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


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Simple slope connecting High to High Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
HAY725
Posted : Tuesday, June 23, 2015 7:51:26 PM
Registered User
Joined: 10/17/2013
Posts: 3

How do I compute a slope line that connect the high of two candle stick?

for example, I want a slope that connect 50 day high and 30 day high. I could use their price difference for numerator but what do I do for the denominator? (P50-P10)/(T50-T10)

There is no count function in the system.

 

Thank You

Bruce_L
Posted : Wednesday, June 24, 2015 10:09:57 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The 50 period high is just the following.

MAXH50

The 30 period high is just the following.

MAXH30

The number of bars since the high most recently hit its current 50 period high can be written as the following.

ABS(H < MAXH50) * (ABS(H1 = MAXH50) + ABS(H1 < MAXH50) * (ABS(H2 = MAXH50) * 2 + ABS(H2 < MAXH50) * (ABS(H3 = MAXH50) * 3 + ABS(H3 < MAXH50) * (ABS(H4 = MAXH50) * 4 + ABS(H4 < MAXH50) * (ABS(H5 = MAXH50) * 5 + ABS(H5 < MAXH50) * (ABS(H6 = MAXH50) * 6 + ABS(H6 < MAXH50) * (ABS(H7 = MAXH50) * 7 + ABS(H7 < MAXH50) * (ABS(H8 = MAXH50) * 8 + ABS(H8 < MAXH50) * (ABS(H9 = MAXH50) * 9 + ABS(H9 < MAXH50) * (ABS(H10 = MAXH50) * 10 + ABS(H10 < MAXH50) * (ABS(H11 = MAXH50) * 11 + ABS(H11 < MAXH50) * (ABS(H12 = MAXH50) * 12 + ABS(H12 < MAXH50) * (ABS(H13 = MAXH50) * 13 + ABS(H13 < MAXH50) * (ABS(H14 = MAXH50) * 14 + ABS(H14 < MAXH50) * (ABS(H15 = MAXH50) * 15 + ABS(H15 < MAXH50) * (ABS(H16 = MAXH50) * 16 + ABS(H16 < MAXH50) * (ABS(H17 = MAXH50) * 17 + ABS(H17 < MAXH50) * (ABS(H18 = MAXH50) * 18 + ABS(H18 < MAXH50) * (ABS(H19 = MAXH50) * 19 + ABS(H19 < MAXH50) * (ABS(H20 = MAXH50) * 20 + ABS(H20 < MAXH50) * (ABS(H21 = MAXH50) * 21 + ABS(H21 < MAXH50) * (ABS(H22 = MAXH50) * 22 + ABS(H22 < MAXH50) * (ABS(H23 = MAXH50) * 23 + ABS(H23 < MAXH50) * (ABS(H24 = MAXH50) * 24 + ABS(H24 < MAXH50) * (ABS(H25 = MAXH50) * 25 + ABS(H25 < MAXH50) * (ABS(H26 = MAXH50) * 26 + ABS(H26 < MAXH50) * (ABS(H27 = MAXH50) * 27 + ABS(H27 < MAXH50) * (ABS(H28 = MAXH50) * 28 + ABS(H28 < MAXH50) * (ABS(H29 = MAXH50) * 29 + ABS(H29 < MAXH50) * (ABS(H30 = MAXH50) * 30 + ABS(H30 < MAXH50) * (ABS(H31 = MAXH50) * 31 + ABS(H31 < MAXH50) * (ABS(H32 = MAXH50) * 32 + ABS(H32 < MAXH50) * (ABS(H33 = MAXH50) * 33 + ABS(H33 < MAXH50) * (ABS(H34 = MAXH50) * 34 + ABS(H34 < MAXH50) * (ABS(H35 = MAXH50) * 35 + ABS(H35 < MAXH50) * (ABS(H36 = MAXH50) * 36 + ABS(H36 < MAXH50) * (ABS(H37 = MAXH50) * 37 + ABS(H37 < MAXH50) * (ABS(H38 = MAXH50) * 38 + ABS(H38 < MAXH50) * (ABS(H39 = MAXH50) * 39 + ABS(H39 < MAXH50) * (ABS(H40 = MAXH50) * 40 + ABS(H40 < MAXH50) * (ABS(H41 = MAXH50) * 41 + ABS(H41 < MAXH50) * (ABS(H42 = MAXH50) * 42 + ABS(H42 < MAXH50) * (ABS(H43 = MAXH50) * 43 + ABS(H43 < MAXH50) * (ABS(H44 = MAXH50) * 44 + ABS(H44 < MAXH50) * (ABS(H45 = MAXH50) * 45 + ABS(H45 < MAXH50) * (ABS(H46 = MAXH50) * 46 + ABS(H46 < MAXH50) * (ABS(H47 = MAXH50) * 47 + ABS(H47 < MAXH50) * (ABS(H48 = MAXH50) * 48 + ABS(H48 < MAXH50) * (ABS(H49 = MAXH50) * 49)))))))))))))))))))))))))))))))))))))))))))))))))

