Calculating win/loss of trades

Hello all,

I have a file full of stock trades and I need to calculate the win/loss of each selling trade in %. I did this calculation already in Excel, the file is attached. There you can see the given information form column A to H. In column O is the result I need to achieve in KNIME. The columns in between contain the calculations in Excel. 

Do you have any idea how to achieve the same results in KNIME?



Hello Ralph2605,

I think you can get the same results by using the Rule Engine node and the Math Formula node. Are you struggling with any specific step of the data manipulation process?