CT_PRICE
Pull live cryptocurrency prices directly into your Google Sheets cells. One formula, any coin, any fiat currency.
Syntax
=CT_PRICE(symbol)
=CT_PRICE(symbol, currency)
Parameters
| Parameter | Required | Description | Example |
|---|---|---|---|
symbol | Yes | Cryptocurrency ticker | "BTC" |
currency | No | Fiat currency code (default: "USD") | "EUR" |
Supported currencies include USD, EUR, GBP, JPY, AUD, CAD, CHF, and 20+ more.
Examples
| Formula | Result | Description |
|---|---|---|
=CT_PRICE("BTC") | $67,432.15 | Bitcoin price in USD |
=CT_PRICE("ETH", "EUR") | €3,201.48 | Ethereum price in euros |
=CT_PRICE("SOL", "GBP") | £124.33 | Solana price in British pounds |
Common use cases
Track a single coin
Monitor any cryptocurrency price that updates automatically. Just type the formula and the cell stays current.
=CT_PRICE("BTC")
Build a portfolio tracker
Combine CT_PRICE with your holdings to calculate portfolio value in real time.
=B2 * CT_PRICE(A2)
Place your ticker in column A, quantity in column B, and this formula in column C. Copy it down for every row. Your total portfolio value is a simple =SUM(C:C) away.
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 |
| Wrong currency | Make sure the currency code is a valid ISO 4217 string, e.g. "EUR" |
Related formulas
- CT_CHANGE — Track price changes over 1h, 24h, 7d, or 30d
- CT_MARKETCAP — Get market capitalization for any coin
- CT_HIGH — Fetch the all-time or 24h high price