CT_LOW
Get the 24-hour low price for any cryptocurrency directly in Google Sheets. Spot daily bottoms and track support levels with one formula.
Syntax
=CT_LOW(symbol)
Parameters
| Parameter | Required | Description | Example |
|---|---|---|---|
symbol | Yes | Cryptocurrency ticker | "BTC" |
Examples
| Formula | Result | Description |
|---|---|---|
=CT_LOW("BTC") | $66,800.00 | Bitcoin 24h low |
=CT_LOW("ETH") | $3,150.20 | Ethereum 24h low |
=CT_LOW("SOL") | $122.10 | Solana 24h low |
=CT_LOW("ADA") | $0.58 | Cardano 24h low |
Common use cases
Calculate daily volatility
Measure the daily price range as a percentage. Higher values mean more volatile trading days.
=(CT_HIGH("BTC") - CT_LOW("BTC")) / CT_LOW("BTC") * 100
Build a volatility column across your watchlist to compare coins side by side.
Buy-the-dip tracker
Track how close the current price is to the daily low. A small gap may signal a buying opportunity.
=(CT_PRICE("BTC") - CT_LOW("BTC")) / CT_LOW("BTC")
Use conditional formatting to highlight coins trading within 1% of their daily low:
- Green: within 1% of 24h low
- Yellow: within 5% of 24h low
- Neutral: more than 5% above 24h low
Troubleshooting
| Problem | Solution |
|---|---|
Returns #ERROR! | Check the ticker symbol spelling |
Returns N/A | This coin may not be in the free plan |
| Low equals current price | The coin just set a new 24h low |
| Stale data | Press Ctrl+Shift+F9 to force refresh |