These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 14, 2010

Calculating and Graphing the Efficient Frontier for a Stock Portfolio


PROBLEM.

Another assignment a few weeks ago for one of my classes. A spreadsheet calculating and graphing the Efficient Frontier for portfolio of chosen stocks based the required return of the chosen stocks.

SOLUTION.

After finishing the assignment, I decided to simplify the process as much as possible. Thus, this program was created to calculate and graph the Efficient Frontier for portfolio of chosen stocks based the average required return of the minimum and maximum of the chosen stock returns.

OVERVIEW.

See the files below. To calculate and graph the Efficient Frontier, please press the Start button and follow the instructions.


Explanation

Xlsm-file

1 comment:

  1. Hey i am making a similar project and using your code as a guide. Thanks for your great work. But the solver module requires password. Can you remove that password thing. it would be really helpful.

    ReplyDelete

Blog Archive