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
CRYPTOFINANCEfunction 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,
A1here, 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