-
DSS - How can I get a full list of equities in selected stock exchanges?
Hi, I hope this is the right place to raise this question. We have been unable to get a satisfactory answer from Customer Support, so I wanted to reach out here directly. We are trying to retrieve all instruments (both active and inactive) per stock exchange (e.g., XOSL - Oslo Stock Exchange) in DSS (Datascope Select).…
-
In Codebook, for RIC AOFG.DE I get duplicate entries
In Codebook, for RIC AOFG.DE I get duplicate entries, which causes considerable problems in my workflow. For example, the commands import lseg.data as ld ld.open_session() RICs=['AAPL.OQ','AOFG.DE','ADSK.OQ']…
-
LSEG Data Library for Python: incomplete quarterly data (Financials)
I get incomplete quarterly data (Financials - Balance Sheet and Ratios Key Metrics) for many European banks (this is NOT the case for US banks). Take the following code as an example: import lseg.data as ld ld.open_session() workspace_df =…
-
Income Statement, not showing the latest FY data
In Codebook, the commanddf=dl.get_data('KMB.OQ',['TR.TotalRevenue.date','TR.TotalRevenue','TR.GrossProfit','TR.NormalizedEBIT','TR.TotalDebtOutstanding','TR.CashAndSTInvestments'],parameters={'Period':'FY0','Frq':'FY','SDate':0,'EDate':'FY-5','curn':'NATIVE', 'NULL':'Blank', 'Scale':6})does not return Income Statement data…
-
Unable to establish OMMStreamConnection while calling ld.get_data
I’m getting an error while fetching Qatar Stock Exchange data using the LSEG Python SDK. import lseg.data as ld session = ld.open_session( config_name='config.json') df = ld.get_data( universe=['QNBK.QA'], fields=['TRDPRC_1']) Error: lseg.data._errors.LDError: Cannot prepare connection OMMStreamConnection name :…
-
I'm trying to query volume for datastream_id=887742 it works if I only query 2025, but fails if I'm
I'm trying to query volume for datastream_id=887742 it works if I only query 2025, but fails if I'm querying 2011-2025 I'm using datastream with the following code: ds.get_data(tickers='887742', fields=['X(VP)'], kind=1, start='2011-01-01', end='2025-12-22', freq='D')
-
Differences between workspace and refinitiv.data
Hello Support Team, I'm retrieving quarterly fundamental data for XOM.N using the dl.get_data() function, and I've noticed a discrepancy in the data quality between the API output and Refinitiv Workspace. Specifically, for the field TR.F.CrudeOilProdPerDayAvgTot, my Python output contains numerical values (or zeros) for…
-
Extracting IBES analyst level detailed forecasts using python on single year and longer horizons
Dear LSEG Team, I want to pull the IBES analyst-level, detailed forecasts from the workspace using Python. I am using the following formula in Excel: =@RDP .Data("MSFT.O;AAPL.O", "TR.EPSEstValue.fperiod;TR.EPSEstValue.analystname;TR.EPSEstValue.analystcode;TR.EPSEstValue.date;TR.EPSEstValue","Period=FY1990:FY2024 RH=IN…
-
Total return for a stock
Dear all, for RDP (not Eikon), e.g. https://api.refinitiv.com/data/historical-pricing/v1/views/interday-summaries/VOD.L, do I have any possibility to get a total return timeseries? It is possible for S&P or Bloomberg, is it also possible here?
-
Why have TR.EV.currency and TR.F.EV.currency stopped working again?
The fields TR.EV.currency and TR.F.EV.currency have stopped working again (this has happened in the past as well).For example, the Python commanddf=dl.get_data(['GOOGL.OQ','AAPL.OQ','LVMH.PA','RKT.L','MELI.OQ'],…
-
Please confirm if this request is possible in Eikon/WS API
Could you please help me with modifying the Python code so that we can pass multiple RICs at once and retrieve data for all of them in a single function execution? We would like to avoid looping through each RIC individually, so any guidance on how to handle multiple RICs in one call would be appreciated. import…
-
Retrieving Stock Split Data using the Eikon Data API (get_data)
I am using the Eikon Data API (Python) to retrieve various time series data (prices, volume, etc.) using the get_data function. Did anyone already successfully obtain explicit information in stock splits (effective date, ratio) using that function? if yes, which fieldnames were used?
-
RIC Spec
Hi there, Is there any RIC specification available apart from the one linked below? https://myaccount.lseg.com/en/faqs/2022/06/000212013 I'm also unclear about the meaning of the caret symbol (^) followed by a code in a RIC. For example: GIWWU.OQ^L22 Could you please clarify what this notation represents? Thanks.
-
How to Grab Bid & Ask at Certain times using Excel add on
Hi, I've been trying to make a formula to try and grab the Bid and Ask price at certain times using the Excel add on for Refinitiv. I've tried to use the =RHistory formula to do this using preset data to the left of formula as seen in the example below.…
-
how to get all the contracts based on underlying Ric including expired?
Hi Devportal team, good morning. Requesting for your assistance. trying to get all the contracts based on underlying ric. but the result is missing contracts which have expired. need to get all the contracts [{"View": "EquityQuotes","Top": 10,"Filter": "( SearchAllCategoryv2 eq 'Options' and ((UnderlyingQuoteRIC eq…
