Overview
Get Bonds by Company or ISIN returns bond terms and the latest market data in one markdown table. Ask for a company’s bonds with itsrp_entity_id, or for specific bonds of any type (corporate, sovereign or municipal) by ISIN.
Each bond comes with its coupon, maturity date, currency, amount outstanding, seniority and status, and, unless you turn prices off, its latest price, yield and spread over the government benchmark.
When to Use
- Debt and maturity profile: when does a company’s debt mature, and how much is outstanding in each currency (“when does Ford’s debt mature?”)
- Bond pricing: what a company’s bonds are trading at and yielding (“what are Apple’s bonds yielding?”)
- ISIN lookup: terms and latest price of specific bonds, including sovereign and municipal bonds
- Credit context: combine with
bigdata_company_tearsheetfor a fuller picture of a company’s finances and debt
How It Works
There are two ways to ask. Use one or the other, never both:- By company (
rp_entity_id): get the company’s ID fromfind_securities, then callbigdata_bonds_tearsheetwith it. The tool returns all the bonds of the company’s mapped issuers, active ones by default, up to 50 per page. - By ISIN (
isins): callbigdata_bonds_tearsheetwith up to 50 ISINs. The tool returns exactly those bonds, whatever their type or status. An ISIN with no bond comes back inunknown_isins.
Parameters
Important Notes
- Give
rp_entity_idorisins, not both. A call with neither, or with both, is refused with a message saying what to change. cursorandstatusapply to a company request only. Looking up ISINs returns every bond asked for, whatever its status.- A malformed ISIN is refused before any lookup, with a message naming it.
Data Returned
The response is a markdown table, one row per bond, under a heading that names the company for a company request:
A cell with no data shows
–. The same bonds are also returned as structured data, with further terms per bond: description, issue date, issue amount, interest payment frequency, and secured, guaranteed and callable status.
Pagination
A company with more bonds thanlimit is answered page by page. When pagination.has_cursor is true, more bonds match: call again with the same rp_entity_id and status, and cursor set to pagination.cursor. The markdown also says so at the end of the table.
Examples
A company’s bonds
bigdata_bonds_tearsheet with {"rp_entity_id": "D8442A", "limit": 50} (Apple Inc), first rows of the first page:
Sovereign bonds by ISIN
bigdata_bonds_tearsheet with {"isins": ["US912810RH32", "DE0001102580", "GB00BMGR2809"]}:
A municipal bond by ISIN
bigdata_bonds_tearsheet with {"isins": ["US64972JS667"]}:
Practical Tips
Reading a Full Maturity Profile
Each page lists active bonds first, then by maturity date, earliest first, with bonds that have no maturity date last. The order holds within a page only, so a later page can start again from earlier maturities. For a company’s full maturity profile, read every page before summarizing.Missing Prices
Not every bond has a recent price. When Price, Yield and Spread are–, the data has no price for that bond: report it as unpriced rather than estimating one. Municipal bonds and recently issued bonds are the most likely to come back unpriced.