Crypto Portfolio Tracker for Investors | Google Sheets

This tracker was built for quick crypto tracking, simple enough for a complete beginner to open and understand right away, without needing to learn how any of the formulas work first. Price and market data come directly from cryptoprices.cc, and everything in the tracker is calculated and displayed in USD.

In the Transactions tab, you log the basics for each trade: date, ticker (BTC, ETH, or whichever coin), the number of coins, price, trade fees, and the exchange you used, Kraken, Bitstamp, or any other. From there, the tracker calculates everything else on its own: cumulative coins held, cumulative buys and sells, coin value, rolling average cost, and profit or loss on that coin, so none of that math is something you're doing by hand.

The Overview brings it all together in two parts. At the top, a summary box shows total cost, overall profit or loss, total ROI, plus your best and worst performing coins by ROI at a glance. Below that, a full table breaks it down coin by coin: ticker, coins purchased, USD spent, average buy price, coins sold, amount earned, average sale price, coins currently on hand, your invested amount, current price pulled from cryptoprices.cc, and each coin's all-time high.

Five automatically generated charts sit alongside the numbers, turning your holdings and performance into a visual view you can read instead of scanning rows in a table.

• Your files are available to download as soon as payment is confirmed, so you can start tracking your crypto portfolio right away; instant download items don't accept returns, exchanges, or cancellations.
• Built for Google Sheets.
• Enter your transactions and the tracker calculates cost basis, ROI, cumulative holdings, and profit or loss automatically.
• Live price data.
• All your holdings and transaction data stay within your own Google Sheets file, with nothing shared externally.

A unified overview brings every coin, trade, and total into one place, instead of checking balances across several exchanges and wallets separately.

Real-time tracking pulls current prices and all-time highs directly from cryptoprices.cc, so your numbers stay current without looking anything up manually.

Time-saving automation handles cost basis, ROI, and profit or loss calculations the moment you log a transaction.

For anyone hesitant to download a portfolio-tracking app and hand over exchange access, this works as a solid alternative that gives the same overview without connecting accounts to a third-party service.