-
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…
-
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…
-
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',…
-
How can I download the equity data of a constituent with country residence or other country informat
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 wonder, besides of…
-
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…
-
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…
-
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 year
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 divid
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…
-
Retrieving data in Datastream Excel-plugin for all European companies with continuous availability o
Hello, I am just starting to work with Datastream and are hence a beginner. I logged into Thomson Reuters Eikon - Microsoft Excel and are connected. Now I am looking for a way to receive all European companies (equities), for which there is a continuous combined-ESG score available (datatype “TRESGCS”) for the last 15…
-
Cannot access CBA.AX minute data
Hi team, tmp = ek.get_timeseries(["MSFT.O"], fields = 'CLOSE', start_date="2021-10-28 09:00:00", end_date="2021-10-28 10:00:00", interval='minute') # This code work for me tmp2 = ek.get_timeseries(["CBA.AX"], fields = 'CLOSE', start_date="2021-10-28 09:00:00", end_date="2021-10-28 09:05:00", interval='minute') # CBA.AX…
-
How to enter a "Custom Eq" order via REDI API
Hi, I want to trade the attached trade via the REDI API. It's a diagonal options trade with an equity leg. On the UI it becomes a "Custom Eq" trade but that's not a valid entry for COMPLEXORDER.Strategy. Is it possible to structure this kind of order via the API? Thanks
-
Is it possible to get the underyling stock for an ADR?
Hi, I use the refinitiv dataplatform API (rdp) to get a list of all assets (stocks & ADRs) on all exchanges for a specific company, using the command "rdp.search". However, I am not able to find a way to display the RIC of the underlying stock for an ADR. Is it possible to do that? Thank you very much in advance for your…
-
Extracting List of Delisted Equities using Screener, RDP. or Eikon API
Hello, I am looking for a way to pull a list of delisted equities using either Screener, the Eikon API, or RDP. The output can be in the form of a data structure in python or an Excel file. Thanks,
-
Method to Pull Delist Date for Delisted Equities
Hello, I am looking for a method to extract the delist date for delisted equities. This would be similar to the 'DELIST_DAT' datafield available in the Data Item Browser, but as a field that would return values either in Data Platform or with the Eikon API (eikon.get_data) when called (i.e. in Screener, Python, etc) Thanks,
-
How to get price & fundamental data for members of constituent lists into R?
hi Refinitiv-team, I want to download price and fundamental data for all single stocks in a specific country. My aim is to cover all historically available stocks (so that there is no survivorship bias in the data). For example for Australia I want to use the lists WSCOPEAU, FAUS, DEADAU (cp. Schmidt et al (2019)*), but I…
-
How to get the free float shares outstanding on country level
I am looking for ownership data on free float shares/percentage basis on a specific day. Unfortunately I only get the Percentages of Shares Out held, but they not consider all free float shares. I tried many different ways, e.g.: =TR("AMZN.O";TR.SharesFreeFloat;"InvestorCountryPermId=100319 Sdate=2020-12-31)…
-
Retrieval of Parent equity close prices via Bond RIC
Hi, I am using the python interface to the API to retrieve corporate bond data, I have a list of their RICs. Now, I need data about close prices of their issuers equity. The question is: is there a best practice for that? For instance, for the RIC "DEA162A2=" the ultimate parent id is not listed, while the immediate parent…
-
Equities Data - S&P/Nasdaq/DAX filtered by financial/accounting numbers possible to create?
Hey Developers, i would like to create a CSV within Eikon by equities and their accounting/financial numbers f.e Price/Book, Total Accruals/Total Assets, Debt to Equity etc. Till now i just could find singular equities by which i i could see the wished for data. But not as a total. What im thinking of is a tabular form…
-
Ownership Fields returning different number of fields - Error
I am currently trying to obtain Fund Ownership information via Python, and while the data is downloaded fine, the issue is with the number of hits being returned. As an example ticker we can take XOM, and you can see that when you run the following two queries separately you get a different number of hits:…
-
Equity fund ownership
I am trying to grab fund ownership data for a specific equity through the Eikon API, here is what the data looks like on the front end: I am using the following python code: import eikon as ek ek.set_app_key('mykey') df, e =ek.get_data('MSFT.O',['TR.FundAdjShrsHeld.InvestorPermID', 'TR.FundPortfolioName',…
-
How can I call a full list of companies listed in one country (e.g., Australia) in a specific year (
I am using EIKON RnA with Datastream API add-on. I need a full list of companies listed in a specific country (e.g., Australia) in a specific year (e.g., 2005 and 2006). I heard that EIKON cannot do this, but it is possible with Datastream, but I do not know how to. Thank you for the help in advance.
-
Is it possible to extract prices for stocks on any given hour of day?
I want to extract historical prices for stocks on hourly basis e.g. at `15H`, `16H` etc. Is there a way to extract this info using Eikon API? If yes than how?
-
LEVEL 2 EQUITY DATA - WHERE IS TRADE TYPE?
Hi Im subscribing to LEVEL 2 MBO equity pricing from Oslo exchange, (example RIC AKA.NO). How can I find the trade/order type in this price stream? Do I need to change my domain to get trade type or is it the case that trade data is delivered in the L1 MARKET_PRICE domain?
-
Eikon API python RES event type
I want to get all the events (for example, revenues or earnings releases) of the symbol LVMH.PA in the last two months, and I know that there should be an event on the 15th October 2020. In Python 3.7 I use: tmp=eik.get_data(['LVMH.PA'], ["TR.EventType", "TR.EventStartDate", "TR.EventEndDate", "TR.EventStartTime",…
-
Turkey single stock prices are wrong for period before 27/07/2020
In Python, ek.get_timeseries() for most Turkish stocks have started to produce wrong historical OPEN/HIGH/LOW/CLOSE values for the period prior to 27/07/2020. Problem started occuring on 19/10/2020. When I check the CHTV for single Turkish stocks on Reuters Eikon App, same problem is seen there as well. It appears that…
-
How to obtain expired equity options daily open interest and close prices via python api/ excel api?
How to obtain expired equity options daily open interest and close prices via python api/ excel api?
-
Obtain both active and inactive stocks on an exchange using Datastream
Hello, I'm trying to obtain both active and inactive/delisted stocks on a few exchanges, let's say the NYSE and Deutsche Börse. The period doesn't matter, I'll take everything and deal with that later. I'm aware that this isn't possible on Eikon, both thanks to this thread and also from using the Screener in the Eikon…
-
Get maximum price of stock within a date range
How can I use Eikon API to extract maximum price of stock over a specfic date range? I am using python to extract the maximum price.
-
How to send Stop Market entry order from Excel VBA to REDI Plus
Hello, I am trying to send a Stop Market entry order from excel VBA to REDI Plus, the code is like below, Dim hOrder As New Order hOrder.Symbol ='SQQQ hOrder.Side = "Buy" hOrder.Quantity = 100 hOrder.Exchange = "GSDE Algo" hOrder.PriceType = "SOR GSDE" hOrder.StopPrice = 26.88 hOrder.TIF = TIF hOrder.Account = AccountID…
-
Filtering companies by major countries of business operations. (E.g. Companies in the UK with major
Is there a way to filter companies by countries where they conduct major business operations? E.g. filtering a list of French companies for having major operations in the United States. Thanks
-
RFA Trade exchange code for European market
Use RFA java to subscribe to VOD.L My application currently look for FID RDN_EXCHD2,GV5_TEXT,IRG_EXID,IRGXID to figure out at which exchange a trade has occurred. Here I provide two trade update received. Message 1: In the following trade update message, none of the above FIDs are available. By looking at the data, it…
-
"Access Denied" for Nasdaq Rics even though permissioned on Eikon
Hi everyone, a client get's error code: 251658243 for Nasdaq RICs randomly where he can't download data for Nasdaq RICs via Eikon Data API anymore even though the same RIC works perfectly fine in Eikon (example: GB00BKZZ4R47.ST). This happens randomly to the customer and in no particular order.. he get's following error…
-
How to interpret LSTSALCOND in SGX?
May I know what does different values mean for SGX LSTSALCOND? Thanks a lot!
-
How can I get the full name for a stock Symbol through the API?
What API call should I make to get the full name for a RIC symbol? For example, from an input of "AC", I would like to get a string of "Air Canada" in return. I tried "Quotes -> RetrieveItem_3", and "Search2 -> SearchSingleItem_1", but neither of them seem to work. Please let me know what call I should make, as well as its…
-
MBO L2 data : can I truncate keys?
Im looking at MBO L2 data and I can see that the "action" keys can be printed, and look like: '3339 6563*******************************39ec' '3330*************************30' '1****************************1' (where * are spaces and pad key to 50 chars wide) however, when I look at the keys in Refinitiv app OMMViewer, you…