Most tools do one or the other. CryptoTrackPro prices shares, ETFs and gold and 10,000+ coins from a single add-on — so your whole net worth lives in one sheet.
If you hold both crypto and traditional assets, you've probably juggled two systems: GOOGLEFINANCE (or a broker export) for stocks, and a separate crypto tracker for coins. Neither shows the full picture. CryptoTrackPro closes that gap — one add-on that prices both asset classes with two sibling formulas, so a single spreadsheet can hold your entire portfolio.
Install the free CryptoTrackPro add-on. Crypto uses one formula, stocks and commodities use its sibling:
=cryptotrackpro("BTC-USD") → live Bitcoin price
=cryptotrackproRWA("AAPL") → live Apple share price
Same add-on, same syntax pattern. Swap the ticker for any of 10,000+ coins or 700+ tokenized stocks, ETFs and commodities — Nvidia (NVDA), Tesla (TSLA), the S&P 500 ETF (SPY), Gold (GOLD).
The payoff is a single total across both worlds. Lay it out like this:
| Asset | Qty | Price formula | Value |
|---|---|---|---|
| BTC | 0.5 | =cryptotrackpro("BTC-USD") | =B2*C2 |
| AAPL | 20 | =cryptotrackproRWA("AAPL") | =B3*C3 |
| GOLD | 3 | =cryptotrackproRWA("GOLD") | =B4*C4 |
| Net worth | =SUM(D2:D4) |
Every row revalues automatically as prices move. Add an allocation column (=D2/$D$5) to see what share of your net worth sits in crypto versus stocks — the view no single-asset tracker gives you.
Both formulas take a currency. Append it to the pair for crypto, or to the ticker for stocks:
=cryptotrackpro("ETH-GBP") · =cryptotrackproRWA("AAPL-EUR")
Free plan, 50 lookups a day. No API key, no card.
Install CryptoTrackPro freeYes — that's the whole point. One add-on prices both, so there's no exporting, no second tool, and no manual updates.
Only a handful of major coins, and it's often delayed or returns errors. If crypto is part of your portfolio, see our GOOGLEFINANCE alternative guide.
Yes — 50 lookups a day on the free plan, shared across crypto and stocks. Base and Pro raise or remove the limit.
See also: stock & commodity prices → · portfolio tracker guide → · GOOGLEFINANCE alternative →