As I mentioned in my first post to your question, you would need a loop
instead of a separate sheet for each symbol.

for each symbol in symbols

modify your url here
"URL;http://table.finance.yahoo.com/d?a=7...9&f=2004&g=d&s
=nt.to"
"URL;http://table.finance.yahoo.com/d?a=7...9&f=2004&g=d&s
=" & symbol & ""

use the data as desired with another macro to copy to the sheet desired.
As you saw on my program, I bring to the data sheet and then extract the
values to the desired column on the main sheet. This could be modified to
copy to a new sheet if desired.

next symbol

As Tom said, you could have it set up and just modify the symbol for each
refresh.
======


Don Guillett
SalesAid Software

"Kent" wrote in message
om...
Don,
You are probably correct in that I may be making things more
difficult than is necessary. I reviewed your *.xls sheet and I was
very impressed. Using your file as a reference I hoped to build
something simular in that it retrieves historical data (open, close,
volume etc.) for variable dates x to y for each stock (of my choice)
and places this information into its specific worksheet. As time
increases I would like certain stocks in the file to update (the
ability to be more picky as t +). The reason for this is that I have
developed analysis macros to systematical review each stock relative
to the S&P 300, their sectors and independent performance set by my
personal criterias. The part in the puzzle that I require help with is
in the development of the retrieval query. As I mentioned, I reviewed
your file and I was hoping to use/feed off part of it by linking your
'enter stock symbol' to my list of symbols, however, the file was
locked and prevented me from doing so with a macro. It is your output
'data' that is of interest to me and the apparent simplicity of the
file.Could you please expain to me how to create a web query as simple
as yours with the ability to feed off a list of symbols? I know how to
save the results to the sheets I have, which are in other reference
workbooks. Thank you for your interest in my problem! If it helps to
know I am using office xp.

Regards,
Charles Kent