Registered User
Joined: 11/7/2004
Posts: 1
|
I was wondering if a PCF could be written for double tops and bottoms. I would like to compare today’s low or high with a low or high in the past 12 to 45 days. These lows or highs should be between 98.5% and 105%of the low or high if you could tell me how to write this I would appreciate it. Thank you. Russ
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (rusedelman) I would like to compare today’s low or high with a low or high in the past 12 to 45 days. These lows or highs should be between 98.5% and 105%of the low or high
The following formulas take a rather liberal interpretation of a low or high deflection. A low deflection just has to be lower than the lows on either side and a high deflection has to be higher than the highs on either side. Both of the following formulas will return True a fairly high percentage of the time for most symbols:
Highs:
(H11 < H12 AND H12 > H13 AND .985 * H12 <= H AND H <= 1.05 * H12) OR (H12 < H13 AND H13 > H14 AND .985 * H13 <= H AND H <= 1.05 * H13) OR (H13 < H14 AND H14 > H15 AND .985 * H14 <= H AND H <= 1.05 * H14) OR (H14 < H15 AND H15 > H16 AND .985 * H15 <= H AND H <= 1.05 * H15) OR (H15 < H16 AND H16 > H17 AND .985 * H16 <= H AND H <= 1.05 * H16) OR (H16 < H17 AND H17 > H18 AND .985 * H17 <= H AND H <= 1.05 * H17) OR (H17 < H18 AND H18 > H19 AND .985 * H18 <= H AND H <= 1.05 * H18) OR (H18 < H19 AND H19 > H20 AND .985 * H19 <= H AND H <= 1.05 * H19) OR (H19 < H20 AND H20 > H21 AND .985 * H20 <= H AND H <= 1.05 * H20) OR (H20 < H21 AND H21 > H22 AND .985 * H21 <= H AND H <= 1.05 * H21) OR (H21 < H22 AND H22 > H23 AND .985 * H22 <= H AND H <= 1.05 * H22) OR (H22 < H23 AND H23 > H24 AND .985 * H23 <= H AND H <= 1.05 * H23) OR (H23 < H24 AND H24 > H25 AND .985 * H24 <= H AND H <= 1.05 * H24) OR (H24 < H25 AND H25 > H26 AND .985 * H25 <= H AND H <= 1.05 * H25) OR (H25 < H26 AND H26 > H27 AND .985 * H26 <= H AND H <= 1.05 * H26) OR (H26 < H27 AND H27 > H28 AND .985 * H27 <= H AND H <= 1.05 * H27) OR (H27 < H28 AND H28 > H29 AND .985 * H28 <= H AND H <= 1.05 * H28) OR (H28 < H29 AND H29 > H30 AND .985 * H29 <= H AND H <= 1.05 * H29) OR (H29 < H30 AND H30 > H31 AND .985 * H30 <= H AND H <= 1.05 * H30) OR (H30 < H31 AND H31 > H32 AND .985 * H31 <= H AND H <= 1.05 * H31) OR (H31 < H32 AND H32 > H33 AND .985 * H32 <= H AND H <= 1.05 * H32) OR (H32 < H33 AND H33 > H34 AND .985 * H33 <= H AND H <= 1.05 * H33) OR (H33 < H34 AND H34 > H35 AND .985 * H34 <= H AND H <= 1.05 * H34) OR (H34 < H35 AND H35 > H36 AND .985 * H35 <= H AND H <= 1.05 * H35) OR (H35 < H36 AND H36 > H37 AND .985 * H36 <= H AND H <= 1.05 * H36) OR (H36 < H37 AND H37 > H38 AND .985 * H37 <= H AND H <= 1.05 * H37) OR (H37 < H38 AND H38 > H39 AND .985 * H38 <= H AND H <= 1.05 * H38) OR (H38 < H39 AND H39 > H40 AND .985 * H39 <= H AND H <= 1.05 * H39) OR (H39 < H40 AND H40 > H41 AND .985 * H40 <= H AND H <= 1.05 * H40) OR (H40 < H41 AND H41 > H42 AND .985 * H41 <= H AND H <= 1.05 * H41) OR (H41 < H42 AND H42 > H43 AND .985 * H42 <= H AND H <= 1.05 * H42) OR (H42 < H43 AND H43 > H44 AND .985 * H43 <= H AND H <= 1.05 * H43) OR (H43 < H44 AND H44 > H45 AND .985 * H44 <= H AND H <= 1.05 * H44) OR (H44 < H45 AND H45 > H46 AND .985 * H45 <= H AND H <= 1.05 * H45)
Lows:
(L11 > L12 AND L12 < L13 AND .985 * L12 <= L AND L <= 1.05 * L12) OR (L12 > L13 AND L13 < L14 AND .985 * L13 <= L AND L <= 1.05 * L13) OR (L13 > L14 AND L14 < L15 AND .985 * L14 <= L AND L <= 1.05 * L14) OR (L14 > L15 AND L15 < L16 AND .985 * L15 <= L AND L <= 1.05 * L15) OR (L15 > L16 AND L16 < L17 AND .985 * L16 <= L AND L <= 1.05 * L16) OR (L16 > L17 AND L17 < L18 AND .985 * L17 <= L AND L <= 1.05 * L17) OR (L17 > L18 AND L18 < L19 AND .985 * L18 <= L AND L <= 1.05 * L18) OR (L18 > L19 AND L19 < L20 AND .985 * L19 <= L AND L <= 1.05 * L19) OR (L19 > L20 AND L20 < L21 AND .985 * L20 <= L AND L <= 1.05 * L20) OR (L20 > L21 AND L21 < L22 AND .985 * L21 <= L AND L <= 1.05 * L21) OR (L21 > L22 AND L22 < L23 AND .985 * L22 <= L AND L <= 1.05 * L22) OR (L22 > L23 AND L23 < L24 AND .985 * L23 <= L AND L <= 1.05 * L23) OR (L23 > L24 AND L24 < L25 AND .985 * L24 <= L AND L <= 1.05 * L24) OR (L24 > L25 AND L25 < L26 AND .985 * L25 <= L AND L <= 1.05 * L25) OR (L25 > L26 AND L26 < L27 AND .985 * L26 <= L AND L <= 1.05 * L26) OR (L26 > L27 AND L27 < L28 AND .985 * L27 <= L AND L <= 1.05 * L27) OR (L27 > L28 AND L28 < L29 AND .985 * L28 <= L AND L <= 1.05 * L28) OR (L28 > L29 AND L29 < L30 AND .985 * L29 <= L AND L <= 1.05 * L29) OR (L29 > L30 AND L30 < L31 AND .985 * L30 <= L AND L <= 1.05 * L30) OR (L30 > L31 AND L31 < L32 AND .985 * L31 <= L AND L <= 1.05 * L31) OR (L31 > L32 AND L32 < L33 AND .985 * L32 <= L AND L <= 1.05 * L32) OR (L32 > L33 AND L33 < L34 AND .985 * L33 <= L AND L <= 1.05 * L33) OR (L33 > L34 AND L34 < L35 AND .985 * L34 <= L AND L <= 1.05 * L34) OR (L34 > L35 AND L35 < L36 AND .985 * L35 <= L AND L <= 1.05 * L35) OR (L35 > L36 AND L36 < L37 AND .985 * L36 <= L AND L <= 1.05 * L36) OR (L36 > L37 AND L37 < L38 AND .985 * L37 <= L AND L <= 1.05 * L37) OR (L37 > L38 AND L38 < L39 AND .985 * L38 <= L AND L <= 1.05 * L38) OR (L38 > L39 AND L39 < L40 AND .985 * L39 <= L AND L <= 1.05 * L39) OR (L39 > L40 AND L40 < L41 AND .985 * L40 <= L AND L <= 1.05 * L40) OR (L40 > L41 AND L41 < L42 AND .985 * L41 <= L AND L <= 1.05 * L41) OR (L41 > L42 AND L42 < L43 AND .985 * L42 <= L AND L <= 1.05 * L42) OR (L42 > L43 AND L43 < L44 AND .985 * L43 <= L AND L <= 1.05 * L43) OR (L43 > L44 AND L44 < L45 AND .985 * L44 <= L AND L <= 1.05 * L44) OR (L44 > L45 AND L45 < L46 AND .985 * L45 <= L AND L <= 1.05 * L45)
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Scanning for Stocks Printing a Double or Triple Bottom
Double top/bottom trend
Finding Double Tops and Double Bottoms
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|