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

% Pull backs Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
rbayliss40
Posted : Thursday, August 28, 2014 6:01:35 AM
Registered User
Joined: 8/30/2011
Posts: 161

How would you configure a % pullback from a previous high?

i.e todays close is equal to or more than 6% from the previous max high of the last 20 trading days

ive been messing around with different formulas but cant get the wording right

c<=maxh20-(maxh20*0.06)? would this be right

Bruce_L
Posted : Thursday, August 28, 2014 10:20:04 AM


Worden Trainer

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

That should work, but you could shorten it a bit.

C <= .94 * MAXH20

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rbayliss40
Posted : Thursday, August 28, 2014 10:56:24 AM
Registered User
Joined: 8/30/2011
Posts: 161

Thanks , helpful as ever :)

Aces4Me
Posted : Monday, April 2, 2018 8:35:30 AM
Registered User
Joined: 4/30/2015
Posts: 197

QUOTE (Bruce_L)

That should work, but you could shorten it a bit.

C <= .94 * MAXH20

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

 

Bruce I am actually looking for pull back in  a dollar amount vs percent and just from the most recent pivot high

 

MAXH5 - C > 2.00

BUT maxh5 ties me to a chart ie Daily or 15m or 5m etc - WHICH IS NOT WHAT I WANT

 

I just want a 2.00 pull back from the most recent high print on any time frame?

 

any help or guidance appreciated

Bruce_L
Posted : Monday, April 9, 2018 2:42:01 PM


Worden Trainer

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

Price being at least $2 below the most recent pivot high (checking for 50 bars with a pivot high being defined as a high surrounded by two lower highs on both sides) can be written as follows.

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Aces4Me
Posted : Saturday, April 14, 2018 4:27:56 PM
Registered User
Joined: 4/30/2015
Posts: 197

thanks was hoping the 2.00 would be something easitly changed but i see not.

Can you provide the reverse formula for 2.00 move up off the most recent Low Print on any time Frame

 

Thanks

Aces4Me
Posted : Saturday, April 14, 2018 10:39:07 PM
Registered User
Joined: 4/30/2015
Posts: 197

if i am looking for 1.00 will changiing  C >= 2 to C >= 1 work correctly

Aces4Me
Posted : Saturday, April 14, 2018 10:41:44 PM
Registered User
Joined: 4/30/2015
Posts: 197

on the 50 bars ?  What 50 bars time frame

Aces4Me
Posted : Saturday, April 14, 2018 11:34:16 PM
Registered User
Joined: 4/30/2015
Posts: 197

Bruce on my these with formula i am .44 cents off

 

i have 1 instance on AAPL on April 3rd

2.92 is the pull back but formula has to be set to C >= 2.55 to show True

 

and 1 instance on AAPL on April 4th 

 

2.06 is the pull back but formula has to be set to C >= 1.62  to show True

 

https://gyazo.com/ade8e330e4949cc8c77e75e22c2707ee

 

Thanks

Bruce_L
Posted : Monday, April 16, 2018 11:38:03 AM


Worden Trainer

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

You seem to have already figured out how to modify the dollar value of the pullback (this has changed to penny value of the pullback in the following formulas).

You also seem to want from the pivot high to the low of the bar and not the close or current price, so please try the following for pullback from pivot high. I have change the C to an L in order to correct for this.

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

And the following for the reverse.

(100 * (H - IIF(MINL2 > L2 AND L2 < MINL2.3, L2, IIF(MINL2.1 > L3 AND L3 < MINL2.4, L3, IIF(MINL2.2 > L4 AND L4 < MINL2.5, L4, IIF(MINL2.3 > L5 AND L5 < MINL2.6, L5, IIF(MINL2.4 > L6 AND L6 < MINL2.7, L6, IIF(MINL2.5 > L7 AND L7 < MINL2.8, L7, IIF(MINL2.6 > L8 AND L8 < MINL2.9, L8, IIF(MINL2.7 > L9 AND L9 < MINL2.10, L9, IIF(MINL2.8 > L10 AND L10 < MINL2.11, L10, IIF(MINL2.9 > L11 AND L11 < MINL2.12, L11, IIF(MINL2.10 > L12 AND L12 < MINL2.13, L12, IIF(MINL2.11 > L13 AND L13 < MINL2.14, L13, IIF(MINL2.12 > L14 AND L14 < MINL2.15, L14, IIF(MINL2.13 > L15 AND L15 < MINL2.16, L15, IIF(MINL2.14 > L16 AND L16 < MINL2.17, L16, IIF(MINL2.15 > L17 AND L17 < MINL2.18, L17, IIF(MINL2.16 > L18 AND L18 < MINL2.19, L18, IIF(MINL2.17 > L19 AND L19 < MINL2.20, L19, IIF(MINL2.18 > L20 AND L20 < MINL2.21, L20, IIF(MINL2.19 > L21 AND L21 < MINL2.22, L21, IIF(MINL2.20 > L22 AND L22 < MINL2.23, L22, IIF(MINL2.21 > L23 AND L23 < MINL2.24, L23, IIF(MINL2.22 > L24 AND L24 < MINL2.25, L24, IIF(MINL2.23 > L25 AND L25 < MINL2.26, L25, IIF(MINL2.24 > L26 AND L26 < MINL2.27, L26, IIF(MINL2.25 > L27 AND L27 < MINL2.28, L27, IIF(MINL2.26 > L28 AND L28 < MINL2.29, L28, IIF(MINL2.27 > L29 AND L29 < MINL2.30, L29, IIF(MINL2.28 > L30 AND L30 < MINL2.31, L30, IIF(MINL2.29 > L31 AND L31 < MINL2.32, L31, IIF(MINL2.30 > L32 AND L32 < MINL2.33, L32, IIF(MINL2.31 > L33 AND L33 < MINL2.34, L33, IIF(MINL2.32 > L34 AND L34 < MINL2.35, L34, IIF(MINL2.33 > L35 AND L35 < MINL2.36, L35, IIF(MINL2.34 > L36 AND L36 < MINL2.37, L36, IIF(MINL2.35 > L37 AND L37 < MINL2.38, L37, IIF(MINL2.36 > L38 AND L38 < MINL2.39, L38, IIF(MINL2.37 > L39 AND L39 < MINL2.40, L39, IIF(MINL2.38 > L40 AND L40 < MINL2.41, L40, IIF(MINL2.39 > L41 AND L41 < MINL2.42, L41, IIF(MINL2.40 > L42 AND L42 < MINL2.43, L42, IIF(MINL2.41 > L43 AND L43 < MINL2.44, L43, IIF(MINL2.42 > L44 AND L44 < MINL2.45, L44, IIF(MINL2.43 > L45 AND L45 < MINL2.46, L45, IIF(MINL2.44 > L46 AND L46 < MINL2.47, L46, IIF(MINL2.45 > L47 AND L47 < MINL2.48, L47, IIF(MINL2.46 > L48 AND L48 < MINL2.49, L48, IIF(MINL2.47 > L49 AND L49 < MINL2.50, L49, IIF(MINL2.48 > L50 AND L50 < MINL2.51, L50, IIF(MINL2.49 > L51 AND L51 < MINL2.52, L51, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))) \ 1 >= 200

Note that I have adjusted the results in such a way that it rounds to the nearest penny in order to correct from possible rounding issues with the way computers candle floating point values and equality. The value is also is pennies. So $2.00 is 200 and not 2.



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