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