EXERCISE #5: Go to Yahoo!Finance, find the adjusted closing prices for XOM and GOOGL for the last day of 2014, 15, 16 and 17. Under Historical prices you can choose daily prices or monthly prices from 30Nov14 to 31Dec17 to read off the end-of-the-year prices. If you choose monthly, they may be marked by the wrong day of Dec, e.g. 12/1/2015 instead of 12/31/2015. Do not email me; figure it out. Compute continuous returns for 2015-17. Find the means and the st. devs of the returns (use stdev.p). Compute the returns for a portfolio invested 70% in XOM and 30% in GOOGL. Find the mean and the st. deviation of the portfolio. Do not write in greyed out areas. [Adjusted prices are not real; they may change everyday to reflect current stock splits or dividends going back in time; yours may not match mine; but the returns will be almost the same.] EXERCISE #5: Go to Yahoo!Finance, find the adjusted closing prices for XOM and GOOGL for the last day of 2014, 15, 16 and 17. Under Historical prices you can choose daily prices or monthly prices from 30Nov14 to 31Dec17 to read off the end-of-the-year prices. If you choose monthly, they may be marked by the wrong day of Dec, e.g. 12/1/2015 instead of 12/31/2015. Do not email me; figure it out. Compute continuous returns for 2015-17. Find the means and the st. devs of the returns (use stdev.p). Compute the returns for a portfolio invested 70% in XOM and 30% in GOOGL. Find the mean and the st. deviation of the portfolio. Do not write in greyed out areas. [Adjusted prices are not real; they may change everyday to reflect current stock splits or dividends going back in time; yours may not match mine; but the returns will be almost the same.]