Create a portfolio that invests 24% of $1 million in company A, 22% in company B, 20% in company C, 18% in company D, and 16% in company E. The 5 stocks are as follows: Microsoft, Apple, Macy’s, Facebook, & Amazon.
Please enter the return correlations for the 5 stocks during the 2018 calendar year. Please use daily returns, and make sure to show your work.
All 5 companies have been publicly traded with daily price data available in Yahoo Finance.