As a general comment, I should just point out that my program is only intended as a relatively simple portfolio manager, which I primarily wrote because I found the one in AmiBroker next to useless for my situation.
As well as displaying the current portfolio and overall basic financial figures though, it also generates trade history files, detailing every trade made along with gain, brokerage and GST for taxation purposes, dividend history files detailing every dividend and franking amount, cash transaction history files detailing all cash amounts added and taken out, and portfolio value history files detailing realised gain (closed equity) and net position (including open gain) for every day. All files are in spreadsheet CSV format, and of course will only be accurate if the information is correctly entered. It can also support an unlimited number of portfolios, although will only display details for one at a time. Switching between portfolios is as simple as selecting the portfolio from a drop-down list.
While I haven't bothered to add a pile of statistics, I think most could be calculated from the information provided in the files if I really wanted to do that. All I have done is provide a very simple text summary report for a selected financial year to assist with taxation. I might add other stats later if I feel it's worthwhile.
As I really wrote this for my own use, it has a few features that are specific to my circumstances, and ties in with my personal AmiBroker plugin which reads the portfolio files (similar to how my stops plugin reads a simple portfolio file to get the purchase dates). As I have both investment and trading portfolios, which are treated differently for tax purposes, the figures generated give me the information I need for both.
For my tax returns, the figures generated allow me to create spreadsheets in Excel, just requiring a bit of presentation formatting and resaving as XLS files, plus adding some overall totals and summary information at the end. A couple of things I have to do manually are highlight which trades are still open in the investment portfolio, as the buy brokerage cannot be subtracted until the shares are sold, and work out which closed trades were held for more than 12 months and thus allowed the 50% CGT discount. I also manually create an overall summary spreadsheet that summaries my position for the year (ie. summarises the results from the separate trade, dividend, and cash spreadsheets). The spreadsheet formats took me a little while to get right this year, as it was my first year, but now I have templates which will make it much easier in subsequent years.
And of course some things I have to leave for my accountant to work out as they're just too hard - things like demergers where there might be combined dividends and capital returns with deferred tax components and even special tax rules about how to handle the changes, and stapled security distributions which include trust distribution and company dividend components. I just whack them all in as simple dividends and let the accountant sort them out properly.
When I submitted the spreadsheets to my accountant to do the tax returns, I asked him if they were okay or needed more information, and he replied that they were very good, much better in fact than he normally gets from his clients. That's good enough for me
Anyway, it's there, it's free, and it seems to be doing the job for me. You're welcome to try it and use it if you like it - on an all care and no responsibility basis of course
.
Cheers,
GP