Is there a solver tool?

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

karinat1045
Posts: 3
Joined: Mon Jan 30, 2017 2:45 pm

Is there a solver tool?

Postby karinat1045 » Tue Jan 31, 2017 3:03 pm

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

javiersan
Posts: 184
Joined: Mon Jan 19, 2009 8:18 am

Re: Is there a solver tool?

Postby javiersan » Thu Feb 02, 2017 3:56 pm


karinat1045
Posts: 3
Joined: Mon Jan 30, 2017 2:45 pm

Re: Is there a solver tool?

Postby karinat1045 » Mon May 15, 2017 2:45 pm

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

dagfinnrime
Posts: 49
Joined: Sat Oct 11, 2008 9:37 am
Location: Oslo
Contact:

Re: Is there a solver tool?

Postby dagfinnrime » Mon Dec 18, 2023 2:59 pm

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

EViews Matt
EViews Developer
Posts: 563
Joined: Thu Apr 25, 2013 7:48 pm

Re: Is there a solver tool?

Postby EViews Matt » Mon Dec 18, 2023 4:05 pm

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.

trubador
Did you use forum search?
Posts: 1518
Joined: Thu Nov 20, 2008 12:04 pm

Re: Is there a solver tool?

Postby trubador » Mon Dec 25, 2023 12:52 am

dagfinnrime wrote: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.

trubador
Did you use forum search?
Posts: 1518
Joined: Thu Nov 20, 2008 12:04 pm

Re: Is there a solver tool?

Postby trubador » Mon Dec 25, 2023 12:55 am

karinat1045 wrote: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


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 46 guests