Why while running the macro, it seems like something is preventing the RDP.HistoricalPricing formula

Carl_Cruz

I am trying to fetch historical price data via the formula =@RDP.HistoricalPricing() during the execution of a VBA macro. While running the macro it seems like something is preventing the RDP.HistoricalPricing-formula from displaying the data. During the process the macro is supposed to loop through a handfull of RICs to perform a calculation based on each instruments price history. But the formula only starts displaying an output after the macro is finished. I have tried to work around this problem by adding specific code to allow the macro only to perform the next step after the formula has delivered an output - which is necessary to perform the calculations based on the historical price data - but even then no formula output appears during the macro's execution

Is there any workaround/option to force the appearance of the output during the execution of a macro or is it blocked on purpose?

Jirapongse

@Carl_Cruz

Thank you for reaching out to us.

If it is about the =@RDP.HistoricalPricing Excel function and Workspace Excel macro, please contact the Workspace Excel support team directly via #LSEG Support to verify what the problem is.

I am not sure if the WorkspaceRefreshWorksheet or WorkspaceRefreshAll macro can help. For more information, please refer to the following discussions.

• Refreshing a Specific Worksheet on Workspace VBA
• the sample code for "WorkspaceRefreshAll" on WS Excel

Otherwise, the LSEG COM Library for Workspace may be a better fit for this use case.