Tagged: Fiscal Periods
Saturday, January 12, 2019 at 1:48 PM #120428
I ran the following query in Google Sheets
Why only the data for 3QCUM and Y are returned? It looks like the data for 1Q and 1H (except for 2016) are missing.
Sunday, January 13, 2019 at 1:04 PM #120467
the above query is not shown properly in the message above but is the following
Monday, January 14, 2019 at 2:56 PM #120543
Hi Angelo – in the query below, I’m returning
period.fiscal-periodas part of the fields to show how the fact corresponds to reporting periods defined by the filer for their annual cycle, which does not always follow the 1/1 – 12/31 calendar.
If you replace the
concept.local-namein the query with a US GAAP element in every filing called DocumentFiscalPeriodFocus the model for this filer’s fiscal year should become clear (10/1 – 9/30).
See this discussion for more detail on periods, and check out the Balance Sheet Compare – SEC Filers Google Sheet for queries that translate the DocumentFiscalPeriodFocus for the presentation.
Tuesday, January 15, 2019 at 12:04 AM #120572
Thanks a lot for the detailed answer David. That was really helpful.
You must be logged in to reply to this topic.
CIK and Ticker 1 week, 6 days ago
Extracting Data From A Particular Financial Statement 2 weeks, 3 days ago
Missing years 1 month ago
Period details for facts 1 month, 3 weeks ago
Extracting Data From A Particular Financial Statement 1 month, 3 weeks ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Documentation (PDF)
- Get Data with Google Sheets
- Sample Queries (Insomina REST client) - requires 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 email@example.com 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