excel - Update Bloomberg API static data -

-

i want copy , paste data 1 sheet sheet. original data bloomberg api function. found bloomberg data cell updates after macro finishes running. tried build private function let static data update before copy it. here code:

private sub procesdata()  application.run  call application.ontime(now + timevalue("00:00:01"), "processdata")  end sub   sub macro3()  dim integer = 1  until > 2     sheets("sheet1").activate      cells(1, 3).value = cells(i, 1)      = + 1      call application.ontime(now + timevalue("00:00:01"), "processdata")      range("c4:e181").select      selection.copy      sheets("sheet2").select     range("a1").select     lmaxrows = cells(rows.count, "a").end(xlup).row     range("a" & lmaxrows + 1).select     selection.pastespecial paste:=xlpastevalues, operation:=xlnone, skipblanks _         :=false, transpose:=false  loop  end sub

ah, bloomberg api... many issue.

so, when bloomberg request using function call, cell call site receives call , refreshes data.

the problem is, w.r.t. automation, data can come in parts , have wait till completes before continuing process data.

so, there 3 approaches solution.

  1. last time looked, 1 bloomberg recommends. have routine refreshes call cell formula. this has timer , recursively invokes itself until data has been retrieved. trick know when data has been retrieved correctly. data area checked errors hasn't been completed yet.
  2. the other solution invoke call using application.run build formula in code , invoke vba. allows not deal functions such in worksheet. same thing 1.
  3. you can set reference bloomberg api , use com request. cleaner approach , can easier integrate code creating bloomberg data call api.

i suggest, if possible going option 3. although little more effort, te code becomes cleaner. options 1. , 2. can tricky debug when workbooks become more complex in terms of structure etc.

if search bloomberg (the ever tremendous old 'f1 f1' service should able point in right direction. impressive system ever done in opinion!) bloomberg have examples demonstrate methods highlighted above.

so, issue @ hand , answer question :) restructure code function call calcuation (which invoke requests bloomberg). enter recursive function calls until there no errors in data. after copy data.

hope helps.


Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more