This community helps developers, analysts, and business intelligence professionals connect with and use the XBRL API, Public Filings Database, staff and community-sourced resources and tools more effectively.
Using the XBRL Filed Data extension for Google Sheets or Office 365 Excel is the quickest way to get started understanding how to use the XBRL API and our Public Filings Database. Scroll down for free spreadsheet templates you can customize, as well as other resources for using the XBRL API with programming languages like PHP, Python and R.
Full ESEF or SEC Report with Dimensions Pivot for Excel Office 365 (.zip download) or Google Sheets
Get report-styled facts for a single filing, with underlying queries grouped in columns to the left of the presentation. Includes a pivot table for dimensional data and a footnote list.
FERC Schedule Compare and Report Template for Excel Office 365 (.zip download) or Google Sheets
Get a side-by-side comparison of FERC Schedule data – including dimensions – for multiple companies, a pivot table display of the schedule detail for improved readability, or XBRL US Members can get a full report for a public utility using the cube endpoint for the hypercube of facts and taxonomy details.
Multi-Company Comparison (.zip download)
Compare financial schedules, statements or disclosures for up to 3 companies. This template will let you compare reports among regulators in a single worksheet (SEC and FERC).
Jupyter Notebook – IPython –
Use this web-based interactive Python loop to gather all available data points for a query. Run the script from a local computer and the output can be saved to a .csv file.
Full-text search Jupyter Notebook – IPython – XBRL US Members can use this web-based interactive Python loop to use the document endpoint of the XBRL API to complete a full-text search of SEC filings from 2018 to the present. Run the script from a local computer and the output can be saved to a .csv file.
Engage in an open forum to learn about new functionality and techniques for using XBRL API, get questions answered, and let members preview XBRL Spreadsheets in development and other applications. The list of upcoming and prior meeting replays is at the right-side of this page.
XBRL US Membership improves data access (see below). Sole Practitioners and Organizational Members also enjoy publishing rights and commercial use of data returned from our Database of Public Filings.
Membership TypeRecords per queryRecord offset limit
The national consortium for the business reporting standard
XBRL US is a not-for-profit organization supporting the implementation of digital business reporting standards through the development of taxonomies for use by U.S. public and private sectors, with a goal of interoperability between sectors, and by promoting XBRL adoption through marketplace collaboration.
You must be logged in to post a comment.