Brokers

eToro portfolio tracker: benchmark your eToro portfolio against the S&P 500

We turn the eToro account statement into an ordinary ledger: an opened position becomes a purchase, a closed one becomes a sale, and dividends and deposits keep rows of their own. eToro records per position rather than per holding, so adding to a holding three times leaves three separate records, each with its own identifier and opening price. Most accounts are denominated in dollars even when they were funded in euros, so part of what the statement calls your result is the exchange rate.

What the file contains

The activity sheet has a Date, a Type, a Details field naming the instrument, Units for the size of the position and Amount for the money involved. Type is where the position model becomes visible: open position and position closed instead of buy and sell, with deposits, withdrawals, dividends and fees sharing that same column.

Because the file is position based, a closed record already contains its own beginning and its own end. That makes the line between banked and paper results unusually clean, and it makes an aggregated view of a holding something that has to be rebuilt rather than read straight off.

Amounts follow the denomination of the account, which is dollars unless you opened one of the euro or pound variants. Each row is converted at the rate on its own date.

The export comes as XLSX, and we read the file as it is: no renaming, no reformatting, no cleaning up in a spreadsheet first. The columns we look for in this export are Date, Type, Details, Units and Amount.

How the import works for eToro

eToro is recognised through a column profile: we know the header names its export uses. That profile follows the documented format rather than a large set of real files, so if a header has been renamed you point at the column once and we save the mapping.

The account statement from the history screen, set to since account opening and downloaded as XLSX. The full route is in our eToro export guide.

Set the range to cover the whole account. A statement that begins partway through leaves closed positions without an opening and open positions without an origin, and every figure computed afterwards carries that hole.

If a column in your file is named differently from the layout we know, the upload does not fail. It drops through to the column mapper and you point out the date, the amount and the quantity once. Judging yourself on closed positions alone is the other common trap, because the positions you chose to end are not a random sample of the ones you opened.

What to watch for with eToro files

Positions, not holdings. Three purchases of the same share are three records with three identifiers. We add them back together into one holding with one average cost, and keep the individual records so the per-entry view still exists.

Dollar accounts funded in euros. Your euro deposit was converted on arrival and every later value is in dollars. In euro terms the outcome is what the investment did plus what the currency did, and the two only come apart when each event is converted on its own date.

Dividends on their own rows. Income is not mixed into the position records, so it can be totalled per year and per holding without being untangled from trading activity first.

Fractional units. The units column carries fractions and they matter. A position rounded to two decimals stops matching what the app shows and produces small gains that were never earned.

What you see after the upload

Your file becomes a verdict first: your time-weighted return next to the S&P 500 and the Nasdaq 100 over the same period, with your own deposits replayed into the index so both sides carry the same timing. Under it sit your positions with their cost basis, the dividends you received and the income your holdings are expected to pay, your allocation across positions and currencies, and a year report you can keep for your records.

Once the position records are folded back into holdings, the allocation view shows what you own rather than a list of entries, and the verdict is stated in the currency you pick.

You can look at all of that on the demo portfolio before you upload anything of your own. The first two weeks are free and no card is asked for.

Frequently asked questions

Where are my buys and sells? They are recorded as open position and position closed rows. Those are the same events under eToro's own labels, and they are translated into ordinary purchases and sales on import. Nothing is lost in the translation: the date, the units and the amount are all there, only the vocabulary differs from a classic broker.

Why do my eToro figures differ from another broker's app? Usually currency. A dollar-denominated eToro account and a euro-denominated account elsewhere are measured in different units, and until both histories are expressed in one base currency at historical rates the comparison is not really a comparison. Pick a base currency once and both accounts are restated into it.

Are dividends part of the statement? Yes, as separate rows in the activity sheet rather than inside the position records. That separation is convenient, because dividend income can then be totalled by year or by holding without first being separated from your trading. Tax withheld before payment appears where eToro records it.

What if my file has different column names? Then the layout we know does not match and the file goes to the column mapper instead of being rejected. You identify the date, the type, the units and the amount once, and that choice is stored for later uploads. Nothing is guessed at on your behalf, which is the point of the extra step.