I went to the site that has the data. What the problem
appears to be to me is suppling symbols, individually to
the site and then then getting rid of the extraneous
data, since you only want the close. Then it becomes more
complicated, because you will then need to find the
symbol on your existing worksheet and give it your "new"
close. Seems at a minimum, what you need to do is
oriented to the website, as much as it is to Excel and
that a list of the symbols to look up would be needed.
Even with this start, part of what you are thrying to do
is web based.
-----Original Message-----
I'm fairly new to Excel and VBA.
Here is the situation:
1. I have a spreadsheet containing the symbols for the
S&P500 index in
A2:A501.
2. I can download data for a single symbol using the
yahoo website:
http://chart.yahoo.com/d?
a=9&b=1&c=2002&d=5&e=30&f=2004&g=d&s=
which will give me a link at the bottom of the page to
download 200
days of data in .CSV format.
3. I need to collect the data for all of the 500 symbols
and save them
to a /DATA driectory as *.csv
4. I need to be able to do daily updates
5. I need to be able to automate this whole process
Any help appreciated
.