ATH

=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

image

image

image

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

image

  • 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

image

Click here 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

Example 2:

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

image

Example 3:

=CS.ATH(,,"Coinbase")

image

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