Querying Data from Google Finance

[belang46]

Hi all,

I know this has been asked in the past...so I apologize to be repetitive. Any links to prior data would be very helpful and much appreciated.

I am trying to get data from Google Finance for a stock analyzer spreadsheet. It is not as simple as using Excel's mini browser and clicking on desired tables. Can anyone explain (or refer me to some material) that shows how to query data from Google?

I'm not just looking for stock price in this circumstance; what i'm really after is historical financial statement data and the list of competitors. Just want it dumped in the spreadsheet, which i'll then wire to the rest of the sheets.

Please let me know, thanks a mil!

-Marcus

 

[c_m_s_jr]

http://www.mrexcel.com/forum/showthread.php?t=471110&highlight=Google+Finance

Did a search on Google Finance on the board and came up with this. Maybe it will at least get you started?