I decided to have a go building my own simple spreadsheet and borrow ideas from the various options already out there. This is how far I’ve got… what do you guys think??
One of the things I’m noticing is that pulling data from Google Finance doesn’t always give you an accurate output, for example, when pulling share prices I have to divide the figure by 100 to get the correct share price in GBP to the penny. Also, unlike Yahoo Finance, the pricing information is 24hrs old.