Cryptofinance
Open CryptowatchCreate AccountPricingContact Us
Search…
⌃K
Links

How to Refresh Rates with CRYPTOFINANCE

Cells won't automatically refresh with new data — learn how to set a manual refresh trigger.
Google Sheets
Excel
Airtable

Using an Automatic Trigger

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. 1.
    Have a cell, i.e., A1= GOOGLEFINANCE("CURRENCY:USDEUR")
  2. 2.
    In a different cell, say A2, set your 4th argument of CRYPTOFINANCE, which is used to update the data, to A1. 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")
​

Using 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. 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, like this "".
  2. 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)

Using a Manual Refresh Trigger

We use a trick where 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. 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, like this "".
  2. 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)
Not available for Airtable.
Previous
Formula Builder
Next - Markets Data
Cryptowatch Data
Last modified 2d ago