CT_MARKETCAP
Get the total market capitalization of any cryptocurrency in Google Sheets. Understand relative coin size at a glance.
Syntax
=CT_MARKETCAP(symbol)
Parameters
| Parameter | Required | Description | Example |
|---|---|---|---|
symbol | Yes | Cryptocurrency ticker | "BTC" |
Examples
| Formula | Result | Description |
|---|---|---|
=CT_MARKETCAP("BTC") | $1,320,000,000,000 | Bitcoin market cap |
=CT_MARKETCAP("ETH") | $385,000,000,000 | Ethereum market cap |
=CT_MARKETCAP("SOL") | $58,000,000,000 | Solana market cap |
Common use cases
Compare market caps
Line up multiple coins and sort by market capitalization to see which projects carry the most weight.
=CT_MARKETCAP(A2)
Place tickers in column A and this formula in column B. Sort the sheet by column B descending for a quick leaderboard.
Track market dominance
Calculate any coin's share of the total crypto market by dividing its market cap by the sum of all tracked caps.
=CT_MARKETCAP("BTC") / SUM(B2:B20)
Format the cell as a percentage to see Bitcoin dominance (or any other coin) relative to your watchlist.
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 | Format cells as Number with abbreviated units or use =CT_MARKETCAP("BTC")/1e9 for billions |