I am trying to fetch some historical prices in large blocks of at least 50000 and inserting them directly into SQL with a VBA-Loop. Thanks to this forum I was already able to figure out that a synchronous refresh of the TR-formulas can be done with Application.Run "EikonRefreshWorkbook".
Everything works fine for a small number of 100 RICs. But for larger amounts everything just freezes. Even if I use a timeout interval of like 300000, it still isn't done after 5 minutes.
So I was wondering if there is a more efficient way to do this. Or what are reasonable block sizes and timeout intervals?
TR-formula includes TR Undadj Cloese Price, TR Company, TR Volume and TR.Turnover for one specific date.