CT_HIGH
Get the 24-hour high price for any cryptocurrency directly in Google Sheets. Track daily price peaks with a single formula.
Syntax
=CT_HIGH(symbol)
Parameters
| Parameter | Required | Description | Example |
|---|---|---|---|
symbol | Yes | Cryptocurrency ticker | "BTC" |
Examples
| Formula | Result | Description |
|---|---|---|
=CT_HIGH("BTC") | $68,100.00 | Bitcoin 24h high |
=CT_HIGH("ETH") | $3,290.45 | Ethereum 24h high |
=CT_HIGH("SOL") | $128.50 | Solana 24h high |
=CT_HIGH("ADA") | $0.62 | Cardano 24h high |
Common use cases
Daily range analysis
Combine 24h high and low to measure daily volatility. Wider ranges signal higher trading activity.
=CT_HIGH("BTC") - CT_LOW("BTC")
Express it as a percentage of current price:
=(CT_HIGH("BTC") - CT_LOW("BTC")) / CT_PRICE("BTC")
Set price alert thresholds
Use the 24h high as a breakout reference. If the current price approaches or exceeds the daily high, it may signal momentum.
| A | B | C | |
|---|---|---|---|
| 1 | Coin | 24h High | Current |
| 2 | BTC | =CT_HIGH("BTC") | =CT_PRICE("BTC") |
| 3 | ETH | =CT_HIGH("ETH") | =CT_PRICE("ETH") |
Add a column with =IF(C2 >= B2 * 0.99, "NEAR HIGH", "") to flag coins near their daily peak.
Troubleshooting
| Problem | Solution |
|---|---|
Returns #ERROR! | Check the ticker symbol spelling |
Returns N/A | This coin may not be in the free plan |
| High equals current price | The coin just set a new 24h high |
| Stale data | Press Ctrl+Shift+F9 to force refresh |