CT_ATH

Get the all-time high price for any cryptocurrency directly in Google Sheets. One formula returns the historical peak price in USD.

Syntax

=CT_ATH(symbol)

Parameters

ParameterRequiredDescriptionExample
symbolYesCryptocurrency ticker"BTC"

Examples

FormulaResultDescription
=CT_ATH("BTC")$73,750.07Bitcoin all-time high price
=CT_ATH("ETH")$4,891.70Ethereum all-time high price
=CT_ATH("SOL")$260.06Solana all-time high price
=CT_ATH("BNB")$720.67BNB all-time high price

Common use cases

Track distance from ATH

Compare current price to the peak. See how far each coin is from its record high.

=(CT_PRICE("BTC") - CT_ATH("BTC")) / CT_ATH("BTC")

Format the cell as a percentage to see the drawdown at a glance.

Historical peak comparison

Build a table of ATH prices across your portfolio. Quickly spot which coins have the most recovery potential.

ABC
1CoinATHCurrent
2BTC=CT_ATH("BTC")=CT_PRICE("BTC")
3ETH=CT_ATH("ETH")=CT_PRICE("ETH")

Troubleshooting

ProblemSolution
Returns #ERROR!Check the ticker symbol spelling
Returns N/AThis coin may not be in the free plan
Stale dataPress Ctrl+Shift+F9 to force refresh