Support Board
Date/Time: Sun, 02 Feb 2025 12:48:37 +0000
Post From: Moving average cross then price retraces to go back and touch another ma
| [2019-09-04 01:32:57] |
| Sawtooth - Posts: 4164 |
|
Do you mean when the 34EMA crosses the 55EMA? (It is rare for a slower EMA to cross a faster EMA, in the direction of the trade.) You'll need to create a persistent variable of the cross event so it is available to reference when price retraces. You'll also need a condition to release the persistent variable. See example formulas below. ID3 = 34EMA ID4 = 55EMA Cell P3: =IF(ID3.SG1@3>ID4.SG1@3+$J$21*2,1,IF(AND(ID3.SG1@4>ID4.SG1@4,ID3.SG1@3<ID4.SG1@3),0,P4)) This returns 1 at the first bar when the 34EMA is 2 ticks above the 55EMA, and makes it persistent until the 34EMA crosses below the 55EMA. Cell Q3: =IF(AND(P3,E4>ID3.SG1@4,E3<=ID3.SG1@3),1,IF(P3=0,0,Q4)) This looks for a 1 in column P, when the Last price touches/crosses the 34EMA, then makes it persistent until the 34EMA crosses below the 55EMA. Cell K3: =AND(Q4=0,Q3) You'll need to replicate the examples for short entries in M3. Date Time Of Last Edit: 2019-09-07 01:00:13
|