Nasdaq-100 Fundamentals

Good fundamental data usually sits behind an expensive terminal. I wanted to see how far I could get with nothing but public sources and careful engineering. The answer turned out to be a long way.

The dashboard pulls every 10-K and 10-Q filed since 2015 straight from SEC EDGAR, the official index constituents from Nasdaq, and monthly prices plus the next earnings date from Yahoo Finance. It normalizes all of it into a clean quarterly and annual series, then presents around seventy metrics per company across nine tabs.

You can pick companies from a sector-grouped sidebar or search by ticker, then compare up to six side by side with consistent colors across every chart. Everything runs in the browser, so it stays fast and works offline once loaded.

The hard part was never the charts. It was making messy XBRL data honest enough to trust.

A nightly Python pipeline moves through clear stages. It pulls the index constituents, downloads raw EDGAR submissions into a SQLite database, normalizes them into calendar-aligned quarters, fetches prices and quotes, then exports one small JSON file per company for the browser to load on demand.

Public data is full of traps, so most of the work went into safeguards. Share counts are never summed or differenced, which kills the impossible negative market caps a naive approach produces. Per-share values use only reported figures so stock splits do not break them. Effective tax rate is computed on a trailing basis so one-time items do not create fake spikes. Values that look extreme but are real are kept as they are rather than quietly clamped.

Quarterly figures are aligned to the calendar quarter of each company's fiscal period end, so businesses with offset fiscal years still line up on the same axis. It is built for a public audience, so it is honest about what it shows.

The hosted version is a snapshot. Figures are current as of the last data export shown in the app. Educational use only, not investment advice.