GoalSeek
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.
Library
Optimization Functions library (Optimization Functions.ana)
- Use File → Add Library... to add this library
Notes
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.
Enable comment auto-refresher