Forum Replies Created
-
AuthorPosts
-
AnonymousInactive
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 TruscottParticipantHi Francesco. I’m gonna put a video together today that will demo what you need to do. Jim
David TaurielloKeymasterHere’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 TruscottParticipantThanks for posting that David. Jim
Jim TruscottParticipantHi 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 BuiParticipantHello,
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 TaurielloKeymasterentity.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 includingdts.id
orreport.id
as one of the fields in your initial query, then set up a second query to returnentity.ticker
as/report/search?dts.id=(INTEGERS,FROM,YOUR,QUERY)&fields=entity.ticker
Friday, March 22, 2019 at 5:16 PM in reply to: Getting started with the XBRL Google Sheet and add-on #129657AnonymousInactiveI 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 BuiParticipantThank you for your explanation, David.
Monday, March 25, 2019 at 9:37 AM in reply to: Extracting Data From A Particular Financial Statement #129969Tim BuiParticipantHi 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
Monday, March 25, 2019 at 3:14 PM in reply to: Getting started with the XBRL Google Sheet and add-on #130034David TaurielloKeymasterHi 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 NYParticipantI 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.?
Thursday, March 28, 2019 at 4:28 PM in reply to: Extracting Data From A Particular Financial Statement #130800David TaurielloKeymasterTim – 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.*
– thenetwork.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 TaurielloKeymasterThe 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 onfact.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
.Thursday, March 28, 2019 at 6:01 PM in reply to: Extracting Data From A Particular Financial Statement #130825Tim BuiParticipantThank you, David! Got it. It’s working
-
AuthorPosts