Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 05 May 2024 23:54:07 +0000

How to Post a Message for Support

Post From: Moving average cross then price retraces to go back and touch another ma

[2019-09-04 01:32:57]
[Go To First Post]
Sawtooth - Posts: 3993
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