Stock market info import from the web, given ticker

[rrbest]

I want to create a form where I input the stock ticker into a cell (say, GOOG) and click a button to import GOOG stock information from the web. I could start simple, so at this point it is not so important what gets imported as long as it works. I know how to create macros, and I know how to import from the web, but I am unsure how to combines these to get what I am trying to do. Any help is appreciated.

[rrbest]

Further example: Let's say I choose GOOG for the ticker symbol. I want to retreive a table from http://www.google.com/finance?q=GOOG with the click of a button. If i change the cell containing GOOG to AMZN, it should update the import from GOOG to http://www.google.com/finance?q=AMZN.

[jolivanes]

I had this hanging around. Does it get you started?

Regards
John

[MarvinP]

Excel has had a "Get Data from the Web" feature since Excel 2002.
See one article at
http://office.microsoft.com/en-us/ex...001045085.aspx
another article is at
http://articles.techrepublic.com.com...g=feed&subj=tr

The problem is that some of the websites from the past have changed their design and no longer use web tables, that Excel needs to know where to select the data from. Yahoo still works but MSN and Google finance don't seem to work now.

[ShredDude]

I recently answered a similar question on another forum. Here's some code I put together for pulling data from google finance. This code pulls the last price, but can be adapted to get anything.

Good luck with it.

Please Login or Register  to view this content.

[MarvinP]

Hey ShredDude,
GREAT CODE!!!
I stand corrected about getting stock prices. You simply took the source HTML code and extracted it without needing a table.
THANKS - I've been looking for a method to do this for years.