Icon

Calc XIRR - draft for comment

Draft version of a workflow for handling multiple periodic XIRR calculations

sample data in local workflow data areagroup by company-fundso on a single iteration, itis dealing with just one funditeratevaluationsValuation to topEquity to bottomrows intoascendingdate orderloop through valuationsEquities up toand including this valuation dateis this correct?current valuationadd current valuation rowto end of tableof equities up to this dateiteratecompany-fundsretain company/fund and valuation datetidy upensurereset and execute thisto open workflowdata areain OS "explorer"applicationExcel Reader Extended InternalRate of Return (XIRR) Group Loop Start Loop End Row Splitter Sorter Table Row ToVariable Loop Start Rule-basedRow Filter Row Filter Concatenate Column Appender Loop End Column Filter Table Manipulator Open File or Folder sample data in local workflow data areagroup by company-fundso on a single iteration, itis dealing with just one funditeratevaluationsValuation to topEquity to bottomrows intoascendingdate orderloop through valuationsEquities up toand including this valuation dateis this correct?current valuationadd current valuation rowto end of tableof equities up to this dateiteratecompany-fundsretain company/fund and valuation datetidy upensurereset and execute thisto open workflowdata areain OS "explorer"applicationExcel Reader Extended InternalRate of Return (XIRR) Group Loop Start Loop End Row Splitter Sorter Table Row ToVariable Loop Start Rule-basedRow Filter Row Filter Concatenate Column Appender Loop End Column Filter Table Manipulator Open File or Folder

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: BATEB031
Created at: 2023-12-12
On NodePit since: 2023-12-12
Last update: 2024-12-17
Created with KNIME version: v4.7.7

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!