Forum Replies Created
-
AuthorPosts
-
David TaurielloKeymaster
Hi Arthur – we’re not a good resource for this data, which is created via a web form on the SEC’s site, and available as .xml
Angelo BriziParticipant1)
/api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2019&period.fiscal-period=Y&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.valuereturns 152703000000
This is the 10-K filed on 2019-10-11 but the returned revenues are for the 12 months not the 3 months. The 10K reports 152703 (like the API) for the 12 months but only 34740 for the 3 months. How do I get the data for the 3 months (which should be 34740)?
2)
api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2020&period.fiscal-period=1Q&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.valueThis correctly represents the Revenues for the filings 10Q on 2019-12-23. No issues here
3)
api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2020&period.fiscal-period=2Q&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.valueThis is the 10Q filed on 2020-03-12 and it’s missing. Revenues should be 39072000000 but returned value is null
4)
api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2020&period.fiscal-period=3Q&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.valueThis is the 10Q filed on 2020-06-04 and it’s missing. Revenues should be 37266000000 but returned value is null
Also data for 2019 2Q and 2019 3Q are missing.
Arthur OlevskiyParticipantHi Angelo,
I can help you with first issue. In your request, you specified “period.fiscal-period=Y” which is means 12 month. If you want get 3 quarters you can put following values: Y, 1Q, 2Q, 3Q, 4Q, 3QCUM, 1H, 2H. It depends on accounting data type if it is “duration” you need to put 3QCUM if data published “as for some date” you can put 3Q.
Arthur OlevskiyParticipantAs for me, it is better to get list of fact.id for specific filing and put it in request to get values.
Arthur OlevskiyParticipant.
- This reply was modified 3 years, 10 months ago by Arthur Olevskiy.
- This reply was modified 3 years, 10 months ago by Arthur Olevskiy.
Angelo BriziParticipantHi Arthur,
thanks a lot for your feedback. How do you get the list of fact.id for the specific filing?For 2Q 2019, using either 2Q or 1H the query returns no data
api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2019&period.fiscal-period=2Q,1H&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value
Same thing for 3Q 2019, using either 3Q or 3QCUM no data
api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2019&period.fiscal-period=3Q,3QCUM&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value
or for 2Q 2020, using either 2Q or 1H still no data
api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&period.fiscal-year=2020&period.fiscal-period=2Q,1H&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value
Thanks again.
Arthur OlevskiyParticipantHi Angelo,
I use this link
api/v1/relationship/tree/search?dts.id={dts_id}&network.link-name=calculationLink,presentationLink&format=flat&fields=relationship.target-datatype,relationship.target-concept-id,network.role-description.sort(ASC)
Also, you can play with requests in documentation (https://xbrlus.github.io/xbrl-api)
Arthur OlevskiyParticipantThen, you can get relationship.target-concept-id value and make following request
https://api.xbrl.us/api/v1/fact/search?concept.id=&dimension.is-base=false&dts.id={dts_id}&fact.ultimus-index=1&period.fiscal-period=&period.fiscal-year=&fields=fact.value,fact.inline-display-value,concept.local-name
concept.id same as relationship.target-concept-id. I put list of ids, fiscal period and fiscal year period to request’s params
Angelo BriziParticipantThanks a lot Arthur
Hasnain jafferyParticipantHello,
where can I find the exact label match for the number reported in 10-K or any field report. For example Apple 10-K year 2019 there are 29 entries marked as “MarketableSecuritiesCurrent” in fact table. I can match the numbers in 10-K as well but I am not able to locate the exact screen match label for these numbers anywhere. Can anyone help me on this…?David TaurielloKeymasterHi Angelo – On your question about why you’re unable to return fact.value data for 2Q, 3Q or 3QCUM, it is because when we load the data, our process includes an algorithm to determine period.fiscal-period, based on a common reporting calendar framework with some flexibility for start/end dates and industry sector. Unfortunately, Costco’s timings don’t quite fit this expectation and as a result, we report the range as YYYY-MM-DD – YYYY-MM-DD.
api/v1/fact/search?concept.local-name=RevenueFromContractWithCustomerExcludingAssessedTax&entity.cik=0000909832&fact.ultimus=true&fact.has-dimensions=false&fields=fact.value,period.fiscal-period,entity.name,report.filing-date.sort(DESC)
I’ve raised this issue with the team and we’re looking at ways to address this as we process the data from the SEC. Check out this thread for a bit more discussion on fiscal v. calendar periods in the XBRL API: https://xbrl.us/forums/topic/reports-and-periods/#post-115421.
Angelo BriziParticipantHi David, thanks a lot for your explanation. That was very helpful.
David TaurielloKeymasterHi Hasnain,
Pass the
dts.id
andconcept.local-name
for the fact to the/label
endpoint to get the presentation-side text that corresponds to the value.There’s a Google Sheet sample posted in this reply that might be helpful – https://xbrl.us/forums/topic/tackling-issues-with-operating-lease-data/#post-185320.
Saturday, September 12, 2020 at 12:48 AM in reply to: Getting started with the XBRL Google Sheet and add-on #185957AnonymousInactiveI could not get to work on Firefox
Monday, September 14, 2020 at 9:31 AM in reply to: Getting started with the XBRL Google Sheet and add-on #185988David TaurielloKeymasterMorjanah – please review the instructions at the top of this post, and try installing the add-on to your Google Account using the Chrome web browser first, before moving to Firefox.
-
AuthorPosts