Hi everyone,

I need to create a spreadsheet listing the current value of several public limited companies, i therefore need to pull information from balance sheets published online into Excel. I want to construct the spreadsheet in such a way that it updates itself when new reports are published so that it is always up to date.

I have managed to gather information such as the latest share price, market capital, 52 week high/low etc.. from the 'MSN moneycentral stock quotes' add-in, but do not know how to do a similar thing for balance sheet information.

I can't find balance sheet information on the companies that i am analysing on MSN money, but i can find it on Yahoo finance. Is there an Excel add-in that will allow me to pull this information in a similar way to the 'stock quotes' add-in? If not, is there any other way to do this?

Thanks in advance - any help or guidance will be much appreciated.