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 |

RSI SIGNAL SPIKE Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Sunday, January 7, 2018 4:32:26 PM
Registered User
Joined: 3/10/2012
Posts: 465

Hi Bruce 

I hope you had great holidays , 

Before holidays we were discussing on RSI so i thought to see if we can do it like this please see attached examples 

i have following bullish criteria to meet

1) Wilder RSI14 period trigger should be that it comes out of 30 level 

2) It must cross 50 centre line 

3) It must come back below 30 and must hold above previous trigger spike  that will become signal spike thats where i NEED PCF SPIKE 

I have attached couple of examples please see the link 

http://www.dhirenshah.com/rsi-example-1/

http://www.dhirenshah.com/rsi-spike-example-2/

 

On reverse side i have following for bearish criteria to mee

1) Wilder RSI14 period trigger should be that it comes out of 70 level 

2) It must cross 50 centre line 

3) It must come back ABOVE 70 and must hold below previous trigger spike that will become signal spike thats where I NEED PCF SPIKE 

I have attached couple of examples please see the link 

http://www.dhirenshah.com/rsi-bearish-spike-example/

 

Thanks 

Dhiren

 

dhirenshah
Posted : Sunday, January 7, 2018 5:06:38 PM
Registered User
Joined: 3/10/2012
Posts: 465

One more bearish example 

http://www.dhirenshah.com/rsi-bearsih-signal-spike-example-2/

Bruce_L
Posted : Monday, January 8, 2018 1:04:35 PM


Worden Trainer

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

I cannot think of any way to do this.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Tuesday, January 9, 2018 1:19:14 AM
Registered User
Joined: 3/10/2012
Posts: 465

Alright Bruce No worries thats fine i understand i can eyeball then , but instead can we do this if possible 

In same Wilder RSI14  i want to overlay on RSI 4 colour dots with HH -HL-LH -LL using calculations of RSI everytime RSI forms a Pivot (hypothetically Imagine the RSI value as CLOSE value of price in line charting),, i just marked few to show u but i m sure you will get an idea of what i want to achieve, 

so what i did is I marked pink dots on RSI as bull dots where using this formula

IIF((WRSI14 > WRSI14.1), WRSI14 , 1 / 0)

 and marked blue bear dots on RSI using this formula

IIF((WRSI14 < WRSI14.1), WRSI14 , 1 / 0)

Please see the attached link http://www.dhirenshah.com/rsi-hh-hl-lh-ll-example/

my main interest is to see HH-LH and HL - LL  using 4 different colours and based on example HH AND LH will always be pink dots and HL AND LL will always be blue dots

and here is another example http://www.dhirenshah.com/rsi-hh-lh-hl-ll-example-2/

may be in rush i must have marked some incorrect labelling but you will get the idea of how it should look with 4 colours dots

thanks again 

Dhiren

Bruce_L
Posted : Tuesday, January 9, 2018 2:49:18 PM


Worden Trainer

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

So I am not quite sure what colors you want for what. If you really just want pink and blue, couldn't you just do the following for pink (HH and LH):

IIF(MAX(WRSI14, 2) < WRSI14.2 AND WRSI14.2 > MAX(WRSI14.3, 2), WRSI14.2, -1)

And the following for blue (HL and LL):

IIF(MIN(WRSI14, 2) > WRSI14.2 AND WRSI14.2 < MIN(WRSI14.3, 2), WRSI14.2, -1)

You will have to offset these plots by adding a 1 period moving average with the offset set to -2.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Tuesday, January 9, 2018 3:04:09 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce the pink dots that i mentioned HH and LH was to explain you that because i don't know the formula so i had only pink dots on HH and LH but now since u gave the formula for HH can you please give me formula for LH ??

 

and same thing for blue dots i mentioned HL and LL as i didn;t know the formula so i had only blue dots on HL and LL but now since u have the formula for LL can you please give me formula for HL?

 

so i wanted to do HH GREEN , LH PURPLE , HL BROWN & LL RED thats what i wish to overlay on RSI

 

thanks

Bruce_L
Posted : Tuesday, January 9, 2018 3:59:18 PM


Worden Trainer

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

Higher High:

