Shares / Funds tracking & analysis software?

Lomcevak · 9 December 2017 at 2:07PM

I have a home-brewed Excel spreadsheet that I use to keep track of three pension accounts (one a dormant DC scheme, two active - one a DC work scheme, the other a SIPP) and a S&S ISA - all containing very mainstream funds. It kind of works, but I'd really like some software that:

keeps track of fund prices, buy/sell activity, etc. (ideally with CSV import) to avoid typing in, but i'm only buying a few times a month across the whole set so manual isn't too bad
keeps track of basic rate-of-return analysis, etc. with standard metrics
lets me dig a bit deeper into things like asset allocation across the whole portfolio - i'm fairly sure i'm not as well balanced as I should be

The first two are (sort-of) handled by my spreadsheet, although automatic price updates would be nice. The third isn't. Back in the day I used to use MS Money, although I can't remember if it did asset allocation analysis or not, but haven't used it in ten years or so. Die-hard YNAB (classic) user for personal finances, but it doesn't do funds.

I've had a look around the MacOS AppStore but nothing jumps out, so any recommendations? Happy to pay up to £100 or so for the software provided it is good, Mac preferred but have a Windows PC if needed.

Thoughts?

redpete · 9 December 2017 at 2:13PM

You can get hold of the free 'sunset edition' of MS Money. This won't automatically track prices but it's not a big overhead to manually enter prices once a week. It tracks all purchase / sales / dividends / splits etc and gives good analysis of return over different periods.

The asset allocation isn't very sophisticated and I use a spreadsheet to do this, put in the allocation of each investment and update total value of each every month or so that you can see the overall allocation of your portfolio.

Linton · 9 December 2017 at 2:43PM

MS Money can produce a wide range of reports including IRR values. It can export holding and price data to spreadsheets so you can carry out whatever further analysis you want. If you go for the UK 2005 version rather than the US sunset version you can use software from Gaier to automatically load the latest prices for UK shares and funds. I dont know whether the Gaier software picks up UK share and fund data with the US sunset version of MS Money.

Reasonably deep analysis of asset allocation can be provided by Morningstar's portfolio Xray facility. Sadly you cant transfer data in and out of Morningstar

stephen160 · 9 December 2017 at 4:56PM

try stockmarketeye.com i am very pleased with this software about $99
steve

Lomcevak · 10 December 2017 at 5:52PM

stephen160 wrote: »

try stockmarketeye.com i am very pleased with this software about $99
steve

I've had a quick play with the demo - quite like it, but the price feeds seem temperamental, have you got them working reliably?

e.g. I hold ETFs like VFEM and VWRL which are priced in pounds but StockMarketEye interprets the Yahoo finance price in pence (so it either shows a 99% loss or I have to multiply the number of units I hold by 100), while mainstream funds like VLS80 and Fidelity Index US can be found by ISIN on Yahoo but the price data is messed up (lots of discontinuous jumps up and down in price).

Shares / Funds tracking & analysis software?

Comments

Categories

Get our FREE Weekly email full of deals & guides - and it’s spam-free