Wrapper for the Extended Internal Rate of Return (XIRR) component
This version allows for the XIRR component to be supplied with a table of portfolio transactions, containing periodic valuations. The Valuation information is separated out and used as the basis for providing XIRR returns at each of the valuation dates.
@takbb Brian Bates 12/12/2023
The following is copied from the XIRR component that this wraps:
(https://hub.knime.com/-/spaces/-/~mTw4LaivNmdlrLk3/current-state/)
DISCLAIMER: To adopt this library the component downloads on its first execution in a new workflow from search.maven.org. Make sure your KNIME has internet access when executing the component in a new workflow for the first time.
DISCLAIMER: The adopted library does not perform well with multiple negative cash flows.
The component calculates the internal rate of return for a schedule of cash flows that is not necessarily periodic. It starts from a series of cash flows and their date to approximate the value of XIRR for each of the defined portfolio/project that the cash flows are grouped by. Make sure that you have at least one column for the dates of the transactions in a date format, one column for the cash flows (for each portfolio/project the first transaction needs to be negative), and one column for the project/portfolio by which you want the transactions to be grouped by.
Microsoft Excel Docs: support.microsoft.com/en-us/office/xirr-function-de1242ec-6477-445b-b11b-a303ad9adc9d
Google Sheets Docs: support.google.com/docs/answer/3093266
- Type: Table