Registered User
Joined: 9/30/2011
Posts: 788
|
The following formula generates the signal on the symbols above the zero line, I would like the change to have the signal on the symbols below the zero line.
IIF (C <O, IIF (C1 <O, GREATEST (H - C1, C - L), GREATEST (H - O, C - L)), IIF (C> O, IIF (C1> O, H - L , GREATEST (O - C1, H - L)), IIF (H - C> C - L, IIF (C1 <O, GREATEST (H - C1, C - L), H - O), IIF (H - C <C - L, IIF (C1> O, H - L, GREATEST (O - C1, H - L)), IIF (C1> O, GREATEST (H - O, C - L), IIF (C1 <O, GREATEST (O - C1, H - L), H - L)))))> IIF (C <O, IIF (C1> O, GREATEST (C1 - O, H - L), HL), IIF (C > O, IIF (C1> O, GREATEST (C1 - L, H - C), GREATEST (O - L, H - C)), IIF (H - C> C - L, IIF (C1> O, GREATEST ( C1 - O, H - L), H - L), IIF (H - C <C - L, IIF (C1> O, GREATEST (C1 - L, H - C), O - L), IIF (C1> O, GREATEST (C1 - O, H - L), IIF (C1 <O, GREATEST (O - L, H - C), H - L))))))
Thank you and goodbye.
Raider45
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The following?
IIF(C < O, IIF(C1 < O, GREATEST(H - C1, C - L), GREATEST(H - O, C - L)), IIF(C > O, IIF(C1 > O, H - L, GREATEST(O - C1, H - L)), IIF(H - C > C - L, IIF(C1 < O, GREATEST(H - C1, C - L), H - O), IIF(H - C < C - L, IIF(C1 > O, H - L, GREATEST(O - C1, H - L)), IIF(C1 > O, GREATEST(H - O, C - L), IIF(C1 < O, GREATEST(O - C1, H - L), H - L)))))) < IIF(C < O, IIF(C1 > O, GREATEST(C1 - O, H - L), H-L), IIF(C > O, IIF(C1 > O, GREATEST(C1 - L, H - C), GREATEST(O - L, H - C)), IIF(H - C > C - L, IIF(C1 > O, GREATEST(C1 - O, H - L), H - L), IIF(H - C < C - L, IIF(C1 > O, GREATEST(C1 - L, H - C), O - L), IIF(C1 > O, GREATEST(C1 - O, H - L), IIF(C1 < O, GREATEST(O - L, H - C), H - L))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 9/30/2011
Posts: 788
|
Congratulations, thank you !
Best regards !
|