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