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

pcf decimal error Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Tuesday, February 12, 2019 1:49:49 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce I am trying to create this PCF as below but its giving me error message as : numeric value with multiple decimal places at position 87 " so in the newer version can u please ask the development team to have that particular error highlighted so we can fix on our own because position 87 means what and where ?

Please help me to correct this below pcf 

IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.2 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.2 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.3, 2) AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.2 > IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.3, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.5 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.5 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.6, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.5, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.4, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.6 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.6 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.7, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.6, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.5, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.7 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.7 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.8, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.7, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.6, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.8 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.8 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.9, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.8, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.7, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.9 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.9 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.10, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.9, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.8, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.10 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.10 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.11, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.10, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.9, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.11 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.11 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.12, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.11, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.10, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.12 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.12 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.13, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.12, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.11, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.13 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.13 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.14, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.13, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.12, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.14 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.14 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.15, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.14, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.13, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.15 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.15 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.16, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.15, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.14, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.16 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.16 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.17, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.16, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.15, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.17 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.17 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.18, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.17, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.16, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.18 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.18 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.19, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.18, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.17, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.19 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.19 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.20, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.19, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.18, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.20 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.20 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.21, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.20, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.19, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.21 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.21 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.22, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.21, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.20, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.22 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.22 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.23, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.22, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.21, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.23 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.23 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.24, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.23, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.22, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.24 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.24 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.25, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.24, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.23, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.25 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.25 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.26, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.25, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.24, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.26 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.26 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.27, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.26, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.25, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.27 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.27 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.28, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.27, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.26, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.28 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.28 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.29, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.28, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.27, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.29 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.29 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.30, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.29, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.28, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.30 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.30 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.31, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.30, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.29, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.31 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.31 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.32, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.31, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.30, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.32 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.32 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.33, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.32, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.31, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.33 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.33 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.34, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.33, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.32, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.34 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.34 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.35, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.34, IIF(MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.33, 2) < (C - AVGC20) / 2 / 2 / STDDEV20 + .5.35 AND (C - AVGC20) / 2 / 2 / STDDEV20 + .5.35 > MAX((C - AVGC20) / 2 / 2 / STDDEV20 + .5.36, 2), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.35, 101))))))))))))))))))))))))))))))), (C - AVGC20) / 2 / 2 / STDDEV20 + .5.2, -10)
 
thanks
 
Bruce_L
Posted : Tuesday, February 12, 2019 2:20:19 PM


Worden Trainer

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

Position 87 is the 87th character in the entire formula. The issue is that .5.2 in the formula and the many subsequent .5.s going from .5.2 through .5.36 as the various bars ago parameters increase.

I am really not quite sure what the formula is supposed to be doing to tell you how to correct it. There seem to be a bunch of bars ago parameters connected to the end of numbers instead of being attached to the end of indicator syntax.

I guess I could have created something like this using copy and replace, but I usually test long formulas like this before I post them in the forums.

Thank you for your suggestion.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Tuesday, February 12, 2019 2:30:29 PM
Registered User
Joined: 3/10/2012
Posts: 465

Ok bruce what i was trying to do is make dot plot overlayed as  higher high fractal , Lower high fractal  , Higher low fractal and Lower Low fractal on Bollinger bands %B with 4 different colours 

So can u please help , I thought i might be able to do it myself but obviously without your expert input nothing seems to fall in right place 

thankyou 

Bruce_L
Posted : Tuesday, February 12, 2019 4:01:13 PM


Worden Trainer

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

I probably am not going to be able to do the full formula until sometime tomorrow, so let me show you what the problem seems to be.

Where you have written the following for the 2 bars ago version of Bollinger Band %B:

(C - AVGC20) / 2 / 2 / STDDEV20 + .5.2

It needs to actually be the following instead:

(C2 - AVGC20.2) / 2 / 2 / STDDEV20.2 + .5

But you don't actually need to calculate the entire Bollinger Bands %B formula:

(C - AVGC20) / 2 / 2 / STDDEV20 + .5

You can actually eliminate both the / 2 / 2 and the + .5 sections of the formula. If Bollinger Bands %B is at its highest point, then the following would be as well.

(C - AVGC20) / STDDEV20

And the 2 bars ago version of that woul dbe:

(C2 - AVGC20.2) / STDDEV20.2

I don't know if you want to give it a try before tomorrow or not.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Tuesday, February 12, 2019 4:11:21 PM
Registered User
Joined: 3/10/2012
Posts: 465

No problem Bruce i will wait until tomorrow for you to  give me the pcf  because the other ones i will goof up > < signs i know 

thanks 

Bruce_L
Posted : Wednesday, February 13, 2019 12:04:35 PM


Worden Trainer

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

My assumption is that is a lower high fractal.

