[RESOLVED] How to download stock quotes from Yahoo?

[beamer-dreamer]

Has anybody done that or an idea/link on how to download quotes from free sites like Yahoo Finance?

Would another forum here be better suited for questions regarding data transfer over the internet?

Thanks! :)

[PeejAvery]

Are you just trying to parse specific quotes for certain companies? It would be insanely simply using their download quote (http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=sl1d1t1c1ohgv&e=.csv) links.

EDIT: You can see the "Download Data" link right below the graph (http://finance.yahoo.com/q?s=aapl). It will download a CSV file.

[beamer-dreamer]

Are you just trying to parse specific quotes for certain companies? It would be insanely simply using their download quote (http://download.finance.yahoo.com/d/quotes.csv?s=AAPL&f=sl1d1t1c1ohgv&e=.csv) links.

EDIT: You can see the "Download Data" link right below the graph (http://finance.yahoo.com/q?s=aapl). It will download a CSV file.

I want to download data regularly for a BIG number of stocks (>500). Although I am aware of the download feature that you mentioned it is not feasible to use it for such a big number of stocks. To do the download manually would take far too much time.

Therefore I want to write a program that collects the data automatically and stores it into an ACCESS database. I just don't know if YAHOO (or another provider) supports that.

The program would have to send a date (or a range of dates like a week or a month) and the stock names/ticker symbols to the site (plus what kind of data is required like: Open/Close/High/Low/Volume). The site would then return the data for each day and each stock.

It's just that I have never programmed a tool for the communication with a web site/server. Can you tell me some key words to search for?

Thanks!

[PeejAvery]

I think you are missing my point. You don't have to get just one stock quote. You can create an array of all the stock quotes you want. Then loop through the array downloading the CSV for each one. What is wrong with that?

[beamer-dreamer]

Thanks for your input. I found a FREE tool that does all I need: http://www.amichel.com/ydownloader/ :)