#Bloomberg api vba update#
#Bloomberg api vba code#
#Bloomberg api vba Pc#

It should an arbitrary task by calling a sub like DoSomething() Public Sub DoSomething() StillToReceive = StillToReceive Or (Not rngStillToReceive Is Nothing)ДЄpplication.OnTime Now + (TimeSerial(0, 0, 1)), CallbackД®rr.Raise -1,, 'BloomCalc: Timed Out. Set rngStillToReceive = ws.UsedRange.Find('*Requesting Data*', LookIn:=xlValues) If TimeValue(Now()) >= WaitStartedAt + TimeValue(TimeOut) Then Public Function BloomCalc(Callback As String) As Boolean

Private Const TimeOut As String = '00:02:00' I gathered some information from around the web and wrote what imho is an improved version in comparison with everything I have found so far: Private WaitStartedAt As Double

#Bloomberg api vba update#

Once you have tried out Mr Excel's solution, perhaps you could update this answer for the benefit of future visitors. Set objBloomberg = New BLP_DATA_CTRLLib.BlpData Transpose(.Transpose(Range('C1:H1').Value)) 'fill our arrays - must be 1 dimension so we transpose from the worksheet

#Bloomberg api vba code#

This code can then be used to populate the cells: Sub Test2()Дim objBloomberg As BLP_DATA_CTRLLib.BlpData Go to Tools | References and add a reference to this library. Using the helpfile information in that area we can build a more robust solution to this using the Bloomberg Data Type Library. On your Bloomberg terminal if you type in WAPI you will find listings of the Bloomberg API and downloadable examples. Within Mr Excel, the chain is: MrExcel Message Board > Question Forums > Excel Questions > Bloomberg links and macros. The Google link will probably exist for the forseeable future. However, I am not sure I understand the question or the answer well enough to summarise it. We are not supposed post answers which are only links in case that link disappears and takes the answer with it. I googled for BloombergUI.RefreshAllStaticData and was immediately taken to this Mr Excel page:

Private Sub Populate_Me() Dim lRow_PM As Integer Public Sub Run_Me() 'Application.DisplayAlerts = False wb is a global-level workbook and ws1 is a global level worksheet. I've tried using a combination of DoEvents and Application.OnTime() to return control to the operating system and to get the program to wait for a long time for the data update, but neither worked. I want these values to appear while the program is still running.

When I stop debugging - fully ending running the program - all the Bberg values that should have populated then appear. Because some of the functions are dependent on string and numeric field results being populated, the program hits a run-time error at that code. ' instead of the results of the query, no matter how slowly I go.

When I step through the program it only displays '#N/A Requesting Data. Some additional functions' results are dependent on the first functions finishing and correctly displaying the Bberg data. The macro inserts Bloomberg functions into sheet1 that pull yield curve data.

#Bloomberg api vba Pc#

I'm running a macro in a blank Excel 2007 workbook on a PC with a Bloomberg license.