Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started