[SOLVED] The James-Stein Estimates

A template is attached. You will walk through an example of calibrating a model to use for recommending portfolio allocations. The book is Portfolio Management: Theory and Practice by Stewart. First, download some data. Go to Yahoo Finance and download levels for the assets in the allocation below. Use the monthly adjusted close values (so you can ignore the dividend information) for the period :Start date: 12/1/2011End date: 12/1/2021(use the “max” time period to download and then trim to this range)This will provide ten years of monthly returns.
Part 1 – Calculate the log returns for these assets, and then calculate the James-Stein Estimates for these assets (Part 2)Now, assume that some rational investor will have the following asset allocation:15% Russell 2000 (^RUT)20% SPDR S&P 500 ETF Trust (SPY)20% Invesco QQQ Trust (QQQ)5% Clough Global Equity Fund (GLQ)20% iShares 20+ Year Treasury Bond ETF (TLT)13% iShares iBoxx $ Investment Grade Corporate Bond ETF (LQD)5% Templeton Global Bond Fund Class A (TPINX) 2% SPDR Gold Shares (GLD)The Yahoo Finance ticker is in parentheses for each asset.
This means that some investor, who is solving the mean-variance problem, will own this portfolio, which in turn means it has to be on the efficient frontier. Use the methodology discussed in the book for Implied Estimates to find a set of inputs that will put this allocation on the efficient frontier defined by these assets.
Part 3:This means you need to “pin down” the returns for two assets so that you can derive a risk premium for calculating the zero-beta CAPM implied returns for the other assets. For this exercise, use the James-Stein estimates for SPY and LQD in this role.
Part 4: Use the implied estimates and expand the “5 Asset Efficient Frontier” example to cover 8 assets, and see if using a target return equal to the implied estimates portfolio return actually recovers those asset allocations.
Download a blank template– just fill it in — this will be your submission for this assignment. Please don’t mess with the formatting