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

vba excel bloomberg
Larry picture Larry · Oct 12, 2012 · Viewed 71.8k times · Source

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.RefreshData
Application.RTD.throttleInterval = 0
Application.CalculateFull

The BDH function do not reload themselve.

The only way I can refresh them now is : I click the "Refresh WorkBook" Button on the Ribbon of the BloomBerg add-in.

Since the Bloomberg Add-in is locked in VBE, I cannot find out the necessary code. Am I missing any Bloomberg Reference? Can any Bloomberg expert/user point me in the right direction? Thanks.

Answer

Larry picture Larry · Jan 17, 2013

I did a searching of the keyword "refresh" in the xla by opening it in notepad. Found the following targets: 

RefreshAllWorkbooks
blpmain.xla!RefreshAllStaticData
blpmain.xla!'RefreshWorkbookFundamentalsData
blp.xla!IsBlpRefreshAvailable

I tried them out one by one, the first 2 works by calling: 

Application.run "RefreshAllWorkbooks"
Application.run "RefreshAllStaticData"

But not calling them alone ( I guess it's because I somehow can call protected PUBLIC procedure using Application.run)

RefreshAllWorkbooks

or

RefreshAllStaticData

Thanks for all the help

Related questions

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
Bloomberg and updating formula if holidays give N/A

We use the BDH function to get closing prices at the end of each trading day, and do this for a list of different types of securities and indices at once. Currently every BDH-of-index in the list refers to the …

Read More