The attached document is used to track my trades. What I am looking to do is track my stop loss as I move it to follow the trade.
The formulas in columns O, P, and Q need to calculate using the latest stop loss in place moving from column G to J, whichever is the last column populated.
How do I have the formulas look at the Stop Loss columns and then calculate on the most current Stop Loss populated?
As an example in row 32 I opened the trade with a stop loss at $7.56 and this is what columns O, P and Q is using to calculate. However, I then moved the stop loss up to $7.97 and then $8.31 and I need columns O,P and Q to calculate on the stop loss columns moving from G to J.
Please if anyone is able to provide some guidance.
thank you
Alan
Bookmarks