[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]

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.

[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?

[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).

[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.

[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.

[Anonymous]

I ran the following query in Google Sheets

=showData(“https://api.xbrl.us/api/v1/fact/search?&concept.local-name=NetCashProvidedByUsedInOperatingActivities&period.calendar-period=1Q,1H,3QCUM,Y&period.year=2015,2016,2017,2018,2019&entity.cik=0000915840&fact.ultimus=1&dimensions.count=0&fields=fact.numerical-value,period.year,period.calendar-period,concept.local-name,period.end.sort(ASC)”)

Why only the data for 3QCUM and Y are returned? It looks like the data for 1Q and 1H (except for 2016) are missing.
Thank you very much!

[David Tauriello]

Hi Dulich – please take a look at this post (and the full thread) for some information about calendar period vs. fiscal period. This may help explain why you’re not returning the details you think you should be seeing. Try this query:

https://api.xbrl.us/api/v1/fact/search?concept.local-
name=NetCashProvidedByUsedInOperatingActivities&period.fiscal-
period=1Q,1H,3QCUM,Y&period.year=2015,2016,2017,2018,2019&
entity.cik=0000915840&fact.ultimus=true&fact.has-dimensions=
false&fields=fact.numerical-value,period.year,period.fiscal-period,
concept.local-name,period.end.sort(ASC)

[Steven Rankin]

I have correctly setup my api to retrieve the access token and I can hit the xbrl api.

I am hoping someone can point me in the right direction of how to obtain specific data – what the api endpoint should look like and what ids I need to provide.

I want to get Financial analysis data (Standardized and Reported Financials) for a given company. Is there a specific endpoint where you can provide a company id (or ticker code) and retrieve all the filings financial information, or most recent etc?

The docs here are great: https://xbrlus.github.io/xbrl-api/#/ But they don’t help those like me who are completely new to xbrl.

Example data I hope to retrieve:
– Operating income
– Other income/(expense)
– Net Income
– Earnings Before Interest and Taxes (EBIT)
– Current Assets
– Liabilities and Shareholders’ Equity
etc etc

Is there an API call which provides all these?

Thanks

[David Tauriello]

Hi Steven – thanks for writing. Much of your approach to getting information will depend on what details you need to return.

The /report endpoint can be used to return details about filings for an entity.

/report/search?entity.cik=0000320193&report.document-type=10-K&fields=dts.id,report.id,report.period-end.sort(DESC),report.sec-url

Using dts.id information returned from this query, you could then use the /fact endpoint query to get financial details for the report:

/fact/search?dts.id=348264&fact.has-dimensions=false&concept.is-monetary=true&fact.ultimus=true&report.type=10-K&fields=dts.id,report.id,entity.name,concept.local-name.sort(ASC),concept.is-base,fact.value,period.fiscal-year.sort(DESC),fact.limit(10)

Use concept.local-name to filter the fact results to the reported values you’re looking for and you’re on your way!

I encourage you to look at the XBRL Spreadsheet and others linked at right. You’ll need to install our XBRL API Access add-on to use the template – there are queries you can explore (and modify for your own purposes). We’ve also posted some of the queries we use on pages of our site (and elsewhere) on this page.

[Steven Rankin]

Thanks for this – this is very helpful.

Is there an easy way to get cik codes to use. My database already has a tonne of companies listed by name.

So the flow would be:

1. search for company (by name or some other useful field)
2. Retrieve cik from above query
3. Get a list of reports using cik
4. Get data from specific report using dts.id from report

I will have a look at the spreadsheets too.

Thanks

[David Tauriello]

Steven – you can return ticker detail as part of a /report query:

https://api.xbrl.us/api/v1/report/search?report.is-most-current=true&fields=entity.ticker,report.entity-name,report.document-type,report.filing-date.sort(DESC),report.limit(10)

[Steven Rankin]

Thanks for the continued help and support.

I am learning more about XBRL and I see that there seems to be parent sections and children of that section.

So there might be a parent:

Assets
   AssetsCurrent
       Cash
       accountsreceivable
       othercurrentassets
   AssetsNonCurrent
       prepaidexpenses
       accountsreceivable

Is there a way to pull in all Parent and children values? For example all these and their children elements:

  "AssetsCurrent",
  "AssetsNoncurrent",
  "Assets",
  "LiabilitiesCurrent",
  "LiabilitiesNoncurrent",
  "Liabilities",
  "StockholdersEquity",
  "MinorityInterest",
 "StockholdersEquityIncludingPortionAttributableToNoncontrollingInterest",
  "LiabilitiesAndStockholdersEquity"

This url doesn’t seem to:

/fact/search?dts.id=348264&fact.has-dimensions=false&concept.is-monetary=true&fact.ultimus=true&report.type=10-K&fields=dts.id,report.id,entity.name,concept.local-name.sort(ASC),concept.is-base,fact.value,period.fiscal-year.sort(DESC),fact.limit(10)

• This reply was modified 4 years, 3 months ago by Steven Rankin.

[Brandon de la Houssaye]

I know that this is an older string, but I am running into the same issue as what was generally identified above.

As an example, focusing on ‘Total Consolidated Revenues’ for an entity, I found that you cannot just rely on a string for under local-names.

If you want to return revenues for a given entity; given year; and given report (i.e., FY 2019 Total Revenues for array of entities), you can help by limiting down the returns by setting dimension.count = 0 (so there are no sub-members); concept.is-monetary = True (so you get only numerical response); fact.ultimus (so you only get the ‘top’ response). You may also be able to explore embedded concept object calls within the API (i.e., dimension.local-name = ConsolidatedItemAxis) or even member.is-base = True.

However, even with those screens I think you still have to limit down using concept.local-name. Some taxonomies tag this as ‘Revenues’; some as ‘RevenueFromContractWithCustomer’; etc.).

I am focusing on revenues right now because for major line items (Sales, COS, Inventories, etc.) this fact would have the most variance (e.g., sales by country; sales business segment; sales by service/product/etc.).

If anyone has any thoughts as to how you can collect a simple P&L, BS (i.e, forgoing specific entity extensions or reporting) for any given year & any given report type (10K, 10Q, etc.), please share the API construct.

It would be a huge help!

[Author]

Posts