I am new to spotfire and am trying to setup a dynamic IRR calculation given cashflows that I want to be able to group by different filters.

[Greg Ekkebus]

I am new to spotfire and am trying to setup a dynamic IRR calculation given cashflows that I want to be able to group by different filters. Is it possible to do an IRR and NPV calculation in Spotfire

[Manoj Chaurasia]

Sorry for the extremely long delay in responding but thank you for the suggestion. I will have a look at it and see what I can do with it. I am unfamiliar with using Data functions but it sounds like no time like the present to learn. Cheers

[Chris S.]

You could register your own data function using R script with TERR (TIBCO Enterprise Runtime for R). I found these two R functions after a quick Google search.

NPV

[Sushant Gupta]

Hi guys, just wanted to check if 1) this worked and 2) Is there any function to calculate XIRR (as opposed to simple IRR)

[Greg Ekkebus]

Hi, I was able to implement an IRR and NPV calculation using R. The script above will get you started. Important to setup your dataframe correctly and deal with structure of time series to implement.

[Arindam Arang]

Hi, Can you please share your solution, maybe you can send me your spotfire project if possible. Thanks in advance.