EXCEL QUESTION

Download from finance.yahoo.com the dividend and split adjusted monthly stock prices of Home Depot (HD), your company, S&P 500 (SNP) index for the period from 8/1/2012 to 8/31/2018. You should have 73 monthly observations. Note: you enter ^GSPC as the symbol for the S&P 500 index in finance.yahoo.com.

1. Combine all three data sets into a worksheet and clean up to have only four columns: date, HD prices, your company prices, and SNP index. Format the date column in MMM-YYYY; May-2018, for example, and sort the data in the ascending order (oldest to newest). This sorting is very important as the returns will be computed rt = (Pt Pt-1) / Pt-1