ABSTRACT
Similar to Crystal Ball simulations and part of the Crystal Ball package, OptQuest is an MS Excel add-on originally designed by Decisioneering and now owned and distributed by Oracle. It is an optimization tool that uses neural networks to find "optimal" solutions for analyses. Crystal Ball/OptQuest captures the three parameters for the assets within the defined Assumption Cells, i.e. return (E(r)), risk, and correlation coefficient (CC). OptQuest then captures the weight of the assets within the defined Decision variables. Graphically, OptQuest captures the portfolio parameters. The classic of optimization utilizing OptQuest is the simulation portfolio. OptQuest is absolutely required for a mature quantification of portfolio returns, risk, and optimal results. When adding OptQuest to an existing spreadsheet model the basic Crystal Ball page must be scaled to include Decision variables.
