Hi Folks,
Can Anyone Help me with getting this fixed in Excel? I tried the variations mention below and many more but all are getting error in excel.
=IF(AND C2="LONG", IF(P2>J2,"WIN","LOSS"), OR(C2="SHORT", (P2<J2,"WIN","LOSS")
=IF(AND(C2="LONG", P2>J2,)"WIN", IF(C2="LONG", P2<J2,)"LOSS", IF(AND(C2="SHORT", P2<J2,)"WIN",IF(C2="LONG", P2>J2,)"LOSS"
=IF(C2="LONG", (P2>J2, "WIN", IF(C2="LONG", ( P2<J2, "LOSS", IF(C2="SHORT", (P2<J2, "WIN", IF(C2="SHORT", P2>J2, "LOSS")))))))
This is for my trading journal. Basically what I need is If I am taking a buy(LONG) position, it should be a win if P2>J2. Similarly for a Sell(SHORT) position it should be a win if P2<J2. C2 has the type of the position LONG/SHORT.
Would be very thankful for any help.
Bookmarks