Wednesday, July 17, 2019 at 1:04 PM #146005
I’m enjoying using the API and got my python scripts to pull a large number of historical financials for many tickers.
However, ticker MTSC, CIK 68709, only pulls financials from 2015 and before. It does not pull for 2016 – 2018. The SEC does have financials reported for MTSC for these periods. Could you take a look at the issue?
Thursday, July 18, 2019 at 1:13 PM #146116
Anil – thanks for writing; this was similar to a prior post – https://xbrl.us/forums/topic/missing-reports/ and it has been resolved. Let us know if you find other instances.
Keep enjoying the data and please consider XBRL US Membership – https://xbrl.us/membership – for yourself or your institution to take full advantage of our Public Filings Database and other benefits.
You must be logged in to reply to this topic.
CIK and Ticker 1 week, 5 days ago
Extracting Data From A Particular Financial Statement 2 weeks, 3 days ago
Missing years 1 month ago
Period details for facts 1 month, 3 weeks ago
Extracting Data From A Particular Financial Statement 1 month, 3 weeks ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Documentation (PDF)
- Get Data with Google Sheets
- Sample Queries (Insomina REST client) - requires account provision
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