How to Refresh Rates with CRYPTOFINANCE
Cells won't automatically refresh with new data — learn how to set a manual refresh trigger.
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)