"We use a loop in Excel-VBA to retrieve historic data with RDP.HistoricalPricing() for a list of RICs. This process is often unstable as for some RICs we don't get data. The issue is not replicable, sometimes we get all data, sometimes some RICs don't get any data. We tried several ideas from LSEG help page e.g. use command in VBA Application.Run "WorkspaceRefreshWorkbook". This improved the solution, but didn't lead to a 100% stable import process. We attach an excel sheet as example. It has a list of RICs in tab "RICs". In tab Staging you can press button "Import_Refinitiv_Data" and it imports for each RIC 5 historical prices in columns A:D. When no data is retrieved it writes "No result" in columns A and D. Can you please help to make sure that the VBA code always forces the formula RDP.HistoricalPricing to retrieve the data. Further remark: When we press "F9" manually in the excelsheet then it usually works more stable and formula delivers data. So the problem is related to VBA triggering formula update. "
