Web Query

[Jar2112]

Hello,

-I am working with web queries and I would like to know if there is a way to input info in a cell to a website. For instance if I had a list of stock symbols and wanted a return data of the current price. Can I have excel go from cell A1 and take that info and input it in a blank in say Yahoo and retrieve the current price? I don’t want all the slop of the entire website.

-Any suggestions?

THANK YOU!!!

 

[DonkeyOte]

Hmm this isn't my expertise but depending on the website you're using you may find that the URL will contain an extension for each symbol - ie the normal page could say be

http://www.joebloggs.com/index.asp

then when you select a particular character to search (say $) you may find that when the website gets the data the URL will change - eg

http://www.joebloggs.com/getdata.asp?type=usd

where type is a variable the website uses to determine which data it's getting - so if your site works in this manner then you can just set your xl file to load specific addresses withouth having to enter the $ in to say the index page... so you just amend type= to match the criteria you want to get data for.

Does this make sense?