The article How to Calculate the Regression of 2 Stocks Using Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days.

Programs such as Excel, Access, etc. how become incredibly powerful and can be powerful tools in the hands of the individual investor.

How to calculate average stock returns in Excel In the following example, I'll calculate the returns for Microsoft stock using historical prices and dividends. The first step is to get organized.

Retrieving up to date stock market prices for Excel is a snap with the free Stock Connector add-in. Here's a walkthrough of how you get it and how it works.

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...

Microsoft STOCKHISTORY allows users to visualise history of stocks and financial instruments in Excel It is currently available in beta for Microsoft 365 subscribers in the Office Insider program.