turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- XIRR

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 18, 2016 10:36 AM
(1230 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 14, 2018 11:14 AM
(811 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jan 23, 2018 11:36 AM
(617 views)

- Tags:
- Finance Functions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 14, 2018 11:14 AM
(812 views)

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.