Cryptofinance
Open CryptowatchCreate AccountPricingContact Us
Search…
Getting Started
Pricing
Markets Data
Cryptowatch Data
Trade Data
Historical Data
Historical OHLCV
All-Time-Highs
Market Macro Data
Return on Investment Data
Exchange Data
Exchange Data
Batch Formula
Supported Exchanges
Cryptowatch Portfolio Data
Holdings
Trades
Orders
Order Books Data
Markets Liquidity
Market Order Book
Blockchain Data
Bitcoin and Cryptocurrency Network Data in Google Sheets
Advanced
Best Practices in Google Sheets
How to Refresh Rates with CRYPTOFINANCE in Google Sheets
Advanced Usage and Tips in Google Sheets
Things to Know
Disclaimer & Privacy
Risk Disclaimer
Privacy Statement
Terms of Service
Powered By GitBook
How to Refresh Rates with CRYPTOFINANCE in Google Sheets
Cells won't automatically refresh with new data — learn how to set a manual refresh trigger in Google Sheets.

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. 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)

Next Step

Check out the page Things to Know to better understand Google Sheets behaviour.
Advanced - Previous
Best Practices in Google Sheets
Next - Advanced
Advanced Usage and Tips in Google Sheets
Last modified 1yr ago
Copy link
Outline
Using a Manual Refresh Trigger
Next Step