Support Board
Date/Time: Tue, 22 Apr 2025 21:53:04 +0000
Post From: Needing Help with Spreadsheet Formula's for Auto Trading System
| [2025-01-08 01:15:19] |
| Derek J - Posts: 12 |
|
Hey @Sawtooth (or anyone else that can help please chime in). So I am refining this mean reversion Bollinger band strategy that basically buys the next candle that breaks the high of the setup candle (C4). However I've noticed that if the trade line (9ema, AA3) is right above the current price this will not always work. It will breach the high of the setup candle (C4) and immediately reverse as soon as it gets to (or close to) the 9ema. Sawtooth provided me with a formula that will not let it take the trade if it is within 5 ticks of the 9ema trade line (AA3) That works great except if price goes above the setup candle and moves more than 5 ticks from the 9ema it will still trigger the trade which is not good. I need it to enter as soon as price goes above the previous (setup C4) candle and only if the 9ema (AA3) is more than 5 ticks away at that time. How can I write this? I am thinking maybe something like only if the 9ema (AA3)>5 ticks from C3 and C3<2 ticks from C4? This way if price does end up moving up past the 9ema it won't trigger, because it is no longer within the 2 tick maximum from the C4 (setup) candle. Can someone help me write out this formula? Thanks in Advance, Everyone has been a huge help and I am very grateful for it! Date Time Of Last Edit: 2025-01-08 01:16:21
|