-
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',…
-
Data quality check on equity
Hi, I am downloading the equity data and use they for analysis. It is required by regulation that the data quality test must be performed. So I wonder if Refinitiv performs the data quality test on the equities data (returns, volume, market-cap....), such as completeness, accuracy, consistency, etc, see below the table…
-
How can I download the equity data of a constituent with country residence or other country infor...
...mation via Eikon? Hi, I was downloading the constituent equity data using Python with Eikon as ek.get_data(instruments=constituent, fields=required_fields), with certain fields contain country information of the constituent: required_fields = ['TR.ExchangeCountry', 'TR.CoRPrimaryCountry', 'TR.CoRPrimaryCountryCode'] I…
-
Retrieve the Parent equity RIC with bond ISIN: Incomplete lists
Hi all, I am trying to retrieve the parent euqity RIC using the bond ISIN. Following the previous tasks and questions proposed like Retrieval of Parent equity close prices via Bond RIC - Forum | Refinitiv Developer Community and Retrieval of Equity Instrument Data via Bond Instrument Identifier - Forum | Refinitiv…
-
Number of analysts for an individual estimate of broker forecasts
Let's pick VOD.L. I would like to know how many analysts are behind each historical forecast of one year ahead (i.e. FY1) for (say) Revenue, EBITDA, EPS, Net Debt, etc... Put another way, I would like to have a sense how thin/thick is the forecast
-
Pct of Shares held domestically
Dear all, I am using Eikon/Datastream API on Webservice. I tried extracting aggregated percentage of shares held by domestic investors on a daily basis. To do so I have tried using Shares Held with Country Perm ID as well as Tr.PctCountry but it does not seem to load. The Country Perm ID List also does not load. Can…
-
Is the reference to FY1 as per the company year end or is the data standardised to a consistent y...
Is the reference to FY1 as per the company year end or is the data standardised to a consistent year end (e.g. a calendar year end company and June year end company in the same sector)?
-
What is mnemoic to access the stock buybacks from the database ?
I'm trying to pull the stock buybacks for different stock index universes.
-
does anybody know how to download adjusted and not adjusted price for equity (with and without di...
...vidends) I'd like to analyze historical prices of some equities (e.g. Apple) in terms of dividends - any idea if Eikon has such different time series? i'd like to pull data in python using API
-
Get constituents for equity index at historic moment in time
Hi, How do I get the constituents for equity index at historic moment in time. For example, you can request the constituents of MNEM RLISVIT with: ds.get_data("LRLISVIT|L", fields=["MNEM"], kind=0) Instrument Datatype Value 0 929467 MNEM I:RN But how can you do the same request but then at a historic time points to…