Problem with Solver add-in. Changing values

[johannes.liss]

I try to calculate the minimun variance portfolio from a varians-
covariance matrix. The problem is that the target cell has changed
value a couple of times when I made small changes and then changed
back so now I can't know which one is correct, how could this be? I
use this formula:
=MMULT(TRANSPOSE(DH2H26);MMULT(CE2C26;DH2H26))
DH2H26 = stock weights (which are being changed by Solver to
minimize target cell)
CE2C26 = variance-covariance matrix

Thanks!

 

[Dana DeLouis]

Hi. I am not sure of the question, but guessing from the size of the
problem, you may be running into Local Minimum values, and not Global
values. Just guessing of course.

=MMULT(TRANSPOSE(DH2H26);MMULT(CE2C26;DH2H26))

If I am not mistaken, this non-array entered formula should return the
same thing...

=SUMPRODUCT(DH2H26,MMULT(CE2C26,DH2H26))

= = =
HTH :>)
Dana DeLouis