New version 17 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

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

Price cross above MA Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Tr4deCr4ft
Posted : Wednesday, December 13, 2017 3:32:21 PM
Registered User
Joined: 8/31/2017
Posts: 16

Hi Bruce,

I'd like to get an EasyScan (Condition Set or whatever proper term is) alert when price closes ABOVE a MA after having closed BELOW it for some predetermined number (or flexible number of times > X) of candles. In the case of 10 candles, would the following work:

C < AVGC20 AND C1 < AVG20.1 AND C2 < AVG20.2 AND C3 < AVG20.3 AND C4 < AVG20.4 AND C5 < AVG20.5 AND C6 < AVG20.6 AND C7 < AVG20.7 AND C8 < AVG20.8 AND C9 < AVG20.9 AND C10 < AVG20.10

 

With thanks

Bruce_L
Posted : Wednesday, December 13, 2017 3:39:16 PM


Worden Trainer

Joined: 10/7/2004
Posts: 61,974

Based on your description, I would think you would want the first comparison to be creater than instead of less then.

C > AVGC20 AND C1 < AVGC20.1 AND C2 < AVGC20.2 AND C3 < AVGC20.3 AND C4 < AVGC20.4 AND C5 < AVGC20.5 AND C6 < AVGC20.6 AND C7 < AVGC20.7 AND C8 < AVGC20.8 AND C9 < AVGC20.9 AND C10 < AVGC20.10

This could be written as follows in TC2000 v17 or newer versions.

C > AVGC20 AND TrueInRow(C1 < AVGC20.1, 10) = 10



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Tr4deCr4ft
Posted : Wednesday, December 13, 2017 3:41:26 PM
Registered User
Joined: 8/31/2017
Posts: 16

Thank you, correct on the 1st, flubbed it when transposing.

I'll give your compact (and correct) version a try. thanks!

Quiktdr
Posted : Wednesday, December 20, 2017 9:29:01 PM
Platinum Customer Platinum Customer

Joined: 10/7/2004
Posts: 742

Senior moment!!    

wkly > XAvgC8  and  was <XAvgC8 week before

 

 

C5>XAvgc8 and C5.1<XAvgc8    or

C5>XAvgC8 and C6<XAvgC8

 

Thank you

Quiktdr
Posted : Thursday, December 21, 2017 7:28:48 AM
Platinum Customer Platinum Customer

Joined: 10/7/2004
Posts: 742

I realize that the above is not the PCF I was seeking but what do those formulas represent?

 

Also how do I write a PCF for three consecutive highr highs and higher lows above/below 13e and 20e

Bruce_L
Posted : Thursday, December 21, 2017 9:41:39 AM


Worden Trainer

Joined: 10/7/2004
Posts: 61,974

The C5.1 is incorrect and needs to be C6 as in the second version.

I am guessing you would probably also want to change the XAVGC8 to XAVGC8.5 and XAVGC8.6 instead.

C5 > XAVGC8.5 AND C6 < XAVGC8.6

Note that this represents price closing above its own exponential moving average 5 bars ago while closing below 6 bars ago.

This would be 1 week ago on a daily chart, but the exponential movinga average would be daily and not weekly in this case.

If you are interested in price crossing up through its own 8 period exponential moving average on a weekly chart in TC2000 v17, you can just set the time frame of the following to weekly.

XUP(C, XAVGC8)

In TC2000 v7, this formula would be quite a bit longer (and represents slightly different things since the weeks in v17 are calendar weeks and the weeks in v7 are rolling 5 trading day bars).

