-
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…
-
What is wrong with my Symbol conversion code?
Hello Team please check the following code. The output that I want is USA country code specific but it is showing Exchanges from Thailand and Vienna. Also my asset class are code for funds, equities, certificates and bonds but Commodities futures also show in my output. Here is the code: from lseg.data.content import…
-
Reconstructing total return from scratch
I'm looking at a number of delisted stocks that do not have proper total return series. For example, if you look at BCAP.L^F20, the price return (using TR.PriceClose) and the total return (using TR.TotalReturn) are identical. That can't be right because BCAP.L^F20 has dividends (using TR.DivAdjustedGross). Since the data…
-
Platform Access Denied for ['TR.FUNDEXDIVIDENDDATE', 'TR.FUNDPAYDATE']
Platform Access Denied for ['TR.FUNDEXDIVIDENDDATE', 'TR.FUNDPAYDATE'] I am doing an rdp.get_data call with the Python API, after authenticating with a Platform Session. And I see the following issue: The access to field(s) denied. Requested universes: ['EUNH.DE', 'IBCN.DE', 'IEF.O', 'TLT.O', 'VGLT.O', 'BND.O', 'VGIT.O',…
-
Gross Profit & Gross Margin % (Non-GAAP) for equities
is the Non-GAAP information is available on RDP API. Gross Profit & Gross Margin % (Non-GAAP) for equities? or is it only found in LKD?
-
Requesting US equity imbalance type/side via Workspace API-- numeric data for string fields
I'm porting some tasks from the Eikon C# .NET APIs to the LSEG Data Library API (implementing in Python). For some of this data we subscribe to the US imbalance feed RICs (e.g. IBM.NOI, AAPL.ITC). I'm subscribing to, among other fields, IMB_TYPE, IMB_ACT_TP, and IMB_SIDE). These fields, in the Eikon Quote app and the…
-
Data for Delisting companies
Hi everybody! I am currently engaged in a project that involves analyzing companies in the United States that have been delisted or are on the verge of delisting. The objective is to compute the "delisting return," which necessitates understanding the specific reasons behind each company's delisting. To identify these…
