Top 2 Websites for 10-Year Historical Stock Data

There are hundreds of websites around that provide real-time quotes and basic fundamental data for stocks such as P/E ratio, EPS, etc. Usually only current information is available however, as of the current trading day. Value investors by contrast often need up to 10 years of historical fundamental stock data to complete their research. Fortunately there are two excellent websites available that provide free ten year historical data. We’re going to look at both of them today.

The two historical data resources we’re going to look at each have their pros and cons, but both are excellent:

  1. GuruFocus: A site geared towards providing value investors with data specific to their needs. Besides offering 10-year financials, GuruFocus also calculates valuable metrics not available on other sites such as the Piotroski F-Score, Altman Z-Score, and Beneish M-Score. All data can be downloaded for use in MS-Excel.
  2. Morningstar: Beautiful interface and offers 5-year and 10-year historical financial data. It also allows users download historical data directly to excel, saving a lot of time for detailed analysis.

Guide to GuruFocus Historical Financials

Website: http://www.gurufocus.com

GuruFocus has tons of tools, calculators, and information available to help value investors make decisions, but in this article I’m going to focus specifically on the historical financial data that’s available, and how to access it.

10-Year Financials

After navigating to the GuruFocus website and entering a ticker symbol, you’ll be brought up with a great summary page, which does an excellent job of outlining the current condition of the stock. For this example I am going to use Apple (AAPL). The historical financials can be found by navigating to the 10-Y Financials tab in the navigation menu (click to enlarge).

This is the most useful and thoughtfully laid out set of company financials I have ever seen. The income statement, balance sheet, and cashflow statement are all displayed on the same page so that information can easily be compared without having to flip back and forth between multiple pages. The past 10 years of annual historical data, the past 5 quarters of quarterly data, and the latest TTM data are all displayed in one easy-to-use layout. The numbers can be displayed as either dollar amounts or as a percentage by clicking the toggle button.

Besides the financials, GuruFocus also displays all of the common per share metrics such as EPS, RPS, BVPS for the past 10 years as well. Below that are all of the historical key ratios such as historical ROE, ROC, ROA, margin data etc. A premium subscription to GuruFocus allows access to historical P/E, as well as some other data not available on other sites to my knowledge such as historical Graham Number, Piotroski F-Score, Altman Z-Score, and Beneish M-Scores.

One of the most useful features however is the ability to export all of this data directly to excel. This is accomplished by clicking on the export button near the top right corner of the table. Unfortunately it is only available to premium members, but GuruFocus does usually offer a free trial.

Guide to Morningstar Historical Financials

Website: http://morningstar.com

We’ll now look at the Morningstar site in more detail and look at the data that’s available to us. Each of the key features will be explored in detail, including explanations of where to find the relevant data.

Quick Summary of Recent Historical Data

Morningstar offers a quick snapshot of the past three years of annual financials, along with the most recent quarterly financials alongside the same quarter’s data from a year ago. This is extremely useful for getting an immediate feel for how the company has been performing in the recent past.

The key line items from the income statement, balance sheet, and cash flow are all included in this concise summary. It can be found on the Quote tab of the navigation menu.

10-year and 5-year Historical Financials

Morningstar offers a beautiful interface for exploring long term historical financials. There are two settings – 5 year data is available for free, while 10-year data requires a premium subscription. By clicking buttons in the interface you can choose whether to display the numbers as dollar amounts, percentages, or fractions. You can select whether to display annual or quarterly data, and the table also includes another column for trailing twelve months (ttm) financials.

These financials are all found surprisingly enough under the Financials tab of the navigation bar, and then the Income Statement, Balance Sheet, or Cash Flow Statement can be selected from the smaller navigation bar down below. The home-run feature offered by Morningstar however, is the ability to download historical financial data directly into excel, simply by clicking the Export button. Here’s a screen shot of the data above imported into excel, without any other data manipulation:

Historical Price Data

Morningstar also includes historical price data. Both the date range and frequency can be selected, and there’s no limit to how many years back you can pull data from. Best of all, the data is exportable to an excel spreadsheet just by clicking the export button. Historical price data can be found under the Performance tab, and then the Price History sub-tab.

Historical Key Ratios, Growth Rates, and more

Under the Key Ratios navigation tab, there’s a wealth of information available, all presented in 10-year historical format, along with the latest ttm data. Included in the upper table are key metrics such as historical EPS, dividends, number of shares, book value per share, free cash flow, margin data, etc. The bottom table includes sub-tabs that display profitability, growth, cash flow, financial health, and efficiency ratios – again all over the past 10 years. Best of all, this entire dataset can be exported to excel.

Historical P/E and other Valuation Ratios

Clicking on the Valuation tab of the navigation menu brings up a summary of both current and forward valuations. More interesting however are the tables down below which provide historical P/E, P/B, P/S, and P/CF data for the past 10 years along with graphs. Historical P/E data can be useful in particular for determining the behavior of a company’s stock price is with respect to its earnings over time. Usually high growth companies command a higher price, but slow down as the company matures.

Links

Tagged , , ,

10 thoughts on “Top 2 Websites for 10-Year Historical Stock Data

  1. Liquid says:

    Pretty cool charts. Thanks for doing the research on this. I knew about morningstar, but this is the first time I’ve heard of gurufocus. It’s amazing how easily all the companys’ information is now available to the public through the interwebs :S

    • Dustin Small says:

      Yes – it’s great! Especially for guys like me who love playing with data and spreadsheets lol. Yes, GuruFocus is my “go-to” place for data nowadays. Still need to go to Morningstar for a few pieces that aren’t provided, but it’s pretty minimal.

  2. Both are great references. I pay for Morningstar’s premium package, I believe it’s around $10-$15/ month in order to get the 10yr data and some of their analysts reviews.

    • Dustin Small says:

      Yes, I’m considering getting one of the premium packages as well. It’s so nice to have a reliable source of data without having to go to six different sites to get what you’re looking for!

  3. Dustin, thanks to share step by step guidance to use both GuruFocus and Morningstar. I first time came through such easy steps explained to use a website or tool. When we talk about “Historical Stock Data” the first thing come in mind is “Accuracy and Reliability”.

    What do you think, the historical data shared here is accurate and reliable?

    • Dustin Small says:

      Hi Shawn, yes I have done a fair amount of testing on the data, and compared to the actual financial reports from the companies it’s based on — it looks to be accurate to me. Thanks for the comment.

  4. Jon Torrez says:

    For a couple of good data sets that you can export directly to Excel, check http://marketcapitalizations.com/historical-data/

    They have e.g. historical market caps and annual dividend yields for S&P 100 and NASDAQ-100 companies for the past ten years.

  5. Jay says:

    For individuals looking for 10 years of financial data to calculate Rule #1 based filters, here is a site that provides all of the big 5 ROI growth rates, margin of safety, sticker price, and payback times. The full list has all the raw data plus the calculated percentage rates. All the stocks in the list are filtered and scanned every quarter for the latest passing Rule #1 stocks.
    http://www.big5roireports.com

  6. Tom Mathers says:

    I just started using Robur Terminal (www.roburir.com) for this as they cover non-US stocks pretty well (I need UK stock data). Their SW is pretty useful as well for value hunting

Leave a Reply

Your email address will not be published. Required fields are marked *