Goal-seeking

[rhoro]

I've scanned the forums (fora?) but have not seen any reference to goal-seeking. This is a must for a financial modelling system. Can this be implemented simply by coding some iterative convergence algorithm in the Post-formulae User Code section?

[glenn]

You could code a goal-seeking algorithm in user code in Resolver One. However, it might be easier and faster to use an existing framework like Microsoft's Solver Foundation. You can download the free Express Edition from http://code.msdn.microsoft.com/solverfoundation.

[giles]

If you did want to code your own goal-seeking algorithm rather than using Solver, you could definitely do it in Resolver One, but the easiest way would be to use RunWorkbook.

You'd create the model you wanted to run in one Resolver One spreadsheet, and then in another sheet (or even from stand-alone IronPython code) you would use RunWorkbook to "call" it from inside a while loop, putting appropriate values into appropriate cells and reading out the results, stopping when it converged on a solution (or made it clear that it wasn't going to converge).

You can read about RunWorkbook here: http://www.resolversystems.com/documentation/index.php/RunWorkbook.html