Examples

Practical ways to use CoinTable formulas in Google Sheets. Copy any example and customize it for your needs.

Portfolio Tracker

Track the value and daily change of your crypto holdings.

Formulas used: CT_PRICE, CT_CHANGE

Setup

  1. Column A: coin symbols (BTC, ETH, SOL)
  2. Column B: amount held (0.5, 10, 100)
  3. Column C: current price — =CT_PRICE(A2)
  4. Column D: total value — =B2*C2
  5. Column E: 24h change — =CT_CHANGE(A2)

Expected result

SymbolAmountPriceValue24h Change
BTC0.5$67,432.15$33,716.08-2.34%
ETH10$3,456.78$34,567.80+1.25%
SOL100$124.33$12,433.00+5.67%

Watchlist Dashboard

Monitor multiple coins with price, high, low, and daily change at a glance.

Formulas used: CT_PRICE, CT_HIGH, CT_LOW, CT_CHANGE

Setup

  1. Column A: coin symbols
  2. Column B: =CT_PRICE(A2)
  3. Column C: =CT_HIGH(A2)
  4. Column D: =CT_LOW(A2)
  5. Column E: =CT_CHANGE(A2)

Expected result

SymbolPrice24h High24h LowChange
BTC$67,432.15$68,100.00$66,800.00-2.34%
ETH$3,456.78$3,290.45$3,150.20+1.25%
DOGE$0.124$0.128$0.119+3.45%

Multi-Currency Comparison

Compare crypto prices in different fiat currencies.

Formulas used: CT_PRICE with currency parameter

Setup

  1. Row 1: currency headers (USD, EUR, GBP, JPY)
  2. Column A: coin symbols
  3. Each cell: =CT_PRICE(A2, B1) — where B1 is the currency code

Expected result

SymbolUSDEURGBPJPY
BTC$67,432€62,180£53,200¥10,114,800
ETH$3,457€3,188£2,729¥518,550

DCA Calculator

Track your dollar-cost averaging performance over time.

Formulas used: CT_PRICE

Setup

  1. Column A: purchase dates
  2. Column B: amount invested ($100 each time)
  3. Column C: price at purchase (manual entry or historical)
  4. Column D: coins bought — =B2/C2
  5. Column E: current value — =D2*CT_PRICE("BTC")
  6. Column F: profit/loss — =E2-B2

Expected result

DateInvestedBuy PriceCoinsCurrent ValueP/L
Jan 1$100$42,0000.00238$160.54+$60.54
Feb 1$100$48,0000.00208$140.26+$40.26
Mar 1$100$62,0000.00161$108.57+$8.57

Price Alerts Sheet

Use conditional formatting with CoinTable formulas to create visual price alerts.

Formulas used: CT_PRICE, CT_HIGH, CT_LOW

Setup

  1. Column A: coin symbols
  2. Column B: current price — =CT_PRICE(A2)
  3. Column C: alert threshold (high) — manually set your target
  4. Column D: alert threshold (low) — manually set your floor
  5. Column E: status — =IF(B2>=C2, "🔴 SELL", IF(B2<=D2, "🟢 BUY", "⚪ HOLD"))

Expected result

SymbolPriceSell AboveBuy BelowStatus
BTC$67,432$70,000$60,000⚪ HOLD
ETH$3,457$3,500$3,000⚪ HOLD
SOL$124$120$100🔴 SELL

Add conditional formatting to color the Status column for instant visual alerts.