I have a worksheet where I input the CIK for one specific issuer.
This pulls a list into the worksheet of all of the 10-Q and 10-K reports by that issuer.
For the oldest report the worksheet then pulls in the facts from that report that are relevant to me.
So far, no VBA, just XBRL.showData() functions in the worksheet.
I then want to use VBA to do the following steps:
1. Store the relevant facts, mentioned above, in my own DB.
2. Select the next-oldest report from the worksheet, and make the worksheet pull in the relevant facts from that report into the worksheet, still using the XBRL.showData() Function.
3. Go back to step 1.
This works fine for the first/oldest report, but once we get to the next report the XBRL.showData() function does not update. It just displays #BUSY!, because the VBA-macro is still running.
Once the VBA stops running, the function updates almost immediately.
In Google Sheets with App Script this does work as long as you insert pauses that allows the function to update.
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.