How to Calculate Historical Return

Alternatively, you can get stock information from another financial information website, like MarketWatch, or directly from a stock exchange like Nasdaq. Many companies also provide this data in the investor relations portion of their websites.

1. Open the stock price data in a spreadsheet program like Microsoft Excel. Sort the data so the first column shows historical dates in descending order and the second column contains the corresponding stock price on that date. Delete any columns labeled Open, High, Low, Close and Volume; you won’t need that information to calculate the return.
2. Subtract the beginning adjusted close price from the ending adjusting close price for the period you want to measure. For example, say you’re measuring the historical return of the stock for 2014. If the adjusted close price was $100 on Jan. 1, 2014, and $150 on Dec. 31, 2014, the difference is $50.
3. Divide the difference between the ending and beginning close price by the beginning close price. In this example, that would be the $50 difference divided by the beginning adjusted close of $100, or 0.5. This calculation shows that the stock experienced a 50 percent historical return during the specified period.

You can measure the historical return of any investment, not just a single stock. For example, you can measure the historical return of the entire S&P 500 by getting the historical prices from the Yahoo Finance page. You can also search for data about a specific mutual fund or index fund. Follow the same formula — new price minus old price divided by old price — to measure the historical return on a physical asset, such as a real estate investment, precious metals or collectible items.