Linking Google Finance stock data with Excel

[rkumaran]

Hi, can Google Finance content on stocks be linked with an excel worksheet.....such that the user can have an updated portfolio everytime the file is opened....thanks...Kumaran

 

[Hui]

rkumaran


Yes, with some limitations


I've played with Google Finance and Excel for some time and some tables come in and others just don't ?


In Excel 2007/10 goto the Data Tab and select the From Web button

This will open up a Web Browser from within Excel

navigate to the Google Finance or any other page you want

There will be a number of Small Yellow (right pointing) arrows next to tables

Select the table you want and the arrow will change to a Green Tick


Select The Import Button


Excel will prompt to where you want to put the Table, Select the area, but Don't Accept yet

On the Properties Tab Tick the "Refresh Data When Opening File" option and any other options that may help


Thats it


I have found that sometimes selecting a single cell as the location in Excel doesn't always work, but selecting an area that has more rows and Columns than the table does.


Good luck

 

[Hui]

Obviously the above applies to any HTML Tables on the Web, not just in Google Finance.

Also note that a lot of the Charts are Flash or Java and hence can't be linked to.

 

[grfiv]

For a VBA function that reads the Google Finance XL stream and returns any of the parameters they supply try this


http://www.philadelphia-reflections.com/blog/2385.htm