-
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?
-
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.
-
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…
-
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. //…
-
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…
-
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!
-
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!
-
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…
-
Matching ISIN codes with emissions data and accounting data
Dear all, Note: I am very new to using Refinitv so bear with me if these questions are very basic. I am currently working with a sample of ISIN codes that I retrieved from Screener in Excel earlier. This was my code: =@TR("SCREEN(U(IN(Equity(active or inactive,public,primary))/*UNV:Public*/),…
-
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…
-
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?
-
ISIN code for Credit Default Swaps
Hi, I need to find the ISIN codes for credit default swaps in Datastream such as: GOLDMAN SACHS GROUP SNR CR14 5Y $ Can you help me? Best, Jeroen
-
Get data from RIC given parameters (case: ISIN from delisted RICs)
Hi, I want to get the ISIN from a list of delisted RICS (not all but the majority). From the help desk I got this answer, to get delisted information. =@TR($B$2,"TR.ISIN","SDate=2021-03-31 EDate=2021-03-31 CH=Fd",$C$2) Is it possible to prompt it via Python? How to handle the fact that for each RIC, I have a specific SDate…
-
How do I convert bond CUSIP to ISIN?
Hi, I have a list of bond 8-digit CUSIP that I would like to acquire a historical rating for. But using CODECR, it seems that I need 12-digit ISIN. Is there a clever way to convert CUSIP to a list of ISIN? Thank you in advance.
-
Can't use ISIN to retreive datapoints
I'm currently building a program in Pycharm and want to use the Eikon API to retreive 2 fields: CF_Last and TR.priceclose (SDate=-1M). However, when i give up ISIN codes as instrument names, i get an error, while RICs do seem to work. Is there any way to do this based on ISIN? import tkinter as tk from tkinter import…
-
Hello I am using Datastream on excel. I have a list of ISINs and need to generate certain variables.
Hello I am using Datastream on excel. I have a list of ISINs and need to generate certain variables. however, the report shows the name of the companies and not the ISINs. I would like to replace the company names with the original ISINs in my sample
-
Going from Old ISIN to new ISIN
Hello, I am using the EIKON Data API through Python. I have a large list of ISIN, with some ISIN being outdated or delisted. Since I need the newest ISIN to pull data on stock price etc., it is important to match outdated ISINs to their most recent value. I so far used the following approach: 1) parse all ISINs in my list…
-
Eikon bond identifier query retrieves unrelated bond ISIN
I have a list of ISINs but the problem is that some of them are 'Corresponding 144A ISIN' or 'Corresponding Regulation S ISIN', of the same bond. I am trying to find these duplicates and group them using eikon python API. The problem is that sometimes the API returns seemingly unrelated bond identifiers. For example,…
-
ISIN returns no best match in GetSymbology or get_data. Records found manually
I am having trouble matching some ISIN codes to their respective company information (attached the list). I tried the get_symbology() and get_data() methods without luck. However, when I look for each ISIN manually on the RefinitivWorkspace Search Bar, there is information on the company, with a given RIC and all. I wanted…
-
Get RIC or ISIN from company name
Using EIKON with Excel, i want to retrieve either RICs or ideally ISINs for a large number of companies. Now, what I could do is using the "build formula" tool to get the codes manually by typing in the companies' name and selecting the right one from the search suggestions, usually the top hit. I would like to automate…
-
Mapping from Bond to Equity ticker
Is there a way to map from a given corporate bond identifier to its issuer parent equity ticker? Really struggling to find any thing that works here. If I have a Bond ISIN how can I from that get to its Issuer/Parent as I then I want to screen on its company financials. Thank You!
-
How can I find ISIN codes on Refinitiv Workspace?
I need ISIN codes and I am using Refinitiv Workspace. How can I find them?
-
Bond Obligor
Hello, I just saw this message on my Workspace. I was wondering if this was already implemented in the RDP API to use it with ISIN Bonds and find its ISIN Obligor?
-
Charts via DSWS or any other API?
Dear all, I have received the following question from a customer: "We have used a url to retrieve this type of graphs like the following example: https://refini.tv/3NyvoSK This sample url is retrieved from Refinitv Eikon, where we use this in the AS IS situation for a few hundred fixed isin codes. But we need to make this…
-
RIC Search tool API
https://developers.refinitiv.com/en/tools-catalog/ric-search 网站能不能用API提取RIC? 如果可以是否有具体方法可以参考,特别感谢!
-
In CompositeExtractionRequest TRADEDATE is null for ISIN
Hallo All, I have below CompositeExtractionRequest extraction request where when requested for ISIN some values return with TRADE date and also values for rest of the field but some without any TRADE date and rest of the field also return nulls without ISIN. It returns values ony with Ric and Contributor Code. What is the…
-
Warrant data on ISIN via Eikon Data API
Dear all, I'm too much of a noob when it comes to Python so I would need your help in the following client query. Client is trying to use ISIN for Warrants traded at Frankfurt Stock Exchange like (DE000PF2SQR3 or DE000UH5CN61) to extract CF_BID, CF_ASK etc without needing to pick out RICs everytime. My "code" to first…
-
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.
-
Identifier conversion to RIC
Hello, I am trying to get the RIC of a list of banks I got through S&P Capital IQ. For each bank, I have their name, their primary industry, and sometimes their SNL, CIQ, CUSIP, ISIN and LEI identifiers. I converted the ISIN codes to RIC by using the code: ek.get_symbology( symbol = ISIN , from_symbol_type = "ISIN",…
-
How to filter ISIN by Instrument Type Code
Hello I'm trying to get data using TermsAndConditionsExtractionRequest. As it shown in the tutorial, there are several steps of getting data. Such as request token, load json request etc. I'm interested in the step, where I need to append instruments to the array and post request to DSS REST server. Here is my JSON request…
-
Price Subscription via ISIN and/or MIC
Hi Refinitiv Team, See below code segment used via WebSocket API to retrieve prices. Please advise how we can use ISIN / MIC codes to subscribe to pricing, as well as any way to retrieve a look up table with the relevant symbol / ISIN / MIC / RIC code. SENT on Session1: { "ID": 2, "Key": { "Name": "IBM.N", "Service":…
-
How can I match multiple ISIN codes to company names in Excel using the Refinitiv Eikon Datastream t
Hello, I have a dataset with roughly 20.000 strategic alliances that occurred from 2011 until 2020, retrieved from the SDC platinum database. I want to measure the impact of these strategic alliances on firm financial performance and therefore I need to connect the company names to a measurable company identifier, such as…
-
How to construct Bond's 10 year Yield Series through Python API
Hi, I want to construct a 10 year worth of data yield timeseries of a number of cash bonds (say 10 year US Gov Bond for sake of example). I have the ISINs in a spreadsheet and have been able to map them with RICs in Datascope Select. Is there a Python API I could use to import such RICs and build my timeseries? Or even…
-
How to extract a current Bond's current Bid Yield through its ISIN through python?
I have a bond which has the following ISIN: XS0316008399. I've been able to extract its bid and ask price but I'm struggling to extract its Bid Yield. I thought it might happen because of lack of data, but this datapoint is available in Thomson Reuters. Also, I've checked the Data Item Browser and used the correct labels,…
-
ISIN code and Currency
Hi, I need find instruments trading currency. I'm using ISIN codes and universe is equities, ETFs and bonds. I have tested CF_CURR, Ccy etc and still <NA>. What should I try next? Thx. Juha
-
how to get all related classes in the fund family from a given isin fund class ?
Hi all, i was just wondering using RDP Funds API how to get all isin for various classes of a given fund and potentially also filter the primary class or a class with some attributes. for instance if i start with fund with ISIN LU0302447452, how could i get the equivalent that in Eikon is shown in fund family showing the…