Saturday, September 21, 2019 at 8:46 AM #152015Kevin MonahanParticipant
I have been a member previously utilizing the google sheets via token for the margin analysis template and it worked flawlessly. However, with the new setup, it seems that it does not call all the data. For example when searching AMZN in the MarginTimeSeries tab, (utilizing the overrides ticker) the data stops at 2018 2Q and for many other symbols such as OLLI, there is no data at all or very little.
I’m I missing something or additional step perhaps??
Saturday, September 21, 2019 at 3:19 PM #152025David TaurielloKeymaster
Hi Kevin – thanks for writing and for your good question. You might need to adjust the elements queried for the time series to work properly.
I’m confirming OLLI was empty until I entered RevenueFromContractWithCustomerExcludingAssessedTax in the override cell B21 of the time series tab. NOTE – you can use a comma-delimited set of elements in this override field.
- You must be logged in to reply to this topic.
Risk factors and other items from 10-Q&10-K filings 22 hours, 8 minutes ago
Lists of similar concepts 5 days, 8 hours ago
Lists of similar concepts 6 days, 20 hours ago
Lists of similar concepts 6 days, 23 hours ago
Risk factors and other items from 10-Q&10-K filings 2 weeks, 3 days ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- XBRL API Documentation (PDF)
- Get Started with Google Sheets
- OR get access to data for your own app and/or our API Tools
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
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.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.