Web Query

scottbro · Feb 26th, 2002, 11:51 AM

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. · Feb 26th, 2002, 01:39 PM

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 ]

Feb 26th, 2002, 02:09 PM

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 · Feb 26th, 2002, 02:14 PM

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.

Feb 26th, 2002, 02:14 PM	#4
gplhl Board Regular Join Date: Feb 2002 Location: Chippenham, UK Posts: 136	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. __________________ Regards, Gary Hewitt-Long

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 26th, 2002, 11:51 AM	#1
scottbro New Member Join Date: Feb 2002 Posts: 11	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...

Feb 26th, 2002, 01:39 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

Feb 26th, 2002, 02:09 PM	#3
Guest Posts: n/a	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?