Spreadsheet Portfolio Tracker Alternatives for UK Investors

A spreadsheet is the right tool for tracking a portfolio for about eighteen months. After that, depending on how active you are, the cracks start to show. Live prices stop refreshing reliably. Dividend reinvestments fall behind. The FX columns drift. The GBp/GBX confusion becomes a recurring bug. Eventually you realise you are spending more time maintaining the spreadsheet than thinking about your investments — which is the wrong direction.

This article looks at why home-built portfolio spreadsheets break for serious UK investors, what a tracker should automate, and which alternatives are worth considering. It is written for self-directed investors with an ISA, a SIPP and a GIA — the typical setup that exposes spreadsheet limits fastest.

This is not financial advice. Past performance does not guarantee future returns. Consider speaking to an FCA-authorised financial adviser for personalised guidance.

Why your spreadsheet keeps breaking

A spreadsheet that worked fine when you held five FTSE 100 stocks behaves differently once you add international ETFs, accumulating funds, multiple wrappers and dividend reinvestment. The breakages cluster around four pain points.

Live data is not actually live. Google Sheets' GOOGLEFINANCE function is the most common solution, and it is the most common source of frustration. It throws #N/A errors at random, returns stale prices outside US market hours, has gaps in coverage for UCITS ETFs (especially Irish-domiciled ones with IE00... ISINs), and often returns prices in the wrong currency without telling you. Excel's Stock data type is more reliable but has its own coverage gaps and only works with a Microsoft 365 subscription. Free third-party scraping add-ons exist but break every time the source site changes its HTML. The "live portfolio" you set up in a weekend ends up being live some of the time, on some assets, in some currencies.

FX is a quiet killer. A UK investor holding US-listed stocks, US-listed ETFs, UCITS ETFs priced in GBP, and direct UK equities priced in pence has at least four currency conversions to keep straight: USD-to-GBP, EUR-to-GBP for some funds, GBp-to-GBP for UK equities, and the implicit FX inside UCITS ETFs that hedge or do not hedge. A spreadsheet can do all of this; the problem is that you have to remember to do all of this. The first time you forget to apply the GBp-to-GBP factor on a UK equity, your spreadsheet thinks Lloyds Banking Group is trading at fifty pounds rather than fifty pence and your portfolio total looks great for half a day.

GBp versus GBX trips up almost everyone. UK equities are quoted in pence (GBp or GBX — the names are interchangeable, GBX is just a clarification). One pound equals one hundred pence. Most data sources return UK prices in pence; some return them in pounds; a few are inconsistent depending on the symbol. A spreadsheet that mixes a Lloyds price in pence (50.32) with a Vodafone price someone manually entered in pounds (0.7081) will produce nonsense at the portfolio level and you will not notice until a position you thought was £5,000 turns out to be £50.

Splits, consolidations, and dividend reinvestment. When a stock splits 2-for-1, your cost basis halves and your unit count doubles. When it consolidates 1-for-10, the opposite. When a fund pays a dividend that you reinvest, your unit count rises and the cost basis adjusts. None of this happens automatically in a home-built spreadsheet. You have to read your contract notes, work out what changed, and patch the rows. Miss a corporate action and your performance figures drift permanently — you do not just lose accuracy on that line, you lose it on the entire portfolio's IRR calculation.

A spreadsheet does not break catastrophically. It breaks gradually, in ways you do not always notice, until the day you compare its number to your broker's number and find a five-per-cent discrepancy with no obvious cause.

The hidden cost of spreadsheet maintenance

There is a labour cost as well. The honest accounting for a moderately complex UK portfolio in a spreadsheet looks like:

• Twenty minutes a week reconciling new transactions, reinvested dividends, and FX moves.
• An hour a month chasing down the things that did not auto-populate — a UCITS ETF that GOOGLEFINANCE cannot find, a corporate action that has not flowed through, a dividend that arrived in USD but needs to be recorded in GBP.
• Half a day a year doing the spring clean — fixing splits you missed, reconciling cost bases against your broker's records, rebuilding the IRR formula because someone (you) tweaked a column reference and broke it.

Call it 25 hours a year. At a notional £30/hour value of your time, that is £750 a year. The same time spent on actual investment thinking would, almost certainly, be worth more.

This is not an argument that everyone should pay for software. Plenty of investors run a spreadsheet for years and are happy with the trade-off — the spreadsheet is fully customisable, costs nothing, and you understand it because you built it. The argument is that if you are paying the time cost without being aware of it, you are not making a clean comparison against a £12-a-month tracker.

What a portfolio tracker should automate

A useful tracker takes the manual labour out of the four pain points above and adds a few things a spreadsheet cannot easily do.

The minimum bar:

