Skip to main content

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 its rp_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_tearsheet for 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:
  1. By company (rp_entity_id): get the company’s ID from find_securities, then call bigdata_bonds_tearsheet with it. The tool returns all the bonds of the company’s mapped issuers, active ones by default, up to 50 per page.
  2. By ISIN (isins): call bigdata_bonds_tearsheet with up to 50 ISINs. The tool returns exactly those bonds, whatever their type or status. An ISIN with no bond comes back in unknown_isins.
Sovereign and municipal bonds are reached by ISIN. Asking by company returns a company’s bonds only.

Parameters

Important Notes

  • Give rp_entity_id or isins, not both. A call with neither, or with both, is refused with a message saying what to change.
  • cursor and status apply 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 than limit 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.

When a Spread Is Given

A spread is given only where the bond names a government benchmark: US, German, UK and Canadian government bonds, for bonds issued from 2015 on. Sovereign bonds have no spread, as they are the benchmark.

Coverage by Company

A company request returns the bonds of the issuers mapped to that company. A company that issues debt through entities not mapped to it can show fewer bonds than it has outstanding. Look those bonds up by ISIN.

Combining Currencies

The table reports each bond in its own currency. To total a company’s debt, convert each currency before adding the amounts outstanding.