Freetrade Portfolio Tracker: Track Your Freetrade Investments Beyond the App
How to track a Freetrade portfolio properly: export your activity from the app as a CSV, import it, and see performance against a benchmark, dividend income, sector concentration and a Reward and Risk score on every holding.
On this page (8)
Freetrade made investing feel simple: a clean app, commission-free dealing, fractional shares and a low-cost route into an ISA or SIPP. The trade-off is that the app is built for buying and holding, not for analysis. If you want a Freetrade portfolio tracker that tells you how your whole portfolio has done against an index, what it pays you in dividends, how concentrated you are and where the risk sits, you need to get your data out. Freetrade makes that easier than most: the activity export is three taps in the app, and the file it produces is one of the cleanest among UK brokers. This guide covers the export, the file, and the analysis you can build on it.
What the Freetrade App Shows, and What It Does Not
The app gives you portfolio value, a chart of that value over time, and each position's gain or loss since purchase. That is more than some brokers offer, but it stops short of the questions that matter.
- No benchmark. The value chart shows the line going up or down. It does not show the FTSE All-Share or the S&P 500 next to it, so you cannot tell whether your picks earned their keep.
- No income view. Dividends appear in your activity feed one at a time. There is no view of income by month, by holding, or of the yield on what you paid.
- No concentration or risk view. A portfolio that is half US tech and a quarter one company looks the same as a diversified one on the app's chart.
- Accounts stay separate. A general account, an ISA and a SIPP are three portfolios in the app, never one.
How to Export Your Freetrade Data
Freetrade has no public API, but its activity export is quick and complete.
- In the Freetrade app, open the Activity tab at the bottom of the screen.
- Tap the export / share arrow in the top-right corner.
- Confirm All Activity and export the CSV to your device. Save it somewhere you can find it, or share it straight to your computer.
- Repeat for each account (general, ISA, SIPP) if you hold more than one.
The export contains every order, dividend, deposit and withdrawal, with a timestamp, the ticker, whether it was a buy or sell, the quantity and the price per share. Two things make the Freetrade file friendlier than most. It carries a ticker for every holding, so matching to a listed security is reliable. And prices are in pounds, not pence, unlike Hargreaves Lansdown, AJ Bell or interactive investor, so a spreadsheet does not need a conversion column and there is no hundred-times valuation trap to fall into.
Skip the spreadsheet
Import your Freetrade CSV straight into Openbook
Upload the file as it downloaded. Openbook reads the Ticker, Buy / Sell, Quantity, Timestamp and Price per Share columns automatically, keeps prices in pounds, and shows you what it read before anything is saved. Verified against a real Freetrade export.
Building a Freetrade Spreadsheet
Because the file has tickers and pounds prices, a Freetrade spreadsheet is about as easy as a DIY tracker gets.
- Paste the export into a sheet and keep the timestamp, ticker, buy/sell, quantity and price columns.
- Turn sells into negative quantities, then use a pivot table summing quantity by ticker to get current positions.
- Add a price lookup per ticker and multiply out for current value.
- Pivot the dividend rows by month for an income history.
- If you hold more than one account, add a summary tab that combines tickers across them.
Fractional shares are handled naturally: quantities are simply decimals. The usual spreadsheet limits still apply. It has to be rebuilt after every export, and a benchmark, a dividend calendar and any measure of risk are all things you have to add yourself. Our guide to portfolio trackers for UK investors is honest about when that stops being worth the time.
What a Dedicated Tracker Shows That Freetrade Cannot
- Performance against a benchmark for the whole portfolio, and per account, over one, three and five years.
- Income by month and by holding, with yield on the price you paid. Freetrade investors with a dividend tilt will want our dividend tracker guide alongside this.
- Concentration by sector, country and company. Freetrade portfolios are often heavier in US technology and a handful of well-known names than their owners expect.
- Reward and Risk on every holding. Openbook scores UK and US-listed companies on Growth, Momentum, Profitability and Valuation for Reward, and Volatility, Financial Solvency, Operational Quality and Size for Risk. Seeing those scores against your positions shows which holdings the fundamentals support. The methodology explains each factor.
- Drawdown history: how far the portfolio fell from its peak in each downturn, which is the honest measure of the risk you have been running.
No card required
Set the analytics layer up once
Create a free Openbook account, import your Freetrade accounts, and the analysis is there every time you log in. Re-export from the app when you deal and the picture updates with it.
Fractional Shares, Averaging In and Your True Cost
Freetrade's fractional shares change how a portfolio is built. Instead of saving up for one Apple share, people buy £50 of Apple a month, and the export records each of those purchases as a separate lot with its own quantity (0.2 of a share, 0.18 of a share) and its own price. Over two years that is twenty-four lots in one holding. This is precisely the situation where the app's "average price" figure and your own sense of what you paid drift apart, and where a tracker earns its keep: it nets every lot into one position with a true average cost, shows the gain against that, and keeps the lots available if you want to see when you bought well and when you bought badly. A spreadsheet can do the same with a pivot table, as long as the quantities stay numeric.
General Account, ISA and SIPP: One Portfolio or Three?
Freetrade shows each account separately, and many investors treat them as separate portfolios: the ISA for long-term holdings, the general account for ideas, the SIPP for retirement. That is a sensible way to organise money and a poor way to judge it. Your exposure to a company, a sector or a currency is the sum across all three, and risk does not respect account boundaries. Export each account, import them together, and look at the combined view at least once a quarter, even if you go back to thinking about them separately day to day. It is common to discover that the "safe" ISA and the "speculative" general account hold the same three US technology names, and that the overall portfolio is far more concentrated than either account looks on its own.
Common Problems with Freetrade Exports
- The export only covers recent activity. Make sure "All Activity" was selected rather than a filtered view.
- Values look too small. The opposite of the usual UK problem: if a tool assumes pence, Freetrade's pounds prices are read a hundred times too low. In Openbook the pence option is off when you choose Freetrade in the import.
- US holdings in dollars. The file records the price in the currency of the trade; a tracker converts at the day's rate. Check one US position against the app if the value looks off.
- Several accounts. Export each and import them one after another; they combine in the portfolio view.
Taking Your Freetrade Analysis Further
The reason to get your data out of Freetrade is not to see the same numbers on a bigger screen. It is to answer the questions the app cannot: whether Vodafone (VOD), Apple (AAPL) and Tesco (TSCO) have earned their place against a tracker, whether your income depends on too few payers, and whether the risk you are running is the risk you meant to take. Once the export is in a tracker those are five-minute checks. If you also use other brokers, the same import handles Trading 212, Hargreaves Lansdown and AJ Bell files, so everything ends up in one place. And if you are weighing Freetrade against Trading 212, our Trading 212 vs Freetrade comparison covers the differences that matter.
Next step
See what your Freetrade portfolio is actually exposed to
Sector concentration, income by holding, drawdown history and a Reward and Risk score on every position, across your general account, ISA and SIPP. Bring the CSV; the rest is done for you.
You can Compare VOD, AAPL, TSCO side by side on Openbook, or find stocks with the screener.
Co-founder of Openbook Analytics. Andrew studied Finance and Economics at the University of Strathclyde and writes on UK & US equities, stock valuation models, and portfolio strategy.
This article is for information and education only. It is not investment advice and not a recommendation to buy, sell or hold any investment. Openbook Analytics Ltd is not authorised or regulated by the Financial Conduct Authority. Past performance is not a reliable indicator of future results; the value of investments can fall as well as rise and you may get back less than you invest. Do your own research or speak to a qualified financial adviser.