Page 1 of 1
Is there a solver tool?
Posted: Tue Jan 31, 2017 3:03 pm
by karinat1045
Hello everyone, I am looking for a solver program like the excel's solver. I need to find a rate that makes a difference equal to zero, is a cash flow with terminal value that needs to be equal to a number.
A program, an add-in or a command would be very appropiate.
Thanks a lot!
Karina
Re: Is there a solver tool?
Posted: Thu Feb 02, 2017 3:56 pm
by javiersan
Re: Is there a solver tool?
Posted: Mon May 15, 2017 2:45 pm
by karinat1045
I tried with the add-in irrval, but i could not programmed it. Does anybody knows if i can code an add-in? Or how can i use it in a loop? Thanks
Re: Is there a solver tool?
Posted: Mon Dec 18, 2023 2:59 pm
by dagfinnrime
Hi
I too failed to manage to use the command-line version of irrval. Tried both the global command, and the series version.
Irrval(series=«seriesname»)
Irrval(«seriesname»)
Irrval(seriesname)
(And with versions like scalar test = …. Any of the above).
Seriesname.irrval(results)
Since the menu -alternative is working I guess all that is needed is an update of documentation.
Dagfinn
Re: Is there a solver tool?
Posted: Mon Dec 18, 2023 4:05 pm
by EViews Matt
Hello,
Take a look at EViews'
optimize command, which is the general purpose command for user-defined optimization. It requires knowledge of EViews programming to use, but it's very flexible once understood.
Re: Is there a solver tool?
Posted: Mon Dec 25, 2023 12:52 am
by trubador
Hi
I too failed to manage to use the command-line version of irrval. Tried both the global command, and the series version.
Irrval(series=«seriesname»)
Irrval(«seriesname»)
Irrval(seriesname)
(And with versions like scalar test = …. Any of the above).
Seriesname.irrval(results)
Since the menu -alternative is working I guess all that is needed is an update of documentation.
Dagfinn
Yes, the problem is due to output argument. Use "result" instead of "results" when calling the add-in from the command line and it should be fine. Please let me know if the problem persists.
Re: Is there a solver tool?
Posted: Mon Dec 25, 2023 12:55 am
by trubador
I tried with the add-in irrval, but i could not programmed it. Does anybody knows if i can code an add-in? Or how can i use it in a loop? Thanks
Each add-in comes with the help file, where author explains its use in detail. You can find the document in the add-in's folder-> C:\Users\...\Documents\EViews Addins\irrval