how do i use the markowitz method with solver?

[NSD]

Hi... I'm using Solver on Excel. I need to come up with an efficient
portfolio of 5 stocks out of 10 that I have info for (covariances, returns,
betas, etc). I have the example on how to use the Sharpe model, but I need
to use the Markowitz method as I have to take covariances into account. I'm
using Excel XP.

Any help is greatly appreciated. Thanks!

 

[Jerry W. Lewis]

A Google search is a good place to start

http://groups.google.com/groups?as_q=markowitz&as_ugroup=microsoft.public.excel.*

Jerry