How to Refresh Rates with CRYPTOFINANCE
Cells won’t automatically refresh with new data — learn how to use automatic and manual refresh triggers.
Google Sheets
Excel
Airtable
We use google sheet built-in function
GOOGLEFINANCE("CURRENCY:USDEUR")
. This will refresh the cell every 5 - 15 minutes.To set it up you can do as follows:
- 1.Have a cell, i.e.,
A1
=GOOGLEFINANCE("CURRENCY:USDEUR")
- 2.In a different cell, say
A2
, set your 4th argument ofCRYPTOFINANCE
, which is used to update the data, toA1
. If you don’t have 2nd or 3rd arguments, just make them an empty string, like this""
.
Example:
=CRYPTOFINANCE("KRAKEN:ETH/BTC, "", "", $A$1)
Where
A1
is defined as:=GOOGLEFINANCE("CURRENCY:USDEUR")
We use a trick where Google Sheets and Excel 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, sayA1
. If you don’t have 2nd or 3rd arguments, just make them an empty string, like this""
. - 2.From now on every time you change the content of this cell,
A1
here, your data will be updated.
ProTip — Use a checkbox in
A1
to trigger a refresh easily, go to Insert
› Checkbox
. 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("KRAKEN")
your function call becomes=CRYPTOFINANCE("KRAKEN", "", "", $A$1)
You can refresh the whole sheet by clicking the Cryptofinance->Refresh Sheet button.

Not available for Airtable.
Last modified 5mo ago