Friday, April 9, 2021 at 7:54 AM #190837sabbir ahmedParticipant
I have a good interest for 2 data points, here are they
1. Net profit of a company.
2. Number of employees of a company.
Here, I found “Net Profit” in 10-K filings of a company, I use this API-endpoint to retrieve data
But when I’m trying for different company’s CIK like Apple Inc. (CIK = 0000320193), API response breaks. And I can’t find any API to retrieve second data point. Is there any good way to do this? Please help.
Sunday, April 25, 2021 at 3:22 PM #191209David TaurielloKeymaster
Hi Sabbir – apologies for not responding sooner. The SEC requirement allows companies to create extensions for concepts that are not defined by the base US GAAP Taxonomy. So, it’s possible a company does not report Net Profits because the definition in the taxonomy does not match any facts they report.
One of our Power User Members – Peter Guldberg – put together a Google Sheet template for the Balance Sheet that ‘maps’ taxonomy concepts to a single line in a report – see https://docs.google.com/spreadsheets/d/16f6CRVvfyyVEhpfm3lJCXODtRUUMhMi1I7XMR324qU0/edit#gid=1819560642&range=A1 for the map. You’ll need to make a copy of this Google Sheet in your Google Account to see how it works.
Applying this mapping technique to your use case for the data (standardization) would help you collect Net Profit for companies under a single term.
- You must be logged in to reply to this topic.
Documentation & Discussion
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- Get started with Google Sheets OR
- Get started with Microsoft Excel OR
- Get access to as-filed data from us for other tools or your own app
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
Using the XBRL API with the Public Filings Database
Unless otherwise agreed to in writing, any and all use of the XBRL API to authenticate and retrieve data from the XBRL US Database of Public Filings implies user consent and agreement with the XBRL US API Agreement. If you are unable to agree to these terms, do not use the XBRL API.
To use the XBRL API outside of Google Sheets, your account needs to be provisioned for OAuth2 access.