Stock Trading and Other Things

How can I download all stock quotes on all markets with daily data for the previous two years?

I think I would need access to a stock Quote server or something, but I don't know where to begin.

I want to be able to download every stock on every market (say 1000's of stocks nationwide), without having to manually type in each ticker.

Is this possible?

Thanks

Public Comments

1. Im not sure why you would want to do this, when for about the price of 1 soda per day you can subscribe to a great charting service (TC2000), that not only gives you price and volume, for all 8000 stocks and 500 ETFs and a multitude of indicies, plots them for you in 1, 2,3, 4, 5, 6, 7, 8, or 9d or 1m or 1Q or 1yr charts, but also gives you thousands of indicators like MS, RS, MACD, etc etc.

But if you insist, you can go to yahoo and setup a multitude of watchlists and download price and volume data into a CSV file to import into XL. I've been there and done that (and even used to plot the charts by hand on graph paper about 20 years ago) and can tell you that you'll be blown away.
///

2. Possible but beyond useless. Not of any value whatsoever.