IIF((C2 - AVGC20.2) / STDDEV20.2 > GREATEST(MAX((C0 - AVGC20.0) / STDDEV20.0, 2), MAX((C3 - AVGC20.3) / STDDEV20.3, 2)) AND (C2 - AVGC20.2) / STDDEV20.2 < IIF((C5 - AVGC20.5) / STDDEV20.5 > GREATEST(MAX((C3 - AVGC20.3) / STDDEV20.3, 2), MAX((C6 - AVGC20.6) / STDDEV20.6, 2)), (C5 - AVGC20.5) / STDDEV20.5, IIF((C6 - AVGC20.6) / STDDEV20.6 > GREATEST(MAX((C4 - AVGC20.4) / STDDEV20.4, 2), MAX((C7 - AVGC20.7) / STDDEV20.7, 2)), (C6 - AVGC20.6) / STDDEV20.6, IIF((C7 - AVGC20.7) / STDDEV20.7 > GREATEST(MAX((C5 - AVGC20.5) / STDDEV20.5, 2), MAX((C8 - AVGC20.8) / STDDEV20.8, 2)), (C7 - AVGC20.7) / STDDEV20.7, IIF((C8 - AVGC20.8) / STDDEV20.8 > GREATEST(MAX((C6 - AVGC20.6) / STDDEV20.6, 2), MAX((C9 - AVGC20.9) / STDDEV20.9, 2)), (C8 - AVGC20.8) / STDDEV20.8, IIF((C9 - AVGC20.9) / STDDEV20.9 > GREATEST(MAX((C7 - AVGC20.7) / STDDEV20.7, 2), MAX((C10 - AVGC20.10) / STDDEV20.10, 2)), (C9 - AVGC20.9) / STDDEV20.9, IIF((C10 - AVGC20.10) / STDDEV20.10 > GREATEST(MAX((C8 - AVGC20.8) / STDDEV20.8, 2), MAX((C11 - AVGC20.11) / STDDEV20.11, 2)), (C10 - AVGC20.10) / STDDEV20.10, IIF((C11 - AVGC20.11) / STDDEV20.11 > GREATEST(MAX((C9 - AVGC20.9) / STDDEV20.9, 2), MAX((C12 - AVGC20.12) / STDDEV20.12, 2)), (C11 - AVGC20.11) / STDDEV20.11, IIF((C12 - AVGC20.12) / STDDEV20.12 > GREATEST(MAX((C10 - AVGC20.10) / STDDEV20.10, 2), MAX((C13 - AVGC20.13) / STDDEV20.13, 2)), (C12 - AVGC20.12) / STDDEV20.12, IIF((C13 - AVGC20.13) / STDDEV20.13 > GREATEST(MAX((C11 - AVGC20.11) / STDDEV20.11, 2), MAX((C14 - AVGC20.14) / STDDEV20.14, 2)), (C13 - AVGC20.13) / STDDEV20.13, IIF((C14 - AVGC20.14) / STDDEV20.14 > GREATEST(MAX((C12 - AVGC20.12) / STDDEV20.12, 2), MAX((C15 - AVGC20.15) / STDDEV20.15, 2)), (C14 - AVGC20.14) / STDDEV20.14, IIF((C15 - AVGC20.15) / STDDEV20.15 > GREATEST(MAX((C13 - AVGC20.13) / STDDEV20.13, 2), MAX((C16 - AVGC20.16) / STDDEV20.16, 2)), (C15 - AVGC20.15) / STDDEV20.15, IIF((C16 - AVGC20.16) / STDDEV20.16 > GREATEST(MAX((C14 - AVGC20.14) / STDDEV20.14, 2), MAX((C17 - AVGC20.17) / STDDEV20.17, 2)), (C16 - AVGC20.16) / STDDEV20.16, IIF((C17 - AVGC20.17) / STDDEV20.17 > GREATEST(MAX((C15 - AVGC20.15) / STDDEV20.15, 2), MAX((C18 - AVGC20.18) / STDDEV20.18, 2)), (C17 - AVGC20.17) / STDDEV20.17, IIF((C18 - AVGC20.18) / STDDEV20.18 > GREATEST(MAX((C16 - AVGC20.16) / STDDEV20.16, 2), MAX((C19 - AVGC20.19) / STDDEV20.19, 2)), (C18 - AVGC20.18) / STDDEV20.18, IIF((C19 - AVGC20.19) / STDDEV20.19 > GREATEST(MAX((C17 - AVGC20.17) / STDDEV20.17, 2), MAX((C20 - AVGC20.20) / STDDEV20.20, 2)), (C19 - AVGC20.19) / STDDEV20.19, IIF((C20 - AVGC20.20) / STDDEV20.20 > GREATEST(MAX((C18 - AVGC20.18) / STDDEV20.18, 2), MAX((C21 - AVGC20.21) / STDDEV20.21, 2)), (C20 - AVGC20.20) / STDDEV20.20, IIF((C21 - AVGC20.21) / STDDEV20.21 > GREATEST(MAX((C19 - AVGC20.19) / STDDEV20.19, 2), MAX((C22 - AVGC20.22) / STDDEV20.22, 2)), (C21 - AVGC20.21) / STDDEV20.21, IIF((C22 - AVGC20.22) / STDDEV20.22 > GREATEST(MAX((C20 - AVGC20.20) / STDDEV20.20, 2), MAX((C23 - AVGC20.23) / STDDEV20.23, 2)), (C22 - AVGC20.22) / STDDEV20.22, IIF((C23 - AVGC20.23) / STDDEV20.23 > GREATEST(MAX((C21 - AVGC20.21) / STDDEV20.21, 2), MAX((C24 - AVGC20.24) / STDDEV20.24, 2)), (C23 - AVGC20.23) / STDDEV20.23, IIF((C24 - AVGC20.24) / STDDEV20.24 > GREATEST(MAX((C22 - AVGC20.22) / STDDEV20.22, 2), MAX((C25 - AVGC20.25) / STDDEV20.25, 2)), (C24 - AVGC20.24) / STDDEV20.24, IIF((C25 - AVGC20.25) / STDDEV20.25 > GREATEST(MAX((C23 - AVGC20.23) / STDDEV20.23, 2), MAX((C26 - AVGC20.26) / STDDEV20.26, 2)), (C25 - AVGC20.25) / STDDEV20.25, IIF((C26 - AVGC20.26) / STDDEV20.26 > GREATEST(MAX((C24 - AVGC20.24) / STDDEV20.24, 2), MAX((C27 - AVGC20.27) / STDDEV20.27, 2)), (C26 - AVGC20.26) / STDDEV20.26, IIF((C27 - AVGC20.27) / STDDEV20.27 > GREATEST(MAX((C25 - AVGC20.25) / STDDEV20.25, 2), MAX((C28 - AVGC20.28) / STDDEV20.28, 2)), (C27 - AVGC20.27) / STDDEV20.27, IIF((C28 - AVGC20.28) / STDDEV20.28 > GREATEST(MAX((C26 - AVGC20.26) / STDDEV20.26, 2), MAX((C29 - AVGC20.29) / STDDEV20.29, 2)), (C28 - AVGC20.28) / STDDEV20.28, IIF((C29 - AVGC20.29) / STDDEV20.29 > GREATEST(MAX((C27 - AVGC20.27) / STDDEV20.27, 2), MAX((C30 - AVGC20.30) / STDDEV20.30, 2)), (C29 - AVGC20.29) / STDDEV20.29, IIF((C30 - AVGC20.30) / STDDEV20.30 > GREATEST(MAX((C28 - AVGC20.28) / STDDEV20.28, 2), MAX((C31 - AVGC20.31) / STDDEV20.31, 2)), (C30 - AVGC20.30) / STDDEV20.30, IIF((C31 - AVGC20.31) / STDDEV20.31 > GREATEST(MAX((C29 - AVGC20.29) / STDDEV20.29, 2), MAX((C32 - AVGC20.32) / STDDEV20.32, 2)), (C31 - AVGC20.31) / STDDEV20.31, IIF((C32 - AVGC20.32) / STDDEV20.32 > GREATEST(MAX((C30 - AVGC20.30) / STDDEV20.30, 2), MAX((C33 - AVGC20.33) / STDDEV20.33, 2)), (C32 - AVGC20.32) / STDDEV20.32, IIF((C33 - AVGC20.33) / STDDEV20.33 > GREATEST(MAX((C31 - AVGC20.31) / STDDEV20.31, 2), MAX((C34 - AVGC20.34) / STDDEV20.34, 2)), (C33 - AVGC20.33) / STDDEV20.33, IIF((C34 - AVGC20.34) / STDDEV20.34 > GREATEST(MAX((C32 - AVGC20.32) / STDDEV20.32, 2), MAX((C35 - AVGC20.35) / STDDEV20.35, 2)), (C34 - AVGC20.34) / STDDEV20.34, IIF((C35 - AVGC20.35) / STDDEV20.35 > GREATEST(MAX((C33 - AVGC20.33) / STDDEV20.33, 2), MAX((C36 - AVGC20.36) / STDDEV20.36, 2)), (C35 - AVGC20.35) / STDDEV20.35, IIF((C36 - AVGC20.36) / STDDEV20.36 > GREATEST(MAX((C34 - AVGC20.34) / STDDEV20.34, 2), MAX((C37 - AVGC20.37) / STDDEV20.37, 2)), (C36 - AVGC20.36) / STDDEV20.36, IIF((C37 - AVGC20.37) / STDDEV20.37 > GREATEST(MAX((C35 - AVGC20.35) / STDDEV20.35, 2), MAX((C38 - AVGC20.38) / STDDEV20.38, 2)), (C37 - AVGC20.37) / STDDEV20.37, IIF((C38 - AVGC20.38) / STDDEV20.38 > GREATEST(MAX((C36 - AVGC20.36) / STDDEV20.36, 2), MAX((C39 - AVGC20.39) / STDDEV20.39, 2)), (C38 - AVGC20.38) / STDDEV20.38, IIF((C39 - AVGC20.39) / STDDEV20.39 > GREATEST(MAX((C37 - AVGC20.37) / STDDEV20.37, 2), MAX((C40 - AVGC20.40) / STDDEV20.40, 2)), (C39 - AVGC20.39) / STDDEV20.39, (C2 - AVGC20.2) / STDDEV20.2 - 1))))))))))))))))))))))))))))))))))), (C2 - AVGC20.2) / 4 / STDDEV20.2 + .5, 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, February 13, 2019 1:50:08 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce I m not on my computer today , just traveling for a day, so once you upload all 4 fractal pcf&rsquo;s will  check later in evening and update you tomorrow 

thanks again 

Bruce_L
Posted : Wednesday, February 13, 2019 2:48:32 PM


Worden Trainer

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

The higher high should involve changing one > sign to a < sign and one - operator to a + operator.

IIF((C2 - AVGC20.2) / STDDEV20.2 > GREATEST(MAX((C0 - AVGC20.0) / STDDEV20.0, 2), MAX((C3 - AVGC20.3) / STDDEV20.3, 2)) AND (C2 - AVGC20.2) / STDDEV20.2 > IIF((C5 - AVGC20.5) / STDDEV20.5 > GREATEST(MAX((C3 - AVGC20.3) / STDDEV20.3, 2), MAX((C6 - AVGC20.6) / STDDEV20.6, 2)), (C5 - AVGC20.5) / STDDEV20.5, IIF((C6 - AVGC20.6) / STDDEV20.6 > GREATEST(MAX((C4 - AVGC20.4) / STDDEV20.4, 2), MAX((C7 - AVGC20.7) / STDDEV20.7, 2)), (C6 - AVGC20.6) / STDDEV20.6, IIF((C7 - AVGC20.7) / STDDEV20.7 > GREATEST(MAX((C5 - AVGC20.5) / STDDEV20.5, 2), MAX((C8 - AVGC20.8) / STDDEV20.8, 2)), (C7 - AVGC20.7) / STDDEV20.7, IIF((C8 - AVGC20.8) / STDDEV20.8 > GREATEST(MAX((C6 - AVGC20.6) / STDDEV20.6, 2), MAX((C9 - AVGC20.9) / STDDEV20.9, 2)), (C8 - AVGC20.8) / STDDEV20.8, IIF((C9 - AVGC20.9) / STDDEV20.9 > GREATEST(MAX((C7 - AVGC20.7) / STDDEV20.7, 2), MAX((C10 - AVGC20.10) / STDDEV20.10, 2)), (C9 - AVGC20.9) / STDDEV20.9, IIF((C10 - AVGC20.10) / STDDEV20.10 > GREATEST(MAX((C8 - AVGC20.8) / STDDEV20.8, 2), MAX((C11 - AVGC20.11) / STDDEV20.11, 2)), (C10 - AVGC20.10) / STDDEV20.10, IIF((C11 - AVGC20.11) / STDDEV20.11 > GREATEST(MAX((C9 - AVGC20.9) / STDDEV20.9, 2), MAX((C12 - AVGC20.12) / STDDEV20.12, 2)), (C11 - AVGC20.11) / STDDEV20.11, IIF((C12 - AVGC20.12) / STDDEV20.12 > GREATEST(MAX((C10 - AVGC20.10) / STDDEV20.10, 2), MAX((C13 - AVGC20.13) / STDDEV20.13, 2)), (C12 - AVGC20.12) / STDDEV20.12, IIF((C13 - AVGC20.13) / STDDEV20.13 > GREATEST(MAX((C11 - AVGC20.11) / STDDEV20.11, 2), MAX((C14 - AVGC20.14) / STDDEV20.14, 2)), (C13 - AVGC20.13) / STDDEV20.13, IIF((C14 - AVGC20.14) / STDDEV20.14 > GREATEST(MAX((C12 - AVGC20.12) / STDDEV20.12, 2), MAX((C15 - AVGC20.15) / STDDEV20.15, 2)), (C14 - AVGC20.14) / STDDEV20.14, IIF((C15 - AVGC20.15) / STDDEV20.15 > GREATEST(MAX((C13 - AVGC20.13) / STDDEV20.13, 2), MAX((C16 - AVGC20.16) / STDDEV20.16, 2)), (C15 - AVGC20.15) / STDDEV20.15, IIF((C16 - AVGC20.16) / STDDEV20.16 > GREATEST(MAX((C14 - AVGC20.14) / STDDEV20.14, 2), MAX((C17 - AVGC20.17) / STDDEV20.17, 2)), (C16 - AVGC20.16) / STDDEV20.16, IIF((C17 - AVGC20.17) / STDDEV20.17 > GREATEST(MAX((C15 - AVGC20.15) / STDDEV20.15, 2), MAX((C18 - AVGC20.18) / STDDEV20.18, 2)), (C17 - AVGC20.17) / STDDEV20.17, IIF((C18 - AVGC20.18) / STDDEV20.18 > GREATEST(MAX((C16 - AVGC20.16) / STDDEV20.16, 2), MAX((C19 - AVGC20.19) / STDDEV20.19, 2)), (C18 - AVGC20.18) / STDDEV20.18, IIF((C19 - AVGC20.19) / STDDEV20.19 > GREATEST(MAX((C17 - AVGC20.17) / STDDEV20.17, 2), MAX((C20 - AVGC20.20) / STDDEV20.20, 2)), (C19 - AVGC20.19) / STDDEV20.19, IIF((C20 - AVGC20.20) / STDDEV20.20 > GREATEST(MAX((C18 - AVGC20.18) / STDDEV20.18, 2), MAX((C21 - AVGC20.21) / STDDEV20.21, 2)), (C20 - AVGC20.20) / STDDEV20.20, IIF((C21 - AVGC20.21) / STDDEV20.21 > GREATEST(MAX((C19 - AVGC20.19) / STDDEV20.19, 2), MAX((C22 - AVGC20.22) / STDDEV20.22, 2)), (C21 - AVGC20.21) / STDDEV20.21, IIF((C22 - AVGC20.22) / STDDEV20.22 > GREATEST(MAX((C20 - AVGC20.20) / STDDEV20.20, 2), MAX((C23 - AVGC20.23) / STDDEV20.23, 2)), (C22 - AVGC20.22) / STDDEV20.22, IIF((C23 - AVGC20.23) / STDDEV20.23 > GREATEST(MAX((C21 - AVGC20.21) / STDDEV20.21, 2), MAX((C24 - AVGC20.24) / STDDEV20.24, 2)), (C23 - AVGC20.23) / STDDEV20.23, IIF((C24 - AVGC20.24) / STDDEV20.24 > GREATEST(MAX((C22 - AVGC20.22) / STDDEV20.22, 2), MAX((C25 - AVGC20.25) / STDDEV20.25, 2)), (C24 - AVGC20.24) / STDDEV20.24, IIF((C25 - AVGC20.25) / STDDEV20.25 > GREATEST(MAX((C23 - AVGC20.23) / STDDEV20.23, 2), MAX((C26 - AVGC20.26) / STDDEV20.26, 2)), (C25 - AVGC20.25) / STDDEV20.25, IIF((C26 - AVGC20.26) / STDDEV20.26 > GREATEST(MAX((C24 - AVGC20.24) / STDDEV20.24, 2), MAX((C27 - AVGC20.27) / STDDEV20.27, 2)), (C26 - AVGC20.26) / STDDEV20.26, IIF((C27 - AVGC20.27) / STDDEV20.27 > GREATEST(MAX((C25 - AVGC20.25) / STDDEV20.25, 2), MAX((C28 - AVGC20.28) / STDDEV20.28, 2)), (C27 - AVGC20.27) / STDDEV20.27, IIF((C28 - AVGC20.28) / STDDEV20.28 > GREATEST(MAX((C26 - AVGC20.26) / STDDEV20.26, 2), MAX((C29 - AVGC20.29) / STDDEV20.29, 2)), (C28 - AVGC20.28) / STDDEV20.28, IIF((C29 - AVGC20.29) / STDDEV20.29 > GREATEST(MAX((C27 - AVGC20.27) / STDDEV20.27, 2), MAX((C30 - AVGC20.30) / STDDEV20.30, 2)), (C29 - AVGC20.29) / STDDEV20.29, IIF((C30 - AVGC20.30) / STDDEV20.30 > GREATEST(MAX((C28 - AVGC20.28) / STDDEV20.28, 2), MAX((C31 - AVGC20.31) / STDDEV20.31, 2)), (C30 - AVGC20.30) / STDDEV20.30, IIF((C31 - AVGC20.31) / STDDEV20.31 > GREATEST(MAX((C29 - AVGC20.29) / STDDEV20.29, 2), MAX((C32 - AVGC20.32) / STDDEV20.32, 2)), (C31 - AVGC20.31) / STDDEV20.31, IIF((C32 - AVGC20.32) / STDDEV20.32 > GREATEST(MAX((C30 - AVGC20.30) / STDDEV20.30, 2), MAX((C33 - AVGC20.33) / STDDEV20.33, 2)), (C32 - AVGC20.32) / STDDEV20.32, IIF((C33 - AVGC20.33) / STDDEV20.33 > GREATEST(MAX((C31 - AVGC20.31) / STDDEV20.31, 2), MAX((C34 - AVGC20.34) / STDDEV20.34, 2)), (C33 - AVGC20.33) / STDDEV20.33, IIF((C34 - AVGC20.34) / STDDEV20.34 > GREATEST(MAX((C32 - AVGC20.32) / STDDEV20.32, 2), MAX((C35 - AVGC20.35) / STDDEV20.35, 2)), (C34 - AVGC20.34) / STDDEV20.34, IIF((C35 - AVGC20.35) / STDDEV20.35 > GREATEST(MAX((C33 - AVGC20.33) / STDDEV20.33, 2), MAX((C36 - AVGC20.36) / STDDEV20.36, 2)), (C35 - AVGC20.35) / STDDEV20.35, IIF((C36 - AVGC20.36) / STDDEV20.36 > GREATEST(MAX((C34 - AVGC20.34) / STDDEV20.34, 2), MAX((C37 - AVGC20.37) / STDDEV20.37, 2)), (C36 - AVGC20.36) / STDDEV20.36, IIF((C37 - AVGC20.37) / STDDEV20.37 > GREATEST(MAX((C35 - AVGC20.35) / STDDEV20.35, 2), MAX((C38 - AVGC20.38) / STDDEV20.38, 2)), (C37 - AVGC20.37) / STDDEV20.37, IIF((C38 - AVGC20.38) / STDDEV20.38 > GREATEST(MAX((C36 - AVGC20.36) / STDDEV20.36, 2), MAX((C39 - AVGC20.39) / STDDEV20.39, 2)), (C38 - AVGC20.38) / STDDEV20.38, IIF((C39 - AVGC20.39) / STDDEV20.39 > GREATEST(MAX((C37 - AVGC20.37) / STDDEV20.37, 2), MAX((C40 - AVGC20.40) / STDDEV20.40, 2)), (C39 - AVGC20.39) / STDDEV20.39, (C2 - AVGC20.2) / STDDEV20.2 + 1))))))))))))))))))))))))))))))))))), (C2 - AVGC20.2) / 4 / STDDEV20.2 + .5, 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Bruce_L
Posted : Wednesday, February 13, 2019 2:57:10 PM


Worden Trainer

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

Lover Low should be the first formula with > GREASTEST replaced by < LEAST and MAX replaced by MIN.

IIF((C2 - AVGC20.2) / STDDEV20.2 < LEAST(MIN((C0 - AVGC20.0) / STDDEV20.0, 2), MIN((C3 - AVGC20.3) / STDDEV20.3, 2)) AND (C2 - AVGC20.2) / STDDEV20.2 < IIF((C5 - AVGC20.5) / STDDEV20.5 < LEAST(MIN((C3 - AVGC20.3) / STDDEV20.3, 2), MIN((C6 - AVGC20.6) / STDDEV20.6, 2)), (C5 - AVGC20.5) / STDDEV20.5, IIF((C6 - AVGC20.6) / STDDEV20.6 < LEAST(MIN((C4 - AVGC20.4) / STDDEV20.4, 2), MIN((C7 - AVGC20.7) / STDDEV20.7, 2)), (C6 - AVGC20.6) / STDDEV20.6, IIF((C7 - AVGC20.7) / STDDEV20.7 < LEAST(MIN((C5 - AVGC20.5) / STDDEV20.5, 2), MIN((C8 - AVGC20.8) / STDDEV20.8, 2)), (C7 - AVGC20.7) / STDDEV20.7, IIF((C8 - AVGC20.8) / STDDEV20.8 < LEAST(MIN((C6 - AVGC20.6) / STDDEV20.6, 2), MIN((C9 - AVGC20.9) / STDDEV20.9, 2)), (C8 - AVGC20.8) / STDDEV20.8, IIF((C9 - AVGC20.9) / STDDEV20.9 < LEAST(MIN((C7 - AVGC20.7) / STDDEV20.7, 2), MIN((C10 - AVGC20.10) / STDDEV20.10, 2)), (C9 - AVGC20.9) / STDDEV20.9, IIF((C10 - AVGC20.10) / STDDEV20.10 < LEAST(MIN((C8 - AVGC20.8) / STDDEV20.8, 2), MIN((C11 - AVGC20.11) / STDDEV20.11, 2)), (C10 - AVGC20.10) / STDDEV20.10, IIF((C11 - AVGC20.11) / STDDEV20.11 < LEAST(MIN((C9 - AVGC20.9) / STDDEV20.9, 2), MIN((C12 - AVGC20.12) / STDDEV20.12, 2)), (C11 - AVGC20.11) / STDDEV20.11, IIF((C12 - AVGC20.12) / STDDEV20.12 < LEAST(MIN((C10 - AVGC20.10) / STDDEV20.10, 2), MIN((C13 - AVGC20.13) / STDDEV20.13, 2)), (C12 - AVGC20.12) / STDDEV20.12, IIF((C13 - AVGC20.13) / STDDEV20.13 < LEAST(MIN((C11 - AVGC20.11) / STDDEV20.11, 2), MIN((C14 - AVGC20.14) / STDDEV20.14, 2)), (C13 - AVGC20.13) / STDDEV20.13, IIF((C14 - AVGC20.14) / STDDEV20.14 < LEAST(MIN((C12 - AVGC20.12) / STDDEV20.12, 2), MIN((C15 - AVGC20.15) / STDDEV20.15, 2)), (C14 - AVGC20.14) / STDDEV20.14, IIF((C15 - AVGC20.15) / STDDEV20.15 < LEAST(MIN((C13 - AVGC20.13) / STDDEV20.13, 2), MIN((C16 - AVGC20.16) / STDDEV20.16, 2)), (C15 - AVGC20.15) / STDDEV20.15, IIF((C16 - AVGC20.16) / STDDEV20.16 < LEAST(MIN((C14 - AVGC20.14) / STDDEV20.14, 2), MIN((C17 - AVGC20.17) / STDDEV20.17, 2)), (C16 - AVGC20.16) / STDDEV20.16, IIF((C17 - AVGC20.17) / STDDEV20.17 < LEAST(MIN((C15 - AVGC20.15) / STDDEV20.15, 2), MIN((C18 - AVGC20.18) / STDDEV20.18, 2)), (C17 - AVGC20.17) / STDDEV20.17, IIF((C18 - AVGC20.18) / STDDEV20.18 < LEAST(MIN((C16 - AVGC20.16) / STDDEV20.16, 2), MIN((C19 - AVGC20.19) / STDDEV20.19, 2)), (C18 - AVGC20.18) / STDDEV20.18, IIF((C19 - AVGC20.19) / STDDEV20.19 < LEAST(MIN((C17 - AVGC20.17) / STDDEV20.17, 2), MIN((C20 - AVGC20.20) / STDDEV20.20, 2)), (C19 - AVGC20.19) / STDDEV20.19, IIF((C20 - AVGC20.20) / STDDEV20.20 < LEAST(MIN((C18 - AVGC20.18) / STDDEV20.18, 2), MIN((C21 - AVGC20.21) / STDDEV20.21, 2)), (C20 - AVGC20.20) / STDDEV20.20, IIF((C21 - AVGC20.21) / STDDEV20.21 < LEAST(MIN((C19 - AVGC20.19) / STDDEV20.19, 2), MIN((C22 - AVGC20.22) / STDDEV20.22, 2)), (C21 - AVGC20.21) / STDDEV20.21, IIF((C22 - AVGC20.22) / STDDEV20.22 < LEAST(MIN((C20 - AVGC20.20) / STDDEV20.20, 2), MIN((C23 - AVGC20.23) / STDDEV20.23, 2)), (C22 - AVGC20.22) / STDDEV20.22, IIF((C23 - AVGC20.23) / STDDEV20.23 < LEAST(MIN((C21 - AVGC20.21) / STDDEV20.21, 2), MIN((C24 - AVGC20.24) / STDDEV20.24, 2)), (C23 - AVGC20.23) / STDDEV20.23, IIF((C24 - AVGC20.24) / STDDEV20.24 < LEAST(MIN((C22 - AVGC20.22) / STDDEV20.22, 2), MIN((C25 - AVGC20.25) / STDDEV20.25, 2)), (C24 - AVGC20.24) / STDDEV20.24, IIF((C25 - AVGC20.25) / STDDEV20.25 < LEAST(MIN((C23 - AVGC20.23) / STDDEV20.23, 2), MIN((C26 - AVGC20.26) / STDDEV20.26, 2)), (C25 - AVGC20.25) / STDDEV20.25, IIF((C26 - AVGC20.26) / STDDEV20.26 < LEAST(MIN((C24 - AVGC20.24) / STDDEV20.24, 2), MIN((C27 - AVGC20.27) / STDDEV20.27, 2)), (C26 - AVGC20.26) / STDDEV20.26, IIF((C27 - AVGC20.27) / STDDEV20.27 < LEAST(MIN((C25 - AVGC20.25) / STDDEV20.25, 2), MIN((C28 - AVGC20.28) / STDDEV20.28, 2)), (C27 - AVGC20.27) / STDDEV20.27, IIF((C28 - AVGC20.28) / STDDEV20.28 < LEAST(MIN((C26 - AVGC20.26) / STDDEV20.26, 2), MIN((C29 - AVGC20.29) / STDDEV20.29, 2)), (C28 - AVGC20.28) / STDDEV20.28, IIF((C29 - AVGC20.29) / STDDEV20.29 < LEAST(MIN((C27 - AVGC20.27) / STDDEV20.27, 2), MIN((C30 - AVGC20.30) / STDDEV20.30, 2)), (C29 - AVGC20.29) / STDDEV20.29, IIF((C30 - AVGC20.30) / STDDEV20.30 < LEAST(MIN((C28 - AVGC20.28) / STDDEV20.28, 2), MIN((C31 - AVGC20.31) / STDDEV20.31, 2)), (C30 - AVGC20.30) / STDDEV20.30, IIF((C31 - AVGC20.31) / STDDEV20.31 < LEAST(MIN((C29 - AVGC20.29) / STDDEV20.29, 2), MIN((C32 - AVGC20.32) / STDDEV20.32, 2)), (C31 - AVGC20.31) / STDDEV20.31, IIF((C32 - AVGC20.32) / STDDEV20.32 < LEAST(MIN((C30 - AVGC20.30) / STDDEV20.30, 2), MIN((C33 - AVGC20.33) / STDDEV20.33, 2)), (C32 - AVGC20.32) / STDDEV20.32, IIF((C33 - AVGC20.33) / STDDEV20.33 < LEAST(MIN((C31 - AVGC20.31) / STDDEV20.31, 2), MIN((C34 - AVGC20.34) / STDDEV20.34, 2)), (C33 - AVGC20.33) / STDDEV20.33, IIF((C34 - AVGC20.34) / STDDEV20.34 < LEAST(MIN((C32 - AVGC20.32) / STDDEV20.32, 2), MIN((C35 - AVGC20.35) / STDDEV20.35, 2)), (C34 - AVGC20.34) / STDDEV20.34, IIF((C35 - AVGC20.35) / STDDEV20.35 < LEAST(MIN((C33 - AVGC20.33) / STDDEV20.33, 2), MIN((C36 - AVGC20.36) / STDDEV20.36, 2)), (C35 - AVGC20.35) / STDDEV20.35, IIF((C36 - AVGC20.36) / STDDEV20.36 < LEAST(MIN((C34 - AVGC20.34) / STDDEV20.34, 2), MIN((C37 - AVGC20.37) / STDDEV20.37, 2)), (C36 - AVGC20.36) / STDDEV20.36, IIF((C37 - AVGC20.37) / STDDEV20.37 < LEAST(MIN((C35 - AVGC20.35) / STDDEV20.35, 2), MIN((C38 - AVGC20.38) / STDDEV20.38, 2)), (C37 - AVGC20.37) / STDDEV20.37, IIF((C38 - AVGC20.38) / STDDEV20.38 < LEAST(MIN((C36 - AVGC20.36) / STDDEV20.36, 2), MIN((C39 - AVGC20.39) / STDDEV20.39, 2)), (C38 - AVGC20.38) / STDDEV20.38, IIF((C39 - AVGC20.39) / STDDEV20.39 < LEAST(MIN((C37 - AVGC20.37) / STDDEV20.37, 2), MIN((C40 - AVGC20.40) / STDDEV20.40, 2)), (C39 - AVGC20.39) / STDDEV20.39, (C2 - AVGC20.2) / STDDEV20.2 - 1))))))))))))))))))))))))))))))))))), (C2 - AVGC20.2) / 4 / STDDEV20.2 + .5, 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Bruce_L
Posted : Wednesday, February 13, 2019 3:00:36 PM


Worden Trainer

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

The same is true of converting the higher high to a higher low.

IIF((C2 - AVGC20.2) / STDDEV20.2 < LEAST(MIN((C0 - AVGC20.0) / STDDEV20.0, 2), MIN((C3 - AVGC20.3) / STDDEV20.3, 2)) AND (C2 - AVGC20.2) / STDDEV20.2 > IIF((C5 - AVGC20.5) / STDDEV20.5 < LEAST(MIN((C3 - AVGC20.3) / STDDEV20.3, 2), MIN((C6 - AVGC20.6) / STDDEV20.6, 2)), (C5 - AVGC20.5) / STDDEV20.5, IIF((C6 - AVGC20.6) / STDDEV20.6 < LEAST(MIN((C4 - AVGC20.4) / STDDEV20.4, 2), MIN((C7 - AVGC20.7) / STDDEV20.7, 2)), (C6 - AVGC20.6) / STDDEV20.6, IIF((C7 - AVGC20.7) / STDDEV20.7 < LEAST(MIN((C5 - AVGC20.5) / STDDEV20.5, 2), MIN((C8 - AVGC20.8) / STDDEV20.8, 2)), (C7 - AVGC20.7) / STDDEV20.7, IIF((C8 - AVGC20.8) / STDDEV20.8 < LEAST(MIN((C6 - AVGC20.6) / STDDEV20.6, 2), MIN((C9 - AVGC20.9) / STDDEV20.9, 2)), (C8 - AVGC20.8) / STDDEV20.8, IIF((C9 - AVGC20.9) / STDDEV20.9 < LEAST(MIN((C7 - AVGC20.7) / STDDEV20.7, 2), MIN((C10 - AVGC20.10) / STDDEV20.10, 2)), (C9 - AVGC20.9) / STDDEV20.9, IIF((C10 - AVGC20.10) / STDDEV20.10 < LEAST(MIN((C8 - AVGC20.8) / STDDEV20.8, 2), MIN((C11 - AVGC20.11) / STDDEV20.11, 2)), (C10 - AVGC20.10) / STDDEV20.10, IIF((C11 - AVGC20.11) / STDDEV20.11 < LEAST(MIN((C9 - AVGC20.9) / STDDEV20.9, 2), MIN((C12 - AVGC20.12) / STDDEV20.12, 2)), (C11 - AVGC20.11) / STDDEV20.11, IIF((C12 - AVGC20.12) / STDDEV20.12 < LEAST(MIN((C10 - AVGC20.10) / STDDEV20.10, 2), MIN((C13 - AVGC20.13) / STDDEV20.13, 2)), (C12 - AVGC20.12) / STDDEV20.12, IIF((C13 - AVGC20.13) / STDDEV20.13 < LEAST(MIN((C11 - AVGC20.11) / STDDEV20.11, 2), MIN((C14 - AVGC20.14) / STDDEV20.14, 2)), (C13 - AVGC20.13) / STDDEV20.13, IIF((C14 - AVGC20.14) / STDDEV20.14 < LEAST(MIN((C12 - AVGC20.12) / STDDEV20.12, 2), MIN((C15 - AVGC20.15) / STDDEV20.15, 2)), (C14 - AVGC20.14) / STDDEV20.14, IIF((C15 - AVGC20.15) / STDDEV20.15 < LEAST(MIN((C13 - AVGC20.13) / STDDEV20.13, 2), MIN((C16 - AVGC20.16) / STDDEV20.16, 2)), (C15 - AVGC20.15) / STDDEV20.15, IIF((C16 - AVGC20.16) / STDDEV20.16 < LEAST(MIN((C14 - AVGC20.14) / STDDEV20.14, 2), MIN((C17 - AVGC20.17) / STDDEV20.17, 2)), (C16 - AVGC20.16) / STDDEV20.16, IIF((C17 - AVGC20.17) / STDDEV20.17 < LEAST(MIN((C15 - AVGC20.15) / STDDEV20.15, 2), MIN((C18 - AVGC20.18) / STDDEV20.18, 2)), (C17 - AVGC20.17) / STDDEV20.17, IIF((C18 - AVGC20.18) / STDDEV20.18 < LEAST(MIN((C16 - AVGC20.16) / STDDEV20.16, 2), MIN((C19 - AVGC20.19) / STDDEV20.19, 2)), (C18 - AVGC20.18) / STDDEV20.18, IIF((C19 - AVGC20.19) / STDDEV20.19 < LEAST(MIN((C17 - AVGC20.17) / STDDEV20.17, 2), MIN((C20 - AVGC20.20) / STDDEV20.20, 2)), (C19 - AVGC20.19) / STDDEV20.19, IIF((C20 - AVGC20.20) / STDDEV20.20 < LEAST(MIN((C18 - AVGC20.18) / STDDEV20.18, 2), MIN((C21 - AVGC20.21) / STDDEV20.21, 2)), (C20 - AVGC20.20) / STDDEV20.20, IIF((C21 - AVGC20.21) / STDDEV20.21 < LEAST(MIN((C19 - AVGC20.19) / STDDEV20.19, 2), MIN((C22 - AVGC20.22) / STDDEV20.22, 2)), (C21 - AVGC20.21) / STDDEV20.21, IIF((C22 - AVGC20.22) / STDDEV20.22 < LEAST(MIN((C20 - AVGC20.20) / STDDEV20.20, 2), MIN((C23 - AVGC20.23) / STDDEV20.23, 2)), (C22 - AVGC20.22) / STDDEV20.22, IIF((C23 - AVGC20.23) / STDDEV20.23 < LEAST(MIN((C21 - AVGC20.21) / STDDEV20.21, 2), MIN((C24 - AVGC20.24) / STDDEV20.24, 2)), (C23 - AVGC20.23) / STDDEV20.23, IIF((C24 - AVGC20.24) / STDDEV20.24 < LEAST(MIN((C22 - AVGC20.22) / STDDEV20.22, 2), MIN((C25 - AVGC20.25) / STDDEV20.25, 2)), (C24 - AVGC20.24) / STDDEV20.24, IIF((C25 - AVGC20.25) / STDDEV20.25 < LEAST(MIN((C23 - AVGC20.23) / STDDEV20.23, 2), MIN((C26 - AVGC20.26) / STDDEV20.26, 2)), (C25 - AVGC20.25) / STDDEV20.25, IIF((C26 - AVGC20.26) / STDDEV20.26 < LEAST(MIN((C24 - AVGC20.24) / STDDEV20.24, 2), MIN((C27 - AVGC20.27) / STDDEV20.27, 2)), (C26 - AVGC20.26) / STDDEV20.26, IIF((C27 - AVGC20.27) / STDDEV20.27 < LEAST(MIN((C25 - AVGC20.25) / STDDEV20.25, 2), MIN((C28 - AVGC20.28) / STDDEV20.28, 2)), (C27 - AVGC20.27) / STDDEV20.27, IIF((C28 - AVGC20.28) / STDDEV20.28 < LEAST(MIN((C26 - AVGC20.26) / STDDEV20.26, 2), MIN((C29 - AVGC20.29) / STDDEV20.29, 2)), (C28 - AVGC20.28) / STDDEV20.28, IIF((C29 - AVGC20.29) / STDDEV20.29 < LEAST(MIN((C27 - AVGC20.27) / STDDEV20.27, 2), MIN((C30 - AVGC20.30) / STDDEV20.30, 2)), (C29 - AVGC20.29) / STDDEV20.29, IIF((C30 - AVGC20.30) / STDDEV20.30 < LEAST(MIN((C28 - AVGC20.28) / STDDEV20.28, 2), MIN((C31 - AVGC20.31) / STDDEV20.31, 2)), (C30 - AVGC20.30) / STDDEV20.30, IIF((C31 - AVGC20.31) / STDDEV20.31 < LEAST(MIN((C29 - AVGC20.29) / STDDEV20.29, 2), MIN((C32 - AVGC20.32) / STDDEV20.32, 2)), (C31 - AVGC20.31) / STDDEV20.31, IIF((C32 - AVGC20.32) / STDDEV20.32 < LEAST(MIN((C30 - AVGC20.30) / STDDEV20.30, 2), MIN((C33 - AVGC20.33) / STDDEV20.33, 2)), (C32 - AVGC20.32) / STDDEV20.32, IIF((C33 - AVGC20.33) / STDDEV20.33 < LEAST(MIN((C31 - AVGC20.31) / STDDEV20.31, 2), MIN((C34 - AVGC20.34) / STDDEV20.34, 2)), (C33 - AVGC20.33) / STDDEV20.33, IIF((C34 - AVGC20.34) / STDDEV20.34 < LEAST(MIN((C32 - AVGC20.32) / STDDEV20.32, 2), MIN((C35 - AVGC20.35) / STDDEV20.35, 2)), (C34 - AVGC20.34) / STDDEV20.34, IIF((C35 - AVGC20.35) / STDDEV20.35 < LEAST(MIN((C33 - AVGC20.33) / STDDEV20.33, 2), MIN((C36 - AVGC20.36) / STDDEV20.36, 2)), (C35 - AVGC20.35) / STDDEV20.35, IIF((C36 - AVGC20.36) / STDDEV20.36 < LEAST(MIN((C34 - AVGC20.34) / STDDEV20.34, 2), MIN((C37 - AVGC20.37) / STDDEV20.37, 2)), (C36 - AVGC20.36) / STDDEV20.36, IIF((C37 - AVGC20.37) / STDDEV20.37 < LEAST(MIN((C35 - AVGC20.35) / STDDEV20.35, 2), MIN((C38 - AVGC20.38) / STDDEV20.38, 2)), (C37 - AVGC20.37) / STDDEV20.37, IIF((C38 - AVGC20.38) / STDDEV20.38 < LEAST(MIN((C36 - AVGC20.36) / STDDEV20.36, 2), MIN((C39 - AVGC20.39) / STDDEV20.39, 2)), (C38 - AVGC20.38) / STDDEV20.38, IIF((C39 - AVGC20.39) / STDDEV20.39 < LEAST(MIN((C37 - AVGC20.37) / STDDEV20.37, 2), MIN((C40 - AVGC20.40) / STDDEV20.40, 2)), (C39 - AVGC20.39) / STDDEV20.39, (C2 - AVGC20.2) / STDDEV20.2 + 1))))))))))))))))))))))))))))))))))), (C2 - AVGC20.2) / 4 / STDDEV20.2 + .5, 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, February 13, 2019 6:35:47 PM
Registered User
Joined: 3/10/2012
Posts: 465

Hi Bruce 

Okay the pcf's are plotting correct but dots are not Snapping on %B line even after offsetting as -2 so is there anything else needs to be adjusted ??

And second question now that we have 4 different PCF so can the fibonacci ratio is possible as output in pcf to find where in ratio terms current %BB is "when a Fib retracement drawn from LOWER LOW to HIGHER HIGH when HH was most recent "

And vice versa where is current %B in ratio "when fib retracment drawn from HH to LL when LL is most recent"

thanks   

 

Bruce_L
Posted : Thursday, February 14, 2019 8:02:04 AM


Worden Trainer

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

See the 1 / 0 at the end? That is so dots don't get plotted when it isn't true. Changing that to a numeric value should do the trick, but I don't know what you want to change it to. Zero maybe?

Nope, still can't do that for all the same reasons as previously with price.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Thursday, February 14, 2019 12:15:12 PM
Registered User
Joined: 3/10/2012
Posts: 465

Ok Bruce so you saying that snapping isn't possible correct ? but my second question getting fib ratio as output possible ?

Bruce_L
Posted : Thursday, February 14, 2019 12:28:53 PM


Worden Trainer

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

Quite the opposite. I provided a solution where you could replace the 1 / 0 with say 0 (or some number) in order to offset the plot. You will just end up with a line of dots at whatever value you choose.

There isn't a way to calculate the fib ratio from the LL to HH when the HH was most recent, because there is no way to determine the most recent past value of the LL in the formula. The same is true when going from HH to LL instead.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Thursday, February 14, 2019 12:53:20 PM
Registered User
Joined: 3/10/2012
Posts: 465

Okay got it Bruce i replaced with -0.5 at the end so %B will rarely reach there

and then for lower line bottom dots i plot Custom pcf again and scale with %B, change the "c" to -0.5 plot style as dots and colour as black as my chart background so that works and hides all lower line dots :) 

thanks again for your help

Bruce_L
Posted : Thursday, February 14, 2019 3:28:05 PM


Worden Trainer

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

Sounds like a great solution.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, March 13, 2019 3:11:41 PM
Registered User
Joined: 3/10/2012
Posts: 465

hi Bruce here i am attaching links to show you few divergence trades with price and bollinger %B 

Can you please compute PCF to  show a dot next to pricelow when the condition met is true 

Please see links below 

https://www.dhirenshah.com/higher-high-in-price-and-lower-high-in-b-bearish-reversal-divergence/

 

https://www.dhirenshah.com/lower-high-in-price-and-higher-high-in-b-bearish-continuation-hidden/

 

https://www.dhirenshah.com/higher-low-in-price-and-lower-low-in-b-bullish-continuation-divergence/

 

https://www.dhirenshah.com/lower-low-in-price-and-higher-low-in-b-bullish-reversal/

 

Bruce_L
Posted : Thursday, March 14, 2019 12:59:39 PM


Worden Trainer

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

Pleaes try the following for a lower high in Bollinger %B and a higher high in price.

IIF((C2 - AVGC20.2) / STDDEV20.2 > GREATEST(MAX((C - AVGC20) / STDDEV20, 2), MAX((C3 - AVGC20.3) / STDDEV20.3, 2)) AND (C2 - AVGC20.2) / STDDEV20.2 < IIF((C5 - AVGC20.5) / STDDEV20.5 > GREATEST(MAX((C3 - AVGC20.3) / STDDEV20.3, 2), MAX((C6 - AVGC20.6) / STDDEV20.6, 2)), IIF(H2 > H5, (C5 - AVGC20.5) / STDDEV20.5, 1 / 0), IIF((C6 - AVGC20.6) / STDDEV20.6 > GREATEST(MAX((C4 - AVGC20.4) / STDDEV20.4, 2), MAX((C7 - AVGC20.7) / STDDEV20.7, 2)), IIF(H2 > H6, (C6 - AVGC20.6) / STDDEV20.6, 1 / 0), IIF((C7 - AVGC20.7) / STDDEV20.7 > GREATEST(MAX((C5 - AVGC20.5) / STDDEV20.5, 2), MAX((C8 - AVGC20.8) / STDDEV20.8, 2)), IIF(H2 > H7, (C7 - AVGC20.7) / STDDEV20.7, 1 / 0), IIF((C8 - AVGC20.8) / STDDEV20.8 > GREATEST(MAX((C6 - AVGC20.6) / STDDEV20.6, 2), MAX((C9 - AVGC20.9) / STDDEV20.9, 2)), IIF(H2 > H8, (C8 - AVGC20.8) / STDDEV20.8, 1 / 0), IIF((C9 - AVGC20.9) / STDDEV20.9 > GREATEST(MAX((C7 - AVGC20.7) / STDDEV20.7, 2), MAX((C10 - AVGC20.10) / STDDEV20.10, 2)), IIF(H2 > H9, (C9 - AVGC20.9) / STDDEV20.9, 1 / 0), IIF((C10 - AVGC20.10) / STDDEV20.10 > GREATEST(MAX((C8 - AVGC20.8) / STDDEV20.8, 2), MAX((C11 - AVGC20.11) / STDDEV20.11, 2)), IIF(H2 > H10, (C10 - AVGC20.10) / STDDEV20.10, 1 / 0), IIF((C11 - AVGC20.11) / STDDEV20.11 > GREATEST(MAX((C9 - AVGC20.9) / STDDEV20.9, 2), MAX((C12 - AVGC20.12) / STDDEV20.12, 2)), IIF(H2 > H11, (C11 - AVGC20.11) / STDDEV20.11, 1 / 0), IIF((C12 - AVGC20.12) / STDDEV20.12 > GREATEST(MAX((C10 - AVGC20.10) / STDDEV20.10, 2), MAX((C13 - AVGC20.13) / STDDEV20.13, 2)), IIF(H2 > H12, (C12 - AVGC20.12) / STDDEV20.12, 1 / 0), IIF((C13 - AVGC20.13) / STDDEV20.13 > GREATEST(MAX((C11 - AVGC20.11) / STDDEV20.11, 2), MAX((C14 - AVGC20.14) / STDDEV20.14, 2)), IIF(H2 > H13, (C13 - AVGC20.13) / STDDEV20.13, 1 / 0), IIF((C14 - AVGC20.14) / STDDEV20.14 > GREATEST(MAX((C12 - AVGC20.12) / STDDEV20.12, 2), MAX((C15 - AVGC20.15) / STDDEV20.15, 2)), IIF(H2 > H14, (C14 - AVGC20.14) / STDDEV20.14, 1 / 0), IIF((C15 - AVGC20.15) / STDDEV20.15 > GREATEST(MAX((C13 - AVGC20.13) / STDDEV20.13, 2), MAX((C16 - AVGC20.16) / STDDEV20.16, 2)), IIF(H2 > H15, (C15 - AVGC20.15) / STDDEV20.15, 1 / 0), IIF((C16 - AVGC20.16) / STDDEV20.16 > GREATEST(MAX((C14 - AVGC20.14) / STDDEV20.14, 2), MAX((C17 - AVGC20.17) / STDDEV20.17, 2)), IIF(H2 > H16, (C16 - AVGC20.16) / STDDEV20.16, 1 / 0), IIF((C17 - AVGC20.17) / STDDEV20.17 > GREATEST(MAX((C15 - AVGC20.15) / STDDEV20.15, 2), MAX((C18 - AVGC20.18) / STDDEV20.18, 2)), IIF(H2 > H17, (C17 - AVGC20.17) / STDDEV20.17, 1 / 0), IIF((C18 - AVGC20.18) / STDDEV20.18 > GREATEST(MAX((C16 - AVGC20.16) / STDDEV20.16, 2), MAX((C19 - AVGC20.19) / STDDEV20.19, 2)), IIF(H2 > H18, (C18 - AVGC20.18) / STDDEV20.18, 1 / 0), IIF((C19 - AVGC20.19) / STDDEV20.19 > GREATEST(MAX((C17 - AVGC20.17) / STDDEV20.17, 2), MAX((C20 - AVGC20.20) / STDDEV20.20, 2)), IIF(H2 > H19, (C19 - AVGC20.19) / STDDEV20.19, 1 / 0), IIF((C20 - AVGC20.20) / STDDEV20.20 > GREATEST(MAX((C18 - AVGC20.18) / STDDEV20.18, 2), MAX((C21 - AVGC20.21) / STDDEV20.21, 2)), IIF(H2 > H20, (C20 - AVGC20.20) / STDDEV20.20, 1 / 0), IIF((C21 - AVGC20.21) / STDDEV20.21 > GREATEST(MAX((C19 - AVGC20.19) / STDDEV20.19, 2), MAX((C22 - AVGC20.22) / STDDEV20.22, 2)), IIF(H2 > H21, (C21 - AVGC20.21) / STDDEV20.21, 1 / 0), IIF((C22 - AVGC20.22) / STDDEV20.22 > GREATEST(MAX((C20 - AVGC20.20) / STDDEV20.20, 2), MAX((C23 - AVGC20.23) / STDDEV20.23, 2)), IIF(H2 > H22, (C22 - AVGC20.22) / STDDEV20.22, 1 / 0), IIF((C23 - AVGC20.23) / STDDEV20.23 > GREATEST(MAX((C21 - AVGC20.21) / STDDEV20.21, 2), MAX((C24 - AVGC20.24) / STDDEV20.24, 2)), IIF(H2 > H23, (C23 - AVGC20.23) / STDDEV20.23, 1 / 0), IIF((C24 - AVGC20.24) / STDDEV20.24 > GREATEST(MAX((C22 - AVGC20.22) / STDDEV20.22, 2), MAX((C25 - AVGC20.25) / STDDEV20.25, 2)), IIF(H2 > H24, (C24 - AVGC20.24) / STDDEV20.24, 1 / 0), IIF((C25 - AVGC20.25) / STDDEV20.25 > GREATEST(MAX((C23 - AVGC20.23) / STDDEV20.23, 2), MAX((C26 - AVGC20.26) / STDDEV20.26, 2)), IIF(H2 > H25, (C25 - AVGC20.25) / STDDEV20.25, 1 / 0), IIF((C26 - AVGC20.26) / STDDEV20.26 > GREATEST(MAX((C24 - AVGC20.24) / STDDEV20.24, 2), MAX((C27 - AVGC20.27) / STDDEV20.27, 2)), IIF(H2 > H26, (C26 - AVGC20.26) / STDDEV20.26, 1 / 0), IIF((C27 - AVGC20.27) / STDDEV20.27 > GREATEST(MAX((C25 - AVGC20.25) / STDDEV20.25, 2), MAX((C28 - AVGC20.28) / STDDEV20.28, 2)), IIF(H2 > H27, (C27 - AVGC20.27) / STDDEV20.27, 1 / 0), IIF((C28 - AVGC20.28) / STDDEV20.28 > GREATEST(MAX((C26 - AVGC20.26) / STDDEV20.26, 2), MAX((C29 - AVGC20.29) / STDDEV20.29, 2)), IIF(H2 > H28, (C28 - AVGC20.28) / STDDEV20.28, 1 / 0), IIF((C29 - AVGC20.29) / STDDEV20.29 > GREATEST(MAX((C27 - AVGC20.27) / STDDEV20.27, 2), MAX((C30 - AVGC20.30) / STDDEV20.30, 2)), IIF(H2 > H29, (C29 - AVGC20.29) / STDDEV20.29, 1 / 0), IIF((C30 - AVGC20.30) / STDDEV20.30 > GREATEST(MAX((C28 - AVGC20.28) / STDDEV20.28, 2), MAX((C31 - AVGC20.31) / STDDEV20.31, 2)), IIF(H2 > H30, (C30 - AVGC20.30) / STDDEV20.30, 1 / 0), IIF((C31 - AVGC20.31) / STDDEV20.31 > GREATEST(MAX((C29 - AVGC20.29) / STDDEV20.29, 2), MAX((C32 - AVGC20.32) / STDDEV20.32, 2)), IIF(H2 > H31, (C31 - AVGC20.31) / STDDEV20.31, 1 / 0), IIF((C32 - AVGC20.32) / STDDEV20.32 > GREATEST(MAX((C30 - AVGC20.30) / STDDEV20.30, 2), MAX((C33 - AVGC20.33) / STDDEV20.33, 2)), IIF(H2 > H32, (C32 - AVGC20.32) / STDDEV20.32, 1 / 0), IIF((C33 - AVGC20.33) / STDDEV20.33 > GREATEST(MAX((C31 - AVGC20.31) / STDDEV20.31, 2), MAX((C34 - AVGC20.34) / STDDEV20.34, 2)), IIF(H2 > H33, (C33 - AVGC20.33) / STDDEV20.33, 1 / 0), IIF((C34 - AVGC20.34) / STDDEV20.34 > GREATEST(MAX((C32 - AVGC20.32) / STDDEV20.32, 2), MAX((C35 - AVGC20.35) / STDDEV20.35, 2)), IIF(H2 > H34, (C34 - AVGC20.34) / STDDEV20.34, 1 / 0), IIF((C35 - AVGC20.35) / STDDEV20.35 > GREATEST(MAX((C33 - AVGC20.33) / STDDEV20.33, 2), MAX((C36 - AVGC20.36) / STDDEV20.36, 2)), IIF(H2 > H35, (C35 - AVGC20.35) / STDDEV20.35, 1 / 0), IIF((C36 - AVGC20.36) / STDDEV20.36 > GREATEST(MAX((C34 - AVGC20.34) / STDDEV20.34, 2), MAX((C37 - AVGC20.37) / STDDEV20.37, 2)), IIF(H2 > H36, (C36 - AVGC20.36) / STDDEV20.36, 1 / 0), IIF((C37 - AVGC20.37) / STDDEV20.37 > GREATEST(MAX((C35 - AVGC20.35) / STDDEV20.35, 2), MAX((C38 - AVGC20.38) / STDDEV20.38, 2)), IIF(H2 > H37, (C37 - AVGC20.37) / STDDEV20.37, 1 / 0), IIF((C38 - AVGC20.38) / STDDEV20.38 > GREATEST(MAX((C36 - AVGC20.36) / STDDEV20.36, 2), MAX((C39 - AVGC20.39) / STDDEV20.39, 2)), IIF(H2 > H38, (C38 - AVGC20.38) / STDDEV20.38, 1 / 0), IIF((C39 - AVGC20.39) / STDDEV20.39 > GREATEST(MAX((C37 - AVGC20.37) / STDDEV20.37, 2), MAX((C40 - AVGC20.40) / STDDEV20.40, 2)), IIF(H2 > H39, (C39 - AVGC20.39) / STDDEV20.39, 1 / 0), 1 / 0))))))))))))))))))))))))))))))))))), H2, 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Bruce_L
Posted : Thursday, March 14, 2019 1:19:13 PM


Worden Trainer

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

Please try the following for a higher high in Bollinger %B and a lower high in price.

IIF((C2 - AVGC20.2) / STDDEV20.2 > GREATEST(MAX((C - AVGC20) / STDDEV20, 2), MAX((C3 - AVGC20.3) / STDDEV20.3, 2)) AND (C2 - AVGC20.2) / STDDEV20.2 > IIF((C5 - AVGC20.5) / STDDEV20.5 > GREATEST(MAX((C3 - AVGC20.3) / STDDEV20.3, 2), MAX((C6 - AVGC20.6) / STDDEV20.6, 2)), IIF(H2 < H5, (C5 - AVGC20.5) / STDDEV20.5, 1 / 0), IIF((C6 - AVGC20.6) / STDDEV20.6 > GREATEST(MAX((C4 - AVGC20.4) / STDDEV20.4, 2), MAX((C7 - AVGC20.7) / STDDEV20.7, 2)), IIF(H2 < H6, (C6 - AVGC20.6) / STDDEV20.6, 1 / 0), IIF((C7 - AVGC20.7) / STDDEV20.7 > GREATEST(MAX((C5 - AVGC20.5) / STDDEV20.5, 2), MAX((C8 - AVGC20.8) / STDDEV20.8, 2)), IIF(H2 < H7, (C7 - AVGC20.7) / STDDEV20.7, 1 / 0), IIF((C8 - AVGC20.8) / STDDEV20.8 > GREATEST(MAX((C6 - AVGC20.6) / STDDEV20.6, 2), MAX((C9 - AVGC20.9) / STDDEV20.9, 2)), IIF(H2 < H8, (C8 - AVGC20.8) / STDDEV20.8, 1 / 0), IIF((C9 - AVGC20.9) / STDDEV20.9 > GREATEST(MAX((C7 - AVGC20.7) / STDDEV20.7, 2), MAX((C10 - AVGC20.10) / STDDEV20.10, 2)), IIF(H2 < H9, (C9 - AVGC20.9) / STDDEV20.9, 1 / 0), IIF((C10 - AVGC20.10) / STDDEV20.10 > GREATEST(MAX((C8 - AVGC20.8) / STDDEV20.8, 2), MAX((C11 - AVGC20.11) / STDDEV20.11, 2)), IIF(H2 < H10, (C10 - AVGC20.10) / STDDEV20.10, 1 / 0), IIF((C11 - AVGC20.11) / STDDEV20.11 > GREATEST(MAX((C9 - AVGC20.9) / STDDEV20.9, 2), MAX((C12 - AVGC20.12) / STDDEV20.12, 2)), IIF(H2 < H11, (C11 - AVGC20.11) / STDDEV20.11, 1 / 0), IIF((C12 - AVGC20.12) / STDDEV20.12 > GREATEST(MAX((C10 - AVGC20.10) / STDDEV20.10, 2), MAX((C13 - AVGC20.13) / STDDEV20.13, 2)), IIF(H2 < H12, (C12 - AVGC20.12) / STDDEV20.12, 1 / 0), IIF((C13 - AVGC20.13) / STDDEV20.13 > GREATEST(MAX((C11 - AVGC20.11) / STDDEV20.11, 2), MAX((C14 - AVGC20.14) / STDDEV20.14, 2)), IIF(H2 < H13, (C13 - AVGC20.13) / STDDEV20.13, 1 / 0), IIF((C14 - AVGC20.14) / STDDEV20.14 > GREATEST(MAX((C12 - AVGC20.12) / STDDEV20.12, 2), MAX((C15 - AVGC20.15) / STDDEV20.15, 2)), IIF(H2 < H14, (C14 - AVGC20.14) / STDDEV20.14, 1 / 0), IIF((C15 - AVGC20.15) / STDDEV20.15 > GREATEST(MAX((C13 - AVGC20.13) / STDDEV20.13, 2), MAX((C16 - AVGC20.16) / STDDEV20.16, 2)), IIF(H2 < H15, (C15 - AVGC20.15) / STDDEV20.15, 1 / 0), IIF((C16 - AVGC20.16) / STDDEV20.16 > GREATEST(MAX((C14 - AVGC20.14) / STDDEV20.14, 2), MAX((C17 - AVGC20.17) / STDDEV20.17, 2)), IIF(H2 < H16, (C16 - AVGC20.16) / STDDEV20.16, 1 / 0), IIF((C17 - AVGC20.17) / STDDEV20.17 > GREATEST(MAX((C15 - AVGC20.15) / STDDEV20.15, 2), MAX((C18 - AVGC20.18) / STDDEV20.18, 2)), IIF(H2 < H17, (C17 - AVGC20.17) / STDDEV20.17, 1 / 0), IIF((C18 - AVGC20.18) / STDDEV20.18 > GREATEST(MAX((C16 - AVGC20.16) / STDDEV20.16, 2), MAX((C19 - AVGC20.19) / STDDEV20.19, 2)), IIF(H2 < H18, (C18 - AVGC20.18) / STDDEV20.18, 1 / 0), IIF((C19 - AVGC20.19) / STDDEV20.19 > GREATEST(MAX((C17 - AVGC20.17) / STDDEV20.17, 2), MAX((C20 - AVGC20.20) / STDDEV20.20, 2)), IIF(H2 < H19, (C19 - AVGC20.19) / STDDEV20.19, 1 / 0), IIF((C20 - AVGC20.20) / STDDEV20.20 > GREATEST(MAX((C18 - AVGC20.18) / STDDEV20.18, 2), MAX((C21 - AVGC20.21) / STDDEV20.21, 2)), IIF(H2 < H20, (C20 - AVGC20.20) / STDDEV20.20, 1 / 0), IIF((C21 - AVGC20.21) / STDDEV20.21 > GREATEST(MAX((C19 - AVGC20.19) / STDDEV20.19, 2), MAX((C22 - AVGC20.22) / STDDEV20.22, 2)), IIF(H2 < H21, (C21 - AVGC20.21) / STDDEV20.21, 1 / 0), IIF((C22 - AVGC20.22) / STDDEV20.22 > GREATEST(MAX((C20 - AVGC20.20) / STDDEV20.20, 2), MAX((C23 - AVGC20.23) / STDDEV20.23, 2)), IIF(H2 < H22, (C22 - AVGC20.22) / STDDEV20.22, 1 / 0), IIF((C23 - AVGC20.23) / STDDEV20.23 > GREATEST(MAX((C21 - AVGC20.21) / STDDEV20.21, 2), MAX((C24 - AVGC20.24) / STDDEV20.24, 2)), IIF(H2 < H23, (C23 - AVGC20.23) / STDDEV20.23, 1 / 0), IIF((C24 - AVGC20.24) / STDDEV20.24 > GREATEST(MAX((C22 - AVGC20.22) / STDDEV20.22, 2), MAX((C25 - AVGC20.25) / STDDEV20.25, 2)), IIF(H2 < H24, (C24 - AVGC20.24) / STDDEV20.24, 1 / 0), IIF((C25 - AVGC20.25) / STDDEV20.25 > GREATEST(MAX((C23 - AVGC20.23) / STDDEV20.23, 2), MAX((C26 - AVGC20.26) / STDDEV20.26, 2)), IIF(H2 < H25, (C25 - AVGC20.25) / STDDEV20.25, 1 / 0), IIF((C26 - AVGC20.26) / STDDEV20.26 > GREATEST(MAX((C24 - AVGC20.24) / STDDEV20.24, 2), MAX((C27 - AVGC20.27) / STDDEV20.27, 2)), IIF(H2 < H26, (C26 - AVGC20.26) / STDDEV20.26, 1 / 0), IIF((C27 - AVGC20.27) / STDDEV20.27 > GREATEST(MAX((C25 - AVGC20.25) / STDDEV20.25, 2), MAX((C28 - AVGC20.28) / STDDEV20.28, 2)), IIF(H2 < H27, (C27 - AVGC20.27) / STDDEV20.27, 1 / 0), IIF((C28 - AVGC20.28) / STDDEV20.28 > GREATEST(MAX((C26 - AVGC20.26) / STDDEV20.26, 2), MAX((C29 - AVGC20.29) / STDDEV20.29, 2)), IIF(H2 < H28, (C28 - AVGC20.28) / STDDEV20.28, 1 / 0), IIF((C29 - AVGC20.29) / STDDEV20.29 > GREATEST(MAX((C27 - AVGC20.27) / STDDEV20.27, 2), MAX((C30 - AVGC20.30) / STDDEV20.30, 2)), IIF(H2 < H29, (C29 - AVGC20.29) / STDDEV20.29, 1 / 0), IIF((C30 - AVGC20.30) / STDDEV20.30 > GREATEST(MAX((C28 - AVGC20.28) / STDDEV20.28, 2), MAX((C31 - AVGC20.31) / STDDEV20.31, 2)), IIF(H2 < H30, (C30 - AVGC20.30) / STDDEV20.30, 1 / 0), IIF((C31 - AVGC20.31) / STDDEV20.31 > GREATEST(MAX((C29 - AVGC20.29) / STDDEV20.29, 2), MAX((C32 - AVGC20.32) / STDDEV20.32, 2)), IIF(H2 < H31, (C31 - AVGC20.31) / STDDEV20.31, 1 / 0), IIF((C32 - AVGC20.32) / STDDEV20.32 > GREATEST(MAX((C30 - AVGC20.30) / STDDEV20.30, 2), MAX((C33 - AVGC20.33) / STDDEV20.33, 2)), IIF(H2 < H32, (C32 - AVGC20.32) / STDDEV20.32, 1 / 0), IIF((C33 - AVGC20.33) / STDDEV20.33 > GREATEST(MAX((C31 - AVGC20.31) / STDDEV20.31, 2), MAX((C34 - AVGC20.34) / STDDEV20.34, 2)), IIF(H2 < H33, (C33 - AVGC20.33) / STDDEV20.33, 1 / 0), IIF((C34 - AVGC20.34) / STDDEV20.34 > GREATEST(MAX((C32 - AVGC20.32) / STDDEV20.32, 2), MAX((C35 - AVGC20.35) / STDDEV20.35, 2)), IIF(H2 < H34, (C34 - AVGC20.34) / STDDEV20.34, 1 / 0), IIF((C35 - AVGC20.35) / STDDEV20.35 > GREATEST(MAX((C33 - AVGC20.33) / STDDEV20.33, 2), MAX((C36 - AVGC20.36) / STDDEV20.36, 2)), IIF(H2 < H35, (C35 - AVGC20.35) / STDDEV20.35, 1 / 0), IIF((C36 - AVGC20.36) / STDDEV20.36 > GREATEST(MAX((C34 - AVGC20.34) / STDDEV20.34, 2), MAX((C37 - AVGC20.37) / STDDEV20.37, 2)), IIF(H2 < H36, (C36 - AVGC20.36) / STDDEV20.36, 1 / 0), IIF((C37 - AVGC20.37) / STDDEV20.37 > GREATEST(MAX((C35 - AVGC20.35) / STDDEV20.35, 2), MAX((C38 - AVGC20.38) / STDDEV20.38, 2)), IIF(H2 < H37, (C37 - AVGC20.37) / STDDEV20.37, 1 / 0), IIF((C38 - AVGC20.38) / STDDEV20.38 > GREATEST(MAX((C36 - AVGC20.36) / STDDEV20.36, 2), MAX((C39 - AVGC20.39) / STDDEV20.39, 2)), IIF(H2 < H38, (C38 - AVGC20.38) / STDDEV20.38, 1 / 0), IIF((C39 - AVGC20.39) / STDDEV20.39 > GREATEST(MAX((C37 - AVGC20.37) / STDDEV20.37, 2), MAX((C40 - AVGC20.40) / STDDEV20.40, 2)), IIF(H2 < H39, (C39 - AVGC20.39) / STDDEV20.39, 1 / 0), 1 / 0))))))))))))))))))))))))))))))))))), H2, 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Bruce_L
Posted : Thursday, March 14, 2019 1:26:03 PM


Worden Trainer

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

Please try the following for a lower low in Bollinger %B and a higher low in price.

IIF((C2 - AVGC20.2) / STDDEV20.2 < LEAST(MIN((C - AVGC20) / STDDEV20, 2), MIN((C3 - AVGC20.3) / STDDEV20.3, 2)) AND (C2 - AVGC20.2) / STDDEV20.2 < IIF((C5 - AVGC20.5) / STDDEV20.5 < LEAST(MIN((C3 - AVGC20.3) / STDDEV20.3, 2), MIN((C6 - AVGC20.6) / STDDEV20.6, 2)), IIF(L2 > L5, (C5 - AVGC20.5) / STDDEV20.5, 1 / 0), IIF((C6 - AVGC20.6) / STDDEV20.6 < LEAST(MIN((C4 - AVGC20.4) / STDDEV20.4, 2), MIN((C7 - AVGC20.7) / STDDEV20.7, 2)), IIF(L2 > L6, (C6 - AVGC20.6) / STDDEV20.6, 1 / 0), IIF((C7 - AVGC20.7) / STDDEV20.7 < LEAST(MIN((C5 - AVGC20.5) / STDDEV20.5, 2), MIN((C8 - AVGC20.8) / STDDEV20.8, 2)), IIF(L2 > L7, (C7 - AVGC20.7) / STDDEV20.7, 1 / 0), IIF((C8 - AVGC20.8) / STDDEV20.8 < LEAST(MIN((C6 - AVGC20.6) / STDDEV20.6, 2), MIN((C9 - AVGC20.9) / STDDEV20.9, 2)), IIF(L2 > L8, (C8 - AVGC20.8) / STDDEV20.8, 1 / 0), IIF((C9 - AVGC20.9) / STDDEV20.9 < LEAST(MIN((C7 - AVGC20.7) / STDDEV20.7, 2), MIN((C10 - AVGC20.10) / STDDEV20.10, 2)), IIF(L2 > L9, (C9 - AVGC20.9) / STDDEV20.9, 1 / 0), IIF((C10 - AVGC20.10) / STDDEV20.10 < LEAST(MIN((C8 - AVGC20.8) / STDDEV20.8, 2), MIN((C11 - AVGC20.11) / STDDEV20.11, 2)), IIF(L2 > L10, (C10 - AVGC20.10) / STDDEV20.10, 1 / 0), IIF((C11 - AVGC20.11) / STDDEV20.11 < LEAST(MIN((C9 - AVGC20.9) / STDDEV20.9, 2), MIN((C12 - AVGC20.12) / STDDEV20.12, 2)), IIF(L2 > L11, (C11 - AVGC20.11) / STDDEV20.11, 1 / 0), IIF((C12 - AVGC20.12) / STDDEV20.12 < LEAST(MIN((C10 - AVGC20.10) / STDDEV20.10, 2), MIN((C13 - AVGC20.13) / STDDEV20.13, 2)), IIF(L2 > L12, (C12 - AVGC20.12) / STDDEV20.12, 1 / 0), IIF((C13 - AVGC20.13) / STDDEV20.13 < LEAST(MIN((C11 - AVGC20.11) / STDDEV20.11, 2), MIN((C14 - AVGC20.14) / STDDEV20.14, 2)), IIF(L2 > L13, (C13 - AVGC20.13) / STDDEV20.13, 1 / 0), IIF((C14 - AVGC20.14) / STDDEV20.14 < LEAST(MIN((C12 - AVGC20.12) / STDDEV20.12, 2), MIN((C15 - AVGC20.15) / STDDEV20.15, 2)), IIF(L2 > L14, (C14 - AVGC20.14) / STDDEV20.14, 1 / 0), IIF((C15 - AVGC20.15) / STDDEV20.15 < LEAST(MIN((C13 - AVGC20.13) / STDDEV20.13, 2), MIN((C16 - AVGC20.16) / STDDEV20.16, 2)), IIF(L2 > L15, (C15 - AVGC20.15) / STDDEV20.15, 1 / 0), IIF((C16 - AVGC20.16) / STDDEV20.16 < LEAST(MIN((C14 - AVGC20.14) / STDDEV20.14, 2), MIN((C17 - AVGC20.17) / STDDEV20.17, 2)), IIF(L2 > L16, (C16 - AVGC20.16) / STDDEV20.16, 1 / 0), IIF((C17 - AVGC20.17) / STDDEV20.17 < LEAST(MIN((C15 - AVGC20.15) / STDDEV20.15, 2), MIN((C18 - AVGC20.18) / STDDEV20.18, 2)), IIF(L2 > L17, (C17 - AVGC20.17) / STDDEV20.17, 1 / 0), IIF((C18 - AVGC20.18) / STDDEV20.18 < LEAST(MIN((C16 - AVGC20.16) / STDDEV20.16, 2), MIN((C19 - AVGC20.19) / STDDEV20.19, 2)), IIF(L2 > L18, (C18 - AVGC20.18) / STDDEV20.18, 1 / 0), IIF((C19 - AVGC20.19) / STDDEV20.19 < LEAST(MIN((C17 - AVGC20.17) / STDDEV20.17, 2), MIN((C20 - AVGC20.20) / STDDEV20.20, 2)), IIF(L2 > L19, (C19 - AVGC20.19) / STDDEV20.19, 1 / 0), IIF((C20 - AVGC20.20) / STDDEV20.20 < LEAST(MIN((C18 - AVGC20.18) / STDDEV20.18, 2), MIN((C21 - AVGC20.21) / STDDEV20.21, 2)), IIF(L2 > L20, (C20 - AVGC20.20) / STDDEV20.20, 1 / 0), IIF((C21 - AVGC20.21) / STDDEV20.21 < LEAST(MIN((C19 - AVGC20.19) / STDDEV20.19, 2), MIN((C22 - AVGC20.22) / STDDEV20.22, 2)), IIF(L2 > L21, (C21 - AVGC20.21) / STDDEV20.21, 1 / 0), IIF((C22 - AVGC20.22) / STDDEV20.22 < LEAST(MIN((C20 - AVGC20.20) / STDDEV20.20, 2), MIN((C23 - AVGC20.23) / STDDEV20.23, 2)), IIF(L2 > L22, (C22 - AVGC20.22) / STDDEV20.22, 1 / 0), IIF((C23 - AVGC20.23) / STDDEV20.23 < LEAST(MIN((C21 - AVGC20.21) / STDDEV20.21, 2), MIN((C24 - AVGC20.24) / STDDEV20.24, 2)), IIF(L2 > L23, (C23 - AVGC20.23) / STDDEV20.23, 1 / 0), IIF((C24 - AVGC20.24) / STDDEV20.24 < LEAST(MIN((C22 - AVGC20.22) / STDDEV20.22, 2), MIN((C25 - AVGC20.25) / STDDEV20.25, 2)), IIF(L2 > L24, (C24 - AVGC20.24) / STDDEV20.24, 1 / 0), IIF((C25 - AVGC20.25) / STDDEV20.25 < LEAST(MIN((C23 - AVGC20.23) / STDDEV20.23, 2), MIN((C26 - AVGC20.26) / STDDEV20.26, 2)), IIF(L2 > L25, (C25 - AVGC20.25) / STDDEV20.25, 1 / 0), IIF((C26 - AVGC20.26) / STDDEV20.26 < LEAST(MIN((C24 - AVGC20.24) / STDDEV20.24, 2), MIN((C27 - AVGC20.27) / STDDEV20.27, 2)), IIF(L2 > L26, (C26 - AVGC20.26) / STDDEV20.26, 1 / 0), IIF((C27 - AVGC20.27) / STDDEV20.27 < LEAST(MIN((C25 - AVGC20.25) / STDDEV20.25, 2), MIN((C28 - AVGC20.28) / STDDEV20.28, 2)), IIF(L2 > L27, (C27 - AVGC20.27) / STDDEV20.27, 1 / 0), IIF((C28 - AVGC20.28) / STDDEV20.28 < LEAST(MIN((C26 - AVGC20.26) / STDDEV20.26, 2), MIN((C29 - AVGC20.29) / STDDEV20.29, 2)), IIF(L2 > L28, (C28 - AVGC20.28) / STDDEV20.28, 1 / 0), IIF((C29 - AVGC20.29) / STDDEV20.29 < LEAST(MIN((C27 - AVGC20.27) / STDDEV20.27, 2), MIN((C30 - AVGC20.30) / STDDEV20.30, 2)), IIF(L2 > L29, (C29 - AVGC20.29) / STDDEV20.29, 1 / 0), IIF((C30 - AVGC20.30) / STDDEV20.30 < LEAST(MIN((C28 - AVGC20.28) / STDDEV20.28, 2), MIN((C31 - AVGC20.31) / STDDEV20.31, 2)), IIF(L2 > L30, (C30 - AVGC20.30) / STDDEV20.30, 1 / 0), IIF((C31 - AVGC20.31) / STDDEV20.31 < LEAST(MIN((C29 - AVGC20.29) / STDDEV20.29, 2), MIN((C32 - AVGC20.32) / STDDEV20.32, 2)), IIF(L2 > L31, (C31 - AVGC20.31) / STDDEV20.31, 1 / 0), IIF((C32 - AVGC20.32) / STDDEV20.32 < LEAST(MIN((C30 - AVGC20.30) / STDDEV20.30, 2), MIN((C33 - AVGC20.33) / STDDEV20.33, 2)), IIF(L2 > L32, (C32 - AVGC20.32) / STDDEV20.32, 1 / 0), IIF((C33 - AVGC20.33) / STDDEV20.33 < LEAST(MIN((C31 - AVGC20.31) / STDDEV20.31, 2), MIN((C34 - AVGC20.34) / STDDEV20.34, 2)), IIF(L2 > L33, (C33 - AVGC20.33) / STDDEV20.33, 1 / 0), IIF((C34 - AVGC20.34) / STDDEV20.34 < LEAST(MIN((C32 - AVGC20.32) / STDDEV20.32, 2), MIN((C35 - AVGC20.35) / STDDEV20.35, 2)), IIF(L2 > L34, (C34 - AVGC20.34) / STDDEV20.34, 1 / 0), IIF((C35 - AVGC20.35) / STDDEV20.35 < LEAST(MIN((C33 - AVGC20.33) / STDDEV20.33, 2), MIN((C36 - AVGC20.36) / STDDEV20.36, 2)), IIF(L2 > L35, (C35 - AVGC20.35) / STDDEV20.35, 1 / 0), IIF((C36 - AVGC20.36) / STDDEV20.36 < LEAST(MIN((C34 - AVGC20.34) / STDDEV20.34, 2), MIN((C37 - AVGC20.37) / STDDEV20.37, 2)), IIF(L2 > L36, (C36 - AVGC20.36) / STDDEV20.36, 1 / 0), IIF((C37 - AVGC20.37) / STDDEV20.37 < LEAST(MIN((C35 - AVGC20.35) / STDDEV20.35, 2), MIN((C38 - AVGC20.38) / STDDEV20.38, 2)), IIF(L2 > L37, (C37 - AVGC20.37) / STDDEV20.37, 1 / 0), IIF((C38 - AVGC20.38) / STDDEV20.38 < LEAST(MIN((C36 - AVGC20.36) / STDDEV20.36, 2), MIN((C39 - AVGC20.39) / STDDEV20.39, 2)), IIF(L2 > L38, (C38 - AVGC20.38) / STDDEV20.38, 1 / 0), IIF((C39 - AVGC20.39) / STDDEV20.39 < LEAST(MIN((C37 - AVGC20.37) / STDDEV20.37, 2), MIN((C40 - AVGC20.40) / STDDEV20.40, 2)), IIF(L2 > L39, (C39 - AVGC20.39) / STDDEV20.39, 1 / 0), 1 / 0))))))))))))))))))))))))))))))))))), L2, 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Bruce_L
Posted : Thursday, March 14, 2019 1:26:58 PM


Worden Trainer

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

Please try the following for a higher low in Bollinger %B and a lower low in price.

IIF((C2 - AVGC20.2) / STDDEV20.2 < LEAST(MIN((C - AVGC20) / STDDEV20, 2), MIN((C3 - AVGC20.3) / STDDEV20.3, 2)) AND (C2 - AVGC20.2) / STDDEV20.2 > IIF((C5 - AVGC20.5) / STDDEV20.5 < LEAST(MIN((C3 - AVGC20.3) / STDDEV20.3, 2), MIN((C6 - AVGC20.6) / STDDEV20.6, 2)), IIF(L2 < L5, (C5 - AVGC20.5) / STDDEV20.5, 1 / 0), IIF((C6 - AVGC20.6) / STDDEV20.6 < LEAST(MIN((C4 - AVGC20.4) / STDDEV20.4, 2), MIN((C7 - AVGC20.7) / STDDEV20.7, 2)), IIF(L2 < L6, (C6 - AVGC20.6) / STDDEV20.6, 1 / 0), IIF((C7 - AVGC20.7) / STDDEV20.7 < LEAST(MIN((C5 - AVGC20.5) / STDDEV20.5, 2), MIN((C8 - AVGC20.8) / STDDEV20.8, 2)), IIF(L2 < L7, (C7 - AVGC20.7) / STDDEV20.7, 1 / 0), IIF((C8 - AVGC20.8) / STDDEV20.8 < LEAST(MIN((C6 - AVGC20.6) / STDDEV20.6, 2), MIN((C9 - AVGC20.9) / STDDEV20.9, 2)), IIF(L2 < L8, (C8 - AVGC20.8) / STDDEV20.8, 1 / 0), IIF((C9 - AVGC20.9) / STDDEV20.9 < LEAST(MIN((C7 - AVGC20.7) / STDDEV20.7, 2), MIN((C10 - AVGC20.10) / STDDEV20.10, 2)), IIF(L2 < L9, (C9 - AVGC20.9) / STDDEV20.9, 1 / 0), IIF((C10 - AVGC20.10) / STDDEV20.10 < LEAST(MIN((C8 - AVGC20.8) / STDDEV20.8, 2), MIN((C11 - AVGC20.11) / STDDEV20.11, 2)), IIF(L2 < L10, (C10 - AVGC20.10) / STDDEV20.10, 1 / 0), IIF((C11 - AVGC20.11) / STDDEV20.11 < LEAST(MIN((C9 - AVGC20.9) / STDDEV20.9, 2), MIN((C12 - AVGC20.12) / STDDEV20.12, 2)), IIF(L2 < L11, (C11 - AVGC20.11) / STDDEV20.11, 1 / 0), IIF((C12 - AVGC20.12) / STDDEV20.12 < LEAST(MIN((C10 - AVGC20.10) / STDDEV20.10, 2), MIN((C13 - AVGC20.13) / STDDEV20.13, 2)), IIF(L2 < L12, (C12 - AVGC20.12) / STDDEV20.12, 1 / 0), IIF((C13 - AVGC20.13) / STDDEV20.13 < LEAST(MIN((C11 - AVGC20.11) / STDDEV20.11, 2), MIN((C14 - AVGC20.14) / STDDEV20.14, 2)), IIF(L2 < L13, (C13 - AVGC20.13) / STDDEV20.13, 1 / 0), IIF((C14 - AVGC20.14) / STDDEV20.14 < LEAST(MIN((C12 - AVGC20.12) / STDDEV20.12, 2), MIN((C15 - AVGC20.15) / STDDEV20.15, 2)), IIF(L2 < L14, (C14 - AVGC20.14) / STDDEV20.14, 1 / 0), IIF((C15 - AVGC20.15) / STDDEV20.15 < LEAST(MIN((C13 - AVGC20.13) / STDDEV20.13, 2), MIN((C16 - AVGC20.16) / STDDEV20.16, 2)), IIF(L2 < L15, (C15 - AVGC20.15) / STDDEV20.15, 1 / 0), IIF((C16 - AVGC20.16) / STDDEV20.16 < LEAST(MIN((C14 - AVGC20.14) / STDDEV20.14, 2), MIN((C17 - AVGC20.17) / STDDEV20.17, 2)), IIF(L2 < L16, (C16 - AVGC20.16) / STDDEV20.16, 1 / 0), IIF((C17 - AVGC20.17) / STDDEV20.17 < LEAST(MIN((C15 - AVGC20.15) / STDDEV20.15, 2), MIN((C18 - AVGC20.18) / STDDEV20.18, 2)), IIF(L2 < L17, (C17 - AVGC20.17) / STDDEV20.17, 1 / 0), IIF((C18 - AVGC20.18) / STDDEV20.18 < LEAST(MIN((C16 - AVGC20.16) / STDDEV20.16, 2), MIN((C19 - AVGC20.19) / STDDEV20.19, 2)), IIF(L2 < L18, (C18 - AVGC20.18) / STDDEV20.18, 1 / 0), IIF((C19 - AVGC20.19) / STDDEV20.19 < LEAST(MIN((C17 - AVGC20.17) / STDDEV20.17, 2), MIN((C20 - AVGC20.20) / STDDEV20.20, 2)), IIF(L2 < L19, (C19 - AVGC20.19) / STDDEV20.19, 1 / 0), IIF((C20 - AVGC20.20) / STDDEV20.20 < LEAST(MIN((C18 - AVGC20.18) / STDDEV20.18, 2), MIN((C21 - AVGC20.21) / STDDEV20.21, 2)), IIF(L2 < L20, (C20 - AVGC20.20) / STDDEV20.20, 1 / 0), IIF((C21 - AVGC20.21) / STDDEV20.21 < LEAST(MIN((C19 - AVGC20.19) / STDDEV20.19, 2), MIN((C22 - AVGC20.22) / STDDEV20.22, 2)), IIF(L2 < L21, (C21 - AVGC20.21) / STDDEV20.21, 1 / 0), IIF((C22 - AVGC20.22) / STDDEV20.22 < LEAST(MIN((C20 - AVGC20.20) / STDDEV20.20, 2), MIN((C23 - AVGC20.23) / STDDEV20.23, 2)), IIF(L2 < L22, (C22 - AVGC20.22) / STDDEV20.22, 1 / 0), IIF((C23 - AVGC20.23) / STDDEV20.23 < LEAST(MIN((C21 - AVGC20.21) / STDDEV20.21, 2), MIN((C24 - AVGC20.24) / STDDEV20.24, 2)), IIF(L2 < L23, (C23 - AVGC20.23) / STDDEV20.23, 1 / 0), IIF((C24 - AVGC20.24) / STDDEV20.24 < LEAST(MIN((C22 - AVGC20.22) / STDDEV20.22, 2), MIN((C25 - AVGC20.25) / STDDEV20.25, 2)), IIF(L2 < L24, (C24 - AVGC20.24) / STDDEV20.24, 1 / 0), IIF((C25 - AVGC20.25) / STDDEV20.25 < LEAST(MIN((C23 - AVGC20.23) / STDDEV20.23, 2), MIN((C26 - AVGC20.26) / STDDEV20.26, 2)), IIF(L2 < L25, (C25 - AVGC20.25) / STDDEV20.25, 1 / 0), IIF((C26 - AVGC20.26) / STDDEV20.26 < LEAST(MIN((C24 - AVGC20.24) / STDDEV20.24, 2), MIN((C27 - AVGC20.27) / STDDEV20.27, 2)), IIF(L2 < L26, (C26 - AVGC20.26) / STDDEV20.26, 1 / 0), IIF((C27 - AVGC20.27) / STDDEV20.27 < LEAST(MIN((C25 - AVGC20.25) / STDDEV20.25, 2), MIN((C28 - AVGC20.28) / STDDEV20.28, 2)), IIF(L2 < L27, (C27 - AVGC20.27) / STDDEV20.27, 1 / 0), IIF((C28 - AVGC20.28) / STDDEV20.28 < LEAST(MIN((C26 - AVGC20.26) / STDDEV20.26, 2), MIN((C29 - AVGC20.29) / STDDEV20.29, 2)), IIF(L2 < L28, (C28 - AVGC20.28) / STDDEV20.28, 1 / 0), IIF((C29 - AVGC20.29) / STDDEV20.29 < LEAST(MIN((C27 - AVGC20.27) / STDDEV20.27, 2), MIN((C30 - AVGC20.30) / STDDEV20.30, 2)), IIF(L2 < L29, (C29 - AVGC20.29) / STDDEV20.29, 1 / 0), IIF((C30 - AVGC20.30) / STDDEV20.30 < LEAST(MIN((C28 - AVGC20.28) / STDDEV20.28, 2), MIN((C31 - AVGC20.31) / STDDEV20.31, 2)), IIF(L2 < L30, (C30 - AVGC20.30) / STDDEV20.30, 1 / 0), IIF((C31 - AVGC20.31) / STDDEV20.31 < LEAST(MIN((C29 - AVGC20.29) / STDDEV20.29, 2), MIN((C32 - AVGC20.32) / STDDEV20.32, 2)), IIF(L2 < L31, (C31 - AVGC20.31) / STDDEV20.31, 1 / 0), IIF((C32 - AVGC20.32) / STDDEV20.32 < LEAST(MIN((C30 - AVGC20.30) / STDDEV20.30, 2), MIN((C33 - AVGC20.33) / STDDEV20.33, 2)), IIF(L2 < L32, (C32 - AVGC20.32) / STDDEV20.32, 1 / 0), IIF((C33 - AVGC20.33) / STDDEV20.33 < LEAST(MIN((C31 - AVGC20.31) / STDDEV20.31, 2), MIN((C34 - AVGC20.34) / STDDEV20.34, 2)), IIF(L2 < L33, (C33 - AVGC20.33) / STDDEV20.33, 1 / 0), IIF((C34 - AVGC20.34) / STDDEV20.34 < LEAST(MIN((C32 - AVGC20.32) / STDDEV20.32, 2), MIN((C35 - AVGC20.35) / STDDEV20.35, 2)), IIF(L2 < L34, (C34 - AVGC20.34) / STDDEV20.34, 1 / 0), IIF((C35 - AVGC20.35) / STDDEV20.35 < LEAST(MIN((C33 - AVGC20.33) / STDDEV20.33, 2), MIN((C36 - AVGC20.36) / STDDEV20.36, 2)), IIF(L2 < L35, (C35 - AVGC20.35) / STDDEV20.35, 1 / 0), IIF((C36 - AVGC20.36) / STDDEV20.36 < LEAST(MIN((C34 - AVGC20.34) / STDDEV20.34, 2), MIN((C37 - AVGC20.37) / STDDEV20.37, 2)), IIF(L2 < L36, (C36 - AVGC20.36) / STDDEV20.36, 1 / 0), IIF((C37 - AVGC20.37) / STDDEV20.37 < LEAST(MIN((C35 - AVGC20.35) / STDDEV20.35, 2), MIN((C38 - AVGC20.38) / STDDEV20.38, 2)), IIF(L2 < L37, (C37 - AVGC20.37) / STDDEV20.37, 1 / 0), IIF((C38 - AVGC20.38) / STDDEV20.38 < LEAST(MIN((C36 - AVGC20.36) / STDDEV20.36, 2), MIN((C39 - AVGC20.39) / STDDEV20.39, 2)), IIF(L2 < L38, (C38 - AVGC20.38) / STDDEV20.38, 1 / 0), IIF((C39 - AVGC20.39) / STDDEV20.39 < LEAST(MIN((C37 - AVGC20.37) / STDDEV20.37, 2), MIN((C40 - AVGC20.40) / STDDEV20.40, 2)), IIF(L2 < L39, (C39 - AVGC20.39) / STDDEV20.39, 1 / 0), 1 / 0))))))))))))))))))))))))))))))))))), L2, 1 / 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Thursday, March 14, 2019 2:27:59 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce all of them work perfect... I cannot thankyou enough brother for taking time to compute... 

cheers :))

Priyaa
Posted : Sunday, March 24, 2019 11:32:36 AM
Registered User
Joined: 1/11/2019
Posts: 28

Hi Dhiren,

I tried adding your pcf's to the chart but they are not aligned to the BB band. I changed the number to -0.5 like you mentioned but I guess I'm doing something wrong. Is it okay for you to TCMail me your pcf chart? I can share what I was doing on my chart. It is okay if it is not possible to share too.'

 

Thanks,

Priya

Priyaa
Posted : Monday, March 25, 2019 9:44:25 AM
Registered User
Joined: 1/11/2019
Posts: 28

Hi Bruce,

I am new to TC2000 and trying to understand as much as I can through the forum posts. I have the following requests for you.

Request1:

I have seen some posts on MACD Divergence but I felt if I can get PCF for MACD and price Divergence just like how you wrote for BB & Price, that would be nice.

Can you please write the PCF for MACD and Price divergence that plot dots on price? If you can add these to a chart and TC Mail me, that would be great.

1) Bullish Reversal

2) Bullish Continuation Divergence

3) Bearish Continuation 

4) Bearish Reversal Divergence

Unfortunately, I'm not a pro like everyone is in the forum and I cannot specify the Higher high, lower low criteria like Dhirenshah provided you. 

 

Request2: Can I please also get a chart on TCMail with what was requested in this post for BB and Price divergence? I tried to add these on my TC2000 but I' no where close to doing it right.

1)Dot plot overlayed as  higher high fractal , Lower high fractal  , Higher low fractal and Lower Low fractal on Bollinger bands %B with 4 different colours 