1. Live prices that work. UK-listed equities in pence with proper unit handling. UCITS ETFs with their full ISIN coverage. Major US-listed stocks and ETFs in USD with FX to GBP. A good tracker handles this without you needing to think about it.
2. Automatic FX. Every position priced in GBP for the portfolio total, with the underlying native-currency price still visible if you want to see it.
3. Corporate action handling. Splits, consolidations, share-class consolidations, and ticker changes processed automatically, so your historical performance remains correct.
4. Dividend tracking. Cash dividends recorded as income; reinvested dividends recorded as additional units with adjusted cost basis. Both visible in a year-to-date income figure.
5. Wrapper segmentation. ISA, SIPP and GIA as first-class concepts, not generic "Account 1 / Account 2" labels. A view that totals across wrappers and a view that breaks them out.

The more useful bar adds:

6. Look-through into ETFs. The same underlying companies aggregated across all the funds you hold, so you can see real concentration rather than fund-level allocation.
7. Performance vs benchmark. Money-weighted (IRR) and time-weighted return, both of which are non-trivial to compute correctly in a spreadsheet, against a sensible benchmark you choose.
8. Tax-aware reporting. CGT-relevant disposals in your GIA, dividend tax reporting outside wrappers, ISA/SIPP allowance tracking. This is where mature tools earn their fee.
9. Multi-broker aggregation. A single view across the three or four platforms a typical UK investor uses. Without this, you are still doing reconciliation work — just inside someone else's UI.

Anything beyond that is a "nice to have" — AI analysis, rebalancing suggestions, tax-loss harvesting flags. They are useful, but only on top of a foundation that gets the basics right.

Connection methods: CSV, broker API, manual

There are three ways a tracker can pull your data, and the choice shapes how much maintenance you do.

CSV upload. You export trades from your broker as a CSV file and import them into the tracker. Pros: no shared credentials, you control what gets uploaded, works with every UK broker because they all support CSV export. Cons: you have to remember to do it. Most CSV-based trackers prompt you weekly or monthly. A good importer maps columns intelligently and handles the messy edges of broker exports (different schemas across Trading 212, AJ Bell, HL, Freetrade, Vanguard).

Broker API. The tracker connects directly to the broker's API and pulls trades automatically. Pros: hands-off, near-real-time. Cons: the UK has poor API coverage for retail brokers — Sharesight uses a mix of API integrations and email parsing because most UK platforms do not expose direct APIs. Trading 212 has an API. Interactive Brokers has one. AJ Bell, Hargreaves Lansdown, and Vanguard UK do not.

Manual entry. You type each trade in. Useful for one-off positions or non-standard assets (private investments, crypto held in cold storage, peer-to-peer loans). Painful for an active investor with dozens of trades a year.

In practice, most UK investors end up with a hybrid: API or CSV for the main brokers, manual entry for the long-tail accounts. The right tracker is one that handles all three without making any of them feel second-class.

UK-specific must-haves

Generic global trackers — including some well-marketed ones — do not handle UK-specific realities cleanly. The features that matter are:

ISA, SIPP and GIA wrapper distinction. An ISA shelters gains and dividends from UK tax. A SIPP shelters them too, with different access rules and contribution limits. A GIA does not — gains over the annual exempt amount are taxable, dividends over the personal allowance are taxable. A tracker that treats all three as "Account A / Account B / Account C" can tell you what you own; it cannot tell you the wrapper-level efficiency of where you own it.

GBp/GBX handling. UK equities priced in pence, with the conversion done correctly and consistently. A tracker that ever shows you a UK equity at "fifty pounds" when the market price is fifty pence has a bug.

Accumulating versus distributing share classes. UCITS funds come in both. An accumulating share class reinvests dividends inside the fund (no cash distribution; price drifts up). A distributing class pays cash dividends. A UK tracker should record income correctly on both, even though the accumulating version produces no broker-recorded dividend events — it has to be modelled from fund data.

Excess Reportable Income (ERI). Offshore UCITS funds held in a GIA can generate ERI — a notional dividend you have to declare on your Self Assessment even though no cash arrived. This is genuinely fiddly. Sharesight surfaces it; many other tools ignore it.

Annual exemption tracking. The CGT annual exempt amount is currently low (£3,000 for 2024–25, halved again from previous years). A GIA tracker should track realised gains against this allowance year-to-date.

A tracker built outside the UK can be retrofitted for some of this. None of them fit it as cleanly as a tracker built around it from the start.

Comparison: the leading options

The honest comparison: if your priority is UK CGT reporting and you have been with Sharesight for years, switching is not obvious — Sharesight's tax reports are still the most polished thing in the market. If you want UK tax wrapper awareness and ETF look-through and you do not need automatic broker sync, Invormed is the more appropriate fit and cheaper at the mid tier. If you mostly want pretty charts and dividend visualisation, Snowball or Delta will do it for less. If you only have one broker and never plan to add another, the native broker app is fine.

When a spreadsheet is still fine

Three situations where the spreadsheet is genuinely the right answer.

