Tuesday, October 30, 2018 at 12:20 PM #114392
Having double-checked the documentation (and run some never ending queries!), am I right in thinking that you cannot retrieve fact values directly with a ticker?
That you need to query the entity or report first to get an id to use in your fact request?
I guess confirming this?, I notice the google sheet exclusively uses CIK’s and where a ticker can be used as an input in BSCompare, a look up is made to a different url – https://csuite.xbrl.us (another API?).
Is this a better source of ticker/CIK mappings? If so, should we use this?
Wednesday, October 31, 2018 at 9:19 PM #114719
you can search on
entity.tickerto return facts, see
That said, I wouldn’t advise it for heavy lifting as it can be a bit slow, which is why we’re returning tickers with the legacy API in the BScompare template. When the other endpoints are sunset in December, this one will likely remain available for several months into 2019.
Thursday, November 1, 2018 at 5:54 AM #114754
I am not sure it will work much quicker, but you could also use:
in Google Sheets where cell D2 contains your ticker.
You must be logged in to reply to this topic.
XBRL API Resources
- Create a Google Account (without Gmail)
- Install XBRL API Access (Google Sheet Add-on)
- Make a Copy of Google Sheet Templates:
Using the XBRL API with the Public Filings Database
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.
Ready to work with the API in Excel's Power Query, or with your own system or app?
Contact us at firstname.lastname@example.org to have your existing XBRL US Web account provisioned to generate client ID/Secret pairs to work with the XBRL API in a REST client or other application, including Excel's Power Query.
NOTE: You do not need to generate client ID/Secret pairs if you use the Google Add-on and Google Sheet exclusively to access data - the XBRL API Authentication Add-on handles this automatically.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table