-
collect all bond issuances for a company based on PermID via Python Refinitiv API
I want to collect all bond issuances (start 2013-1-1 to 2024-12-31) for a company based on PermID via Python Refinitiv API. For instance, PermID '5081184843'
-
FID explanation for JGBs
Take a look at the following RICs JP00170054=RRPS OR JP00180054=RRPS . We used to get the benchmark on the LINKLINK1 FID. The format of the LONGLINK1 getting published has changed and we dont have permissions anymore. What other FIDs can give us the benchmark? Also what do the LONGLINK1 , LONGLINK2 and LONGLINK3 FIDs…
-
WS API How to Retrieve MBS, ABS, and Corporate Bond by Country or Currency
Currently, Our client is looking to obtain data on U.S. MBS (Mortgage-Backed Securities), ABS (Asset-Backed Securities), as well as corporate bonds categorized by country or currency. Until now, he has been using the following method to retrieve government bond data. However, he have not been successful in acquiring MBS…
-
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.
