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?

Thanks!

Ralph

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?

Best,

Vincenzo