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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 12/18 » Hidden Divergence

Hidden Divergence Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Sunday, December 3, 2017 3:22:06 AM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce

Please click on the link below and Picture this looking at chart of " GLD"  on weekly  on July 07 ,2017 there is a 5 bar lower low fractal and Nov 03rd 2017 there is a 5 bar higher low fractal 

Now if u see below on Stochastics on the chart with settings 12-3-3

I want a custom pcf spike when Higher low fractal forms but the stochastic goes below the previous low as marked on the chart attached link this is divergence where price makes higher low and stochastic make lower low  even if the higher low fractal is not formed still if the stochastic goes below the previous low circled of July 0,2017 then still pcf should show spike when price remains higher low 

So can we do this PCF  ?

http://www.dhirenshah.com/hidden-divergence/

 

thanks a lot 

Dhiren
Back to top
Bruce_L
Posted : Monday, December 4, 2017 11:22:08 AM


Worden Trainer

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

Is a 5 bar fractal a low where price is higher for 2 bars on a both sides (for a pattern which is 5 bars long) or higher for 5 bars on both sides (for an 11 bar pattern)?

Where exactly do you want to start checking? If we only have one higher lower to the right of the central bar, should we start returning true as long as the stochastic value is lower then at the same bar as the central bars of the fractals?


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Monday, December 4, 2017 12:08:53 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce this is what i use for 5 bar fractal higher low 

