VBA: Waiting for Bloomberg BDP calls to finish

vba excel bloomberg
Martin picture Martin · Nov 28, 2010 · Viewed 10.5k times · Source

I have a script that imports some external data into the worksheet, which in turn affects some =BDP(...) formulas. Optimally, I'd like to do some checks on the BDP results immidiately after copying the data.

The Bloomberg Excel Add-in updates asynchronously - how do I wait for the results and then resume the script? It seems that the results are only imported after the VBA script finishes, no matter how long it runs.

Thanks in advance Martin

Answer

Chris Spicer picture Chris Spicer · Nov 29, 2010

I built something similar using BDH. I had to release control so that the Bloomberg add-in can go and collect the data, then resume my code. I was able to do this using Application.OnTime.

For example, if you have a 'CheckForData' function that affects the =BDP calls, and another function called 'ProcessData' that checks the results, make an aynchronous call to to 'ProcessData' within 'CheckForData', e.g.

Sub CheckForData
  ' Your code here
  Application.OnTime Now + TimeValue("00:00:05"), "ProcessData"
End Sub

Then within 'ProcessData' perform your checks.

Related questions

How to refresh/load RTD Bloomberg function (BDH) in excel in vba

I would like to know if there's a way in VBA code forcing the bloomberg functions (In spreadsheet) to update its value( Any BDH functions) Targeting Developers have faced similar issue/ have Bloomberg terminal What have I tried-- Application.RTD.…

Read More
Bloomberg data doesn't populate until Excel VBA macro finishes

I'm running a macro in a blank Excel 2007 workbook on a PC with a Bloomberg license. The macro inserts Bloomberg functions into sheet1 that pull yield curve data. Some additional functions' results are dependent on the first functions finishing and …

Read More
Using the Bloomberg API in vba

I am trying to load data with the bloomberg API using this function- ' Make certain you have a Reference to C:\blp\API\ActiveX\blpdatax.dll Sub FindBloombergData() On Error GoTo Handler: Dim oBlp As BLP_DATA_CTRLLib.BlpData …

Read More