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
Fund Quantity -The outstanding 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 + Dividends
Return Realised - Dividend + Gain/Loss
Return Unrealised- Market value Clean - Closing Balance
Return Allocated - Market value Clean – Opening balance + Dividend in period +/- bought/sold quantity within the 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
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 coulmn
NAV at Period End- The Fund NAV at measuring period end, if sold in the period the price sold will be shown in this coulmn
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article