Few holdings, one broker, no FX. If you hold five UK-listed ETFs in a single ISA at one platform, a spreadsheet is not going to break. The only thing it will not give you that the broker app already gives you is performance versus a benchmark, which you can compute by hand once a year.

Highly idiosyncratic assets. Private company investments, structured products, syndicated loans, illiquid closed-ended funds. No off-the-shelf tracker will handle these well. A spreadsheet you control will.

You enjoy it. Some investors find building and maintaining the spreadsheet useful in itself — it forces engagement with the data, surfaces things they would not otherwise notice, and is a kind of journaling exercise. That is a valid reason to keep doing it. The argument against spreadsheets is not that they are wrong; it is that they take time, and most investors over-estimate how much they enjoy that maintenance.

Migrating off a spreadsheet without losing history

If you do decide to move, the migration is not as painful as it looks. The standard playbook:

1. Export your full transaction history from each broker. Almost every UK broker — Trading 212, AJ Bell, HL, Freetrade, Interactive Investor, Vanguard UK — supports CSV export of trades. Some require you to email support; most have it in account settings.
2. Reconcile your spreadsheet's current positions against the broker's actual positions. Before importing anything anywhere, make sure the spreadsheet you have been trusting is correct. The migration is not the time to discover a year-old missing dividend reinvestment.
3. Import to the new tool. Most trackers accept the broker's native CSV format; a few require a standardised template. Check the documentation for your specific broker.
4. Verify opening positions. Spot-check ten or so holdings — units, cost basis, current value — against the broker statement. Discrepancies usually mean a corporate action was handled differently in the spreadsheet versus the new tool. Resolve at the position level.
5. Keep the spreadsheet for a month. Run both in parallel for a month. If the tracker is doing its job, you will stop opening the spreadsheet within the first fortnight.

Most migrations take two to four hours of focused effort. Active investors with ten years of history budget more.

Frequently asked questions

What is wrong with using Google Sheets to track my portfolio?

Nothing, for a small simple portfolio. The problems show up at scale: GOOGLEFINANCE returns inconsistent prices for UCITS ETFs and outside US market hours; FX conversions have to be applied manually; GBp/GBX errors compound; and corporate actions like splits, consolidations and share-class changes are not handled automatically. For a UK investor with multiple wrappers and international holdings, the maintenance burden grows faster than the portfolio.

Why do live stock prices break in Google Sheets?

GOOGLEFINANCE depends on Google Finance's underlying data feed, which has gaps for non-US assets, returns prices in unpredictable currencies, and throws #N/A errors when the source is unavailable. UCITS ETFs (Irish-domiciled, IE00... ISINs) are particularly weak in coverage. The function is also rate-limited, so a sheet with hundreds of cells calling it can hit limits during heavy use. Excel's Stock data type is more reliable but requires Microsoft 365 and has its own gaps.

How do I handle GBp versus GBX in a spreadsheet?

GBp and GBX are the same thing — both refer to pence sterling, with GBX usually used to make explicit that prices are in pence rather than pounds. Most UK equity prices come back from data sources in pence. The standard fix in a spreadsheet is to multiply by 0.01 to get pounds, but this has to be applied consistently across every UK row and removed for the row that returns pounds directly (some sources do, most do not). Inconsistency is the most common source of wrong portfolio totals for UK investors.

Best free portfolio tracker UK?

For UK investors, the strongest free options are Snowball Analytics' free tier, Delta's free tier, JustETF's portfolio tools (especially for ETF-heavy portfolios), and Sharesight's free plan (limited to 10 holdings). Invormed offers a free tier at launch. Native broker apps — Trading 212, AJ Bell, HL — are free and adequate if you only use one broker. Beyond a handful of holdings, the free tiers start to feel limiting.

Should I just use my broker's app?

If you only use one broker and never plan to add another, yes. The native app shows live prices for your holdings, basic performance, dividend history, and tax-relevant reports for that account. The limit is that it cannot aggregate across brokers, will not look through ETFs to underlying companies, and usually has weak performance calculation versus a benchmark. Most UK investors end up holding across two or more brokers within a few years (separate ISA and SIPP providers is the common pattern), at which point a single broker app stops being sufficient.

How do I migrate from a spreadsheet without losing history?

Export the full transaction history from each broker as CSV (almost every UK broker supports this), reconcile the spreadsheet's positions against the broker statements before migrating, import the broker CSVs to the new tracker, and then verify position by position that units, cost bases and current values match. Run the spreadsheet and the new tool in parallel for a month before retiring the spreadsheet. Two to four hours is typical for a moderately complex portfolio.

Want to skip the spreadsheet entirely?

Invormed aggregates your ISA, SIPP and GIA, handles GBp correctly, looks through your ETFs to the underlying companies, and gives you an AI-powered view of what you actually own. Pro is £12/mo flat — no holdings caps. We are in early access — join the early-access waitlist and we will let you in as we open up.