Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

PCF question Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Friday, April 13, 2018 1:54:19 PM
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

Bruce_L
Posted : Friday, April 13, 2018 1:59:08 PM


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
dhirenshah
Posted : Friday, April 13, 2018 2:09:47 PM
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 

Bruce_L
Posted : Friday, April 13, 2018 2:16:27 PM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.