Back to feed
Dev.to
Dev.to
8/2/2026
Getting clean SEC financials without fighting XBRL

Getting clean SEC financials without fighting XBRL

Short summary

Pulling clean financials from SEC EDGAR is painful due to inconsistent XBRL tags, dimensional context, and unit scaling. The author ran S&P 500 filings through a normalization pipeline (Filingrail) and packaged results as a flat CSV with one row per company-statement-period. A free 100-row sample is available, and the post includes pandas code for computing margins and ROE.

  • •XBRL filings have inconsistent tags, context dimensions, and unit scales across filers
  • •Normalized CSV: one row per (company, statement_type, period) with USD figures and filing URLs
  • •Free 100-row sample plus pandas snippets for margin and ROE calculations

Generated with AI, which can make mistakes.

#ai-tools#open-source
Read full article at Dev.to

Is this a good recommendation for you?

Comments

Failed to load comments. Please try again.

Explore more

The SEC gives away every company's financials. Parsing them was the hard part
Dev.to
How to Get Clean SEC EDGAR Filing Data (Without Getting Rate-Limited)
Dev.to
How to Build a Point-in-Time Fundamentals Database from SEC EDGAR (and When Not To)
Dev.to
The SEC has a free financial data API that nobody talks about
Dev.to