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

Profile: dhirenshah
About
User Name: dhirenshah
Groups: Gold User, Member, Platinum User, TeleChart
Rank: Registered User
Real Name:
Location
Occupation:
Interests:
Gender: Gender:
Statistics
Joined: Saturday, March 10, 2012
Last Visit: Tuesday, April 24, 2018 5:56:03 PM
Number of Posts: 314
[0.11% of all post / 0.14 posts per day]
Avatar
Last 10 Posts
Topic: PCF question
Posted: Friday, April 13, 2018 2:09:47 PM

Ok that works Bruce .. so just for my understanding why in the earlier pcf we used SGN " function 

Topic: PCF question
Posted: Friday, April 13, 2018 1:54:19 PM

Bruce this formula below gives me 2 consecutive close above 8EMA 

SGN(C - XAVG(H + L + C, 8) / 3) = SGN(C1 - XAVG(H + L + C, 8.1) / 3) AND SGN(C1 - XAVG(H + L + C, 8.1) / 3) > SGN(C2 - XAVG(H + L + C, 8.2) / 3)

So my question is how do i write the same above formula where it close above 8ema(hlc) today , and close below 8ema(hlc) yesterday and Close above 8ema(hlc) day before yesterday  and all happening Consecutively in 3 bars

thanks 

Dhiren

Topic: Volume question
Posted: Thursday, March 29, 2018 3:55:37 PM

Okay Bruce i got my answer from your above formula thanks 

have great weekend,,, 

Cheers

Topic: Volume question
Posted: Thursday, March 29, 2018 12:57:46 PM

Bruce 2 quick questions please

1) Need 2 standard deviation of 20 bar average volume in boolean formula so how to write that ?

 

2) this below pcf u did for somebody in forum and wanted to ask you what exactly the output of Value 63 being the highest and 8  ,10,31 etc signify for interpretation ??

