I updated my US stock portfolio spreadsheet using Google spreadsheet, and used the "publish" feature to create html code to display the current portfolio (with current prices linked into the google spreadsheet from google finance data) and performance in live tables in the blog sidebar. These tables will be automatically updated to show current prices, overall gain, and the calculated annualised return (using the XIRR function). It's quite a cool little tool, but I wish google finance provided data on the Australian market - currently they only supply data on the US, Japan and European markets.

I also just noticed that although this displayed OK using IE at work, it doesn't display properly using Firefox (although on my other site http://enoughwealth.com it DOES display OK with both IE and Firefox!). I'll have to edit the code to fit into this blog...