Import your XTB account into Quantic
XTB's account history export is a spreadsheet of closed positions, cash operations and open positions. Quantic reads it on sight — trades and dividends from the same file, no mapping step.
XTB exports your account as an Excel workbook with three sheets, and the one that matters is Cash Operations: every buy, sale, dividend and withholding on the account, one row each. A trade's quantity and price live in a comment like "OPEN BUY 2/2.7 @ 128.26" rather than in columns of their own, so Quantic reads them from there — each partial fill of a fractional order becomes its own trade, and a close becomes a sale.
Some positions never touch cash where you would expect them to. A free share from a promotion has no purchase row, a position opened before the date range you exported has none either, and rights from a corporate action can be booked in and out with no cash at all. Quantic fills those ends in from the position sheets, using XTB's own position ids, so the holdings it rebuilds match the ones XTB says you have.
Dividends arrive the way XTB books them: in your account currency, gross, with the withholding on a row of its own and one payment per lot you hold. Quantic adds the lots up into one dividend per payment, and when XTB reverses a payment and pays it again — it sometimes does, in a different currency — the reversal cancels the original instead of counting twice.
Transaction taxes arrive as rows of their own, often days after the trade: Spain's and Italy's financial transaction tax, UK stamp duty, the US SEC fee. Quantic attaches each one to the trade it belongs to through XTB's position id, so a purchase tax raises that buy's cost basis — converted at the rate the trade itself settled at when the share is priced in another currency.
How to import it
-
1
In XTB, open your account history and export it to Excel, choosing the widest date range it offers.
-
2
In Quantic, open Movements or Dividends and upload the .xlsx file.
-
3
Check the preview — nothing is written until you confirm what it found.
XTB names instruments with tickers of its own and no ISIN — REP1.ES is Repsol in Madrid — so Quantic translates each one to the listing it most likely means. That is the step to check: a depositary receipt or a less common venue can land on the wrong listing, and anything with no listing at all, like subscription rights, is left for you to match by hand. CFDs are not shares and are skipped.
Key terms
- Trade-backed position
- A position built from your actual buys and sells, whether typed in or imported from a broker statement. The shares and average cost are calculated from those trades rather than entered directly — which is why you edit the trades, not the position. Commissions, splits and option assignments all fold in automatically.
- 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.
- Withholding tax
- When you own a foreign stock, the company's home country usually skims a percentage off each dividend before it reaches you — say 15% on US shares. Quantic estimates this from where each holding is based and your tax residence, so your income reflects what actually arrives. It's the tax withheld at source only — not any tax your own country adds, nor amounts you can often reclaim or credit back under a tax treaty.
- 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.
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 →