Goal-seeking

Discussion of things that should be added, pet peeves, etc.

Moderator: giles

Goal-seeking

Postby rhoro on Mon Feb 08, 2010 6:54 pm

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?
rhoro
 
Posts: 3
Joined: Mon Feb 08, 2010 6:53 pm

Re: Goal-seeking

Postby glenn on Tue Feb 09, 2010 10:32 am

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.
glenn
Resolver Systems
 
Posts: 115
Joined: Wed Dec 12, 2007 6:36 pm

Re: Goal-seeking

Postby giles on Wed Feb 10, 2010 1:12 pm

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
giles
Resolver Systems
 
Posts: 137
Joined: Mon Jun 04, 2007 5:18 pm


Return to What's missing?

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests

cron