PDA

View Full Version : Excel Macro to make Bloomberg refresh Data?



roxnoxsox
08-07-2015, 02:01 AM
I have a large spreadsheet on Excel which I'm trying to automate using a macro. I'm using the BDP function to pick up prices in approx. 3000 cells and then copy and paste this as special values into a new spreadsheet.

The only problem is that when I run the macro, it copies and pastes before the formulas to pick up from Bloomberg have finished running so all I get is a bunch of cells with '#N/A Requesting Data'.

If I do this manually, I have to click 'Refresh Worksheet' under the Bloomberg tab at the top of excel. Is there any way of writing the Refresh worksheet function into my macro so that the formulas will actually calculate ?

mancubus
08-10-2015, 07:58 AM
you can use Application.Wait method perhaps...

or change the codes in Bloomberg, if it is not a password protected add-in.