-
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…
-
How to get NEWS for Sugar
How to get NEWS for Sugar
-
LSEG API Access for Ipreo Wire Text
Hi Team, Is there a way to programmatically retrieve the full Ipreo wire text using an LSEG API? For example, I would like to access the wire content for PIPR.N, North America NEWS2.0 and understand whether there is an API endpoint or supported method that allows extraction of the complete wire text and related metadata.
-
Clarification on Consolidated (Composite) RIC Support for APAC Exchanges
Hello LSEG Team, We are currently evaluating market coverage for a number of APAC exchanges and would like to understand whether consolidated (composite) RIC subscriptions are available for these markets, similar to the consolidated symbols available for certain US markets. As part of our investigation, we have been using…
-
API Error
当我使用python获取数据时，下列问题出现，请问如何解决: refinitiv.data._errors.RDError: Error code -1 | [WinError 10054] 远程主机强迫关闭了一个现有的连接。
-
Data usage Limit on Workspace
Senario: Client is inquiring how usage limit is calculated Client is a Workspace user who is looking for the worst 10 days performance of 1000 instruments in last 20 years. Would the usage would count as all data points 365 days x 20 yrs x 1000 instrumetns or just the data points on end result 10 days x 1000 instruments?…
-
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…
-
How to get TWAP data using python API.Time weighted average price
How to get TWAP data using python API. Time weighted average price Sample code AAPL.OQ
-
Get list of RICs trading on a stock exchange segment in a specific time window
Hello, I'm trying to find a list of all RICs trading on a particular stock exchange segment within a specific time window. For example, the London Stock Exchange has the following segments: the Main Market and the Alternative Investment Market (AIM). I'm trying to download a list of RICs that were listed on the AIM at any…
-
Is it possible to retrieve FSCREEN including the added columns data in API?
I need to retrieve the following ETF attributes: Management Approach (Actively Managed or Passively Managed) Index Replication Strategy It was confirmed that there are currently no dedicated data fields or API fields available for these attributes. However, the information is available within the Fund Screener (FSCREEN)…
-
How to get the contents on the PDF for News Story?
Some of news stories are linked to the PDF files start with "https://newsfile.refinitiv.com/getnewsfile/" or " cpurl://views.cp./newsfile/getnewsfile/" without any body. e.g. storyId = 'urn:newsml:reuters.com:20260811:nASX8TmPfj:1' The client is asking how to retrieve the PDF file or how to get the contents n the PDF with…
-
How to Aggregate Universe Returns When Calculating Factor Returns
To calculate factor returns using TOPIX as the universe, I attempted to retrieve the stock prices of the index constituents. However, the volume of data is too large and I am hitting the daily data retrieval limit. I would appreciate any suggestions on a better approach. I am currently downloading the data using the…
-
API for Historical Intraday VWAP
Hi Team. Good day! Kindly confirm if we have a code we can use on Workspace to pull up the Historical Intraday VWAP data for AAPL.OQ We are using the code below to pull up the historical end of day VWAP data. import refinitiv.data as rd rd.open_session() df = rd.get_history( universe=["AAPL.OQ"], fields=["TR.TSVWAP"],…
-
hi how can I, using eikon python api, get the 2 years percentile for implied volatility of SXE Index
hi how can I, using eikon python api, get the 2 years percentile for implied volatility of SXE Index please ? and the 2 years percentile for realized volatility ? thanks
-
CodeBook not working
Hi, I am not able to open CodeBook as it crashes after trying to load (Spawn failed - the latest attempt to start your server failed). Login works normally and I have tried clearing cache, restarting. Relaunching does not help either. If someone could help witht the issue, thanks :)
-
Adjusted close prices
Client wants to get to get dividend adjusted close prices sample RIC IXJ Python code snips below for reference. What should I use in the PRICE_FIELD? PRICE_FIELD = "TRDPRC_1" def fetch_prices(rics: list, interval: str) -> pd.DataFrame: """Retrieve price history for a list of RICs.""" raw = ld.get_history( universe = rics,…
-
Developr support report a rules exception
Hi I hope you are well. I had a developer from production support informing me they saw the following error message in their logs. State: Closed / Suspect / Internal error from sender / '*Subscription terminated: A rules exception occurred', Status code: 28, Status Text: *Subscription terminated: A rules exception…
-
how can I pull in python the historical holding of an etf? for example the holding of XLK.P as of 31
how can I pull in python the historical holding of an etf? for example the holding of XLK.P as of 31-12-2019
-
Clarification on Partial Page Update Highlighting in Workspace vs Eikon
Hi LSEG Support, We would like to confirm the expected visual behaviour for page-based updates in LSEG Workspace. From the LSEG documentation, we understand that page rows can be updated either as: Full update — the whole row/field is sent. Partial field update — only the changed characters are sent using an intra-field…
-
Provider_Interactive not working on RHEL8 platform
Hi Team, We are using RFA C++ version 8.2.5 to consume market data. In the API package built the Provider Interactive but it's not starting and connection is down, giving below errors: Could you please help us with this?
