VBA Code with Bloomberg

[rki1966]

I have an excel spreadsheet that has a bloomberg blph function. The fuction returns a volume for a period. I can get the bloomberg query to work but the macro has a loop for each security. The symbol will change during the loop but the bloomberg query will not update the data.

I have put in a wait, but it still does not help. The symbol will change every 5 seconds but the query will not update. After each update I want to copy the average volume to another page.

Oh one more thing each symbol has diffenet time periods.

 

[Wolfshead]

Hi
I had the same problem. The running of a macro appeared to interrupt the calculation of the BLP function. Also I believe a wait suspends all activity anyway, so no process would continue. However I went into Bloomberg help and found that you could call directly on the Bloomberg API. Also in help were a series of downloadable examples which I have adapted to run the code I wanted. I would recommend that you have a look at them - I found that they worked brilliantly.
To find the help:
at a Bloomberg machine type API and press enter (GO)
select "A complete guide to Bloomberg data in Excel"
select WAPI API programming guide.
Hope this helps
Wolfshead