-
How to retrieve the RICs using the bond ISINs?
Hello Team, I hope all is well. I'm seeking for your help, (for example) Apple, Microsoft and Tesla have bonds going 10 years and each of these bonds have a specific ISIN, unfortunately the ISIN doesn’t map directly to the company’s RIC but to the bond’s RIC. My goal is to sort of input an ISIN of a bond and return a…
-
Question about getting bid ask of Isincodes by Codebook.
I want to obtain bid ask data by Code book. The code attached below is about getting bid ask from the input data; Isincode. Could you tell me why the code does not work. import pandas as pd import refinitiv.data as rd from refinitiv.data.content import symbol_conversion as sc # ← v1.6 ではこちら 1. セッション開始（Workspace/CodeBook…
-
Does RTO allows to send a SEADOL/ISIN/CUSIP and recieve a RIC?
Does RTO allows to send a SEADOL/ISIN/CUSIP and recieve a RIC?
-
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!
