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
.

I didn't see anything in the original post that said he only wanted the
close. Was there a subsequent post that said this? Perhaps it isn't
showing up for me. Or was that implicit in the URL?

--
Regards,
Tom Ogilvy

"David" wrote in message
...
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
.

"Tom Ogilvy" wrote in message ...
I didn't see anything in the original post that said he only wanted the
close. Was there a subsequent post that said this? Perhaps it isn't
showing up for me. Or was that implicit in the URL?

--
Regards,
Tom Ogilvy

I guess the original poster did not say so, but I was looking
for something exactly like this.

I have a set of symbols in the columns (I guess I can change A1:A5
to A1:E1) and just want to get the adjusted closing price for the
past year in the columns below the symbols. This is the last column
in the spreadsheet on yahoo.

Eternally grateful to the kind soul who can provide this. This is
just too difficult for my present non-programming-oriented mind.

Kaspa [Only did some FORTRAN programming 15 years ago]

Did you look at my post?

--
Don Guillett
SalesAid Software

"The Chess Addict" wrote in message
om...
"Tom Ogilvy" wrote in message
...
I didn't see anything in the original post that said he only wanted the
close. Was there a subsequent post that said this? Perhaps it isn't
showing up for me. Or was that implicit in the URL?

--
Regards,
Tom Ogilvy

I guess the original poster did not say so, but I was looking
for something exactly like this.

I have a set of symbols in the columns (I guess I can change A1:A5
to A1:E1) and just want to get the adjusted closing price for the
past year in the columns below the symbols. This is the last column
in the spreadsheet on yahoo.

Eternally grateful to the kind soul who can provide this. This is
just too difficult for my present non-programming-oriented mind.

Kaspa [Only did some FORTRAN programming 15 years ago]

"Don Guillett" wrote in message ...
Did you look at my post?


Yes, I did, but I am not quite familiar with this
programming. It looks like I have to insert some more
code in your macro (you have mentioned add code here). I tried
to merge your code with Tom's solution, without much luck.
I guess I don't understand some parts of the code.

Tom's code runs well, but it creates too many CSV files and it
is harder to import only one column from them to the main
spreadsheet (at least for me).

Thanks for all your help.

Kaspa