Registered User Joined: 1/31/2013 Posts: 8
|
Hi,
Can you help me with a formula for NOT a new high in the past 70 days, please?
James
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If we just check for the high of the most recent 70 bars to be less than the high of the most recent 252 bars:
MAXH70 < MAXH252
But if we actually check to make sure that each of the most recent 70 bars did not make a new 252-bar high:
H <= MAXH251.1 AND H1 <= MAXH251.2 AND H2 <= MAXH251.3 AND H3 <= MAXH251.4 AND H4 <= MAXH251.5 AND H5 <= MAXH251.6 AND H6 <= MAXH251.7 AND H7 <= MAXH251.8 AND H8 <= MAXH251.9 AND H9 <= MAXH251.10 AND H10 <= MAXH251.11 AND H11 <= MAXH251.12 AND H12 <= MAXH251.13 AND H13 <= MAXH251.14 AND H14 <= MAXH251.15 AND H15 <= MAXH251.16 AND H16 <= MAXH251.17 AND H17 <= MAXH251.18 AND H18 <= MAXH251.19 AND H19 <= MAXH251.20 AND H20 <= MAXH251.21 AND H21 <= MAXH251.22 AND H22 <= MAXH251.23 AND H23 <= MAXH251.24 AND H24 <= MAXH251.25 AND H25 <= MAXH251.26 AND H26 <= MAXH251.27 AND H27 <= MAXH251.28 AND H28 <= MAXH251.29 AND H29 <= MAXH251.30 AND H30 <= MAXH251.31 AND H31 <= MAXH251.32 AND H32 <= MAXH251.33 AND H33 <= MAXH251.34 AND H34 <= MAXH251.35 AND H35 <= MAXH251.36 AND H36 <= MAXH251.37 AND H37 <= MAXH251.38 AND H38 <= MAXH251.39 AND H39 <= MAXH251.40 AND H40 <= MAXH251.41 AND H41 <= MAXH251.42 AND H42 <= MAXH251.43 AND H43 <= MAXH251.44 AND H44 <= MAXH251.45 AND H45 <= MAXH251.46 AND H46 <= MAXH251.47 AND H47 <= MAXH251.48 AND H48 <= MAXH251.49 AND H49 <= MAXH251.50 AND H50 <= MAXH251.51 AND H51 <= MAXH251.52 AND H52 <= MAXH251.53 AND H53 <= MAXH251.54 AND H54 <= MAXH251.55 AND H55 <= MAXH251.56 AND H56 <= MAXH251.57 AND H57 <= MAXH251.58 AND H58 <= MAXH251.59 AND H59 <= MAXH251.60 AND H60 <= MAXH251.61 AND H61 <= MAXH251.62 AND H62 <= MAXH251.63 AND H63 <= MAXH251.64 AND H64 <= MAXH251.65 AND H65 <= MAXH251.66 AND H66 <= MAXH251.67 AND H67 <= MAXH251.68 AND H68 <= MAXH251.69 AND H69 <= MAXH251.70
If you mean something else, we would need further clarification from you as to your actual intent.
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|