Skip to search.

Breaking News Visit Yahoo! News for the latest.

×Close this window

Understanding historical prices

ID: SLN2311
Refers to: Finance

Description

Learn more about historical prices on Yahoo! Finance, including:

  • What and where historical data are available
  • How to download historical data
  • How adjusted close values are calculated

Resolution

You can view historical price data on Yahoo! Finance for most funds and companies by clicking Historical Prices under the “QUOTES” navigation menu.

Historical prices can be filtered by a custom date range, or by using these preset filters at the top of the page:

  • Daily
  • Weekly
  • Monthly
  • Dividends Only

Historical prices include the daily open, high, low, close, and volume for each trading day shown.

  • Weekly historical prices show:
    • Opening trade of the first trading day for the week.
    • High and low price quotes of the week.
    • Closing price on the last trading day of the week.
    • Adjusted close, based on closing price.
    • Weekly volume is the average daily volume for all trading days in the reported week.
  • Monthly historical prices show:
    • Opening trade from the first trading day of the month,
    • High and low price quotes for the month,
    • Closing price on the last trading day of the month.
    • Adjusted close, based on closing price.
    • Monthly volume is the average daily volume for all trading days in the reported month.
  • Historical Dividends show the dividend distribution amount and the ex-dividend date of the distribution.

Downloading historical data

  • To download historical prices, scroll to the bottom of the page and click Download to Spreadsheet.
  • To download historical dividend data click the Dividends Only filter. Then click Download to Spreadsheet.

Note: If the data requested is beyond the range of historical prices available through Yahoo! Finance, all available data within the range is displayed. Historical prices typically do not go back further than 1970.

Understanding the adjusted close

Adjusted Close provides the closing price for the requested day, week, or month, adjusted for all applicable splits and dividend distributions. Data are adjusted using appropriate split and dividend multipliers, adhering to Center for Research in Security Prices (CRSP) standards.

  • Split multipliers: determined by the split ratio.
    • For example, in a 2 for 1 split, the pre-split data are multiplied by 0.5.
  • Dividend multipliers: calculated based on dividend as a percentage of the price, primarily to avoid negative historical pricing.
    • For example, when a $0.08 cash dividend is distributed on Feb 19 (ex-date), and the Feb 18 closing price is 24.96, the pre-dividend data are multiplied by (1-0.08/24.96) = 0.9968. Below is a detailed example of adjusted close calculations.

Adjusted close calculation example

This example shows how split and dividend multipliers are calculated and applied, to determine adjusted close prices:

Date Close, Dividend, or Split
2/13/03 Close = 46.99
2/14/03 Close = 48.30
2/18/03 Split = 2:1
2/18/03 Close = 24.96
2/19/03 Cash Dividend = 0.08 (ex-date)
2/19/03 Close = 24.53
 

  1. The multipliers are determined using the split and dividend:
  • Split Multiplier = 0.5
  • Dividend Multiplier = 1 - (0.08/24.96) = 0.9968 
  1. Using these split and dividend multipliers, the adjusted close prices are calculated:


Date Adjusted close calculation
2/13/03 0.5 * 0.9968 * 46.99 = 23.42
2/14/03 0.5 * 0.9968 * 48.30 = 24.07
2/18/03 0.9968 * 24.96 = 24.88
2/19/03 24.53



Last updated: February 28, 2013
Rate this article:
Thank you! Please complete the form to submit your rating/feedback.

Please tell us why you didn't find this helpful.

  • The article needs updating or needs additional information.
  • The article is confusing or hard to follow.
  • The article describes the correct issue, but it doesn't solve the problem.
  • Other
  • I have feedback about the product or feature.

Forgot your password?

Can't access your account? Help is on the way!

Help on Yahoo! Answers

Get quick assistance from the community members and Yahoo!

 
 

How can we help?

Yahoo! Customer Care is here to help you with your question or issue.

Copyright © 2013 Yahoo! All rights reserved.   Privacy Policy | Terms of Service