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

S

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?
 
A

Arvin Meyer [MVP]

StockResearcher said:
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?
Click to expand...

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.
 
Top