πŸ‘‰ Follow these steps to create automatically refreshing formulas

  1. In any cell (ie $A$1) type =GOOGLEFINANCE("CURRENCY:USDEUR") which will automatically update (about every 2 minutes)
  2. 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"))
  3. Everytime the GoogleFinance cell updates πŸ‘‰ so will your Cryptosheets data! That's it!

​

​

​

​
Click here to read the full article on automatic refresh

​

How to Automatically Refresh Cryptosheets Custom Functions Data in Excel & Googlesheets using CS.TIME

Learn how to refresh any Cryptosheets custom function dataset…

​

​
​

​

πŸ‘‰ Follow these steps to make your Google spreadsheet update automatically at set intervals

  1. Go to File menu
  2. Select Spreadsheet settings
  3. Select Calculation
  4. Adjust the drop down menu to your desired refresh interval
  5. 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:

  1. 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())
    ​
  2. 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

https://support.google.com/docs/answer/3092981?visit_id=637216175023079490-3634357301&hl=en&rd=2

Did this answer your question?