Stock Shelf-Registration Database for Financing Research

Use a shelf-registration database as a dated ledger of financing capacity, then keep effectiveness, takedown evidence, and completed issuance as separate research events.

Alphanume's Shelf Registrations dataset tracks S-3 and F-3 base filings, amendments, and automatic WKSI shelves. Each row carries filing identity, shelf type, registered securities, capacity when stated, resale status, effectiveness fields, linked takedown counts, issuer size, source URL, and last update time.

That makes the database useful for financing research because it dates when an issuer opened a legal path to sell securities. The filing creates capacity. It does not show that the issuer immediately sold the full amount, and a later takedown count is linkage evidence rather than a complete dollar-usage ledger.

Read the database as a ledger

Automatic or indeterminate shelves can have null capacity_amount by design. Resale rows describe securities registered for selling holders, so their capacity is not new primary financing capacity. A database screen should preserve both populations and state which one its ranking uses.

Retrieve a complete date window

The endpoint is GET /v1/capital/shelf-registrations. It supports filing-date filters, ticker, CIK, form, shelf type, and updated_since. Cursor pagination requires the date and accession values returned together by the previous page.

import os
import requests

url = "https://api.alphanume.com/v1/capital/shelf-registrations"
headers = {"X-API-Key": os.environ["ALPHANUME_API_KEY"]}
params = {"date_gte": "2026-01-01", "date_lte": "2026-06-30"}
rows = []

while True:
    response = requests.get(url, headers=headers, params=params, timeout=30)
    response.raise_for_status()
    payload = response.json()
    rows.extend(payload["data"])
    if not payload.get("has_more"):
        break
    params["cursor_date"] = payload["next_cursor"]["date"]
    params["cursor_accession"] = payload["next_cursor"]["accession_number"]

Save every page before filtering and verify accession uniqueness. Results are ordered by filing date descending and accession number ascending. The Shelf Registrations API reference defines the exact fields and null behavior.

Define active as a research rule

The API does not return a universal active flag. A researcher can build a candidate status using filing type, effectiveness, expiry_estimate, and an as-of date, then review replacements or transition rules in the source filings. The expiry value is generally estimated as three years from effectiveness and can differ from the legal result.

Store the as-of date and rule version beside this derived status. Avoid overwriting the original row because last_updated can change when effectiveness or takedown linkage refreshes. An incremental monitor can query updated_since and append each observed version.

Rank capacity without inventing values

For a primary-capacity watchlist, filter shelf_type=new and is_resale=0, then calculate capacity_amount / market_cap_at_filing only when both fields are present. Keep null-capacity, null-market-cap, automatic, resale, amendment, and refused rows in an exclusions report.

That ratio ranks authorized capacity relative to issuer size. It does not estimate the amount that will be issued. The securities list can include common stock, preferred stock, debt, warrants, or combinations, and the economic dilution from a later transaction depends on terms absent from the base ratio.

Treat takedowns as evidence

• Count scope. takedown_count records linked 424B prospectuses, not a complete tally of capital raised.
• Refresh horizon. Shelves filed in the trailing 400 days receive takedown refreshes; older counts can be frozen.
• Zero values. A zero count means no linked event under the serving process, not proof that nothing was issued.
• Amendments. Amendment rows stay separate and should not be merged without a documented file-number rule.
• Refusals. Rows marked refused are real filings whose extracted fields can be null.

A completed offering study needs prospectus terms, pricing evidence, or another verified issuance source. It also needs point-in-time prices and corporate-action handling before making return claims. Shelf data alone identifies financing optionality and lifecycle evidence.

Build one financing audit

Pull one completed six-month window and export separate tables for new primary shelves, resale shelves, automatic shelves, amendments, and refused rows. Verify every top capacity ratio against its filing URL, then rerun with updated_since after a later cutoff and append changes rather than replacing them.

Free access provides the trailing 20 trading sessions after a one-trading-session delay. Use it to validate the ledger mechanics. A historical financing study needs deeper coverage and a frozen as-of policy. The shelf takedown workflow is useful next reading once the base database reproduces.