CT_RANK
Get the global market cap ranking of any cryptocurrency. See exactly where a coin stands among thousands of projects.
Syntax
=CT_RANK(symbol)
Parameters
| Parameter | Required | Description | Example |
|---|---|---|---|
symbol | Yes | Cryptocurrency ticker | "BTC" |
Examples
| Formula | Result | Description |
|---|---|---|
=CT_RANK("BTC") | 1 | Bitcoin is ranked #1 by market cap |
=CT_RANK("ETH") | 2 | Ethereum is ranked #2 by market cap |
=CT_RANK("SOL") | 5 | Solana is ranked #5 by market cap |
Common use cases
Sort portfolio by rank
Add a rank column to your portfolio sheet and sort by it. This keeps your largest, most established holdings at the top.
=CT_RANK(A2)
Place tickers in column A and this formula in column B. Sort ascending so rank 1 appears first.
Track rank changes over time
Record daily snapshots of rank to see if a coin is climbing or falling in the global leaderboard.
=CT_RANK("SOL")
Paste the value (Ctrl+Shift+V) into a dated row each day. Over weeks you will see the trend. A rising rank signals growing market confidence.
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 |
| Unexpected rank | Rankings update in real time and shift as market caps change |
Related formulas
- CT_MARKETCAP — Get the market cap behind the ranking
- CT_PRICE — Get the current price for any coin
- CT_VOLUME — Get 24-hour trading volume