Posted by Peter Aptaker on January 22, 1998 at 06:54:11:

In Reply to: Constrained QP Algorithm posted by Rex Macey on January 08, 1998 at 21:55:04:

: I would like to write (or buy) a program in EXCEL VBA to solve a portfolio problem (quadratic optimization with linear constraints). N will be less than 20. Where could I find an algorithm? Or code.

: BTW Excel has built-in matrix inversion and multiplication functions.

: I have an undergraduate degree in math (about 15 years ago), so I'm rusty.

Have you tried Frontline (who make the standard Excel Solver) ?

Edwin Straver