Web Query

[scottbro]

Guys...I'm looking to add a single stock ticker to my spreadsheet. I'm working in Excel 2000, so I'm guessing the option to use is the "Data---> Get External Data---> New Web Query..." The thing is, I navigate to the site I want that contains the ticker, and then when I go to specify which table it is, I have no clue, even after looking at the html code. Anyone know how to identify the name of a table, such as in my case? Or, if anyone has any other ideas/advice as to how to accomplish my objective other than this way, please do not hesitate to clue me in! Thanks...

 

[Mark W.]

See the Excel Help topic for "Get data from a Web source". Look specifically at the Notes section.

What web site are you trying to use?
This message was edited by Mark W. on 2002-02-26 12:43

 

[Guest]

I'm fine with getting the data onto the spreadsheet...what I would like is to only list the current market price, without all the other info that is usually contained in the table containing this. For example, usually the table containing the current price also has opening price, # of shares, volumes, change in price, etc. I only want to have the current market price appear in my sheet, and I don't know how to only bring this value into excel...any ideas?

 

[gplhl]

Send the url of the page that the ticker is on and maybe someone will be able to extract just that for you or work something out.