Can I track my whole net worth in one Google Sheet?

Yes. With the free CryptoTrackPro add-on you price crypto with =cryptotrackpro("BTC-USD") and stocks, ETFs and commodities with =cryptotrackproRWA("AAPL") in the same sheet, then total them for one live net-worth figure with allocation and profit/loss.

Do I need an API key or code?

No. It's spreadsheet formulas only — install the add-on and type the formula. No API key, no scripts.

Build a Net-Worth Tracker with Stocks and Crypto in Google Sheets

Quick answer: price crypto with =cryptotrackpro("BTC-USD") and stocks with =cryptotrackproRWA("AAPL") in the same sheet, multiply by holdings, and total. Free, no API key — install CryptoTrackPro.

If you hold both shares and coins, your net worth is split across a brokerage app and a crypto app, and neither shows the whole picture. A single spreadsheet fixes that — and once the prices are live formulas, it maintains itself. Here's the build, step by step.

Step 1 — set up the columns

In a fresh sheet, make six columns: Asset · Type · Holdings · Price · Value · Weight. List your assets in column A (tickers) and how many you hold in column C.

Step 2 — price each row

This is the trick: crypto and stocks use two sibling formulas. In the Price column (D):

Crypto rows: =cryptotrackpro(A2 & "-USD")

Stock / ETF / gold rows: =cryptotrackproRWA(A2)

Tip: if you'd rather one formula figure it out, put the right one per row — crypto tickers get cryptotrackpro, everything else gets cryptotrackproRWA. (Stocks and commodities always use the RWA function — =cryptotrackpro("GOLD-USD") would return a coin named GOLD, not the metal.)

Step 3 — value, net worth and allocation

Value (E): =C2*D2 — drag down.
Net worth: =SUM(E2:E10).
Weight (F): =E2/$E$11, formatted as a percentage — now you can see crypto-vs-stocks split at a glance.

Step 4 (optional) — profit/loss

Add a Cost column with what you paid per unit. P&L is =E2-(C2*Cost). Don't remember an old buy price? =cryptotrackproPrice("BTC","2021-04-14") returns the price on any past date.

Skip the setup

Grab the ready-made free investment tracker, or one-click the Portfolio template from the add-on sidebar.

Install CryptoTrackPro free

FAQ

Does it update automatically?

Prices refresh on their own; turn on auto-refresh in the sidebar (every 30 min on Base, 5 min on Pro).

Can I track in GBP or EUR?

Yes — =cryptotrackpro("BTC-GBP") or =cryptotrackproRWA("AAPL-EUR").

Written by the CryptoTrackPro team. We build market-data tools for Google Sheets, used by hundreds of investors and analysts worldwide. Prices come from CoinMarketCap and established on-chain issuers — not guesswork. More about us →

← Back to the blog

Build a net-worth tracker — stocks + crypto