Pausing BDP function in VBA

[JulianT]

Does anyone know how one would go about pausing Bloomberg's BDP function in excel's VBA developer? Ideally I would like to fix the live data for the duration of the execution of my macro, and restart the stream as soon as the macro has finished its final iteration.
Thanks!

 

[Lyosha]

Turn worksheet formula calculation from automatic to manual. That way they'll only update when you hit f9.

 

[GoalSeeker]

the deal with bloomberg excel vba macros is that they will not refresh/give data until your macro finishes to run n then u either refresh manually or weite a second macro for that.. i had a similar issue where data was gng into 20 tabs in excel n using a second macro to refresh made more sense

 

[JulianT]

My macro turns calculations into manual mode at the start to control when I run the calculations for efficiency purposes, but it calls the Calculate command every iteration in a big loop. Would that refresh the data?

 

[Tsotne]

My macro turns calculations into manual mode at the start to control when I run the calculations for efficiency purposes, but it calls the Calculate command every iteration in a big loop. Would that refresh the data?

No that wouldn't. You should write a separate code refreshing the data manually everytime before the the code enters into the new loop. I had a data and an open source macro doing almost the same thing: processing the data with its own logic in each loop after getting the newest data from web and deleting the first one in the vector - looks like moving average when newest data is added and the oldest one is deleted every single minute. I had to write a separate code on top of the loop logic to take into account the new modification of the data. You have to do the same if I got your problem correctly.