Registered User Joined: 3/10/2012 Posts: 465
|
Bruce this formula below gives me 2 consecutive close above 8EMA
SGN(C - XAVG(H + L + C, 8) / 3) = SGN(C1 - XAVG(H + L + C, 8.1) / 3) AND SGN(C1 - XAVG(H + L + C, 8.1) / 3) > SGN(C2 - XAVG(H + L + C, 8.2) / 3)
So my question is how do i write the same above formula where it close above 8ema(hlc) today , and close below 8ema(hlc) yesterday and Close above 8ema(hlc) day before yesterday and all happening Consecutively in 3 bars
thanks
Dhiren
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following condition formula.
C > XAVG(H + L + C, 8) / 3 AND C1 < XAVG(H1 + L1 + C1, 8) / 3 AND C2 > XAVG(H2 + L2 + C2, 8) / 3
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 3/10/2012 Posts: 465
|
Ok that works Bruce .. so just for my understanding why in the earlier pcf we used SGN " function
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I am guessing the formula was originally created to test for price being on the same side of the moving average for three bars in a row and then modified to check for the crossup between two bars ago and one bar ago.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|