How to Download Historical Stock Prices From Yahoo! Finance

Learn how to download historical stock prices from Yahoo! Finance.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Computer
• Internet connection

1. 
   Enter ticker symbol or company name

   Navigate to http://finance.yahoo.com and enter the ticker symbol for the stock whose historical prices you want to retrieve into the text box beside the "Get Quotes" button near the top left corner of the page. If you do not know the ticker symbol just begin typing the name of the company into the text box. Select the company from the dropdown list that appears or press "Get Quotes."

2. 
   Select

   Select the "Historical Prices" link from the "More On..." box to the left of the current quote.

3. 
   Change search parameters

   Yahoo! Finance will return a set of daily historic prices for the stock you selected. You can change the parameters for the search in the "Set Date Range" box. Here you can change the start and end dates for the search as well as the frequency of prices to return (i.e., daily, weekly, monthly).

4. 
   Download the data

   Once you have the data you want scroll to the bottom of the list of prices and select the "Download To Spreadsheet" link. You can choose to save the data to your hard drive or open it directly into your spreadsheet software.

Tips & Warnings

• Yahoo! Finance will give you Open, High, Low, and Close prices plus Volume for each period you requested.
• You will also see a column called Adj Close. These prices are adjusted for dividends and stock splits.

Resources

• Yahoo! Finance

[raldjq]

on 2/28/2009 good info. :)