| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| copy information on a excel sheet and send to an outlook contact? | Excel Discussion (Misc queries) | |||
| Import information to Excel | Excel Discussion (Misc queries) | |||
| Formatting information copied and pasted from the WEB to excel | Excel Discussion (Misc queries) | |||
Threaded Mode
