Just wondering if anyone has a way of calculating IRR with actual dates as in XIRR in excell:
XIRR function - Office Support
Go to 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.
Additionally, JMP Technical Support has submitted an feature request to add the Excel functions to JSL for a future release of JMP.
View solution in original post
@ron_horne , I am looking for XIRR and XNPV in JMP - were you able to find any resources ?
There are no labels assigned to this post.