Refresh Interval

On the free plan data are cached for 1 hour. A refresh after that will get you the latest data.

The Data Availability Service offers a sub-1-minute refresh interval.

Using a Manual Refresh Trigger

We use a trick where Google Sheets will force a refresh when one of the function’s argument has changed.

Here is how to set it up in 2 steps:

  1. Make the 4th argument to all your CRYPTOFINANCE function calls a locked reference to a cell, say A1. If you don’t have 2nd or 3rd arguments, just make them an empty string.
  2. From now on every time you change the content of your cell, A1 here, your data will be updated.

ProTip Use a checkbox in A1 to trigger a refresh easily, go to InsertCheckbox. Clicking it only once will suffice to trigger a refresh.

Examples:

If your function call was =CRYPTOFINANCE("BINANCE:ETH/BTC") your function call becomes:

=CRYPTOFINANCE("BINANCE:ETH/BTC", "", "", $A$1)

If your function call was =CRYPTOFINANCE("COINMARKETCAP") your function call becomes

=CRYPTOFINANCE("COINMARKETCAP", "", "", $A$1)

If your function call was =CRYPTOFINANCE("COINMARKETCAP", "EUR") your function call becomes

=CRYPTOFINANCE("COINMARKETCAP", "EUR", "", $A$1)

Next Step

Check out the page Things to Know to better understand Google Sheets behaviour.