Fund in reports

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