Portfolio Manager

Linton

The paid for version accepts Cash as a holding name.  I would have expected the free one to do so as well.  Not that I see any great point in analysing a portfolio with cash in it.

Why dont you ring the help line to get your subscription sorted?  On the other hand since you think the whole system is terrible why do you want to?

valiant24

Linton said:

The paid for version accepts Cash as a holding name.  .... Not that I see any great point in analysing a portfolio with cash in it.

If you're holding back a portion of assets for drip-feeding, or because you misguidely think you might be able to market-time, it would be pretty handy.

valiant24

eskbanker said:

valiant24 said:

I have all sorts of sipps and isas on various platforms.  Fidelity and AJ Bell do have the xray, but obviously not across the whole portfolio, and iweb, embark, eqi and vanguard do not

Why spread your portfolio so widely?

It's just happened over many years of ISAs and, before that, PEPs

Michael121

Build Your Own Stock Portfolio Tracker On Google Sheets - YouTube

I just copied this guys script in google spreadsheets and made adjustments to the portfolio he used. Can either copy him from YT vid or sign up to his patreon and get it there. 

No need to update prices either does it automatically, though you will need to download an app in sheets if you want etf/fund prices. There is away to do it through yahoo but i couldn't get it to work properly. Maybe google finance will add them soon so it works without the app.

eskbanker

valiant24 said:

eskbanker said:

valiant24 said:

I have all sorts of sipps and isas on various platforms.  Fidelity and AJ Bell do have the xray, but obviously not across the whole portfolio, and iweb, embark, eqi and vanguard do not

Why spread your portfolio so widely?

It's just happened over many years of ISAs and, before that, PEPs

OK then, let's try a slightly different phrasing - regardless of how you got here, why do you wish to continue to perpetuate a complex and difficult to manage portfolio dispersed across a wide variety of environments?  Trying to find suitable aggregation tools is obviously one way of addressing the symptoms of the situation but I was implicitly suggesting stepping back a bit and reconsidering your overall approach, i.e. simplify rather than manage complexity....

Linton

valiant24 said:

Linton said:

The paid for version accepts Cash as a holding name.  .... Not that I see any great point in analysing a portfolio with cash in it.

If you're holding back a portion of assets for drip-feeding, or because you misguidely think you might be able to market-time, it would be pretty handy.

Yes you certainly need to hold and track cash in your investment accounts.  The question is why you would want to put it in a trustnet/morningstar etc portfolio.  However, I suspect you may be trying to use the free portfolio tools for a task they arent equipped to support.

What essentially they are is dummy portfolios only.  They arent designed for managing investment accounts but rather to analyse and report the performance/make-up of a given set of investments.  So for example a performance graph from trustnet simply provides the performance of a portfolio with funds allocated as they are at the current time.  It wont give you the historical performance through the various changes you have made. 

If you want software that will track and report on investments in multiple accounts over time in a similar way to one that tracks bank accounts  you would probably have to pay for it.  But as far as I know there is nothing on the market that does the job properly and integrates investment accounts with cash accounts completely satisfactorily.  Possible options mentioned in the past are Gnucash and Quicken.  However the latter is no longer sold in or for the UK.

The one system I know about that does almost all you could possibly want is MSMoney - extensive reporting, integration of bank accounts with investments, detailed tracking of multiple investment accounts, bulk upload of investment prices and bank account transactions etc etc.  On the downside it is no longer supported or available from Microsft.  On the upside it has worked for me since support stopped around 2009 despite the many changes to Windows since then.  It did stop accepting new investments when the data file with 20 years of detailed investment and cash data exceeded 86M but it was then simple to start again from scratch - the old data was not lost. There are free versions of the final UK release to be found on the net.

valiant24

eskbanker said:

valiant24 said:

eskbanker said:

valiant24 said:

I have all sorts of sipps and isas on various platforms.  Fidelity and AJ Bell do have the xray, but obviously not across the whole portfolio, and iweb, embark, eqi and vanguard do not

Why spread your portfolio so widely?

It's just happened over many years of ISAs and, before that, PEPs

OK then, let's try a slightly different phrasing - regardless of how you got here, why do you wish to continue to perpetuate a complex and difficult to manage portfolio dispersed across a wide variety of environments?  Trying to find suitable aggregation tools is obviously one way of addressing the symptoms of the situation but I was implicitly suggesting stepping back a bit and reconsidering your overall approach, i.e. simplify rather than manage complexity....

Yes I am gradually using ISA transfers with the intention of ending up with just 2 iWeb ISAs (one each for Mrs Valiant24 and me); an SIPP with AJ Bell for me, and a SIPP for the mrs. but I haven't worked out which is the best platform for hers yet.