Yahoo Historical Quotes Downloader.xls

[scifos]

Just thought I'd put this up here for anyone who needs or wants to download historical data from Yahoo Finance.

End Date is automatically set to the current date.
Start Date is set to 140 days in the past. Feel free to change either of these
Put in the tickers you want in column B under 'Symbol' and push the 'Get Prices' button. Excel will save a .csv file for each ticker in the same directory as the workbook.

I also have one that creates a new sheet in the workbook for each symbol if you don't want all the seperate files, but it is 10x slower.

Edit: I guess I can't upload it to the forum. PM me if you are interested and I can email it to ya. It's pretty slick.

[tulsatom]

I'm newbie in this in Feb 06 you posted a spreadsheet data downloader - can you send Yahoo Historical Quotes Downloader.xls to me?
tom_tulsa@yahoo.com

[Mien]

Please send it to me as well.

My email is investor2011@hotmail.com.

Thanks a bunch.

[Shep]

Hello Scifos.......Do you think it would be possible to send me the historical quotes downloader also?
My e-mail is:cshep11@hotmail.com
Thanks alot.

[slouie39]

I'm new to this site. I've seem messages indicating you can email a spreadsheet data downloader - can you send Yahoo Historical Quotes Downloader.xls to me?

Thanks
Bob

[scifos]

I'm new to this site. I've seem messages indicating you can email a spreadsheet data downloader - can you send Yahoo Historical Quotes Downloader.xls to me?

Thanks
Bob

I'll need an email address

[Karel]

OK, here is the downloader. I finally succeeded in uploading it, after some fiddling. There seemed to be something wrong with the upload permissions. Anyway. I zipped the file together with the (necessary!) Data folder.

Regards,

Karel

[scifos]

Props to Karel!

[mimo_100]

OK, here is the downloader. I finally succeeded in uploading it, after some fiddling. There seemed to be something wrong with the upload permissions. Anyway. I zipped the file together with the (necessary!) Data folder.

Regards,

Karel

Karel,

When I click on "Get Prices", I get a disabled macros message. What is the magic word to get this thing running?

Thanks.

Tim

[scifos]

Karel,

When I click on "Get Prices", I get a disabled macros message. What is the magic word to get this thing running?

Thanks.

Tim

In excel, click on "Tools" then "Macros" then "Security" and set to "Medium". Close excel and re-open the file. It will say macros can be dangerous and ask if you want to enable them for this file. Click yes and you're set.