Can Excel control webpages?

  • Thread starter Thread starter Tom Allen
  • Start date Start date
T

Tom Allen

I have a need to automatically extract stock market information from a
webpage. I know that Excel's Web Query function will allow me to grab a
webpage and paste it into the spreadsheet but that's not enough.

I'd like to be able to control the webpage. Automatically (thru some
type of macro), enter signon and password, enter information into a
webpage, click OK, grab some data, enter some more information, click OK
again....etc, etc.

But I need all of this to happen just by starting a macro and walking away.

I want to select several stocks and grab information from an Investor's
Business Daily (IBD) website.

Can this be done with Excel? And (generally) how?

If it can't, any other suggestions for software to use to do this?

Thanks.
 
I do this with Yahoo but have not mastered the login user name bit.
Maybe Yahoo has the info desired or I can custom design something.
What do you want?
 
Don,

From your comment, I'm assuming you extract stock information from
Yahoo and store it in Excel. I'm assuming you have automated the
process. And finally, I'm assuming you use Excel as the tool to do the
communication with the Yahoo website. Lots of assumptions, eh?

Here's what I want to do:

I want to start an Excel macro. The macro will go out to investors.com,
enter my user name, enter my password, click on a report, enter a stock
symbol, extract information from the report for that stock then finally
place that information into the Excel spreadsheet......then I want it to
repeat the process 20 times for 20 different stocks, then logoff. Then
I'll repeat it everyday.

I can write this myself, but I'm not sure if Excel is the proper tool to
use to do it.

Tom Allen
 
Yes to all. Let me know if I can help. I don't know about yours but I can
get hundreds from Yahoo with no looping.
I would like to know the code to bypass the security logon for username &
password?
 
Back
Top