BookmarkSubscribeSubscribe to RSS Feed

XIRR

ron_horne

Super User

Joined:

Jun 23, 2011

Hi all,

Just wondering if anyone has a way of calculating IRR with actual dates as in XIRR in excell:

XIRR function - Office Support

thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Dahlia_Watkins

Joined:

Jan 24, 2017

Solution

Although there is not a specific function for XIRR and XNPV. You could try creating the algorithm Microsoft describes and create it in JSL. 

The algorithm that Excel’s XIRR page explains should be suffice to write a JSL. Hint: use Minimize. 

 

  • Tries to find the solution for  x^3+2*x^2-x+1 = 0 x = -4;minFun = minimize ( (x^3+2*x^2-x+1)^2, {x});sol = Eval List( {x, minFun} );solx = sol[1];show(solx^3+2*solx^2-solx+1)

Additionally, JMP Technical Support has submitted an feature request to add the Excel functions to JSL for a future release of JMP.

 

Regards. 

2 REPLIES
uday_guntupalli

Community Trekker

Joined:

Sep 15, 2014

@ron_horne , 
    I am looking for XIRR and XNPV in JMP - were you able to find any resources ? 

 

 

Best
Uday
Dahlia_Watkins

Joined:

Jan 24, 2017

Solution

Although there is not a specific function for XIRR and XNPV. You could try creating the algorithm Microsoft describes and create it in JSL. 

The algorithm that Excel’s XIRR page explains should be suffice to write a JSL. Hint: use Minimize. 

 

  • Tries to find the solution for  x^3+2*x^2-x+1 = 0 x = -4;minFun = minimize ( (x^3+2*x^2-x+1)^2, {x});sol = Eval List( {x, minFun} );solx = sol[1];show(solx^3+2*solx^2-solx+1)

Additionally, JMP Technical Support has submitted an feature request to add the Excel functions to JSL for a future release of JMP.

 

Regards.