=CS.TIME

Use Case Scenarios

TIME - Syntax

Function arguments

Function argume...

Automatically r...

PARAMETERS - Ab...

TIME - 

Advanced Refres...

Troubleshooting

## =CS.TIME

In its simplest form, the TIME function says

```
=CS.TIME(how often to automatically refresh in seconds)
```

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTIME-syntax.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTIME-autocomplete.png)

### Use Case Scenarios

`When you need an automatically updating date or time to refresh other custom functions at set intervals`

> **IMPORTANT**

- `CS.TIME` is only available in Cryptosheets for Microsoft Excel and not Googlesheets
- `CS.TIME` refresh intervals are limited according to your [account subscription level](https://cryptosheets.com/pricing) which you can upgrade at anytime
- [Read the Help Center Tutorial for CS.TIME](https://intercom.help/cryptosheets/en/articles/3972081-how-to-automatically-refresh-cryptosheets-custom-functions-data-in-excel-googlesheets-using-cs-time)

---

## TIME - Syntax

### Function arguments

Arguments: `=CS.TIME("refresh")`

Example Values: `=CS.TIME("5")`

### Function argument descriptions

- **refresh**: The time in seconds to wait before the next update on the cell [number] optional

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTIME-syntax-autocomplete.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTIME-syntax-example.gif)


### Automatically refresh any crypto data at any interval

<iframe
  style={{ maxWidth: "570px" }}
  width="570"
  height="350"
  src="https://www.youtube.com/embed/xpOEUgGwaKE"
  frameborder="0"
  allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture"
  allowfullscreen
></iframe>


### PARAMETERS - Absolute vs. Relative

**Absolute Parameter Values**

Formulas using **absolute values** for arguments will look like this:

`=CS.TIME("5")`

**Relative Parameter Values**

Formulas using **referenced values** will look like this:

`=CS.TIME("B1")`

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTIME-relative-cells.png)

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTIME-relative-example.gif)

---

## TIME - [Examples](https://www.youtube.com/playlist?list=PLBg8GR5ao-azCwkh769O7WUMPOKdleKNH)

**TIP**: _Try copying + pasting the example formulas directly into your worksheet_


**Example 1:**

> `=CS.TIME(3600)`

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/cstime-example4.png)

**Example 2:**

> **`=CS.TIME(G5,G6,H8)`**

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/csTIME-example1.png)

**Example 3:**

> **`=CS.PRICE("BTC","USD",(CS.TIME(B4))`**

![image](https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/excel/functions/cstime-example3.png)

**Example 4:**
Refresh a complex data set including transformations from a technical indicators custom function (CS.RSI) with an attached chart

> **`MULTIPLE FUNCTIONS`**



<iframe
  width="315"
  height="315"
  src="https://www.youtube.com/embed/GLt8gvY2sBE"
  frameborder="0"
  allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture"
  allowfullscreen
></iframe>

### Advanced Refresh Examples

Cryptosheets custom functions allow infinite combinations of custom refresh setups including high frequency low interval time series with simultaneous technical indicator transformations!

![](https://res.cloudinary.com/cryptosheets/image/upload/v1588884141/cryptosheets-docs/quickcharts/indicators/rsi-refresh.gif)

### Troubleshooting

1. Check your formula syntax for carefully, different functions for the same data may have slightly different required syntax
2. Check the **required arguments** for your function vs the **optional arguments**
3. Check your data & API quotas and limits
4. Check your formulas carefully
5. Check your relative references
6. Use Excels **error checking tools**
7. Check [Excels help sections](https://support.office.com/en-us/article/function-arguments-65b29fb5-ec7b-4c0b-a54b-a67923571519)
8. Error Response Codes Reference

   - **#N/A** OK – Everything worked as expected
   - **#BUSY** Heavy query and/or unauthorized – Your User/Password API Keys are incorrect
   - **#LIMIT** Forbidden – You are not subscribed to the data feed requested
   - **Other** Something else? Reach out to us directly

Use the CS.TIME function for auto refresh at a set time interval

How to use TIME in Excel & Googlesheets

TIME