Tagged: xbrl api dimension fact
Tuesday, May 12, 2020 at 2:12 AM #179419
Hope you are keeping well. I had a few questions regarding the extraction and interpretation of Operating Lease related data:
1) Is there possibility of a time delay between the filing of 10-K/10-Q and when Operating Lease data is available on an xbrl-API endpoint. (we encountered this with WMT on the day 10-K was released. When we tried again after a week the data was there).
If is a typical occurrence, is there a way by which we can ascertain if the lack of data is bcos of a delay VS the entity not having any Operating Lease disclosure requirement ?
2) In a prior post, you had pointed out about using fact.has-dimensions=false to return non-dimensional values. However, there are cases where setting has-dimensions as false does not return any operating lease related data (for e.g. GM, cik=0001467858). In this context,
– How do we get operating lease related data (OperatingLeaseLiability, OperatingLeaseLiabilityNoncurrent, OperatingLeaseLiabilityCurrent, OperatingLeaseRightOfUseAsset)
– And how do we select the correct dimension for the consolidated lease data for the entity – because some of the above facts return multiple values
– Is there a xbrl document that explains how to interpret the different dimensions for various concepts.
3) Are there alternative way of extracting the above op. lease related facts when the entity does not disclose during interim intervals (ie quarterly). For e.g. when we try to extract Op. Lease data for GM for 2020 Q1 – we are not getting any values for OperatingLeaseLiability, OperatingLeaseLiabilityNoncurrent, OperatingLeaseLiabilityCurrent. Not sure if this is another case of a delay OR some other reason.
Thanks much, Teji
Tuesday, May 26, 2020 at 12:10 PM #181112
Teji – apologies for the delayed response; I hope you are well.
1) there may be occasions where we’re more than a few minutes behind the SEC: the end of filing periods are rich with reports that have grown in complexity because filers are becoming smarter about using XBRL and the SEC has expanded its program to allow more sophisticated configurations. In addition to being copied to our database, each filing scanned with multiple data quality rulesets (see the
2) can you share the specific
report.idwhere this issue is occurring – ? – it would be helpful to know the context for the data in the complete filing
3) Have you tried using 1H and Q2, then subtracting to get Q1 – ? (there’s also a 3QCUM fiscal period that you might be able to use to ‘back into’ quarterly values).
Wednesday, May 27, 2020 at 2:06 PM #181308
No worries. Thank you David for the response and the clarifications.
1) Sounds good
2) “report.id”: 269648 is an example. There are several others as well but I have not kept track. In this report, only OperatingLeaseLiabilityNoncurrent is returned when specifying fact.has-dimensions=false
To obtain the other Operating Lease facts, we had to set fact.has-dimensions=true
3) I haven’t tried 1H and Q2 — but I heard back from investor relations at a couple of companies that starting in 2020 – they have decided to report Op Lease facts in the interim quarters only if there are material changes.
Thanks again. Teji
You must be logged in to reply to this topic.
Extraction and Interpretation of Operating Lease Data 1 day, 1 hour ago
Getting started with the XBRL Google Sheet and add-on 1 day, 9 hours ago
Specifying reports for results 2 days, 2 hours ago
Getting started with the XBRL Google Sheet and add-on 2 days, 2 hours ago
Entity's industry 2 days, 2 hours ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- XBRL API Documentation (PDF)
- Getting Started with Google Sheets
- Sample API Queries (works with Insomina) or Excel Power Query Template
these options require account provision
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.
Ready to work with the API in Excel's Power Query, or with your own system or app?
Contact us at firstname.lastname@example.org to have your existing XBRL US Web account provisioned to generate client ID/Secret pairs to work with the XBRL API in a REST client or other application, including Excel's Power Query.
NOTE: You do not need to generate client ID/Secret pairs if you use the Google Add-on and Google Sheet exclusively to access data - the XBRL API Authentication Add-on handles this automatically.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table