interactive investor Portfolio Tracker: Track Your ii Investments

interactive investor's flat-fee model attracts investors with larger portfolios, and larger portfolios are exactly where the gap between an account page and a proper tracker shows. ii tells you what you hold and what it is worth today. It does not give you an interactive investor portfolio tracker that combines your ISA, SIPP and trading account, measures the lot against a benchmark, and shows your income and risk. This guide covers how to get your ii data out, the one thing that makes the ii export slightly fiddlier than other brokers, and how to build the analysis layer on top.

Why the ii Website Is Not a Portfolio Tracker

ii's portfolio pages show holdings per account, with book cost and current value. For a quick check that is enough. For understanding how you are doing, three things are missing.

• Accounts stay separate. Lloyds held in an ISA and a SIPP is two lines on two pages. Your true weight in one bank is never shown.
• No benchmark. Book cost versus value tells you a gain, not whether it beat the index over the same period, which is the only question that says whether your effort is paying.
• No income or risk view. Dividends are transactions, not an income history. Sector concentration and drawdowns are not on the page at all.

How to Export Your interactive investor Transaction History

ii has no API, and the export is only available on the website, not in the app. Each account exports separately.

• Log in at ii.co.uk on a computer.
• Open Portfolio in the top navigation, then Transaction history.
• Set the date range to cover all of your purchases and click Submit. Choose the account (ISA, SIPP or Trading); each one is exported on its own.
• Click the download icon to the right of the table and choose CSV.
• Repeat for each account.

The file contains a row per transaction with the security's name, its symbol, the date, the quantity and the price, plus dividends, fees and cash movements. Unlike Hargreaves Lansdown, ii includes the symbol for each holding, which makes matching to a listed security much more reliable.

Skip the spreadsheet

Import your ii export straight into Openbook

Upload each account's CSV as it downloaded. Openbook reads the Security, Symbol, Date, Quantity and Price columns, treats UK prices as pence, and shows you every holding it found before anything is saved.

Import your portfolio →

Mapping the ii Columns Correctly

The one thing that makes the ii file slightly different is that its column names do not match what most trackers expect, so if you are building your own sheet or using a tool that asks you to map columns, the mapping is:

• Security is the holding's name.
• Symbol is the ticker.
• Date is the buy or sell date.
• Quantity is the number of shares or units.
• Price is the price per share, in pence for UK shares.

That last point is the usual UK trap. ii quotes UK share prices in pence, so a purchase of GSK at 1,540p appears as 1540. Divide by 100 for pounds, and check one price against what you actually paid before trusting a valuation. Openbook's import maps these columns for you and turns the pence setting on when you choose interactive investor; the preview shows the price in pounds so the check takes two seconds.

Building an interactive investor Spreadsheet

For investors who want to stay in Excel or Google Sheets, the structure that works is one tab per account, a pounds-price column, and a pivot table that sums quantity by symbol (sells as negatives) to give current positions. Add a price lookup per symbol for current value, and a summary tab that adds each symbol across accounts to reveal your true concentration. Because ii gives you symbols, the lookups are far less error-prone than with brokers that export names only.

The weakness is the same as any spreadsheet: it needs rebuilding after every export, and a benchmark, an income calendar and a risk view are all extra work. Our guide to choosing a UK portfolio tracker sets out where that trade-off tips.

What a Dedicated Tracker Shows That ii Cannot

• Performance against a benchmark across every ii account together, and per account, over one, three and five years.
• Income by month and by holding, with yield on cost rather than yield on today's price. Our dividend tracker guide covers why that distinction matters.
• Concentration by sector, country and company once the ISA, SIPP and trading account are combined.
• 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 numbers support. The methodology explains each factor.
• Drawdown history: how far the portfolio fell from its peak in each downturn.

No card required

Set the analytics layer up once

Create a free Openbook account, import each ii account, and the analysis is there every time you log in. Re-import a fresh export when you deal and the picture updates with it.

Create a free account →

Why Flat-Fee Investors Need Tracking Most

ii's pricing is a fixed monthly subscription rather than a percentage of assets, which is why it attracts larger portfolios: the bigger the account, the smaller the fee is as a share of it. The flip side is that ii customers tend to hold more positions, across more accounts, for longer, and that is exactly the portfolio where the account page falls furthest short. Twenty holdings across an ISA and a SIPP, built up over a decade, is a portfolio nobody can hold in their head. Whether it has beaten a tracker, how much of it is in financials, how dependent the income is on three payers: these are not questions you can answer by scrolling two pages of holdings. They are questions a tracker answers in one screen, and the larger the portfolio, the more the answers are worth.

Regular Investing and Transfers In

Two things about how an ii account is built up show in the export and are worth knowing. If you use ii's regular investing to buy the same holdings each month, the file has a deal row per month per holding at that month's price. That is what a true average cost needs, and a tracker nets the lots into one position; the file is long, and that is fine. If you transferred holdings in from another broker, the transferred positions appear in the history as transfer or "stock in" events rather than purchases, usually without the original purchase price. A tracker will show the position from the transfer date, but your original cost and the full history before the transfer are in the old broker's export, which is worth downloading before the old account is closed. Import both and the picture is complete.

Common Problems with ii Exports

• No export button in the app. Correct: use the website.
• Only one account in the file. By design. Export each account and import them one after another; they combine in the portfolio view.
• Valuations a hundred times too high. Pence read as pounds. Check one UK price against what you paid.
• Funds without a symbol. Some OEICs carry a name but no ticker. Match by name in the preview before saving.

Taking Your ii Analysis Further

Getting your data out of interactive investor is worth doing for one reason: the decisions it makes possible. Whether individual holdings like abrdn (ABDN), Lloyds (LLOY) or GSK (GSK) have earned their place against a tracker, whether your income depends on too few payers, and whether the risk you are carrying is deliberate. With the export in a tracker those become quick checks rather than an evening in Excel. If you hold accounts elsewhere too, the same import takes Hargreaves Lansdown, AJ Bell and Trading 212 files, so everything ends up in one view. Our guide on tracking investment performance covers the measures worth watching once it is there.

Next step

See what your ii portfolio is actually exposed to

Sector concentration, income by holding, drawdown history and a Reward and Risk score on every position, across your ISA, SIPP and trading account. Bring the CSVs; the rest is done for you.

Open your portfolio →

You can Compare ABDN, LLOY, GSK side by side on Openbook, or find stocks with the screener.