Web Query

[ellevers]

I am going to try to explain my problem the best i can.

I am doing a web query to pull option quotes from the cboe web page.

the web query goes like this:

http://quote.cboe.com/QuoteTable.asp?TICKER=brcd&ALL=2
^ ^
varible
what i want to be able to do is make a cell for the symbol i want to pull the qoutes for as in the example above "brcd" being the symbol and variable that i can change in the web query and then next to the designated cell with the ticker symbol have an update button that once clicked on will go and do a web query with a new ticker symbol.

I am not sure if this needs to be in vba to do it

Thanks so much

let me know if it is not clear

 

[PaddyD]

Hi,

welcome to the board1

You're right about the vba - the process is
1) get vba to pick up the value in the cell
2) get vba to construct a new query file with the appropriate url
3) get vba to run the query

check out:

http://www.mrexcel.com/board/viewtopic.php?topic=11973&forum=2

where reefland has posted some code for this sort of thing - if you can't adapt it for your use, post back with more details about what cell the stock symbol is in etc...

Paddy

EDIT: I'm only on xl97 sr2 here, so it could be that later versions will give you an alternative solution...
This message was edited by PaddyD on 2002-09-02 19:39