[Anonymous]

Hi everyone,

apologies, I believe I might be overlooking something fundamental here but I do not understand what exactly has to be done to authenticate within the XBRL XL template and make the query connections work. I tried to follow the steps in the “FAQ” tab but could not really progress.. would be really appreciated if someone could higlight the necessary (first) steps a bit more clearly. Thanks a bunch in advance!

[Jim Truscott]

Hi Francesco. I’m gonna put a video together today that will demo what you need to do. Jim

[David Tauriello]

Here’s an excerpt from our XBRL US Member meeting last week, showing where the values are inserted: https://www.youtube.com/watch?v=pct7PZJsM0c

[Jim Truscott]

Thanks for posting that David. Jim

[Jim Truscott]

Hi there,

I’ve just posted a fuller video – https://youtu.be/taoE_hDq6LM which covers the whole setup from start to finish and a quick whizz around the queries for starters.

Jim

[Tim Bui]

Hello,
I use the code below to get some data. with entity.name I do get the company name, however, the entity.ticker does not return value. Would anyone please point me to the right direction? Thank you
=CONCATENATE(A1&”/fact/search?entity.cik=”&TEXTJOIN(“,”,TRUE,Call!B22:B179)&”&fact.has-dimensions=false&fact.ultimus-index=1&concept.local-name=”&Call!G19&”&period.fiscal-period=”&Call!D1&”&period.fiscal-year=”&TEXTJOIN(“,”,TRUE,Call!A2:I2)&”&fields=entity.cik,period.fiscal-year,period.fiscal-period,concept.local-name,concept.id,fact.value,concept.balance-type, entity.name,entity.ticker”)

[David Tauriello]

entity.ticker is not available on the /fact endpoint (see XBRL API Documentation).

You might be able to return this detail if you use /report/fact/search? instead of /fact/search? – note: this might ‘nest’ the results in Google Sheets and make that approach impractical. In that case, consider including dts.id or report.id as one of the fields in your initial query, then set up a second query to return entity.ticker as /report/search?dts.id=(INTEGERS,FROM,YOUR,QUERY)&fields=entity.ticker

[Anonymous]

I could not get to work on Firefox – At the Authentication Menu, I was never given a menu to login – including following all of the steps anove. It did work on Chrome.

[Tim Bui]

Thank you for your explanation, David.

[Tim Bui]

Hi Brian,

Not being a technical person and not knowing much about Google Sheet, would you please help me again with downloading the financial statements?
1. Get CIK:
I put the ticker in B2 and use this code to get the CIK(put code in B3): =left(ImportXML(“https://www.sec.gov/cgi-bin/browse-edgar?ticker=”&A2&”&action=getcompany”,”//div/span/a[1]”),10)

2. Get dtd.id:
I put your code in cell B3
https://api.xbrl.us/api/v1/report/search?entity.cik=B2&fields=dts.id
=showdata(B3), but I get “No information returned”

3. Get financial statements:

https://api.xbrl.us/api/v1/relationship/search?dts.id={dtsid}&relationship.target-is-abstract=false&network.link-name=presentationLink&network.role-description=1003000 – Statement – Condensed Consolidated Balance Sheets (Unaudited)&fields=relationship.tree-sequence.sort(ASC),relationship.*

– what does the curly brackets {dtsid} do?
– where do I change the code to get Income statement or cash flow statement?

Thank you for your help, Brian!

Tim

[David Tauriello]

Hi James – I’m confirming there’s an issue with the link to the Authentication Menu with Firefox. As a work-around, right-click (Windows) and open the Authentication Menu in a new tab or window, then proceed with credentials and close the tab upon ‘success’ messaging.

[PX NY]

I hope this question isn’t out of place.

Is there a way the use API to parse a 10-K and have it return specific abstract text formally itemized in the document, such as “Item 1.”, which is “Business Description” or “Item 2.” which is “Risk Factors,” etc.?

[David Tauriello]

Tim – on the ‘no information returned’ issue, check that your formula is correct. Spreadsheet programs (Google Sheets, Excel) require a specific syntax when you want to use data contained in a cell – our templates use the CONCATENATE formula pretty consistently to join strings together see: https://support.google.com/docs/answer/3094123 – this creates a URL that is recognized by the XBRL US showData() function in our add-on that enables data to flow into Google cells.

I read Brian’s {curly brackets} as a variable – in this case, it’s the dts.id that’s populated by data in another cell or worksheet.

Try this query in your Google Sheet – /relationship/search?dts.id=316055&relationship.target-is-abstract=false&network.link-name=presentationLink&fields=network.role-description.sort(ASC),relationship.* – the network.role-description column lists statements and disclosures from this Ford Motor Company report. You can use the text from any of these reports with Brian’s code to get line details for any statement or disclosure (remember to carry the dts.id into Brian’s query – not every company reports the same statements and disclosures)

[David Tauriello]

The XBRL API is not currently configured to query text within fact.value as there are several datatypes for this information (numeric, boolean, data, string, etc.). At this point, the parsing needs to be done on fact.value after it’s returned to the end user. Fortunately, structured data like XBRL makes this easy at the destination.

To date, we’ve enabled text-match on the label endpoint so a query like this will show all of the labels in a filing that contain the string “Text Block” – /label/search?dts.id=292503&label.text=Text Block&fields=label.*,concept.local-name.sort(ASC). Take a look at the documentation for details.

We’re continuing to explore and assess the suitability of text match on other viable endpoints like fact.

[Tim Bui]

Thank you, David! Got it. It’s working

[Author]

Posts