Performance Tables

[KateMoloney]

Hi Nick,

I just watched your video about the performance tables;

https://www.thechartist.com.au/portfolio-management-software/

Do you just fill in the gross trading P & L and add the dividends & interest separately?

I tried using the net P & L, but the numbers were too high, assuming it is because it included unrealised profits?

[KateMoloney]

Also, do you have any videos or information about VAMI tab on share trade tracker?

Not sure if it is user error, but the data seems incorrect on the VAMI tab. For example gross profit and loss is completely different to the gross P & L I get when I run a report for that same time period (or what is reflected on the summary tab).

[Nick Radge]

I don’t use the VAMI tables in STT as it doesn’t account for deposits or withdrawals, the same as the actual portfolio return number.

I do all performance calculations in the separate Excel sheet.

All I do is take the Net P&L figure out of STT. It accounts for all dividends, interest and commissions.

I then add that in column F and subtract the sum of all prior months in column F.

Basically I’m recording the change in Net P&L for the month out of STT (but STT can’t go back in time) which is why I do it each month after the close.

[GlenPeake]

Yep. What Nick said!!! That’s how I manage it as well

I’ve created a STT NetProfit column in the Performance tables spreadsheet and enter in the value from STT at the end of the month and subtract the previous month.

(Zoomed in screen shots below)

I have a unique TAB for each system and then can perform different ‘system combination’ statistics for each system. I.e. I can group all the MR systems into the one TAB and get an ‘overall’ % return for the MR systems combined etc.

[KateMoloney]

Thank you Nick and Glen for sharing.

I spent a number of hours yesterday trying to figure out best process for this.

Grateful for this community.

[Nick Radge]

If you get stuck, send the sheet to me Kate. Essential that the data is updated at the end of each month though. You can’t pull it back out of STT after its been updated.

[KateMoloney]

Thanks Nick.

I have been using the report function and doing monthly reports to get the back dated monthly P&L. STT is such a great tool.

[KateMoloney]

Thanks Nick – will do.

Appreciate your help.

[ChrisThong]

Hi Glen,

May I know what does the inception CAGR mean?

[GlenPeake]

Chris Thong wrote:

May I know what does the inception CAGR mean?

Hey Chris,

That’s the total return since going live with the system.

As time goes by, hopefully you’ll see this number get bigger and bigger

[ChrisThong]

Thanks Glen.

[#REF!McGrath]

Hi Glen, how do you account for the US systems. If starting NAV is in AUD & STT Net Profit is in USD do you convert back to AUD at month end. Or alternatively have starting NAV as USD. There are also times where for the monthly systems you are sitting in cash which may be USD or AUD depending on currency movements. I have been reconciling to my IB account in both AUD & USD but looking to simply the reporting.

thanks

[GlenPeake]

Hi Gavin,

In a nutshell I track the system(s) performance in it’s own performance tab and record the monthly performance/profit from Share Trade Tracker all in US$. I’m interested in the performance of the system itself as traded (excluding currency conversion).

I have another performance tab in the Performance Tables spreadsheet which tracks my IB account NAV, which shows the total of everything in AU$….. cash/open positions/currency hedging etc.

Hope that helps.

[Author]

Posts