How we calculate

Few trackers show how they calculate. We do: below is every measure in one sentence, with an example. The examples use made-up amounts.

Value

The value of an investment is the number of units times the latest closing price, converted to euros.

Currencies are converted at the European Central Bank's reference rates of that day. When a day has no rate (weekend, holiday), we use the last known one. When a price is missing altogether, we use the price of your last transaction and say so next to the investment.

Net invested and result per investment

Net invested is what you paid for your purchases, costs included, minus what you received from sales after costs.

The result is the value minus net invested, plus the dividends received after dividend tax.

Example. You get 10 units at €50 each and pay €2 in costs: net invested €502. The price is now €56, so the value is €560. You received €8 in net dividends. Result: €560 − €502 + €8 = €66.

Cash on your account

With DEGIRO's account statement, Kapitaaltrackr also knows your cash balance: the sum of every credit and debit per currency. Internal transfers between DEGIRO and the bank behind your cash account are left out, because the money does not really leave your account. After each upload we compare the calculated balance with the last balance in your file; if it differs by more than 5 cents, we say so.

Net deposits and change in value

Net deposits are all your deposits minus your withdrawals.

Change in value is your total value (investments plus cash) minus your net deposits. It holds price changes, dividends, interest and costs together.

Without an account statement (as with Meesman) we do not know your deposits. We then assume you deposited your net invested amount, minus the dividends you reinvested. The basis then shows "transactions" instead of "account statement".

Time-weighted return per year (approximation)

This percentage shows what your investments did in a year, without the timing of your deposits distorting the number much. We approximate it with the Modified Dietz method: a deposit counts for the part of the year the money was in.

Example. On 1 January your account is worth €10,000. On 1 July you deposit €1,200; that money is in for 184 of the 365 days. On 31 December the value is €12,000.

  • Change in value: €12,000 − €10,000 − €1,200 = €800
  • Average invested: €10,000 + €1,200 × 184/365 = €10,604.93
  • Return: €800 ÷ €10,604.93 = 7.54%

Money-weighted annual return

This is the return per year that matches your own deposits and withdrawals on the days you made them (the internal rate of return, or XIRR). If you deposit a lot just before a fall, this number looks worse than the time-weighted return; that is not an error, it measures something else.

Savings accounts

The balance is the sum of your deposits, withdrawals, interest and costs. When you use "set balance", we book the difference as new savings or as interest, whichever you choose.

New savings are your deposits minus your withdrawals, without interest. That shows what you put aside yourself.

The interest estimate is each day's balance times the interest rate, divided by the number of days in the year, from the last interest you booked. It is an estimate; the real interest is what your bank pays.

Example. €10,000 at 2% interest for 30 days: €10,000 × 2% × 30/365 = €16.44.

Spread

The split over sectors, countries and currencies is about the current value. An index fund is split by the sector weights its provider publishes; for countries a fund counts as one whole.

Box 3 (indication)

The box 3 calculation (the Dutch tax on savings and investments) uses your investments and cash on 1 January and the official percentages of that year, with and without the actual return (the tegenbewijs rule). The percentages are shown with their source in the app. It is an indication, not a tax return and not tax advice; the rules are still to be checked by an adviser.

Data sources

  • Prices, company data, dividends and splits: Yahoo Finance (public, unofficial data).
  • Exchange rates: the European Central Bank's reference rates, with Yahoo Finance as a fallback.
  • From ISIN to ticker symbol: Yahoo Finance, with OpenFIGI as a fallback.
  • Prices of Meesman funds: Meesman's fund pages.

Prices can be delayed, incomplete or wrong. The Kapitaaltrackr server requests them; your data is not sent along, only ISINs, symbols and fund names.