CT_VOLUME
Fetch the 24-hour trading volume for any cryptocurrency. High volume signals strong market interest and liquidity.
Syntax
=CT_VOLUME(symbol)
Parameters
| Parameter | Required | Description | Example |
|---|---|---|---|
symbol | Yes | Cryptocurrency ticker | "BTC" |
Examples
| Formula | Result | Description |
|---|---|---|
=CT_VOLUME("BTC") | $28,500,000,000 | Bitcoin 24h trading volume |
=CT_VOLUME("ETH") | $15,200,000,000 | Ethereum 24h trading volume |
=CT_VOLUME("SOL") | $2,800,000,000 | Solana 24h trading volume |
Common use cases
Identify trending coins
Sort your watchlist by volume to spot coins with unusual trading activity. A sudden volume spike often precedes a price move.
=CT_VOLUME(A2)
Place tickers in column A and this formula in column B. Sort descending to see the most actively traded coins first.
Volume-weighted analysis
Calculate the volume-to-market-cap ratio to gauge relative trading activity. A higher ratio means more turnover relative to the coin's size.
=CT_VOLUME(A2) / CT_MARKETCAP(A2)
Format as a percentage. Coins above 10% daily turnover are unusually active.
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 |
| Very large numbers | Use =CT_VOLUME("BTC")/1e9 and label the column "Volume (B)" for readability |
Related formulas
- CT_MARKETCAP — Get market capitalization for any coin
- CT_PRICE — Get the current price for any coin
- CT_HIGH — Fetch the 24-hour or all-time high price