How to track your stock portfolio properly (without a spreadsheet)

Checking your broker app is not tracking your portfolio. The five-step method — and why spreadsheets hit a wall.

Most retail investors believe they track their portfolio because they open their broker app every day. What they actually watch is a slice of it: stocks with one broker, an ETF plan somewhere else, crypto on an exchange, some idle cash. Nobody sees the total — let alone what that total is exposed to.

Here is the full method — the one professional managers apply, scaled down to an individual investor. You can follow it by hand. You will also see, honestly, where doing it by hand stops working.

Step 1 — Consolidate: one list of positions

The starting point is not a chart, it is an inventory: for every position, wherever it lives — ticker, quantity, cost basis and currency. Every line of every account in a single list: stocks, ETFs, crypto, bonds and cash included.

The classic trap: exporting a snapshot of positions instead of the transaction history. Without dated buys and sells you cannot rebuild an exact cost basis — so you cannot know your true performance since purchase. If your broker offers an “account statement” or “history” export, that is the one you want.

Step 2 — Price everything daily, in one currency

An Apple line in dollars, an ETF in euros, some bitcoin: adding values across three currencies is meaningless. Proper valuation needs, every day: each position's closing price, conversion at today's FX rate, and a sum in your reference currency. It is mechanical — and it is exactly the kind of mechanical work people abandon three weeks into a hand-built spreadsheet.

Step 3 — Measure risk, not just performance

This is the step almost everyone skips, and it is the one that matters most. Performance tells you what happened; risk tells you what can happen to you. Four measures are enough to start:

• Volatility — how widely your portfolio swings, annualised. Two portfolios up 8% have nothing in common if one oscillates ±5% and the other ±40%.
• 95% VaR — the daily loss you historically exceed only 5% of days. A concrete answer to “how much can I lose on a bad day?”.
• Maximum drawdown — the worst fall from a peak. It is what makes people sell at the bottom when they never anticipated it.
• Correlations — do your holdings move up and down together? Fifteen lines that move as one protect you no more than two would. We wrote a whole article about that trap.

Step 4 — Track the real cash flows: dividends and fees

A portfolio is alive: it pays dividends and it bleeds fees (commissions, FX conversion, ETF expense ratios). Over ten years these flows often matter more than stock-picking skill. Tracking them means knowing what your money pays you back — and what is being taken from it.

Step 5 — Review on a fixed schedule

Useful tracking is not checking prices ten times a day — it is a short ritual at a fixed cadence: once a week, the same questions. What changed in my weights? Did my risk move? Has one position grown enough to dominate the portfolio? Ten minutes is enough when the numbers are already computed.

Excel or Google Sheets: how far does it go?

Many investors start with a spreadsheet, and it is a healthy reflex: free, transparent, fully under your control. Here is, honestly, how it holds up step by step:

The real cost of a spreadsheet is not the time to build it, it is erosion: a formula breaks silently, a price feed stops updating, and three months later you are steering with stale numbers you believe are fresh. A wrong figure displayed with confidence is worse than no figure at all.

What a dedicated tool changes

Automating these five steps is exactly why OplynQ exists: import your broker statements (19 formats parsed — CSV, PDF, Excel, OFX) or connect accounts read-only, and the cockpit consolidates, prices everything daily, computes volatility, 95% VaR, drawdown and correlations, tracks dividends and fees — and an AI copilot answers questions about your portfolio, with the numbers to back it up.