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.
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Documentation (PDF)
- Getting Started with Google API Access
- Sample Queries (Insomina REST client) - requires account provision