View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kaleidoscopic Perspectives Kaleidoscopic Perspectives is offline
external usenet poster
 
Posts: 2
Default How do I extract information from these websites onto Excel?

I have the following stock symbols:

SYMBOL
NCST
CRMH
PXPL
DEIX
EMS
SPSN
CNCP
CPA
RPB
STP
SCOP
TRAK

I also know where the URL for information on these stocks reside. They
reside at:
http://finance.yahoo.com/q/ks?s=NCST
http://finance.yahoo.com/q/ks?s=CRMH
http://finance.yahoo.com/q/ks?s=PXPL
http://finance.yahoo.com/q/ks?s=DEIX
http://finance.yahoo.com/q/ks?s=EMS
http://finance.yahoo.com/q/ks?s=SPSN
http://finance.yahoo.com/q/ks?s=CNCP
http://finance.yahoo.com/q/ks?s=CPA
http://finance.yahoo.com/q/ks?s=RPB
http://finance.yahoo.com/q/ks?s=STP
http://finance.yahoo.com/q/ks?s=SCOP
http://finance.yahoo.com/q/ks?s=TRAK

Note: The URL addresses were made using the concatenate function:
=concatenate ("http://finance.yahoo.com/q/ks?s=", a2) ---- Where
a2 is the stock symbol.

Now, here's where it gets interesting. How do I:
1. Extract specific information for each of the websites, such as
http://finance.yahoo.com/q/ks?s=NCST? Specifically, I'd like to be
able to copy and paste one of the cells of this page. I'd like to do
this task for everyone of those stocks (i.e. URLs) listed above.

Thanks in advance.