I have a trading sheet, where I enter my trades. It shows entry/price target and stop loss. The idea is to show the following;-If the trade hit the profit target, it will show ‘Target Hit’.If the trade hits the Stop loss, it will show ‘Stop Loss Hit’. If neither profit or stop loss have been hit, it will show ‘Active’. This is for both Long and short positions.
Long $10, Stop loss $9 and profit target $12 Short $10, Stop Loss $11 and Profit Target $9
When I enter a long position, works perfect, but when I enter a short, it does not for some reason. Can anyone check the code to see where I have gone wrong?
=IF(AND(D21="Long",C21>=H21),"Target Hit Long",IF(And(D21="Long"),IF(And(C21<=J21),"Stop Loss Long",IF(And(D21="Long",C21<H21),"Active Long",
IF(AND(D21="Short",C21<=H21),"Target Hit Short",IF(And(D21="Short"),IF(And(C21>=J21),"Stop Loss Short",IF(And(D21="Short",C21>J21,"Active Short")))))))))
Aucun commentaire:
Enregistrer un commentaire