[Timur Mirzaev]

Hi, David

That resolves the issue (I also retrieve the latest fiscal year to dynamically adjust my period.fiscal-year series)!
Thank you very much indeed for your time and assistance.

Regards,
Timur

[David Tauriello]

Peter – thanks for taking a look at the materials I passed in email from another XBRL US Member. I sent along your appreciation for his efforts in using the data.

We’re working out how to provide face financial data through endpoints to the XBRL API – stay tuned.

[Timur Mirzaev]

Hello!

For some reason, my query, which used to work just fine (arguably, before the recent add-in update), now shows the “Calc!” error. What is even more unusual is that in a split of a second I can actually see the data appearing before being superseded by this very error.
Apparently, this error can be replicated by having the full code written as a formula [ with references to other cells having, say, ‘fact endpoint’ and ‘textjoin(“,”, TRUE, concept name) formula for concept unification], while the XBRL.showData () is used separately to refer to that formula.
Interestingly, if one “kills” the formula, so that the code is just a plain text, the error is gone, and data is extracted.

I would very much appreciate any help around this issue.

[David Tauriello]

Hi Timur – this link might help you diagnose the #CALC! issue: https://exceljet.net/formula/how-to-fix-the-calc-error

If you post an example of a query that’s not returning data, it will be easier to understand the issue you’re encountering.

David

[Asif Saberi]

Another question:This pertains to using the entity.ticker in the search phrase-
The following works (the entity code is hard coded – CIK for AAPL):
=XBRL.showData(CONCATENATE(“https://api.xbrl.us/api/v1/fact/search?entity.code=0000320193&period.fiscal-year=2021&period.fiscal-period=Y&concept.local-name=”,$B12,”&fact.ha”,”s-dimensions=false&fact.ultimus=true&fields=fact.value,period.fisc”,”al-year,fact.limit(),fact.offset()&”),””, “”, “0”)

But the following does not work (cell D5 contains the ticker for Apple inc, AAPL)
=XBRL.showData(CONCATENATE(“https://api.xbrl.us/api/v1/fact/search?entity.ticker=”, $D$5,”&period.fiscal-year=2021&period.fiscal-period=Y&concept.local-name=”,$B12,”&fact.ha”,”s-dimensions=false&fact.ultimus=true&fields=fact.value,period.fisc”,”al-year,fact.limit(),fact.offset()&”),””, “”, “0”)

[David Tauriello]

Hi Asif – apologies for the slow reply; the entity.ticker parameter is not available as a filter for queries on the fact endpoint. You should see the following message in your query:

The following search parameter is not valid: entity.ticker

You’ll need to convert use another value (entity.id, entity.cik or entity.code) to return values for the entity.

[Tim Bui]

Timur, I had replied twice but some how my notes were not posted.

You can get the Excel files of US Taxonomy from these 2 sources:
– https://fasb.org/Page/PageContent?PageId=/xbrl/2022financial.html
– https://xbrl.us/xbrl-taxonomy/2022-us-gaap/

[David Tauriello]

Hi Tim – thanks for posting and apologies to you and Timur – posts with URLs are pushed to moderation and I didn’t get a notification for this.

[Tim Bui]

Hi Timur, You can google “US GAAP Taxonomy 2022” then it will take you to this site: https://fasb.org/Page/PageContent?PageId=/xbrl/2022financial.html
In the section “Guidance and Supporting Documents”, you will see 2022 GAAP Taxonony(Excel Version). You can download and extract this large Excel file. The fist tab is “Elements” that contains Col N & O that Peter referred to.

XBRL.US also has the same Excel (xls format) at this site: https://xbrl.us/xbrl-taxonomy/2022-us-gaap/

Tim

[Matthew Beveridge]

Hi Peter and apologies for the ridiculously late reply — you can find my most recent (yet very out-of-date) version here: https://github.com/mattbev/finpandas.

This is by no means a complete remedy and like Mikko said is very similar in principle to their solution. Additionally, the cloud bucket that this repository relies on has not been updated with new DERA data in many months. If there is sufficient interest I can revisit this, but otherwise, I am inclined to table/archive my version of this project until a later date.

[Peter W Reed]

Thanks Matthew for taking the time to reply. I’m using Alpha Advantage for now. Let me know when you get back to your project on github? You don’t want me to write code – I’m a hack. But I will take the time to test or contribute in other ways. I’m fairly competent at documentation.

[Satish Sahoo]

Dear Members,
I am very new to XBRL. So this might be very basic. But I am struggling to find a way to request only tags/concepts containing a specific keyword. For example, how to get all the tags containing the word ‘goodwill’ even if I don’t know the exact tag names ? I am using the US XBRL API in python.

One way perhaps is to download all tags and then search for the word goodwill using python functions/tools. But that would download too many records. Is there a way to specify through the API that I am only interested in tags containing goodwill?
If it’s possible can it also be used to filter based on labels in the filing and not just the tags?

Thanks
Satish

[David Tauriello]

Hi Satish – thanks for writing. You can get a company’s Goodwill elements by using a query like this, where the DTS ID is the company filing:

https://api.xbrl.us/api/v1/label/search?fields=concept.local-name.sort(ASC),label.text&label.role=http://www.xbrl.org/2003/role/label&label.text=goodwill&dts.id=583061&concept.is-abstract=false (this is available from the XBRL Filed Data extension on the fact and concept functions when you filter the form by a company DTS). The DTS ID for the 2022 US GAAP Taxonomy is 553038.

The Financial Accounting Standards Board (FASB) produces the US GAAP Taxonomy annually. See https://xbrl.us/2022-us-gaap for details, including:

• a link to the taxonomy in a viewer with a search feature – this shows the structure for presentation and other linkbases, and includes definitions and authoritative references for all elements
• a link to an Excel file with the 2022 US GAAP concepts

Companies can also create their own concepts (called extension concepts) for cases where a data point in the report does not fall within the definition of any concept in the US GAAP Taxonomy. Consider reviewing a company’s filing to see if any of the concepts in the filing are extension concepts (use concept.is-base on a fact query to see which elements are extensions).

[Satish Sahoo]

Hi David,
Thanks a lot for your very detailed response. I could get what I was looking for adapting your query to my python script. Thanks.

[Satish Sahoo]

Hi David/Others,
I want to extract certain sections of the 10-k filings. For example I tried to extract segment information using ‘SegmentReportingDisclosureTextBlock’ tag. I was hoping to get the entire section (including the tables and text etc).
While I am able to pull the tag, its fact.value just gives me the details of the tag.
For example I get-
<p style=’margin-top:0pt; margin-bottom:0pt’><font style=”font-family:Times New Roman;font-size:10pt;font-weight:bold;margin-left:0px;”>NOTE 4.</font><font style=”font-family:Times New Roman;font-…

<div style=”font-family:Times New Roman;font-size:10pt;”><div style=”line-height:120%;padding-top:18px;font-size:10pt;”><font style=”font-family:inherit;font-size:10pt;font-weight:bold;”>ACQUISITI…

ACQUISITIONS, GOODWILL, AND ACQUIRED INTANGIBLE ASSETS<div style=”line-height:120%;padding-top:6px;text-indent:16px;font-size:10pt;”><span style=”font-family:inherit;font-size:10pt;font-style:ital…

How can I get the entire section’s text and formatting information to put it in another HTML/Text File ? I tried footnote.* as well without any luck.

Your help would be much appreciated.

Thanks

[Author]

Posts