=CS.ATH

Use Case Scenarios

ATH - Syntax

Function arguments

Function argume...

PARAMETERS - Ab...

ATH - Examples

Troubleshooting


## =CS.ATH

In its simplest form, the ATH function says to get data about

```
=CS.ATH(what base asset, what quoted asset, all time statistics from what source)
```

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

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

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

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

### Use Case Scenarios

`When you need detailed statistics about all time highs and lows for a crypto asset`

---

## ATH - Syntax

### Function arguments

Arguments: `=CS.ATH("base","quote","source","args")`

Example Values: `=CS.ATH("BTC","USD","Coinbase","")`

### Function argument descriptions

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

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

- **base**: The base asset symbol [string] optional
- **quote**: The quote asset symbol [string] optional
- **source**: Name of the exchange or provider [string] optional
- **args**: Optional: Global arguments, ex. limit, fields [any] optional

### PARAMETERS - Absolute vs. Relative

**Absolute Parameter Values**

Formulas using **absolute values** for arguments with multiple parameters must be referenced inside an array using `{"curly_brackets"}` and will look like this:

`=CS.ATH("BTC","USD","Coinbase","")`

**Relative Parameter Values**

Formulas using **referenced values** for arguments with multiple parameters must be referenced inside an array using a defined range and will look like this _(\*Note - `{"curly_brackets"}` are NOT required when using referenced values)_:

`=CS.ATH("A1","A2","A3","")`

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

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

[Click here](https://app.cryptosheets.com/#/browse) to search for data providers and endpoints

---

## ATH - Examples

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

**Example 1:**

> `=CS.ATH("BTC")`

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

**Example 2:**

> **`=CS.ATH("BTC","USD")`**

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

**Example 3:**

> **`=CS.ATH(,,"Coinbase")`**

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

### 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**


Use the ATH function to get statistics for all time high & low prices, volumes and more for any pair and exchange