Christoph has attended:
Excel VBA Intro Intermediate course
Bloomberg - Overcome problem when data have not finished loading
When using data from bloomberg (i.e. loading data with a =bdh function in a cell) and data have not finished loading VBA need to be stopped to load the data. Is there a way to refresh the bloomberg request to finish loading the data inside the VBA code? (Without stopping the code running)
RE: Bloomberg - Overcome problem when data have not finished loa
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