2) lower high in Bollinger %B and a higher high in price.

 3) higher high in Bollinger %B and a lower high in price.

 4) lower low in Bollinger %B and a higher low in price.

5) higher low in Bollinger %B and a lower low in price.

Please let me know if it is possible.

 

Note: I'm new and only started learning since last two months. I appreciate all the requests people post on the forums and I'm learning a lot from them.

Priyaa
Posted : Thursday, March 28, 2019 10:12:08 AM
Registered User
Joined: 1/11/2019
Posts: 28

Good Morning Bruce,

Whenever you get a chance, can you please help me with the above requests?

 

Regards,

Priya

Bruce_L
Posted : Thursday, March 28, 2019 4:47:34 PM


Worden Trainer

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

I have sent you a my implementation Request2 via TCMail.

Request1 is may or may not be possible (and I have not personally been impressed by any MACD divergence formula of this type so far), but let me ask some questions.

Is this for a plain MACD or a MACD Histogram?

Are it an exponential MACD 12,26,9?

I can't really interpret Bullish Reversal, Bullish Continuation Reversal, Bearish Continuation, and Bearish Reversal Divergence for you as it would pertain to higher highs, higher lows, lower highs, and lower lows.

There are 16 possible combinations if we are considering both the MACD and price in combination.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Friday, March 29, 2019 2:39:06 AM
Registered User
Joined: 3/10/2012
Posts: 465

