Can anybody recommend proper portfolio tools which provide:
1. daily valuations with a full history
2. dividends and other corporate actions
3. daily, monthly, quarterly, annual performance attribution for stocks, styles, sub-portfolio, strategies and overall
4. full import / export
5. performance benchmarking against chosen index
6. full performance metrics - annual returns, cumulative returns, monthly, vol, sharpe, skew, kurtosis, tracking error, drawdowns, leverage. etc..
I am tired of all these free portfolio tools... looking for recommendations for something more professional and accessible for individual investors at a reasonable price.
thanks!
For a while I struggled with portfolio tracking ; any system is only as good as the input provided. Free often means DIY, and this means thinking about what you actually need, and the time you are willing to spend on creating and maintaining that. In the beginning, I was able to track every day, but just ended up with workbooks of fancy charts, rather than something as simple as a compound annual growth rate, which tells me a lot more than 10 lines on a line chart over a three year period.
I find the Stockopedia tools in combination with MS Excel quite useful. I also hope that because I pay for this service, my data is not the product. Being mindful that I don’t have all the answers to your questions - here is how I approach some of this:
1/ daily valuations with full history
To keep this relevant, I want to include a stock when I held it, and exclude it when I sold; and only include the dividends I actually collected.
I try to keep on top of transactions in the stockopedia folio tool, having different broker accounts. I don't consider myself a trader, so for me, monthly works and every month I export the data. I then do my analysis, charts, whatever I need to do in excel.
The valuation charts under the Analysis tab clearly show a progress over time, which saves me from creating such charts myself.
If I wanted to process daily valuations, I would export my folio values every day at a given time.
2/ dividends and other corporate actions go under transactions
3/ sub-portfolio strategies
I use different strategies and created extra folios on Stockopedia – I do some guru checklist investing, some stockrank investing, some tracking in USD and some in GBP as well.
4/ full import / export / export to excel works for me here.
5/ benchmarking against an index
When I recently invested X amount in a Tiny Titans strategy, I chose an (accumulating) ETF that tracked my benchmark index and created a folio with X amount invested in the ETF.
That allows me to compare the bottom line difference between both strategies.
ETF historical values you can find them online, if you want something at shorter intervals.
6/ Metrics Annual returns, CAGR, cumulative returns, I deduct them from the data available on the folio tool – or I go into the detailed tabs. Being able to download historical stock reports is useful for me because I’m still learning and it allows me to go back and revisit a metric on a stock closer to when I purchased.
