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: COINTABLE with price and changepct

Setup

Column A: coin symbols (BTC, ETH, SOL)
Column B: amount held (0.5, 10, 100)
Column C: current price — =COINTABLE(A2)
Column D: total value — =B2*C2
Column E: 24h change — =COINTABLE(A2, "changepct")

Expected result

Symbol	Amount	Price	Value	24h Change (%)
BTC	0.5	$81,995.00	$40,997.50	0.16
ETH	10	$2,462.04	$24,620.40	2.87
SOL	100	$105.78	$10,578.00	1.07

Crypto portfolio tracker in Google Sheets: amount, price, value and 24h change for BTC, ETH and SOL — The same setup in a real sheet. Values as of October 16, 2026.

Watchlist Dashboard

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

Formulas used: COINTABLE with price, high, low and changepct

Setup

Column A: coin symbols
Column B: =COINTABLE(A2)
Column C: =COINTABLE(A2, "high")
Column D: =COINTABLE(A2, "low")
Column E: =COINTABLE(A2, "changepct")

Expected result

Symbol	Price	24h High	24h Low	Change (%)
BTC	$81,995.00	$82,816.00	$81,634.00	0.16
ETH	$2,462.04	$2,488.84	$2,393.83	2.87
DOGE	$0.0816	$0.0828	$0.0797	2.20

Crypto watchlist in Google Sheets with price, 24-hour high, low and change — The same setup in a real sheet. Values as of October 16, 2026.

Multi-Currency Comparison

Compare crypto prices in different fiat currencies.

Formulas used: COINTABLE with a pair

Setup

Row 1: currency headers (USD, EUR, GBP, JPY)
Column A: coin symbols
Each cell: =COINTABLE(A2&"/"&B1) — where B1 is the currency code

Expected result

Symbol	USD	EUR	GBP	JPY
BTC	$81,995	€72,827	£61,344	¥12,933,241
ETH	$2,462	€2,187	£1,841	¥388,455

Bitcoin and Ethereum prices in US dollars, euros, pounds and yen in Google Sheets — Each cell reads its currency code from row 1. Values as of October 16, 2026.

DCA Calculator

Track your dollar-cost averaging performance over time.

Formulas used: COINTABLE with price, and a date on Plus

Setup

Column A: purchase dates
Column B: amount invested ($100 each time)
Column C: price at purchase — type it in, or on Plus use =COINTABLE("BTC", "price", A2) for a date within the last year
Column D: coins bought — =B2/C2
Column E: current value — =COINTABLE("BTC")*D2
Column F: profit/loss — =E2-B2

Expected result

Date	Invested	Buy Price	Coins	Current Value	P/L
Jan 1	$100	$42,000	0.00238	$195.23	+$95.23
Feb 1	$100	$48,000	0.00208	$170.82	+$70.82
Mar 1	$100	$62,000	0.00161	$132.25	+$32.25

Bitcoin DCA calculator in Google Sheets: three $100 buys, coins bought, current value and profit — Buy prices are typed in by hand; only the current value comes from CoinTable. Values as of October 16, 2026.

Price Targets with Conditional Formatting

Use conditional formatting in Google Sheets with CoinTable formulas to flag coins that cross your price targets. The flags change when the prices in your sheet update; CoinTable doesn't send notifications.

Formulas used: COINTABLE with price

Setup

Column A: coin symbols
Column B: current price — =COINTABLE(A2)
Column C: upper threshold — manually set your target
Column D: lower threshold — manually set your floor
Column E: status — =IF(B2>=C2, "🔴 SELL", IF(B2<=D2, "🟢 BUY", "⚪ HOLD"))

Expected result

Symbol	Price	Sell Above	Buy Below	Status
BTC	$81,651	$90,000	$75,000	⚪ HOLD
ETH	$2,446	$2,400	$2,000	🔴 SELL
SOL	$105	$150	$110	🟢 BUY

Price targets in Google Sheets: each coin's price against a sell-above and buy-below level with a status column — Targets set for this example. Values as of October 16, 2026.

Add conditional formatting to color the Status column, so coins that crossed a target stand out at a glance.