Priyaa first of all welcome to the forum and i saw the message you asked to me  above,,, i think Bruce answered you for your query by sending you TC mail  but in your Request 1 for MACD i might be able to help somewhat try this as below i followed what Bruce had built in past for me for someother queries he is best in what he does ,,,

ok saw for request 1

I like 5 and 21 for macd so i plot custom indicator and formula as "MACD5.21" then i slide to left and add click on that PCF and  click add plot here then add 1 period simple moving average data source as Macd--- the reason i do this because to my eye i don't want zero line to be seen it bothers my divergence analysis 

then plot custom indicator name it as Higher High and copy as below then slide it to the left and add offset moving average period 1 and offset -2 style dot plot give a green colour

IIF(MAX(MACD5.21, 2) < MACD5.21.2 AND MACD5.21.2 > MAX(MACD5.21.3, 2) AND MACD5.21.2 > IIF(MAX(MACD5.21.3, 2) < MACD5.21.5 AND MACD5.21.5 > MAX(MACD5.21.6, 2), MACD5.21.5, IIF(MAX(MACD5.21.4, 2) < MACD5.21.6 AND MACD5.21.6 > MAX(MACD5.21.7, 2), MACD5.21.6, IIF(MAX(MACD5.21.5, 2) < MACD5.21.7 AND MACD5.21.7 > MAX(MACD5.21.8, 2), MACD5.21.7, IIF(MAX(MACD5.21.6, 2) < MACD5.21.8 AND MACD5.21.8 > MAX(MACD5.21.9, 2), MACD5.21.8, IIF(MAX(MACD5.21.7, 2) < MACD5.21.9 AND MACD5.21.9 > MAX(MACD5.21.10, 2), MACD5.21.9, IIF(MAX(MACD5.21.8, 2) < MACD5.21.10 AND MACD5.21.10 > MAX(MACD5.21.11, 2), MACD5.21.10, IIF(MAX(MACD5.21.9, 2) < MACD5.21.11 AND MACD5.21.11 > MAX(MACD5.21.12, 2), MACD5.21.11, IIF(MAX(MACD5.21.10, 2) < MACD5.21.12 AND MACD5.21.12 > MAX(MACD5.21.13, 2), MACD5.21.12, IIF(MAX(MACD5.21.11, 2) < MACD5.21.13 AND MACD5.21.13 > MAX(MACD5.21.14, 2), MACD5.21.13, IIF(MAX(MACD5.21.12, 2) < MACD5.21.14 AND MACD5.21.14 > MAX(MACD5.21.15, 2), MACD5.21.14, IIF(MAX(MACD5.21.13, 2) < MACD5.21.15 AND MACD5.21.15 > MAX(MACD5.21.16, 2), MACD5.21.15, IIF(MAX(MACD5.21.14, 2) < MACD5.21.16 AND MACD5.21.16 > MAX(MACD5.21.17, 2), MACD5.21.16, IIF(MAX(MACD5.21.15, 2) < MACD5.21.17 AND MACD5.21.17 > MAX(MACD5.21.18, 2), MACD5.21.17, IIF(MAX(MACD5.21.16, 2) < MACD5.21.18 AND MACD5.21.18 > MAX(MACD5.21.19, 2), MACD5.21.18, IIF(MAX(MACD5.21.17, 2) < MACD5.21.19 AND MACD5.21.19 > MAX(MACD5.21.20, 2), MACD5.21.19, IIF(MAX(MACD5.21.18, 2) < MACD5.21.20 AND MACD5.21.20 > MAX(MACD5.21.21, 2), MACD5.21.20, IIF(MAX(MACD5.21.19, 2) < MACD5.21.21 AND MACD5.21.21 > MAX(MACD5.21.22, 2), MACD5.21.21, IIF(MAX(MACD5.21.20, 2) < MACD5.21.22 AND MACD5.21.22 > MAX(MACD5.21.23, 2), MACD5.21.22, IIF(MAX(MACD5.21.21, 2) < MACD5.21.23 AND MACD5.21.23 > MAX(MACD5.21.24, 2), MACD5.21.23, IIF(MAX(MACD5.21.22, 2) < MACD5.21.24 AND MACD5.21.24 > MAX(MACD5.21.25, 2), MACD5.21.24, IIF(MAX(MACD5.21.23, 2) < MACD5.21.25 AND MACD5.21.25 > MAX(MACD5.21.26, 2), MACD5.21.25, IIF(MAX(MACD5.21.24, 2) < MACD5.21.26 AND MACD5.21.26 > MAX(MACD5.21.27, 2), MACD5.21.26, IIF(MAX(MACD5.21.25, 2) < MACD5.21.27 AND MACD5.21.27 > MAX(MACD5.21.28, 2), MACD5.21.27, IIF(MAX(MACD5.21.26, 2) < MACD5.21.28 AND MACD5.21.28 > MAX(MACD5.21.29, 2), MACD5.21.28, IIF(MAX(MACD5.21.27, 2) < MACD5.21.29 AND MACD5.21.29 > MAX(MACD5.21.30, 2), MACD5.21.29, IIF(MAX(MACD5.21.28, 2) < MACD5.21.30 AND MACD5.21.30 > MAX(MACD5.21.31, 2), MACD5.21.30, IIF(MAX(MACD5.21.29, 2) < MACD5.21.31 AND MACD5.21.31 > MAX(MACD5.21.32, 2), MACD5.21.31, IIF(MAX(MACD5.21.30, 2) < MACD5.21.32 AND MACD5.21.32 > MAX(MACD5.21.33, 2), MACD5.21.32, IIF(MAX(MACD5.21.31, 2) < MACD5.21.33 AND MACD5.21.33 > MAX(MACD5.21.34, 2), MACD5.21.33, IIF(MAX(MACD5.21.32, 2) < MACD5.21.34 AND MACD5.21.34 > MAX(MACD5.21.35, 2), MACD5.21.34, IIF(MAX(MACD5.21.33, 2) < MACD5.21.35 AND MACD5.21.35 > MAX(MACD5.21.36, 2), MACD5.21.35, 101))))))))))))))))))))))))))))))), MACD5.21.2, -200)
 
