Hi,

http://www.investor.reuters.wallst.c...asp?ticker=IBM

Trying to retrieve specific info from the web page.
ie: EPS (TTM) vs TTM 1 Yr. Ago

I can't seem to retrieve any data from the page, I have tried using the
following:

#1:
'Microsoft.XMLHTTP, MS COM object to retrieve data from another website via
HTTP requests
Set xmlhttp = CreateObject("Microsoft.XMLHTTP")

#2:
Set oIE = New SHDocVw.InternetExplorer
'Open the web page
oIE.Navigate
"http://www.investor.reuters.wallst.com/stocks/Ratios.asp?ticker=IBM


What is the best way to retrieve the data from this page?


Thanks.

What specifically happened when you tried those approaches?
They are both valid methods.


--
Tim Williams
Palo Alto, CA


"tech" wrote in message ...
Hi,

http://www.investor.reuters.wallst.c...asp?ticker=IBM

Trying to retrieve specific info from the web page.
ie: EPS (TTM) vs TTM 1 Yr. Ago

I can't seem to retrieve any data from the page, I have tried using the
following:

#1:
'Microsoft.XMLHTTP, MS COM object to retrieve data from another website via
HTTP requests
Set xmlhttp = CreateObject("Microsoft.XMLHTTP")

#2:
Set oIE = New SHDocVw.InternetExplorer
'Open the web page
oIE.Navigate
"http://www.investor.reuters.wallst.com/stocks/Ratios.asp?ticker=IBM


What is the best way to retrieve the data from this page?


Thanks.

Hi,

When I view the contents of the variable it doesn't have any of the data
shown on the webpage.
ie: EPS (TTM) vs TTM 1 Yr. Ago

Thanks.

"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
What specifically happened when you tried those approaches?
They are both valid methods.


--
Tim Williams
Palo Alto, CA


"tech" wrote in message
...
Hi,

http://www.investor.reuters.wallst.c...asp?ticker=IBM

Trying to retrieve specific info from the web page.
ie: EPS (TTM) vs TTM 1 Yr. Ago

I can't seem to retrieve any data from the page, I have tried using the
following:

#1:
'Microsoft.XMLHTTP, MS COM object to retrieve data from another website
via
HTTP requests
Set xmlhttp = CreateObject("Microsoft.XMLHTTP")

#2:
Set oIE = New SHDocVw.InternetExplorer
'Open the web page
oIE.Navigate
"http://www.investor.reuters.wallst.com/stocks/Ratios.asp?ticker=IBM


What is the best way to retrieve the data from this page?


Thanks.

tech wrote:

When I view the contents of the variable it doesn't have any of the data
shown on the webpage.
ie: EPS (TTM) vs TTM 1 Yr. Ago

Which variable are you looking at? You'll need to search through the
attributes of the oIE object to find the particular piece of
information you're looking for, or at least search the innerHTML using
InStr(). The page you're looking at using DIV and SPAN tags instead of
HTML tables, so it may be easier to use InStr().

If you're doing a lot with EXCEL and the stock market, I'd suggest a
visit to:

http://groups.yahoo.com/group/xltraders/
http://groups.yahoo.com/group/smf_addin/

They have tools in their libraries to retrieve financial data from web
pages.