Google Sheets has some quota limit
Google Sheets imposes a 20,000 API calls quota per day per user and per spreadsheet file.
Each call to
CRYPTOFINANCE is 1 API call. Whenever possible
CRYPTOFINANCE will use a cache to avoid doing a request, but never for too long as getting up to date data is critical.
When you hit the quota, you will see this error message:
Service invoked too many times for one day: urlfetch.
It is recommened to use full-listings to avoid hitting this API call quota.
The add-on doesn’t run in your browser
CRYPTOFINANCE, like all Google Sheets add-ons, runs on Google Sheets servers. When you call
CRYPTOFINANCE(), Google will run the add-on on their servers on your behalf.
This means for instance that all API requests sent to exchanges are the same for all Google Sheets users. No matter if you use
CRYPTOFINANCE or any other add-on or custom script, for Coinmarketcap and exchanges your requests will appear to come the same IP address as everybody else.
As a result, exchanges may see an unusual large amount of traffic coming from Google Sheets IP. As they also have API request quota, they may ban requests, preventing you from getting your data.
For this reason the Data Availability Service offers a proxy server to ensure you get your data even when exchanges are banning requests.
Google Sheets servers are unevenly updated
The server that Google Sheets connects you to are based on your geographic location. You’re assigned to the closets servers to ensure the best user experience.
As a direct consequences, some users in some locations may receive the add-on updates after other users. It takes a different time for each server to get the add-on latest version.
Using a VPN to connect from an IP located in California may help you avoid some cache issue where your region servers are not yet updated.