Lower high purple
 
IIF(MAX(MACD5.21, 2) < MACD5.21.2 AND MACD5.21.2 > MAX(MACD5.21.3, 2) AND MACD5.21.2 < IIF(MAX(MACD5.21.3, 2) < MACD5.21.5 AND MACD5.21.5 > MAX(MACD5.21.6, 2), MACD5.21.5, IIF(MAX(MACD5.21.4, 2) < MACD5.21.6 AND MACD5.21.6 > MAX(MACD5.21.7, 2), MACD5.21.6, IIF(MAX(MACD5.21.5, 2) < MACD5.21.7 AND MACD5.21.7 > MAX(MACD5.21.8, 2), MACD5.21.7, IIF(MAX(MACD5.21.6, 2) < MACD5.21.8 AND MACD5.21.8 > MAX(MACD5.21.9, 2), MACD5.21.8, IIF(MAX(MACD5.21.7, 2) < MACD5.21.9 AND MACD5.21.9 > MAX(MACD5.21.10, 2), MACD5.21.9, IIF(MAX(MACD5.21.8, 2) < MACD5.21.10 AND MACD5.21.10 > MAX(MACD5.21.11, 2), MACD5.21.10, IIF(MAX(MACD5.21.9, 2) < MACD5.21.11 AND MACD5.21.11 > MAX(MACD5.21.12, 2), MACD5.21.11, IIF(MAX(MACD5.21.10, 2) < MACD5.21.12 AND MACD5.21.12 > MAX(MACD5.21.13, 2), MACD5.21.12, IIF(MAX(MACD5.21.11, 2) < MACD5.21.13 AND MACD5.21.13 > MAX(MACD5.21.14, 2), MACD5.21.13, IIF(MAX(MACD5.21.12, 2) < MACD5.21.14 AND MACD5.21.14 > MAX(MACD5.21.15, 2), MACD5.21.14, IIF(MAX(MACD5.21.13, 2) < MACD5.21.15 AND MACD5.21.15 > MAX(MACD5.21.16, 2), MACD5.21.15, IIF(MAX(MACD5.21.14, 2) < MACD5.21.16 AND MACD5.21.16 > MAX(MACD5.21.17, 2), MACD5.21.16, IIF(MAX(MACD5.21.15, 2) < MACD5.21.17 AND MACD5.21.17 > MAX(MACD5.21.18, 2), MACD5.21.17, IIF(MAX(MACD5.21.16, 2) < MACD5.21.18 AND MACD5.21.18 > MAX(MACD5.21.19, 2), MACD5.21.18, IIF(MAX(MACD5.21.17, 2) < MACD5.21.19 AND MACD5.21.19 > MAX(MACD5.21.20, 2), MACD5.21.19, IIF(MAX(MACD5.21.18, 2) < MACD5.21.20 AND MACD5.21.20 > MAX(MACD5.21.21, 2), MACD5.21.20, IIF(MAX(MACD5.21.19, 2) < MACD5.21.21 AND MACD5.21.21 > MAX(MACD5.21.22, 2), MACD5.21.21, IIF(MAX(MACD5.21.20, 2) < MACD5.21.22 AND MACD5.21.22 > MAX(MACD5.21.23, 2), MACD5.21.22, IIF(MAX(MACD5.21.21, 2) < MACD5.21.23 AND MACD5.21.23 > MAX(MACD5.21.24, 2), MACD5.21.23, IIF(MAX(MACD5.21.22, 2) < MACD5.21.24 AND MACD5.21.24 > MAX(MACD5.21.25, 2), MACD5.21.24, IIF(MAX(MACD5.21.23, 2) < MACD5.21.25 AND MACD5.21.25 > MAX(MACD5.21.26, 2), MACD5.21.25, IIF(MAX(MACD5.21.24, 2) < MACD5.21.26 AND MACD5.21.26 > MAX(MACD5.21.27, 2), MACD5.21.26, IIF(MAX(MACD5.21.25, 2) < MACD5.21.27 AND MACD5.21.27 > MAX(MACD5.21.28, 2), MACD5.21.27, IIF(MAX(MACD5.21.26, 2) < MACD5.21.28 AND MACD5.21.28 > MAX(MACD5.21.29, 2), MACD5.21.28, IIF(MAX(MACD5.21.27, 2) < MACD5.21.29 AND MACD5.21.29 > MAX(MACD5.21.30, 2), MACD5.21.29, IIF(MAX(MACD5.21.28, 2) < MACD5.21.30 AND MACD5.21.30 > MAX(MACD5.21.31, 2), MACD5.21.30, IIF(MAX(MACD5.21.29, 2) < MACD5.21.31 AND MACD5.21.31 > MAX(MACD5.21.32, 2), MACD5.21.31, IIF(MAX(MACD5.21.30, 2) < MACD5.21.32 AND MACD5.21.32 > MAX(MACD5.21.33, 2), MACD5.21.32, IIF(MAX(MACD5.21.31, 2) < MACD5.21.33 AND MACD5.21.33 > MAX(MACD5.21.34, 2), MACD5.21.33, IIF(MAX(MACD5.21.32, 2) < MACD5.21.34 AND MACD5.21.34 > MAX(MACD5.21.35, 2), MACD5.21.34, IIF(MAX(MACD5.21.33, 2) < MACD5.21.35 AND MACD5.21.35 > MAX(MACD5.21.36, 2), MACD5.21.35, -1))))))))))))))))))))))))))))))), MACD5.21.2, -200)
 
