Portfolio tracking ...
 

  You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more

[Closed] Portfolio tracking tool.

17 Posts
11 Users
0 Reactions
127 Views
Posts: 12993
Free Member
Topic starter
 

I've been given a talking to by my uncle. Essentially telling me to keep more of an eye on my investments.

Last year I started an excel sheet, but it's tedious looking up each price and entering it manually.

My uncle has an analogue spreadsheet that is not several feet long... 😁

Is there a tool or app that let's me keep track of both my investments and potential investments.

Entering everything manually is quite tedious.

Cheers!


 
Posted : 04/02/2021 3:06 pm
Posts: 48
Full Member
 

If they are shares or funds, I think Simply Wall Street allow unlimited portfolios.


 
Posted : 04/02/2021 3:23 pm
Posts: 3899
Free Member
 

advfn.com


 
Posted : 04/02/2021 9:26 pm
Posts: 0
Free Member
 

Who are you buying through?
Some platforms have an app.


 
Posted : 04/02/2021 9:35 pm
Posts: 13594
Free Member
 

If they are shares or funds, I think Simply Wall Street allow unlimited portfolios.

Just having a play, you have to pay for more than a single limited portfolio. I also can't figure out how to add open ended funds eg Fundsmith Equity - it only seems to allow stocks / trusts.


 
Posted : 04/02/2021 9:56 pm
Posts: 13594
Free Member
 

Some platforms have an app.

I think most do now.

My problem is I keep all investments split over a load of different platforms as a de-risk for one getting hacked, so I don't have an easy way of seeing the whole pot...


 
Posted : 04/02/2021 9:58 pm
 hugo
Posts: 0
Free Member
 

If your platform doesn't cover it simply then it suggests the approach may be overcomplicated and too many moving parts.

Also, weirdly, investing should be long term. Tracking short term is speculation and counter productive often.

Low cost, diversified, simple, buy and hold!

Edit

Just seen this.

My problem is I keep all investments split over a load of different platforms as a de-risk for one getting hacked,

I use Swissquote and have the option of two factor authentication and entering a code from a totally separate pdf matrix that I keep tucked away on Google drive. Surely that's enough?


 
Posted : 05/02/2021 5:16 am
Posts: 1156
Free Member
 

i quite like googlefinance ( https://www.google.com/finance)

In sheets (the equivalent of excel), just type

=googlefinance("Lon:Vod")

for instance, and it'll update every time you log in. It's very simple

There are other parameters if you want to get fancy
https://blog.sheetgo.com/google-sheets-formulas/googlefinance-formula-google-sheets/


 
Posted : 05/02/2021 5:21 am
Posts: 13594
Free Member
 

I use Swissquote and have the option of two factor authentication and entering a code from a totally separate pdf matrix that I keep tucked away on Google drive. Surely that’s enough?

Who knows.

But lets say HL gets hacked and a load of accounts get cleared out.

I'd rather wake up to discover I've 'lost' 20% of my pension than '100%' whilst they sort it all out etc.

Hence my funds are split across different providers.


 
Posted : 05/02/2021 10:09 am
Posts: 8469
Full Member
 

I use Trustnet to track mine. Im with Aviva, who's interface is awful/non existent, Trustnet works well.


 
Posted : 05/02/2021 1:57 pm
Posts: 1899
Free Member
 

And what exactly do you do with the information now?

I inherited management of mum's investments when my dad died.

I've been watching a few of the funds now and then, but I am clueless.

Some of them have done well, some of them have been a disaster (woodford).

Most have bounced back from covid to pre covid levels. Of course some of those could be rocket ships in a post-covid bounce.

Some are deemed "riskier" than others.

I have no idea when to change the investment, except to rebalance, or if a fund has done nothing since purchase.

So how do you make decisions about them?


 
Posted : 05/02/2021 4:18 pm
Posts: 12993
Free Member
Topic starter
 

Who are you buying through?
Some platforms have an app.

Use HL. I can look up the price and see how the fund/share has performed,can add them to a watch list, but have to click each one individually. Gets a bit boring.

Also, weirdly, investing should be long term. Tracking short term is speculation and counter productive often.

Once a fortnight I'll look up and enter the current price. That way I can see gains /losses and make a decision on whether to buy or switch.

I keep track of those funds I own and those in interested in.

I have no idea when to change the investment, except to rebalance, or if a fund has done nothing since purchase.

So how do you make decisions about them?

I've subscribed to What Investment which lists all funds available in the UK.

Some might think my system is balls, but I look at the average performance for each sector and look for those funds that are consistently out performing it. Generally look at the 6 month, one, three and five year numbers. Ignore bonds...


 
Posted : 05/02/2021 4:58 pm
Posts: 13594
Free Member
 

So how do you make decisions about them?

Once a year I look up how they've done and make a judgement call about wether I think that is good enough etc. Given you can only compare past performance and no one knows what will happen moving forwards, it's all very subjective.

I've made a few changes based on articles in the Sunday Times business sections, eg a few years ago they did a big piece about Woodford's patient capital fund explaining how the net asset valuations were all made up. I sold the fund based on that as the article made valid points. A year or so later, Woodford's main fund went belly up and Patient Capital tanked. I only had £12k in it, so not a huge deal if I'd lost it.

But generally, there is a lot to said for just buying a bunch of diverse funds and doing nothing....


 
Posted : 05/02/2021 5:04 pm
Posts: 1899
Free Member
 

I’ve made a few changes based on articles in the Sunday Times business sections, eg a few years ago they did a big piece about Woodford’s patient capital fund explaining how the net asset valuations were all made up. I sold the fund based on that as the article made valid points. A year or so later, Woodford’s main fund went belly up and Patient Capital tanked. I only had £12k in it, so not a huge deal if I’d lost it.

If I had read that then my mum would have been able to buy a new car on the Woodford losses as it had done very well....

Some stuff I thought about selling has done well since.....good job I didn't.

I did read once the best private investors are the dead ones. Didn't really work for me with the Woodford my dad chose....

I'm 50:50 on starting to really read all the financial press and getting into it or just move the money into a safeish vanguard life strategy mostly bonds for my mum. Getting into it hasn't really worked out for me so far.


 
Posted : 05/02/2021 5:09 pm
Posts: 8469
Full Member
 

It certainly isn't for everyone. I have several mates who are quite nerdy on all the data who I bounce ideas off, which helps.


 
Posted : 05/02/2021 6:15 pm
Posts: 12993
Free Member
Topic starter
 

It certainly isn’t for everyone. I have several mates who are quite nerdy on all the data who I bounce ideas off, which helps.

Got their number? 😁


 
Posted : 05/02/2021 6:22 pm
Posts: 757
Free Member
 

Interactive Investor have Virtual Portfolios so you can put what you want in. I have all my Vangaurd funds in one so I can see there performance over different time lines, also can see fund performance against its peers. So you can see how its doing in relation to others, might as well be invested in a top performing fund than bottom.


 
Posted : 05/02/2021 8:07 pm
Posts: 4397
Full Member
 

What Blastit said. A free ii research account should enable you to do what you want.


 
Posted : 05/02/2021 8:10 pm

6 DAYS LEFT
We are currently at 95% of our target!