IIF(MINL2 > L2 AND L2 < MINL2.3 AND L2 > 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, IIF(MINL2.50 > L52 AND L52 < MINL2.53, L52, IIF(MINL2.51 > L53 AND L53 < MINL2.54, L53, IIF(MINL2.52 > L54 AND L54 < MINL2.55, L54, IIF(MINL2.53 > L55 AND L55 < MINL2.56, L55, IIF(MINL2.54 > L56 AND L56 < MINL2.57, L56, IIF(MINL2.55 > L57 AND L57 < MINL2.58, L57, IIF(MINL2.56 > L58 AND L58 < MINL2.59, L58, IIF(MINL2.57 > L59 AND L59 < MINL2.60, L59, IIF(MINL2.58 > L60 AND L60 < MINL2.61, L60, IIF(MINL2.59 > L61 AND L61 < MINL2.62, L61, IIF(MINL2.60 > L62 AND L62 < MINL2.63, L62, IIF(MINL2.61 > L63 AND L63 < MINL2.64, L63, IIF(MINL2.62 > L64 AND L64 < MINL2.65, L64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), L2, 0)
 
 
And this is what i use for 5 bar fractal lower low
 
IIF(MINL2 > L2 AND L2 < MINL2.3 AND L2 < 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, IIF(MINL2.50 > L52 AND L52 < MINL2.53, L52, IIF(MINL2.51 > L53 AND L53 < MINL2.54, L53, IIF(MINL2.52 > L54 AND L54 < MINL2.55, L54, IIF(MINL2.53 > L55 AND L55 < MINL2.56, L55, IIF(MINL2.54 > L56 AND L56 < MINL2.57, L56, IIF(MINL2.55 > L57 AND L57 < MINL2.58, L57, IIF(MINL2.56 > L58 AND L58 < MINL2.59, L58, IIF(MINL2.57 > L59 AND L59 < MINL2.60, L59, IIF(MINL2.58 > L60 AND L60 < MINL2.61, L60, IIF(MINL2.59 > L61 AND L61 < MINL2.62, L61, IIF(MINL2.60 > L62 AND L62 < MINL2.63, L62, IIF(MINL2.61 > L63 AND L63 < MINL2.64, L63, IIF(MINL2.62 > L64 AND L64 < MINL2.65, L64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), L2, 0)
 

 

And to your query Where exactly do you want to start checking? If we only have one higher lower to the right of the central bar, should we start returning true as long as the stochastic value is lower then at the same bar as the central bars of the fractals?

Yes please start checking one higher low (orange dot )to the right of the central bar and start returning true as long as stochastic value is lower then at the same bar as the central bar of the lower low fractal(red dot )
 
thanks Bruce if this works it will open too many new ideas
Back to top
Bruce_L
Posted : Monday, December 4, 2017 2:36:01 PM


Worden Trainer

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

So I can do it on the day after the low (before it is confirmed) and on the day the low is confirmed, but I really can't just keep returning the dot until the stochastic stops being lower. The resulting formula would be too long and slow to be practical or post in the forums.


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Monday, December 4, 2017 3:09:30 PM
Registered User
Joined: 3/10/2012
Posts: 465

Hmm Okay Bruce why don't we first try to see what u can compute based on your analysis and then i will eyeball to see what fits best to tweak thereafter ... 

And while we are on the topic is it possible to this way .. please click the link 

http://www.dhirenshah.com/hidden-divergengce-reversal-pattern/

where price is making lower low and stochastic makes higher low 

thanks for everything Bruce 

Cheers
Back to top
Bruce_L
Posted : Monday, December 4, 2017 3:42:10 PM


Worden Trainer

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

Please try the following Custom PCF Indicators using the Dots Plot Style plotted in the same pane and scale as price.

IIF(IIF(L > L1 AND L1 < MINL2.2, STOC12.3.1, IIF(MINL2 > L2 AND L2 < MINL2.3, STOC12.3.2, 1 / 0)) < IIF(MINL2.2 > L4 AND L4 < MINL2.5, IIF(MINL2.1 > L4, STOC12.3.4, 1 / 0), IIF(MINL2.3 > L5 AND L5 < MINL2.6, IIF(MINL2.1 > L5, STOC12.3.5, 1 / 0), IIF(MINL2.4 > L6 AND L6 < MINL2.7, IIF(MINL2.1 > L6, STOC12.3.6, 1 / 0), IIF(MINL2.5 > L7 AND L7 < MINL2.8, IIF(MINL2.1 > L7, STOC12.3.7, 1 / 0), IIF(MINL2.6 > L8 AND L8 < MINL2.9, IIF(MINL2.1 > L8, STOC12.3.8, 1 / 0), IIF(MINL2.7 > L9 AND L9 < MINL2.10, IIF(MINL2.1 > L9, STOC12.3.9, 1 / 0), IIF(MINL2.8 > L10 AND L10 < MINL2.11, IIF(MINL2.1 > L10, STOC12.3.10, 1 / 0), IIF(MINL2.9 > L11 AND L11 < MINL2.12, IIF(MINL2.1 > L11, STOC12.3.11, 1 / 0), IIF(MINL2.10 > L12 AND L12 < MINL2.13, IIF(MINL2.1 > L12, STOC12.3.12, 1 / 0), IIF(MINL2.11 > L13 AND L13 < MINL2.14, IIF(MINL2.1 > L13, STOC12.3.13, 1 / 0), IIF(MINL2.12 > L14 AND L14 < MINL2.15, IIF(MINL2.1 > L14, STOC12.3.14, 1 / 0), IIF(MINL2.13 > L15 AND L15 < MINL2.16, IIF(MINL2.1 > L15, STOC12.3.15, 1 / 0), IIF(MINL2.14 > L16 AND L16 < MINL2.17, IIF(MINL2.1 > L16, STOC12.3.16, 1 / 0), IIF(MINL2.15 > L17 AND L17 < MINL2.18, IIF(MINL2.1 > L17, STOC12.3.17, 1 / 0), IIF(MINL2.16 > L18 AND L18 < MINL2.19, IIF(MINL2.1 > L18, STOC12.3.18, 1 / 0), IIF(MINL2.17 > L19 AND L19 < MINL2.20, IIF(MINL2.1 > L19, STOC12.3.19, 1 / 0), IIF(MINL2.18 > L20 AND L20 < MINL2.21, IIF(MINL2.1 > L20, STOC12.3.20, 1 / 0), IIF(MINL2.19 > L21 AND L21 < MINL2.22, IIF(MINL2.1 > L21, STOC12.3.21, 1 / 0), IIF(MINL2.20 > L22 AND L22 < MINL2.23, IIF(MINL2.1 > L22, STOC12.3.22, 1 / 0), IIF(MINL2.21 > L23 AND L23 < MINL2.24, IIF(MINL2.1 > L23, STOC12.3.23, 1 / 0), IIF(MINL2.22 > L24 AND L24 < MINL2.25, IIF(MINL2.1 > L24, STOC12.3.24, 1 / 0), IIF(MINL2.23 > L25 AND L25 < MINL2.26, IIF(MINL2.1 > L25, STOC12.3.25, 1 / 0), IIF(MINL2.24 > L26 AND L26 < MINL2.27, IIF(MINL2.1 > L26, STOC12.3.26, 1 / 0), IIF(MINL2.25 > L27 AND L27 < MINL2.28, IIF(MINL2.1 > L27, STOC12.3.27, 1 / 0), IIF(MINL2.26 > L28 AND L28 < MINL2.29, IIF(MINL2.1 > L28, STOC12.3.28, 1 / 0), IIF(MINL2.27 > L29 AND L29 < MINL2.30, IIF(MINL2.1 > L29, STOC12.3.29, 1 / 0), IIF(MINL2.28 > L30 AND L30 < MINL2.31, IIF(MINL2.1 > L30, STOC12.3.30, 1 / 0), IIF(MINL2.29 > L31 AND L31 < MINL2.32, IIF(MINL2.1 > L31, STOC12.3.31, 1 / 0), IIF(MINL2.30 > L32 AND L32 < MINL2.33, IIF(MINL2.1 > L32, STOC12.3.32, 1 / 0), IIF(MINL2.31 > L33 AND L33 < MINL2.34, IIF(MINL2.1 > L33, STOC12.3.33, 1 / 0), IIF(MINL2.32 > L34 AND L34 < MINL2.35, IIF(MINL2.1 > L34, STOC12.3.34, 1 / 0), IIF(MINL2.33 > L35 AND L35 < MINL2.36, IIF(MINL2.1 > L35, STOC12.3.35, 1 / 0), IIF(MINL2.34 > L36 AND L36 < MINL2.37, IIF(MINL2.1 > L36, STOC12.3.36, 1 / 0), IIF(MINL2.35 > L37 AND L37 < MINL2.38, IIF(MINL2.1 > L37, STOC12.3.37, 1 / 0), IIF(MINL2.36 > L38 AND L38 < MINL2.39, IIF(MINL2.1 > L38, STOC12.3.38, 1 / 0), IIF(MINL2.37 > L39 AND L39 < MINL2.40, IIF(MINL2.1 > L39, STOC12.3.39, 1 / 0), IIF(MINL2.38 > L40 AND L40 < MINL2.41, IIF(MINL2.1 > L40, STOC12.3.40, 1 / 0), IIF(MINL2.39 > L41 AND L41 < MINL2.42, IIF(MINL2.1 > L41, STOC12.3.41, 1 / 0), IIF(MINL2.40 > L42 AND L42 < MINL2.43, IIF(MINL2.1 > L42, STOC12.3.42, 1 / 0), IIF(MINL2.41 > L43 AND L43 < MINL2.44, IIF(MINL2.1 > L43, STOC12.3.43, 1 / 0), IIF(MINL2.42 > L44 AND L44 < MINL2.45, IIF(MINL2.1 > L44, STOC12.3.44, 1 / 0), IIF(MINL2.43 > L45 AND L45 < MINL2.46, IIF(MINL2.1 > L45, STOC12.3.45, 1 / 0), IIF(MINL2.44 > L46 AND L46 < MINL2.47, IIF(MINL2.1 > L46, STOC12.3.46, 1 / 0), IIF(MINL2.45 > L47 AND L47 < MINL2.48, IIF(MINL2.1 > L47, STOC12.3.47, 1 / 0), IIF(MINL2.46 > L48 AND L48 < MINL2.49, IIF(MINL2.1 > L48, STOC12.3.48, 1 / 0), IIF(MINL2.47 > L49 AND L49 < MINL2.50, IIF(MINL2.1 > L49, STOC12.3.49, 1 / 0), IIF(MINL2.48 > L50 AND L50 < MINL2.51, IIF(MINL2.1 > L50, STOC12.3.50, 1 / 0), IIF(MINL2.49 > L51 AND L51 < MINL2.52, IIF(MINL2.1 > L51, STOC12.3.51, 1 / 0), IIF(MINL2.50 > L52 AND L52 < MINL2.53, IIF(MINL2.1 > L52, STOC12.3.52, 1 / 0), IIF(MINL2.51 > L53 AND L53 < MINL2.54, IIF(MINL2.1 > L53, STOC12.3.53, 1 / 0), IIF(MINL2.52 > L54 AND L54 < MINL2.55, IIF(MINL2.1 > L54, STOC12.3.54, 1 / 0), IIF(MINL2.53 > L55 AND L55 < MINL2.56, IIF(MINL2.1 > L55, STOC12.3.55, 1 / 0), IIF(MINL2.54 > L56 AND L56 < MINL2.57, IIF(MINL2.1 > L56, STOC12.3.56, 1 / 0), IIF(MINL2.55 > L57 AND L57 < MINL2.58, IIF(MINL2.1 > L57, STOC12.3.57, 1 / 0), IIF(MINL2.56 > L58 AND L58 < MINL2.59, IIF(MINL2.1 > L58, STOC12.3.58, 1 / 0), IIF(MINL2.57 > L59 AND L59 < MINL2.60, IIF(MINL2.1 > L59, STOC12.3.59, 1 / 0), IIF(MINL2.58 > L60 AND L60 < MINL2.61, IIF(MINL2.1 > L60, STOC12.3.60, 1 / 0), IIF(MINL2.59 > L61 AND L61 < MINL2.62, IIF(MINL2.1 > L61, STOC12.3.61, 1 / 0), IIF(MINL2.60 > L62 AND L62 < MINL2.63, IIF(MINL2.1 > L62, STOC12.3.62, 1 / 0), IIF(MINL2.61 > L63 AND L63 < MINL2.64, IIF(MINL2.1 > L63, STOC12.3.63, 1 / 0), 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), MINL2.1, 1 / 0)

And:

IIF(IIF(H < H1 AND H1 > MAXH2.2, STOC12.3.1, IIF(MAXH2 < H2 AND H2 > MAXH2.3, STOC12.3.2, 1 / 0)) > IIF(MAXH2.2 < H4 AND H4 > MAXH2.5, IIF(MAXH2.1 < H4, STOC12.3.4, 1 / 0), IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, IIF(MAXH2.1 < H5, STOC12.3.5, 1 / 0), IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, IIF(MAXH2.1 < H6, STOC12.3.6, 1 / 0), IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, IIF(MAXH2.1 < H7, STOC12.3.7, 1 / 0), IIF(MAXH2.6 < H8 AND H8 > MAXH2.9, IIF(MAXH2.1 < H8, STOC12.3.8, 1 / 0), IIF(MAXH2.7 < H9 AND H9 > MAXH2.10, IIF(MAXH2.1 < H9, STOC12.3.9, 1 / 0), IIF(MAXH2.8 < H10 AND H10 > MAXH2.11, IIF(MAXH2.1 < H10, STOC12.3.10, 1 / 0), IIF(MAXH2.9 < H11 AND H11 > MAXH2.12, IIF(MAXH2.1 < H11, STOC12.3.11, 1 / 0), IIF(MAXH2.10 < H12 AND H12 > MAXH2.13, IIF(MAXH2.1 < H12, STOC12.3.12, 1 / 0), IIF(MAXH2.11 < H13 AND H13 > MAXH2.14, IIF(MAXH2.1 < H13, STOC12.3.13, 1 / 0), IIF(MAXH2.12 < H14 AND H14 > MAXH2.15, IIF(MAXH2.1 < H14, STOC12.3.14, 1 / 0), IIF(MAXH2.13 < H15 AND H15 > MAXH2.16, IIF(MAXH2.1 < H15, STOC12.3.15, 1 / 0), IIF(MAXH2.14 < H16 AND H16 > MAXH2.17, IIF(MAXH2.1 < H16, STOC12.3.16, 1 / 0), IIF(MAXH2.15 < H17 AND H17 > MAXH2.18, IIF(MAXH2.1 < H17, STOC12.3.17, 1 / 0), IIF(MAXH2.16 < H18 AND H18 > MAXH2.19, IIF(MAXH2.1 < H18, STOC12.3.18, 1 / 0), IIF(MAXH2.17 < H19 AND H19 > MAXH2.20, IIF(MAXH2.1 < H19, STOC12.3.19, 1 / 0), IIF(MAXH2.18 < H20 AND H20 > MAXH2.21, IIF(MAXH2.1 < H20, STOC12.3.20, 1 / 0), IIF(MAXH2.19 < H21 AND H21 > MAXH2.22, IIF(MAXH2.1 < H21, STOC12.3.21, 1 / 0), IIF(MAXH2.20 < H22 AND H22 > MAXH2.23, IIF(MAXH2.1 < H22, STOC12.3.22, 1 / 0), IIF(MAXH2.21 < H23 AND H23 > MAXH2.24, IIF(MAXH2.1 < H23, STOC12.3.23, 1 / 0), IIF(MAXH2.22 < H24 AND H24 > MAXH2.25, IIF(MAXH2.1 < H24, STOC12.3.24, 1 / 0), IIF(MAXH2.23 < H25 AND H25 > MAXH2.26, IIF(MAXH2.1 < H25, STOC12.3.25, 1 / 0), IIF(MAXH2.24 < H26 AND H26 > MAXH2.27, IIF(MAXH2.1 < H26, STOC12.3.26, 1 / 0), IIF(MAXH2.25 < H27 AND H27 > MAXH2.28, IIF(MAXH2.1 < H27, STOC12.3.27, 1 / 0), IIF(MAXH2.26 < H28 AND H28 > MAXH2.29, IIF(MAXH2.1 < H28, STOC12.3.28, 1 / 0), IIF(MAXH2.27 < H29 AND H29 > MAXH2.30, IIF(MAXH2.1 < H29, STOC12.3.29, 1 / 0), IIF(MAXH2.28 < H30 AND H30 > MAXH2.31, IIF(MAXH2.1 < H30, STOC12.3.30, 1 / 0), IIF(MAXH2.29 < H31 AND H31 > MAXH2.32, IIF(MAXH2.1 < H31, STOC12.3.31, 1 / 0), IIF(MAXH2.30 < H32 AND H32 > MAXH2.33, IIF(MAXH2.1 < H32, STOC12.3.32, 1 / 0), IIF(MAXH2.31 < H33 AND H33 > MAXH2.34, IIF(MAXH2.1 < H33, STOC12.3.33, 1 / 0), IIF(MAXH2.32 < H34 AND H34 > MAXH2.35, IIF(MAXH2.1 < H34, STOC12.3.34, 1 / 0), IIF(MAXH2.33 < H35 AND H35 > MAXH2.36, IIF(MAXH2.1 < H35, STOC12.3.35, 1 / 0), IIF(MAXH2.34 < H36 AND H36 > MAXH2.37, IIF(MAXH2.1 < H36, STOC12.3.36, 1 / 0), IIF(MAXH2.35 < H37 AND H37 > MAXH2.38, IIF(MAXH2.1 < H37, STOC12.3.37, 1 / 0), IIF(MAXH2.36 < H38 AND H38 > MAXH2.39, IIF(MAXH2.1 < H38, STOC12.3.38, 1 / 0), IIF(MAXH2.37 < H39 AND H39 > MAXH2.40, IIF(MAXH2.1 < H39, STOC12.3.39, 1 / 0), IIF(MAXH2.38 < H40 AND H40 > MAXH2.41, IIF(MAXH2.1 < H40, STOC12.3.40, 1 / 0), IIF(MAXH2.39 < H41 AND H41 > MAXH2.42, IIF(MAXH2.1 < H41, STOC12.3.41, 1 / 0), IIF(MAXH2.40 < H42 AND H42 > MAXH2.43, IIF(MAXH2.1 < H42, STOC12.3.42, 1 / 0), IIF(MAXH2.41 < H43 AND H43 > MAXH2.44, IIF(MAXH2.1 < H43, STOC12.3.43, 1 / 0), IIF(MAXH2.42 < H44 AND H44 > MAXH2.45, IIF(MAXH2.1 < H44, STOC12.3.44, 1 / 0), IIF(MAXH2.43 < H45 AND H45 > MAXH2.46, IIF(MAXH2.1 < H45, STOC12.3.45, 1 / 0), IIF(MAXH2.44 < H46 AND H46 > MAXH2.47, IIF(MAXH2.1 < H46, STOC12.3.46, 1 / 0), IIF(MAXH2.45 < H47 AND H47 > MAXH2.48, IIF(MAXH2.1 < H47, STOC12.3.47, 1 / 0), IIF(MAXH2.46 < H48 AND H48 > MAXH2.49, IIF(MAXH2.1 < H48, STOC12.3.48, 1 / 0), IIF(MAXH2.47 < H49 AND H49 > MAXH2.50, IIF(MAXH2.1 < H49, STOC12.3.49, 1 / 0), IIF(MAXH2.48 < H50 AND H50 > MAXH2.51, IIF(MAXH2.1 < H50, STOC12.3.50, 1 / 0), IIF(MAXH2.49 < H51 AND H51 > MAXH2.52, IIF(MAXH2.1 < H51, STOC12.3.51, 1 / 0), IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, IIF(MAXH2.1 < H52, STOC12.3.52, 1 / 0), IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, IIF(MAXH2.1 < H53, STOC12.3.53, 1 / 0), IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, IIF(MAXH2.1 < H54, STOC12.3.54, 1 / 0), IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, IIF(MAXH2.1 < H55, STOC12.3.55, 1 / 0), IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, IIF(MAXH2.1 < H56, STOC12.3.56, 1 / 0), IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, IIF(MAXH2.1 < H57, STOC12.3.57, 1 / 0), IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, IIF(MAXH2.1 < H58, STOC12.3.58, 1 / 0), IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, IIF(MAXH2.1 < H59, STOC12.3.59, 1 / 0), IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, IIF(MAXH2.1 < H60, STOC12.3.60, 1 / 0), IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, IIF(MAXH2.1 < H61, STOC12.3.61, 1 / 0), IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, IIF(MAXH2.1 < H62, STOC12.3.62, 1 / 0), IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, IIF(MAXH2.1 < H63, STOC12.3.63, 1 / 0), 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), MAXH2.1, 1 / 0)


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Tuesday, December 5, 2017 1:27:27 AM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce the first formula you did is perfect that two dots are enough intimation its good for me... i can eyeball smaller list then what i use too i don't need any changes 

second formula u did inverse where price makes LOWER HIGH AND STOCHASTIC MAKES HIGHER HIGH that is good 

but what i was looking for is price makes LOWER LOW and stochastic make higher low  

this link is exactly what it does as posted previously http://www.dhirenshah.com/hidden-divergengce-reversal-pattern/    to the upside 

and using the same idea of 5 bar fractal pcf from my first response above ,

can u please also do the inverse for the same where Price makes HIGHER HIGH and stochastic makes Lower High example http://www.dhirenshah.com/bearish-regular-divergence/

For my higher high fractal formula i use this as below 

IIF(MAXH2 < H2 AND H2 > MAXH2.3 AND H2 > 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, IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, H52, IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, H53, IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, H54, IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, H55, IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, H56, IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, H57, IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, H58, IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, H59, IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, H60, IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, H61, IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, H62, IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, H63, IIF(MAXH2.62 < H64 AND H64 > MAXH2.65, H64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), H2, 0)
 
Back to top
Bruce_L
Posted : Tuesday, December 5, 2017 9:20:37 AM


Worden Trainer

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

So?:

IIF(IIF(L > L1 AND L1 < MINL2.2, STOC12.3.1, IIF(MINL2 > L2 AND L2 < MINL2.3, STOC12.3.2, 1 / 0)) > IIF(MINL2.2 > L4 AND L4 < MINL2.5, IIF(MINL2.1 < L4, STOC12.3.4, 1 / 0), IIF(MINL2.3 > L5 AND L5 < MINL2.6, IIF(MINL2.1 < L5, STOC12.3.5, 1 / 0), IIF(MINL2.4 > L6 AND L6 < MINL2.7, IIF(MINL2.1 < L6, STOC12.3.6, 1 / 0), IIF(MINL2.5 > L7 AND L7 < MINL2.8, IIF(MINL2.1 < L7, STOC12.3.7, 1 / 0), IIF(MINL2.6 > L8 AND L8 < MINL2.9, IIF(MINL2.1 < L8, STOC12.3.8, 1 / 0), IIF(MINL2.7 > L9 AND L9 < MINL2.10, IIF(MINL2.1 < L9, STOC12.3.9, 1 / 0), IIF(MINL2.8 > L10 AND L10 < MINL2.11, IIF(MINL2.1 < L10, STOC12.3.10, 1 / 0), IIF(MINL2.9 > L11 AND L11 < MINL2.12, IIF(MINL2.1 < L11, STOC12.3.11, 1 / 0), IIF(MINL2.10 > L12 AND L12 < MINL2.13, IIF(MINL2.1 < L12, STOC12.3.12, 1 / 0), IIF(MINL2.11 > L13 AND L13 < MINL2.14, IIF(MINL2.1 < L13, STOC12.3.13, 1 / 0), IIF(MINL2.12 > L14 AND L14 < MINL2.15, IIF(MINL2.1 < L14, STOC12.3.14, 1 / 0), IIF(MINL2.13 > L15 AND L15 < MINL2.16, IIF(MINL2.1 < L15, STOC12.3.15, 1 / 0), IIF(MINL2.14 > L16 AND L16 < MINL2.17, IIF(MINL2.1 < L16, STOC12.3.16, 1 / 0), IIF(MINL2.15 > L17 AND L17 < MINL2.18, IIF(MINL2.1 < L17, STOC12.3.17, 1 / 0), IIF(MINL2.16 > L18 AND L18 < MINL2.19, IIF(MINL2.1 < L18, STOC12.3.18, 1 / 0), IIF(MINL2.17 > L19 AND L19 < MINL2.20, IIF(MINL2.1 < L19, STOC12.3.19, 1 / 0), IIF(MINL2.18 > L20 AND L20 < MINL2.21, IIF(MINL2.1 < L20, STOC12.3.20, 1 / 0), IIF(MINL2.19 > L21 AND L21 < MINL2.22, IIF(MINL2.1 < L21, STOC12.3.21, 1 / 0), IIF(MINL2.20 > L22 AND L22 < MINL2.23, IIF(MINL2.1 < L22, STOC12.3.22, 1 / 0), IIF(MINL2.21 > L23 AND L23 < MINL2.24, IIF(MINL2.1 < L23, STOC12.3.23, 1 / 0), IIF(MINL2.22 > L24 AND L24 < MINL2.25, IIF(MINL2.1 < L24, STOC12.3.24, 1 / 0), IIF(MINL2.23 > L25 AND L25 < MINL2.26, IIF(MINL2.1 < L25, STOC12.3.25, 1 / 0), IIF(MINL2.24 > L26 AND L26 < MINL2.27, IIF(MINL2.1 < L26, STOC12.3.26, 1 / 0), IIF(MINL2.25 > L27 AND L27 < MINL2.28, IIF(MINL2.1 < L27, STOC12.3.27, 1 / 0), IIF(MINL2.26 > L28 AND L28 < MINL2.29, IIF(MINL2.1 < L28, STOC12.3.28, 1 / 0), IIF(MINL2.27 > L29 AND L29 < MINL2.30, IIF(MINL2.1 < L29, STOC12.3.29, 1 / 0), IIF(MINL2.28 > L30 AND L30 < MINL2.31, IIF(MINL2.1 < L30, STOC12.3.30, 1 / 0), IIF(MINL2.29 > L31 AND L31 < MINL2.32, IIF(MINL2.1 < L31, STOC12.3.31, 1 / 0), IIF(MINL2.30 > L32 AND L32 < MINL2.33, IIF(MINL2.1 < L32, STOC12.3.32, 1 / 0), IIF(MINL2.31 > L33 AND L33 < MINL2.34, IIF(MINL2.1 < L33, STOC12.3.33, 1 / 0), IIF(MINL2.32 > L34 AND L34 < MINL2.35, IIF(MINL2.1 < L34, STOC12.3.34, 1 / 0), IIF(MINL2.33 > L35 AND L35 < MINL2.36, IIF(MINL2.1 < L35, STOC12.3.35, 1 / 0), IIF(MINL2.34 > L36 AND L36 < MINL2.37, IIF(MINL2.1 < L36, STOC12.3.36, 1 / 0), IIF(MINL2.35 > L37 AND L37 < MINL2.38, IIF(MINL2.1 < L37, STOC12.3.37, 1 / 0), IIF(MINL2.36 > L38 AND L38 < MINL2.39, IIF(MINL2.1 < L38, STOC12.3.38, 1 / 0), IIF(MINL2.37 > L39 AND L39 < MINL2.40, IIF(MINL2.1 < L39, STOC12.3.39, 1 / 0), IIF(MINL2.38 > L40 AND L40 < MINL2.41, IIF(MINL2.1 < L40, STOC12.3.40, 1 / 0), IIF(MINL2.39 > L41 AND L41 < MINL2.42, IIF(MINL2.1 < L41, STOC12.3.41, 1 / 0), IIF(MINL2.40 > L42 AND L42 < MINL2.43, IIF(MINL2.1 < L42, STOC12.3.42, 1 / 0), IIF(MINL2.41 > L43 AND L43 < MINL2.44, IIF(MINL2.1 < L43, STOC12.3.43, 1 / 0), IIF(MINL2.42 > L44 AND L44 < MINL2.45, IIF(MINL2.1 < L44, STOC12.3.44, 1 / 0), IIF(MINL2.43 > L45 AND L45 < MINL2.46, IIF(MINL2.1 < L45, STOC12.3.45, 1 / 0), IIF(MINL2.44 > L46 AND L46 < MINL2.47, IIF(MINL2.1 < L46, STOC12.3.46, 1 / 0), IIF(MINL2.45 > L47 AND L47 < MINL2.48, IIF(MINL2.1 < L47, STOC12.3.47, 1 / 0), IIF(MINL2.46 > L48 AND L48 < MINL2.49, IIF(MINL2.1 < L48, STOC12.3.48, 1 / 0), IIF(MINL2.47 > L49 AND L49 < MINL2.50, IIF(MINL2.1 < L49, STOC12.3.49, 1 / 0), IIF(MINL2.48 > L50 AND L50 < MINL2.51, IIF(MINL2.1 < L50, STOC12.3.50, 1 / 0), IIF(MINL2.49 > L51 AND L51 < MINL2.52, IIF(MINL2.1 < L51, STOC12.3.51, 1 / 0), IIF(MINL2.50 > L52 AND L52 < MINL2.53, IIF(MINL2.1 < L52, STOC12.3.52, 1 / 0), IIF(MINL2.51 > L53 AND L53 < MINL2.54, IIF(MINL2.1 < L53, STOC12.3.53, 1 / 0), IIF(MINL2.52 > L54 AND L54 < MINL2.55, IIF(MINL2.1 < L54, STOC12.3.54, 1 / 0), IIF(MINL2.53 > L55 AND L55 < MINL2.56, IIF(MINL2.1 < L55, STOC12.3.55, 1 / 0), IIF(MINL2.54 > L56 AND L56 < MINL2.57, IIF(MINL2.1 < L56, STOC12.3.56, 1 / 0), IIF(MINL2.55 > L57 AND L57 < MINL2.58, IIF(MINL2.1 < L57, STOC12.3.57, 1 / 0), IIF(MINL2.56 > L58 AND L58 < MINL2.59, IIF(MINL2.1 < L58, STOC12.3.58, 1 / 0), IIF(MINL2.57 > L59 AND L59 < MINL2.60, IIF(MINL2.1 < L59, STOC12.3.59, 1 / 0), IIF(MINL2.58 > L60 AND L60 < MINL2.61, IIF(MINL2.1 < L60, STOC12.3.60, 1 / 0), IIF(MINL2.59 > L61 AND L61 < MINL2.62, IIF(MINL2.1 < L61, STOC12.3.61, 1 / 0), IIF(MINL2.60 > L62 AND L62 < MINL2.63, IIF(MINL2.1 < L62, STOC12.3.62, 1 / 0), IIF(MINL2.61 > L63 AND L63 < MINL2.64, IIF(MINL2.1 < L63, STOC12.3.63, 1 / 0), 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), MINL2.1, 1 / 0)

And?:

IIF(IIF(H < H1 AND H1 > MAXH2.2, STOC12.3.1, IIF(MAXH2 < H2 AND H2 > MAXH2.3, STOC12.3.2, 1 / 0)) < IIF(MAXH2.2 < H4 AND H4 > MAXH2.5, IIF(MAXH2.1 > H4, STOC12.3.4, 1 / 0), IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, IIF(MAXH2.1 > H5, STOC12.3.5, 1 / 0), IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, IIF(MAXH2.1 > H6, STOC12.3.6, 1 / 0), IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, IIF(MAXH2.1 > H7, STOC12.3.7, 1 / 0), IIF(MAXH2.6 < H8 AND H8 > MAXH2.9, IIF(MAXH2.1 > H8, STOC12.3.8, 1 / 0), IIF(MAXH2.7 < H9 AND H9 > MAXH2.10, IIF(MAXH2.1 > H9, STOC12.3.9, 1 / 0), IIF(MAXH2.8 < H10 AND H10 > MAXH2.11, IIF(MAXH2.1 > H10, STOC12.3.10, 1 / 0), IIF(MAXH2.9 < H11 AND H11 > MAXH2.12, IIF(MAXH2.1 > H11, STOC12.3.11, 1 / 0), IIF(MAXH2.10 < H12 AND H12 > MAXH2.13, IIF(MAXH2.1 > H12, STOC12.3.12, 1 / 0), IIF(MAXH2.11 < H13 AND H13 > MAXH2.14, IIF(MAXH2.1 > H13, STOC12.3.13, 1 / 0), IIF(MAXH2.12 < H14 AND H14 > MAXH2.15, IIF(MAXH2.1 > H14, STOC12.3.14, 1 / 0), IIF(MAXH2.13 < H15 AND H15 > MAXH2.16, IIF(MAXH2.1 > H15, STOC12.3.15, 1 / 0), IIF(MAXH2.14 < H16 AND H16 > MAXH2.17, IIF(MAXH2.1 > H16, STOC12.3.16, 1 / 0), IIF(MAXH2.15 < H17 AND H17 > MAXH2.18, IIF(MAXH2.1 > H17, STOC12.3.17, 1 / 0), IIF(MAXH2.16 < H18 AND H18 > MAXH2.19, IIF(MAXH2.1 > H18, STOC12.3.18, 1 / 0), IIF(MAXH2.17 < H19 AND H19 > MAXH2.20, IIF(MAXH2.1 > H19, STOC12.3.19, 1 / 0), IIF(MAXH2.18 < H20 AND H20 > MAXH2.21, IIF(MAXH2.1 > H20, STOC12.3.20, 1 / 0), IIF(MAXH2.19 < H21 AND H21 > MAXH2.22, IIF(MAXH2.1 > H21, STOC12.3.21, 1 / 0), IIF(MAXH2.20 < H22 AND H22 > MAXH2.23, IIF(MAXH2.1 > H22, STOC12.3.22, 1 / 0), IIF(MAXH2.21 < H23 AND H23 > MAXH2.24, IIF(MAXH2.1 > H23, STOC12.3.23, 1 / 0), IIF(MAXH2.22 < H24 AND H24 > MAXH2.25, IIF(MAXH2.1 > H24, STOC12.3.24, 1 / 0), IIF(MAXH2.23 < H25 AND H25 > MAXH2.26, IIF(MAXH2.1 > H25, STOC12.3.25, 1 / 0), IIF(MAXH2.24 < H26 AND H26 > MAXH2.27, IIF(MAXH2.1 > H26, STOC12.3.26, 1 / 0), IIF(MAXH2.25 < H27 AND H27 > MAXH2.28, IIF(MAXH2.1 > H27, STOC12.3.27, 1 / 0), IIF(MAXH2.26 < H28 AND H28 > MAXH2.29, IIF(MAXH2.1 > H28, STOC12.3.28, 1 / 0), IIF(MAXH2.27 < H29 AND H29 > MAXH2.30, IIF(MAXH2.1 > H29, STOC12.3.29, 1 / 0), IIF(MAXH2.28 < H30 AND H30 > MAXH2.31, IIF(MAXH2.1 > H30, STOC12.3.30, 1 / 0), IIF(MAXH2.29 < H31 AND H31 > MAXH2.32, IIF(MAXH2.1 > H31, STOC12.3.31, 1 / 0), IIF(MAXH2.30 < H32 AND H32 > MAXH2.33, IIF(MAXH2.1 > H32, STOC12.3.32, 1 / 0), IIF(MAXH2.31 < H33 AND H33 > MAXH2.34, IIF(MAXH2.1 > H33, STOC12.3.33, 1 / 0), IIF(MAXH2.32 < H34 AND H34 > MAXH2.35, IIF(MAXH2.1 > H34, STOC12.3.34, 1 / 0), IIF(MAXH2.33 < H35 AND H35 > MAXH2.36, IIF(MAXH2.1 > H35, STOC12.3.35, 1 / 0), IIF(MAXH2.34 < H36 AND H36 > MAXH2.37, IIF(MAXH2.1 > H36, STOC12.3.36, 1 / 0), IIF(MAXH2.35 < H37 AND H37 > MAXH2.38, IIF(MAXH2.1 > H37, STOC12.3.37, 1 / 0), IIF(MAXH2.36 < H38 AND H38 > MAXH2.39, IIF(MAXH2.1 > H38, STOC12.3.38, 1 / 0), IIF(MAXH2.37 < H39 AND H39 > MAXH2.40, IIF(MAXH2.1 > H39, STOC12.3.39, 1 / 0), IIF(MAXH2.38 < H40 AND H40 > MAXH2.41, IIF(MAXH2.1 > H40, STOC12.3.40, 1 / 0), IIF(MAXH2.39 < H41 AND H41 > MAXH2.42, IIF(MAXH2.1 > H41, STOC12.3.41, 1 / 0), IIF(MAXH2.40 < H42 AND H42 > MAXH2.43, IIF(MAXH2.1 > H42, STOC12.3.42, 1 / 0), IIF(MAXH2.41 < H43 AND H43 > MAXH2.44, IIF(MAXH2.1 > H43, STOC12.3.43, 1 / 0), IIF(MAXH2.42 < H44 AND H44 > MAXH2.45, IIF(MAXH2.1 > H44, STOC12.3.44, 1 / 0), IIF(MAXH2.43 < H45 AND H45 > MAXH2.46, IIF(MAXH2.1 > H45, STOC12.3.45, 1 / 0), IIF(MAXH2.44 < H46 AND H46 > MAXH2.47, IIF(MAXH2.1 > H46, STOC12.3.46, 1 / 0), IIF(MAXH2.45 < H47 AND H47 > MAXH2.48, IIF(MAXH2.1 > H47, STOC12.3.47, 1 / 0), IIF(MAXH2.46 < H48 AND H48 > MAXH2.49, IIF(MAXH2.1 > H48, STOC12.3.48, 1 / 0), IIF(MAXH2.47 < H49 AND H49 > MAXH2.50, IIF(MAXH2.1 > H49, STOC12.3.49, 1 / 0), IIF(MAXH2.48 < H50 AND H50 > MAXH2.51, IIF(MAXH2.1 > H50, STOC12.3.50, 1 / 0), IIF(MAXH2.49 < H51 AND H51 > MAXH2.52, IIF(MAXH2.1 > H51, STOC12.3.51, 1 / 0), IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, IIF(MAXH2.1 > H52, STOC12.3.52, 1 / 0), IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, IIF(MAXH2.1 > H53, STOC12.3.53, 1 / 0), IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, IIF(MAXH2.1 > H54, STOC12.3.54, 1 / 0), IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, IIF(MAXH2.1 > H55, STOC12.3.55, 1 / 0), IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, IIF(MAXH2.1 > H56, STOC12.3.56, 1 / 0), IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, IIF(MAXH2.1 > H57, STOC12.3.57, 1 / 0), IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, IIF(MAXH2.1 > H58, STOC12.3.58, 1 / 0), IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, IIF(MAXH2.1 > H59, STOC12.3.59, 1 / 0), IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, IIF(MAXH2.1 > H60, STOC12.3.60, 1 / 0), IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, IIF(MAXH2.1 > H61, STOC12.3.61, 1 / 0), IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, IIF(MAXH2.1 > H62, STOC12.3.62, 1 / 0), IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, IIF(MAXH2.1 > H63, STOC12.3.63, 1 / 0), 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), MAXH2.1, 1 / 0)


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Tuesday, December 5, 2017 10:54:05 AM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce everything works perfect , thank you so very much , now next will be harmonic patterns but not today , will follow-up soon.... 

Cheers

Dhiren 
Back to top
dhirenshah
Posted : Tuesday, December 5, 2017 3:29:06 PM
Registered User
Joined: 3/10/2012
Posts: 465

Sorry bruce one quick question 

your FIRST formula posted Monday, December 04, 2017 3:42:10 PM  so can we do  a slight change where the dots ON THE SIDE only show when FRACTAL LOWER LOW (RED DOT ) is higher then previous Lower Low red dot 

Like this idea  http://www.dhirenshah.com/hidden-divergence-195-minute-chart-bullish/

thanks 
Back to top
Bruce_L
Posted : Tuesday, December 5, 2017 3:30:27 PM


Worden Trainer

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

No.


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
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.