Bloomberg - Overcome problem when data have not finished loading

Hi Christoph, thanks for your query. You are not alone in trying to address this problem! We can't offer advice about third-party APIs such as the Bloomberg add-in but this link should give you some pointers:

http://stackoverflow.com/questions/8669845/bloomberg-data-doesnt-populate-until-excel-vba-macro-finishes

My first thought was to use DoEvents to return control to the user while the query refreshes, but as you can see this causes problems. The solution will almost certainly involve using one of the Bloomberg API calls outlined in the link.

Hope this helps,

Anthony