-
Bond data via API in Python
Hello, I have a download restriction of 10'000 lines and am doing data analysis in Python. So that I do not have to down all of this, I would like to use an API and loop it to download all the data. I am struggling with this. Below a screenshot of what I would like to download, and here the query: rd.discovery.search( view…
-
Problem with permission in Pricing API
Hi team, When I started using the bond pricing API with the request below, I was advised to add "RRPS" to the end of every RIC that did not already have it at the end. However, in some cases, adding "RRPS" is causing a permission denial, while removing it allows me to retrieve the price successfully. Attached is an…
-
FINRA bonds data
Hi all, I am attempting to retrieve bond data from the TRACE provider, but I’ve encountered issues with the current code. Some fields return empty cells, even though the data exists when checked manually. For instance, volume data is one such example. Additionally, the code is not outputting dates. Best
-
Python ld.get_data() Unable to collect data for field 'TR.ASKPRICE.DATE' and some specific idenfier
I have a list of over 800 bond ISIN and I am using ld.get_data() in a loop to download historical pricing data in chunks (see attached txt file). I need a solution to handle cases where no data is available, so that no errors are returned. First isin chunk: ['ES0200002022', 'IT0005057770', 'US00289WAA99', 'USE00020AA01',…
-
sample API query for amount outstanding under Bond Schedules template.
Hi Team, Please provide sample API query for amount outstanding under Bond Schedules template. Amount Outstanding info is available via Bond Schedules Template for all GovCorp assets.We reviewed few Egypt Bills [e.g. EGT998042P17/ EGT99801AO17] and amount outstanding available in Bond Schedules.
-
US Municipal bonds - LSEG products
Can you please advise the products LSEG offers used in the US Municipal world, i need tools to be able to price municipal bonds current and historical prices using benchmarks, trade and quote prices, and comparables data. Right now I have an Eikon kiosk, which has the municipal bonds calculator and comparables data access,…
-
retrieve bonds based on codes
Hello all, I am trying to retrieve all bonds for a list of issuers and i found in this forum a way of doing, however when i implemented it for some stocks i get an error based on the stocks name (see image below) what leads to an incomplete list of bonds. My question is if there is any alternative to retrieve bonds based…
-
search.Definition - bonds
hello, are you aware of list of possible values for this field - 'select'? search.Definition object response = search.Definition( view=search.Views.FIXED_INCOME_INSTRUMENTS, select="ISIN,RIC,IssueDate,Currency,FaceIssuedTotal,CouponRate,CouponType,MaturityDate", filter=filter_str, top=10000, ).get_data() I am looking for…
-
Eurozone bonds issued from 2016
Hi! I have two questions. The sales rep showed us a Python environment embedded in workspace that looked very user friendly to download data. Can you help me to find this embedded Python environment within workspace. I also need to download all bond issues in the eurozone from 2016 to 2023 (I send you a screenshot of how…
-
Do we have a list of all fields that can be placed under "SELECT" Parameter?
Do we have a list of all fields that can be placed under "SELECT" Parameter?
-
API query for Amortization schedule
Please provide API query for below Amortization Frequency CodeAmortization Frequency Code DescriptionAmortization TypeAmortization Type DescriptionAmortization Schedule Sample ISIN XS0180245515 XS0166025824 XS1171476739
-
How to pull whole list of active bonds for an issuer in python
In python, I need to download the full list of bonds that are currently active on the italian BTP curve. For each bond, I would like this information: -Cusip -ISIN -Dirty Price -Coupon -Last coupon date -Next coupon date -Issue date -Maturity -Description -yield to maturity For something else, I'm currently using the…
-
Datascope API PriceHistory extraction request does not fetch Amount Outstanding
Using Extraction Request template #DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest", over https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes, the value for field "Amount Outstanding Unscaled" always seems to be None. Is this data (daily time series of amount…
-
Get "related instruments" using the refintiv.data API
Hi all, I'm looking into using the refintiv.data python API to calculate benchmarks for bonds. Right now the process is very manual and not scalable, I'm searching the bond in the workspace and looking at the "Related Instruments" tab, then creating my query and looking at the results. (see screenshot) I would like to use…
-
Corporate Bonds: Retrieving Dates of Coupons paid this year, and other bond data
Hi everyone, I have 2 questions regarding the retrieval of Corporate Bond data with the Refinitiv Data Library in Python. I am currently trying to retrieve the coupon rate, next payment date, and coupon payment frequency, with the following formulae: 'TR.CouponRate','TR.FiNextPayDate','TR.FiCouponFrequency' I checked that…
