Fund in reports

Created by Erik Åkerlund, Modified on Mon, 24 Jun at 11:50 AM by Maria Appelquist

This article describes the some of the columns that are  used for funds


Fund transaction type -The type of the fund transaction, i.e Buy, Sell, Interest, Rebate, Dividend

Quantity - Quantity of bought / sold shares in a Fund in the period per transaction

Fund Quantity - The outstanding total quantity of the Fund

Price - The price if the fund

Acquisition Price -The fund acquisition price according to Average or FIFO setting

Return - Market value Clean -Closing Balance - Dividend

Return % - Return/ Closing balance

Return Realised - Dividend + Gain/Loss

Return Realised% - Return Realised/Opening balance

Return Unrealised - Market value Clean - Closing Balance- Gain/loss

Return Unrealised % - Return Unrealised/Opening Balance

Return Allocated - Market value Clean – Opening balance - Dividend in period +/- bought/sold quantity within the period.

Return Allocated % - Return Allocated/(Opening balance- Amount bought in period)

Gain / Loss - Gain / Loss of a fund sell or commodity (Acquisition price – Price) *Quantity

Dividend / Rebate - Fund Dividend / Rebate in the period

Fund Dividends - The total Dividend / Rebate


Weighted Capital Realised - Weighted invested capital including dividends + re-invested dividends

Weighted Capital Unrealised - Weighted invested capital included re-invested dividends

Weighted Capital Allocated - The calculation will be from measuring period start  to measuring period end. If not allocated the calculation of the weight will be from the first buy


Modified Dietz Return - Calculates the Modified Dietz return of a Fund, looks at the cashflows and when it occurs

Modified Dietz Return Allocated - Only cash flows from within the measuring period is part of the calculation. Market value Clean – Opening balance + Dividend in period +/- bought/sold quantity within the period.

Modified Dietz Return Realised - Dividend + Gain/Loss

Modified Dietz Return Unrealised - Market value Clean - Closing Balance




NAV at Period Start - The Fund NAV at measuring period start, if bought in the period the price bought will be shown in this column

NAV at Period End - The Fund NAV at measuring period end, if sold in the period the price sold will be shown in this column

NAV Delta % - NAV at Period End- NAV at Period Start / Nav at Period Start

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article