Hi Guys,

I am working on a Portfolio in Excel and basically wanna set up an overview of a couple of key figures.

Basically, I wanna import data from google finance or reuters (not from yahoo finance). I don t wanna do it every day so I need to write a VBA and make a module button, so I can update the information whenever I want. However, I know the VBA code has to be more sophisticated as I only wanna import, lets say the stock price and not all the other stuff along with it. So for instance my code has to know that he should pull only the stock price from google finance to cell J4 in Excel, P/E in J5, Yield in J6 and so on.

Can anybody help me out on this one? My VBA coding skills are so poor and I can`t even do it manually as google finance doesn t provide any html tables.

Thanks in Advance