I have been able to set up my Google Sheet and it is pulling data. Is there a specific dictionary which lists out the naming conventions of various line items? I was able to access this through the above mentioned Google Drives file.
For example, If I want to pull Interest Expenses in Google Sheets, I have typed [Interest Expense]. Is there a way to find a complete dictionary? I am using IXBRLAnalayst add-on in Google.
Hi Parker – thanks for writing. SEC filers create their own dictionary when they submit a filing. It includes importing the chosen base taxonomy (US GAAP or IFRS) and adding any company-specific extension concepts that are not defined in the base taxonomy.
I’m not familiar with features of iXBRL Analyst, so can’t advise you on whether these are accessible in that tool. Our XBRL Filed Data extension lets Member institutions create a simple query (either entire base taxonomies or extensions) to return the entire list of concepts (the dictionary). Anyone can search for concepts from the task pane of the extension.
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.
To use the XBRL API outside of Google Sheets, your account needs to be provisioned for OAuth2 access.
The national consortium for the business reporting standard
XBRL US is a not-for-profit organization supporting the implementation of digital business reporting standards through the development of taxonomies for use by U.S. public and private sectors, with a goal of interoperability between sectors, and by promoting XBRL adoption through marketplace collaboration.