Calcul XIRR in KNIME

Hello Everyone,

I need to calculate the XIRR in KNIME, this function exist in excel,
check this exemple :

And this is the formula of XIRR :

Thank you !

1 Like

Currently there isn’t a node that does this, so you’d have to implement it in a workflow.

I imagine in this case that would involve the use of a Math Formula node to calculate the XIRR inside a parameter optimization loop (see Parameter Optimization Loop Start and Parameter Optimization Loop End). Then you could iterate over the rate with the objective of minimizing your function.

Alternatively, you could use an R Snippet node (or its equivalent in Python) to do the calcuation. For example, the tvm() library in R has an xirr() function available, and I’m sure there are others out there.


Ok thanks @ScottF for your response :slight_smile:

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.