CryptoTrackPro is a Google Sheets™ add-on that brings live cryptocurrency prices and professional-grade technical indicators straight into your spreadsheets—no scripts, no manual imports, no API keys.

Just one formula to get started:
=cryptotrackpro("BTC-USD")

Use any crypto-to-crypto or crypto-to-fiat pair—BTC-USD, ETH-EUR, SOL-BTC, DOGE-USDT, ADA-GBP and more. 1,000+ assets and 150+ quote currencies supported.

▌ Formulas included
• =cryptotrackpro("BTC-USD") — live price, any pair
• =cryptotrackproChange("BTC") — 24-hour % change
• =cryptotrackproData("BTC", "marketcap") — market cap, volume, rank, 7d change
• =cryptotrackproPrice("BTC", "2025-01-01") — historical closing price on any date (great for cost basis & tax)
• =cryptotrackproRSI("BTC", 14) — Relative Strength Index (Base & Pro)
• =cryptotrackproMACD("BTC", "line") — MACD line, signal, or histogram (Base & Pro)
• =cryptotrackproHistory("BTC", 30) — 30-day OHLCV table: date, open, high, low, close, volume (Base & Pro)

▌ Why professionals choose CryptoTrackPro
• Clean integration — one formula per cell, sidebar for quick inserts; nothing else to maintain.
• Auto-refresh — Base plan refreshes every 30 minutes; Pro plan every 5 minutes. Dashboards stay current without manual work.
• Technical analysis in Sheets™ — RSI, MACD and full OHLCV history without leaving your spreadsheet.
• Historical prices for tax — look up any coin's closing price on any past date, permanently cached.
• Low-latency feed — prices sourced from CoinMarketCap's institutional API.
• Transparent quotas — FREE (50/day), BASE (500/day), PRO (Unlimited). Remaining calls shown live in the sidebar.
• Strict data handling — only your email, plan tier and daily usage count are stored. Sheet contents stay private.

▌ Typical use cases
• Intra-day portfolio P&L that auto-refreshes without manual work.
• RSI and MACD dashboards for technical traders who live in Google Sheets™.
• Cost-basis and capital gains calculations using historical closing prices.
• Risk models combining crypto prices with FX and equity data.
• Client-facing dashboards that refresh automatically ahead of meetings.

▌ Get started in three steps
1. Install the add-on and open any Google Sheet.
2. Extensions → CryptoTrackPro → Open Sidebar (one-click setup).
3. Type =cryptotrackpro("BTC-USD") in any cell, or use Insert Formula in the sidebar. Enable auto-refresh to keep prices updating automatically.

▌ Roadmap
Upcoming releases will add:
• Order-book depth, derivatives and funding rates
• On-chain and DeFi metrics
All delivered through the same familiar formula interface.

Bring live prices, technical indicators and historical data into the models and dashboards you already trust. Install CryptoTrackPro and keep Google Sheets™ in sync with the market.

Crypto prices in Google Sheets™, RSI in Google Sheets™, MACD indicator spreadsheet, cryptocurrency portfolio tracker, bitcoin spreadsheet, CoinMarketCap API, live crypto data, real-time crypto prices, Google Sheets™ add-on. For more information, visit cryptotrackpro.com.

Google Sheets™ is a trademark of Google LLC. CryptoTrackPro is not affiliated with Google LLC.

Crypto prices in Google Sheets™, RSI in Google Sheets™, MACD Google Sheets™, cryptocurrency portfolio tracker, bitcoin spreadsheet, CoinMarketCap API, live crypto data, real-time crypto prices, Google Sheets™ add-on, crypto technical analysis, OHLCV history spreadsheet, altcoin price feed, automated crypto dashboard