CT_CHANGE
Get percentage price changes for any cryptocurrency over multiple time periods. Spot trends at a glance in your spreadsheet.
Syntax
=CT_CHANGE(symbol)
=CT_CHANGE(symbol, period)
Parameters
| Parameter | Required | Description | Example |
|---|---|---|---|
symbol | Yes | Cryptocurrency ticker | "BTC" |
period | No | Time period (default: "24h") | "7d" |
Supported periods: "1h", "24h", "7d", "30d".
Examples
| Formula | Result | Description |
|---|---|---|
=CT_CHANGE("BTC") | -2.34% | Bitcoin 24-hour price change |
=CT_CHANGE("ETH", "7d") | +12.5% | Ethereum 7-day price change |
=CT_CHANGE("SOL", "30d") | +45.2% | Solana 30-day price change |
Common use cases
Daily market scanner
Build a dashboard that shows 24-hour changes for your watchlist. Pair with conditional formatting to highlight winners in green and losers in red.
=CT_CHANGE(A2, "24h")
Put tickers in column A and this formula in column B. Apply a conditional format rule: green if > 0, red if < 0.
Weekly performance report
Compare short-term and long-term momentum side by side.
=CT_CHANGE(A2, "7d")
=CT_CHANGE(A2, "30d")
Place the 7-day change in column C and the 30-day change in column D. Coins with strong performance in both columns signal sustained momentum.
Troubleshooting
| Problem | Solution |
|---|---|
Returns #ERROR! | Check the ticker symbol spelling |
Returns N/A | This coin may not be in the free plan |
| Stale data | Press Ctrl+Shift+F9 to force refresh |
| Invalid period | Use one of: "1h", "24h", "7d", "30d" |
Related formulas
- CT_PRICE — Get the current price for any coin
- CT_ATH — Fetch the all-time high price
- CT_ATHCHANGE — Percentage change from all-time high