Individual efficient portfolio design
Each student is required to design an efficient portfolio frontier consisting of at least four companies (each from a different S &P 500 sector) using historical annual return data over the last fifteen years. A brief discussion of why the student selected the specific sectors and a specific company within that sector must be included in the assignment. Chapter 8 of Ragsdale shows a step by step approach for building the portfolio and drawing the efficient frontier diagram using Excel Solver.
Please get 15 years data from YAHOO finance