PDA

View Full Version : Yahoo Historical Quotes Downloader.xls



scifos
02-13-2006, 09:39 PM
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
03-06-2006, 01:52 PM
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
03-09-2006, 02:57 AM
Please send it to me as well.

My email is investor2011@hotmail.com.

Thanks a bunch.

Shep
03-17-2006, 08:30 PM
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
03-24-2006, 11:41 AM
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
03-24-2006, 01:57 PM
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
03-26-2006, 09:21 AM
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
03-26-2006, 08:25 PM
Props to Karel!

mimo_100
07-12-2006, 03:05 PM
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
07-13-2006, 03:54 PM
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.

jamiew
07-21-2006, 01:54 PM
Oh, if any one is interested i programmed a Historical Data downloader a while back too. Its just that i found yahoo only lets you do about 6 months at at time, I programmed something that you could just click sp500 or ftse 100 etc, put a date to start and end and click ok. (it still uses yahoo data)

(- just in case you cant get this one going)

so you can download thousands of stock data in one go, there is a free piece of software out there already(called metastock) its a free trail of about 3 months i think, then u have to pay.

Anyway if any one is interested email me at : rickyjwhoop@hotmail.com

(donít worry I donít charge). I just have to check its all still working correctly first and if its still easy to deploy, havenít used it in a few months.

sharrychrist
07-20-2007, 12:03 PM
Hi, this post is very informative; however I would like some specific information. If someone can help me then please send me a private message. Best Regards,

ricksstocks
10-05-2007, 04:08 PM
I'd like a copy of your historical data from Yahoo Finance if you don't mind.
Thanks.
Ricks_stocks@yahoo.com

rwhite
06-11-2009, 09:16 PM
I know to post is a bit old but if your still watching it first off thank you for the great Historical Quote Downloader second I was hoping you might be able to send me the one that makes a new sheet for each symbol.

my email twiatitc@gmail.com

thanks again

Advice Pro
09-03-2009, 06:50 AM
Where to download things this from Yahoo?

manymaniyaa
03-15-2019, 08:41 AM
Hello Scifos.......Do you think it would be possible to send me the historical quotes downloader also?
My e-mail is:cshep11@hotmail.com PhenQ (https://phenq-reviews.com/) | https://phenq-reviews.com (https://phenq-reviews.com/)
Thanks alot.

All of these are not making the things which you are not quotes easily

jiesen
04-25-2019, 12:01 AM
All of these are not making the things which you are not quotes easily

I find this thread fascinating right now.