Short, practical guides for tracking cryptocurrency in a spreadsheet — prices, history, tax and more. No API keys, no code.
Build one crypto portfolio in euros and pounds with working Google Sheets formulas, currency controls, position values and clear refresh settings.
Look up a historical crypto price using an ISO date or a date cell, avoid date-format errors, and keep daily reference values separate from trade records.
Add daily crypto RSI to Google Sheets with a working 14-period formula, configurable periods, quote currencies, error handling and clear Kraken coverage limits.
Build daily MACD columns in Google Sheets with exact line, signal and histogram formulas, a worked example and clear limits on timeframe and market coverage.
Import up to 365 daily crypto candles into Google Sheets, handle spill ranges, inspect incomplete candles, calculate returns and export a reviewed CSV snapshot.
Diagnose stale CryptoTrackPro prices in Google Sheets with account, formula, quota, refresh-scope and cache checks before rebuilding your spreadsheet.
The one-formula method for live Bitcoin, Ethereum and 10,000+ prices — no API key. Start here.
The best free way to get crypto into a spreadsheet: one formula, no API key, 10,000+ coins.
Honest 2026 comparison vs CoinGecko for Sheets, CoinTable, Cryptosheets, CryptoFinance and GOOGLEFINANCE.
Build a price and market-data watchlist, then add RSI for supported markets with Base or Pro.
Organise transactions and look up historical reference prices. Keep actual fills and fees from your exchange records.
Live and historical BTC prices — dollars, euros, sats — with one formula. No API key.
Holdings, live value, allocation and profit/loss that update themselves — or use the one-click template.
Live and historical ETH prices, the ETH/BTC ratio, and any currency — one formula.
Tokenized stocks — Apple, Nvidia, Tesla and more — alongside your crypto.
One free template for your whole portfolio — live value, allocation and P&L across stocks, ETFs, gold and coins.
One sheet, both worlds — shares, ETFs, gold and 10,000+ coins in a single net-worth dashboard.
700+ tokenized stocks, ETFs and commodities — one formula for all of them.
SPY, QQQ, VTI, GLD and more — live tokenized ETF prices, one formula.
Live gold & silver prices, plus precious-metal ETFs — one formula.
GOOGLEFINANCE is great for stocks but weak on crypto. See how to get both — reliably — in one sheet.
Comparing crypto add-ons? An honest look at where CryptoTrackPro fits — no API key, free to start.
Weighing CryptoFinance? See how a simpler, one-formula add-on compares.
Every formula, installation steps, permissions and troubleshooting in one place.