Improved estimation of covariance matrix for portfolio optimization

1. Improved estimation of covariance matrix for portfolio optimization • PriyankaAgarwal • RezChowdhury • Dzung Du • Nathan Mullen • Ka Ki Ng

2. Progress since the last presentation: • 1. Progress in implementation of Ledoit’s Industry Factors estimator • 2. Standard error calculations (assuming iid Gaussian distribution) • Calculations for annual returns for estimators • Other work in progress: • --The option to not look at the out-of-sample data when selecting portfolio. • --Writing portfolio data out to text file (to facilitate analysis) • --Started standard error calculation using bootstrapping method

3. Progress in implementation of Ledoit’s Industry Factors estimator Sharpe’s Single-index model (p.5 of Ledoit): Industry Factors model (p.14 of Ledoit): is a “dummy variable” equal to 1 if the stock “i” corresponds to the industry “k”. It is equal to zero otherwise. is equal to the industry “k”s average return at time “t”.

4. Progress in implementation of Ledoit’s Industry Factors estimator (cont.) Ledoit uses the same industry grouping as Fama and French’s 1997 “Industry Costs of Equity” in Appendix A: -Uses ranges of Standard Industrial Classification (SIC) codes to group stocks of similar industry into the same group. -SIC code is a 4 digit code ranging from 0100-9999. -The 2 first numbers (from left to right) refer to a “major group”, whereas the first 3 numbers refer to an “industry group”, and all four refer to the specific industry (CRSP website) -Fama and French break up different industries into “industry” groups different from the one’s indicated by the SIC code.

5. Progress in implementation of Ledoit’s Industry Factors estimator (cont.) • For example (partial screen-shot from Fama and Frech Appendix A): (see http://www.ehso.com/siccodes.php for a nice list of SIC codes and meanings)

6. Progress in implementation of Ledoit’s Industry Factors estimator (cont.) • We put all of these mappings into a big chain of if-elseif statements • Our testing revealed a small mistake in Fama and French’s industry grouping: • SICs 3210-3219 are included in two different industry groupings: Group “321x” refers to “Flat Glass”, which is likely best grouped into Construction Materials

7. Progress in implementation of Ledoit’s Industry Factors estimator (cont.) • 32 SIC codes exists in the 1960-2009 data that don’t map to Fama and French Industry groups • We will manually place these in the groups where we think they fit best. • At this point we have all of the code that calculates the industry averages. • Need to use these to calculate Betas, and then the covariance matrix (see page 245 of text)

8. Calculated Standard Deviation and Standard Error T = 23 * 12 = 276 (standard error formula taken from Note)

9. Average Annual Return: 1972-1995(unconstrained)

10. Future Work • Finish Industry Factors implementation • Finish the option to not look at the out-of-sample data when selecting portfolio. • Calculate Standard errors by resampling • Add additional output data (write to file).