- This topic has 1 reply, 1 voice, and was last updated 2 years, 10 months ago by .
Viewing 1 reply thread
Viewing 1 reply thread
- You must be logged in to reply to this topic.
Home › Forums › The XBRL API › Get recents fact values
Hi David,
Thank you for your assistance here. It really helps to move forward in building the app.
So, I came with question. How to get most recent fat value? I’m trying to use ultimus and ultimus-index, but sometimes I still getting not recent value of report facts.
Here is my path to get fact values.
1. Firstly, of all I’m collecting reports for specific CIK.
2. Secondly, using report.id and api /api/v1/report/{report.id}/fact/search I’m collecting facts of report. Here is my query, I will skip fields part:
10-Q https://api.xbrl.us/api/v1/report/333770/fact/search?fact.ultimus=true
10-K https://api.xbrl.us/api/v1/report/323207/fact/search?fact.ultimus=true
In these two examples I’m using ultimus, however I’m still getting not recent values and those values also has ultimus-index = 1
Is there a better way to get recent fact values for specific report?
How can I get fiscal year for report object, so I can compare report fiscal year and fact fiscal year)
Thanks in advance for all answers.
Arthur
Hi Arthur – first, apologies for the delay in responding – this post was flagged in our system (probably because it includes ‘https://’
The fact.ultimus
parameter is used on the /fact
endpoint. When you specify a /report
, you will return all facts in the report without regard to fact.ultimus
.
Use your /report
query to return the dts.id
value for the report, then use a separate /fact
query to show fact.ultimus-index
detail.
/fact/search?dts.id=428275&fact.ultimus=false&fact.has-dimensions=false&fields=entity.id,report.id,concept.local-name,fact.value,fact.ultimus-index,period.fiscal-period,period.fiscal-year.sort(DESC)
In the query above, IntangibleAssetsNetExcludingGoodwill for the year 2020 was reported several more times:
/fact/search?entity.id=6252&concept.local-name=IntangibleAssetsNetExcludingGoodwill&fact.has-dimensions=false&period.fiscal-period=Y&period.fiscal-year=2020&fields=concept.local-name,fact.numerical-value,fact.ultimus-index.sort(DESC),report.id,period.fiscal-period,period.fiscal-year
Let me know if you have additional questions about this.
API Use 2024 || API Use 2023 || API Use 2022 || API Use 2021 || API Use 2020 || API Use 2019 || API Use 2018
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.