How To Download Spreadsheet From A Website?

Where to find history of stock prices, downloadable into spreadsheet?

• I want a list of stock prices for a 10- or 20-year history of a stock. I'll specify the stock ticker symbol, the history range, and the website will return me all the daily prices of that stock during that range. The website will return it to me in some way that I can download it (rather than just look at it). I do NOT want to look up each day, one at a time. When I say "stock", I mean anything that has a ticker symbol, including mutual funds. When I say "spreadsheet", I mean anything I can easily convert into a Word table, or an Excel spreadsheet. It would be fine to have plain text, with one line per day, each line showing the date and the price. I have found http://table.finance.yahoo.com/t?s=AHG&g=m does this, but its history goes back only 10 years. I need at least 20 years. Obviously I'd prefer this source to be free, but I'm willing to pay. If you can't find any free sources, I'll take whatever you can find. Thanks!

• Answer:

  Hello Mark, The Yahoo Finance site actually does allow customizable downloads of historical price information -- I've used the feature many times myself both for my own purposes as well as a tool for fielding questions here at Google Answers. For instance, historical information for IBM can be found here: http://finance.yahoo.com/q/hp?s=IBM NOTE that you can change the symbol to any stock/fund of your choice by simply altering the URL, and replacing "IBM" with the symbol of your choice. The link leads to a table that labelled "Historical Prices" that gives you a number of options: SET DATE RANGE allows you to <<ahem>> set the date range. For IBM, the "Start Date" goes back as far as 1962. You can also select the frequency of the data: either Daily, Weekly, Monthly, or "Dividends Only" By clickin on the "Get Prices" button, you'll retrieve some of the data, but at the bottom of the table is a link that reads: "Download To Spreadsheet" Clicking on this will get you the full history -- volume, prices, dividends, etc. As elmarto-ga noted, stocks with less historical information can mean, simply, that the stock has not been trading for very long. The Yahoo Finance tools should do the trick. But before rating this answer, please let me know if anything is unclear, or if you need additional information. Just post a Request for Clarification, and I'm at your service. pafalafa-ga search strategy -- Used bookmarked site for Yahoo Finance.