cryptoc

Home / Guides

How to track a crypto portfolio manually

No API keys, no wallet connections. A few fields per coin and a habit of updating after each trade.

Updated

To track a crypto portfolio manually, record each coin you hold with its amount, and optionally its average buy price and where it is held, in a tracker app or a spreadsheet. The app or sheet multiplies your amounts by current prices to give total value and profit and loss. You update the amounts yourself after every buy, sell or transfer, which takes a minute and needs no exchange API keys or wallet connections.

Why track manually at all?

Automatic trackers read your balances through exchange API keys and wallet addresses. That saves typing, but it means handing those keys and addresses to a third party, and sync can break when an exchange changes its API. Manual tracking is:

  • Private. No keys, no addresses, nothing linking your holdings to an account.
  • Complete. It covers coins anywhere: exchanges, hardware wallets, a friend holding some for you, an exchange that no tracker supports.
  • Under your control. The numbers are what you entered, so there are no duplicated balances from a transfer counted twice.

It is weaker when you trade often. Ten trades a day is a lot to type, and then automatic sync, or importing exchange exports into a tax tool, is the better choice.

What do I need to record for each coin?

FieldRequiredWhy
CoinYesTo fetch its price
AmountYesValue = amount times price
Average buy priceOptionalNeeded for all-time profit and loss
Where it is heldOptionalSo you can reconcile with each exchange or wallet
Date and price of each tradeOptionalOnly if you need realized gains or tax figures

If you hold the same coin in two places, you can keep two entries ("BTC, Ledger" and "BTC, exchange") or one combined entry. Two entries make reconciling easier.

How do I set it up, step by step?

  1. Collect your balances. Log in to each exchange and open each wallet app, and write down the amount of every coin. Include small balances only if they matter to you.
  2. Work out average buy prices from your purchase history, if you want profit and loss: total spent including fees, divided by total coins bought. The profit and loss guide has a worked example.
  3. Pick the tool. A tracker app fetches prices, draws charts and can show the total in a widget. A spreadsheet gives full control and per-trade history but needs a price source.
  4. Enter each holding with the coin, amount, average buy price and a note for where it is.
  5. Set your currency to the one you think in, so values and profit are in EUR, USD or whatever you use.
  6. Back it up. For an app, turn on the phone's backup. For a spreadsheet, keep it in a place that is backed up.

How do I keep it up to date?

The rule is simple: update when coins move, not when prices move.

  1. After a buy: add the amount, and recompute the average buy price: (old amount times old average plus new cost) divided by new amount.
  2. After a sell: reduce the amount. Under the average cost method the average buy price stays the same.
  3. After a transfer between your own accounts: move the amount from one entry to the other, minus the network fee. The cost does not change.
  4. After staking rewards or airdrops: add the coins when you receive them.
  5. Once a month or quarter: compare each entry with the real balance and fix any difference.

Where does cryptoc fit?

cryptoc is a manual tracker by design. You enter the coin, the amount, an optional average buy price and an optional note such as "Ledger" or "Bybit". It needs no account, no exchange API keys and no wallet connection, and the portfolio stays on your device, backed up by your own iCloud or Google Drive backup. It shows total value, profit and loss over 24 hours, 180 days and all time, an allocation chart, and home screen widgets for the portfolio and for prices. The free version holds 3 holdings; Pro holds more.

It does not import CSV files, track DeFi or NFT positions, or produce tax reports, so if your tracking needs go there, a spreadsheet with one row per trade or a dedicated tax tool fits better. For coins on a hardware wallet, see how to track a cold wallet.

Questions

Is it better to track crypto manually or with exchange sync?

Manual tracking suits people who buy and hold a few coins and care about privacy. Automatic sync suits active traders with many transactions across several exchanges, or anyone who needs tax reports.

What should I record for each coin?

At minimum the coin and the amount. Add the average buy price if you want profit and loss, and a note for where it is held, such as an exchange name or "cold wallet".

Can I track crypto in Google Sheets or Excel?

Yes. Keep one row per coin with amount and average buy price, and fill in the current price by hand or with a price function or add-on. It works, but a tracker app fetches prices for you and shows charts and widgets.

How do I handle staking rewards when tracking manually?

Add the rewarded coins to the amount when they arrive. They raise your holdings at no purchase cost, so if you keep an average buy price, recompute it with the rewards counted at zero cost or at their value on receipt, depending on how you want to measure.