Need help for a good data source

[Timothy Clontz]

I'm flying blind this weekend. Yahoo keeps creating an error when I try to download price and volume information. Is there another data source other folks are using they would recommend? I need to import historical stock info via an Excel macro.

Thanks.

[Billy]

I'm flying blind this weekend. Yahoo keeps creating an error when I try to download price and volume information. Is there another data source other folks are using they would recommend? I need to import historical stock info via an Excel macro.

Thanks.

Google Finance will do it. Search for ticker, then go to historical prices and export.

http://www.google.com/finance#
Billy

[Timothy Clontz]

I'll try to adjust the code to import from google tomorrow. Hopefully I can have the problem fixed this week. It's maddening flying blind.

[mnoel]

I'm flying blind this weekend. Yahoo keeps creating an error when I try to download price and volume information. Is there another data source other folks are using they would recommend? I need to import historical stock info via an Excel macro.

Thanks.

I am using this software to download one-minute data for the SP500 every week. Very good!

http://www.volumedigger.com/Software...ownloader.aspx

[Harry]

I am using this software to download one-minute data for the SP500 every week. Very good!

http://www.volumedigger.com/Software...ownloader.aspx

FYI volumedigger (when Yahoo source) downloads from the BATS Exchange, hence the 1-minute volumes are a lot less than total traded volume.

[TraderD]

I'm flying blind this weekend. Yahoo keeps creating an error when I try to download price and volume information. Is there another data source other folks are using they would recommend? I need to import historical stock info via an Excel macro.

Thanks.

DTN IQFeed serves me well for years.

Trader D

[Timothy Clontz]

Thanks a million, everyone.

There's a product called BulkQuotesXL that will solve my problem. Just tested it on my sector model (only uses 100 stocks) and it worked just fine. Adjusting my code to use it took no time at all, and the program doesn't spazz out trying to get the data from Yahoo like my macro started doing.

I should be up and running again tonight.

NOT FUN being blindsided like that!!!

[senco]

Timothy - good you found a solution that works.
I thought of posting the following anyway, as this is a tool that might be very useful for others on this board:

http://finance.groups.yahoo.com/group/smf_addin is a Yahoo group for the Stock Market Functions Excel add-in developed by Randy Harmelink. This is a very flexible set of user defined functions that can extract financial data from the web - quotes, fundamentals, and more from numerous sources. It has been out there for a number of years, the user group is active and Randy supports users.
It is free.

[Timothy Clontz]

Thanks. I actually downloaded the add-in and joined the group before finding the other solution. I may do more with this tool in the next few weeks, but I needed a quicker, dumber fix ;-)

The good news is that I'll be able to incporporate some end of day trading. I've adapted my sector model (i.e. the small portfolio) to be able to trade at 3:45. I should be able to do the same with the full Mousetrap.

Won't have to worry about morning gaps on my rotation days if this works out.