How do I write a URL to download multiple historical stock quotes at a time?

Answer 1

I don't believe there's a way to download more than 1 ticker symbol at a time... but...

You could download multiple CSV files (to open in Excel) like this:
http://ichart.finance.yahoo.com/table.csv?s=YHOO&d=6&e=8&f=2006&g=d&a=3&b=12&c=1996&ignore=.csv

In the URL above, here's how the variables break down:
s = ticker symbol
d = end month -1 (January = 0, December = 11)
e = end day
f = end year
a = start month -1 (January = 0, December = 11)
b = start day
c = start year

If you knew the date range, and all the ticker symbols, you could write a Javascript function that downloaded all ticker symbols for all the dates.

When you download all your files (either manually or through a custom function) you can combine the contents of all of them in Excel and then sort by ticker symbol or date.

Answer 2

Try Google