Customised report

[mfmelb]

Hi Mark,

I would like to do a customise report and would like some suggestions on the best way of doing it.
Basically what I need is a Report over a rolling 12 months period with 12 columns of data.
Each column would have the end of month valuation and also the net transaction value for that month. This is sort of a combination of the Portfolio Value report and the Transaction report but not using all the parameters.
Problems I encounter in trying to setup the customised report are that it only allows 6 periods rather than 12 which I need. Also, I am not sure how to get the net transaction value for each month - normally one would subtract all the outgoings/redemptions from the incoming/entry.
Suggestions on how best to achieve this would be welcome.

Regards

Matt

[Mark]

Hi Matt,

In the report settings, you can only have up to 6 dates. If you are using the Pro or Advisor versions you could write your own equations for fields that have these 12 different dates. For details, see this recent discussion (look at my post towards the bottom of the thread with sample equations):

viewtopic.php?f=7&t=1845

To get your net transaction value, you may want to look at the Custom report field:

Invested (between)