-
Excel Runtime 438 error
Hi , We are facing issue when a user tries to refresh the data he is getting the below runtime error 438 error on his excel .
-
#NAME Error on Sharedpoint - How to make this work using Workspace or LSEG plugins?
Client's query: I am using 3rd party API's now through a Microsoft Logic AppThe python tutorial was helpful, but a large learning curve. My other subscription is working well. The client is using Workspace. One example to share is data I am presenting through a MS Sharepoint page that won't update. A direct link to my…
-
Retrieving insider transactions (Form 4) for a list of ~2,600 companies in a single request
I am a Master's student in Finance writing a dissertation on insider trading activity and acquisition premiums in M&A. My econometric analysis will be conducted in Stata, so what I ultimately need is the data in a flat file format (CSV or Excel) that I can import. 1. Insider transactions for a large list of companies I can…
-
Daily usage limits
Hi What are the daily usage limits for: Excel add-in calls Python API calls Workspace AI (WSAI) calls Thanks
-
websocket api equivalent of Excel Macro function (DfAddPeriod) ?
We wonder how we can get data through websocket connection for the lseg refinitiv function which is “DfAddPeriod”, for example: =@DfAddPeriod("TUR";0;"1D").We can get the data from the excel, however we also want to get the date data of stated function on websocket connection in scope of one of our automation project. Can…
-
Does the LSEG Workspace Excel Add-in provide a way to refresh TR formulas programmatically via Pytho
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") Wh
Application.Run "WorkspaceRefreshSelection", True, 12000, Worksheets("ETF Database").Range("Z1") I just want the right VBA code or what is wrong with my code
-
Python code verification
Client generated the attached python code but it does not seem to be working. Kindly seek your help to check and advise. Thank you
-
DS Tickers to capture information in IRPR app on Workspace
My goal here is to create a refreshable excel file using Datastream tickers and formula which captures the market-implied policy rate path. The sheet should show me the implied policy rate at end of current calendar year and next calendar year whenever I refresh it for a bunch of countries. For example, as in can seen in…
-
Workspace Excel Add In: How to get the number of holdings in an ETF?
I am trying to get the exact number of holdings of an ETF. I have tried "TR.FundHoldingName.holdingname" but this gives me a list of all the ETF Holdings. We only need the number not the list.
-
Excel Add in Behavior
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…
-
No history on .BAUBIL and .BATY0 on Excel (Workspace Lite)
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 there any chance of getting this data for specific years, such as 2022, 2023, and so on? I have a
Client query: is there any chance of getting this data for specific years, such as 2022, 2023, and so on? I have access to the API via Python, and I do a lot of my work that way, as it’s easier for certain tasks. Do you know if it might be possible to do it from Python? And resolution provided was: I have reached out to…
-
Can Excel add-in call can be imbedded into application code that mounts to ADS for realtime data
Client inquiring if Excel add-in call can be imbedded into application code that mounts to ADS for realtime data access. This would not include Workspace to be installed.
-
Excel Formula to RDL
The client wants to know if it is possible to retrieve the data being retrieved by this excel formula =@RDP.HistoricalPricing("PLN3YOIS=TTKL","BID;ASK","START:30-Apr-2026 END:30-Apr-2026 INTERVAL:P1D SOURCE:RFV",,"CH:Fd RH:Timestamp") This formula pulls the BID and ASK price of PLN3YOIS=TTKL for April 30, 2026 Moreover, if…