Esta página está en inglés. El resto del sitio está en el idioma que elegiste.
Importing your XTB history into a portfolio tracker
XTB keeps the account history as tables, and the one that holds the trades is the cash operations table. Allocaria reads it as a CSV file or as an Excel workbook. This guide explains how a trade is recognised in that table, what is deliberately left out, and the one thing the file does not say, which you fill in at review.
Updated 15.10.2026
Which table to export
From the trading platform, save the cash operations table. It can be saved as a CSV file with semicolons between the columns, or as an Excel workbook whose sheet is called CASH OPERATION HISTORY. Both are read. The workbook also has sheets of open and closed positions; they are not the source of the trades and are not read.
Choose the longest period offered and bring several files in one after another if the history has to be split.
How a trade is recognised
The columns are ID, Type, Time, Symbol, Comment and Amount. A trade is the row whose Comment starts with OPEN or CLOSE, then names the direction and gives the quantity and the price of that fill with an @ sign between them. When an order was filled in parts, the comment can show two numbers separated by a slash; the first is the quantity of that fill.
An opening row of a long position is read as a purchase, and a closing row of a long position as a sale.
The sign of the Amount has to agree with the direction. If the cash moved the other way, the row is refused with a reason, never guessed.
A short position is refused and listed, not turned into a purchase or a sale.
Dates are read as day.month.year. Rows with the same ID are one operation however often the file lists them.
Deposits, withdrawals, dividends, interest, swaps and fees are counted and reported as not read. Fees are not read; the table shows a fee of 0.
What the file does not say
The cash operations table does not name the currency of a price. The reader does not guess one: the currency is left empty and the review table shows it as missing, so you fill it in from your statement before confirming.
Checking the table before saving
What is read from a file is a proposal, not a record. The rows appear in a table, and nothing is added to the portfolio until the person has looked at them and confirmed.
Check a few rows against the platform's own history, complete the currencies and look at the totals after saving: each position's quantity ought to match what the platform shows.
Common questions
No. Only the exported file is read. No password, login or key is asked for, and nothing is placed or changed at the broker.
The XTB cash operations table gives a quantity and a price but no currency for the price. A guess could put a wrong currency into a cost, so the field is left empty for you to complete.
No. A comment that opens or closes a short position is refused with a reason and listed in the result. It is never turned into a purchase or a sale.
Brokers change their exports from time to time, and the reader follows the layout of XTB files as published and as public samples show it. A file that does not match is either refused with a plain reason or shown with the missing pieces empty, never guessed. A screenshot, a pasted list or the form still work.
In Allocaria
How Allocaria's numbers are calculated →
The rest lives in your own account: see it next to your own holdings.
Request accessClosed beta · by invitation
General information, not investment, tax or legal advice, and not a recommendation about any security. Allocaria is a decision-support tool; it places no orders and holds no money.