-
Pricing a bond with a modified yield curve
Hello, I have downloaded the yield curve of a bond benchmark using the following import refinitiv.data.eikon as ek curve = ek.get_data('0#ITXZ=R',['MATUR_DATE','PRIMACT_1']) Then I modify the yield curve by applying a parallel shift of 25bp via: curve['Shifted_Rate'] = curve['PRIMACT_1ì] + 0.25 Now I want to reprice a bond…
-
API script to get coupon payment date on business day basis.
Please advise how to get coupon payment date on business day basis (which is next day if coupon date falls on holiday) by API. Example of the expected result is attached. https://us.v-cdn.net/6038239/uploads/93CBCKEI7AH8/cash-flow-bond-structure-realtime-sample.xlsx I checked the site Documentation | Devportal but not able…
-
Getting Bond Future Convexity, T&C template in DSS REST API
Hello, is it possible to get historical Bond Future Convexity field, using Terms and Conditions template in DSS REST API? Or if not, are there any alternatives? Client has access to DSS and TH. I know that history for that field is limited within GUI - I'm looking for history range since years ago until today.
-
Convert bond RICs/ISIN symbols to Parent RIC (RIC of the Issuer) with Excel?
Using Green Bond Guide in Sustainability, I got a list of Bonds with bond RICs, bond ISIN and Issuers Name. I am trying to download multiple companies' data (ROA%, Total Asset and Total debt percentage to total capital) through Screener. However, the the Porfolio import require Symbols/ Company RICs and PermID beside…
-
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 =…
