CT_SUPPLY
Get live cryptocurrency supply data directly in Google Sheets. Pull circulating, total, or max supply for any supported coin in one formula.
Syntax
=CT_SUPPLY(symbol, [type])
Parameters
| Parameter | Required | Description | Example |
|---|---|---|---|
symbol | Yes | Cryptocurrency ticker | "BTC" |
type | No | Supply type: "circulating", "total", or "max". Defaults to "circulating" | "max" |
Examples
| Formula | Result | Description |
|---|---|---|
=CT_SUPPLY("BTC") | 19,700,000 | Bitcoin circulating supply |
=CT_SUPPLY("BTC", "max") | 21,000,000 | Bitcoin maximum supply cap |
=CT_SUPPLY("ETH") | 120,200,000 | Ethereum circulating supply |
=CT_SUPPLY("BTC", "total") | 19,700,000 | Bitcoin total supply |
=CT_SUPPLY("SOL", "circulating") | 410,300,000 | Solana circulating supply (explicit) |
Common use cases
Calculate fully diluted valuation
Multiply max supply by current price to get FDV. Useful for comparing projects at different supply stages.
=CT_SUPPLY("BTC", "max") * CT_PRICE("BTC")
Compare supply metrics
Build a dashboard comparing circulating vs. max supply. Spot coins with high inflation risk or limited remaining issuance.
=CT_SUPPLY("BTC") / CT_SUPPLY("BTC", "max")
This returns the percentage of total supply already in circulation.
Troubleshooting
| Problem | Solution |
|---|---|
Returns #ERROR! | Check the ticker symbol spelling |
Returns N/A | This coin may not be in the free plan |
max returns N/A | Some coins have no max supply cap (e.g., ETH) |
| Stale data | Press Ctrl+Shift+F9 to force refresh |
Related formulas
- CT_MARKETCAP — Get live market capitalization
- CT_PRICE — Get current coin price
- CT_RANK — Get CoinMarketCap ranking