Execute all formulas before convert to values

[maacmaac]

I'm executing two lines of code to pull data with BDP Formulas from Bloomberg (I have about 95,000 lines of data). The problem which is occuring is the "convert cells to values" line of code occurs before all the formulas have finished pulling in the data from Bloomberg. Is there a way to delay the "convert cells to values" line of code to ensure the data formulas have finished pulling the data first?

Please Login or Register  to view this content.

[AlphaFrog]

I wouldn't think that was possible, but I'm not familiar with the BDP functions.

This may wait until the formulas have completed calculating.

Please Login or Register  to view this content.

[maacmaac]

I tried that but the formulas aren't finishing the calculation process before executing the line to convert the cells to values. Do I have the new line in the correct part of the code?

Please Login or Register  to view this content.

[AlphaFrog]

This will wait 3 seconds. Adjust the time to suit.

Please Login or Register  to view this content.