How do I download stock price info from the internet in access or

[StockResearcher]

Is there a way to connect to the internet (e.g. Yahoo) and download
information about a group of stocks into an access 2007 database?

 

[Arvin Meyer [MVP]]

Is there a way to connect to the internet (e.g. Yahoo) and download
information about a group of stocks into an access 2007 database?

You can get to a particular stock in Yahoo by doing something like this:

Private Sub cmdYahoo_Click()
Application.FollowHyperlink "http://finance.yahoo.com/q?s=" &
Me.txtSymbol
End Sub

where txtSymbol is the stock symbol displayed in a text box on the form.
There's no way to identify a field on the web page that shows the price. If
the data at Yahoo was exportable, you may be able to click a button, get to
the relevant page at Yahoo, download the data to, say Excel, and
automatically connect to the Excel spreadsheet. Before I can give a
definitive answer, I'd need the URL of the Yahoo page.

 

[Michael Gramelspacher]

Is there a way to connect to the internet (e.g. Yahoo) and download
information about a group of stocks into an access 2007 database?

OK, try this. www.psci.net/gramelsp/temp/Yahoo_Stocks.zip

I downloaded it from somewhere. No idea where. I will keep it here for a day.