IIF(XUP(IIF(V > 1.5 * AVGV30, IIF(C > C1 AND V > 1.5 * AVGV30, IIF(C1 < C2 AND V <= V1, 0, IIF(C2 < C3 AND V <= V2, 1, IIF(C3 < C4 AND V <= V3, 2, IIF(C4 < C5 AND V <= V4, 3, IIF(C5 < C6 AND V <= V5, 4, IIF(C6 < C7 AND V <= V6, 5, IIF(C7 < C8 AND V <= V7, 6, IIF(C8 < C9 AND V <= V8, 7, IIF(C9 < C10 AND V <= V9, 8, IIF(C10 < C11 AND V <= V10, 9, IIF(C11 < C12 AND V <= V11, 10, IIF(C12 < C13 AND V <= V12, 11, IIF(C13 < C14 AND V <= V13, 12, IIF(C14 < C15 AND V <= V14, 13, IIF(C15 < C16 AND V <= V15, 14, IIF(C16 < C17 AND V <= V16, 15, IIF(C17 < C18 AND V <= V17, 16, IIF(C18 < C19 AND V <= V18, 17, IIF(C19 < C20 AND V <= V19, 18, IIF(C20 < C21 AND V <= V20, 19, IIF(C21 < C22 AND V <= V21, 20, IIF(C22 < C23 AND V <= V22, 21, IIF(C23 < C24 AND V <= V23, 22, IIF(C24 < C25 AND V <= V24, 23, IIF(C25 < C26 AND V <= V25, 24, IIF(C26 < C27 AND V <= V26, 25, IIF(C27 < C28 AND V <= V27, 26, IIF(C28 < C29 AND V <= V28, 27, IIF(C29 < C30 AND V <= V29, 28, IIF(C30 < C31 AND V <= V30, 29, IIF(C31 < C32 AND V <= V31, 30, IIF(C32 < C33 AND V <= V32, 31, IIF(C33 < C34 AND V <= V33, 32, IIF(C34 < C35 AND V <= V34, 33, IIF(C35 < C36 AND V <= V35, 34, IIF(C36 < C37 AND V <= V36, 35, IIF(C37 < C38 AND V <= V37, 36, IIF(C38 < C39 AND V <= V38, 37, IIF(C39 < C40 AND V <= V39, 38, IIF(C40 < C41 AND V <= V40, 39, IIF(C41 < C42 AND V <= V41, 40, IIF(C42 < C43 AND V <= V42, 41, IIF(C43 < C44 AND V <= V43, 42, IIF(C44 < C45 AND V <= V44, 43, IIF(C45 < C46 AND V <= V45, 44, IIF(C46 < C47 AND V <= V46, 45, IIF(C47 < C48 AND V <= V47, 46, IIF(C48 < C49 AND V <= V48, 47, IIF(C49 < C50 AND V <= V49, 48, IIF(C50 < C51 AND V <= V50, 49, IIF(C51 < C52 AND V <= V51, 50, IIF(C52 < C53 AND V <= V52, 51, IIF(C53 < C54 AND V <= V53, 52, IIF(C54 < C55 AND V <= V54, 53, IIF(C55 < C56 AND V <= V55, 54, IIF(C56 < C57 AND V <= V56, 55, IIF(C57 < C58 AND V <= V57, 56, IIF(C58 < C59 AND V <= V58, 57, IIF(C59 < C60 AND V <= V59, 58, IIF(C60 < C61 AND V <= V60, 59, IIF(C61 < C62 AND V <= V61, 60, IIF(C62 < C63 AND V <= V62, 61, IIF(C63 < C64 AND V <= V63, 62, 63))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 0), 0), 1), IIF(V > 1.5 * AVGV30, IIF(C > C1 AND V > 1.5 * AVGV30, IIF(C1 < C2 AND V <= V1, 0, IIF(C2 < C3 AND V <= V2, 1, IIF(C3 < C4 AND V <= V3, 2, IIF(C4 < C5 AND V <= V4, 3, IIF(C5 < C6 AND V <= V5, 4, IIF(C6 < C7 AND V <= V6, 5, IIF(C7 < C8 AND V <= V7, 6, IIF(C8 < C9 AND V <= V8, 7, IIF(C9 < C10 AND V <= V9, 8, IIF(C10 < C11 AND V <= V10, 9, IIF(C11 < C12 AND V <= V11, 10, IIF(C12 < C13 AND V <= V12, 11, IIF(C13 < C14 AND V <= V13, 12, IIF(C14 < C15 AND V <= V14, 13, IIF(C15 < C16 AND V <= V15, 14, IIF(C16 < C17 AND V <= V16, 15, IIF(C17 < C18 AND V <= V17, 16, IIF(C18 < C19 AND V <= V18, 17, IIF(C19 < C20 AND V <= V19, 18, IIF(C20 < C21 AND V <= V20, 19, IIF(C21 < C22 AND V <= V21, 20, IIF(C22 < C23 AND V <= V22, 21, IIF(C23 < C24 AND V <= V23, 22, IIF(C24 < C25 AND V <= V24, 23, IIF(C25 < C26 AND V <= V25, 24, IIF(C26 < C27 AND V <= V26, 25, IIF(C27 < C28 AND V <= V27, 26, IIF(C28 < C29 AND V <= V28, 27, IIF(C29 < C30 AND V <= V29, 28, IIF(C30 < C31 AND V <= V30, 29, IIF(C31 < C32 AND V <= V31, 30, IIF(C32 < C33 AND V <= V32, 31, IIF(C33 < C34 AND V <= V33, 32, IIF(C34 < C35 AND V <= V34, 33, IIF(C35 < C36 AND V <= V35, 34, IIF(C36 < C37 AND V <= V36, 35, IIF(C37 < C38 AND V <= V37, 36, IIF(C38 < C39 AND V <= V38, 37, IIF(C39 < C40 AND V <= V39, 38, IIF(C40 < C41 AND V <= V40, 39, IIF(C41 < C42 AND V <= V41, 40, IIF(C42 < C43 AND V <= V42, 41, IIF(C43 < C44 AND V <= V43, 42, IIF(C44 < C45 AND V <= V44, 43, IIF(C45 < C46 AND V <= V45, 44, IIF(C46 < C47 AND V <= V46, 45, IIF(C47 < C48 AND V <= V47, 46, IIF(C48 < C49 AND V <= V48, 47, IIF(C49 < C50 AND V <= V49, 48, IIF(C50 < C51 AND V <= V50, 49, IIF(C51 < C52 AND V <= V51, 50, IIF(C52 < C53 AND V <= V52, 51, IIF(C53 < C54 AND V <= V53, 52, IIF(C54 < C55 AND V <= V54, 53, IIF(C55 < C56 AND V <= V55, 54, IIF(C56 < C57 AND V <= V56, 55, IIF(C57 < C58 AND V <= V57, 56, IIF(C58 < C59 AND V <= V58, 57, IIF(C59 < C60 AND V <= V59, 58, IIF(C60 < C61 AND V <= V60, 59, IIF(C61 < C62 AND V <= V61, 60, IIF(C62 < C63 AND V <= V62, 61, IIF(C63 < C64 AND V <= V63, 62, 63))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 0), 0), 0)
 
thanks 

Dhiren
 
Topic: WRSI fibs
Posted: Tuesday, March 20, 2018 9:55:23 AM

No problem Bruce , thanks for Trying .. 

Cheers

Topic: WRSI fibs
Posted: Monday, March 19, 2018 12:23:25 PM

Ok Bruce thanks for above formula

Now we only need to identify the swing low 13 and we don&#39;t have to try and identify the swing high at all. All we do is use the highest high since the swing low (excluding the bar of the swing low) 

So when i draw fib retracement on WRSI 13 bar swing LOW i want to identify where is current WRSI in terms of fib ratio... you did this on price for me .. as below formula 

100 * (IIF(MINL13 > L13 AND L13 < MINL13.14, MAXH13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, MAXH14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, MAXH15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, MAXH16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, MAXH17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, MAXH18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, MAXH19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, MAXH20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, MAXH21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, MAXH22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, MAXH23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, MAXH24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, MAXH25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, MAXH26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, MAXH27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, MAXH28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, MAXH29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, MAXH30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, MAXH31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, MAXH32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, MAXH33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, MAXH34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, MAXH35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, MAXH36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, MAXH37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, MAXH38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, MAXH39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, MAXH40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, MAXH41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, MAXH42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, MAXH43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, MAXH44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, MAXH45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, MAXH46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, MAXH47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, MAXH48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, MAXH49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, MAXH50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, MAXH51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, MAXH52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, MAXH53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, MAXH54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, MAXH55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, MAXH56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, MAXH57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, MAXH58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, MAXH59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, MAXH60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, MAXH61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, MAXH62, 1/0)))))))))))))))))))))))))))))))))))))))))))))))))) - L) / IIF(MINL13 > L13 AND L13 < MINL13.14, MAXH13 - L13, IIF(MINL13.1 > L14 AND L14 < MINL13.15, MAXH14 - L14, IIF(MINL13.2 > L15 AND L15 < MINL13.16, MAXH15 - L15, IIF(MINL13.3 > L16 AND L16 < MINL13.17, MAXH16 - L16, IIF(MINL13.4 > L17 AND L17 < MINL13.18, MAXH17 - L17, IIF(MINL13.5 > L18 AND L18 < MINL13.19, MAXH18 - L18, IIF(MINL13.6 > L19 AND L19 < MINL13.20, MAXH19 - L19, IIF(MINL13.7 > L20 AND L20 < MINL13.21, MAXH20 - L20, IIF(MINL13.8 > L21 AND L21 < MINL13.22, MAXH21 - L21, IIF(MINL13.9 > L22 AND L22 < MINL13.23, MAXH22 - L22, IIF(MINL13.10 > L23 AND L23 < MINL13.24, MAXH23 - L23, IIF(MINL13.11 > L24 AND L24 < MINL13.25, MAXH24 - L24, IIF(MINL13.12 > L25 AND L25 < MINL13.26, MAXH25 - L25, IIF(MINL13.13 > L26 AND L26 < MINL13.27, MAXH26 - L26, IIF(MINL13.14 > L27 AND L27 < MINL13.28, MAXH27 - L27, IIF(MINL13.15 > L28 AND L28 < MINL13.29, MAXH28 - L28, IIF(MINL13.16 > L29 AND L29 < MINL13.30, MAXH29 - L29, IIF(MINL13.17 > L30 AND L30 < MINL13.31, MAXH30 - L30, IIF(MINL13.18 > L31 AND L31 < MINL13.32, MAXH31 - L31, IIF(MINL13.19 > L32 AND L32 < MINL13.33, MAXH32 - L32, IIF(MINL13.20 > L33 AND L33 < MINL13.34, MAXH33 - L33, IIF(MINL13.21 > L34 AND L34 < MINL13.35, MAXH34 - L34, IIF(MINL13.22 > L35 AND L35 < MINL13.36, MAXH35 - L35, IIF(MINL13.23 > L36 AND L36 < MINL13.37, MAXH36 - L36, IIF(MINL13.24 > L37 AND L37 < MINL13.38, MAXH37 - L37, IIF(MINL13.25 > L38 AND L38 < MINL13.39, MAXH38 - L38, IIF(MINL13.26 > L39 AND L39 < MINL13.40, MAXH39 - L39, IIF(MINL13.27 > L40 AND L40 < MINL13.41, MAXH40 - L40, IIF(MINL13.28 > L41 AND L41 < MINL13.42, MAXH41 - L41, IIF(MINL13.29 > L42 AND L42 < MINL13.43, MAXH42 - L42, IIF(MINL13.30 > L43 AND L43 < MINL13.44, MAXH43 - L43, IIF(MINL13.31 > L44 AND L44 < MINL13.45, MAXH44 - L44, IIF(MINL13.32 > L45 AND L45 < MINL13.46, MAXH45 - L45, IIF(MINL13.33 > L46 AND L46 < MINL13.47, MAXH46 - L46, IIF(MINL13.34 > L47 AND L47 < MINL13.48, MAXH47 - L47, IIF(MINL13.35 > L48 AND L48 < MINL13.49, MAXH48 - L48, IIF(MINL13.36 > L49 AND L49 < MINL13.50, MAXH49 - L49, IIF(MINL13.37 > L50 AND L50 < MINL13.51, MAXH50 - L50, IIF(MINL13.38 > L51 AND L51 < MINL13.52, MAXH51 - L51, IIF(MINL13.39 > L52 AND L52 < MINL13.53, MAXH52 - L52, IIF(MINL13.40 > L53 AND L53 < MINL13.54, MAXH53 - L53, IIF(MINL13.41 > L54 AND L54 < MINL13.55, MAXH54 - L54, IIF(MINL13.42 > L55 AND L55 < MINL13.56, MAXH55 - L55, IIF(MINL13.43 > L56 AND L56 < MINL13.57, MAXH56 - L56, IIF(MINL13.44 > L57 AND L57 < MINL13.58, MAXH57 - L57, IIF(MINL13.45 > L58 AND L58 < MINL13.59, MAXH58 - L58, IIF(MINL13.46 > L59 AND L59 < MINL13.60, MAXH59 - L59, IIF(MINL13.47 > L60 AND L60 < MINL13.61, MAXH60 - L60, IIF(MINL13.48 > L61 AND L61 < MINL13.62, MAXH61 - L61, IIF(MINL13.49 > L62 AND L62 < MINL13.63, MAXH62 - L62, 1/0))))))))))))))))))))))))))))))))))))))))))))))))))

 
 
Topic: WRSI fibs
Posted: Sunday, March 18, 2018 10:57:26 PM

Bruce hope u had good weekend ... 

1) have two part question as below 

a) I want to convert the below formula to overlay on WRSI14 low so what will be the new formula

L13 * ABS(MINL13 > L13 AND L13 < MINL13.14) 

b) I want to convert the below formula to overlay on WRSI14 high so what will be new formula

H13 * ABS(MAXH13 < H13 AND H13 > MAXH13.14) 

 

Second question i will ask after your response to the first one as i will be asking after a little back testing from your response

thanks 

Topic: Stochastic Momentum Index - SMI
Posted: Friday, March 09, 2018 3:49:45 PM

Okay bruce lets live it for now... we both need weekend break 

have great weekend brother 

Cheers

Dhiren

Topic: Stochastic Momentum Index - SMI
Posted: Friday, March 09, 2018 3:24:33 PM

Bruce I had asked stochastic in past and u did this for me at the time as below and it works as charm so just to save you time , 

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)
 
 
And i use them everyday  .... but I tried plotting them on SMI  main line but the dots are not plotting correctly so if u can just modify in the HH, HL, LH, LL formulas  to fit on SMI ..please that would be a great visual secondary confirmation as some signals are caught visually better when looking SMI 
 
thanks 
 
 
 
 
Topic: Stochastic Momentum Index - SMI
Posted: Friday, March 09, 2018 2:48:44 PM

Yes they do but when I plot 1 period simple moving avg on SMI and offset -2 and change to dots then its not plotting on the curve of smi ... as for other formulas u have written ...