-
Mapping of a company and related bonds in refinitiv data api
Hi Team, Could you provide the details of where we can find a mapping of a company's ISIN to all its bonds' ISINs in the Refinitiv data API? For example, we would like to have a mapping of Mercedes-Benz (DE007100000) with all its related 36 bonds (see screenshot). Thank you.
-
How to pull Outstanding Bonds of an Equity RIC categorized by Currency via Workspace CODEBK?
I would like to pull in the following data into CodeBook. Under the Debt and Credit tab, you can display the amount of bonds outstanding for a certain company (ex. APPL) sliced by currency. What is the name of this data in the data item browser, so that I can pull it in CodeBook?
-
Workspace API python:Retrieve EUR-denominated French government bonds
Our client is currently working on the government bond curve for the European region. However, using the method below, He is unable to retrieve EUR-denominated French government bonds (while major countries such as Germany and Belgium are returned correctly). If you happen to know a way to obtain them, I would greatly…
-
Time out error when downloading bonds from the govsrch
Dear community, I am trying to download bonds information data from the govsrch using the following code: # Define the start and end dates start_date = '2025-01-01' end_date = '2025-06-30' # Generate a list of dates between the start and end dates date_range = pd.date_range(start=start_date, end=end_date) # Convert to a…
-
How to retrieve Historical Data for Bid-Ask Yield and Bid-Ask Spread forBonds
I want to download the Bid-Ask Yield spread. But I am not sure which field I need to use. Below is my python code to download the bid, ask,mid yields. I hope you can help me to find an appropriate field for bid-ask spread. Currently using below fields = ['B_YLD_1', 'A_YLD_1', 'MID_YLD_1', 'YLDTOMAT'] fields_length =…
-
Hi can I ask how do i get the mid price and YTM for bonds via the python API for historical pricing
how do i get the mid price and YTM for bonds via the python API for historical pricing
-
Extract bond time series information from LSEG python package by ISIN
Hi All, I need to extract the following bond information using LSEG python package: macaulay duration, outstanding amount, market value bond rating bond maturity date bond coupon rate I try to use the field in my attach file, but it doesn't work. Could you advise me the proper field name to extract such information? I…
-
Hi, I downloaded the field "RCSCoveredBondGenealogy" and it is populated by codes, such as "A:3X\\A:
Sample instrument: DE000A1MLRP0 I downloaded the field "RCSCoveredBondGenealogy" and it is populated by codes, such as "A:3X\\A:NW". How do I interpret those field? Is there a glossary or a guide to decrypt them? this is my query: response = search.Definition(view = search.Views.GOV_CORP_INSTRUMENTS,top = 10000,filter =…
-
Retrieving Bond Rating Data Based on Tickers
I'm trying to retrieve the most recent bond ratings from Moody's, S&P, and Fitch from a list of tickers. I convert the list of tickers to both ISIN and RICs with this code that seems to work: I tried throwing the whole list of codes as either RICa rics = codes['RIC'].tolist() or ISIN as isin = codes['IssueISIN'].tolist()…
-
Resolve the identifier as a CORP
Hi all, I'm working with Refinitiv DataScope Select (DSS) and encountering a discrepancy between results returned via the DSS UI and those returned via the REST API. What is working: When I upload a list of ISINs in the DSS UI and run an immediate extraction with Terms & Conditions content fields (which are bond-specific),…
-
How to get historical price data of GOV BOND(EXPIRED/MATURED) like JP10504214C9 more efficiently
It seems to work below code but is there more efficiently codes like historical_function in workspace API? ### import refinitiv.data as rd import refinitiv.data.content.ipa.financial_contracts as rdf from refinitiv.data.content.ipa.financial_contracts import bond rd.open_session() import pandas as pd from datetime import…
-
Jupyter notebook on Codebook
Hi Dev Team, I would like to receive an updated Jupyter notebook on Codebook for bonds whereby I can extract the historical price and yield with the associate events. Thank you for your assistance.
-
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…
-
Mapping Advanced Search options
Hello everyone/Eikon support, Would it be possible to have the mapping filter options names:python identifier for all the options available in the Advanced Search app ? Thanks a lot in advance
-
Convert Bonds Issued Amounts in EUR using exchange rate at Issue Date
Hi all, I would like to API request to retrieve a list of bonds, with the outstanding amounts converted to EUR based on the exchange rate as of the issue date. Currently, the GOVSRCH function in Workspace performs conversions using the exchange rate as of the previous close. Can you help me? Best Giacomo