C > .32708487 * (ABS(C - C5) + 7 / 9 * (ABS(C5 - C10) + 7 / 9 * (ABS(C10 - C15) + 7 / 9 * (ABS(C15 - C20) + 7 / 9 * (ABS(C20 - C25) + 7 / 9 * (ABS(C25 - C30) + 7 / 9 * (ABS(C30 - C35) + 7 / 9 * (ABS(C35 - C40) + 7 / 9 * (ABS(C40 - C45) + 7 / 9 * (ABS(C45 - C50) + 7 / 9 * (ABS(C50 - C55) + 7 / 9 * (ABS(C55 - C60) + 7 / 9 * (ABS(C60 - C65) + 7 / 9 * (ABS(C65 - C70) + 7 / 9 * (ABS(C70 - C75) + 7 / 9 * (ABS(C75 - C80) + 7 / 9 * (ABS(C80 - C85) + 7 / 9 * (ABS(C85 - C90) + 7 / 9 * (ABS(C90 - C95) + 7 / 9 * (ABS(C95 - C100) + 7 / 9 * (ABS(C100 - C105) + 7 / 9 * (ABS(C105 - C110) + 7 / 9 * (ABS(C110 - C115) + 7 / 9 * (ABS(C115 - C120) + 7 / 9 * (ABS(C120 - C125) + 7 / 9 * (ABS(C125 - C130) + 7 / 9 * (ABS(C130 - C135) + 7 / 9 * (ABS(C135 - C140))))))))))))))))))))))))))))) AND C5 <= .32708487 * (ABS(C5 - C10) + 7 / 9 * (ABS(C10 - C15) + 7 / 9 * (ABS(C15 - C20) + 7 / 9 * (ABS(C20 - C25) + 7 / 9 * (ABS(C25 - C30) + 7 / 9 * (ABS(C30 - C35) + 7 / 9 * (ABS(C35 - C40) + 7 / 9 * (ABS(C40 - C45) + 7 / 9 * (ABS(C45 - C50) + 7 / 9 * (ABS(C50 - C55) + 7 / 9 * (ABS(C55 - C60) + 7 / 9 * (ABS(C60 - C65) + 7 / 9 * (ABS(C65 - C70) + 7 / 9 * (ABS(C70 - C75) + 7 / 9 * (ABS(C75 - C80) + 7 / 9 * (ABS(C80 - C85) + 7 / 9 * (ABS(C85 - C90) + 7 / 9 * (ABS(C90 - C95) + 7 / 9 * (ABS(C95 - C100) + 7 / 9 * (ABS(C100 - C105) + 7 / 9 * (ABS(C105 - C110) + 7 / 9 * (ABS(C110 - C115) + 7 / 9 * (ABS(C115 - C120) + 7 / 9 * (ABS(C120 - C125) + 7 / 9 * (ABS(C125 - C130) + 7 / 9 * (ABS(C130 - C135) + 7 / 9 * (ABS(C135 - C140) + 7 / 9 * (ABS(C140 - C145)))))))))))))))))))))))))))))

I am not quite sure what three consecutive higher highs and higher lows above/below 13e and 20e means. The 3 consecutive higher highs and higher lows seems simple enough. In v17:

TrueInRow(H > H1 AND L > L1, 3) = 3

In earlier versions of TC2000 (such as v7):

H > H1 AND L > L1 AND H1 > H2 AND L1 > L2 AND H2 > H3 AND L2 > L3

But I am not sure what to check when both above and below are requested for the 13 and 20 period exponential moving averages.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Quiktdr
Posted : Thursday, December 21, 2017 10:06:21 AM
Platinum Customer Platinum Customer

Joined: 10/7/2004
Posts: 742

Bruce,

I was referring to higher highs and higher lows  above 13e  and 20e

and lower highs and lower  lows below 13e & 20 e   Sorry

 

Bruce_L
Posted : Thursday, December 21, 2017 10:14:32 AM


Worden Trainer

Joined: 10/7/2004
Posts: 61,974

Higher for v17:

TrueInRow(H > H1 AND L > L1 AND L > XAVGC13 AND L > XAVGC20, 3) = 3

Lower for v17:

TrueInRow(H < H1 AND L < L1 AND H < XAVGC13 AND H < XAVGC20, 3) = 3

Higher for earlier versions:

H > H1 AND L > L1 AND L > XAVGC13 AND L > XAVGC20 AND H1 > H2 AND L1 > L2 AND L1 > XAVGC13.1 AND L1 > XAVGC20.1 AND H2 > H3 AND L2 > L3 AND L2 > XAVGC13.2 AND L2 > XAVGC20.2

Lower for earlier versions:

H < H1 AND L < L1 AND H < XAVGC13 AND H < XAVGC20 AND H1 < H2 AND L1 < L2 AND H1 < XAVGC13.1 AND H1 < XAVGC20.1 AND H2 < H3 AND L2 < L3 AND H2 < XAVGC13.2 AND H2 < XAVGC20.2



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Quiktdr
Posted : Thursday, December 21, 2017 10:27:08 AM
Platinum Customer Platinum Customer

Joined: 10/7/2004
Posts: 742

Thank you and Merry Christmas to you and yours!

Bruce_L
Posted : Thursday, December 21, 2017 10:30:45 AM


Worden Trainer

Joined: 10/7/2004
Posts: 61,974

You're welcome. Merry Christmas!



-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.