DiviScout

Returns analysis

Why XIRR looks wrong in portfolio apps

Why money-weighted returns can look strange, when XIRR is doing the right job, and how missing current values distort the result.

01

XIRR cares when the money arrived.

A simple gain percentage treats the account like one pot. XIRR treats each deposit and withdrawal as a dated cash flow. Add a large amount near a peak and the result can look much worse than the chart in your head.

That does not mean the calculation is broken. It means it is answering a narrower question: what annualised return did your actual invested cash earn, given the timing?

02

A missing ending value makes the percentage meaningless.

XIRR needs two things: dated cash flows and a current value. If the import has deposits and withdrawals but no holdings snapshot, the app cannot pretend the account is worth zero just to produce a number.

That is why DiviScout asks for a current account value, or uses imported holdings when they are available. Without that last value, the return is not merely rough; it is the wrong calculation.

03

Very large percentages are usually data problems.

When XIRR spits out a huge number, the first suspect should be the import, not a sudden discovery that you are an investing genius. The common causes are incomplete history, a missing current value, or a current value that does not belong to the same cash flows.

Precision can be misleading here. The right move is to check the file coverage and ending value before reading anything into the result.

04

Look at simple gain and XIRR side by side.

Simple gain tells you what happened to the pot relative to deposits. XIRR tells you how the timing of those deposits changed the annualised return.

Neither number is enough on its own. Together they tell you whether the portfolio result is genuinely good, or whether cash-flow timing is doing most of the explaining.

Use in DiviScout

Compare simple gain with XIRR on the same import.

Use both views together to separate real portfolio performance from cash-flow timing and missing-value problems.

XIRR FAQ

01

Why can XIRR look wrong even when the formula is correct?

XIRR is money-weighted, so it reacts strongly to the timing of deposits, withdrawals and the ending portfolio value. That makes it answer a different question from a simple gain percentage.

02

What breaks an XIRR calculation most often?

The most common issues are incomplete cash-flow history, a missing or inconsistent current portfolio value, or an import range that excludes earlier deposits and buys.

03

Should I trust a very high XIRR number?

Not without checking the assumptions. Extreme percentages usually point to broken inputs or incomplete coverage rather than genuinely extraordinary performance.

04

What should I open after this article?

Open the main Trading 212 tools page if you want to compare XIRR with simple gain, or start with the export guide if you still need the right broker file.

Read next