How Does It Work?

Example Use Cases

How to Upgrade Your Subscription

FAQ & Troubleshooting

Type =CS.TIME(# of seconds) into any cell (ie $A$1)
​Example =CS.TIME(3600)
👉 3600 seconds / 60 = 60 minutes = 1 hour
​

Using any Cryptosheets custom function, add a reference to a parameter called refresh with a value of =CS.TIME in it as the parameter value or a reference to a cell with CS.TIME in it (see example below)
​
​Syntax Example 1
​=CSPRICEA("base","BTC","quote","USD","refresh",CS.TIME(3600))
​
​Syntax Example 2
​=CSPRICEA("base","BTC","quote","USD","refresh",$C$5)
​

Type =CS.TIME(# of seconds)  into any cell (ie $A$1)
​Example  =CS.TIME(3600)
👉 3600 seconds / 60 = 60 minutes = 1 hour
​

(DEPRECATED) Using any Cryptosheets custom function, add a reference to the cell with =CS.TIME in it as the time  parameter or at the very end of the formula if there isn't a time  parameter
​Syntax =CSPRICE("base","quote","time","exchange","returnType")
​Example  =CS.PRICE("BTC","USD",$A$1)
​Example 2 =CS.PRICE("BTC","USD",CS.TIME(3600))
​

Every time the =CS.TIME  function updates, any/all functions that reference it will automatically refresh!

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  =CSPRICE("BTC","USD",,,$A$1)
​Example  CSPRICE("BTC","USD",,,GOOGLEFINANCE("CURRENCY:USDEUR"))
​

Everytime the GoogleFinance cell updates 👉 so will your Cryptosheets data! That's it!

CS.TIME might well be the single most powerful tool for Excel I've ever seen. It's a genuine game changer and will improve your quality of life by saving you time, stress and mistakes (#AWESOME)

Using automatic refresh features can and will significantly increase your quota usage

It is YOUR RESPONSIBILITY to monitor your usage and we will not reset quotas for lower tier accounts that use =CS.TIME() and use up their quota accidentally

You can access your current quota usage in real time ANYtime using the billing section in your your settings (Help Center tutorial: See your subscription usage in real time)

Check your syntax for =CS.TIME() carefully, different functions for the same data may have slightly different required syntax

Check the required arguments for =CS.TIME() vs the optional arguments

Check your data & API quotas and limits

Check your formulas carefully

Check your local computer & Excel settings for default date, time, geography, format

Use Excel's error checking tools

Check Excel's help sections: https://support.office.com/en-us/article/function-arguments-65b29fb5-ec7b-4c0b-a54b-a67923571519

Find additional troubleshooting resources and tips here