Support Board
Date/Time: Wed, 05 Mar 2025 04:29:22 +0000
Post From: [Spreadsheet Trading] How to lock TP & SL targets to the ATR at that time?
| [2022-01-07 01:36:00] |
| tuanluu20902 - Posts: 24 |
|
Hi guys, Currently, for my spreadsheet system, I calculate TP and SL levels based on a multiples of ATR. For example. my Buy Exit looks something like this: =OR(E3>=($J$9+(4*AC3)),E3<=($J$9-(2*AC3))) where AC3 is the cell of the candle's Average True Range. So as you can see, the strategy is simple, either TP at 4xATR or SL below at 2xATR. My problem is the ATR is constantly changing with every new candle and that means every new candle my TP and SL fluctuate based on the calculations of the new ATR. How do I set it so that the TP and SL is locked to the ATR of the candle when the trade was entered? |