=IF(AND(C2="BUY", H2<0),"UP",
IF(AND(C2="SELL", H2>0),"UP",
IF(AND(C2="BUY", H2>0),"DOWN",
IF(AND(C2="SELL", H2<0),"DOWN",""))))
-----UD-DONE-----
=IF(AND(H2>0, I2="UP", P3=""),5,
IF(AND(H2<0, I2="UP", P3=""),5,
IF(AND(H2>0, I2="UP", P3=5),5,
IF(AND(H2<0, I2="UP", P3=5),5,
IF(AND(H2>0, I2="UP", P3=-5),-10,
IF(AND(H2<0, I2="UP", P3=-5),-10,
IF(AND(H2>0, I2="UP", P3=-10),5,
IF(AND(H2<0, I2="UP", P3=10),5,
IF(AND(H2<0, I2="UP", P3=-10),5,
IF(AND(H2<0, I2="DOWN", P3=5),-5,
IF(AND(H2<0, I2="DOWN", P3=10),5,
IF(AND(H2>0, I2="DOWN", P3=5),-5,
IF(AND(H2>0, I2="DOWN", P3=-5),10,
IF(AND(H2<0, I2="DOWN", P3=-5),10,
IF(AND(H2>0, I2="DOWN", P3=10),-5,
IF(AND(H2<0, I2="DOWN", P3=-10),-5,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2>0, I2="DOWN", P3=""),-5,
"FAIL"))))))))))))))))))
-----
-----UDU-DONE----
=IF(AND(H2>0, I2="UP", P3=""),5,
IF(AND(H2<0, I2="UP", P3=""),5,
IF(AND(H2>0, I2="UP", P3=5),5,
IF(AND(H2<0, I2="UP", P3=5),5,
IF(AND(H2>0, I2="UP", P3=-5),-10,
IF(AND(H2<0, I2="UP", P3=-5),-10,
IF(AND(H2>0, I2="UP", P3=-10),30,
IF(AND(H2>0, I2="UP", P3=30),5,
IF(AND(H2>0, I2="UP", P3=-30),5,
IF(AND(H2<0, I2="UP", P3=30),5,
IF(AND(H2<0, I2="UP", P3=10),5,
IF(AND(H2<0, I2="UP", P3=-10),30,
IF(AND(H2<0, I2="DOWN", P3=5),-5,
IF(AND(H2<0, I2="DOWN", P3=-5),10,
IF(AND(H2<0, I2="DOWN", P3=10),5,
IF(AND(H2<0, I2="DOWN", P3=30),-5,
IF(AND(H2>0, I2="DOWN", P3=30),-5,
IF(AND(H2>0, I2="DOWN", P3=-30),-5,
IF(AND(H2<0, I2="DOWN", P3=-30),-5,
IF(AND(H2>0, I2="DOWN", P3=5),-5,
IF(AND(H2>0, I2="DOWN", P3=-5),10,
IF(AND(H2>0, I2="DOWN", P3=10),-5,
IF(AND(H2<0, I2="DOWN", P3=-10),-30,
IF(AND(H2>0, I2="DOWN", P3=-10),-30,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2>0, I2="DOWN", P3=""),-5,
"FAIL"))))))))))))))))))))))))))
-----
-----UDD-DONE----
=IF(AND(H2>0, I2="UP", P3=""),5,
IF(AND(H2<0, I2="UP", P3=""),5,
IF(AND(H2>0, I2="UP", P3=5),5,
IF(AND(H2<0, I2="UP", P3=5),5,
IF(AND(H2>0, I2="UP", P3=-5),-10,
IF(AND(H2<0, I2="UP", P3=-5),-10,
IF(AND(H2>0, I2="UP", P3=-10),-30,
IF(AND(H2>0, I2="UP", P3=30),5,
IF(AND(H2>0, I2="UP", P3=-30),5,
IF(AND(H2<0, I2="UP", P3=30),5,
IF(AND(H2<0, I2="UP", P3=-30),5,
IF(AND(H2<0, I2="UP", P3=10),5,
IF(AND(H2<0, I2="UP", P3=-10),-30,
IF(AND(H2<0, I2="DOWN", P3=5),-5,
IF(AND(H2<0, I2="DOWN", P3=-5),10,
IF(AND(H2<0, I2="DOWN", P3=10),5,
IF(AND(H2<0, I2="DOWN", P3=30),-5,
IF(AND(H2>0, I2="DOWN", P3=30),-5,
IF(AND(H2>0, I2="DOWN", P3=-30),-5,
IF(AND(H2<0, I2="DOWN", P3=-30),-5,
IF(AND(H2>0, I2="DOWN", P3=5),-5,
IF(AND(H2>0, I2="DOWN", P3=-5),10,
IF(AND(H2>0, I2="DOWN", P3=10),-5,
IF(AND(H2<0, I2="DOWN", P3=-10),30,
IF(AND(H2>0, I2="DOWN", P3=-10),30,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2>0, I2="DOWN", P3=""),-5,
"FAIL")))))))))))))))))))))))))))
-----
-----UU-DONE-----
=IF(AND(H2>0, I2="UP", P3=""),5,
IF(AND(H2<0, I2="UP", P3=""),5,
IF(AND(H2>0, I2="UP", P3=5),5,
IF(AND(H2<0, I2="UP", P3=5),5,
IF(AND(H2>0, I2="UP", P3=-5),10,
IF(AND(H2<0, I2="UP", P3=-5),10,
IF(AND(H2>0, I2="UP", P3=-10),5,
IF(AND(H2<0, I2="UP", P3=10),5,
IF(AND(H2>0, I2="UP", P3=10),5,
IF(AND(H2<0, I2="UP", P3=-10),5,
IF(AND(H2<0, I2="DOWN", P3=5),-5,
IF(AND(H2<0, I2="DOWN", P3=10),-5,
IF(AND(H2>0, I2="DOWN", P3=5),-5,
IF(AND(H2>0, I2="DOWN", P3=-5),-10,
IF(AND(H2<0, I2="DOWN", P3=-5),-10,
IF(AND(H2>0, I2="DOWN", P3=10),-5,
IF(AND(H2>0, I2="DOWN", P3=-10),-5,
IF(AND(H2<0, I2="DOWN", P3=-10),-5,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2>0, I2="DOWN", P3=""),-5,
"FAIL"))))))))))))))))))))
-----
-----UUU-DONE----
=IF(AND(H2>0, I2="UP", P3=""),5,
IF(AND(H2>0, I2="UP", P3=-5),10,
IF(AND(H2>0, I2="UP", P3=5),5,
IF(AND(H2>0, I2="UP", P3=-10),5,
IF(AND(H2>0, I2="UP", P3=10),5,
IF(AND(H2>0, I2="UP", P3=30),5,
IF(AND(H2<0, I2="UP", P3=""),5,
IF(AND(H2<0, I2="UP", P3=-5),10,
IF(AND(H2<0, I2="UP", P3=5),5,
IF(AND(H2<0, I2="UP", P3=-10),30,
IF(AND(H2<0, I2="UP", P3=10),5,
IF(AND(H2<0, I2="UP", P3=30),5,
IF(AND(H2>0, I2="DOWN", P3=""),-5,
IF(AND(H2>0, I2="DOWN", P3=-5),-10,
IF(AND(H2>0, I2="DOWN", P3=5),-5,
IF(AND(H2>0, I2="DOWN", P3=-10),-30,
IF(AND(H2>0, I2="DOWN", P3=10),-5,
IF(AND(H2>0, I2="DOWN", P3=-30),-5,
IF(AND(H2>0, I2="DOWN", P3=30),-5,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2<0, I2="DOWN", P3=-5),-10,
IF(AND(H2<0, I2="DOWN", P3=5),-5,
IF(AND(H2<0, I2="DOWN", P3=-10),-5,
IF(AND(H2<0, I2="DOWN", P3=10),-5,
IF(AND(H2<0, I2="DOWN", P3=30),-5,
"FAIL")))))))))))))))))))))))))
-----
-----UUD-DONE---
=IF(AND(H2>0, I2="UP", P3=""),5,
IF(AND(H2>0, I2="UP", P3=-5),10,
IF(AND(H2>0, I2="UP", P3=5),5,
IF(AND(H2>0, I2="UP", P3=-10),5,
IF(AND(H2>0, I2="UP", P3=10),5,
IF(AND(H2>0, I2="UP", P3=-30),5,
IF(AND(H2>0, I2="UP", P3=30),5,
IF(AND(H2<0, I2="UP", P3=""),5,
IF(AND(H2<0, I2="UP", P3=-5),10,
IF(AND(H2<0, I2="UP", P3=5),5,
IF(AND(H2<0, I2="UP", P3=-10),-30,
IF(AND(H2<0, I2="UP", P3=10),5,
IF(AND(H2<0, I2="UP", P3=-30),5,
IF(AND(H2<0, I2="UP", P3=30),5,
IF(AND(H2>0, I2="DOWN", P3=""),-5,
IF(AND(H2>0, I2="DOWN", P3=-5),-10,
IF(AND(H2>0, I2="DOWN", P3=5),-5,
IF(AND(H2>0, I2="DOWN", P3=-10),30,
IF(AND(H2>0, I2="DOWN", P3=10),-5,
IF(AND(H2>0, I2="DOWN", P3=-30),-5,
IF(AND(H2>0, I2="DOWN", P3=30),-5,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2<0, I2="DOWN", P3=-5),-10,
IF(AND(H2<0, I2="DOWN", P3=5),-5,
IF(AND(H2<0, I2="DOWN", P3=-10),-5,
IF(AND(H2<0, I2="DOWN", P3=10),-5,
IF(AND(H2<0, I2="DOWN", P3=-30),-5,
IF(AND(H2<0, I2="DOWN", P3=30),-5,
"FAIL")))))))))))))))))))))))))))))
-----
-----DD-DONE----
=IF(AND(H2>0, I2="UP", P3=""),-5,
IF(AND(H2>0, I2="UP", P3=-5),-10,
IF(AND(H2>0, I2="UP", P3=5),-10,
IF(AND(H2>0, I2="UP", P3=-10),-5,
IF(AND(H2>0, I2="UP", P3=10),5,
IF(AND(H2<0, I2="UP", P3=""),-5,
IF(AND(H2<0, I2="UP", P3=-5),-10,
IF(AND(H2<0, I2="UP", P3=5),-5,
IF(AND(H2<0, I2="UP", P3=-10),-5,
IF(AND(H2<0, I2="UP", P3=10),-5,
IF(AND(H2>0, I2="DOWN", P3=""),5,
IF(AND(H2>0, I2="DOWN", P3=-5),10,
IF(AND(H2>0, I2="DOWN", P3=5),5,
IF(AND(H2>0, I2="DOWN", P3=-10),5,
IF(AND(H2>0, I2="DOWN", P3=10),5,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2<0, I2="DOWN", P3=-5),10,
IF(AND(H2<0, I2="DOWN", P3=5),5,
IF(AND(H2<0, I2="DOWN", P3=-10),5,
IF(AND(H2<0, I2="DOWN", P3=10),5,
"FAIL"))))))))))))))))))))
-----
-----DDD-DONE----
=IF(AND(H2>0, I2="UP", P3=""),-5,
IF(AND(H2>0, I2="UP", P3=-5),-10,
IF(AND(H2>0, I2="UP", P3=5),-5,
IF(AND(H2>0, I2="UP", P3=-10),-30,
IF(AND(H2>0, I2="UP", P3=10),-5,
IF(AND(H2>0, I2="UP", P3=-30),-5,
IF(AND(H2>0, I2="UP", P3=30),-5,
IF(AND(H2<0, I2="UP", P3=""),-5,
IF(AND(H2<0, I2="UP", P3=-5),-10,
IF(AND(H2<0, I2="UP", P3=5),-5,
IF(AND(H2<0, I2="UP", P3=-10),-30,
IF(AND(H2<0, I2="UP", P3=10),-5,
IF(AND(H2<0, I2="UP", P3=-30),-5,
IF(AND(H2<0, I2="UP", P3=30),-5,
IF(AND(H2>0, I2="DOWN", P3=""),5,
IF(AND(H2>0, I2="DOWN", P3=-5),10,
IF(AND(H2>0, I2="DOWN", P3=5),5,
IF(AND(H2>0, I2="DOWN", P3=-10),30,
IF(AND(H2>0, I2="DOWN", P3=10),5,
IF(AND(H2>0, I2="DOWN", P3=-30),5,
IF(AND(H2>0, I2="DOWN", P3=30),5,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2<0, I2="DOWN", P3=-5),10,
IF(AND(H2<0, I2="DOWN", P3=5),5,
IF(AND(H2<0, I2="DOWN", P3=-10),30,
IF(AND(H2<0, I2="DOWN", P3=10),5,
IF(AND(H2<0, I2="DOWN", P3=-30),5,
IF(AND(H2<0, I2="DOWN", P3=30),-5,
"FAIL"))))))))))))))))))))))))))))
-----
-----DDU-DONE----
=IF(AND(H2>0, I2="UP", P3=""),-5,
IF(AND(H2>0, I2="UP", P3=-5),-10,
IF(AND(H2>0, I2="UP", P3=5),-5,
IF(AND(H2>0, I2="UP", P3=-10),30,
IF(AND(H2>0, I2="UP", P3=10),-5,
IF(AND(H2>0, I2="UP", P3=-30),-5,
IF(AND(H2>0, I2="UP", P3=30),-5,
IF(AND(H2<0, I2="UP", P3=""),-5,
IF(AND(H2<0, I2="UP", P3=-5),-10,
IF(AND(H2<0, I2="UP", P3=5),-5,
IF(AND(H2<0, I2="UP", P3=-10),30,
IF(AND(H2<0, I2="UP", P3=10),-5,
IF(AND(H2<0, I2="UP", P3=-30),-5,
IF(AND(H2<0, I2="UP", P3=30),-5,
IF(AND(H2>0, I2="DOWN", P3=""),5,
IF(AND(H2>0, I2="DOWN", P3=-5),10,
IF(AND(H2>0, I2="DOWN", P3=5),5,
IF(AND(H2>0, I2="DOWN", P3=-10),-30,
IF(AND(H2>0, I2="DOWN", P3=10),5,
IF(AND(H2>0, I2="DOWN", P3=-30),5,
IF(AND(H2>0, I2="DOWN", P3=30),5,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2<0, I2="DOWN", P3=-5),10,
IF(AND(H2<0, I2="DOWN", P3=5),5,
IF(AND(H2<0, I2="DOWN", P3=-10),-30,
IF(AND(H2<0, I2="DOWN", P3=10),5,
IF(AND(H2<0, I2="DOWN", P3=-30),5,
IF(AND(H2<0, I2="DOWN", P3=30),5,
"FAIL"))))))))))))))))))))))))))))
-----
-----DU-DONE----
=IF(AND(H2>0, I2="UP", P3=""),-5,
IF(AND(H2>0, I2="UP", P3=-5),10,
IF(AND(H2>0, I2="UP", P3=5),-5,
IF(AND(H2>0, I2="UP", P3=-10),-5,
IF(AND(H2>0, I2="UP", P3=10),-5,
IF(AND(H2<0, I2="UP", P3=""),-5,
IF(AND(H2<0, I2="UP", P3=-5),10,
IF(AND(H2<0, I2="UP", P3=5),-5,
IF(AND(H2<0, I2="UP", P3=-10),-5,
IF(AND(H2<0, I2="UP", P3=10),-5,
IF(AND(H2>0, I2="DOWN", P3=""),5,
IF(AND(H2>0, I2="DOWN", P3=-5),-10,
IF(AND(H2>0, I2="DOWN", P3=5),5,
IF(AND(H2>0, I2="DOWN", P3=-10),5,
IF(AND(H2>0, I2="DOWN", P3=10),5,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2<0, I2="DOWN", P3=-5),-10,
IF(AND(H2<0, I2="DOWN", P3=5),5,
IF(AND(H2<0, I2="DOWN", P3=-10),5,
IF(AND(H2<0, I2="DOWN", P3=10),5,
"FAIL"))))))))))))))))))))
-----
-----DUU-DONE----
=IF(AND(H2>0, I2="UP", P3=""),-5,
IF(AND(H2>0, I2="UP", P3=-5),10,
IF(AND(H2>0, I2="UP", P3=5),-5,
IF(AND(H2>0, I2="UP", P3=-10),30,
IF(AND(H2>0, I2="UP", P3=10),-5,
IF(AND(H2>0, I2="UP", P3=30),-5,
IF(AND(H2<0, I2="UP", P3=""),-5,
IF(AND(H2<0, I2="UP", P3=-5),10,
IF(AND(H2<0, I2="UP", P3=5),-5,
IF(AND(H2<0, I2="UP", P3=-10),30,
IF(AND(H2<0, I2="UP", P3=10),-5,
IF(AND(H2<0, I2="UP", P3=-30),-5,
IF(AND(H2<0, I2="UP", P3=30),-5,
IF(AND(H2>0, I2="DOWN", P3=""),5,
IF(AND(H2>0, I2="DOWN", P3=-5),-10,
IF(AND(H2>0, I2="DOWN", P3=5),5,
IF(AND(H2>0, I2="DOWN", P3=-10),-30,
IF(AND(H2>0, I2="DOWN", P3=10),5,
IF(AND(H2>0, I2="DOWN", P3=-30),5,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2<0, I2="DOWN", P3=-5),-10,
IF(AND(H2<0, I2="DOWN", P3=5),5,
IF(AND(H2<0, I2="DOWN", P3=-10),-30,
IF(AND(H2<0, I2="DOWN", P3=10),5,
"FAIL"))))))))))))))))))))))))
-----
-----DUD-DONE----
=IF(AND(H2>0, I2="UP", P3=""),-5,
IF(AND(H2>0, I2="UP", P3=-5),10,
IF(AND(H2>0, I2="UP", P3=5),-5,
IF(AND(H2>0, I2="UP", P3=-10),30,
IF(AND(H2>0, I2="UP", P3=10),-5,
IF(AND(H2>0, I2="UP", P3=30),-5,
IF(AND(H2<0, I2="UP", P3=""),-5,
IF(AND(H2<0, I2="UP", P3=-5),10,
IF(AND(H2<0, I2="UP", P3=5),-5,
IF(AND(H2<0, I2="UP", P3=-10),-30,
IF(AND(H2<0, I2="UP", P3=10),-5,
IF(AND(H2<0, I2="UP", P3=-30),-5,
IF(AND(H2<0, I2="UP", P3=30),-5,
IF(AND(H2>0, I2="DOWN", P3=""),5,
IF(AND(H2>0, I2="DOWN", P3=-5),-10,
IF(AND(H2>0, I2="DOWN", P3=5),5,
IF(AND(H2>0, I2="DOWN", P3=-10),30,
IF(AND(H2>0, I2="DOWN", P3=10),5,
IF(AND(H2>0, I2="DOWN", P3=-30),5,
IF(AND(H2<0, I2="DOWN", P3=""),-5,
IF(AND(H2<0, I2="DOWN", P3=-5),-10,
IF(AND(H2<0, I2="DOWN", P3=5),5,
IF(AND(H2<0, I2="DOWN", P3=-10),30,
IF(AND(H2<0, I2="DOWN", P3=10),5,
"FAIL"))))))))))))))))))))))))
-----