IIF(MAX(WRSI14, 2) < WRSI14.2 AND WRSI14.2 > MAX(WRSI14.3, 2) AND WRSI14.2 > IIF(MAX(WRSI14.3, 2) < WRSI14.5 AND WRSI14.5 > MAX(WRSI14.7, 2), WRSI14.5, IIF(MAX(WRSI14.4, 2) < WRSI14.6 AND WRSI14.6 > MAX(WRSI14.8, 2), WRSI14.6, IIF(MAX(WRSI14.5, 2) < WRSI14.7 AND WRSI14.7 > MAX(WRSI14.9, 2), WRSI14.7, IIF(MAX(WRSI14.6, 2) < WRSI14.8 AND WRSI14.8 > MAX(WRSI14.10, 2), WRSI14.8, IIF(MAX(WRSI14.7, 2) < WRSI14.9 AND WRSI14.9 > MAX(WRSI14.11, 2), WRSI14.9, IIF(MAX(WRSI14.8, 2) < WRSI14.10 AND WRSI14.10 > MAX(WRSI14.12, 2), WRSI14.10, IIF(MAX(WRSI14.9, 2) < WRSI14.11 AND WRSI14.11 > MAX(WRSI14.13, 2), WRSI14.11, IIF(MAX(WRSI14.10, 2) < WRSI14.12 AND WRSI14.12 > MAX(WRSI14.14, 2), WRSI14.12, IIF(MAX(WRSI14.11, 2) < WRSI14.13 AND WRSI14.13 > MAX(WRSI14.15, 2), WRSI14.13, IIF(MAX(WRSI14.12, 2) < WRSI14.14 AND WRSI14.14 > MAX(WRSI14.16, 2), WRSI14.14, IIF(MAX(WRSI14.13, 2) < WRSI14.15 AND WRSI14.15 > MAX(WRSI14.17, 2), WRSI14.15, IIF(MAX(WRSI14.14, 2) < WRSI14.16 AND WRSI14.16 > MAX(WRSI14.18, 2), WRSI14.16, IIF(MAX(WRSI14.15, 2) < WRSI14.17 AND WRSI14.17 > MAX(WRSI14.19, 2), WRSI14.17, IIF(MAX(WRSI14.16, 2) < WRSI14.18 AND WRSI14.18 > MAX(WRSI14.20, 2), WRSI14.18, IIF(MAX(WRSI14.17, 2) < WRSI14.19 AND WRSI14.19 > MAX(WRSI14.21, 2), WRSI14.19, IIF(MAX(WRSI14.18, 2) < WRSI14.20 AND WRSI14.20 > MAX(WRSI14.22, 2), WRSI14.20, IIF(MAX(WRSI14.19, 2) < WRSI14.21 AND WRSI14.21 > MAX(WRSI14.23, 2), WRSI14.21, IIF(MAX(WRSI14.20, 2) < WRSI14.22 AND WRSI14.22 > MAX(WRSI14.24, 2), WRSI14.22, IIF(MAX(WRSI14.21, 2) < WRSI14.23 AND WRSI14.23 > MAX(WRSI14.25, 2), WRSI14.23, IIF(MAX(WRSI14.22, 2) < WRSI14.24 AND WRSI14.24 > MAX(WRSI14.26, 2), WRSI14.24, IIF(MAX(WRSI14.23, 2) < WRSI14.25 AND WRSI14.25 > MAX(WRSI14.27, 2), WRSI14.25, IIF(MAX(WRSI14.24, 2) < WRSI14.26 AND WRSI14.26 > MAX(WRSI14.28, 2), WRSI14.26, IIF(MAX(WRSI14.25, 2) < WRSI14.27 AND WRSI14.27 > MAX(WRSI14.29, 2), WRSI14.27, IIF(MAX(WRSI14.26, 2) < WRSI14.28 AND WRSI14.28 > MAX(WRSI14.30, 2), WRSI14.28, IIF(MAX(WRSI14.27, 2) < WRSI14.29 AND WRSI14.29 > MAX(WRSI14.31, 2), WRSI14.29, IIF(MAX(WRSI14.28, 2) < WRSI14.30 AND WRSI14.30 > MAX(WRSI14.32, 2), WRSI14.30, IIF(MAX(WRSI14.29, 2) < WRSI14.31 AND WRSI14.31 > MAX(WRSI14.33, 2), WRSI14.31, IIF(MAX(WRSI14.30, 2) < WRSI14.32 AND WRSI14.32 > MAX(WRSI14.34, 2), WRSI14.32, IIF(MAX(WRSI14.31, 2) < WRSI14.33 AND WRSI14.33 > MAX(WRSI14.35, 2), WRSI14.33, IIF(MAX(WRSI14.32, 2) < WRSI14.34 AND WRSI14.34 > MAX(WRSI14.36, 2), WRSI14.34, IIF(MAX(WRSI14.33, 2) < WRSI14.35 AND WRSI14.35 > MAX(WRSI14.37, 2), WRSI14.35, IIF(MAX(WRSI14.34, 2) < WRSI14.36 AND WRSI14.36 > MAX(WRSI14.38, 2), WRSI14.36, IIF(MAX(WRSI14.35, 2) < WRSI14.37 AND WRSI14.37 > MAX(WRSI14.39, 2), WRSI14.37, IIF(MAX(WRSI14.36, 2) < WRSI14.38 AND WRSI14.38 > MAX(WRSI14.40, 2), WRSI14.38, IIF(MAX(WRSI14.37, 2) < WRSI14.39 AND WRSI14.39 > MAX(WRSI14.41, 2), WRSI14.39, IIF(MAX(WRSI14.38, 2) < WRSI14.40 AND WRSI14.40 > MAX(WRSI14.42, 2), WRSI14.40, IIF(MAX(WRSI14.39, 2) < WRSI14.41 AND WRSI14.41 > MAX(WRSI14.43, 2), WRSI14.41, IIF(MAX(WRSI14.40, 2) < WRSI14.42 AND WRSI14.42 > MAX(WRSI14.44, 2), WRSI14.42, IIF(MAX(WRSI14.41, 2) < WRSI14.43 AND WRSI14.43 > MAX(WRSI14.45, 2), WRSI14.43, IIF(MAX(WRSI14.42, 2) < WRSI14.44 AND WRSI14.44 > MAX(WRSI14.46, 2), WRSI14.44, IIF(MAX(WRSI14.43, 2) < WRSI14.45 AND WRSI14.45 > MAX(WRSI14.47, 2), WRSI14.45, IIF(MAX(WRSI14.44, 2) < WRSI14.46 AND WRSI14.46 > MAX(WRSI14.48, 2), WRSI14.46, IIF(MAX(WRSI14.45, 2) < WRSI14.47 AND WRSI14.47 > MAX(WRSI14.49, 2), WRSI14.47, IIF(MAX(WRSI14.46, 2) < WRSI14.48 AND WRSI14.48 > MAX(WRSI14.50, 2), WRSI14.48, IIF(MAX(WRSI14.47, 2) < WRSI14.49 AND WRSI14.49 > MAX(WRSI14.51, 2), WRSI14.49, IIF(MAX(WRSI14.48, 2) < WRSI14.50 AND WRSI14.50 > MAX(WRSI14.52, 2), WRSI14.50, IIF(MAX(WRSI14.49, 2) < WRSI14.51 AND WRSI14.51 > MAX(WRSI14.53, 2), WRSI14.51, IIF(MAX(WRSI14.50, 2) < WRSI14.52 AND WRSI14.52 > MAX(WRSI14.54, 2), WRSI14.52, IIF(MAX(WRSI14.51, 2) < WRSI14.53 AND WRSI14.53 > MAX(WRSI14.55, 2), WRSI14.53, IIF(MAX(WRSI14.52, 2) < WRSI14.54 AND WRSI14.54 > MAX(WRSI14.56, 2), WRSI14.54, IIF(MAX(WRSI14.53, 2) < WRSI14.55 AND WRSI14.55 > MAX(WRSI14.57, 2), WRSI14.55, IIF(MAX(WRSI14.54, 2) < WRSI14.56 AND WRSI14.56 > MAX(WRSI14.58, 2), WRSI14.56, IIF(MAX(WRSI14.55, 2) < WRSI14.57 AND WRSI14.57 > MAX(WRSI14.59, 2), WRSI14.57, IIF(MAX(WRSI14.56, 2) < WRSI14.58 AND WRSI14.58 > MAX(WRSI14.60, 2), WRSI14.58, IIF(MAX(WRSI14.57, 2) < WRSI14.59 AND WRSI14.59 > MAX(WRSI14.61, 2), WRSI14.59, IIF(MAX(WRSI14.58, 2) < WRSI14.60 AND WRSI14.60 > MAX(WRSI14.62, 2), WRSI14.60, IIF(MAX(WRSI14.59, 2) < WRSI14.61 AND WRSI14.61 > MAX(WRSI14.63, 2), WRSI14.61, IIF(MAX(WRSI14.60, 2) < WRSI14.62 AND WRSI14.62 > MAX(WRSI14.64, 2), WRSI14.62, IIF(MAX(WRSI14.61, 2) < WRSI14.63 AND WRSI14.63 > MAX(WRSI14.65, 2), WRSI14.63, IIF(MAX(WRSI14.62, 2) < WRSI14.64 AND WRSI14.64 > MAX(WRSI14.66, 2), WRSI14.64, IIF(MAX(WRSI14.63, 2) < WRSI14.65 AND WRSI14.65 > MAX(WRSI14.67, 2), WRSI14.65, IIF(MAX(WRSI14.64, 2) < WRSI14.66 AND WRSI14.66 > MAX(WRSI14.68, 2), WRSI14.66, IIF(MAX(WRSI14.65, 2) < WRSI14.67 AND WRSI14.67 > MAX(WRSI14.69, 2), WRSI14.67, 101))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)

Lower High:

IIF(MAX(WRSI14, 2) < WRSI14.2 AND WRSI14.2 > MAX(WRSI14.3, 2) AND WRSI14.2 < IIF(MAX(WRSI14.3, 2) < WRSI14.5 AND WRSI14.5 > MAX(WRSI14.7, 2), WRSI14.5, IIF(MAX(WRSI14.4, 2) < WRSI14.6 AND WRSI14.6 > MAX(WRSI14.8, 2), WRSI14.6, IIF(MAX(WRSI14.5, 2) < WRSI14.7 AND WRSI14.7 > MAX(WRSI14.9, 2), WRSI14.7, IIF(MAX(WRSI14.6, 2) < WRSI14.8 AND WRSI14.8 > MAX(WRSI14.10, 2), WRSI14.8, IIF(MAX(WRSI14.7, 2) < WRSI14.9 AND WRSI14.9 > MAX(WRSI14.11, 2), WRSI14.9, IIF(MAX(WRSI14.8, 2) < WRSI14.10 AND WRSI14.10 > MAX(WRSI14.12, 2), WRSI14.10, IIF(MAX(WRSI14.9, 2) < WRSI14.11 AND WRSI14.11 > MAX(WRSI14.13, 2), WRSI14.11, IIF(MAX(WRSI14.10, 2) < WRSI14.12 AND WRSI14.12 > MAX(WRSI14.14, 2), WRSI14.12, IIF(MAX(WRSI14.11, 2) < WRSI14.13 AND WRSI14.13 > MAX(WRSI14.15, 2), WRSI14.13, IIF(MAX(WRSI14.12, 2) < WRSI14.14 AND WRSI14.14 > MAX(WRSI14.16, 2), WRSI14.14, IIF(MAX(WRSI14.13, 2) < WRSI14.15 AND WRSI14.15 > MAX(WRSI14.17, 2), WRSI14.15, IIF(MAX(WRSI14.14, 2) < WRSI14.16 AND WRSI14.16 > MAX(WRSI14.18, 2), WRSI14.16, IIF(MAX(WRSI14.15, 2) < WRSI14.17 AND WRSI14.17 > MAX(WRSI14.19, 2), WRSI14.17, IIF(MAX(WRSI14.16, 2) < WRSI14.18 AND WRSI14.18 > MAX(WRSI14.20, 2), WRSI14.18, IIF(MAX(WRSI14.17, 2) < WRSI14.19 AND WRSI14.19 > MAX(WRSI14.21, 2), WRSI14.19, IIF(MAX(WRSI14.18, 2) < WRSI14.20 AND WRSI14.20 > MAX(WRSI14.22, 2), WRSI14.20, IIF(MAX(WRSI14.19, 2) < WRSI14.21 AND WRSI14.21 > MAX(WRSI14.23, 2), WRSI14.21, IIF(MAX(WRSI14.20, 2) < WRSI14.22 AND WRSI14.22 > MAX(WRSI14.24, 2), WRSI14.22, IIF(MAX(WRSI14.21, 2) < WRSI14.23 AND WRSI14.23 > MAX(WRSI14.25, 2), WRSI14.23, IIF(MAX(WRSI14.22, 2) < WRSI14.24 AND WRSI14.24 > MAX(WRSI14.26, 2), WRSI14.24, IIF(MAX(WRSI14.23, 2) < WRSI14.25 AND WRSI14.25 > MAX(WRSI14.27, 2), WRSI14.25, IIF(MAX(WRSI14.24, 2) < WRSI14.26 AND WRSI14.26 > MAX(WRSI14.28, 2), WRSI14.26, IIF(MAX(WRSI14.25, 2) < WRSI14.27 AND WRSI14.27 > MAX(WRSI14.29, 2), WRSI14.27, IIF(MAX(WRSI14.26, 2) < WRSI14.28 AND WRSI14.28 > MAX(WRSI14.30, 2), WRSI14.28, IIF(MAX(WRSI14.27, 2) < WRSI14.29 AND WRSI14.29 > MAX(WRSI14.31, 2), WRSI14.29, IIF(MAX(WRSI14.28, 2) < WRSI14.30 AND WRSI14.30 > MAX(WRSI14.32, 2), WRSI14.30, IIF(MAX(WRSI14.29, 2) < WRSI14.31 AND WRSI14.31 > MAX(WRSI14.33, 2), WRSI14.31, IIF(MAX(WRSI14.30, 2) < WRSI14.32 AND WRSI14.32 > MAX(WRSI14.34, 2), WRSI14.32, IIF(MAX(WRSI14.31, 2) < WRSI14.33 AND WRSI14.33 > MAX(WRSI14.35, 2), WRSI14.33, IIF(MAX(WRSI14.32, 2) < WRSI14.34 AND WRSI14.34 > MAX(WRSI14.36, 2), WRSI14.34, IIF(MAX(WRSI14.33, 2) < WRSI14.35 AND WRSI14.35 > MAX(WRSI14.37, 2), WRSI14.35, IIF(MAX(WRSI14.34, 2) < WRSI14.36 AND WRSI14.36 > MAX(WRSI14.38, 2), WRSI14.36, IIF(MAX(WRSI14.35, 2) < WRSI14.37 AND WRSI14.37 > MAX(WRSI14.39, 2), WRSI14.37, IIF(MAX(WRSI14.36, 2) < WRSI14.38 AND WRSI14.38 > MAX(WRSI14.40, 2), WRSI14.38, IIF(MAX(WRSI14.37, 2) < WRSI14.39 AND WRSI14.39 > MAX(WRSI14.41, 2), WRSI14.39, IIF(MAX(WRSI14.38, 2) < WRSI14.40 AND WRSI14.40 > MAX(WRSI14.42, 2), WRSI14.40, IIF(MAX(WRSI14.39, 2) < WRSI14.41 AND WRSI14.41 > MAX(WRSI14.43, 2), WRSI14.41, IIF(MAX(WRSI14.40, 2) < WRSI14.42 AND WRSI14.42 > MAX(WRSI14.44, 2), WRSI14.42, IIF(MAX(WRSI14.41, 2) < WRSI14.43 AND WRSI14.43 > MAX(WRSI14.45, 2), WRSI14.43, IIF(MAX(WRSI14.42, 2) < WRSI14.44 AND WRSI14.44 > MAX(WRSI14.46, 2), WRSI14.44, IIF(MAX(WRSI14.43, 2) < WRSI14.45 AND WRSI14.45 > MAX(WRSI14.47, 2), WRSI14.45, IIF(MAX(WRSI14.44, 2) < WRSI14.46 AND WRSI14.46 > MAX(WRSI14.48, 2), WRSI14.46, IIF(MAX(WRSI14.45, 2) < WRSI14.47 AND WRSI14.47 > MAX(WRSI14.49, 2), WRSI14.47, IIF(MAX(WRSI14.46, 2) < WRSI14.48 AND WRSI14.48 > MAX(WRSI14.50, 2), WRSI14.48, IIF(MAX(WRSI14.47, 2) < WRSI14.49 AND WRSI14.49 > MAX(WRSI14.51, 2), WRSI14.49, IIF(MAX(WRSI14.48, 2) < WRSI14.50 AND WRSI14.50 > MAX(WRSI14.52, 2), WRSI14.50, IIF(MAX(WRSI14.49, 2) < WRSI14.51 AND WRSI14.51 > MAX(WRSI14.53, 2), WRSI14.51, IIF(MAX(WRSI14.50, 2) < WRSI14.52 AND WRSI14.52 > MAX(WRSI14.54, 2), WRSI14.52, IIF(MAX(WRSI14.51, 2) < WRSI14.53 AND WRSI14.53 > MAX(WRSI14.55, 2), WRSI14.53, IIF(MAX(WRSI14.52, 2) < WRSI14.54 AND WRSI14.54 > MAX(WRSI14.56, 2), WRSI14.54, IIF(MAX(WRSI14.53, 2) < WRSI14.55 AND WRSI14.55 > MAX(WRSI14.57, 2), WRSI14.55, IIF(MAX(WRSI14.54, 2) < WRSI14.56 AND WRSI14.56 > MAX(WRSI14.58, 2), WRSI14.56, IIF(MAX(WRSI14.55, 2) < WRSI14.57 AND WRSI14.57 > MAX(WRSI14.59, 2), WRSI14.57, IIF(MAX(WRSI14.56, 2) < WRSI14.58 AND WRSI14.58 > MAX(WRSI14.60, 2), WRSI14.58, IIF(MAX(WRSI14.57, 2) < WRSI14.59 AND WRSI14.59 > MAX(WRSI14.61, 2), WRSI14.59, IIF(MAX(WRSI14.58, 2) < WRSI14.60 AND WRSI14.60 > MAX(WRSI14.62, 2), WRSI14.60, IIF(MAX(WRSI14.59, 2) < WRSI14.61 AND WRSI14.61 > MAX(WRSI14.63, 2), WRSI14.61, IIF(MAX(WRSI14.60, 2) < WRSI14.62 AND WRSI14.62 > MAX(WRSI14.64, 2), WRSI14.62, IIF(MAX(WRSI14.61, 2) < WRSI14.63 AND WRSI14.63 > MAX(WRSI14.65, 2), WRSI14.63, IIF(MAX(WRSI14.62, 2) < WRSI14.64 AND WRSI14.64 > MAX(WRSI14.66, 2), WRSI14.64, IIF(MAX(WRSI14.63, 2) < WRSI14.65 AND WRSI14.65 > MAX(WRSI14.67, 2), WRSI14.65, IIF(MAX(WRSI14.64, 2) < WRSI14.66 AND WRSI14.66 > MAX(WRSI14.68, 2), WRSI14.66, IIF(MAX(WRSI14.65, 2) < WRSI14.67 AND WRSI14.67 > MAX(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)

Higher Low:

IIF(MIN(WRSI14, 2) > WRSI14.2 AND WRSI14.2 < MIN(WRSI14.3, 2) AND WRSI14.2 > IIF(MIN(WRSI14.3, 2) > WRSI14.5 AND WRSI14.5 < MIN(WRSI14.7, 2), WRSI14.5, IIF(MIN(WRSI14.4, 2) > WRSI14.6 AND WRSI14.6 < MIN(WRSI14.8, 2), WRSI14.6, IIF(MIN(WRSI14.5, 2) > WRSI14.7 AND WRSI14.7 < MIN(WRSI14.9, 2), WRSI14.7, IIF(MIN(WRSI14.6, 2) > WRSI14.8 AND WRSI14.8 < MIN(WRSI14.10, 2), WRSI14.8, IIF(MIN(WRSI14.7, 2) > WRSI14.9 AND WRSI14.9 < MIN(WRSI14.11, 2), WRSI14.9, IIF(MIN(WRSI14.8, 2) > WRSI14.10 AND WRSI14.10 < MIN(WRSI14.12, 2), WRSI14.10, IIF(MIN(WRSI14.9, 2) > WRSI14.11 AND WRSI14.11 < MIN(WRSI14.13, 2), WRSI14.11, IIF(MIN(WRSI14.10, 2) > WRSI14.12 AND WRSI14.12 < MIN(WRSI14.14, 2), WRSI14.12, IIF(MIN(WRSI14.11, 2) > WRSI14.13 AND WRSI14.13 < MIN(WRSI14.15, 2), WRSI14.13, IIF(MIN(WRSI14.12, 2) > WRSI14.14 AND WRSI14.14 < MIN(WRSI14.16, 2), WRSI14.14, IIF(MIN(WRSI14.13, 2) > WRSI14.15 AND WRSI14.15 < MIN(WRSI14.17, 2), WRSI14.15, IIF(MIN(WRSI14.14, 2) > WRSI14.16 AND WRSI14.16 < MIN(WRSI14.18, 2), WRSI14.16, IIF(MIN(WRSI14.15, 2) > WRSI14.17 AND WRSI14.17 < MIN(WRSI14.19, 2), WRSI14.17, IIF(MIN(WRSI14.16, 2) > WRSI14.18 AND WRSI14.18 < MIN(WRSI14.20, 2), WRSI14.18, IIF(MIN(WRSI14.17, 2) > WRSI14.19 AND WRSI14.19 < MIN(WRSI14.21, 2), WRSI14.19, IIF(MIN(WRSI14.18, 2) > WRSI14.20 AND WRSI14.20 < MIN(WRSI14.22, 2), WRSI14.20, IIF(MIN(WRSI14.19, 2) > WRSI14.21 AND WRSI14.21 < MIN(WRSI14.23, 2), WRSI14.21, IIF(MIN(WRSI14.20, 2) > WRSI14.22 AND WRSI14.22 < MIN(WRSI14.24, 2), WRSI14.22, IIF(MIN(WRSI14.21, 2) > WRSI14.23 AND WRSI14.23 < MIN(WRSI14.25, 2), WRSI14.23, IIF(MIN(WRSI14.22, 2) > WRSI14.24 AND WRSI14.24 < MIN(WRSI14.26, 2), WRSI14.24, IIF(MIN(WRSI14.23, 2) > WRSI14.25 AND WRSI14.25 < MIN(WRSI14.27, 2), WRSI14.25, IIF(MIN(WRSI14.24, 2) > WRSI14.26 AND WRSI14.26 < MIN(WRSI14.28, 2), WRSI14.26, IIF(MIN(WRSI14.25, 2) > WRSI14.27 AND WRSI14.27 < MIN(WRSI14.29, 2), WRSI14.27, IIF(MIN(WRSI14.26, 2) > WRSI14.28 AND WRSI14.28 < MIN(WRSI14.30, 2), WRSI14.28, IIF(MIN(WRSI14.27, 2) > WRSI14.29 AND WRSI14.29 < MIN(WRSI14.31, 2), WRSI14.29, IIF(MIN(WRSI14.28, 2) > WRSI14.30 AND WRSI14.30 < MIN(WRSI14.32, 2), WRSI14.30, IIF(MIN(WRSI14.29, 2) > WRSI14.31 AND WRSI14.31 < MIN(WRSI14.33, 2), WRSI14.31, IIF(MIN(WRSI14.30, 2) > WRSI14.32 AND WRSI14.32 < MIN(WRSI14.34, 2), WRSI14.32, IIF(MIN(WRSI14.31, 2) > WRSI14.33 AND WRSI14.33 < MIN(WRSI14.35, 2), WRSI14.33, IIF(MIN(WRSI14.32, 2) > WRSI14.34 AND WRSI14.34 < MIN(WRSI14.36, 2), WRSI14.34, IIF(MIN(WRSI14.33, 2) > WRSI14.35 AND WRSI14.35 < MIN(WRSI14.37, 2), WRSI14.35, IIF(MIN(WRSI14.34, 2) > WRSI14.36 AND WRSI14.36 < MIN(WRSI14.38, 2), WRSI14.36, IIF(MIN(WRSI14.35, 2) > WRSI14.37 AND WRSI14.37 < MIN(WRSI14.39, 2), WRSI14.37, IIF(MIN(WRSI14.36, 2) > WRSI14.38 AND WRSI14.38 < MIN(WRSI14.40, 2), WRSI14.38, IIF(MIN(WRSI14.37, 2) > WRSI14.39 AND WRSI14.39 < MIN(WRSI14.41, 2), WRSI14.39, IIF(MIN(WRSI14.38, 2) > WRSI14.40 AND WRSI14.40 < MIN(WRSI14.42, 2), WRSI14.40, IIF(MIN(WRSI14.39, 2) > WRSI14.41 AND WRSI14.41 < MIN(WRSI14.43, 2), WRSI14.41, IIF(MIN(WRSI14.40, 2) > WRSI14.42 AND WRSI14.42 < MIN(WRSI14.44, 2), WRSI14.42, IIF(MIN(WRSI14.41, 2) > WRSI14.43 AND WRSI14.43 < MIN(WRSI14.45, 2), WRSI14.43, IIF(MIN(WRSI14.42, 2) > WRSI14.44 AND WRSI14.44 < MIN(WRSI14.46, 2), WRSI14.44, IIF(MIN(WRSI14.43, 2) > WRSI14.45 AND WRSI14.45 < MIN(WRSI14.47, 2), WRSI14.45, IIF(MIN(WRSI14.44, 2) > WRSI14.46 AND WRSI14.46 < MIN(WRSI14.48, 2), WRSI14.46, IIF(MIN(WRSI14.45, 2) > WRSI14.47 AND WRSI14.47 < MIN(WRSI14.49, 2), WRSI14.47, IIF(MIN(WRSI14.46, 2) > WRSI14.48 AND WRSI14.48 < MIN(WRSI14.50, 2), WRSI14.48, IIF(MIN(WRSI14.47, 2) > WRSI14.49 AND WRSI14.49 < MIN(WRSI14.51, 2), WRSI14.49, IIF(MIN(WRSI14.48, 2) > WRSI14.50 AND WRSI14.50 < MIN(WRSI14.52, 2), WRSI14.50, IIF(MIN(WRSI14.49, 2) > WRSI14.51 AND WRSI14.51 < MIN(WRSI14.53, 2), WRSI14.51, IIF(MIN(WRSI14.50, 2) > WRSI14.52 AND WRSI14.52 < MIN(WRSI14.54, 2), WRSI14.52, IIF(MIN(WRSI14.51, 2) > WRSI14.53 AND WRSI14.53 < MIN(WRSI14.55, 2), WRSI14.53, IIF(MIN(WRSI14.52, 2) > WRSI14.54 AND WRSI14.54 < MIN(WRSI14.56, 2), WRSI14.54, IIF(MIN(WRSI14.53, 2) > WRSI14.55 AND WRSI14.55 < MIN(WRSI14.57, 2), WRSI14.55, IIF(MIN(WRSI14.54, 2) > WRSI14.56 AND WRSI14.56 < MIN(WRSI14.58, 2), WRSI14.56, IIF(MIN(WRSI14.55, 2) > WRSI14.57 AND WRSI14.57 < MIN(WRSI14.59, 2), WRSI14.57, IIF(MIN(WRSI14.56, 2) > WRSI14.58 AND WRSI14.58 < MIN(WRSI14.60, 2), WRSI14.58, IIF(MIN(WRSI14.57, 2) > WRSI14.59 AND WRSI14.59 < MIN(WRSI14.61, 2), WRSI14.59, IIF(MIN(WRSI14.58, 2) > WRSI14.60 AND WRSI14.60 < MIN(WRSI14.62, 2), WRSI14.60, IIF(MIN(WRSI14.59, 2) > WRSI14.61 AND WRSI14.61 < MIN(WRSI14.63, 2), WRSI14.61, IIF(MIN(WRSI14.60, 2) > WRSI14.62 AND WRSI14.62 < MIN(WRSI14.64, 2), WRSI14.62, IIF(MIN(WRSI14.61, 2) > WRSI14.63 AND WRSI14.63 < MIN(WRSI14.65, 2), WRSI14.63, IIF(MIN(WRSI14.62, 2) > WRSI14.64 AND WRSI14.64 < MIN(WRSI14.66, 2), WRSI14.64, IIF(MIN(WRSI14.63, 2) > WRSI14.65 AND WRSI14.65 < MIN(WRSI14.67, 2), WRSI14.65, IIF(MIN(WRSI14.64, 2) > WRSI14.66 AND WRSI14.66 < MIN(WRSI14.68, 2), WRSI14.66, IIF(MIN(WRSI14.65, 2) > WRSI14.67 AND WRSI14.67 < MIN(WRSI14.69, 2), WRSI14.67, 101))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)

Lower Low:

IIF(MIN(WRSI14, 2) > WRSI14.2 AND WRSI14.2 < MIN(WRSI14.3, 2) AND WRSI14.2 < IIF(MIN(WRSI14.3, 2) > WRSI14.5 AND WRSI14.5 < MIN(WRSI14.7, 2), WRSI14.5, IIF(MIN(WRSI14.4, 2) > WRSI14.6 AND WRSI14.6 < MIN(WRSI14.8, 2), WRSI14.6, IIF(MIN(WRSI14.5, 2) > WRSI14.7 AND WRSI14.7 < MIN(WRSI14.9, 2), WRSI14.7, IIF(MIN(WRSI14.6, 2) > WRSI14.8 AND WRSI14.8 < MIN(WRSI14.10, 2), WRSI14.8, IIF(MIN(WRSI14.7, 2) > WRSI14.9 AND WRSI14.9 < MIN(WRSI14.11, 2), WRSI14.9, IIF(MIN(WRSI14.8, 2) > WRSI14.10 AND WRSI14.10 < MIN(WRSI14.12, 2), WRSI14.10, IIF(MIN(WRSI14.9, 2) > WRSI14.11 AND WRSI14.11 < MIN(WRSI14.13, 2), WRSI14.11, IIF(MIN(WRSI14.10, 2) > WRSI14.12 AND WRSI14.12 < MIN(WRSI14.14, 2), WRSI14.12, IIF(MIN(WRSI14.11, 2) > WRSI14.13 AND WRSI14.13 < MIN(WRSI14.15, 2), WRSI14.13, IIF(MIN(WRSI14.12, 2) > WRSI14.14 AND WRSI14.14 < MIN(WRSI14.16, 2), WRSI14.14, IIF(MIN(WRSI14.13, 2) > WRSI14.15 AND WRSI14.15 < MIN(WRSI14.17, 2), WRSI14.15, IIF(MIN(WRSI14.14, 2) > WRSI14.16 AND WRSI14.16 < MIN(WRSI14.18, 2), WRSI14.16, IIF(MIN(WRSI14.15, 2) > WRSI14.17 AND WRSI14.17 < MIN(WRSI14.19, 2), WRSI14.17, IIF(MIN(WRSI14.16, 2) > WRSI14.18 AND WRSI14.18 < MIN(WRSI14.20, 2), WRSI14.18, IIF(MIN(WRSI14.17, 2) > WRSI14.19 AND WRSI14.19 < MIN(WRSI14.21, 2), WRSI14.19, IIF(MIN(WRSI14.18, 2) > WRSI14.20 AND WRSI14.20 < MIN(WRSI14.22, 2), WRSI14.20, IIF(MIN(WRSI14.19, 2) > WRSI14.21 AND WRSI14.21 < MIN(WRSI14.23, 2), WRSI14.21, IIF(MIN(WRSI14.20, 2) > WRSI14.22 AND WRSI14.22 < MIN(WRSI14.24, 2), WRSI14.22, IIF(MIN(WRSI14.21, 2) > WRSI14.23 AND WRSI14.23 < MIN(WRSI14.25, 2), WRSI14.23, IIF(MIN(WRSI14.22, 2) > WRSI14.24 AND WRSI14.24 < MIN(WRSI14.26, 2), WRSI14.24, IIF(MIN(WRSI14.23, 2) > WRSI14.25 AND WRSI14.25 < MIN(WRSI14.27, 2), WRSI14.25, IIF(MIN(WRSI14.24, 2) > WRSI14.26 AND WRSI14.26 < MIN(WRSI14.28, 2), WRSI14.26, IIF(MIN(WRSI14.25, 2) > WRSI14.27 AND WRSI14.27 < MIN(WRSI14.29, 2), WRSI14.27, IIF(MIN(WRSI14.26, 2) > WRSI14.28 AND WRSI14.28 < MIN(WRSI14.30, 2), WRSI14.28, IIF(MIN(WRSI14.27, 2) > WRSI14.29 AND WRSI14.29 < MIN(WRSI14.31, 2), WRSI14.29, IIF(MIN(WRSI14.28, 2) > WRSI14.30 AND WRSI14.30 < MIN(WRSI14.32, 2), WRSI14.30, IIF(MIN(WRSI14.29, 2) > WRSI14.31 AND WRSI14.31 < MIN(WRSI14.33, 2), WRSI14.31, IIF(MIN(WRSI14.30, 2) > WRSI14.32 AND WRSI14.32 < MIN(WRSI14.34, 2), WRSI14.32, IIF(MIN(WRSI14.31, 2) > WRSI14.33 AND WRSI14.33 < MIN(WRSI14.35, 2), WRSI14.33, IIF(MIN(WRSI14.32, 2) > WRSI14.34 AND WRSI14.34 < MIN(WRSI14.36, 2), WRSI14.34, IIF(MIN(WRSI14.33, 2) > WRSI14.35 AND WRSI14.35 < MIN(WRSI14.37, 2), WRSI14.35, IIF(MIN(WRSI14.34, 2) > WRSI14.36 AND WRSI14.36 < MIN(WRSI14.38, 2), WRSI14.36, IIF(MIN(WRSI14.35, 2) > WRSI14.37 AND WRSI14.37 < MIN(WRSI14.39, 2), WRSI14.37, IIF(MIN(WRSI14.36, 2) > WRSI14.38 AND WRSI14.38 < MIN(WRSI14.40, 2), WRSI14.38, IIF(MIN(WRSI14.37, 2) > WRSI14.39 AND WRSI14.39 < MIN(WRSI14.41, 2), WRSI14.39, IIF(MIN(WRSI14.38, 2) > WRSI14.40 AND WRSI14.40 < MIN(WRSI14.42, 2), WRSI14.40, IIF(MIN(WRSI14.39, 2) > WRSI14.41 AND WRSI14.41 < MIN(WRSI14.43, 2), WRSI14.41, IIF(MIN(WRSI14.40, 2) > WRSI14.42 AND WRSI14.42 < MIN(WRSI14.44, 2), WRSI14.42, IIF(MIN(WRSI14.41, 2) > WRSI14.43 AND WRSI14.43 < MIN(WRSI14.45, 2), WRSI14.43, IIF(MIN(WRSI14.42, 2) > WRSI14.44 AND WRSI14.44 < MIN(WRSI14.46, 2), WRSI14.44, IIF(MIN(WRSI14.43, 2) > WRSI14.45 AND WRSI14.45 < MIN(WRSI14.47, 2), WRSI14.45, IIF(MIN(WRSI14.44, 2) > WRSI14.46 AND WRSI14.46 < MIN(WRSI14.48, 2), WRSI14.46, IIF(MIN(WRSI14.45, 2) > WRSI14.47 AND WRSI14.47 < MIN(WRSI14.49, 2), WRSI14.47, IIF(MIN(WRSI14.46, 2) > WRSI14.48 AND WRSI14.48 < MIN(WRSI14.50, 2), WRSI14.48, IIF(MIN(WRSI14.47, 2) > WRSI14.49 AND WRSI14.49 < MIN(WRSI14.51, 2), WRSI14.49, IIF(MIN(WRSI14.48, 2) > WRSI14.50 AND WRSI14.50 < MIN(WRSI14.52, 2), WRSI14.50, IIF(MIN(WRSI14.49, 2) > WRSI14.51 AND WRSI14.51 < MIN(WRSI14.53, 2), WRSI14.51, IIF(MIN(WRSI14.50, 2) > WRSI14.52 AND WRSI14.52 < MIN(WRSI14.54, 2), WRSI14.52, IIF(MIN(WRSI14.51, 2) > WRSI14.53 AND WRSI14.53 < MIN(WRSI14.55, 2), WRSI14.53, IIF(MIN(WRSI14.52, 2) > WRSI14.54 AND WRSI14.54 < MIN(WRSI14.56, 2), WRSI14.54, IIF(MIN(WRSI14.53, 2) > WRSI14.55 AND WRSI14.55 < MIN(WRSI14.57, 2), WRSI14.55, IIF(MIN(WRSI14.54, 2) > WRSI14.56 AND WRSI14.56 < MIN(WRSI14.58, 2), WRSI14.56, IIF(MIN(WRSI14.55, 2) > WRSI14.57 AND WRSI14.57 < MIN(WRSI14.59, 2), WRSI14.57, IIF(MIN(WRSI14.56, 2) > WRSI14.58 AND WRSI14.58 < MIN(WRSI14.60, 2), WRSI14.58, IIF(MIN(WRSI14.57, 2) > WRSI14.59 AND WRSI14.59 < MIN(WRSI14.61, 2), WRSI14.59, IIF(MIN(WRSI14.58, 2) > WRSI14.60 AND WRSI14.60 < MIN(WRSI14.62, 2), WRSI14.60, IIF(MIN(WRSI14.59, 2) > WRSI14.61 AND WRSI14.61 < MIN(WRSI14.63, 2), WRSI14.61, IIF(MIN(WRSI14.60, 2) > WRSI14.62 AND WRSI14.62 < MIN(WRSI14.64, 2), WRSI14.62, IIF(MIN(WRSI14.61, 2) > WRSI14.63 AND WRSI14.63 < MIN(WRSI14.65, 2), WRSI14.63, IIF(MIN(WRSI14.62, 2) > WRSI14.64 AND WRSI14.64 < MIN(WRSI14.66, 2), WRSI14.64, IIF(MIN(WRSI14.63, 2) > WRSI14.65 AND WRSI14.65 < MIN(WRSI14.67, 2), WRSI14.65, IIF(MIN(WRSI14.64, 2) > WRSI14.66 AND WRSI14.66 < MIN(WRSI14.68, 2), WRSI14.66, IIF(MIN(WRSI14.65, 2) > WRSI14.67 AND WRSI14.67 < MIN(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, January 10, 2018 12:54:42 PM
Registered User
Joined: 3/10/2012
Posts: 465

Excellent Bruce it works perfect, 

one last thing whenever u have a chance ,,,if i can please get help in making the above PCF little more responsive

so what i need is to have first LL  AS TRUE then LH AS TRUE then HL AS TRUE  ONCE ALL THREE DOTS ARE TRUE HAPPENS in a sequence  BELOW WRSI50 level then show me a spike  FOR SCANNING 

LL -LH- HL true in sequence then show spike  EXAMPLE ROKU" ON 130 MIN CHART 

and same for INVERSE

HH- HL - LH if TRUE IN sequence ABOVE 50 then show spike Example " ANTM ON 130 MIN CHART

 

Thanks 

Dhiren

 

Bruce_L
Posted : Wednesday, January 10, 2018 1:08:43 PM


Worden Trainer

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

Sorry, but that is not happening. You can theoretically use SinceTrue (or better yet TrueInRow maybe using the Not function) to determine the sequence, but the resulting formulas are too long and slow to be practical or post in the forums.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, January 10, 2018 3:59:15 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce can u please give an example of pcf how would i use since true or true in toe func ,,, like if i want 

just LL and LH to be true in row so how would we write that  ?

or HH and HL true in row or since true how would we write that  ?

 

thanks

Bruce_L
Posted : Wednesday, January 10, 2018 4:44:17 PM


Worden Trainer

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

The more I think about it and play with it, the more I think it is way more difficult than I was thinking earlier.

Even if I write a formula checking that the most recent instances of LL, LH, and HL happen in that order, this doesn't check anything at all about HH or if maybe there was a HL between the most recent LL and LH (and there isn't any reasonable way to do so). I also can't think of any reasonable way to check for all of these values being below 50.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Wednesday, January 10, 2018 4:51:35 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce a while back for the fractal formula you did this for me ... where if LL - LH in a row is true then +1 and LH - LL in a row is true then -1  

so its the same concept that i want to apply on RSI , 

this is the formula

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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 1, 0) + 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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), -1, 0)
 
Bruce_L
Posted : Thursday, January 11, 2018 10:10:35 AM


Worden Trainer

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

That isn't what it does. All it does is check for both a lower high and a lower low. If there is a lower high it adds 1 to the value and if there is a lower low, it adds -1 to the value.

IIF(MAX(WRSI14, 2) < WRSI14.2 AND WRSI14.2 > MAX(WRSI14.3, 2) AND WRSI14.2 < IIF(MAX(WRSI14.3, 2) < WRSI14.5 AND WRSI14.5 > MAX(WRSI14.7, 2), WRSI14.5, IIF(MAX(WRSI14.4, 2) < WRSI14.6 AND WRSI14.6 > MAX(WRSI14.8, 2), WRSI14.6, IIF(MAX(WRSI14.5, 2) < WRSI14.7 AND WRSI14.7 > MAX(WRSI14.9, 2), WRSI14.7, IIF(MAX(WRSI14.6, 2) < WRSI14.8 AND WRSI14.8 > MAX(WRSI14.10, 2), WRSI14.8, IIF(MAX(WRSI14.7, 2) < WRSI14.9 AND WRSI14.9 > MAX(WRSI14.11, 2), WRSI14.9, IIF(MAX(WRSI14.8, 2) < WRSI14.10 AND WRSI14.10 > MAX(WRSI14.12, 2), WRSI14.10, IIF(MAX(WRSI14.9, 2) < WRSI14.11 AND WRSI14.11 > MAX(WRSI14.13, 2), WRSI14.11, IIF(MAX(WRSI14.10, 2) < WRSI14.12 AND WRSI14.12 > MAX(WRSI14.14, 2), WRSI14.12, IIF(MAX(WRSI14.11, 2) < WRSI14.13 AND WRSI14.13 > MAX(WRSI14.15, 2), WRSI14.13, IIF(MAX(WRSI14.12, 2) < WRSI14.14 AND WRSI14.14 > MAX(WRSI14.16, 2), WRSI14.14, IIF(MAX(WRSI14.13, 2) < WRSI14.15 AND WRSI14.15 > MAX(WRSI14.17, 2), WRSI14.15, IIF(MAX(WRSI14.14, 2) < WRSI14.16 AND WRSI14.16 > MAX(WRSI14.18, 2), WRSI14.16, IIF(MAX(WRSI14.15, 2) < WRSI14.17 AND WRSI14.17 > MAX(WRSI14.19, 2), WRSI14.17, IIF(MAX(WRSI14.16, 2) < WRSI14.18 AND WRSI14.18 > MAX(WRSI14.20, 2), WRSI14.18, IIF(MAX(WRSI14.17, 2) < WRSI14.19 AND WRSI14.19 > MAX(WRSI14.21, 2), WRSI14.19, IIF(MAX(WRSI14.18, 2) < WRSI14.20 AND WRSI14.20 > MAX(WRSI14.22, 2), WRSI14.20, IIF(MAX(WRSI14.19, 2) < WRSI14.21 AND WRSI14.21 > MAX(WRSI14.23, 2), WRSI14.21, IIF(MAX(WRSI14.20, 2) < WRSI14.22 AND WRSI14.22 > MAX(WRSI14.24, 2), WRSI14.22, IIF(MAX(WRSI14.21, 2) < WRSI14.23 AND WRSI14.23 > MAX(WRSI14.25, 2), WRSI14.23, IIF(MAX(WRSI14.22, 2) < WRSI14.24 AND WRSI14.24 > MAX(WRSI14.26, 2), WRSI14.24, IIF(MAX(WRSI14.23, 2) < WRSI14.25 AND WRSI14.25 > MAX(WRSI14.27, 2), WRSI14.25, IIF(MAX(WRSI14.24, 2) < WRSI14.26 AND WRSI14.26 > MAX(WRSI14.28, 2), WRSI14.26, IIF(MAX(WRSI14.25, 2) < WRSI14.27 AND WRSI14.27 > MAX(WRSI14.29, 2), WRSI14.27, IIF(MAX(WRSI14.26, 2) < WRSI14.28 AND WRSI14.28 > MAX(WRSI14.30, 2), WRSI14.28, IIF(MAX(WRSI14.27, 2) < WRSI14.29 AND WRSI14.29 > MAX(WRSI14.31, 2), WRSI14.29, IIF(MAX(WRSI14.28, 2) < WRSI14.30 AND WRSI14.30 > MAX(WRSI14.32, 2), WRSI14.30, IIF(MAX(WRSI14.29, 2) < WRSI14.31 AND WRSI14.31 > MAX(WRSI14.33, 2), WRSI14.31, IIF(MAX(WRSI14.30, 2) < WRSI14.32 AND WRSI14.32 > MAX(WRSI14.34, 2), WRSI14.32, IIF(MAX(WRSI14.31, 2) < WRSI14.33 AND WRSI14.33 > MAX(WRSI14.35, 2), WRSI14.33, IIF(MAX(WRSI14.32, 2) < WRSI14.34 AND WRSI14.34 > MAX(WRSI14.36, 2), WRSI14.34, IIF(MAX(WRSI14.33, 2) < WRSI14.35 AND WRSI14.35 > MAX(WRSI14.37, 2), WRSI14.35, IIF(MAX(WRSI14.34, 2) < WRSI14.36 AND WRSI14.36 > MAX(WRSI14.38, 2), WRSI14.36, IIF(MAX(WRSI14.35, 2) < WRSI14.37 AND WRSI14.37 > MAX(WRSI14.39, 2), WRSI14.37, IIF(MAX(WRSI14.36, 2) < WRSI14.38 AND WRSI14.38 > MAX(WRSI14.40, 2), WRSI14.38, IIF(MAX(WRSI14.37, 2) < WRSI14.39 AND WRSI14.39 > MAX(WRSI14.41, 2), WRSI14.39, IIF(MAX(WRSI14.38, 2) < WRSI14.40 AND WRSI14.40 > MAX(WRSI14.42, 2), WRSI14.40, IIF(MAX(WRSI14.39, 2) < WRSI14.41 AND WRSI14.41 > MAX(WRSI14.43, 2), WRSI14.41, IIF(MAX(WRSI14.40, 2) < WRSI14.42 AND WRSI14.42 > MAX(WRSI14.44, 2), WRSI14.42, IIF(MAX(WRSI14.41, 2) < WRSI14.43 AND WRSI14.43 > MAX(WRSI14.45, 2), WRSI14.43, IIF(MAX(WRSI14.42, 2) < WRSI14.44 AND WRSI14.44 > MAX(WRSI14.46, 2), WRSI14.44, IIF(MAX(WRSI14.43, 2) < WRSI14.45 AND WRSI14.45 > MAX(WRSI14.47, 2), WRSI14.45, IIF(MAX(WRSI14.44, 2) < WRSI14.46 AND WRSI14.46 > MAX(WRSI14.48, 2), WRSI14.46, IIF(MAX(WRSI14.45, 2) < WRSI14.47 AND WRSI14.47 > MAX(WRSI14.49, 2), WRSI14.47, IIF(MAX(WRSI14.46, 2) < WRSI14.48 AND WRSI14.48 > MAX(WRSI14.50, 2), WRSI14.48, IIF(MAX(WRSI14.47, 2) < WRSI14.49 AND WRSI14.49 > MAX(WRSI14.51, 2), WRSI14.49, IIF(MAX(WRSI14.48, 2) < WRSI14.50 AND WRSI14.50 > MAX(WRSI14.52, 2), WRSI14.50, IIF(MAX(WRSI14.49, 2) < WRSI14.51 AND WRSI14.51 > MAX(WRSI14.53, 2), WRSI14.51, IIF(MAX(WRSI14.50, 2) < WRSI14.52 AND WRSI14.52 > MAX(WRSI14.54, 2), WRSI14.52, IIF(MAX(WRSI14.51, 2) < WRSI14.53 AND WRSI14.53 > MAX(WRSI14.55, 2), WRSI14.53, IIF(MAX(WRSI14.52, 2) < WRSI14.54 AND WRSI14.54 > MAX(WRSI14.56, 2), WRSI14.54, IIF(MAX(WRSI14.53, 2) < WRSI14.55 AND WRSI14.55 > MAX(WRSI14.57, 2), WRSI14.55, IIF(MAX(WRSI14.54, 2) < WRSI14.56 AND WRSI14.56 > MAX(WRSI14.58, 2), WRSI14.56, IIF(MAX(WRSI14.55, 2) < WRSI14.57 AND WRSI14.57 > MAX(WRSI14.59, 2), WRSI14.57, IIF(MAX(WRSI14.56, 2) < WRSI14.58 AND WRSI14.58 > MAX(WRSI14.60, 2), WRSI14.58, IIF(MAX(WRSI14.57, 2) < WRSI14.59 AND WRSI14.59 > MAX(WRSI14.61, 2), WRSI14.59, IIF(MAX(WRSI14.58, 2) < WRSI14.60 AND WRSI14.60 > MAX(WRSI14.62, 2), WRSI14.60, IIF(MAX(WRSI14.59, 2) < WRSI14.61 AND WRSI14.61 > MAX(WRSI14.63, 2), WRSI14.61, IIF(MAX(WRSI14.60, 2) < WRSI14.62 AND WRSI14.62 > MAX(WRSI14.64, 2), WRSI14.62, IIF(MAX(WRSI14.61, 2) < WRSI14.63 AND WRSI14.63 > MAX(WRSI14.65, 2), WRSI14.63, IIF(MAX(WRSI14.62, 2) < WRSI14.64 AND WRSI14.64 > MAX(WRSI14.66, 2), WRSI14.64, IIF(MAX(WRSI14.63, 2) < WRSI14.65 AND WRSI14.65 > MAX(WRSI14.67, 2), WRSI14.65, IIF(MAX(WRSI14.64, 2) < WRSI14.66 AND WRSI14.66 > MAX(WRSI14.68, 2), WRSI14.66, IIF(MAX(WRSI14.65, 2) < WRSI14.67 AND WRSI14.67 > MAX(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 1, 0) + IIF(MIN(WRSI14, 2) > WRSI14.2 AND WRSI14.2 < MIN(WRSI14.3, 2) AND WRSI14.2 < IIF(MIN(WRSI14.3, 2) > WRSI14.5 AND WRSI14.5 < MIN(WRSI14.7, 2), WRSI14.5, IIF(MIN(WRSI14.4, 2) > WRSI14.6 AND WRSI14.6 < MIN(WRSI14.8, 2), WRSI14.6, IIF(MIN(WRSI14.5, 2) > WRSI14.7 AND WRSI14.7 < MIN(WRSI14.9, 2), WRSI14.7, IIF(MIN(WRSI14.6, 2) > WRSI14.8 AND WRSI14.8 < MIN(WRSI14.10, 2), WRSI14.8, IIF(MIN(WRSI14.7, 2) > WRSI14.9 AND WRSI14.9 < MIN(WRSI14.11, 2), WRSI14.9, IIF(MIN(WRSI14.8, 2) > WRSI14.10 AND WRSI14.10 < MIN(WRSI14.12, 2), WRSI14.10, IIF(MIN(WRSI14.9, 2) > WRSI14.11 AND WRSI14.11 < MIN(WRSI14.13, 2), WRSI14.11, IIF(MIN(WRSI14.10, 2) > WRSI14.12 AND WRSI14.12 < MIN(WRSI14.14, 2), WRSI14.12, IIF(MIN(WRSI14.11, 2) > WRSI14.13 AND WRSI14.13 < MIN(WRSI14.15, 2), WRSI14.13, IIF(MIN(WRSI14.12, 2) > WRSI14.14 AND WRSI14.14 < MIN(WRSI14.16, 2), WRSI14.14, IIF(MIN(WRSI14.13, 2) > WRSI14.15 AND WRSI14.15 < MIN(WRSI14.17, 2), WRSI14.15, IIF(MIN(WRSI14.14, 2) > WRSI14.16 AND WRSI14.16 < MIN(WRSI14.18, 2), WRSI14.16, IIF(MIN(WRSI14.15, 2) > WRSI14.17 AND WRSI14.17 < MIN(WRSI14.19, 2), WRSI14.17, IIF(MIN(WRSI14.16, 2) > WRSI14.18 AND WRSI14.18 < MIN(WRSI14.20, 2), WRSI14.18, IIF(MIN(WRSI14.17, 2) > WRSI14.19 AND WRSI14.19 < MIN(WRSI14.21, 2), WRSI14.19, IIF(MIN(WRSI14.18, 2) > WRSI14.20 AND WRSI14.20 < MIN(WRSI14.22, 2), WRSI14.20, IIF(MIN(WRSI14.19, 2) > WRSI14.21 AND WRSI14.21 < MIN(WRSI14.23, 2), WRSI14.21, IIF(MIN(WRSI14.20, 2) > WRSI14.22 AND WRSI14.22 < MIN(WRSI14.24, 2), WRSI14.22, IIF(MIN(WRSI14.21, 2) > WRSI14.23 AND WRSI14.23 < MIN(WRSI14.25, 2), WRSI14.23, IIF(MIN(WRSI14.22, 2) > WRSI14.24 AND WRSI14.24 < MIN(WRSI14.26, 2), WRSI14.24, IIF(MIN(WRSI14.23, 2) > WRSI14.25 AND WRSI14.25 < MIN(WRSI14.27, 2), WRSI14.25, IIF(MIN(WRSI14.24, 2) > WRSI14.26 AND WRSI14.26 < MIN(WRSI14.28, 2), WRSI14.26, IIF(MIN(WRSI14.25, 2) > WRSI14.27 AND WRSI14.27 < MIN(WRSI14.29, 2), WRSI14.27, IIF(MIN(WRSI14.26, 2) > WRSI14.28 AND WRSI14.28 < MIN(WRSI14.30, 2), WRSI14.28, IIF(MIN(WRSI14.27, 2) > WRSI14.29 AND WRSI14.29 < MIN(WRSI14.31, 2), WRSI14.29, IIF(MIN(WRSI14.28, 2) > WRSI14.30 AND WRSI14.30 < MIN(WRSI14.32, 2), WRSI14.30, IIF(MIN(WRSI14.29, 2) > WRSI14.31 AND WRSI14.31 < MIN(WRSI14.33, 2), WRSI14.31, IIF(MIN(WRSI14.30, 2) > WRSI14.32 AND WRSI14.32 < MIN(WRSI14.34, 2), WRSI14.32, IIF(MIN(WRSI14.31, 2) > WRSI14.33 AND WRSI14.33 < MIN(WRSI14.35, 2), WRSI14.33, IIF(MIN(WRSI14.32, 2) > WRSI14.34 AND WRSI14.34 < MIN(WRSI14.36, 2), WRSI14.34, IIF(MIN(WRSI14.33, 2) > WRSI14.35 AND WRSI14.35 < MIN(WRSI14.37, 2), WRSI14.35, IIF(MIN(WRSI14.34, 2) > WRSI14.36 AND WRSI14.36 < MIN(WRSI14.38, 2), WRSI14.36, IIF(MIN(WRSI14.35, 2) > WRSI14.37 AND WRSI14.37 < MIN(WRSI14.39, 2), WRSI14.37, IIF(MIN(WRSI14.36, 2) > WRSI14.38 AND WRSI14.38 < MIN(WRSI14.40, 2), WRSI14.38, IIF(MIN(WRSI14.37, 2) > WRSI14.39 AND WRSI14.39 < MIN(WRSI14.41, 2), WRSI14.39, IIF(MIN(WRSI14.38, 2) > WRSI14.40 AND WRSI14.40 < MIN(WRSI14.42, 2), WRSI14.40, IIF(MIN(WRSI14.39, 2) > WRSI14.41 AND WRSI14.41 < MIN(WRSI14.43, 2), WRSI14.41, IIF(MIN(WRSI14.40, 2) > WRSI14.42 AND WRSI14.42 < MIN(WRSI14.44, 2), WRSI14.42, IIF(MIN(WRSI14.41, 2) > WRSI14.43 AND WRSI14.43 < MIN(WRSI14.45, 2), WRSI14.43, IIF(MIN(WRSI14.42, 2) > WRSI14.44 AND WRSI14.44 < MIN(WRSI14.46, 2), WRSI14.44, IIF(MIN(WRSI14.43, 2) > WRSI14.45 AND WRSI14.45 < MIN(WRSI14.47, 2), WRSI14.45, IIF(MIN(WRSI14.44, 2) > WRSI14.46 AND WRSI14.46 < MIN(WRSI14.48, 2), WRSI14.46, IIF(MIN(WRSI14.45, 2) > WRSI14.47 AND WRSI14.47 < MIN(WRSI14.49, 2), WRSI14.47, IIF(MIN(WRSI14.46, 2) > WRSI14.48 AND WRSI14.48 < MIN(WRSI14.50, 2), WRSI14.48, IIF(MIN(WRSI14.47, 2) > WRSI14.49 AND WRSI14.49 < MIN(WRSI14.51, 2), WRSI14.49, IIF(MIN(WRSI14.48, 2) > WRSI14.50 AND WRSI14.50 < MIN(WRSI14.52, 2), WRSI14.50, IIF(MIN(WRSI14.49, 2) > WRSI14.51 AND WRSI14.51 < MIN(WRSI14.53, 2), WRSI14.51, IIF(MIN(WRSI14.50, 2) > WRSI14.52 AND WRSI14.52 < MIN(WRSI14.54, 2), WRSI14.52, IIF(MIN(WRSI14.51, 2) > WRSI14.53 AND WRSI14.53 < MIN(WRSI14.55, 2), WRSI14.53, IIF(MIN(WRSI14.52, 2) > WRSI14.54 AND WRSI14.54 < MIN(WRSI14.56, 2), WRSI14.54, IIF(MIN(WRSI14.53, 2) > WRSI14.55 AND WRSI14.55 < MIN(WRSI14.57, 2), WRSI14.55, IIF(MIN(WRSI14.54, 2) > WRSI14.56 AND WRSI14.56 < MIN(WRSI14.58, 2), WRSI14.56, IIF(MIN(WRSI14.55, 2) > WRSI14.57 AND WRSI14.57 < MIN(WRSI14.59, 2), WRSI14.57, IIF(MIN(WRSI14.56, 2) > WRSI14.58 AND WRSI14.58 < MIN(WRSI14.60, 2), WRSI14.58, IIF(MIN(WRSI14.57, 2) > WRSI14.59 AND WRSI14.59 < MIN(WRSI14.61, 2), WRSI14.59, IIF(MIN(WRSI14.58, 2) > WRSI14.60 AND WRSI14.60 < MIN(WRSI14.62, 2), WRSI14.60, IIF(MIN(WRSI14.59, 2) > WRSI14.61 AND WRSI14.61 < MIN(WRSI14.63, 2), WRSI14.61, IIF(MIN(WRSI14.60, 2) > WRSI14.62 AND WRSI14.62 < MIN(WRSI14.64, 2), WRSI14.62, IIF(MIN(WRSI14.61, 2) > WRSI14.63 AND WRSI14.63 < MIN(WRSI14.65, 2), WRSI14.63, IIF(MIN(WRSI14.62, 2) > WRSI14.64 AND WRSI14.64 < MIN(WRSI14.66, 2), WRSI14.64, IIF(MIN(WRSI14.63, 2) > WRSI14.65 AND WRSI14.65 < MIN(WRSI14.67, 2), WRSI14.65, IIF(MIN(WRSI14.64, 2) > WRSI14.66 AND WRSI14.66 < MIN(WRSI14.68, 2), WRSI14.66, IIF(MIN(WRSI14.65, 2) > WRSI14.67 AND WRSI14.67 < MIN(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), -1, 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Thursday, January 11, 2018 10:42:02 AM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce this is perfect that will work for me,,, but can u please give me a template so i can fill in myself  the above 4 PCF you did from your post Tuesday, January 09, 2018 3:59:18 PM 

Like  if i want to have HH AND HL in a row then i just fill in that template your formula 

same if i want HH AND LL in a row then i can fill in the template or if i want HH AND LH ina row then i can fill in that template 

or HL AND LL in a row so i can fill in the template 

thanks for all your inputs 

Appreciate 

Dhiren

Bruce_L
Posted : Thursday, January 11, 2018 10:48:32 AM


Worden Trainer

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

The template is pretty straightforward.

IIF(Boolean formula here, 1, 0) + IIF(Boolean formula here, -1, 0)

But you can't just use the formulas from the Tuesday, January 09, 2018 3:59:18 PM ET post because those formulas return numeric values instead of being Boolean (returning true or false.)

Really a better option is to modify those formulas and then put a + in between them.

Replace the WRSI14.2, -10) at the end with either 1, 0) or -1, 0) depending on if it is the formula you want to use to add 1 or the formula you want to use to add -1.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Thursday, January 11, 2018 11:05:41 AM
Registered User
Joined: 3/10/2012
Posts: 465

Awesome Bruce thankyou so very much that helps to play with many other formulas

Cheers

dhirenshah
Posted : Thursday, January 25, 2018 2:33:28 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce i m having trouble making PCF similar to your Tuesday, January 09, 2018 3:59:18 PM

I want to make for stochastic using the settings as period 5  %k 2 and %D 3 averages simple

I need HH -LH HL and LL on stochastic

if you can please help whenever u have time 

thanks 

Dhiren

Bruce_L
Posted : Friday, January 26, 2018 10:24:23 AM


Worden Trainer

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

Higher High:

IIF(MAX(AVG(STOC5.2, 3), 2) < AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) > MAX(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) > IIF(MAX(AVG(STOC5.2.3, 3), 2) < AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) > MAX(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MAX(AVG(STOC5.2.4, 3), 2) < AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) > MAX(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MAX(AVG(STOC5.2.5, 3), 2) < AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) > MAX(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MAX(AVG(STOC5.2.6, 3), 2) < AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) > MAX(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MAX(AVG(STOC5.2.7, 3), 2) < AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) > MAX(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MAX(AVG(STOC5.2.8, 3), 2) < AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) > MAX(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MAX(AVG(STOC5.2.9, 3), 2) < AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) > MAX(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MAX(AVG(STOC5.2.10, 3), 2) < AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) > MAX(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MAX(AVG(STOC5.2.11, 3), 2) < AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) > MAX(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MAX(AVG(STOC5.2.12, 3), 2) < AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) > MAX(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MAX(AVG(STOC5.2.13, 3), 2) < AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) > MAX(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MAX(AVG(STOC5.2.14, 3), 2) < AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) > MAX(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MAX(AVG(STOC5.2.15, 3), 2) < AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) > MAX(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MAX(AVG(STOC5.2.16, 3), 2) < AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) > MAX(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MAX(AVG(STOC5.2.17, 3), 2) < AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) > MAX(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MAX(AVG(STOC5.2.18, 3), 2) < AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) > MAX(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MAX(AVG(STOC5.2.19, 3), 2) < AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) > MAX(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MAX(AVG(STOC5.2.20, 3), 2) < AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) > MAX(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MAX(AVG(STOC5.2.21, 3), 2) < AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) > MAX(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MAX(AVG(STOC5.2.22, 3), 2) < AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) > MAX(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MAX(AVG(STOC5.2.23, 3), 2) < AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) > MAX(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MAX(AVG(STOC5.2.24, 3), 2) < AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) > MAX(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MAX(AVG(STOC5.2.25, 3), 2) < AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) > MAX(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MAX(AVG(STOC5.2.26, 3), 2) < AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) > MAX(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MAX(AVG(STOC5.2.27, 3), 2) < AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) > MAX(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MAX(AVG(STOC5.2.28, 3), 2) < AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) > MAX(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MAX(AVG(STOC5.2.29, 3), 2) < AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) > MAX(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MAX(AVG(STOC5.2.30, 3), 2) < AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) > MAX(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MAX(AVG(STOC5.2.31, 3), 2) < AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) > MAX(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MAX(AVG(STOC5.2.32, 3), 2) < AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) > MAX(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MAX(AVG(STOC5.2.33, 3), 2) < AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) > MAX(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), 101))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)

Lower High:

IIF(MAX(AVG(STOC5.2, 3), 2) < AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) > MAX(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) < IIF(MAX(AVG(STOC5.2.3, 3), 2) < AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) > MAX(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MAX(AVG(STOC5.2.4, 3), 2) < AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) > MAX(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MAX(AVG(STOC5.2.5, 3), 2) < AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) > MAX(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MAX(AVG(STOC5.2.6, 3), 2) < AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) > MAX(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MAX(AVG(STOC5.2.7, 3), 2) < AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) > MAX(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MAX(AVG(STOC5.2.8, 3), 2) < AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) > MAX(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MAX(AVG(STOC5.2.9, 3), 2) < AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) > MAX(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MAX(AVG(STOC5.2.10, 3), 2) < AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) > MAX(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MAX(AVG(STOC5.2.11, 3), 2) < AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) > MAX(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MAX(AVG(STOC5.2.12, 3), 2) < AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) > MAX(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MAX(AVG(STOC5.2.13, 3), 2) < AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) > MAX(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MAX(AVG(STOC5.2.14, 3), 2) < AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) > MAX(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MAX(AVG(STOC5.2.15, 3), 2) < AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) > MAX(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MAX(AVG(STOC5.2.16, 3), 2) < AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) > MAX(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MAX(AVG(STOC5.2.17, 3), 2) < AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) > MAX(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MAX(AVG(STOC5.2.18, 3), 2) < AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) > MAX(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MAX(AVG(STOC5.2.19, 3), 2) < AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) > MAX(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MAX(AVG(STOC5.2.20, 3), 2) < AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) > MAX(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MAX(AVG(STOC5.2.21, 3), 2) < AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) > MAX(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MAX(AVG(STOC5.2.22, 3), 2) < AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) > MAX(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MAX(AVG(STOC5.2.23, 3), 2) < AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) > MAX(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MAX(AVG(STOC5.2.24, 3), 2) < AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) > MAX(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MAX(AVG(STOC5.2.25, 3), 2) < AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) > MAX(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MAX(AVG(STOC5.2.26, 3), 2) < AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) > MAX(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MAX(AVG(STOC5.2.27, 3), 2) < AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) > MAX(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MAX(AVG(STOC5.2.28, 3), 2) < AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) > MAX(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MAX(AVG(STOC5.2.29, 3), 2) < AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) > MAX(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MAX(AVG(STOC5.2.30, 3), 2) < AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) > MAX(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MAX(AVG(STOC5.2.31, 3), 2) < AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) > MAX(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MAX(AVG(STOC5.2.32, 3), 2) < AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) > MAX(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MAX(AVG(STOC5.2.33, 3), 2) < AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) > MAX(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), -1))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)

Higher Low:

IIF(MIN(AVG(STOC5.2, 3), 2) > AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) < MIN(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) > IIF(MIN(AVG(STOC5.2.3, 3), 2) > AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) < MIN(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MIN(AVG(STOC5.2.4, 3), 2) > AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) < MIN(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MIN(AVG(STOC5.2.5, 3), 2) > AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) < MIN(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MIN(AVG(STOC5.2.6, 3), 2) > AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) < MIN(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MIN(AVG(STOC5.2.7, 3), 2) > AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) < MIN(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MIN(AVG(STOC5.2.8, 3), 2) > AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) < MIN(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MIN(AVG(STOC5.2.9, 3), 2) > AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) < MIN(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MIN(AVG(STOC5.2.10, 3), 2) > AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) < MIN(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MIN(AVG(STOC5.2.11, 3), 2) > AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) < MIN(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MIN(AVG(STOC5.2.12, 3), 2) > AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) < MIN(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MIN(AVG(STOC5.2.13, 3), 2) > AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) < MIN(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MIN(AVG(STOC5.2.14, 3), 2) > AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) < MIN(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MIN(AVG(STOC5.2.15, 3), 2) > AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) < MIN(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MIN(AVG(STOC5.2.16, 3), 2) > AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) < MIN(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MIN(AVG(STOC5.2.17, 3), 2) > AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) < MIN(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MIN(AVG(STOC5.2.18, 3), 2) > AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) < MIN(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MIN(AVG(STOC5.2.19, 3), 2) > AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) < MIN(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MIN(AVG(STOC5.2.20, 3), 2) > AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) < MIN(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MIN(AVG(STOC5.2.21, 3), 2) > AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) < MIN(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MIN(AVG(STOC5.2.22, 3), 2) > AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) < MIN(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MIN(AVG(STOC5.2.23, 3), 2) > AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) < MIN(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MIN(AVG(STOC5.2.24, 3), 2) > AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) < MIN(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MIN(AVG(STOC5.2.25, 3), 2) > AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) < MIN(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MIN(AVG(STOC5.2.26, 3), 2) > AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) < MIN(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MIN(AVG(STOC5.2.27, 3), 2) > AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) < MIN(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MIN(AVG(STOC5.2.28, 3), 2) > AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) < MIN(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MIN(AVG(STOC5.2.29, 3), 2) > AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) < MIN(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MIN(AVG(STOC5.2.30, 3), 2) > AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) < MIN(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MIN(AVG(STOC5.2.31, 3), 2) > AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) < MIN(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MIN(AVG(STOC5.2.32, 3), 2) > AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) < MIN(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MIN(AVG(STOC5.2.33, 3), 2) > AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) < MIN(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), 101))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)

Lower Low:

IIF(MIN(AVG(STOC5.2, 3), 2) > AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) < MIN(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) < IIF(MIN(AVG(STOC5.2.3, 3), 2) > AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) < MIN(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MIN(AVG(STOC5.2.4, 3), 2) > AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) < MIN(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MIN(AVG(STOC5.2.5, 3), 2) > AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) < MIN(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MIN(AVG(STOC5.2.6, 3), 2) > AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) < MIN(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MIN(AVG(STOC5.2.7, 3), 2) > AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) < MIN(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MIN(AVG(STOC5.2.8, 3), 2) > AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) < MIN(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MIN(AVG(STOC5.2.9, 3), 2) > AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) < MIN(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MIN(AVG(STOC5.2.10, 3), 2) > AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) < MIN(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MIN(AVG(STOC5.2.11, 3), 2) > AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) < MIN(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MIN(AVG(STOC5.2.12, 3), 2) > AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) < MIN(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MIN(AVG(STOC5.2.13, 3), 2) > AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) < MIN(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MIN(AVG(STOC5.2.14, 3), 2) > AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) < MIN(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MIN(AVG(STOC5.2.15, 3), 2) > AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) < MIN(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MIN(AVG(STOC5.2.16, 3), 2) > AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) < MIN(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MIN(AVG(STOC5.2.17, 3), 2) > AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) < MIN(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MIN(AVG(STOC5.2.18, 3), 2) > AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) < MIN(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MIN(AVG(STOC5.2.19, 3), 2) > AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) < MIN(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MIN(AVG(STOC5.2.20, 3), 2) > AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) < MIN(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MIN(AVG(STOC5.2.21, 3), 2) > AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) < MIN(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MIN(AVG(STOC5.2.22, 3), 2) > AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) < MIN(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MIN(AVG(STOC5.2.23, 3), 2) > AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) < MIN(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MIN(AVG(STOC5.2.24, 3), 2) > AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) < MIN(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MIN(AVG(STOC5.2.25, 3), 2) > AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) < MIN(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MIN(AVG(STOC5.2.26, 3), 2) > AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) < MIN(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MIN(AVG(STOC5.2.27, 3), 2) > AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) < MIN(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MIN(AVG(STOC5.2.28, 3), 2) > AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) < MIN(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MIN(AVG(STOC5.2.29, 3), 2) > AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) < MIN(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MIN(AVG(STOC5.2.30, 3), 2) > AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) < MIN(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MIN(AVG(STOC5.2.31, 3), 2) > AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) < MIN(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MIN(AVG(STOC5.2.32, 3), 2) > AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) < MIN(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MIN(AVG(STOC5.2.33, 3), 2) > AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) < MIN(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), -1))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Friday, January 26, 2018 11:50:16 AM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce thankyou for the formulas ,, they are plotting correct but they are doing on %D ... while i was looking for %K plots 

so what do we need to change on them 

 

thanks a lot again

Dhiren

Bruce_L
Posted : Friday, January 26, 2018 11:55:24 AM


Worden Trainer

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

You will find that with a lot of symbols, this just won't work because you will have the stochastic hit 0 or 100 for multiple bars in a row (and no, I am not re-writing the formulas to try and correct for this).

This can also result in a much higher chance of consecutive highs and lows being exactly the same instead of higher or lower than the previous instance.

Higher High:

IIF(MAX(STOC5.2, 2) < STOC5.2.2 AND STOC5.2.2 > MAX(STOC5.2.3, 2) AND STOC5.2.2 > IIF(MAX(STOC5.2.3, 2) < STOC5.2.5 AND STOC5.2.5 > MAX(STOC5.2.6, 2), STOC5.2.5, IIF(MAX(STOC5.2.4, 2) < STOC5.2.6 AND STOC5.2.6 > MAX(STOC5.2.7, 2), STOC5.2.6, IIF(MAX(STOC5.2.5, 2) < STOC5.2.7 AND STOC5.2.7 > MAX(STOC5.2.8, 2), STOC5.2.7, IIF(MAX(STOC5.2.6, 2) < STOC5.2.8 AND STOC5.2.8 > MAX(STOC5.2.9, 2), STOC5.2.8, IIF(MAX(STOC5.2.7, 2) < STOC5.2.9 AND STOC5.2.9 > MAX(STOC5.2.10, 2), STOC5.2.9, IIF(MAX(STOC5.2.8, 2) < STOC5.2.10 AND STOC5.2.10 > MAX(STOC5.2.11, 2), STOC5.2.10, IIF(MAX(STOC5.2.9, 2) < STOC5.2.11 AND STOC5.2.11 > MAX(STOC5.2.12, 2), STOC5.2.11, IIF(MAX(STOC5.2.10, 2) < STOC5.2.12 AND STOC5.2.12 > MAX(STOC5.2.13, 2), STOC5.2.12, IIF(MAX(STOC5.2.11, 2) < STOC5.2.13 AND STOC5.2.13 > MAX(STOC5.2.14, 2), STOC5.2.13, IIF(MAX(STOC5.2.12, 2) < STOC5.2.14 AND STOC5.2.14 > MAX(STOC5.2.15, 2), STOC5.2.14, IIF(MAX(STOC5.2.13, 2) < STOC5.2.15 AND STOC5.2.15 > MAX(STOC5.2.16, 2), STOC5.2.15, IIF(MAX(STOC5.2.14, 2) < STOC5.2.16 AND STOC5.2.16 > MAX(STOC5.2.17, 2), STOC5.2.16, IIF(MAX(STOC5.2.15, 2) < STOC5.2.17 AND STOC5.2.17 > MAX(STOC5.2.18, 2), STOC5.2.17, IIF(MAX(STOC5.2.16, 2) < STOC5.2.18 AND STOC5.2.18 > MAX(STOC5.2.19, 2), STOC5.2.18, IIF(MAX(STOC5.2.17, 2) < STOC5.2.19 AND STOC5.2.19 > MAX(STOC5.2.20, 2), STOC5.2.19, IIF(MAX(STOC5.2.18, 2) < STOC5.2.20 AND STOC5.2.20 > MAX(STOC5.2.21, 2), STOC5.2.20, IIF(MAX(STOC5.2.19, 2) < STOC5.2.21 AND STOC5.2.21 > MAX(STOC5.2.22, 2), STOC5.2.21, IIF(MAX(STOC5.2.20, 2) < STOC5.2.22 AND STOC5.2.22 > MAX(STOC5.2.23, 2), STOC5.2.22, IIF(MAX(STOC5.2.21, 2) < STOC5.2.23 AND STOC5.2.23 > MAX(STOC5.2.24, 2), STOC5.2.23, IIF(MAX(STOC5.2.22, 2) < STOC5.2.24 AND STOC5.2.24 > MAX(STOC5.2.25, 2), STOC5.2.24, IIF(MAX(STOC5.2.23, 2) < STOC5.2.25 AND STOC5.2.25 > MAX(STOC5.2.26, 2), STOC5.2.25, IIF(MAX(STOC5.2.24, 2) < STOC5.2.26 AND STOC5.2.26 > MAX(STOC5.2.27, 2), STOC5.2.26, IIF(MAX(STOC5.2.25, 2) < STOC5.2.27 AND STOC5.2.27 > MAX(STOC5.2.28, 2), STOC5.2.27, IIF(MAX(STOC5.2.26, 2) < STOC5.2.28 AND STOC5.2.28 > MAX(STOC5.2.29, 2), STOC5.2.28, IIF(MAX(STOC5.2.27, 2) < STOC5.2.29 AND STOC5.2.29 > MAX(STOC5.2.30, 2), STOC5.2.29, IIF(MAX(STOC5.2.28, 2) < STOC5.2.30 AND STOC5.2.30 > MAX(STOC5.2.31, 2), STOC5.2.30, IIF(MAX(STOC5.2.29, 2) < STOC5.2.31 AND STOC5.2.31 > MAX(STOC5.2.32, 2), STOC5.2.31, IIF(MAX(STOC5.2.30, 2) < STOC5.2.32 AND STOC5.2.32 > MAX(STOC5.2.33, 2), STOC5.2.32, IIF(MAX(STOC5.2.31, 2) < STOC5.2.33 AND STOC5.2.33 > MAX(STOC5.2.34, 2), STOC5.2.33, IIF(MAX(STOC5.2.32, 2) < STOC5.2.34 AND STOC5.2.34 > MAX(STOC5.2.35, 2), STOC5.2.34, IIF(MAX(STOC5.2.33, 2) < STOC5.2.35 AND STOC5.2.35 > MAX(STOC5.2.36, 2), STOC5.2.35, 101))))))))))))))))))))))))))))))), STOC5.2.2, -10)

Lower High:

IIF(MAX(STOC5.2, 2) < STOC5.2.2 AND STOC5.2.2 > MAX(STOC5.2.3, 2) AND STOC5.2.2 < IIF(MAX(STOC5.2.3, 2) < STOC5.2.5 AND STOC5.2.5 > MAX(STOC5.2.6, 2), STOC5.2.5, IIF(MAX(STOC5.2.4, 2) < STOC5.2.6 AND STOC5.2.6 > MAX(STOC5.2.7, 2), STOC5.2.6, IIF(MAX(STOC5.2.5, 2) < STOC5.2.7 AND STOC5.2.7 > MAX(STOC5.2.8, 2), STOC5.2.7, IIF(MAX(STOC5.2.6, 2) < STOC5.2.8 AND STOC5.2.8 > MAX(STOC5.2.9, 2), STOC5.2.8, IIF(MAX(STOC5.2.7, 2) < STOC5.2.9 AND STOC5.2.9 > MAX(STOC5.2.10, 2), STOC5.2.9, IIF(MAX(STOC5.2.8, 2) < STOC5.2.10 AND STOC5.2.10 > MAX(STOC5.2.11, 2), STOC5.2.10, IIF(MAX(STOC5.2.9, 2) < STOC5.2.11 AND STOC5.2.11 > MAX(STOC5.2.12, 2), STOC5.2.11, IIF(MAX(STOC5.2.10, 2) < STOC5.2.12 AND STOC5.2.12 > MAX(STOC5.2.13, 2), STOC5.2.12, IIF(MAX(STOC5.2.11, 2) < STOC5.2.13 AND STOC5.2.13 > MAX(STOC5.2.14, 2), STOC5.2.13, IIF(MAX(STOC5.2.12, 2) < STOC5.2.14 AND STOC5.2.14 > MAX(STOC5.2.15, 2), STOC5.2.14, IIF(MAX(STOC5.2.13, 2) < STOC5.2.15 AND STOC5.2.15 > MAX(STOC5.2.16, 2), STOC5.2.15, IIF(MAX(STOC5.2.14, 2) < STOC5.2.16 AND STOC5.2.16 > MAX(STOC5.2.17, 2), STOC5.2.16, IIF(MAX(STOC5.2.15, 2) < STOC5.2.17 AND STOC5.2.17 > MAX(STOC5.2.18, 2), STOC5.2.17, IIF(MAX(STOC5.2.16, 2) < STOC5.2.18 AND STOC5.2.18 > MAX(STOC5.2.19, 2), STOC5.2.18, IIF(MAX(STOC5.2.17, 2) < STOC5.2.19 AND STOC5.2.19 > MAX(STOC5.2.20, 2), STOC5.2.19, IIF(MAX(STOC5.2.18, 2) < STOC5.2.20 AND STOC5.2.20 > MAX(STOC5.2.21, 2), STOC5.2.20, IIF(MAX(STOC5.2.19, 2) < STOC5.2.21 AND STOC5.2.21 > MAX(STOC5.2.22, 2), STOC5.2.21, IIF(MAX(STOC5.2.20, 2) < STOC5.2.22 AND STOC5.2.22 > MAX(STOC5.2.23, 2), STOC5.2.22, IIF(MAX(STOC5.2.21, 2) < STOC5.2.23 AND STOC5.2.23 > MAX(STOC5.2.24, 2), STOC5.2.23, IIF(MAX(STOC5.2.22, 2) < STOC5.2.24 AND STOC5.2.24 > MAX(STOC5.2.25, 2), STOC5.2.24, IIF(MAX(STOC5.2.23, 2) < STOC5.2.25 AND STOC5.2.25 > MAX(STOC5.2.26, 2), STOC5.2.25, IIF(MAX(STOC5.2.24, 2) < STOC5.2.26 AND STOC5.2.26 > MAX(STOC5.2.27, 2), STOC5.2.26, IIF(MAX(STOC5.2.25, 2) < STOC5.2.27 AND STOC5.2.27 > MAX(STOC5.2.28, 2), STOC5.2.27, IIF(MAX(STOC5.2.26, 2) < STOC5.2.28 AND STOC5.2.28 > MAX(STOC5.2.29, 2), STOC5.2.28, IIF(MAX(STOC5.2.27, 2) < STOC5.2.29 AND STOC5.2.29 > MAX(STOC5.2.30, 2), STOC5.2.29, IIF(MAX(STOC5.2.28, 2) < STOC5.2.30 AND STOC5.2.30 > MAX(STOC5.2.31, 2), STOC5.2.30, IIF(MAX(STOC5.2.29, 2) < STOC5.2.31 AND STOC5.2.31 > MAX(STOC5.2.32, 2), STOC5.2.31, IIF(MAX(STOC5.2.30, 2) < STOC5.2.32 AND STOC5.2.32 > MAX(STOC5.2.33, 2), STOC5.2.32, IIF(MAX(STOC5.2.31, 2) < STOC5.2.33 AND STOC5.2.33 > MAX(STOC5.2.34, 2), STOC5.2.33, IIF(MAX(STOC5.2.32, 2) < STOC5.2.34 AND STOC5.2.34 > MAX(STOC5.2.35, 2), STOC5.2.34, IIF(MAX(STOC5.2.33, 2) < STOC5.2.35 AND STOC5.2.35 > MAX(STOC5.2.36, 2), STOC5.2.35, -1))))))))))))))))))))))))))))))), STOC5.2.2, -10)

Higher Low:

IIF(MIN(STOC5.2, 2) > STOC5.2.2 AND STOC5.2.2 < MIN(STOC5.2.3, 2) AND STOC5.2.2 > IIF(MIN(STOC5.2.3, 2) > STOC5.2.5 AND STOC5.2.5 < MIN(STOC5.2.6, 2), STOC5.2.5, IIF(MIN(STOC5.2.4, 2) > STOC5.2.6 AND STOC5.2.6 < MIN(STOC5.2.7, 2), STOC5.2.6, IIF(MIN(STOC5.2.5, 2) > STOC5.2.7 AND STOC5.2.7 < MIN(STOC5.2.8, 2), STOC5.2.7, IIF(MIN(STOC5.2.6, 2) > STOC5.2.8 AND STOC5.2.8 < MIN(STOC5.2.9, 2), STOC5.2.8, IIF(MIN(STOC5.2.7, 2) > STOC5.2.9 AND STOC5.2.9 < MIN(STOC5.2.10, 2), STOC5.2.9, IIF(MIN(STOC5.2.8, 2) > STOC5.2.10 AND STOC5.2.10 < MIN(STOC5.2.11, 2), STOC5.2.10, IIF(MIN(STOC5.2.9, 2) > STOC5.2.11 AND STOC5.2.11 < MIN(STOC5.2.12, 2), STOC5.2.11, IIF(MIN(STOC5.2.10, 2) > STOC5.2.12 AND STOC5.2.12 < MIN(STOC5.2.13, 2), STOC5.2.12, IIF(MIN(STOC5.2.11, 2) > STOC5.2.13 AND STOC5.2.13 < MIN(STOC5.2.14, 2), STOC5.2.13, IIF(MIN(STOC5.2.12, 2) > STOC5.2.14 AND STOC5.2.14 < MIN(STOC5.2.15, 2), STOC5.2.14, IIF(MIN(STOC5.2.13, 2) > STOC5.2.15 AND STOC5.2.15 < MIN(STOC5.2.16, 2), STOC5.2.15, IIF(MIN(STOC5.2.14, 2) > STOC5.2.16 AND STOC5.2.16 < MIN(STOC5.2.17, 2), STOC5.2.16, IIF(MIN(STOC5.2.15, 2) > STOC5.2.17 AND STOC5.2.17 < MIN(STOC5.2.18, 2), STOC5.2.17, IIF(MIN(STOC5.2.16, 2) > STOC5.2.18 AND STOC5.2.18 < MIN(STOC5.2.19, 2), STOC5.2.18, IIF(MIN(STOC5.2.17, 2) > STOC5.2.19 AND STOC5.2.19 < MIN(STOC5.2.20, 2), STOC5.2.19, IIF(MIN(STOC5.2.18, 2) > STOC5.2.20 AND STOC5.2.20 < MIN(STOC5.2.21, 2), STOC5.2.20, IIF(MIN(STOC5.2.19, 2) > STOC5.2.21 AND STOC5.2.21 < MIN(STOC5.2.22, 2), STOC5.2.21, IIF(MIN(STOC5.2.20, 2) > STOC5.2.22 AND STOC5.2.22 < MIN(STOC5.2.23, 2), STOC5.2.22, IIF(MIN(STOC5.2.21, 2) > STOC5.2.23 AND STOC5.2.23 < MIN(STOC5.2.24, 2), STOC5.2.23, IIF(MIN(STOC5.2.22, 2) > STOC5.2.24 AND STOC5.2.24 < MIN(STOC5.2.25, 2), STOC5.2.24, IIF(MIN(STOC5.2.23, 2) > STOC5.2.25 AND STOC5.2.25 < MIN(STOC5.2.26, 2), STOC5.2.25, IIF(MIN(STOC5.2.24, 2) > STOC5.2.26 AND STOC5.2.26 < MIN(STOC5.2.27, 2), STOC5.2.26, IIF(MIN(STOC5.2.25, 2) > STOC5.2.27 AND STOC5.2.27 < MIN(STOC5.2.28, 2), STOC5.2.27, IIF(MIN(STOC5.2.26, 2) > STOC5.2.28 AND STOC5.2.28 < MIN(STOC5.2.29, 2), STOC5.2.28, IIF(MIN(STOC5.2.27, 2) > STOC5.2.29 AND STOC5.2.29 < MIN(STOC5.2.30, 2), STOC5.2.29, IIF(MIN(STOC5.2.28, 2) > STOC5.2.30 AND STOC5.2.30 < MIN(STOC5.2.31, 2), STOC5.2.30, IIF(MIN(STOC5.2.29, 2) > STOC5.2.31 AND STOC5.2.31 < MIN(STOC5.2.32, 2), STOC5.2.31, IIF(MIN(STOC5.2.30, 2) > STOC5.2.32 AND STOC5.2.32 < MIN(STOC5.2.33, 2), STOC5.2.32, IIF(MIN(STOC5.2.31, 2) > STOC5.2.33 AND STOC5.2.33 < MIN(STOC5.2.34, 2), STOC5.2.33, IIF(MIN(STOC5.2.32, 2) > STOC5.2.34 AND STOC5.2.34 < MIN(STOC5.2.35, 2), STOC5.2.34, IIF(MIN(STOC5.2.33, 2) > STOC5.2.35 AND STOC5.2.35 < MIN(STOC5.2.36, 2), STOC5.2.35, 101))))))))))))))))))))))))))))))), STOC5.2.2, -10)

Lower Low:

IIF(MIN(STOC5.2, 2) > STOC5.2.2 AND STOC5.2.2 < MIN(STOC5.2.3, 2) AND STOC5.2.2 < IIF(MIN(STOC5.2.3, 2) > STOC5.2.5 AND STOC5.2.5 < MIN(STOC5.2.6, 2), STOC5.2.5, IIF(MIN(STOC5.2.4, 2) > STOC5.2.6 AND STOC5.2.6 < MIN(STOC5.2.7, 2), STOC5.2.6, IIF(MIN(STOC5.2.5, 2) > STOC5.2.7 AND STOC5.2.7 < MIN(STOC5.2.8, 2), STOC5.2.7, IIF(MIN(STOC5.2.6, 2) > STOC5.2.8 AND STOC5.2.8 < MIN(STOC5.2.9, 2), STOC5.2.8, IIF(MIN(STOC5.2.7, 2) > STOC5.2.9 AND STOC5.2.9 < MIN(STOC5.2.10, 2), STOC5.2.9, IIF(MIN(STOC5.2.8, 2) > STOC5.2.10 AND STOC5.2.10 < MIN(STOC5.2.11, 2), STOC5.2.10, IIF(MIN(STOC5.2.9, 2) > STOC5.2.11 AND STOC5.2.11 < MIN(STOC5.2.12, 2), STOC5.2.11, IIF(MIN(STOC5.2.10, 2) > STOC5.2.12 AND STOC5.2.12 < MIN(STOC5.2.13, 2), STOC5.2.12, IIF(MIN(STOC5.2.11, 2) > STOC5.2.13 AND STOC5.2.13 < MIN(STOC5.2.14, 2), STOC5.2.13, IIF(MIN(STOC5.2.12, 2) > STOC5.2.14 AND STOC5.2.14 < MIN(STOC5.2.15, 2), STOC5.2.14, IIF(MIN(STOC5.2.13, 2) > STOC5.2.15 AND STOC5.2.15 < MIN(STOC5.2.16, 2), STOC5.2.15, IIF(MIN(STOC5.2.14, 2) > STOC5.2.16 AND STOC5.2.16 < MIN(STOC5.2.17, 2), STOC5.2.16, IIF(MIN(STOC5.2.15, 2) > STOC5.2.17 AND STOC5.2.17 < MIN(STOC5.2.18, 2), STOC5.2.17, IIF(MIN(STOC5.2.16, 2) > STOC5.2.18 AND STOC5.2.18 < MIN(STOC5.2.19, 2), STOC5.2.18, IIF(MIN(STOC5.2.17, 2) > STOC5.2.19 AND STOC5.2.19 < MIN(STOC5.2.20, 2), STOC5.2.19, IIF(MIN(STOC5.2.18, 2) > STOC5.2.20 AND STOC5.2.20 < MIN(STOC5.2.21, 2), STOC5.2.20, IIF(MIN(STOC5.2.19, 2) > STOC5.2.21 AND STOC5.2.21 < MIN(STOC5.2.22, 2), STOC5.2.21, IIF(MIN(STOC5.2.20, 2) > STOC5.2.22 AND STOC5.2.22 < MIN(STOC5.2.23, 2), STOC5.2.22, IIF(MIN(STOC5.2.21, 2) > STOC5.2.23 AND STOC5.2.23 < MIN(STOC5.2.24, 2), STOC5.2.23, IIF(MIN(STOC5.2.22, 2) > STOC5.2.24 AND STOC5.2.24 < MIN(STOC5.2.25, 2), STOC5.2.24, IIF(MIN(STOC5.2.23, 2) > STOC5.2.25 AND STOC5.2.25 < MIN(STOC5.2.26, 2), STOC5.2.25, IIF(MIN(STOC5.2.24, 2) > STOC5.2.26 AND STOC5.2.26 < MIN(STOC5.2.27, 2), STOC5.2.26, IIF(MIN(STOC5.2.25, 2) > STOC5.2.27 AND STOC5.2.27 < MIN(STOC5.2.28, 2), STOC5.2.27, IIF(MIN(STOC5.2.26, 2) > STOC5.2.28 AND STOC5.2.28 < MIN(STOC5.2.29, 2), STOC5.2.28, IIF(MIN(STOC5.2.27, 2) > STOC5.2.29 AND STOC5.2.29 < MIN(STOC5.2.30, 2), STOC5.2.29, IIF(MIN(STOC5.2.28, 2) > STOC5.2.30 AND STOC5.2.30 < MIN(STOC5.2.31, 2), STOC5.2.30, IIF(MIN(STOC5.2.29, 2) > STOC5.2.31 AND STOC5.2.31 < MIN(STOC5.2.32, 2), STOC5.2.31, IIF(MIN(STOC5.2.30, 2) > STOC5.2.32 AND STOC5.2.32 < MIN(STOC5.2.33, 2), STOC5.2.32, IIF(MIN(STOC5.2.31, 2) > STOC5.2.33 AND STOC5.2.33 < MIN(STOC5.2.34, 2), STOC5.2.33, IIF(MIN(STOC5.2.32, 2) > STOC5.2.34 AND STOC5.2.34 < MIN(STOC5.2.35, 2), STOC5.2.34, IIF(MIN(STOC5.2.33, 2) > STOC5.2.35 AND STOC5.2.35 < MIN(STOC5.2.36, 2), STOC5.2.35, -1))))))))))))))))))))))))))))))), STOC5.2.2, -10)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Friday, January 26, 2018 12:27:44 PM
Registered User
Joined: 3/10/2012
Posts: 465

Okay Bruce i get it... so mainly what i want to achieve is to sort when i get this set-up like this in stochastic with my settings mentioned,  alternative if you can give a formula for a PIVOT on stochastic with my 5-2-3 settings  like the attached that would do as well 

please see the attached link 

LL-LH-HL

http://www.dhirenshah.com/stochastic/

thanks

Dhiren

Bruce_L
Posted : Friday, January 26, 2018 12:45:15 PM


Worden Trainer

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

We can check for the HL, but not if the previous low was a LL.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Friday, January 26, 2018 12:57:32 PM
Registered User
Joined: 3/10/2012
Posts: 465

No need Bruce what u did on %K works for me ... i think we must have crossed in cyberspace while typing .... 

I don't take all set-ups using this settings but there is a time when they make big moves... and eyeball them

thanks a lot

Have a great weekend...

Dhiren

dhirenshah
Posted : Friday, January 26, 2018 1:08:06 PM
Registered User
Joined: 3/10/2012
Posts: 465

Sorry Bruce one more thing i forgot to ask.. a non related query 

You use to do that forumla under price on moving averages in dot plot style  when the following was true and then the dots disappeared if it was not true so i can't recall them how u did , 

Lets use 8EMA AND 21 EMA examples i need 4 different colours

1) PRICE IS ABOVE 8 EMA  dots plot yellow 

2) 8 EMA ABOVE 21 EMA  and price above 8EMA DOTS plot green 

3) price below 8EMA BUT ABOVE 21EMA dots plot brown 

4) 8 EMA BELOW 21 EMA  AND PRICE BELOW 8 EMA dots plot red 

if u can please post them again

thanks

 

Bruce_L
Posted : Friday, January 26, 2018 1:20:49 PM


Worden Trainer

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

There are two ways to do this. The newer way using IIF() is probably better even though it is longer, but they are essentiall the same technique. I am assuming "under price" means a dot at the low.

1)

IIF(C > XAVGC8, L, 1 / 0)

Or:

L / ABS(C > XAVGC8)

2)

IIF(C > XAVGC8 AND XAVGC8 > XAVGC21, L, 1 / 0)

Or:

L / ABS(C > XAVGC8 AND XAVGC8 > XAVGC21)

3)

IIF(XAVGC8 > C AND C > XAVGC21, L, 1 / 0)

Or:

L / ABS(XAVGC8 > C AND C > XAVGC21)

4)

IIF(XAVGC21 > XAVGC8 AND XAVGC8 > C, L, 1 / 0)

Or:

L / ABS(XAVGC21 > XAVGC8 AND XAVGC8 > C)

The idea of all of these formulas is to generate a division by zero error when you don't want a dot to plot and plot L otherwise.

Using IIF() allows you to specific the Boolean formula as the first argument, the value you want to plot if true as the second argument, and 1 / 0 to generate a division by zero error when false.

Using  / ABS() allows you to put the value you want to plot when true before the / and the Boolean formula inside the ABS() function so it returns 1 when true or 0 when false. Dividing whatever is before the / by 1 returns whatever is before the / and dividing it by zero returns our division by zero error so the dot doesn't plot.

You can replace L with say 0 if you wanted to plot a line of dots at zero instead of plotting the dots at the low of price in the same pane and scale as price.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Friday, January 26, 2018 2:22:20 PM
Registered User
Joined: 3/10/2012
Posts: 465

Excellent Bruce thanks 

 

dhirenshah
Posted : Thursday, November 1, 2018 1:04:14 PM
Registered User
Joined: 3/10/2012
Posts: 465

Hey Bruce 

hope you well, 

I have a follow-up question from the pcf you posted on Posted : 09 January 2018 15:59:18

I need a spike pcf when CURRENT WRSI14 CROSSESS UP OR DOWN THE  MOST RECENT FRACTAL  FROM THE PAST

thanks 

Dhiren

Bruce_L
Posted : Thursday, November 1, 2018 1:17:24 PM


Worden Trainer

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

Does it matter if the fractal is a low or a high? Does the direction of the cross matter depending on if it is a low or a high? Do you want multiple formulas or a single formula?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Thursday, November 1, 2018 1:38:23 PM
Registered User
Joined: 3/10/2012
Posts: 465

Ok Yes 

So my interest is a follows 

1) If current WRSI14 is crossing up HH or LH from past then show me spike one colour

2) If current WRSI14 is crossing down HL or LL from past then show me spike as second colour

Also can you please do 13bar fractal HIGH and LOW for wrsi (where wrsi had 13 bars to the left and 13 bars to the right)

 

thanks

Bruce_L
Posted : Thursday, November 1, 2018 2:30:22 PM


Worden Trainer

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

I can't make a 13 bar version for WRSI14 which is fast enough to be practical or post in the forums.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Thursday, November 1, 2018 2:41:09 PM
Registered User
Joined: 3/10/2012
Posts: 465

Ok no worries and what about these below queries using your post Posted : 09 January 2018 15:59:18

 

1) If current WRSI14 is crossing up HH or LH from past then show me spike one colour

2) If current WRSI14 is crossing down HL or LL from past then show me spike as second colour

Bruce_L
Posted : Thursday, November 1, 2018 2:56:01 PM


Worden Trainer

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

Please try the following for crossing up the most recent high.

XUP(WRSI14, IIF(WRSI14.3 > GREATEST(MAX(WRSI14.1, 2), MAX(WRSI14.4, 2)), WRSI14.3, IIF(WRSI14.4 > GREATEST(MAX(WRSI14.2, 2), MAX(WRSI14.5, 2)), WRSI14.4, IIF(WRSI14.5 > GREATEST(MAX(WRSI14.3, 2), MAX(WRSI14.6, 2)), WRSI14.5, IIF(WRSI14.6 > GREATEST(MAX(WRSI14.4, 2), MAX(WRSI14.7, 2)), WRSI14.6, IIF(WRSI14.7 > GREATEST(MAX(WRSI14.5, 2), MAX(WRSI14.8, 2)), WRSI14.7, IIF(WRSI14.8 > GREATEST(MAX(WRSI14.6, 2), MAX(WRSI14.9, 2)), WRSI14.8, IIF(WRSI14.9 > GREATEST(MAX(WRSI14.7, 2), MAX(WRSI14.10, 2)), WRSI14.9, IIF(WRSI14.10 > GREATEST(MAX(WRSI14.8, 2), MAX(WRSI14.11, 2)), WRSI14.10, IIF(WRSI14.11 > GREATEST(MAX(WRSI14.9, 2), MAX(WRSI14.12, 2)), WRSI14.11, IIF(WRSI14.12 > GREATEST(MAX(WRSI14.10, 2), MAX(WRSI14.13, 2)), WRSI14.12, IIF(WRSI14.13 > GREATEST(MAX(WRSI14.11, 2), MAX(WRSI14.14, 2)), WRSI14.13, IIF(WRSI14.14 > GREATEST(MAX(WRSI14.12, 2), MAX(WRSI14.15, 2)), WRSI14.14, IIF(WRSI14.15 > GREATEST(MAX(WRSI14.13, 2), MAX(WRSI14.16, 2)), WRSI14.15, IIF(WRSI14.16 > GREATEST(MAX(WRSI14.14, 2), MAX(WRSI14.17, 2)), WRSI14.16, IIF(WRSI14.17 > GREATEST(MAX(WRSI14.15, 2), MAX(WRSI14.18, 2)), WRSI14.17, IIF(WRSI14.18 > GREATEST(MAX(WRSI14.16, 2), MAX(WRSI14.19, 2)), WRSI14.18, IIF(WRSI14.19 > GREATEST(MAX(WRSI14.17, 2), MAX(WRSI14.20, 2)), WRSI14.19, IIF(WRSI14.20 > GREATEST(MAX(WRSI14.18, 2), MAX(WRSI14.21, 2)), WRSI14.20, IIF(WRSI14.21 > GREATEST(MAX(WRSI14.19, 2), MAX(WRSI14.22, 2)), WRSI14.21, IIF(WRSI14.22 > GREATEST(MAX(WRSI14.20, 2), MAX(WRSI14.23, 2)), WRSI14.22, IIF(WRSI14.23 > GREATEST(MAX(WRSI14.21, 2), MAX(WRSI14.24, 2)), WRSI14.23, IIF(WRSI14.24 > GREATEST(MAX(WRSI14.22, 2), MAX(WRSI14.25, 2)), WRSI14.24, IIF(WRSI14.25 > GREATEST(MAX(WRSI14.23, 2), MAX(WRSI14.26, 2)), WRSI14.25, IIF(WRSI14.26 > GREATEST(MAX(WRSI14.24, 2), MAX(WRSI14.27, 2)), WRSI14.26, IIF(WRSI14.27 > GREATEST(MAX(WRSI14.25, 2), MAX(WRSI14.28, 2)), WRSI14.27, IIF(WRSI14.28 > GREATEST(MAX(WRSI14.26, 2), MAX(WRSI14.29, 2)), WRSI14.28, IIF(WRSI14.29 > GREATEST(MAX(WRSI14.27, 2), MAX(WRSI14.30, 2)), WRSI14.29, IIF(WRSI14.30 > GREATEST(MAX(WRSI14.28, 2), MAX(WRSI14.31, 2)), WRSI14.30, IIF(WRSI14.31 > GREATEST(MAX(WRSI14.29, 2), MAX(WRSI14.32, 2)), WRSI14.31, IIF(WRSI14.32 > GREATEST(MAX(WRSI14.30, 2), MAX(WRSI14.33, 2)), WRSI14.32, IIF(WRSI14.33 > GREATEST(MAX(WRSI14.31, 2), MAX(WRSI14.34, 2)), WRSI14.33, IIF(WRSI14.34 > GREATEST(MAX(WRSI14.32, 2), MAX(WRSI14.35, 2)), WRSI14.34, IIF(WRSI14.35 > GREATEST(MAX(WRSI14.33, 2), MAX(WRSI14.36, 2)), WRSI14.35, IIF(WRSI14.36 > GREATEST(MAX(WRSI14.34, 2), MAX(WRSI14.37, 2)), WRSI14.36, IIF(WRSI14.37 > GREATEST(MAX(WRSI14.35, 2), MAX(WRSI14.38, 2)), WRSI14.37, IIF(WRSI14.38 > GREATEST(MAX(WRSI14.36, 2), MAX(WRSI14.39, 2)), WRSI14.38, IIF(WRSI14.39 > GREATEST(MAX(WRSI14.37, 2), MAX(WRSI14.40, 2)), WRSI14.39, IIF(WRSI14.40 > GREATEST(MAX(WRSI14.38, 2), MAX(WRSI14.41, 2)), WRSI14.40, IIF(WRSI14.41 > GREATEST(MAX(WRSI14.39, 2), MAX(WRSI14.42, 2)), WRSI14.41, IIF(WRSI14.42 > GREATEST(MAX(WRSI14.40, 2), MAX(WRSI14.43, 2)), WRSI14.42, IIF(WRSI14.43 > GREATEST(MAX(WRSI14.41, 2), MAX(WRSI14.44, 2)), WRSI14.43, IIF(WRSI14.44 > GREATEST(MAX(WRSI14.42, 2), MAX(WRSI14.45, 2)), WRSI14.44, IIF(WRSI14.45 > GREATEST(MAX(WRSI14.43, 2), MAX(WRSI14.46, 2)), WRSI14.45, IIF(WRSI14.46 > GREATEST(MAX(WRSI14.44, 2), MAX(WRSI14.47, 2)), WRSI14.46, IIF(WRSI14.47 > GREATEST(MAX(WRSI14.45, 2), MAX(WRSI14.48, 2)), WRSI14.47, IIF(WRSI14.48 > GREATEST(MAX(WRSI14.46, 2), MAX(WRSI14.49, 2)), WRSI14.48, IIF(WRSI14.49 > GREATEST(MAX(WRSI14.47, 2), MAX(WRSI14.50, 2)), WRSI14.49, IIF(WRSI14.50 > GREATEST(MAX(WRSI14.48, 2), MAX(WRSI14.51, 2)), WRSI14.50, IIF(WRSI14.51 > GREATEST(MAX(WRSI14.49, 2), MAX(WRSI14.52, 2)), WRSI14.51, IIF(WRSI14.52 > GREATEST(MAX(WRSI14.50, 2), MAX(WRSI14.53, 2)), WRSI14.52, IIF(WRSI14.53 > GREATEST(MAX(WRSI14.51, 2), MAX(WRSI14.54, 2)), WRSI14.53, IIF(WRSI14.54 > GREATEST(MAX(WRSI14.52, 2), MAX(WRSI14.55, 2)), WRSI14.54, IIF(WRSI14.55 > GREATEST(MAX(WRSI14.53, 2), MAX(WRSI14.56, 2)), WRSI14.55, IIF(WRSI14.56 > GREATEST(MAX(WRSI14.54, 2), MAX(WRSI14.57, 2)), WRSI14.56, IIF(WRSI14.57 > GREATEST(MAX(WRSI14.55, 2), MAX(WRSI14.58, 2)), WRSI14.57, IIF(WRSI14.58 > GREATEST(MAX(WRSI14.56, 2), MAX(WRSI14.59, 2)), WRSI14.58, IIF(WRSI14.59 > GREATEST(MAX(WRSI14.57, 2), MAX(WRSI14.60, 2)), WRSI14.59, IIF(WRSI14.60 > GREATEST(MAX(WRSI14.58, 2), MAX(WRSI14.61, 2)), WRSI14.60, IIF(WRSI14.61 > GREATEST(MAX(WRSI14.59, 2), MAX(WRSI14.62, 2)), WRSI14.61, IIF(WRSI14.62 > GREATEST(MAX(WRSI14.60, 2), MAX(WRSI14.63, 2)), WRSI14.62, IIF(WRSI14.63 > GREATEST(MAX(WRSI14.61, 2), MAX(WRSI14.64, 2)), WRSI14.63, IIF(WRSI14.64 > GREATEST(MAX(WRSI14.62, 2), MAX(WRSI14.65, 2)), WRSI14.64, IIF(WRSI14.65 > GREATEST(MAX(WRSI14.63, 2), MAX(WRSI14.66, 2)), WRSI14.65, IIF(WRSI14.66 > GREATEST(MAX(WRSI14.64, 2), MAX(WRSI14.67, 2)), WRSI14.66, IIF(WRSI14.67 > GREATEST(MAX(WRSI14.65, 2), MAX(WRSI14.68, 2)), WRSI14.67, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

And the following for crossing down the most recent low.

XDOWN(WRSI14, IIF(WRSI14.3 < LEAST(MIN(WRSI14.1, 2), MIN(WRSI14.4, 2)), WRSI14.3, IIF(WRSI14.4 < LEAST(MIN(WRSI14.2, 2), MIN(WRSI14.5, 2)), WRSI14.4, IIF(WRSI14.5 < LEAST(MIN(WRSI14.3, 2), MIN(WRSI14.6, 2)), WRSI14.5, IIF(WRSI14.6 < LEAST(MIN(WRSI14.4, 2), MIN(WRSI14.7, 2)), WRSI14.6, IIF(WRSI14.7 < LEAST(MIN(WRSI14.5, 2), MIN(WRSI14.8, 2)), WRSI14.7, IIF(WRSI14.8 < LEAST(MIN(WRSI14.6, 2), MIN(WRSI14.9, 2)), WRSI14.8, IIF(WRSI14.9 < LEAST(MIN(WRSI14.7, 2), MIN(WRSI14.10, 2)), WRSI14.9, IIF(WRSI14.10 < LEAST(MIN(WRSI14.8, 2), MIN(WRSI14.11, 2)), WRSI14.10, IIF(WRSI14.11 < LEAST(MIN(WRSI14.9, 2), MIN(WRSI14.12, 2)), WRSI14.11, IIF(WRSI14.12 < LEAST(MIN(WRSI14.10, 2), MIN(WRSI14.13, 2)), WRSI14.12, IIF(WRSI14.13 < LEAST(MIN(WRSI14.11, 2), MIN(WRSI14.14, 2)), WRSI14.13, IIF(WRSI14.14 < LEAST(MIN(WRSI14.12, 2), MIN(WRSI14.15, 2)), WRSI14.14, IIF(WRSI14.15 < LEAST(MIN(WRSI14.13, 2), MIN(WRSI14.16, 2)), WRSI14.15, IIF(WRSI14.16 < LEAST(MIN(WRSI14.14, 2), MIN(WRSI14.17, 2)), WRSI14.16, IIF(WRSI14.17 < LEAST(MIN(WRSI14.15, 2), MIN(WRSI14.18, 2)), WRSI14.17, IIF(WRSI14.18 < LEAST(MIN(WRSI14.16, 2), MIN(WRSI14.19, 2)), WRSI14.18, IIF(WRSI14.19 < LEAST(MIN(WRSI14.17, 2), MIN(WRSI14.20, 2)), WRSI14.19, IIF(WRSI14.20 < LEAST(MIN(WRSI14.18, 2), MIN(WRSI14.21, 2)), WRSI14.20, IIF(WRSI14.21 < LEAST(MIN(WRSI14.19, 2), MIN(WRSI14.22, 2)), WRSI14.21, IIF(WRSI14.22 < LEAST(MIN(WRSI14.20, 2), MIN(WRSI14.23, 2)), WRSI14.22, IIF(WRSI14.23 < LEAST(MIN(WRSI14.21, 2), MIN(WRSI14.24, 2)), WRSI14.23, IIF(WRSI14.24 < LEAST(MIN(WRSI14.22, 2), MIN(WRSI14.25, 2)), WRSI14.24, IIF(WRSI14.25 < LEAST(MIN(WRSI14.23, 2), MIN(WRSI14.26, 2)), WRSI14.25, IIF(WRSI14.26 < LEAST(MIN(WRSI14.24, 2), MIN(WRSI14.27, 2)), WRSI14.26, IIF(WRSI14.27 < LEAST(MIN(WRSI14.25, 2), MIN(WRSI14.28, 2)), WRSI14.27, IIF(WRSI14.28 < LEAST(MIN(WRSI14.26, 2), MIN(WRSI14.29, 2)), WRSI14.28, IIF(WRSI14.29 < LEAST(MIN(WRSI14.27, 2), MIN(WRSI14.30, 2)), WRSI14.29, IIF(WRSI14.30 < LEAST(MIN(WRSI14.28, 2), MIN(WRSI14.31, 2)), WRSI14.30, IIF(WRSI14.31 < LEAST(MIN(WRSI14.29, 2), MIN(WRSI14.32, 2)), WRSI14.31, IIF(WRSI14.32 < LEAST(MIN(WRSI14.30, 2), MIN(WRSI14.33, 2)), WRSI14.32, IIF(WRSI14.33 < LEAST(MIN(WRSI14.31, 2), MIN(WRSI14.34, 2)), WRSI14.33, IIF(WRSI14.34 < LEAST(MIN(WRSI14.32, 2), MIN(WRSI14.35, 2)), WRSI14.34, IIF(WRSI14.35 < LEAST(MIN(WRSI14.33, 2), MIN(WRSI14.36, 2)), WRSI14.35, IIF(WRSI14.36 < LEAST(MIN(WRSI14.34, 2), MIN(WRSI14.37, 2)), WRSI14.36, IIF(WRSI14.37 < LEAST(MIN(WRSI14.35, 2), MIN(WRSI14.38, 2)), WRSI14.37, IIF(WRSI14.38 < LEAST(MIN(WRSI14.36, 2), MIN(WRSI14.39, 2)), WRSI14.38, IIF(WRSI14.39 < LEAST(MIN(WRSI14.37, 2), MIN(WRSI14.40, 2)), WRSI14.39, IIF(WRSI14.40 < LEAST(MIN(WRSI14.38, 2), MIN(WRSI14.41, 2)), WRSI14.40, IIF(WRSI14.41 < LEAST(MIN(WRSI14.39, 2), MIN(WRSI14.42, 2)), WRSI14.41, IIF(WRSI14.42 < LEAST(MIN(WRSI14.40, 2), MIN(WRSI14.43, 2)), WRSI14.42, IIF(WRSI14.43 < LEAST(MIN(WRSI14.41, 2), MIN(WRSI14.44, 2)), WRSI14.43, IIF(WRSI14.44 < LEAST(MIN(WRSI14.42, 2), MIN(WRSI14.45, 2)), WRSI14.44, IIF(WRSI14.45 < LEAST(MIN(WRSI14.43, 2), MIN(WRSI14.46, 2)), WRSI14.45, IIF(WRSI14.46 < LEAST(MIN(WRSI14.44, 2), MIN(WRSI14.47, 2)), WRSI14.46, IIF(WRSI14.47 < LEAST(MIN(WRSI14.45, 2), MIN(WRSI14.48, 2)), WRSI14.47, IIF(WRSI14.48 < LEAST(MIN(WRSI14.46, 2), MIN(WRSI14.49, 2)), WRSI14.48, IIF(WRSI14.49 < LEAST(MIN(WRSI14.47, 2), MIN(WRSI14.50, 2)), WRSI14.49, IIF(WRSI14.50 < LEAST(MIN(WRSI14.48, 2), MIN(WRSI14.51, 2)), WRSI14.50, IIF(WRSI14.51 < LEAST(MIN(WRSI14.49, 2), MIN(WRSI14.52, 2)), WRSI14.51, IIF(WRSI14.52 < LEAST(MIN(WRSI14.50, 2), MIN(WRSI14.53, 2)), WRSI14.52, IIF(WRSI14.53 < LEAST(MIN(WRSI14.51, 2), MIN(WRSI14.54, 2)), WRSI14.53, IIF(WRSI14.54 < LEAST(MIN(WRSI14.52, 2), MIN(WRSI14.55, 2)), WRSI14.54, IIF(WRSI14.55 < LEAST(MIN(WRSI14.53, 2), MIN(WRSI14.56, 2)), WRSI14.55, IIF(WRSI14.56 < LEAST(MIN(WRSI14.54, 2), MIN(WRSI14.57, 2)), WRSI14.56, IIF(WRSI14.57 < LEAST(MIN(WRSI14.55, 2), MIN(WRSI14.58, 2)), WRSI14.57, IIF(WRSI14.58 < LEAST(MIN(WRSI14.56, 2), MIN(WRSI14.59, 2)), WRSI14.58, IIF(WRSI14.59 < LEAST(MIN(WRSI14.57, 2), MIN(WRSI14.60, 2)), WRSI14.59, IIF(WRSI14.60 < LEAST(MIN(WRSI14.58, 2), MIN(WRSI14.61, 2)), WRSI14.60, IIF(WRSI14.61 < LEAST(MIN(WRSI14.59, 2), MIN(WRSI14.62, 2)), WRSI14.61, IIF(WRSI14.62 < LEAST(MIN(WRSI14.60, 2), MIN(WRSI14.63, 2)), WRSI14.62, IIF(WRSI14.63 < LEAST(MIN(WRSI14.61, 2), MIN(WRSI14.64, 2)), WRSI14.63, IIF(WRSI14.64 < LEAST(MIN(WRSI14.62, 2), MIN(WRSI14.65, 2)), WRSI14.64, IIF(WRSI14.65 < LEAST(MIN(WRSI14.63, 2), MIN(WRSI14.66, 2)), WRSI14.65, IIF(WRSI14.66 < LEAST(MIN(WRSI14.64, 2), MIN(WRSI14.67, 2)), WRSI14.66, IIF(WRSI14.67 < LEAST(MIN(WRSI14.65, 2), MIN(WRSI14.68, 2)), WRSI14.67, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Thursday, November 1, 2018 3:08:15 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce it works perfect thankyou, 

One last twist i need is 

1) If current WRSI14 is crossing UP HL or LL from past then show me spike one colour

2) If current WRSI14 is crossing DOWN HH or LH from past then show me spike as second colour

Bruce_L
Posted : Thursday, November 1, 2018 4:06:13 PM


Worden Trainer

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

Just switch the XUP and XDOWN at the beginning of the formulas.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Thursday, November 1, 2018 4:54:31 PM
Registered User
Joined: 3/10/2012
Posts: 465

Thankyou :)

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

Hi Bruce,

I tried the following on TC2000 but got errors, mis-alignment and never got it right. Can you please TC Mail me a chart with the following indicator PCF's please?

Request1:

 HH GREEN , LH PURPLE , HL BROWN & LL RED thats what i wish to overlay on RSI

Higher High:

IIF(MAX(WRSI14, 2) < WRSI14.2 AND WRSI14.2 > MAX(WRSI14.3, 2) AND WRSI14.2 > IIF(MAX(WRSI14.3, 2) < WRSI14.5 AND WRSI14.5 > MAX(WRSI14.7, 2), WRSI14.5, IIF(MAX(WRSI14.4, 2) < WRSI14.6 AND WRSI14.6 > MAX(WRSI14.8, 2), WRSI14.6, IIF(MAX(WRSI14.5, 2) < WRSI14.7 AND WRSI14.7 > MAX(WRSI14.9, 2), WRSI14.7, IIF(MAX(WRSI14.6, 2) < WRSI14.8 AND WRSI14.8 > MAX(WRSI14.10, 2), WRSI14.8, IIF(MAX(WRSI14.7, 2) < WRSI14.9 AND WRSI14.9 > MAX(WRSI14.11, 2), WRSI14.9, IIF(MAX(WRSI14.8, 2) < WRSI14.10 AND WRSI14.10 > MAX(WRSI14.12, 2), WRSI14.10, IIF(MAX(WRSI14.9, 2) < WRSI14.11 AND WRSI14.11 > MAX(WRSI14.13, 2), WRSI14.11, IIF(MAX(WRSI14.10, 2) < WRSI14.12 AND WRSI14.12 > MAX(WRSI14.14, 2), WRSI14.12, IIF(MAX(WRSI14.11, 2) < WRSI14.13 AND WRSI14.13 > MAX(WRSI14.15, 2), WRSI14.13, IIF(MAX(WRSI14.12, 2) < WRSI14.14 AND WRSI14.14 > MAX(WRSI14.16, 2), WRSI14.14, IIF(MAX(WRSI14.13, 2) < WRSI14.15 AND WRSI14.15 > MAX(WRSI14.17, 2), WRSI14.15, IIF(MAX(WRSI14.14, 2) < WRSI14.16 AND WRSI14.16 > MAX(WRSI14.18, 2), WRSI14.16, IIF(MAX(WRSI14.15, 2) < WRSI14.17 AND WRSI14.17 > MAX(WRSI14.19, 2), WRSI14.17, IIF(MAX(WRSI14.16, 2) < WRSI14.18 AND WRSI14.18 > MAX(WRSI14.20, 2), WRSI14.18, IIF(MAX(WRSI14.17, 2) < WRSI14.19 AND WRSI14.19 > MAX(WRSI14.21, 2), WRSI14.19, IIF(MAX(WRSI14.18, 2) < WRSI14.20 AND WRSI14.20 > MAX(WRSI14.22, 2), WRSI14.20, IIF(MAX(WRSI14.19, 2) < WRSI14.21 AND WRSI14.21 > MAX(WRSI14.23, 2), WRSI14.21, IIF(MAX(WRSI14.20, 2) < WRSI14.22 AND WRSI14.22 > MAX(WRSI14.24, 2), WRSI14.22, IIF(MAX(WRSI14.21, 2) < WRSI14.23 AND WRSI14.23 > MAX(WRSI14.25, 2), WRSI14.23, IIF(MAX(WRSI14.22, 2) < WRSI14.24 AND WRSI14.24 > MAX(WRSI14.26, 2), WRSI14.24, IIF(MAX(WRSI14.23, 2) < WRSI14.25 AND WRSI14.25 > MAX(WRSI14.27, 2), WRSI14.25, IIF(MAX(WRSI14.24, 2) < WRSI14.26 AND WRSI14.26 > MAX(WRSI14.28, 2), WRSI14.26, IIF(MAX(WRSI14.25, 2) < WRSI14.27 AND WRSI14.27 > MAX(WRSI14.29, 2), WRSI14.27, IIF(MAX(WRSI14.26, 2) < WRSI14.28 AND WRSI14.28 > MAX(WRSI14.30, 2), WRSI14.28, IIF(MAX(WRSI14.27, 2) < WRSI14.29 AND WRSI14.29 > MAX(WRSI14.31, 2), WRSI14.29, IIF(MAX(WRSI14.28, 2) < WRSI14.30 AND WRSI14.30 > MAX(WRSI14.32, 2), WRSI14.30, IIF(MAX(WRSI14.29, 2) < WRSI14.31 AND WRSI14.31 > MAX(WRSI14.33, 2), WRSI14.31, IIF(MAX(WRSI14.30, 2) < WRSI14.32 AND WRSI14.32 > MAX(WRSI14.34, 2), WRSI14.32, IIF(MAX(WRSI14.31, 2) < WRSI14.33 AND WRSI14.33 > MAX(WRSI14.35, 2), WRSI14.33, IIF(MAX(WRSI14.32, 2) < WRSI14.34 AND WRSI14.34 > MAX(WRSI14.36, 2), WRSI14.34, IIF(MAX(WRSI14.33, 2) < WRSI14.35 AND WRSI14.35 > MAX(WRSI14.37, 2), WRSI14.35, IIF(MAX(WRSI14.34, 2) < WRSI14.36 AND WRSI14.36 > MAX(WRSI14.38, 2), WRSI14.36, IIF(MAX(WRSI14.35, 2) < WRSI14.37 AND WRSI14.37 > MAX(WRSI14.39, 2), WRSI14.37, IIF(MAX(WRSI14.36, 2) < WRSI14.38 AND WRSI14.38 > MAX(WRSI14.40, 2), WRSI14.38, IIF(MAX(WRSI14.37, 2) < WRSI14.39 AND WRSI14.39 > MAX(WRSI14.41, 2), WRSI14.39, IIF(MAX(WRSI14.38, 2) < WRSI14.40 AND WRSI14.40 > MAX(WRSI14.42, 2), WRSI14.40, IIF(MAX(WRSI14.39, 2) < WRSI14.41 AND WRSI14.41 > MAX(WRSI14.43, 2), WRSI14.41, IIF(MAX(WRSI14.40, 2) < WRSI14.42 AND WRSI14.42 > MAX(WRSI14.44, 2), WRSI14.42, IIF(MAX(WRSI14.41, 2) < WRSI14.43 AND WRSI14.43 > MAX(WRSI14.45, 2), WRSI14.43, IIF(MAX(WRSI14.42, 2) < WRSI14.44 AND WRSI14.44 > MAX(WRSI14.46, 2), WRSI14.44, IIF(MAX(WRSI14.43, 2) < WRSI14.45 AND WRSI14.45 > MAX(WRSI14.47, 2), WRSI14.45, IIF(MAX(WRSI14.44, 2) < WRSI14.46 AND WRSI14.46 > MAX(WRSI14.48, 2), WRSI14.46, IIF(MAX(WRSI14.45, 2) < WRSI14.47 AND WRSI14.47 > MAX(WRSI14.49, 2), WRSI14.47, IIF(MAX(WRSI14.46, 2) < WRSI14.48 AND WRSI14.48 > MAX(WRSI14.50, 2), WRSI14.48, IIF(MAX(WRSI14.47, 2) < WRSI14.49 AND WRSI14.49 > MAX(WRSI14.51, 2), WRSI14.49, IIF(MAX(WRSI14.48, 2) < WRSI14.50 AND WRSI14.50 > MAX(WRSI14.52, 2), WRSI14.50, IIF(MAX(WRSI14.49, 2) < WRSI14.51 AND WRSI14.51 > MAX(WRSI14.53, 2), WRSI14.51, IIF(MAX(WRSI14.50, 2) < WRSI14.52 AND WRSI14.52 > MAX(WRSI14.54, 2), WRSI14.52, IIF(MAX(WRSI14.51, 2) < WRSI14.53 AND WRSI14.53 > MAX(WRSI14.55, 2), WRSI14.53, IIF(MAX(WRSI14.52, 2) < WRSI14.54 AND WRSI14.54 > MAX(WRSI14.56, 2), WRSI14.54, IIF(MAX(WRSI14.53, 2) < WRSI14.55 AND WRSI14.55 > MAX(WRSI14.57, 2), WRSI14.55, IIF(MAX(WRSI14.54, 2) < WRSI14.56 AND WRSI14.56 > MAX(WRSI14.58, 2), WRSI14.56, IIF(MAX(WRSI14.55, 2) < WRSI14.57 AND WRSI14.57 > MAX(WRSI14.59, 2), WRSI14.57, IIF(MAX(WRSI14.56, 2) < WRSI14.58 AND WRSI14.58 > MAX(WRSI14.60, 2), WRSI14.58, IIF(MAX(WRSI14.57, 2) < WRSI14.59 AND WRSI14.59 > MAX(WRSI14.61, 2), WRSI14.59, IIF(MAX(WRSI14.58, 2) < WRSI14.60 AND WRSI14.60 > MAX(WRSI14.62, 2), WRSI14.60, IIF(MAX(WRSI14.59, 2) < WRSI14.61 AND WRSI14.61 > MAX(WRSI14.63, 2), WRSI14.61, IIF(MAX(WRSI14.60, 2) < WRSI14.62 AND WRSI14.62 > MAX(WRSI14.64, 2), WRSI14.62, IIF(MAX(WRSI14.61, 2) < WRSI14.63 AND WRSI14.63 > MAX(WRSI14.65, 2), WRSI14.63, IIF(MAX(WRSI14.62, 2) < WRSI14.64 AND WRSI14.64 > MAX(WRSI14.66, 2), WRSI14.64, IIF(MAX(WRSI14.63, 2) < WRSI14.65 AND WRSI14.65 > MAX(WRSI14.67, 2), WRSI14.65, IIF(MAX(WRSI14.64, 2) < WRSI14.66 AND WRSI14.66 > MAX(WRSI14.68, 2), WRSI14.66, IIF(MAX(WRSI14.65, 2) < WRSI14.67 AND WRSI14.67 > MAX(WRSI14.69, 2), WRSI14.67, 101))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)

Lower High:

IIF(MAX(WRSI14, 2) < WRSI14.2 AND WRSI14.2 > MAX(WRSI14.3, 2) AND WRSI14.2 < IIF(MAX(WRSI14.3, 2) < WRSI14.5 AND WRSI14.5 > MAX(WRSI14.7, 2), WRSI14.5, IIF(MAX(WRSI14.4, 2) < WRSI14.6 AND WRSI14.6 > MAX(WRSI14.8, 2), WRSI14.6, IIF(MAX(WRSI14.5, 2) < WRSI14.7 AND WRSI14.7 > MAX(WRSI14.9, 2), WRSI14.7, IIF(MAX(WRSI14.6, 2) < WRSI14.8 AND WRSI14.8 > MAX(WRSI14.10, 2), WRSI14.8, IIF(MAX(WRSI14.7, 2) < WRSI14.9 AND WRSI14.9 > MAX(WRSI14.11, 2), WRSI14.9, IIF(MAX(WRSI14.8, 2) < WRSI14.10 AND WRSI14.10 > MAX(WRSI14.12, 2), WRSI14.10, IIF(MAX(WRSI14.9, 2) < WRSI14.11 AND WRSI14.11 > MAX(WRSI14.13, 2), WRSI14.11, IIF(MAX(WRSI14.10, 2) < WRSI14.12 AND WRSI14.12 > MAX(WRSI14.14, 2), WRSI14.12, IIF(MAX(WRSI14.11, 2) < WRSI14.13 AND WRSI14.13 > MAX(WRSI14.15, 2), WRSI14.13, IIF(MAX(WRSI14.12, 2) < WRSI14.14 AND WRSI14.14 > MAX(WRSI14.16, 2), WRSI14.14, IIF(MAX(WRSI14.13, 2) < WRSI14.15 AND WRSI14.15 > MAX(WRSI14.17, 2), WRSI14.15, IIF(MAX(WRSI14.14, 2) < WRSI14.16 AND WRSI14.16 > MAX(WRSI14.18, 2), WRSI14.16, IIF(MAX(WRSI14.15, 2) < WRSI14.17 AND WRSI14.17 > MAX(WRSI14.19, 2), WRSI14.17, IIF(MAX(WRSI14.16, 2) < WRSI14.18 AND WRSI14.18 > MAX(WRSI14.20, 2), WRSI14.18, IIF(MAX(WRSI14.17, 2) < WRSI14.19 AND WRSI14.19 > MAX(WRSI14.21, 2), WRSI14.19, IIF(MAX(WRSI14.18, 2) < WRSI14.20 AND WRSI14.20 > MAX(WRSI14.22, 2), WRSI14.20, IIF(MAX(WRSI14.19, 2) < WRSI14.21 AND WRSI14.21 > MAX(WRSI14.23, 2), WRSI14.21, IIF(MAX(WRSI14.20, 2) < WRSI14.22 AND WRSI14.22 > MAX(WRSI14.24, 2), WRSI14.22, IIF(MAX(WRSI14.21, 2) < WRSI14.23 AND WRSI14.23 > MAX(WRSI14.25, 2), WRSI14.23, IIF(MAX(WRSI14.22, 2) < WRSI14.24 AND WRSI14.24 > MAX(WRSI14.26, 2), WRSI14.24, IIF(MAX(WRSI14.23, 2) < WRSI14.25 AND WRSI14.25 > MAX(WRSI14.27, 2), WRSI14.25, IIF(MAX(WRSI14.24, 2) < WRSI14.26 AND WRSI14.26 > MAX(WRSI14.28, 2), WRSI14.26, IIF(MAX(WRSI14.25, 2) < WRSI14.27 AND WRSI14.27 > MAX(WRSI14.29, 2), WRSI14.27, IIF(MAX(WRSI14.26, 2) < WRSI14.28 AND WRSI14.28 > MAX(WRSI14.30, 2), WRSI14.28, IIF(MAX(WRSI14.27, 2) < WRSI14.29 AND WRSI14.29 > MAX(WRSI14.31, 2), WRSI14.29, IIF(MAX(WRSI14.28, 2) < WRSI14.30 AND WRSI14.30 > MAX(WRSI14.32, 2), WRSI14.30, IIF(MAX(WRSI14.29, 2) < WRSI14.31 AND WRSI14.31 > MAX(WRSI14.33, 2), WRSI14.31, IIF(MAX(WRSI14.30, 2) < WRSI14.32 AND WRSI14.32 > MAX(WRSI14.34, 2), WRSI14.32, IIF(MAX(WRSI14.31, 2) < WRSI14.33 AND WRSI14.33 > MAX(WRSI14.35, 2), WRSI14.33, IIF(MAX(WRSI14.32, 2) < WRSI14.34 AND WRSI14.34 > MAX(WRSI14.36, 2), WRSI14.34, IIF(MAX(WRSI14.33, 2) < WRSI14.35 AND WRSI14.35 > MAX(WRSI14.37, 2), WRSI14.35, IIF(MAX(WRSI14.34, 2) < WRSI14.36 AND WRSI14.36 > MAX(WRSI14.38, 2), WRSI14.36, IIF(MAX(WRSI14.35, 2) < WRSI14.37 AND WRSI14.37 > MAX(WRSI14.39, 2), WRSI14.37, IIF(MAX(WRSI14.36, 2) < WRSI14.38 AND WRSI14.38 > MAX(WRSI14.40, 2), WRSI14.38, IIF(MAX(WRSI14.37, 2) < WRSI14.39 AND WRSI14.39 > MAX(WRSI14.41, 2), WRSI14.39, IIF(MAX(WRSI14.38, 2) < WRSI14.40 AND WRSI14.40 > MAX(WRSI14.42, 2), WRSI14.40, IIF(MAX(WRSI14.39, 2) < WRSI14.41 AND WRSI14.41 > MAX(WRSI14.43, 2), WRSI14.41, IIF(MAX(WRSI14.40, 2) < WRSI14.42 AND WRSI14.42 > MAX(WRSI14.44, 2), WRSI14.42, IIF(MAX(WRSI14.41, 2) < WRSI14.43 AND WRSI14.43 > MAX(WRSI14.45, 2), WRSI14.43, IIF(MAX(WRSI14.42, 2) < WRSI14.44 AND WRSI14.44 > MAX(WRSI14.46, 2), WRSI14.44, IIF(MAX(WRSI14.43, 2) < WRSI14.45 AND WRSI14.45 > MAX(WRSI14.47, 2), WRSI14.45, IIF(MAX(WRSI14.44, 2) < WRSI14.46 AND WRSI14.46 > MAX(WRSI14.48, 2), WRSI14.46, IIF(MAX(WRSI14.45, 2) < WRSI14.47 AND WRSI14.47 > MAX(WRSI14.49, 2), WRSI14.47, IIF(MAX(WRSI14.46, 2) < WRSI14.48 AND WRSI14.48 > MAX(WRSI14.50, 2), WRSI14.48, IIF(MAX(WRSI14.47, 2) < WRSI14.49 AND WRSI14.49 > MAX(WRSI14.51, 2), WRSI14.49, IIF(MAX(WRSI14.48, 2) < WRSI14.50 AND WRSI14.50 > MAX(WRSI14.52, 2), WRSI14.50, IIF(MAX(WRSI14.49, 2) < WRSI14.51 AND WRSI14.51 > MAX(WRSI14.53, 2), WRSI14.51, IIF(MAX(WRSI14.50, 2) < WRSI14.52 AND WRSI14.52 > MAX(WRSI14.54, 2), WRSI14.52, IIF(MAX(WRSI14.51, 2) < WRSI14.53 AND WRSI14.53 > MAX(WRSI14.55, 2), WRSI14.53, IIF(MAX(WRSI14.52, 2) < WRSI14.54 AND WRSI14.54 > MAX(WRSI14.56, 2), WRSI14.54, IIF(MAX(WRSI14.53, 2) < WRSI14.55 AND WRSI14.55 > MAX(WRSI14.57, 2), WRSI14.55, IIF(MAX(WRSI14.54, 2) < WRSI14.56 AND WRSI14.56 > MAX(WRSI14.58, 2), WRSI14.56, IIF(MAX(WRSI14.55, 2) < WRSI14.57 AND WRSI14.57 > MAX(WRSI14.59, 2), WRSI14.57, IIF(MAX(WRSI14.56, 2) < WRSI14.58 AND WRSI14.58 > MAX(WRSI14.60, 2), WRSI14.58, IIF(MAX(WRSI14.57, 2) < WRSI14.59 AND WRSI14.59 > MAX(WRSI14.61, 2), WRSI14.59, IIF(MAX(WRSI14.58, 2) < WRSI14.60 AND WRSI14.60 > MAX(WRSI14.62, 2), WRSI14.60, IIF(MAX(WRSI14.59, 2) < WRSI14.61 AND WRSI14.61 > MAX(WRSI14.63, 2), WRSI14.61, IIF(MAX(WRSI14.60, 2) < WRSI14.62 AND WRSI14.62 > MAX(WRSI14.64, 2), WRSI14.62, IIF(MAX(WRSI14.61, 2) < WRSI14.63 AND WRSI14.63 > MAX(WRSI14.65, 2), WRSI14.63, IIF(MAX(WRSI14.62, 2) < WRSI14.64 AND WRSI14.64 > MAX(WRSI14.66, 2), WRSI14.64, IIF(MAX(WRSI14.63, 2) < WRSI14.65 AND WRSI14.65 > MAX(WRSI14.67, 2), WRSI14.65, IIF(MAX(WRSI14.64, 2) < WRSI14.66 AND WRSI14.66 > MAX(WRSI14.68, 2), WRSI14.66, IIF(MAX(WRSI14.65, 2) < WRSI14.67 AND WRSI14.67 > MAX(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)

Higher Low:

IIF(MIN(WRSI14, 2) > WRSI14.2 AND WRSI14.2 < MIN(WRSI14.3, 2) AND WRSI14.2 > IIF(MIN(WRSI14.3, 2) > WRSI14.5 AND WRSI14.5 < MIN(WRSI14.7, 2), WRSI14.5, IIF(MIN(WRSI14.4, 2) > WRSI14.6 AND WRSI14.6 < MIN(WRSI14.8, 2), WRSI14.6, IIF(MIN(WRSI14.5, 2) > WRSI14.7 AND WRSI14.7 < MIN(WRSI14.9, 2), WRSI14.7, IIF(MIN(WRSI14.6, 2) > WRSI14.8 AND WRSI14.8 < MIN(WRSI14.10, 2), WRSI14.8, IIF(MIN(WRSI14.7, 2) > WRSI14.9 AND WRSI14.9 < MIN(WRSI14.11, 2), WRSI14.9, IIF(MIN(WRSI14.8, 2) > WRSI14.10 AND WRSI14.10 < MIN(WRSI14.12, 2), WRSI14.10, IIF(MIN(WRSI14.9, 2) > WRSI14.11 AND WRSI14.11 < MIN(WRSI14.13, 2), WRSI14.11, IIF(MIN(WRSI14.10, 2) > WRSI14.12 AND WRSI14.12 < MIN(WRSI14.14, 2), WRSI14.12, IIF(MIN(WRSI14.11, 2) > WRSI14.13 AND WRSI14.13 < MIN(WRSI14.15, 2), WRSI14.13, IIF(MIN(WRSI14.12, 2) > WRSI14.14 AND WRSI14.14 < MIN(WRSI14.16, 2), WRSI14.14, IIF(MIN(WRSI14.13, 2) > WRSI14.15 AND WRSI14.15 < MIN(WRSI14.17, 2), WRSI14.15, IIF(MIN(WRSI14.14, 2) > WRSI14.16 AND WRSI14.16 < MIN(WRSI14.18, 2), WRSI14.16, IIF(MIN(WRSI14.15, 2) > WRSI14.17 AND WRSI14.17 < MIN(WRSI14.19, 2), WRSI14.17, IIF(MIN(WRSI14.16, 2) > WRSI14.18 AND WRSI14.18 < MIN(WRSI14.20, 2), WRSI14.18, IIF(MIN(WRSI14.17, 2) > WRSI14.19 AND WRSI14.19 < MIN(WRSI14.21, 2), WRSI14.19, IIF(MIN(WRSI14.18, 2) > WRSI14.20 AND WRSI14.20 < MIN(WRSI14.22, 2), WRSI14.20, IIF(MIN(WRSI14.19, 2) > WRSI14.21 AND WRSI14.21 < MIN(WRSI14.23, 2), WRSI14.21, IIF(MIN(WRSI14.20, 2) > WRSI14.22 AND WRSI14.22 < MIN(WRSI14.24, 2), WRSI14.22, IIF(MIN(WRSI14.21, 2) > WRSI14.23 AND WRSI14.23 < MIN(WRSI14.25, 2), WRSI14.23, IIF(MIN(WRSI14.22, 2) > WRSI14.24 AND WRSI14.24 < MIN(WRSI14.26, 2), WRSI14.24, IIF(MIN(WRSI14.23, 2) > WRSI14.25 AND WRSI14.25 < MIN(WRSI14.27, 2), WRSI14.25, IIF(MIN(WRSI14.24, 2) > WRSI14.26 AND WRSI14.26 < MIN(WRSI14.28, 2), WRSI14.26, IIF(MIN(WRSI14.25, 2) > WRSI14.27 AND WRSI14.27 < MIN(WRSI14.29, 2), WRSI14.27, IIF(MIN(WRSI14.26, 2) > WRSI14.28 AND WRSI14.28 < MIN(WRSI14.30, 2), WRSI14.28, IIF(MIN(WRSI14.27, 2) > WRSI14.29 AND WRSI14.29 < MIN(WRSI14.31, 2), WRSI14.29, IIF(MIN(WRSI14.28, 2) > WRSI14.30 AND WRSI14.30 < MIN(WRSI14.32, 2), WRSI14.30, IIF(MIN(WRSI14.29, 2) > WRSI14.31 AND WRSI14.31 < MIN(WRSI14.33, 2), WRSI14.31, IIF(MIN(WRSI14.30, 2) > WRSI14.32 AND WRSI14.32 < MIN(WRSI14.34, 2), WRSI14.32, IIF(MIN(WRSI14.31, 2) > WRSI14.33 AND WRSI14.33 < MIN(WRSI14.35, 2), WRSI14.33, IIF(MIN(WRSI14.32, 2) > WRSI14.34 AND WRSI14.34 < MIN(WRSI14.36, 2), WRSI14.34, IIF(MIN(WRSI14.33, 2) > WRSI14.35 AND WRSI14.35 < MIN(WRSI14.37, 2), WRSI14.35, IIF(MIN(WRSI14.34, 2) > WRSI14.36 AND WRSI14.36 < MIN(WRSI14.38, 2), WRSI14.36, IIF(MIN(WRSI14.35, 2) > WRSI14.37 AND WRSI14.37 < MIN(WRSI14.39, 2), WRSI14.37, IIF(MIN(WRSI14.36, 2) > WRSI14.38 AND WRSI14.38 < MIN(WRSI14.40, 2), WRSI14.38, IIF(MIN(WRSI14.37, 2) > WRSI14.39 AND WRSI14.39 < MIN(WRSI14.41, 2), WRSI14.39, IIF(MIN(WRSI14.38, 2) > WRSI14.40 AND WRSI14.40 < MIN(WRSI14.42, 2), WRSI14.40, IIF(MIN(WRSI14.39, 2) > WRSI14.41 AND WRSI14.41 < MIN(WRSI14.43, 2), WRSI14.41, IIF(MIN(WRSI14.40, 2) > WRSI14.42 AND WRSI14.42 < MIN(WRSI14.44, 2), WRSI14.42, IIF(MIN(WRSI14.41, 2) > WRSI14.43 AND WRSI14.43 < MIN(WRSI14.45, 2), WRSI14.43, IIF(MIN(WRSI14.42, 2) > WRSI14.44 AND WRSI14.44 < MIN(WRSI14.46, 2), WRSI14.44, IIF(MIN(WRSI14.43, 2) > WRSI14.45 AND WRSI14.45 < MIN(WRSI14.47, 2), WRSI14.45, IIF(MIN(WRSI14.44, 2) > WRSI14.46 AND WRSI14.46 < MIN(WRSI14.48, 2), WRSI14.46, IIF(MIN(WRSI14.45, 2) > WRSI14.47 AND WRSI14.47 < MIN(WRSI14.49, 2), WRSI14.47, IIF(MIN(WRSI14.46, 2) > WRSI14.48 AND WRSI14.48 < MIN(WRSI14.50, 2), WRSI14.48, IIF(MIN(WRSI14.47, 2) > WRSI14.49 AND WRSI14.49 < MIN(WRSI14.51, 2), WRSI14.49, IIF(MIN(WRSI14.48, 2) > WRSI14.50 AND WRSI14.50 < MIN(WRSI14.52, 2), WRSI14.50, IIF(MIN(WRSI14.49, 2) > WRSI14.51 AND WRSI14.51 < MIN(WRSI14.53, 2), WRSI14.51, IIF(MIN(WRSI14.50, 2) > WRSI14.52 AND WRSI14.52 < MIN(WRSI14.54, 2), WRSI14.52, IIF(MIN(WRSI14.51, 2) > WRSI14.53 AND WRSI14.53 < MIN(WRSI14.55, 2), WRSI14.53, IIF(MIN(WRSI14.52, 2) > WRSI14.54 AND WRSI14.54 < MIN(WRSI14.56, 2), WRSI14.54, IIF(MIN(WRSI14.53, 2) > WRSI14.55 AND WRSI14.55 < MIN(WRSI14.57, 2), WRSI14.55, IIF(MIN(WRSI14.54, 2) > WRSI14.56 AND WRSI14.56 < MIN(WRSI14.58, 2), WRSI14.56, IIF(MIN(WRSI14.55, 2) > WRSI14.57 AND WRSI14.57 < MIN(WRSI14.59, 2), WRSI14.57, IIF(MIN(WRSI14.56, 2) > WRSI14.58 AND WRSI14.58 < MIN(WRSI14.60, 2), WRSI14.58, IIF(MIN(WRSI14.57, 2) > WRSI14.59 AND WRSI14.59 < MIN(WRSI14.61, 2), WRSI14.59, IIF(MIN(WRSI14.58, 2) > WRSI14.60 AND WRSI14.60 < MIN(WRSI14.62, 2), WRSI14.60, IIF(MIN(WRSI14.59, 2) > WRSI14.61 AND WRSI14.61 < MIN(WRSI14.63, 2), WRSI14.61, IIF(MIN(WRSI14.60, 2) > WRSI14.62 AND WRSI14.62 < MIN(WRSI14.64, 2), WRSI14.62, IIF(MIN(WRSI14.61, 2) > WRSI14.63 AND WRSI14.63 < MIN(WRSI14.65, 2), WRSI14.63, IIF(MIN(WRSI14.62, 2) > WRSI14.64 AND WRSI14.64 < MIN(WRSI14.66, 2), WRSI14.64, IIF(MIN(WRSI14.63, 2) > WRSI14.65 AND WRSI14.65 < MIN(WRSI14.67, 2), WRSI14.65, IIF(MIN(WRSI14.64, 2) > WRSI14.66 AND WRSI14.66 < MIN(WRSI14.68, 2), WRSI14.66, IIF(MIN(WRSI14.65, 2) > WRSI14.67 AND WRSI14.67 < MIN(WRSI14.69, 2), WRSI14.67, 101))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)

Lower Low:

IIF(MIN(WRSI14, 2) > WRSI14.2 AND WRSI14.2 < MIN(WRSI14.3, 2) AND WRSI14.2 < IIF(MIN(WRSI14.3, 2) > WRSI14.5 AND WRSI14.5 < MIN(WRSI14.7, 2), WRSI14.5, IIF(MIN(WRSI14.4, 2) > WRSI14.6 AND WRSI14.6 < MIN(WRSI14.8, 2), WRSI14.6, IIF(MIN(WRSI14.5, 2) > WRSI14.7 AND WRSI14.7 < MIN(WRSI14.9, 2), WRSI14.7, IIF(MIN(WRSI14.6, 2) > WRSI14.8 AND WRSI14.8 < MIN(WRSI14.10, 2), WRSI14.8, IIF(MIN(WRSI14.7, 2) > WRSI14.9 AND WRSI14.9 < MIN(WRSI14.11, 2), WRSI14.9, IIF(MIN(WRSI14.8, 2) > WRSI14.10 AND WRSI14.10 < MIN(WRSI14.12, 2), WRSI14.10, IIF(MIN(WRSI14.9, 2) > WRSI14.11 AND WRSI14.11 < MIN(WRSI14.13, 2), WRSI14.11, IIF(MIN(WRSI14.10, 2) > WRSI14.12 AND WRSI14.12 < MIN(WRSI14.14, 2), WRSI14.12, IIF(MIN(WRSI14.11, 2) > WRSI14.13 AND WRSI14.13 < MIN(WRSI14.15, 2), WRSI14.13, IIF(MIN(WRSI14.12, 2) > WRSI14.14 AND WRSI14.14 < MIN(WRSI14.16, 2), WRSI14.14, IIF(MIN(WRSI14.13, 2) > WRSI14.15 AND WRSI14.15 < MIN(WRSI14.17, 2), WRSI14.15, IIF(MIN(WRSI14.14, 2) > WRSI14.16 AND WRSI14.16 < MIN(WRSI14.18, 2), WRSI14.16, IIF(MIN(WRSI14.15, 2) > WRSI14.17 AND WRSI14.17 < MIN(WRSI14.19, 2), WRSI14.17, IIF(MIN(WRSI14.16, 2) > WRSI14.18 AND WRSI14.18 < MIN(WRSI14.20, 2), WRSI14.18, IIF(MIN(WRSI14.17, 2) > WRSI14.19 AND WRSI14.19 < MIN(WRSI14.21, 2), WRSI14.19, IIF(MIN(WRSI14.18, 2) > WRSI14.20 AND WRSI14.20 < MIN(WRSI14.22, 2), WRSI14.20, IIF(MIN(WRSI14.19, 2) > WRSI14.21 AND WRSI14.21 < MIN(WRSI14.23, 2), WRSI14.21, IIF(MIN(WRSI14.20, 2) > WRSI14.22 AND WRSI14.22 < MIN(WRSI14.24, 2), WRSI14.22, IIF(MIN(WRSI14.21, 2) > WRSI14.23 AND WRSI14.23 < MIN(WRSI14.25, 2), WRSI14.23, IIF(MIN(WRSI14.22, 2) > WRSI14.24 AND WRSI14.24 < MIN(WRSI14.26, 2), WRSI14.24, IIF(MIN(WRSI14.23, 2) > WRSI14.25 AND WRSI14.25 < MIN(WRSI14.27, 2), WRSI14.25, IIF(MIN(WRSI14.24, 2) > WRSI14.26 AND WRSI14.26 < MIN(WRSI14.28, 2), WRSI14.26, IIF(MIN(WRSI14.25, 2) > WRSI14.27 AND WRSI14.27 < MIN(WRSI14.29, 2), WRSI14.27, IIF(MIN(WRSI14.26, 2) > WRSI14.28 AND WRSI14.28 < MIN(WRSI14.30, 2), WRSI14.28, IIF(MIN(WRSI14.27, 2) > WRSI14.29 AND WRSI14.29 < MIN(WRSI14.31, 2), WRSI14.29, IIF(MIN(WRSI14.28, 2) > WRSI14.30 AND WRSI14.30 < MIN(WRSI14.32, 2), WRSI14.30, IIF(MIN(WRSI14.29, 2) > WRSI14.31 AND WRSI14.31 < MIN(WRSI14.33, 2), WRSI14.31, IIF(MIN(WRSI14.30, 2) > WRSI14.32 AND WRSI14.32 < MIN(WRSI14.34, 2), WRSI14.32, IIF(MIN(WRSI14.31, 2) > WRSI14.33 AND WRSI14.33 < MIN(WRSI14.35, 2), WRSI14.33, IIF(MIN(WRSI14.32, 2) > WRSI14.34 AND WRSI14.34 < MIN(WRSI14.36, 2), WRSI14.34, IIF(MIN(WRSI14.33, 2) > WRSI14.35 AND WRSI14.35 < MIN(WRSI14.37, 2), WRSI14.35, IIF(MIN(WRSI14.34, 2) > WRSI14.36 AND WRSI14.36 < MIN(WRSI14.38, 2), WRSI14.36, IIF(MIN(WRSI14.35, 2) > WRSI14.37 AND WRSI14.37 < MIN(WRSI14.39, 2), WRSI14.37, IIF(MIN(WRSI14.36, 2) > WRSI14.38 AND WRSI14.38 < MIN(WRSI14.40, 2), WRSI14.38, IIF(MIN(WRSI14.37, 2) > WRSI14.39 AND WRSI14.39 < MIN(WRSI14.41, 2), WRSI14.39, IIF(MIN(WRSI14.38, 2) > WRSI14.40 AND WRSI14.40 < MIN(WRSI14.42, 2), WRSI14.40, IIF(MIN(WRSI14.39, 2) > WRSI14.41 AND WRSI14.41 < MIN(WRSI14.43, 2), WRSI14.41, IIF(MIN(WRSI14.40, 2) > WRSI14.42 AND WRSI14.42 < MIN(WRSI14.44, 2), WRSI14.42, IIF(MIN(WRSI14.41, 2) > WRSI14.43 AND WRSI14.43 < MIN(WRSI14.45, 2), WRSI14.43, IIF(MIN(WRSI14.42, 2) > WRSI14.44 AND WRSI14.44 < MIN(WRSI14.46, 2), WRSI14.44, IIF(MIN(WRSI14.43, 2) > WRSI14.45 AND WRSI14.45 < MIN(WRSI14.47, 2), WRSI14.45, IIF(MIN(WRSI14.44, 2) > WRSI14.46 AND WRSI14.46 < MIN(WRSI14.48, 2), WRSI14.46, IIF(MIN(WRSI14.45, 2) > WRSI14.47 AND WRSI14.47 < MIN(WRSI14.49, 2), WRSI14.47, IIF(MIN(WRSI14.46, 2) > WRSI14.48 AND WRSI14.48 < MIN(WRSI14.50, 2), WRSI14.48, IIF(MIN(WRSI14.47, 2) > WRSI14.49 AND WRSI14.49 < MIN(WRSI14.51, 2), WRSI14.49, IIF(MIN(WRSI14.48, 2) > WRSI14.50 AND WRSI14.50 < MIN(WRSI14.52, 2), WRSI14.50, IIF(MIN(WRSI14.49, 2) > WRSI14.51 AND WRSI14.51 < MIN(WRSI14.53, 2), WRSI14.51, IIF(MIN(WRSI14.50, 2) > WRSI14.52 AND WRSI14.52 < MIN(WRSI14.54, 2), WRSI14.52, IIF(MIN(WRSI14.51, 2) > WRSI14.53 AND WRSI14.53 < MIN(WRSI14.55, 2), WRSI14.53, IIF(MIN(WRSI14.52, 2) > WRSI14.54 AND WRSI14.54 < MIN(WRSI14.56, 2), WRSI14.54, IIF(MIN(WRSI14.53, 2) > WRSI14.55 AND WRSI14.55 < MIN(WRSI14.57, 2), WRSI14.55, IIF(MIN(WRSI14.54, 2) > WRSI14.56 AND WRSI14.56 < MIN(WRSI14.58, 2), WRSI14.56, IIF(MIN(WRSI14.55, 2) > WRSI14.57 AND WRSI14.57 < MIN(WRSI14.59, 2), WRSI14.57, IIF(MIN(WRSI14.56, 2) > WRSI14.58 AND WRSI14.58 < MIN(WRSI14.60, 2), WRSI14.58, IIF(MIN(WRSI14.57, 2) > WRSI14.59 AND WRSI14.59 < MIN(WRSI14.61, 2), WRSI14.59, IIF(MIN(WRSI14.58, 2) > WRSI14.60 AND WRSI14.60 < MIN(WRSI14.62, 2), WRSI14.60, IIF(MIN(WRSI14.59, 2) > WRSI14.61 AND WRSI14.61 < MIN(WRSI14.63, 2), WRSI14.61, IIF(MIN(WRSI14.60, 2) > WRSI14.62 AND WRSI14.62 < MIN(WRSI14.64, 2), WRSI14.62, IIF(MIN(WRSI14.61, 2) > WRSI14.63 AND WRSI14.63 < MIN(WRSI14.65, 2), WRSI14.63, IIF(MIN(WRSI14.62, 2) > WRSI14.64 AND WRSI14.64 < MIN(WRSI14.66, 2), WRSI14.64, IIF(MIN(WRSI14.63, 2) > WRSI14.65 AND WRSI14.65 < MIN(WRSI14.67, 2), WRSI14.65, IIF(MIN(WRSI14.64, 2) > WRSI14.66 AND WRSI14.66 < MIN(WRSI14.68, 2), WRSI14.66, IIF(MIN(WRSI14.65, 2) > WRSI14.67 AND WRSI14.67 < MIN(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), WRSI14.2, -10)

 

Request2:

If there is a lower high it adds 1 to the value and if there is a lower low, it adds -1 to the value.

IIF(MAX(WRSI14, 2) < WRSI14.2 AND WRSI14.2 > MAX(WRSI14.3, 2) AND WRSI14.2 < IIF(MAX(WRSI14.3, 2) < WRSI14.5 AND WRSI14.5 > MAX(WRSI14.7, 2), WRSI14.5, IIF(MAX(WRSI14.4, 2) < WRSI14.6 AND WRSI14.6 > MAX(WRSI14.8, 2), WRSI14.6, IIF(MAX(WRSI14.5, 2) < WRSI14.7 AND WRSI14.7 > MAX(WRSI14.9, 2), WRSI14.7, IIF(MAX(WRSI14.6, 2) < WRSI14.8 AND WRSI14.8 > MAX(WRSI14.10, 2), WRSI14.8, IIF(MAX(WRSI14.7, 2) < WRSI14.9 AND WRSI14.9 > MAX(WRSI14.11, 2), WRSI14.9, IIF(MAX(WRSI14.8, 2) < WRSI14.10 AND WRSI14.10 > MAX(WRSI14.12, 2), WRSI14.10, IIF(MAX(WRSI14.9, 2) < WRSI14.11 AND WRSI14.11 > MAX(WRSI14.13, 2), WRSI14.11, IIF(MAX(WRSI14.10, 2) < WRSI14.12 AND WRSI14.12 > MAX(WRSI14.14, 2), WRSI14.12, IIF(MAX(WRSI14.11, 2) < WRSI14.13 AND WRSI14.13 > MAX(WRSI14.15, 2), WRSI14.13, IIF(MAX(WRSI14.12, 2) < WRSI14.14 AND WRSI14.14 > MAX(WRSI14.16, 2), WRSI14.14, IIF(MAX(WRSI14.13, 2) < WRSI14.15 AND WRSI14.15 > MAX(WRSI14.17, 2), WRSI14.15, IIF(MAX(WRSI14.14, 2) < WRSI14.16 AND WRSI14.16 > MAX(WRSI14.18, 2), WRSI14.16, IIF(MAX(WRSI14.15, 2) < WRSI14.17 AND WRSI14.17 > MAX(WRSI14.19, 2), WRSI14.17, IIF(MAX(WRSI14.16, 2) < WRSI14.18 AND WRSI14.18 > MAX(WRSI14.20, 2), WRSI14.18, IIF(MAX(WRSI14.17, 2) < WRSI14.19 AND WRSI14.19 > MAX(WRSI14.21, 2), WRSI14.19, IIF(MAX(WRSI14.18, 2) < WRSI14.20 AND WRSI14.20 > MAX(WRSI14.22, 2), WRSI14.20, IIF(MAX(WRSI14.19, 2) < WRSI14.21 AND WRSI14.21 > MAX(WRSI14.23, 2), WRSI14.21, IIF(MAX(WRSI14.20, 2) < WRSI14.22 AND WRSI14.22 > MAX(WRSI14.24, 2), WRSI14.22, IIF(MAX(WRSI14.21, 2) < WRSI14.23 AND WRSI14.23 > MAX(WRSI14.25, 2), WRSI14.23, IIF(MAX(WRSI14.22, 2) < WRSI14.24 AND WRSI14.24 > MAX(WRSI14.26, 2), WRSI14.24, IIF(MAX(WRSI14.23, 2) < WRSI14.25 AND WRSI14.25 > MAX(WRSI14.27, 2), WRSI14.25, IIF(MAX(WRSI14.24, 2) < WRSI14.26 AND WRSI14.26 > MAX(WRSI14.28, 2), WRSI14.26, IIF(MAX(WRSI14.25, 2) < WRSI14.27 AND WRSI14.27 > MAX(WRSI14.29, 2), WRSI14.27, IIF(MAX(WRSI14.26, 2) < WRSI14.28 AND WRSI14.28 > MAX(WRSI14.30, 2), WRSI14.28, IIF(MAX(WRSI14.27, 2) < WRSI14.29 AND WRSI14.29 > MAX(WRSI14.31, 2), WRSI14.29, IIF(MAX(WRSI14.28, 2) < WRSI14.30 AND WRSI14.30 > MAX(WRSI14.32, 2), WRSI14.30, IIF(MAX(WRSI14.29, 2) < WRSI14.31 AND WRSI14.31 > MAX(WRSI14.33, 2), WRSI14.31, IIF(MAX(WRSI14.30, 2) < WRSI14.32 AND WRSI14.32 > MAX(WRSI14.34, 2), WRSI14.32, IIF(MAX(WRSI14.31, 2) < WRSI14.33 AND WRSI14.33 > MAX(WRSI14.35, 2), WRSI14.33, IIF(MAX(WRSI14.32, 2) < WRSI14.34 AND WRSI14.34 > MAX(WRSI14.36, 2), WRSI14.34, IIF(MAX(WRSI14.33, 2) < WRSI14.35 AND WRSI14.35 > MAX(WRSI14.37, 2), WRSI14.35, IIF(MAX(WRSI14.34, 2) < WRSI14.36 AND WRSI14.36 > MAX(WRSI14.38, 2), WRSI14.36, IIF(MAX(WRSI14.35, 2) < WRSI14.37 AND WRSI14.37 > MAX(WRSI14.39, 2), WRSI14.37, IIF(MAX(WRSI14.36, 2) < WRSI14.38 AND WRSI14.38 > MAX(WRSI14.40, 2), WRSI14.38, IIF(MAX(WRSI14.37, 2) < WRSI14.39 AND WRSI14.39 > MAX(WRSI14.41, 2), WRSI14.39, IIF(MAX(WRSI14.38, 2) < WRSI14.40 AND WRSI14.40 > MAX(WRSI14.42, 2), WRSI14.40, IIF(MAX(WRSI14.39, 2) < WRSI14.41 AND WRSI14.41 > MAX(WRSI14.43, 2), WRSI14.41, IIF(MAX(WRSI14.40, 2) < WRSI14.42 AND WRSI14.42 > MAX(WRSI14.44, 2), WRSI14.42, IIF(MAX(WRSI14.41, 2) < WRSI14.43 AND WRSI14.43 > MAX(WRSI14.45, 2), WRSI14.43, IIF(MAX(WRSI14.42, 2) < WRSI14.44 AND WRSI14.44 > MAX(WRSI14.46, 2), WRSI14.44, IIF(MAX(WRSI14.43, 2) < WRSI14.45 AND WRSI14.45 > MAX(WRSI14.47, 2), WRSI14.45, IIF(MAX(WRSI14.44, 2) < WRSI14.46 AND WRSI14.46 > MAX(WRSI14.48, 2), WRSI14.46, IIF(MAX(WRSI14.45, 2) < WRSI14.47 AND WRSI14.47 > MAX(WRSI14.49, 2), WRSI14.47, IIF(MAX(WRSI14.46, 2) < WRSI14.48 AND WRSI14.48 > MAX(WRSI14.50, 2), WRSI14.48, IIF(MAX(WRSI14.47, 2) < WRSI14.49 AND WRSI14.49 > MAX(WRSI14.51, 2), WRSI14.49, IIF(MAX(WRSI14.48, 2) < WRSI14.50 AND WRSI14.50 > MAX(WRSI14.52, 2), WRSI14.50, IIF(MAX(WRSI14.49, 2) < WRSI14.51 AND WRSI14.51 > MAX(WRSI14.53, 2), WRSI14.51, IIF(MAX(WRSI14.50, 2) < WRSI14.52 AND WRSI14.52 > MAX(WRSI14.54, 2), WRSI14.52, IIF(MAX(WRSI14.51, 2) < WRSI14.53 AND WRSI14.53 > MAX(WRSI14.55, 2), WRSI14.53, IIF(MAX(WRSI14.52, 2) < WRSI14.54 AND WRSI14.54 > MAX(WRSI14.56, 2), WRSI14.54, IIF(MAX(WRSI14.53, 2) < WRSI14.55 AND WRSI14.55 > MAX(WRSI14.57, 2), WRSI14.55, IIF(MAX(WRSI14.54, 2) < WRSI14.56 AND WRSI14.56 > MAX(WRSI14.58, 2), WRSI14.56, IIF(MAX(WRSI14.55, 2) < WRSI14.57 AND WRSI14.57 > MAX(WRSI14.59, 2), WRSI14.57, IIF(MAX(WRSI14.56, 2) < WRSI14.58 AND WRSI14.58 > MAX(WRSI14.60, 2), WRSI14.58, IIF(MAX(WRSI14.57, 2) < WRSI14.59 AND WRSI14.59 > MAX(WRSI14.61, 2), WRSI14.59, IIF(MAX(WRSI14.58, 2) < WRSI14.60 AND WRSI14.60 > MAX(WRSI14.62, 2), WRSI14.60, IIF(MAX(WRSI14.59, 2) < WRSI14.61 AND WRSI14.61 > MAX(WRSI14.63, 2), WRSI14.61, IIF(MAX(WRSI14.60, 2) < WRSI14.62 AND WRSI14.62 > MAX(WRSI14.64, 2), WRSI14.62, IIF(MAX(WRSI14.61, 2) < WRSI14.63 AND WRSI14.63 > MAX(WRSI14.65, 2), WRSI14.63, IIF(MAX(WRSI14.62, 2) < WRSI14.64 AND WRSI14.64 > MAX(WRSI14.66, 2), WRSI14.64, IIF(MAX(WRSI14.63, 2) < WRSI14.65 AND WRSI14.65 > MAX(WRSI14.67, 2), WRSI14.65, IIF(MAX(WRSI14.64, 2) < WRSI14.66 AND WRSI14.66 > MAX(WRSI14.68, 2), WRSI14.66, IIF(MAX(WRSI14.65, 2) < WRSI14.67 AND WRSI14.67 > MAX(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 1, 0) + IIF(MIN(WRSI14, 2) > WRSI14.2 AND WRSI14.2 < MIN(WRSI14.3, 2) AND WRSI14.2 < IIF(MIN(WRSI14.3, 2) > WRSI14.5 AND WRSI14.5 < MIN(WRSI14.7, 2), WRSI14.5, IIF(MIN(WRSI14.4, 2) > WRSI14.6 AND WRSI14.6 < MIN(WRSI14.8, 2), WRSI14.6, IIF(MIN(WRSI14.5, 2) > WRSI14.7 AND WRSI14.7 < MIN(WRSI14.9, 2), WRSI14.7, IIF(MIN(WRSI14.6, 2) > WRSI14.8 AND WRSI14.8 < MIN(WRSI14.10, 2), WRSI14.8, IIF(MIN(WRSI14.7, 2) > WRSI14.9 AND WRSI14.9 < MIN(WRSI14.11, 2), WRSI14.9, IIF(MIN(WRSI14.8, 2) > WRSI14.10 AND WRSI14.10 < MIN(WRSI14.12, 2), WRSI14.10, IIF(MIN(WRSI14.9, 2) > WRSI14.11 AND WRSI14.11 < MIN(WRSI14.13, 2), WRSI14.11, IIF(MIN(WRSI14.10, 2) > WRSI14.12 AND WRSI14.12 < MIN(WRSI14.14, 2), WRSI14.12, IIF(MIN(WRSI14.11, 2) > WRSI14.13 AND WRSI14.13 < MIN(WRSI14.15, 2), WRSI14.13, IIF(MIN(WRSI14.12, 2) > WRSI14.14 AND WRSI14.14 < MIN(WRSI14.16, 2), WRSI14.14, IIF(MIN(WRSI14.13, 2) > WRSI14.15 AND WRSI14.15 < MIN(WRSI14.17, 2), WRSI14.15, IIF(MIN(WRSI14.14, 2) > WRSI14.16 AND WRSI14.16 < MIN(WRSI14.18, 2), WRSI14.16, IIF(MIN(WRSI14.15, 2) > WRSI14.17 AND WRSI14.17 < MIN(WRSI14.19, 2), WRSI14.17, IIF(MIN(WRSI14.16, 2) > WRSI14.18 AND WRSI14.18 < MIN(WRSI14.20, 2), WRSI14.18, IIF(MIN(WRSI14.17, 2) > WRSI14.19 AND WRSI14.19 < MIN(WRSI14.21, 2), WRSI14.19, IIF(MIN(WRSI14.18, 2) > WRSI14.20 AND WRSI14.20 < MIN(WRSI14.22, 2), WRSI14.20, IIF(MIN(WRSI14.19, 2) > WRSI14.21 AND WRSI14.21 < MIN(WRSI14.23, 2), WRSI14.21, IIF(MIN(WRSI14.20, 2) > WRSI14.22 AND WRSI14.22 < MIN(WRSI14.24, 2), WRSI14.22, IIF(MIN(WRSI14.21, 2) > WRSI14.23 AND WRSI14.23 < MIN(WRSI14.25, 2), WRSI14.23, IIF(MIN(WRSI14.22, 2) > WRSI14.24 AND WRSI14.24 < MIN(WRSI14.26, 2), WRSI14.24, IIF(MIN(WRSI14.23, 2) > WRSI14.25 AND WRSI14.25 < MIN(WRSI14.27, 2), WRSI14.25, IIF(MIN(WRSI14.24, 2) > WRSI14.26 AND WRSI14.26 < MIN(WRSI14.28, 2), WRSI14.26, IIF(MIN(WRSI14.25, 2) > WRSI14.27 AND WRSI14.27 < MIN(WRSI14.29, 2), WRSI14.27, IIF(MIN(WRSI14.26, 2) > WRSI14.28 AND WRSI14.28 < MIN(WRSI14.30, 2), WRSI14.28, IIF(MIN(WRSI14.27, 2) > WRSI14.29 AND WRSI14.29 < MIN(WRSI14.31, 2), WRSI14.29, IIF(MIN(WRSI14.28, 2) > WRSI14.30 AND WRSI14.30 < MIN(WRSI14.32, 2), WRSI14.30, IIF(MIN(WRSI14.29, 2) > WRSI14.31 AND WRSI14.31 < MIN(WRSI14.33, 2), WRSI14.31, IIF(MIN(WRSI14.30, 2) > WRSI14.32 AND WRSI14.32 < MIN(WRSI14.34, 2), WRSI14.32, IIF(MIN(WRSI14.31, 2) > WRSI14.33 AND WRSI14.33 < MIN(WRSI14.35, 2), WRSI14.33, IIF(MIN(WRSI14.32, 2) > WRSI14.34 AND WRSI14.34 < MIN(WRSI14.36, 2), WRSI14.34, IIF(MIN(WRSI14.33, 2) > WRSI14.35 AND WRSI14.35 < MIN(WRSI14.37, 2), WRSI14.35, IIF(MIN(WRSI14.34, 2) > WRSI14.36 AND WRSI14.36 < MIN(WRSI14.38, 2), WRSI14.36, IIF(MIN(WRSI14.35, 2) > WRSI14.37 AND WRSI14.37 < MIN(WRSI14.39, 2), WRSI14.37, IIF(MIN(WRSI14.36, 2) > WRSI14.38 AND WRSI14.38 < MIN(WRSI14.40, 2), WRSI14.38, IIF(MIN(WRSI14.37, 2) > WRSI14.39 AND WRSI14.39 < MIN(WRSI14.41, 2), WRSI14.39, IIF(MIN(WRSI14.38, 2) > WRSI14.40 AND WRSI14.40 < MIN(WRSI14.42, 2), WRSI14.40, IIF(MIN(WRSI14.39, 2) > WRSI14.41 AND WRSI14.41 < MIN(WRSI14.43, 2), WRSI14.41, IIF(MIN(WRSI14.40, 2) > WRSI14.42 AND WRSI14.42 < MIN(WRSI14.44, 2), WRSI14.42, IIF(MIN(WRSI14.41, 2) > WRSI14.43 AND WRSI14.43 < MIN(WRSI14.45, 2), WRSI14.43, IIF(MIN(WRSI14.42, 2) > WRSI14.44 AND WRSI14.44 < MIN(WRSI14.46, 2), WRSI14.44, IIF(MIN(WRSI14.43, 2) > WRSI14.45 AND WRSI14.45 < MIN(WRSI14.47, 2), WRSI14.45, IIF(MIN(WRSI14.44, 2) > WRSI14.46 AND WRSI14.46 < MIN(WRSI14.48, 2), WRSI14.46, IIF(MIN(WRSI14.45, 2) > WRSI14.47 AND WRSI14.47 < MIN(WRSI14.49, 2), WRSI14.47, IIF(MIN(WRSI14.46, 2) > WRSI14.48 AND WRSI14.48 < MIN(WRSI14.50, 2), WRSI14.48, IIF(MIN(WRSI14.47, 2) > WRSI14.49 AND WRSI14.49 < MIN(WRSI14.51, 2), WRSI14.49, IIF(MIN(WRSI14.48, 2) > WRSI14.50 AND WRSI14.50 < MIN(WRSI14.52, 2), WRSI14.50, IIF(MIN(WRSI14.49, 2) > WRSI14.51 AND WRSI14.51 < MIN(WRSI14.53, 2), WRSI14.51, IIF(MIN(WRSI14.50, 2) > WRSI14.52 AND WRSI14.52 < MIN(WRSI14.54, 2), WRSI14.52, IIF(MIN(WRSI14.51, 2) > WRSI14.53 AND WRSI14.53 < MIN(WRSI14.55, 2), WRSI14.53, IIF(MIN(WRSI14.52, 2) > WRSI14.54 AND WRSI14.54 < MIN(WRSI14.56, 2), WRSI14.54, IIF(MIN(WRSI14.53, 2) > WRSI14.55 AND WRSI14.55 < MIN(WRSI14.57, 2), WRSI14.55, IIF(MIN(WRSI14.54, 2) > WRSI14.56 AND WRSI14.56 < MIN(WRSI14.58, 2), WRSI14.56, IIF(MIN(WRSI14.55, 2) > WRSI14.57 AND WRSI14.57 < MIN(WRSI14.59, 2), WRSI14.57, IIF(MIN(WRSI14.56, 2) > WRSI14.58 AND WRSI14.58 < MIN(WRSI14.60, 2), WRSI14.58, IIF(MIN(WRSI14.57, 2) > WRSI14.59 AND WRSI14.59 < MIN(WRSI14.61, 2), WRSI14.59, IIF(MIN(WRSI14.58, 2) > WRSI14.60 AND WRSI14.60 < MIN(WRSI14.62, 2), WRSI14.60, IIF(MIN(WRSI14.59, 2) > WRSI14.61 AND WRSI14.61 < MIN(WRSI14.63, 2), WRSI14.61, IIF(MIN(WRSI14.60, 2) > WRSI14.62 AND WRSI14.62 < MIN(WRSI14.64, 2), WRSI14.62, IIF(MIN(WRSI14.61, 2) > WRSI14.63 AND WRSI14.63 < MIN(WRSI14.65, 2), WRSI14.63, IIF(MIN(WRSI14.62, 2) > WRSI14.64 AND WRSI14.64 < MIN(WRSI14.66, 2), WRSI14.64, IIF(MIN(WRSI14.63, 2) > WRSI14.65 AND WRSI14.65 < MIN(WRSI14.67, 2), WRSI14.65, IIF(MIN(WRSI14.64, 2) > WRSI14.66 AND WRSI14.66 < MIN(WRSI14.68, 2), WRSI14.66, IIF(MIN(WRSI14.65, 2) > WRSI14.67 AND WRSI14.67 < MIN(WRSI14.69, 2), WRSI14.67, -1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), -1, 0)

 

Request3: template

The template is pretty straightforward.

IIF(Boolean formula here, 1, 0) + IIF(Boolean formula here, -1, 0)

Really a better option is to modify those formulas and then put a + in between them.

Replace the WRSI14.2, -10) at the end with either 1, 0) or -1, 0) depending on if it is the formula you want to use to add 1 or the formula you want to use to add -1.

Request4:  stochastic using the settings as period 5  %k 2 and %D 3 averages simple
Higher High:

IIF(MAX(AVG(STOC5.2, 3), 2) < AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) > MAX(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) > IIF(MAX(AVG(STOC5.2.3, 3), 2) < AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) > MAX(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MAX(AVG(STOC5.2.4, 3), 2) < AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) > MAX(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MAX(AVG(STOC5.2.5, 3), 2) < AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) > MAX(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MAX(AVG(STOC5.2.6, 3), 2) < AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) > MAX(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MAX(AVG(STOC5.2.7, 3), 2) < AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) > MAX(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MAX(AVG(STOC5.2.8, 3), 2) < AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) > MAX(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MAX(AVG(STOC5.2.9, 3), 2) < AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) > MAX(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MAX(AVG(STOC5.2.10, 3), 2) < AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) > MAX(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MAX(AVG(STOC5.2.11, 3), 2) < AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) > MAX(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MAX(AVG(STOC5.2.12, 3), 2) < AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) > MAX(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MAX(AVG(STOC5.2.13, 3), 2) < AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) > MAX(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MAX(AVG(STOC5.2.14, 3), 2) < AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) > MAX(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MAX(AVG(STOC5.2.15, 3), 2) < AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) > MAX(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MAX(AVG(STOC5.2.16, 3), 2) < AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) > MAX(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MAX(AVG(STOC5.2.17, 3), 2) < AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) > MAX(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MAX(AVG(STOC5.2.18, 3), 2) < AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) > MAX(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MAX(AVG(STOC5.2.19, 3), 2) < AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) > MAX(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MAX(AVG(STOC5.2.20, 3), 2) < AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) > MAX(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MAX(AVG(STOC5.2.21, 3), 2) < AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) > MAX(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MAX(AVG(STOC5.2.22, 3), 2) < AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) > MAX(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MAX(AVG(STOC5.2.23, 3), 2) < AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) > MAX(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MAX(AVG(STOC5.2.24, 3), 2) < AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) > MAX(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MAX(AVG(STOC5.2.25, 3), 2) < AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) > MAX(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MAX(AVG(STOC5.2.26, 3), 2) < AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) > MAX(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MAX(AVG(STOC5.2.27, 3), 2) < AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) > MAX(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MAX(AVG(STOC5.2.28, 3), 2) < AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) > MAX(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MAX(AVG(STOC5.2.29, 3), 2) < AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) > MAX(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MAX(AVG(STOC5.2.30, 3), 2) < AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) > MAX(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MAX(AVG(STOC5.2.31, 3), 2) < AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) > MAX(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MAX(AVG(STOC5.2.32, 3), 2) < AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) > MAX(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MAX(AVG(STOC5.2.33, 3), 2) < AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) > MAX(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), 101))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)

Lower High:

IIF(MAX(AVG(STOC5.2, 3), 2) < AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) > MAX(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) < IIF(MAX(AVG(STOC5.2.3, 3), 2) < AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) > MAX(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MAX(AVG(STOC5.2.4, 3), 2) < AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) > MAX(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MAX(AVG(STOC5.2.5, 3), 2) < AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) > MAX(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MAX(AVG(STOC5.2.6, 3), 2) < AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) > MAX(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MAX(AVG(STOC5.2.7, 3), 2) < AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) > MAX(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MAX(AVG(STOC5.2.8, 3), 2) < AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) > MAX(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MAX(AVG(STOC5.2.9, 3), 2) < AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) > MAX(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MAX(AVG(STOC5.2.10, 3), 2) < AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) > MAX(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MAX(AVG(STOC5.2.11, 3), 2) < AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) > MAX(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MAX(AVG(STOC5.2.12, 3), 2) < AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) > MAX(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MAX(AVG(STOC5.2.13, 3), 2) < AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) > MAX(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MAX(AVG(STOC5.2.14, 3), 2) < AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) > MAX(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MAX(AVG(STOC5.2.15, 3), 2) < AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) > MAX(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MAX(AVG(STOC5.2.16, 3), 2) < AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) > MAX(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MAX(AVG(STOC5.2.17, 3), 2) < AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) > MAX(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MAX(AVG(STOC5.2.18, 3), 2) < AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) > MAX(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MAX(AVG(STOC5.2.19, 3), 2) < AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) > MAX(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MAX(AVG(STOC5.2.20, 3), 2) < AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) > MAX(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MAX(AVG(STOC5.2.21, 3), 2) < AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) > MAX(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MAX(AVG(STOC5.2.22, 3), 2) < AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) > MAX(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MAX(AVG(STOC5.2.23, 3), 2) < AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) > MAX(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MAX(AVG(STOC5.2.24, 3), 2) < AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) > MAX(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MAX(AVG(STOC5.2.25, 3), 2) < AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) > MAX(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MAX(AVG(STOC5.2.26, 3), 2) < AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) > MAX(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MAX(AVG(STOC5.2.27, 3), 2) < AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) > MAX(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MAX(AVG(STOC5.2.28, 3), 2) < AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) > MAX(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MAX(AVG(STOC5.2.29, 3), 2) < AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) > MAX(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MAX(AVG(STOC5.2.30, 3), 2) < AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) > MAX(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MAX(AVG(STOC5.2.31, 3), 2) < AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) > MAX(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MAX(AVG(STOC5.2.32, 3), 2) < AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) > MAX(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MAX(AVG(STOC5.2.33, 3), 2) < AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) > MAX(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), -1))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)

Higher Low:

IIF(MIN(AVG(STOC5.2, 3), 2) > AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) < MIN(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) > IIF(MIN(AVG(STOC5.2.3, 3), 2) > AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) < MIN(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MIN(AVG(STOC5.2.4, 3), 2) > AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) < MIN(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MIN(AVG(STOC5.2.5, 3), 2) > AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) < MIN(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MIN(AVG(STOC5.2.6, 3), 2) > AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) < MIN(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MIN(AVG(STOC5.2.7, 3), 2) > AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) < MIN(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MIN(AVG(STOC5.2.8, 3), 2) > AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) < MIN(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MIN(AVG(STOC5.2.9, 3), 2) > AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) < MIN(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MIN(AVG(STOC5.2.10, 3), 2) > AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) < MIN(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MIN(AVG(STOC5.2.11, 3), 2) > AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) < MIN(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MIN(AVG(STOC5.2.12, 3), 2) > AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) < MIN(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MIN(AVG(STOC5.2.13, 3), 2) > AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) < MIN(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MIN(AVG(STOC5.2.14, 3), 2) > AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) < MIN(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MIN(AVG(STOC5.2.15, 3), 2) > AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) < MIN(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MIN(AVG(STOC5.2.16, 3), 2) > AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) < MIN(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MIN(AVG(STOC5.2.17, 3), 2) > AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) < MIN(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MIN(AVG(STOC5.2.18, 3), 2) > AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) < MIN(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MIN(AVG(STOC5.2.19, 3), 2) > AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) < MIN(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MIN(AVG(STOC5.2.20, 3), 2) > AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) < MIN(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MIN(AVG(STOC5.2.21, 3), 2) > AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) < MIN(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MIN(AVG(STOC5.2.22, 3), 2) > AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) < MIN(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MIN(AVG(STOC5.2.23, 3), 2) > AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) < MIN(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MIN(AVG(STOC5.2.24, 3), 2) > AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) < MIN(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MIN(AVG(STOC5.2.25, 3), 2) > AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) < MIN(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MIN(AVG(STOC5.2.26, 3), 2) > AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) < MIN(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MIN(AVG(STOC5.2.27, 3), 2) > AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) < MIN(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MIN(AVG(STOC5.2.28, 3), 2) > AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) < MIN(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MIN(AVG(STOC5.2.29, 3), 2) > AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) < MIN(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MIN(AVG(STOC5.2.30, 3), 2) > AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) < MIN(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MIN(AVG(STOC5.2.31, 3), 2) > AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) < MIN(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MIN(AVG(STOC5.2.32, 3), 2) > AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) < MIN(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MIN(AVG(STOC5.2.33, 3), 2) > AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) < MIN(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), 101))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)

Lower Low:

IIF(MIN(AVG(STOC5.2, 3), 2) > AVG(STOC5.2.2, 3) AND AVG(STOC5.2.2, 3) < MIN(AVG(STOC5.2.3, 3), 2) AND AVG(STOC5.2.2, 3) < IIF(MIN(AVG(STOC5.2.3, 3), 2) > AVG(STOC5.2.5, 3) AND AVG(STOC5.2.5, 3) < MIN(AVG(STOC5.2.6, 3), 2), AVG(STOC5.2.5, 3), IIF(MIN(AVG(STOC5.2.4, 3), 2) > AVG(STOC5.2.6, 3) AND AVG(STOC5.2.6, 3) < MIN(AVG(STOC5.2.7, 3), 2), AVG(STOC5.2.6, 3), IIF(MIN(AVG(STOC5.2.5, 3), 2) > AVG(STOC5.2.7, 3) AND AVG(STOC5.2.7, 3) < MIN(AVG(STOC5.2.8, 3), 2), AVG(STOC5.2.7, 3), IIF(MIN(AVG(STOC5.2.6, 3), 2) > AVG(STOC5.2.8, 3) AND AVG(STOC5.2.8, 3) < MIN(AVG(STOC5.2.9, 3), 2), AVG(STOC5.2.8, 3), IIF(MIN(AVG(STOC5.2.7, 3), 2) > AVG(STOC5.2.9, 3) AND AVG(STOC5.2.9, 3) < MIN(AVG(STOC5.2.10, 3), 2), AVG(STOC5.2.9, 3), IIF(MIN(AVG(STOC5.2.8, 3), 2) > AVG(STOC5.2.10, 3) AND AVG(STOC5.2.10, 3) < MIN(AVG(STOC5.2.11, 3), 2), AVG(STOC5.2.10, 3), IIF(MIN(AVG(STOC5.2.9, 3), 2) > AVG(STOC5.2.11, 3) AND AVG(STOC5.2.11, 3) < MIN(AVG(STOC5.2.12, 3), 2), AVG(STOC5.2.11, 3), IIF(MIN(AVG(STOC5.2.10, 3), 2) > AVG(STOC5.2.12, 3) AND AVG(STOC5.2.12, 3) < MIN(AVG(STOC5.2.13, 3), 2), AVG(STOC5.2.12, 3), IIF(MIN(AVG(STOC5.2.11, 3), 2) > AVG(STOC5.2.13, 3) AND AVG(STOC5.2.13, 3) < MIN(AVG(STOC5.2.14, 3), 2), AVG(STOC5.2.13, 3), IIF(MIN(AVG(STOC5.2.12, 3), 2) > AVG(STOC5.2.14, 3) AND AVG(STOC5.2.14, 3) < MIN(AVG(STOC5.2.15, 3), 2), AVG(STOC5.2.14, 3), IIF(MIN(AVG(STOC5.2.13, 3), 2) > AVG(STOC5.2.15, 3) AND AVG(STOC5.2.15, 3) < MIN(AVG(STOC5.2.16, 3), 2), AVG(STOC5.2.15, 3), IIF(MIN(AVG(STOC5.2.14, 3), 2) > AVG(STOC5.2.16, 3) AND AVG(STOC5.2.16, 3) < MIN(AVG(STOC5.2.17, 3), 2), AVG(STOC5.2.16, 3), IIF(MIN(AVG(STOC5.2.15, 3), 2) > AVG(STOC5.2.17, 3) AND AVG(STOC5.2.17, 3) < MIN(AVG(STOC5.2.18, 3), 2), AVG(STOC5.2.17, 3), IIF(MIN(AVG(STOC5.2.16, 3), 2) > AVG(STOC5.2.18, 3) AND AVG(STOC5.2.18, 3) < MIN(AVG(STOC5.2.19, 3), 2), AVG(STOC5.2.18, 3), IIF(MIN(AVG(STOC5.2.17, 3), 2) > AVG(STOC5.2.19, 3) AND AVG(STOC5.2.19, 3) < MIN(AVG(STOC5.2.20, 3), 2), AVG(STOC5.2.19, 3), IIF(MIN(AVG(STOC5.2.18, 3), 2) > AVG(STOC5.2.20, 3) AND AVG(STOC5.2.20, 3) < MIN(AVG(STOC5.2.21, 3), 2), AVG(STOC5.2.20, 3), IIF(MIN(AVG(STOC5.2.19, 3), 2) > AVG(STOC5.2.21, 3) AND AVG(STOC5.2.21, 3) < MIN(AVG(STOC5.2.22, 3), 2), AVG(STOC5.2.21, 3), IIF(MIN(AVG(STOC5.2.20, 3), 2) > AVG(STOC5.2.22, 3) AND AVG(STOC5.2.22, 3) < MIN(AVG(STOC5.2.23, 3), 2), AVG(STOC5.2.22, 3), IIF(MIN(AVG(STOC5.2.21, 3), 2) > AVG(STOC5.2.23, 3) AND AVG(STOC5.2.23, 3) < MIN(AVG(STOC5.2.24, 3), 2), AVG(STOC5.2.23, 3), IIF(MIN(AVG(STOC5.2.22, 3), 2) > AVG(STOC5.2.24, 3) AND AVG(STOC5.2.24, 3) < MIN(AVG(STOC5.2.25, 3), 2), AVG(STOC5.2.24, 3), IIF(MIN(AVG(STOC5.2.23, 3), 2) > AVG(STOC5.2.25, 3) AND AVG(STOC5.2.25, 3) < MIN(AVG(STOC5.2.26, 3), 2), AVG(STOC5.2.25, 3), IIF(MIN(AVG(STOC5.2.24, 3), 2) > AVG(STOC5.2.26, 3) AND AVG(STOC5.2.26, 3) < MIN(AVG(STOC5.2.27, 3), 2), AVG(STOC5.2.26, 3), IIF(MIN(AVG(STOC5.2.25, 3), 2) > AVG(STOC5.2.27, 3) AND AVG(STOC5.2.27, 3) < MIN(AVG(STOC5.2.28, 3), 2), AVG(STOC5.2.27, 3), IIF(MIN(AVG(STOC5.2.26, 3), 2) > AVG(STOC5.2.28, 3) AND AVG(STOC5.2.28, 3) < MIN(AVG(STOC5.2.29, 3), 2), AVG(STOC5.2.28, 3), IIF(MIN(AVG(STOC5.2.27, 3), 2) > AVG(STOC5.2.29, 3) AND AVG(STOC5.2.29, 3) < MIN(AVG(STOC5.2.30, 3), 2), AVG(STOC5.2.29, 3), IIF(MIN(AVG(STOC5.2.28, 3), 2) > AVG(STOC5.2.30, 3) AND AVG(STOC5.2.30, 3) < MIN(AVG(STOC5.2.31, 3), 2), AVG(STOC5.2.30, 3), IIF(MIN(AVG(STOC5.2.29, 3), 2) > AVG(STOC5.2.31, 3) AND AVG(STOC5.2.31, 3) < MIN(AVG(STOC5.2.32, 3), 2), AVG(STOC5.2.31, 3), IIF(MIN(AVG(STOC5.2.30, 3), 2) > AVG(STOC5.2.32, 3) AND AVG(STOC5.2.32, 3) < MIN(AVG(STOC5.2.33, 3), 2), AVG(STOC5.2.32, 3), IIF(MIN(AVG(STOC5.2.31, 3), 2) > AVG(STOC5.2.33, 3) AND AVG(STOC5.2.33, 3) < MIN(AVG(STOC5.2.34, 3), 2), AVG(STOC5.2.33, 3), IIF(MIN(AVG(STOC5.2.32, 3), 2) > AVG(STOC5.2.34, 3) AND AVG(STOC5.2.34, 3) < MIN(AVG(STOC5.2.35, 3), 2), AVG(STOC5.2.34, 3), IIF(MIN(AVG(STOC5.2.33, 3), 2) > AVG(STOC5.2.35, 3) AND AVG(STOC5.2.35, 3) < MIN(AVG(STOC5.2.36, 3), 2), AVG(STOC5.2.35, 3), -1))))))))))))))))))))))))))))))), AVG(STOC5.2.2, 3), -10)
 
 

Request5: 

1) If current WRSI14 is crossing up HH or LH from past then show me spike one colour

2) If current WRSI14 is crossing down HL or LL from past then show me spike as second colour

Please try the following for crossing up the most recent high.

XUP(WRSI14, IIF(WRSI14.3 > GREATEST(MAX(WRSI14.1, 2), MAX(WRSI14.4, 2)), WRSI14.3, IIF(WRSI14.4 > GREATEST(MAX(WRSI14.2, 2), MAX(WRSI14.5, 2)), WRSI14.4, IIF(WRSI14.5 > GREATEST(MAX(WRSI14.3, 2), MAX(WRSI14.6, 2)), WRSI14.5, IIF(WRSI14.6 > GREATEST(MAX(WRSI14.4, 2), MAX(WRSI14.7, 2)), WRSI14.6, IIF(WRSI14.7 > GREATEST(MAX(WRSI14.5, 2), MAX(WRSI14.8, 2)), WRSI14.7, IIF(WRSI14.8 > GREATEST(MAX(WRSI14.6, 2), MAX(WRSI14.9, 2)), WRSI14.8, IIF(WRSI14.9 > GREATEST(MAX(WRSI14.7, 2), MAX(WRSI14.10, 2)), WRSI14.9, IIF(WRSI14.10 > GREATEST(MAX(WRSI14.8, 2), MAX(WRSI14.11, 2)), WRSI14.10, IIF(WRSI14.11 > GREATEST(MAX(WRSI14.9, 2), MAX(WRSI14.12, 2)), WRSI14.11, IIF(WRSI14.12 > GREATEST(MAX(WRSI14.10, 2), MAX(WRSI14.13, 2)), WRSI14.12, IIF(WRSI14.13 > GREATEST(MAX(WRSI14.11, 2), MAX(WRSI14.14, 2)), WRSI14.13, IIF(WRSI14.14 > GREATEST(MAX(WRSI14.12, 2), MAX(WRSI14.15, 2)), WRSI14.14, IIF(WRSI14.15 > GREATEST(MAX(WRSI14.13, 2), MAX(WRSI14.16, 2)), WRSI14.15, IIF(WRSI14.16 > GREATEST(MAX(WRSI14.14, 2), MAX(WRSI14.17, 2)), WRSI14.16, IIF(WRSI14.17 > GREATEST(MAX(WRSI14.15, 2), MAX(WRSI14.18, 2)), WRSI14.17, IIF(WRSI14.18 > GREATEST(MAX(WRSI14.16, 2), MAX(WRSI14.19, 2)), WRSI14.18, IIF(WRSI14.19 > GREATEST(MAX(WRSI14.17, 2), MAX(WRSI14.20, 2)), WRSI14.19, IIF(WRSI14.20 > GREATEST(MAX(WRSI14.18, 2), MAX(WRSI14.21, 2)), WRSI14.20, IIF(WRSI14.21 > GREATEST(MAX(WRSI14.19, 2), MAX(WRSI14.22, 2)), WRSI14.21, IIF(WRSI14.22 > GREATEST(MAX(WRSI14.20, 2), MAX(WRSI14.23, 2)), WRSI14.22, IIF(WRSI14.23 > GREATEST(MAX(WRSI14.21, 2), MAX(WRSI14.24, 2)), WRSI14.23, IIF(WRSI14.24 > GREATEST(MAX(WRSI14.22, 2), MAX(WRSI14.25, 2)), WRSI14.24, IIF(WRSI14.25 > GREATEST(MAX(WRSI14.23, 2), MAX(WRSI14.26, 2)), WRSI14.25, IIF(WRSI14.26 > GREATEST(MAX(WRSI14.24, 2), MAX(WRSI14.27, 2)), WRSI14.26, IIF(WRSI14.27 > GREATEST(MAX(WRSI14.25, 2), MAX(WRSI14.28, 2)), WRSI14.27, IIF(WRSI14.28 > GREATEST(MAX(WRSI14.26, 2), MAX(WRSI14.29, 2)), WRSI14.28, IIF(WRSI14.29 > GREATEST(MAX(WRSI14.27, 2), MAX(WRSI14.30, 2)), WRSI14.29, IIF(WRSI14.30 > GREATEST(MAX(WRSI14.28, 2), MAX(WRSI14.31, 2)), WRSI14.30, IIF(WRSI14.31 > GREATEST(MAX(WRSI14.29, 2), MAX(WRSI14.32, 2)), WRSI14.31, IIF(WRSI14.32 > GREATEST(MAX(WRSI14.30, 2), MAX(WRSI14.33, 2)), WRSI14.32, IIF(WRSI14.33 > GREATEST(MAX(WRSI14.31, 2), MAX(WRSI14.34, 2)), WRSI14.33, IIF(WRSI14.34 > GREATEST(MAX(WRSI14.32, 2), MAX(WRSI14.35, 2)), WRSI14.34, IIF(WRSI14.35 > GREATEST(MAX(WRSI14.33, 2), MAX(WRSI14.36, 2)), WRSI14.35, IIF(WRSI14.36 > GREATEST(MAX(WRSI14.34, 2), MAX(WRSI14.37, 2)), WRSI14.36, IIF(WRSI14.37 > GREATEST(MAX(WRSI14.35, 2), MAX(WRSI14.38, 2)), WRSI14.37, IIF(WRSI14.38 > GREATEST(MAX(WRSI14.36, 2), MAX(WRSI14.39, 2)), WRSI14.38, IIF(WRSI14.39 > GREATEST(MAX(WRSI14.37, 2), MAX(WRSI14.40, 2)), WRSI14.39, IIF(WRSI14.40 > GREATEST(MAX(WRSI14.38, 2), MAX(WRSI14.41, 2)), WRSI14.40, IIF(WRSI14.41 > GREATEST(MAX(WRSI14.39, 2), MAX(WRSI14.42, 2)), WRSI14.41, IIF(WRSI14.42 > GREATEST(MAX(WRSI14.40, 2), MAX(WRSI14.43, 2)), WRSI14.42, IIF(WRSI14.43 > GREATEST(MAX(WRSI14.41, 2), MAX(WRSI14.44, 2)), WRSI14.43, IIF(WRSI14.44 > GREATEST(MAX(WRSI14.42, 2), MAX(WRSI14.45, 2)), WRSI14.44, IIF(WRSI14.45 > GREATEST(MAX(WRSI14.43, 2), MAX(WRSI14.46, 2)), WRSI14.45, IIF(WRSI14.46 > GREATEST(MAX(WRSI14.44, 2), MAX(WRSI14.47, 2)), WRSI14.46, IIF(WRSI14.47 > GREATEST(MAX(WRSI14.45, 2), MAX(WRSI14.48, 2)), WRSI14.47, IIF(WRSI14.48 > GREATEST(MAX(WRSI14.46, 2), MAX(WRSI14.49, 2)), WRSI14.48, IIF(WRSI14.49 > GREATEST(MAX(WRSI14.47, 2), MAX(WRSI14.50, 2)), WRSI14.49, IIF(WRSI14.50 > GREATEST(MAX(WRSI14.48, 2), MAX(WRSI14.51, 2)), WRSI14.50, IIF(WRSI14.51 > GREATEST(MAX(WRSI14.49, 2), MAX(WRSI14.52, 2)), WRSI14.51, IIF(WRSI14.52 > GREATEST(MAX(WRSI14.50, 2), MAX(WRSI14.53, 2)), WRSI14.52, IIF(WRSI14.53 > GREATEST(MAX(WRSI14.51, 2), MAX(WRSI14.54, 2)), WRSI14.53, IIF(WRSI14.54 > GREATEST(MAX(WRSI14.52, 2), MAX(WRSI14.55, 2)), WRSI14.54, IIF(WRSI14.55 > GREATEST(MAX(WRSI14.53, 2), MAX(WRSI14.56, 2)), WRSI14.55, IIF(WRSI14.56 > GREATEST(MAX(WRSI14.54, 2), MAX(WRSI14.57, 2)), WRSI14.56, IIF(WRSI14.57 > GREATEST(MAX(WRSI14.55, 2), MAX(WRSI14.58, 2)), WRSI14.57, IIF(WRSI14.58 > GREATEST(MAX(WRSI14.56, 2), MAX(WRSI14.59, 2)), WRSI14.58, IIF(WRSI14.59 > GREATEST(MAX(WRSI14.57, 2), MAX(WRSI14.60, 2)), WRSI14.59, IIF(WRSI14.60 > GREATEST(MAX(WRSI14.58, 2), MAX(WRSI14.61, 2)), WRSI14.60, IIF(WRSI14.61 > GREATEST(MAX(WRSI14.59, 2), MAX(WRSI14.62, 2)), WRSI14.61, IIF(WRSI14.62 > GREATEST(MAX(WRSI14.60, 2), MAX(WRSI14.63, 2)), WRSI14.62, IIF(WRSI14.63 > GREATEST(MAX(WRSI14.61, 2), MAX(WRSI14.64, 2)), WRSI14.63, IIF(WRSI14.64 > GREATEST(MAX(WRSI14.62, 2), MAX(WRSI14.65, 2)), WRSI14.64, IIF(WRSI14.65 > GREATEST(MAX(WRSI14.63, 2), MAX(WRSI14.66, 2)), WRSI14.65, IIF(WRSI14.66 > GREATEST(MAX(WRSI14.64, 2), MAX(WRSI14.67, 2)), WRSI14.66, IIF(WRSI14.67 > GREATEST(MAX(WRSI14.65, 2), MAX(WRSI14.68, 2)), WRSI14.67, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

And the following for crossing down the most recent low.

XDOWN(WRSI14, IIF(WRSI14.3 < LEAST(MIN(WRSI14.1, 2), MIN(WRSI14.4, 2)), WRSI14.3, IIF(WRSI14.4 < LEAST(MIN(WRSI14.2, 2), MIN(WRSI14.5, 2)), WRSI14.4, IIF(WRSI14.5 < LEAST(MIN(WRSI14.3, 2), MIN(WRSI14.6, 2)), WRSI14.5, IIF(WRSI14.6 < LEAST(MIN(WRSI14.4, 2), MIN(WRSI14.7, 2)), WRSI14.6, IIF(WRSI14.7 < LEAST(MIN(WRSI14.5, 2), MIN(WRSI14.8, 2)), WRSI14.7, IIF(WRSI14.8 < LEAST(MIN(WRSI14.6, 2), MIN(WRSI14.9, 2)), WRSI14.8, IIF(WRSI14.9 < LEAST(MIN(WRSI14.7, 2), MIN(WRSI14.10, 2)), WRSI14.9, IIF(WRSI14.10 < LEAST(MIN(WRSI14.8, 2), MIN(WRSI14.11, 2)), WRSI14.10, IIF(WRSI14.11 < LEAST(MIN(WRSI14.9, 2), MIN(WRSI14.12, 2)), WRSI14.11, IIF(WRSI14.12 < LEAST(MIN(WRSI14.10, 2), MIN(WRSI14.13, 2)), WRSI14.12, IIF(WRSI14.13 < LEAST(MIN(WRSI14.11, 2), MIN(WRSI14.14, 2)), WRSI14.13, IIF(WRSI14.14 < LEAST(MIN(WRSI14.12, 2), MIN(WRSI14.15, 2)), WRSI14.14, IIF(WRSI14.15 < LEAST(MIN(WRSI14.13, 2), MIN(WRSI14.16, 2)), WRSI14.15, IIF(WRSI14.16 < LEAST(MIN(WRSI14.14, 2), MIN(WRSI14.17, 2)), WRSI14.16, IIF(WRSI14.17 < LEAST(MIN(WRSI14.15, 2), MIN(WRSI14.18, 2)), WRSI14.17, IIF(WRSI14.18 < LEAST(MIN(WRSI14.16, 2), MIN(WRSI14.19, 2)), WRSI14.18, IIF(WRSI14.19 < LEAST(MIN(WRSI14.17, 2), MIN(WRSI14.20, 2)), WRSI14.19, IIF(WRSI14.20 < LEAST(MIN(WRSI14.18, 2), MIN(WRSI14.21, 2)), WRSI14.20, IIF(WRSI14.21 < LEAST(MIN(WRSI14.19, 2), MIN(WRSI14.22, 2)), WRSI14.21, IIF(WRSI14.22 < LEAST(MIN(WRSI14.20, 2), MIN(WRSI14.23, 2)), WRSI14.22, IIF(WRSI14.23 < LEAST(MIN(WRSI14.21, 2), MIN(WRSI14.24, 2)), WRSI14.23, IIF(WRSI14.24 < LEAST(MIN(WRSI14.22, 2), MIN(WRSI14.25, 2)), WRSI14.24, IIF(WRSI14.25 < LEAST(MIN(WRSI14.23, 2), MIN(WRSI14.26, 2)), WRSI14.25, IIF(WRSI14.26 < LEAST(MIN(WRSI14.24, 2), MIN(WRSI14.27, 2)), WRSI14.26, IIF(WRSI14.27 < LEAST(MIN(WRSI14.25, 2), MIN(WRSI14.28, 2)), WRSI14.27, IIF(WRSI14.28 < LEAST(MIN(WRSI14.26, 2), MIN(WRSI14.29, 2)), WRSI14.28, IIF(WRSI14.29 < LEAST(MIN(WRSI14.27, 2), MIN(WRSI14.30, 2)), WRSI14.29, IIF(WRSI14.30 < LEAST(MIN(WRSI14.28, 2), MIN(WRSI14.31, 2)), WRSI14.30, IIF(WRSI14.31 < LEAST(MIN(WRSI14.29, 2), MIN(WRSI14.32, 2)), WRSI14.31, IIF(WRSI14.32 < LEAST(MIN(WRSI14.30, 2), MIN(WRSI14.33, 2)), WRSI14.32, IIF(WRSI14.33 < LEAST(MIN(WRSI14.31, 2), MIN(WRSI14.34, 2)), WRSI14.33, IIF(WRSI14.34 < LEAST(MIN(WRSI14.32, 2), MIN(WRSI14.35, 2)), WRSI14.34, IIF(WRSI14.35 < LEAST(MIN(WRSI14.33, 2), MIN(WRSI14.36, 2)), WRSI14.35, IIF(WRSI14.36 < LEAST(MIN(WRSI14.34, 2), MIN(WRSI14.37, 2)), WRSI14.36, IIF(WRSI14.37 < LEAST(MIN(WRSI14.35, 2), MIN(WRSI14.38, 2)), WRSI14.37, IIF(WRSI14.38 < LEAST(MIN(WRSI14.36, 2), MIN(WRSI14.39, 2)), WRSI14.38, IIF(WRSI14.39 < LEAST(MIN(WRSI14.37, 2), MIN(WRSI14.40, 2)), WRSI14.39, IIF(WRSI14.40 < LEAST(MIN(WRSI14.38, 2), MIN(WRSI14.41, 2)), WRSI14.40, IIF(WRSI14.41 < LEAST(MIN(WRSI14.39, 2), MIN(WRSI14.42, 2)), WRSI14.41, IIF(WRSI14.42 < LEAST(MIN(WRSI14.40, 2), MIN(WRSI14.43, 2)), WRSI14.42, IIF(WRSI14.43 < LEAST(MIN(WRSI14.41, 2), MIN(WRSI14.44, 2)), WRSI14.43, IIF(WRSI14.44 < LEAST(MIN(WRSI14.42, 2), MIN(WRSI14.45, 2)), WRSI14.44, IIF(WRSI14.45 < LEAST(MIN(WRSI14.43, 2), MIN(WRSI14.46, 2)), WRSI14.45, IIF(WRSI14.46 < LEAST(MIN(WRSI14.44, 2), MIN(WRSI14.47, 2)), WRSI14.46, IIF(WRSI14.47 < LEAST(MIN(WRSI14.45, 2), MIN(WRSI14.48, 2)), WRSI14.47, IIF(WRSI14.48 < LEAST(MIN(WRSI14.46, 2), MIN(WRSI14.49, 2)), WRSI14.48, IIF(WRSI14.49 < LEAST(MIN(WRSI14.47, 2), MIN(WRSI14.50, 2)), WRSI14.49, IIF(WRSI14.50 < LEAST(MIN(WRSI14.48, 2), MIN(WRSI14.51, 2)), WRSI14.50, IIF(WRSI14.51 < LEAST(MIN(WRSI14.49, 2), MIN(WRSI14.52, 2)), WRSI14.51, IIF(WRSI14.52 < LEAST(MIN(WRSI14.50, 2), MIN(WRSI14.53, 2)), WRSI14.52, IIF(WRSI14.53 < LEAST(MIN(WRSI14.51, 2), MIN(WRSI14.54, 2)), WRSI14.53, IIF(WRSI14.54 < LEAST(MIN(WRSI14.52, 2), MIN(WRSI14.55, 2)), WRSI14.54, IIF(WRSI14.55 < LEAST(MIN(WRSI14.53, 2), MIN(WRSI14.56, 2)), WRSI14.55, IIF(WRSI14.56 < LEAST(MIN(WRSI14.54, 2), MIN(WRSI14.57, 2)), WRSI14.56, IIF(WRSI14.57 < LEAST(MIN(WRSI14.55, 2), MIN(WRSI14.58, 2)), WRSI14.57, IIF(WRSI14.58 < LEAST(MIN(WRSI14.56, 2), MIN(WRSI14.59, 2)), WRSI14.58, IIF(WRSI14.59 < LEAST(MIN(WRSI14.57, 2), MIN(WRSI14.60, 2)), WRSI14.59, IIF(WRSI14.60 < LEAST(MIN(WRSI14.58, 2), MIN(WRSI14.61, 2)), WRSI14.60, IIF(WRSI14.61 < LEAST(MIN(WRSI14.59, 2), MIN(WRSI14.62, 2)), WRSI14.61, IIF(WRSI14.62 < LEAST(MIN(WRSI14.60, 2), MIN(WRSI14.63, 2)), WRSI14.62, IIF(WRSI14.63 < LEAST(MIN(WRSI14.61, 2), MIN(WRSI14.64, 2)), WRSI14.63, IIF(WRSI14.64 < LEAST(MIN(WRSI14.62, 2), MIN(WRSI14.65, 2)), WRSI14.64, IIF(WRSI14.65 < LEAST(MIN(WRSI14.63, 2), MIN(WRSI14.66, 2)), WRSI14.65, IIF(WRSI14.66 < LEAST(MIN(WRSI14.64, 2), MIN(WRSI14.67, 2)), WRSI14.66, IIF(WRSI14.67 < LEAST(MIN(WRSI14.65, 2), MIN(WRSI14.68, 2)), WRSI14.67, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Request6: 

1) If current WRSI14 is crossing UP HL or LL from past then show me spike one colour

2) If current WRSI14 is crossing DOWN HH or LH from past then show me spike as second colour

 

I'm not in a rush and I will let you do whenever your time permits.

 

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.

Bruce_L
Posted : Monday, March 25, 2019 1:27:52 PM


Worden Trainer

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

I have sent you a my imipletation of your requets via TCMail.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Priyaa
Posted : Tuesday, March 26, 2019 1:38:50 AM
Registered User
Joined: 1/11/2019
Posts: 28

Thank you so much Bruce. I will try to understand it and get back to you with any questions I have.

Regards,

Priya

Bruce_L
Posted : Tuesday, March 26, 2019 9:07:21 AM


Worden Trainer

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

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.