-
How to import all Global Equity managers into python that have an ISIN that starts with AU?
Hi there, I am trying to import all Global Equity managers into python (Workspace/Eikon API) that have an ISIN that starts with AU. I’ve been using as a guide but some elements are not working. If you could provide some assistance that would be appreciated.,
-
How to find the list with the exchange for which the suffix of a RIC stands for?
I have a list of RICs belonging to the same ISIN. However, I do not know to which exchange each ric belongs to.
-
problem with z spread extraction - code not working anymore
Hello people, I hope you are doing well. I am experimenting some issues with some zSpread extraction with the code i've always used. I am not able to extract the spreads anymore. Please find below my code: import refinitiv.dataplatform.eikon as ek str_date = "2024-12-31" ISIN = "XS0107203381" df_zSpread, err =…
-
Bond issuers income statement data download
Hello everyone, I am trying to download financial information regarding bond issuers, starting from a series of bond ISIN codes. The query I am using is the following: rd.get_data( universe = ISIN_list, fields = [ 'TR.RIC','TR.NACEClassification', "TR.DTSubjectName", "TR.FIIssuerName", 'TR.FiOrgID', "TR.F.TotRevenue",…
-
DSWS API returns invalid data
Hi, When I execute the following via the DSWS API I receive the following data: ds.get_data(tickers = '8857RL', fields = ['DSCD','ENAME','ISIN','RIC','T1C','LEI',] ,kind = 0) When I use the same DSCD in the web portal, the ISIN is correct. When I try to search the web portal for the ISIN returned by the API, I receive no…
-
Get all futures contracts from ticker or isin
Hi all, I'm trying to find the query to get all futures contract info from the underlying isin / ticker. More specifically, i would like to input the isin/ticker of a security and get all the futures contract on that security. The final goal of this would be to get the RIC code of these contracts. Does anyone have an idea…
-
Eikon API - Adding ISIN number of entities in output
Hi, I'm trying to add the ISIN number to my current search but not sure how to do it. Below is my current code which is gathering weekly news headlines from the free text search. Any help would be great thanks.
-
Extract ESG scores based on ISIN codes
I am using Refinitiv Eikon Datastream in Excel. I want to extract the ESG scores of several companies I have collected in a sample, I have the ISIN codes belonging to those companies. How can I insert those ISIN codes in Datastream to extract the ESG scores belonging to those companies?
-
Reliable way to get RIC code from ISIN through any API
Hi all, I need to retrieve some information on various asset of different asset classes (Fx, Indexes, ...) I have ISIN, CUSIP and SEDOL information for each asset, and i can get basically any information, except RIC code. Here is what I tried, to get for exemple the RIC of isin : IE00B4L5Y983, which is an ETF df =…
-
Get RIC code for derivative using the underlying RIC code
Hi, I'm trying to get the RIC code for some futures contract, especially for index futures. The data i have is the Underlying RIC code. I would like to see all futures contract on that index, with as much information possible so that I can find the one I need. I tried using a Definition Search with the DERIVATIVE_QUOTES or…
-
How to use Eikon API to get the bond ric code?
I am using Eikon API to get bond RIC code via ISIN code. I got the correct result for some ISIN codes ( XS2599899064, XS2650765725, XS2657056268), But for several ISIN codes (XS2506532980, SGXZ38592606, XS2507733231, XS2544098127, XS2618052513,SGXZ84200740,XS2649260333), got nothing. Can you give some advice? Thanks. //…
-
retrieve bond ISIN issued by a list of firm RICs
Hi! I have a list of RICs around 700 firms. I am trying to find ISIN of their issued bond for a typical year (for example 2020). How can I use API for this issue? Many thanks!
-
ISIN codes through deal screener
Hi, I am currently using excel add-in to getter data on M&A deals. I am using the deal screener but I am not able to pull the ISIN code for the acquirer and the target. I am currently preparing for another (very scarce) timeslot in the Refinitiv database provided by my university and I would like to know which steps I…
-
REST API error message for ISIN DU00000COCHA reflecting as ISIN DU00000COCH3
Hi, Wanted to check on the below issue where using DSS REST API for ISIN DU00000COCHA, getting the error message reflecting as ISIN DU00000COCH3 not found under Terms and Conditions Report Template. I am using DSS Rest API extraction and Identifier List is having ISIN as DU00000COCHA which is a Dummy ISIN, however in the…
-
ISIN and RIC codes for Rights Issues
I am studying capital increases through subscription rights, and I have obtained data for many of them through Screener. However, I need to find the ISIN code and the RIC associated with those subscription rights and, so far, I have not found any way to obtain it through any API. For example, I put the case of the capital…
