Data not returned

[Angelo Brizi]

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

[Angelo Brizi]

the above query is not shown properly in the message above but is the following

=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)”)

[David Tauriello]

Hi Angelo – in the query below, I’m returning period.fiscal-period as 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.

/fact/search?&concept.local-name=NetCashProvidedByUsedInOperatingActivities&period.fiscal-year=2015,2016,2017,2018,2019&entity.cik=0000915840&fact.ultimus=1&fact.has-dimensions=false&fields=period.end.sort(DESC),concept.local-name,fact.value,period.fiscal-period,period.calendar-period,period.fiscal-year,period.year

If you replace the concept.local-name in 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.

[Angelo Brizi]

Thanks a lot for the detailed answer David. That was really helpful.
Best regards,

Angelo

[Author]

Posts