Sharing Sheets When You are Using an API Key

If you’ve subscribed to one of the paid plan you have been given an API key. One API key works with one Google Acccount only.

Sheets can only be shared in view-only mode, to an unlimited number of users.

When another user make a copy of your sheet, or when you share a sheet in edit-mode, the add-on will run under the other user’s own Google Account. They won’t have access to the same (paid) data.

Another consequence of sharing in edit-mode is you will also see free quota error message in your sheet too. When you make the refresh last they see the (paid) data too, when they make the refresh last you see the free quota error message too.

To enable multi-user sheet sharing in edit-mode you have 2 options:

  • You can share your Google account with other people you want to share the sheet with.
  • You can have them purchase an API key of their own. If you have more than 4 users, contact us for a discount. We also provide invoice if you can get refunded by your company.

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 is based on your geographic location. You’re assigned to the closets servers to ensure the best user experience.

As a direct consequence, 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.

Sheet Locale Setting and Parse Errors

If the function returns Parse Error or something similar, change the commas to semicolon to separate the function arguments, like this:

=CRYPTOFINANCE("BTC/USD"; "change"; "7d")

This is happening because your sheet locale is not English. You can change your sheet locale to “United States” under the File > Spreadsheet Settings.. menu.

Coins Sharing the Same Symbol

About 60 coins share the same symbol. To ensure you get the correct coin you can use its full name (as used in CoinMarketCap URL) instead of its symbol.

To find the coin full name, simply go to its CoinMarketCap page and copy its name from the URL. For instance Cosmos URL is https://coinmarketcap.com/currencies/cosmos/ so we’ll copy cosmos.

Example with HOT, which can be both holo and hydro-protocol:

Get holo data with:

=CRYPTOFINANCE("holo/btc")

And get hydro-protocol data with:

=CRYPTOFINANCE("hydro-protocol/btc")

Notes:

  • This only work for base currencies, the quote currency must still be a symbol.
  • When using a symbol shared by several currencies, it is not predictable which one will be returned .