-
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…
-
speed up the data refresh within Excel, or use the LSEG Python API to replicate the data pull
We have an Excel file called the Macro Weekly Calendar which is used weekly by our team at Frais Capital. The file pulls live data directly through Refinitiv Workspace Lite via the Excel add-in. The file contains four types of live data: Economic indicators for Australia, United States and China — including macro data such…
-
The client is seeking guidance on how to download end‑of‑day pricing data for portfolios of Nairobi
The client is seeking guidance on how to download end‑of‑day pricing data for portfolios of Nairobi Securities Exchange (NSE) stocks and bonds from LSEG for analytical purposes. While they are currently able to retrieve this data using Excel, they would like assistance with executing the same process programmatically using…
-
Chain Contribution
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
-
RTGET for SRAM26
Hi - what is the field for 'Contract Month'? =rtGet("IDN","SRAM26","CONTACT MONTH")
-
Why while running the macro, it seems like something is preventing the RDP.HistoricalPricing formula
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…
-
How can I use an excel macro to refresh Refinitiv/(DSGRID) formulas detect completion
Hi there, I am working on creating a process that relies on data returned via DSGRID formulas. I am trying to build a macro that I can run using a python script that refreshes the formulas and returns/confirms when the data has actually been retrieved. Looking at other posts, I've been able to find that the below line will…
-
Can I use VBA code in Excel to do this?
Initially client was asking for How can I preserve the values while "erasing" the formula in Cell BB7 in DataStream? So I have provided the below steps: To preserve the values while removing the formula, use the "Save as Values" feature: 1. Open your file (ensure data is updated) 2. Right-click on cell BB7 (or select the…
-
Is there a data field or a formula that retrieves Fiscal Year convention like FY2026 in Excel?
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…
-
How can I modify the VBA code to ensure that the RDP.HistoricalPricing formula always retrieves data
"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…
-
What's the python code for adinterp?
=AdInterp(C1,A1:A2,B1:B2,"IM:LOG") Whereas B1&B2 Yield (internal database)
-
Update excel files
I'm using Excel with Workspace and Datastream. I have many files that I want to update via the excel addin. I want to write a code (VBA or Python) to open these files and "click" "Refresh Worksheet" button, wait for the update, and then save and close the excel files. Could you assist me with a short code snippet that…
-
How to get buy, hold ,sell for a particular ticker by analysts. Ill be using the API.
How to get buy, hold ,sell for a particular ticker by analysts. Ill be using the API. I tried through excel: =@RDP .Data("VOD.L","TR.BrkRecLabel","CH=Fd RH=IN;brokername;analystname",B2)
