Waiting for (BB) add-in data to load befor proceding program

[q-tip]

Hi,

I am building a program that at one point uses Bloomberg add-in functions to load data directly in the sheet. Sometimes it takes a few seconds for the data to load, which is problematic, because the rest of the program won't work properly before all the bloomberg data has been downloaded to the sheet. I use range.formula to enter the add-in functions.

I am using both the "=bdp" and "=bdh" functions of bloomberg. The "=bdp" will return "#N/A Requesting Data" until the data has been downloaded, and each "=bdh" covers four columns wich are blank until the data arrives.

I have tried to enter a loop in the program that will check whether blank cells have been filled or whether the "=bdp" cells match the type of the data I am requesting, starting each loop with "Calculate". This does not appear to work. The loop will go on endlessly but I soon as I break the program, the data appears immediately.

If anyone had any good ideas on this, it would be much appreciated!

[Mordred]

Without seeing the code, it seems like you may not have an exit from the loop. Perhaps if you post the code you will get more help.

[q-tip]

I actually figured it out. I just used the application.ontime function and that works.