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. Sharing a spreadsheet is not quota-gated and has no collaborator cap — see How sharing works for whose quota is used when a sheet is shared. 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.

When does the daily limit reset?

Your daily data-call limit resets at midnight UTC (00:00 UTC) every day, restoring your full plan allowance for both Google Sheets and Excel.

Platform limits: Excel vs Google Sheets

Excel does not impose an additional platform-level quota, so you receive the full SheetsFinance plan allowance.

Google Sheets applies its own account-level daily quota on top of SheetsFinance limits. Free Google accounts are limited to 20,000 external requests per day across all add-ons. A Google Workspace account can raise this to 100,000/day after meeting payment and age thresholds.

To use the full Analyst plan allowance in Google Sheets, you need a qualifying Google Workspace account or you can split your SheetsFinance usage across multiple Google accounts by reconnecting each one with the same Connection ID. See Account and Pricing for how to switch Google accounts.

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?

Daily limits apply across both Google Sheets and Microsoft Excel:

Basic — 10,000
Investor — 25,000
Analyst — 100,000
Pro and Team — 500,000

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?