eToro is the odd one out. It does not give you a CSV at all — it gives you an Excel workbook with several sheets, only one of which is your transaction history, and it does not write a unit price anywhere in it.
Getting the file
Under the account or portfolio history, as an Account Statement. Choose a date range covering the whole account. What downloads is an .xlsx workbook.
The sheet that matters is the Transactions Report — the one with a row per cash movement. The other sheets are summaries: useful to read, but they contain totals rather than the history those totals were computed from.
Three things about eToro’s format
Instruments are named as a pair. eToro writes AAPL/USD rather than AAPL. Taken literally that is not a ticker any price source will resolve, so the part before the slash has to be separated out before the position can be priced at all.
There is no price column. eToro records the amount and the number of units, and leaves the price per unit implied. It has to be worked back out by dividing one by the other — which is fine, but it means a row with an amount and no units cannot be priced and has to be handled rather than silently dropped.
Position IDs repeat. The same identifier appears on every row belonging to one position’s life — the opening trade, its dividends, its fees, the close. Used as a uniqueness key when removing duplicates, it collapses all of those into a single row and quietly deletes most of your history.
The vocabulary
- Open Position — a buy. Position closed — a sell.
- Deposit, Refund, Withdraw Request — money in and out.
- Dividend and Interest Payment — income.
- Rollover fee, Withdraw fee, Stamp duty, SDRT — charges, not trades.
Stamp duty and SDRT are UK transaction taxes. They belong to the cost of a trade rather than being trades themselves, and counted as positions they create holdings that never existed.
What to check once it is in
- The number of transactions, roughly, against the workbook. A large shortfall points at position IDs being used for deduplication.
- That your tickers resolve and show prices — a stuck AAPL/USD shows as an unpriced holding.
- Dividends for a past year, and that fees are not counted as income.
For why the income side matters separately from price movement, see yield on cost versus current yield.
HaboFi takes the eToro workbook as it downloads, picks the Transactions Report sheet, splits AAPL/USD into a ticker it can price, and derives the unit price from the amount and units. No broker login and no API key — a file you downloaded yourself, and nothing that keeps reading your account afterwards.
Try HaboFi free