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