CT_ATHCHANGE
Get the percentage change from a coin's all-time high directly in Google Sheets. Instantly see how far any cryptocurrency has fallen from its peak.
Syntax
=CT_ATHCHANGE(symbol)
Parameters
| Parameter | Required | Description | Example |
|---|---|---|---|
symbol | Yes | Cryptocurrency ticker | "BTC" |
Examples
| Formula | Result | Description |
|---|---|---|
=CT_ATHCHANGE("BTC") | -8.6% | Bitcoin is 8.6% below its ATH |
=CT_ATHCHANGE("ETH") | -34.5% | Ethereum is 34.5% below its ATH |
=CT_ATHCHANGE("SOL") | -52.1% | Solana is 52.1% below its ATH |
=CT_ATHCHANGE("BNB") | -15.2% | BNB is 15.2% below its ATH |
Common use cases
Find undervalued coins
Sort your portfolio by ATH change. Coins with the largest drawdown may offer the biggest recovery upside.
=SORT(B2:C20, 2, TRUE)
Place =CT_ATHCHANGE() in column C and sort ascending. The most beaten-down coins appear first.
Recovery tracker dashboard
Build a live dashboard that highlights coins approaching their ATH. Use conditional formatting to color-code recovery progress.
- Green: within 10% of ATH
- Yellow: 10-50% below ATH
- Red: more than 50% below ATH
Apply conditional formatting rules to cells containing =CT_ATHCHANGE() values.
Troubleshooting
| Problem | Solution |
|---|---|
Returns #ERROR! | Check the ticker symbol spelling |
Returns N/A | This coin may not be in the free plan |
| Value seems wrong | ATH change updates in real time as price moves |
| Stale data | Press Ctrl+Shift+F9 to force refresh |