How to scrape bonds and trading data from Public

The Public bond screener sits at public.com/bonds/screener and lists hundreds of corporate bonds with live prices, yields, coupon rates, maturity dates, and credit ratings all on one page. Getting that data into a spreadsheet manually means copying row by row. This walkthrough shows how to extract it in minutes using the Minexa.ai Chrome extension, no code required.

What data the Public screener exposes

Each row on the screener carries a consistent set of fields. The coupon field shows the bond's fixed annual interest rate as issued. The yield field reflects the current market return based on the live price, so comparing the two immediately tells you whether a bond is trading at a premium or discount. The price field captures the current dollar price per bond. The maturity field gives the redemption date, which is essential for duration analysis. The rating field classifies each bond as investment grade or speculative grade. The trade_type field indicates whether the bond is directly tradeable. The issuer field surfaces whether fractional trading is available for that bond. Finally, the bond_link field provides a relative URL to the individual bond detail page, which can be used for downstream enrichment.

Watch the full tutorial

The video below covers the complete extraction from opening the extension to exporting the final dataset.

https://www.youtube.com/watch?v=aWpczEgyaAg

If you prefer to follow along step by step, the annotated walkthrough continues below.

Step-by-step extraction walkthrough

Start by opening the Minexa.ai home page and installing the Chrome extension if you have not done so already.

Navigate to the Public bond screener at public.com/bonds/screener and let the page fully load before opening the extension.

Click the Minexa.ai extension icon in your browser toolbar. The popup appears with an 'I'm on the right page' button. Click it to confirm the target page.

Minexa automatically detects pagination on the screener. You will see a list of paginated URLs it has identified. Click Continue to proceed.

The next screen validates the pagination and gives you the option to scrape the list page, linked detail pages, or both. For this extraction, selecting the list is sufficient to capture all screener fields.

Choose your scraping mode. Simple scraping works well for the Public screener since the bond list renders without requiring advanced interaction.

Hover over the bond listing container on the page. The full data block highlights in blue. Click to select it as your extraction target.

Minexa creates the scraper and automatically identifies all data points within the container. You will see the full list of detected columns including coupon, yield, price, maturity, and more.

Click through to the code samples screen, then hit 'Complete Configuration' to save the scraper and create the job.

Sample extracted data

Here is a sample of what Minexa returns from the Public screener:

[
  {
    "company_symbol": "NVDA",
    "coupon": "3.70%",
    "yield": "5.50%",
    "price": "$72.50",
    "maturity": "04/01/2060",
    "rating": "Investment grade",
    "trade_type": "Trade",
    "issuer": "",
    "type": "Corporate"
  },
  {
    "company_symbol": "AAPL",
    "coupon": "4.10%",
    "yield": "5.61%",
    "price": "$76.75",
    "maturity": "08/08/2062",
    "rating": "Investment grade",
    "trade_type": "Trade",
    "issuer": "Fractional",
    "type": "Corporate"
  }
]

The issuer field being empty versus showing 'Fractional' is a useful filter when building a dataset focused on accessible bond positions. The gap between coupon and yield on the NVDA bond above (3.70% coupon vs 5.50% yield) reflects the discount at which it is currently trading.

Running and exporting the job

From the job summary screen you can schedule recurring runs to track how bond prices and yields shift over time. Once the job runs, the results appear in a structured table.

Export the dataset directly to Excel, Google Sheets, or JSON from the results screen. The same scraper can be reused on filtered screener URLs, for example sorting by yield or filtering by rating, without any reconfiguration.

The Minexa.ai Chrome extension is available at the Chrome Web Store. Install it, open the Public screener, and your first structured bond dataset is a few clicks away.