Table of contents
Learn several options for how to automatically refresh your Cryptosheets data in Google Sheets
C
Written by Chris Ware
Table of contents
In any cell (ie $A$1) type =GOOGLEFINANCE("CURRENCY:USDEUR") which will automatically update (about every 2 minutes)
Using any Cryptosheets custom function, add a reference to that cell at the very end of the formula for the global refresh argument
Syntax=CSPRICE("base","quote","time","exchange","returnType","refresh")
Example 1=CSPRICE("BTC","USD",,,$A$1)
Example 2=CSPRICE("BTC","USD",,,GOOGLEFINANCE("CURRENCY:USDEUR"))Everytime the GoogleFinance cell updates 👉 so will your Cryptosheets data! That's it!
How to Automatically Refresh Cryptosheets Custom Functions Data in Excel & Googlesheets using CS.TIME
Learn how to refresh any Cryptosheets custom function dataset…
Go to File menu
Select Spreadsheet settings
Select Calculation
Adjust the drop down menu to your desired refresh interval
Save your new settings
*Important reminder: you need to add one of the formulas for =NOW() or =TODAY() into your sheet in order for the auto refresh triggers to automatically update your data
There are also a few less official methods that will likely work but may not be as stable:
Use NOW() in any cell. then use that cell as a "dummy" parameter in a function. When NOW() changes every minute the formula recalculates.
Example: =someFunction(a1,b1,c1) * (cell with NOW() / cell with NOW())
Another method is to include a '+ NOW() - NOW()' stunt at the end of the cell formula, with the setting as seen below to recalculate every minute.
Additional Resources
Did this answer your question?
