-
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…
-
ISIN to WKN (Wertpapier)?
Hello, if I have a list of ISIN numbers in Excel, is it possible to get them as WKN (securities identification number in Germany)? Thank you very much!
-
All RICS for an ISIN or CUSIP
When a company is listed on several markets, it has different RICs but a single ISIN or CUSIP. Is there a way to obtain ALL the RICs associated with an ISIN or CUSIP?
-
Unique stock identifier if company changes ISIN over time
Hello, I have a question about identifying the same issue over time from a list of ISIN codes using the Eikon Python API. As you may know, ISIN codes can change due to mergers and other corporate events. In commonly used datasets by other providers like Compustat (or CRSP) in the US, there is a unique ID code that tracks a…
-
From Fund Company to Lei
I am trying to retrieve LEI codes of issuing company from ISIN codes of open end funds. The code works decently but there is a problem that should be addressed. There are companies for which there exists LEI code in Refinitiv but the code cannot retrieve it. In particular one should focus on the part: fund_company = 'AXA…