higher low  brown
 
IIF(MIN(MACD5.21, 2) > MACD5.21.2 AND MACD5.21.2 < MIN(MACD5.21.3, 2) AND MACD5.21.2 > IIF(MIN(MACD5.21.3, 2) > MACD5.21.5 AND MACD5.21.5 < MIN(MACD5.21.6, 2), MACD5.21.5, IIF(MIN(MACD5.21.4, 2) > MACD5.21.6 AND MACD5.21.6 < MIN(MACD5.21.7, 2), MACD5.21.6, IIF(MIN(MACD5.21.5, 2) > MACD5.21.7 AND MACD5.21.7 < MIN(MACD5.21.8, 2), MACD5.21.7, IIF(MIN(MACD5.21.6, 2) > MACD5.21.8 AND MACD5.21.8 < MIN(MACD5.21.9, 2), MACD5.21.8, IIF(MIN(MACD5.21.7, 2) > MACD5.21.9 AND MACD5.21.9 < MIN(MACD5.21.10, 2), MACD5.21.9, IIF(MIN(MACD5.21.8, 2) > MACD5.21.10 AND MACD5.21.10 < MIN(MACD5.21.11, 2), MACD5.21.10, IIF(MIN(MACD5.21.9, 2) > MACD5.21.11 AND MACD5.21.11 < MIN(MACD5.21.12, 2), MACD5.21.11, IIF(MIN(MACD5.21.10, 2) > MACD5.21.12 AND MACD5.21.12 < MIN(MACD5.21.13, 2), MACD5.21.12, IIF(MIN(MACD5.21.11, 2) > MACD5.21.13 AND MACD5.21.13 < MIN(MACD5.21.14, 2), MACD5.21.13, IIF(MIN(MACD5.21.12, 2) > MACD5.21.14 AND MACD5.21.14 < MIN(MACD5.21.15, 2), MACD5.21.14, IIF(MIN(MACD5.21.13, 2) > MACD5.21.15 AND MACD5.21.15 < MIN(MACD5.21.16, 2), MACD5.21.15, IIF(MIN(MACD5.21.14, 2) > MACD5.21.16 AND MACD5.21.16 < MIN(MACD5.21.17, 2), MACD5.21.16, IIF(MIN(MACD5.21.15, 2) > MACD5.21.17 AND MACD5.21.17 < MIN(MACD5.21.18, 2), MACD5.21.17, IIF(MIN(MACD5.21.16, 2) > MACD5.21.18 AND MACD5.21.18 < MIN(MACD5.21.19, 2), MACD5.21.18, IIF(MIN(MACD5.21.17, 2) > MACD5.21.19 AND MACD5.21.19 < MIN(MACD5.21.20, 2), MACD5.21.19, IIF(MIN(MACD5.21.18, 2) > MACD5.21.20 AND MACD5.21.20 < MIN(MACD5.21.21, 2), MACD5.21.20, IIF(MIN(MACD5.21.19, 2) > MACD5.21.21 AND MACD5.21.21 < MIN(MACD5.21.22, 2), MACD5.21.21, IIF(MIN(MACD5.21.20, 2) > MACD5.21.22 AND MACD5.21.22 < MIN(MACD5.21.23, 2), MACD5.21.22, IIF(MIN(MACD5.21.21, 2) > MACD5.21.23 AND MACD5.21.23 < MIN(MACD5.21.24, 2), MACD5.21.23, IIF(MIN(MACD5.21.22, 2) > MACD5.21.24 AND MACD5.21.24 < MIN(MACD5.21.25, 2), MACD5.21.24, IIF(MIN(MACD5.21.23, 2) > MACD5.21.25 AND MACD5.21.25 < MIN(MACD5.21.26, 2), MACD5.21.25, IIF(MIN(MACD5.21.24, 2) > MACD5.21.26 AND MACD5.21.26 < MIN(MACD5.21.27, 2), MACD5.21.26, IIF(MIN(MACD5.21.25, 2) > MACD5.21.27 AND MACD5.21.27 < MIN(MACD5.21.28, 2), MACD5.21.27, IIF(MIN(MACD5.21.26, 2) > MACD5.21.28 AND MACD5.21.28 < MIN(MACD5.21.29, 2), MACD5.21.28, IIF(MIN(MACD5.21.27, 2) > MACD5.21.29 AND MACD5.21.29 < MIN(MACD5.21.30, 2), MACD5.21.29, IIF(MIN(MACD5.21.28, 2) > MACD5.21.30 AND MACD5.21.30 < MIN(MACD5.21.31, 2), MACD5.21.30, IIF(MIN(MACD5.21.29, 2) > MACD5.21.31 AND MACD5.21.31 < MIN(MACD5.21.32, 2), MACD5.21.31, IIF(MIN(MACD5.21.30, 2) > MACD5.21.32 AND MACD5.21.32 < MIN(MACD5.21.33, 2), MACD5.21.32, IIF(MIN(MACD5.21.31, 2) > MACD5.21.33 AND MACD5.21.33 < MIN(MACD5.21.34, 2), MACD5.21.33, IIF(MIN(MACD5.21.32, 2) > MACD5.21.34 AND MACD5.21.34 < MIN(MACD5.21.35, 2), MACD5.21.34, IIF(MIN(MACD5.21.33, 2) > MACD5.21.35 AND MACD5.21.35 < MIN(MACD5.21.36, 2), MACD5.21.35, 101))))))))))))))))))))))))))))))), MACD5.21.2, -200)
 