The number of bars since the high most recently hit its current 30 period high can be written as the following.

ABS(H < MAXH30) * (ABS(H1 = MAXH30) + ABS(H1 < MAXH30) * (ABS(H2 = MAXH30) * 2 + ABS(H2 < MAXH30) * (ABS(H3 = MAXH30) * 3 + ABS(H3 < MAXH30) * (ABS(H4 = MAXH30) * 4 + ABS(H4 < MAXH30) * (ABS(H5 = MAXH30) * 5 + ABS(H5 < MAXH30) * (ABS(H6 = MAXH30) * 6 + ABS(H6 < MAXH30) * (ABS(H7 = MAXH30) * 7 + ABS(H7 < MAXH30) * (ABS(H8 = MAXH30) * 8 + ABS(H8 < MAXH30) * (ABS(H9 = MAXH30) * 9 + ABS(H9 < MAXH30) * (ABS(H10 = MAXH30) * 10 + ABS(H10 < MAXH30) * (ABS(H11 = MAXH30) * 11 + ABS(H11 < MAXH30) * (ABS(H12 = MAXH30) * 12 + ABS(H12 < MAXH30) * (ABS(H13 = MAXH30) * 13 + ABS(H13 < MAXH30) * (ABS(H14 = MAXH30) * 14 + ABS(H14 < MAXH30) * (ABS(H15 = MAXH30) * 15 + ABS(H15 < MAXH30) * (ABS(H16 = MAXH30) * 16 + ABS(H16 < MAXH30) * (ABS(H17 = MAXH30) * 17 + ABS(H17 < MAXH30) * (ABS(H18 = MAXH30) * 18 + ABS(H18 < MAXH30) * (ABS(H19 = MAXH30) * 19 + ABS(H19 < MAXH30) * (ABS(H20 = MAXH30) * 20 + ABS(H20 < MAXH30) * (ABS(H21 = MAXH30) * 21 + ABS(H21 < MAXH30) * (ABS(H22 = MAXH30) * 22 + ABS(H22 < MAXH30) * (ABS(H23 = MAXH30) * 23 + ABS(H23 < MAXH30) * (ABS(H24 = MAXH30) * 24 + ABS(H24 < MAXH30) * (ABS(H25 = MAXH30) * 25 + ABS(H25 < MAXH30) * (ABS(H26 = MAXH30) * 26 + ABS(H26 < MAXH30) * (ABS(H27 = MAXH30) * 27 + ABS(H27 < MAXH30) * (ABS(H28 = MAXH30) * 28 + ABS(H28 < MAXH30) * (ABS(H29 = MAXH30) * 29)))))))))))))))))))))))))))))

Days Since Last Peak (or other day-counting needs)

It should probably be noted that these numbers can be frequently be the same. When this is the case your denominator will be zero and produce an error.

This could be corrected for by adding 1 to the denominator when MAXH50 and MAXH30 are the same. The following PCF fragment will return 1 when this is the case.

ABS(MAXH50 = MAXH30)



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