Interrogate Bloomberg database via VBA code

[mikeymay]

I am using some '=BDP......' formulas to interrogate the Bloomberg database to return ticker data.

When the formulae are used manually, the relevant cells are populate with the queried data but when used via a VBA procedure, the caluclation/interrogation hangs and only updates once the code has fully executed and exited.

As I am looping through multiple tickers, I need to store the data retrieved from each ticker to create my own mini database of the ticker data retrieved so it can be used in a dynamic ticker driven dashboard.

 

[Dan_W]

Hi - forgive me, but what is the question?

If you're looking for thoughts about the delayed updating of queried data, my first (and thus far only) thought is that it sounds like the code you're using is set to manual and not automatic. Whereas when you enter the formula in a worksheet (and the data is populated then-and-there), it is not necessarily the case that the same will be the same with VBA. People usually turn off ScreenUpdating (Application.ScreenUpdating = False) and change the calculation method to manual (Application.Calculation = xlCalculationManual), which has the combined effect of making it look like the system is 'hanging' and is only ever updated at the end of the routine, when these settings are changed back.

Is that something that might have happened in your VBA?