Lower low red
 
IIF(MIN(MACD5.21, 2) > MACD5.21.2 AND MACD5.21.2 < MIN(MACD5.21.3, 2) AND MACD5.21.2 < IIF(MIN(MACD5.21.3, 2) > MACD5.21.5 AND MACD5.21.5 < MIN(MACD5.21.6, 2), MACD5.21.5, IIF(MIN(MACD5.21.4, 2) > MACD5.21.6 AND MACD5.21.6 < MIN(MACD5.21.7, 2), MACD5.21.6, IIF(MIN(MACD5.21.5, 2) > MACD5.21.7 AND MACD5.21.7 < MIN(MACD5.21.8, 2), MACD5.21.7, IIF(MIN(MACD5.21.6, 2) > MACD5.21.8 AND MACD5.21.8 < MIN(MACD5.21.9, 2), MACD5.21.8, IIF(MIN(MACD5.21.7, 2) > MACD5.21.9 AND MACD5.21.9 < MIN(MACD5.21.10, 2), MACD5.21.9, IIF(MIN(MACD5.21.8, 2) > MACD5.21.10 AND MACD5.21.10 < MIN(MACD5.21.11, 2), MACD5.21.10, IIF(MIN(MACD5.21.9, 2) > MACD5.21.11 AND MACD5.21.11 < MIN(MACD5.21.12, 2), MACD5.21.11, IIF(MIN(MACD5.21.10, 2) > MACD5.21.12 AND MACD5.21.12 < MIN(MACD5.21.13, 2), MACD5.21.12, IIF(MIN(MACD5.21.11, 2) > MACD5.21.13 AND MACD5.21.13 < MIN(MACD5.21.14, 2), MACD5.21.13, IIF(MIN(MACD5.21.12, 2) > MACD5.21.14 AND MACD5.21.14 < MIN(MACD5.21.15, 2), MACD5.21.14, IIF(MIN(MACD5.21.13, 2) > MACD5.21.15 AND MACD5.21.15 < MIN(MACD5.21.16, 2), MACD5.21.15, IIF(MIN(MACD5.21.14, 2) > MACD5.21.16 AND MACD5.21.16 < MIN(MACD5.21.17, 2), MACD5.21.16, IIF(MIN(MACD5.21.15, 2) > MACD5.21.17 AND MACD5.21.17 < MIN(MACD5.21.18, 2), MACD5.21.17, IIF(MIN(MACD5.21.16, 2) > MACD5.21.18 AND MACD5.21.18 < MIN(MACD5.21.19, 2), MACD5.21.18, IIF(MIN(MACD5.21.17, 2) > MACD5.21.19 AND MACD5.21.19 < MIN(MACD5.21.20, 2), MACD5.21.19, IIF(MIN(MACD5.21.18, 2) > MACD5.21.20 AND MACD5.21.20 < MIN(MACD5.21.21, 2), MACD5.21.20, IIF(MIN(MACD5.21.19, 2) > MACD5.21.21 AND MACD5.21.21 < MIN(MACD5.21.22, 2), MACD5.21.21, IIF(MIN(MACD5.21.20, 2) > MACD5.21.22 AND MACD5.21.22 < MIN(MACD5.21.23, 2), MACD5.21.22, IIF(MIN(MACD5.21.21, 2) > MACD5.21.23 AND MACD5.21.23 < MIN(MACD5.21.24, 2), MACD5.21.23, IIF(MIN(MACD5.21.22, 2) > MACD5.21.24 AND MACD5.21.24 < MIN(MACD5.21.25, 2), MACD5.21.24, IIF(MIN(MACD5.21.23, 2) > MACD5.21.25 AND MACD5.21.25 < MIN(MACD5.21.26, 2), MACD5.21.25, IIF(MIN(MACD5.21.24, 2) > MACD5.21.26 AND MACD5.21.26 < MIN(MACD5.21.27, 2), MACD5.21.26, IIF(MIN(MACD5.21.25, 2) > MACD5.21.27 AND MACD5.21.27 < MIN(MACD5.21.28, 2), MACD5.21.27, IIF(MIN(MACD5.21.26, 2) > MACD5.21.28 AND MACD5.21.28 < MIN(MACD5.21.29, 2), MACD5.21.28, IIF(MIN(MACD5.21.27, 2) > MACD5.21.29 AND MACD5.21.29 < MIN(MACD5.21.30, 2), MACD5.21.29, IIF(MIN(MACD5.21.28, 2) > MACD5.21.30 AND MACD5.21.30 < MIN(MACD5.21.31, 2), MACD5.21.30, IIF(MIN(MACD5.21.29, 2) > MACD5.21.31 AND MACD5.21.31 < MIN(MACD5.21.32, 2), MACD5.21.31, IIF(MIN(MACD5.21.30, 2) > MACD5.21.32 AND MACD5.21.32 < MIN(MACD5.21.33, 2), MACD5.21.32, IIF(MIN(MACD5.21.31, 2) > MACD5.21.33 AND MACD5.21.33 < MIN(MACD5.21.34, 2), MACD5.21.33, IIF(MIN(MACD5.21.32, 2) > MACD5.21.34 AND MACD5.21.34 < MIN(MACD5.21.35, 2), MACD5.21.34, IIF(MIN(MACD5.21.33, 2) > MACD5.21.35 AND MACD5.21.35 < MIN(MACD5.21.36, 2), MACD5.21.35, -1))))))))))))))))))))))))))))))), MACD5.21.2, -200) 
 
And they all scale with MACD , once u finish plotting all four then plot custom indicator  and formula just  "-200" with dot plot and colour as background of your chart the reason of doing this is each formula above has -200 at the end so it will hide dots and overlay as colour of your chart
 
I m attaching a Link below so you can see how it appears with some ideas of divergence as shown... but for Divergence formulas I think Bruce will be best to give them if this is what you were asking in request 1
 
 
Goodluck
 
 
Priyaa
Posted : Wednesday, April 3, 2019 11:36:49 AM
Registered User
Joined: 1/11/2019
Posts: 28

Thank you Bruce and Dhiren. I'm very greatful to you both. I will need atleast to week to understand. I will get back to you both with any questions I have.

 

Regards,

Priya

Priyaa
Posted : Wednesday, April 3, 2019 11:33:09 PM
Registered User
Joined: 1/11/2019
Posts: 28

Bruce,

Regarding your question about MACD, I'm looking for MACD-H 12,26,9.

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.