Welcome to the LSEG Developer Community
I am currently working on an automation use case where we need to update several Workspace Excel files using Python. The key requirement is to keep the TR formulas intact while refreshing their values. Simply calling the LSEG Data API and replacing the values in the cells would remove the existing formulas, which we want…
Application.Run "WorkspaceRefreshSelection", True, 12000, Worksheets("ETF Database").Range("Z1") I just want the right VBA code or what is wrong with my code
Hello Team, Can you please help me in understanding why does this excel behave this way? The client is reporting that a historical formula is updating unexpectedly when it should not. Specifically: When invalid (nonexistent) RICs are included in the formula range: The historical formula initially behaves correctly, but…
On Refinitiv Workspace I can access .BATY0 and .BAUBIL historical data through to 1998 and 1997 respectively. However on Excel I cannot pull any data for Price Close. How can I get this data in Excel?
Is Workspace impacted by depreciation of VBScript? https://techcommunity.microsoft.com/blog/windows-itpro-blog/vbscript-deprecation-timelines-and-next-steps/4148301
Hello, how can I create a chain using an RtContributeChain or RDP.PublishChain formula that publishes to BR_LINK fields (not LONGLINK or LINK)? Thank you, Juergen Burkart
Hi - what is the field for 'Contract Month'? =rtGet("IDN","SRAM26","CONTACT MONTH")
Which fiscal year does the field TR.CompanyFYearEnd return exactly? For example, AAPL’s fiscal year end date is September 30, 2026, which corresponds to the end of its 2026 fiscal year.However, LULU’s fiscal year end date is January 31, 2026, which represents the end of its 2025 fiscal year. My goal now is to determine the…
"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…
Is it possible that the field IV_EXCH (FID 8116) is not appearing, in the RTO SDK or Workspace because we are using an older SDK version that may not support this field?
It looks like you're new here. Sign in or register to get started.
