Get Company Net Income from 10-K Filing

[sabbir ahmed]

Hello Everyone,

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

https://api.xbrl.us/api/v1/fact/search?entity.cik=0001326801&report.is-most-current=true&fields=report.%2A/fact/search?entity.cik=0001326801&concept.local-name=NetIncomeLoss&fact.ultimus=true&period.fiscal-period=Y&fields=entity.name,fact.value,fact.decimals,unit,report.filing-date.sort(DESC),concept.local-name

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.

[David Tauriello]

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.

Sincerely,
David

[Author]

Posts