Daily limits apply across both Google Sheets and Microsoft Excel:
Basic — 10,000
Investor — 25,000
Analyst — 100,000
Pro and Team — 500,000
Limits
Tips
The best way to manage both rate limits and quotas is to take advantage of our Realtime Batch, Company Info Batch and other batch functions. This can significantly reduce your external data usage.
Consider purchasing a Google Workspace Account if you intend to use SheetsFinance in Google Sheets for more than 20,000 data calls a day. This will increase your daily Google quota by 5x to 100,000 data calls a day. Note there are some restrictions to when your increased quota is applied, please read Google's Documentation.
Quotas
SheetsFinance plans include daily data call limits that apply across both Google Sheets and Microsoft Excel. At the time of writing, the current plan limits are 10,000/day for Basic, 25,000/day for Investor, 100,000/day for Analyst, and 500,000/day for both Pro and Team.
Google Sheets users should also note that Google applies its own external request quota of 20,000/day on free accounts. Google's daily quota is for all Google Sheets activity on your Google account, so if you use other add-ons in different sheets to access external data this will count toward your overall external data quota.
If you do find that you're regularly hitting Google's limit you could purchase a Google Workspace Account which will increase your daily limit to 100,000/day (5x increase). This is a good move if you intend to use SheetsFinance to pull large quantities of data daily! It is important to note that to receive the increased quota for your Workspace account you must:
Have cumulatively paid at least USD $100 (or equivalent) on the registered Workspace domain, and;
Have at least 60 days elapse since reaching the above payment threshold.
You can read more on Google quotas here.
Rate Limits
Our external data service, like most, is rate limited to protect it from abuse. This means that if you attempt to run 100s of simultaneous functions you may find you hit a rate limit error. We have done our best to efficiently cache non-realtime data and throttle out-going requests but from time-to-time you may over-do it. Don't panic. Just wait a few seconds and re-generate the formula.
Note: If you're still seeing the error be sure you've entirely deleted the formula and then re-entered it. If you continue to have problems please contact us.
Quota FAQ
How many daily data calls does each plan allow?
Does Google Sheets impose its own limit?
Yes. Free Google accounts have a separate external request quota of 20,000/day that covers all Google Sheets activity on your account, including other add-ons. A Google Workspace account can raise this to 100,000/day after meeting payment thresholds. See Google's documentation for details.
How can I reduce my data call usage?
Use batch functions and chain multiple metrics with & to pull more data per request. Request year ranges instead of individual years, and close spreadsheet files you are not actively using to stop background refreshes. See our Performance Tips article for a full guide.
What should I do if I see a rate-limit error?
Wait a few seconds, then entirely delete the formula and re-enter it. To retry only the cells that errored, use Refresh Errors from the SheetsFinance menu in Google Sheets or Excel. If the error persists, contact support.
As always, please access our data in a smart and respectable way. Any abuse of our external data service will result in subscription suspension and potential termination.
Was this helpful?