GoalSeek(Y, X, g)

Finds the value of «X» that makes variable «Y» equal to «g».

To use, «X» and «Y» should both be variables in your model. GoalSeek solves a scalar problem. The function can be used in an array abstracted fashion (for example, with an array of goals), which amounts to solving several separate goal seek problems.


Optimization Functions library (Optimization Functions.ana)

Use FileAdd Library... to add this library


This is a simple Newton-Raphson-based algorithm for the scalar case. GoalSeek can be used from any Analytica edition; however, the Analytica Optimizer edition allows more powerful and flexible "solving", which may be necessary if you need to deal with local optima or additional constraints.

An example of usage is included with the library. The example finds the interest rate that achieves a desired bond value at maturity.

See Also


You are not allowed to post comments.