Preparing the Data in Excel To calculate beta, you need a time series of prices for both the investment and the market. For example, you might set up columns showing the closing prices of Stock XYZ and the S&P 500 over a set date range. This is information you can download from sources...