Friday, 20 April 2007

Live Portfolio Updates in Sidebar

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.

US Stock Portfolio:


Enough Wealth

1 comment:

JR said...

Love the sidebar spreadsheet... You should publish a spreadsheet for your "savings and tax rate" post and try the new charting feature! Those charts post nicely.