Import your Hargreaves Lansdown portfolio into Quantic
HL exports your transaction history as CSV. Quantic reads it through column mapping, and converts pence to pounds on the way in.
A UK export has a trap in it that nothing else in Europe has: the London market quotes most shares in pence, not pounds. A price of 2,450 is £24.50, and an importer that takes it at face value builds a portfolio a hundred times too large — then converts it to your display currency and produces a number that is wrong but perfectly plausible. Quantic knows the GBp and GBX currency codes and divides by a hundred as the rows come in.
Beyond that it is the ordinary path: you tell Quantic which columns carry the date, the instrument, the quantity, the price and the charge, it infers day-first dates from your own rows, and it identifies holdings by ISIN so a company that changes ticker keeps its history. Dealing charges fold into the cost basis rather than being dropped, which is the difference between what a position cost and what it appears to have cost.
How to import it
-
1
In Hargreaves Lansdown, open your account's transaction history and export it as CSV.
-
2
In Quantic, open Movements and drop the file in.
-
3
Map the columns once, and check that prices read as pounds rather than hundreds of them.
-
4
Save the mapping. An ISA and a dealing account export the same shape, so one mapping covers both.
Two things this will not do for a UK filer. Inside an ISA or a SIPP there is nothing to declare at all, so the withholding column describes tax that was never charged. And outside one, HMRC pools your shares into a Section 104 holding at average cost — which is what Quantic's portfolio already does, but not what its tax report does: that section is written for Spain and matches sales to purchases oldest-first. Read the portfolio, not the tax report. We have not validated a real HL export yet either; if yours will not read, the import screen offers to send it to us.
Key terms
- Cost basis (average cost)
- What you actually paid for the shares you hold, per share — the money you put in, including the commission, spread across your shares. Buying more at a different price moves it; selling doesn't, because selling doesn't change what the shares you kept cost you. It's the baseline your gain, your yield on cost and any future tax calculation are measured against.
- Commission
- What your broker charges to execute a trade. It's small per trade but it's real money, and it counts as part of what the shares cost you — which is why Quantic records the commission on every trade it can read from your statement.
- ISIN
- The twelve-character code that identifies a security worldwide, regardless of which exchange it trades on or what ticker it uses there. Unlike a ticker, it doesn't change when a company renames itself — which is why an import identifies your holdings by ISIN where the file carries one, so a renamed company keeps its dividend history instead of splitting into two positions.
- FIFO (first in, first out)
- When you sell part of a holding you bought in several goes, FIFO says you sold the oldest shares first. Most of Europe taxes securities this way, so it decides what those shares cost you and when you acquired them. Quantic carries your holdings at average cost — the better measure of how a position is doing — and uses FIFO only in the tax report, which is why the two can show different figures for the same sale.
Quantic · Free
Import your statement and see the income
Free, no card, and no broker connection — you upload a file you exported yourself. Or explore a sample portfolio first.
Need more? Pro adds portfolios, options income tracking & more AI. See Pro →