Question: Please, using the excel sheet, and telling me what to put in each cell, help me solve this homework questions: Using the Daily data on
Please, using the excel sheet, and telling me what to put in each cell, help me solve this homework questions: Using the Daily data on global stock markets Calculate daily returns and clean the dataset by removing returns duplicate prices Match five indices using vlookup and clean all NA leading to same number of observations for all five indices. You cannot create Variance covariance matrix, otherwise. Using the matrices of weights, returns, and Variance covariance matrix, calculate Portfolio return Rp Portfolio variance and standard deviation Construct the optimized portfolio using stock market indices, starting with minimum variance portfolio MV P Select the portfolio weights that maximise the expected portfolio return subject to a target variance level min to min If the procedure above is followed repeatedly for different return targets, it will trace out the efficient frontier.
Draw the efficient frontier and discuss the changes in weights.
Note: You also need to be slightly careful to impose at least the restriction that all of the wealth has to be invested weights sum to one This restriction is written as wN where N is a column vector of ones of length N
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
