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

Profile: Priyaa
About
User Name: Priyaa
Groups: Member
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Unsure
Statistics
Joined: Friday, January 11, 2019
Last Visit: Tuesday, February 4, 2020 6:29:04 PM
Number of Posts: 28
[0.01% of all post / 0.01 posts per day]
Avatar
Last 10 Posts
Topic: pcf decimal error
Posted: Wednesday, April 3, 2019 11:33:09 PM

Bruce,

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

Topic: I say to-may-to", you say "to-mah-to"
Posted: Wednesday, April 3, 2019 11:43:24 AM

Thank you Bruce.

Topic: pcf decimal error
Posted: Wednesday, April 3, 2019 11:36:49 AM

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

 

Regards,

Priya

Topic: pcf decimal error
Posted: Thursday, March 28, 2019 10:12:08 AM

Good Morning Bruce,

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

 

Regards,

Priya

Topic: APT Indicator Working Flawlessly for 3 Years Now
Posted: Tuesday, March 26, 2019 2:50:31 AM

Hi Bruce and Algorithm,

All that you've mentioned is beyond my understanding. 

If Algorithm cannot come up with those requirements around other indicators and cannot think of a case that is helpful, then I would just try learning from the posts I'm seeing.

Thank you both.

Regards,

Priya

Topic: RSI SIGNAL SPIKE
Posted: Tuesday, March 26, 2019 1:38:50 AM

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

Regards,

Priya

Topic: RSI SIGNAL SPIKE
Posted: Monday, March 25, 2019 9:57:45 AM

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&#39;m not in a rush and I will let you do whenever your time permits.

 

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

Topic: pcf decimal error
Posted: Monday, March 25, 2019 9:44:25 AM

Hi Bruce,

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

Request1:

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

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

1) Bullish Reversal

2) Bullish Continuation Divergence

3) Bearish Continuation 

4) Bearish Reversal Divergence

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

 

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

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

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

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

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

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

Please let me know if it is possible.

 

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

Topic: pcf decimal error
Posted: Sunday, March 24, 2019 11:32:36 AM

Hi Dhiren,

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

 

Thanks,

Priya

Topic: APT Indicator Working Flawlessly for 3 Years Now
Posted: Sunday, March 24, 2019 3:10:51 AM

I know...true!!!

Al, I have been reading all the forum posts a lot and trying to understand as much as I can. All your research posts and requests are very educating and Im glad your on the forum.