-
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.
-
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?
-
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…
-
Retrieval of Equity Repurchases and Equity Issuance Data
Hi everyone, I am trying to find the Net Equity Issuance for stocks in the SNP 500, however, when I look into the Data Item Browser, I see neither the Net Equity Issuance datatype nor the Equity Repurchase and Equity Issuance data. This is a necessary datapoint that I require, so is there any other way I can retrieve this…
-
Downloading Historical Equities data
Hi, I have a fairly heavy task and the LSEG help desk recommended that I put this question here in the dev community. My team and I need to search and download data on equities (outstanding shares, price, dividend yield, etc.) traded on exchanges in 15-20 countries stemming back to the 1970's-present. My gut tells me that…
-
Number of Reuters News, over a period, for US listed stocks - Distribution by stock
I would like to know how many Reuters News in English language we received between July13-20, for US listed stocks only. And then I'd like to know the distribution of stocks the news are related to. This is with RDP News - Wealth package Equity & Markets News, for North America region.
-
How to Efficiently Retrieve TR.PrimaryInstrument for Delisted Equities?
Hello everyone, I'm currently working on a project where I retrieve RICs and PrimaryRICs for a set of ordinary shares from various global markets using the Refinitiv Research API (EQUITY_QUOTES) through codebook. Then I use the PrimaryRICs to gather fundamental data for these companies. However, I've encountered a problem…
-
Industry Median fields not working
Fields related to the median industry (found in Codecreator) are giving me error 414. Is it something related to these fields or what is the reason? Any alternative would be appreciated. from refinitiv.data.content import fundamental_and_reference fields = [ 'TR.MedianIncAvailToComExclExordItemsMargPct',…
