If none of the free online portfolio tracking sites cater to your needs, you might want to try creating your own. Well, maybe not your own site, but you can use
Google Docs to create a spreadsheet that shows you up-to-date stock information in any format you choose.
For example:
The company and EPIC columns are typed in manually, the Price and Change columns use the
GoogleFinance function to find data for the given ticker.
For example, the formula that returns Vodafone's price is:
=GoogleFinance("LON:"&B2,"price")
Where "LON:" indicates we're dealing with the London Stock Exchange.
Similarly, the formula for the price change since yesterday is:
=GoogleFinance("LON:"&B2, "changepct")/100
And that cell is formatted as "percent".
In the next post, I'll build on this to given an example of how you could use this to track actual transactions, and profit.
Click here for the 2nd post in this series.
We saw that Google Docs spreadsheets have financial functions available in the first post in this series. For this post, I've created a Google Docs Template which you can view, and copy for your own use if you like (it's free). Click here to see the te
Tracked: May 14, 17:19