Retrieving Market Cap as a concept.local-name item from a report.id

[Jason Mellone]

Assuming I know some report.id, I can retrieve stuff like CommonStockSharesOutstanding using something like:

def fields_from_report_id(report_id, fields):
    return execute_query('fact/search?report.id=' + str(
        report_id) + '&fact.has-dimensions=false&concept.local-name=' + fields + '&fields=concept.local-name.sort(ASC),fact.value,fact.decimals,period.fiscal-year,period.fiscal-period')

execute_query just executes the query using my credentials – you can assume this works.

Now, assuming I want to retrieve Market Cap as a concept.local-name, is this possible?

Right now, I am calc’ing Market Cap using an external vendor for price, but would rather use the xbrl feed directly, if possible

[David Tauriello]

Hi Jason – take a look at EntityPublicFloat – it might be helpful to you.

Here’s a sample of Microsoft’s fact.value history for the concept:

/report/fact/search?entity.id=6930&concept.local-name=EntityPublicFloat&fields=fact.value,report.document-type,report.period-end.sort(DESC),report.restated-index,dts.id

Here’s the definition of the concept across all US GAAP Taxonomies:

/concept/search?dts.id=257581,257584,257585,257586,257587,257588,257589,
257590,292503,322998&concept.local-name=EntityPublicFloat&fields=
dts.id.sort(DESC),concept.namespace,concept.local-name,label.text

[Jason Mellone]

David,

I am experimenting with this a bit.

Using CIK='0000789019' as an example and dts.id=346047, I get the following URL: https://www.sec.gov/Archives/edgar/data/789019/000156459019037549/0001564590-19-037549-index.htm

Which xml file should I look in to find the various fields that I should try to pull via your API?

For MSFT it is easy, but what about a company that reports less robustly:
https://www.sec.gov/Archives/edgar/data/1117171/000121390019024078/0001213900-19-024078-index.htm

Thank you for any input.

• This reply was modified 4 years, 11 months ago by Jason Mellone.

[David Tauriello]

Hi Jason – thanks for writing. In short, all of the files noted as ‘XBRL’ in the Data Files section of the SEC URLs you sent make up the fields you’re pulling via the XBRL API – it depends on which endpoint you’re using. The data for the company is in its XBRL INSTANCE.

Each company filing with the SEC submits its own taxonomy (referencing US GAAP and other standard taxonomies, and including any extensions for the entity) and instance (the data points defined by the taxonomy). The Public Filings Database is structured to conform to the XBRL 2.1 specification.

In 2019, the SEC began requiring companies to submit inline XBRL – the Microsoft URL is an example of this (see the first link in the Document Format Files section of the page). The HTML is a complete filing – if you view the source code for the page, you’ll see XBRL integrated in the HTML (https://xbrl.us/about-inline-xbrl). The inline requirement is being phased in across the next couple of years.

[Jason Mellone]

the way your website is coded makes the overflow of your response hidden by the right panel. Can you update your wrapping logic? It’s a bit challenging to work with. I am using Chrome Version 79.0.3945.88 (Official Build) (64-bit).

[David Tauriello]

this is fixed; you might need to dump your browser cache of temp files. Let me know if you still have an issue.

[Jason Mellone]

David, I searched the following docs:
https://www.sec.gov/Archives/edgar/data/789019/000156459019037549/msft-20190930.xsd
https://www.sec.gov/Archives/edgar/data/789019/000156459019037549/msft-20190930_cal.xml
https://www.sec.gov/Archives/edgar/data/789019/000156459019037549/msft-20190930_def.xml
https://www.sec.gov/Archives/edgar/data/789019/000156459019037549/msft-20190930_lab.xml
https://www.sec.gov/Archives/edgar/data/789019/000156459019037549/msft-20190930_pre.xml
https://www.sec.gov/Archives/edgar/data/789019/000156459019037549/msft-10q_20190930_htm.xml

For “EntityPublicFloat”. I then searched just for “float” (assuming maybe some naming transformation may have been done) but did not find it.

Are you deriving this field? How would I go about understanding where you are ingesting this file from?

[David Tauriello]

Jason – EntityPublicFloat is not required to be reported on a 10-Q (see the concept endpoint in my first reply above).

Structurally, this is a standard US GAAP element in the DEI (Document and Entity Information) taxonomy, imported as <xsd:import schemaLocation="https://xbrl.sec.gov/dei/2019/dei-2019-01-31.xsd" namespace="http://xbrl.sec.gov/dei/2019-01-31"/> by the company’s .xsd file.

If you look at the .xsd for Microsoft, you can see several other base taxonomies imported here – elements in an instance noted as dei:, us-gaap: and others defined in the schema are imported this way. Elements the company has defined that are not in the base taxonomies are listed in the schema file; these extension elements are prepended as msft: (ticker:) in the Microsoft example.

[Jason Mellone]

The point being that next I’d like to find something like BookValue. Yet, when exploring the field I can see, I do not find BookValue.

Eg: Executing a query like:

execute_query(
        'concept/search?dts.id={dts_arg}&fields=concept.local-name.sort(ASC),concept.*,label.*,concept.limit({limit_arg}),concept.offset({offset_arg})'.format(
            dts_arg=dts, limit_arg=limit_item, offset_arg=offset_item))

[David Tauriello]

Is BookValue a term you’ve seen in a specific filing or filings? Asking because its not a term I’m familiar with, in terms of US GAAP.

What happens if you use US GAAP terms like AssetsNet or LiabilitiesAndStockholdersEquity?

[Author]

Posts