Registered User
Joined: 12/3/2004
Posts: 7
Location: New York City
|
I've created a couple of PCF's for ADX's +DI and -DI but the values I get differ from the lines plotted in your ADX. Could you please provide the formulas used by your vendor? Thank you.
Sincerely yours,
Cy Brown
P.S. The +DI PCF I created is shown below:
(100*ABS((((H-H1)>(L1-L)AND(H-H1))+((H1-H2)>(L2-L1)AND(H1-H2))+((H2-H3)>(L3-L2)AND (H2-H3))+
((H3-H4)>(L4-L3)AND(H3-H4))+((H4-H5)>(L5-L4)AND(H4-H5))+((H5-H6)>(L6-L5)AND(H5-H6))+
((H6-H7)>(L7-L6)AND(H6-H7))+((H7-H8)>(L8-L7)AND(H7-H8))+((H8-H9)>(L9-L8)AND (H8-H9))+
((H9-H10)>(L10-L9)AND(H9-H10))+((H10-H11)>(L11-L10)AND(H10-H11))+((H11-H12)> (L12-L11)AND(H11-H12))+
((H12-H13)>(L13-L12)AND(H12-H13))+((H13-H14)>(L14-L13)AND(H13-H14)))/14)/ (((L>=C1)*C1+(L<C1)*L-(H<C1)*C1-(H>=C1)*H+(L1>=C2)*C2+(L1<C2)*L1-(H1<C2)*C2-(H1>=C2)*H1+
(L2>=C3)*C3+(L2<C3)*L2-(H2<C3)*C3-(H2>=C3)*H2+(L3>=C4)*C4+(L3<C4)*L3-(H3<C4)*C4-(H3>=C4)*H3+
(L4>=C5)*C5+(L4<C5)*L4-(H4<C5)*C5-(H4>=C5)*H4+(L5>=C6)*C6+(L5<C6)*L5-(H5<C6)*C6-(H5>=C6)*H5+
(L6>=C7)*C7+(L6<C7)*L6-(H6<C7)*C7-(H6>=C7)*H6+(L7>=C8)*C8+(L7<C8)*L7-(H7<C8)*C8-(H7>=C8)*H7+
(L8>=C9)*C9+(L8<C9)*L8-(H8<C9)*C9-(H8>=C9)*H8+(L9>=C10)*C10+(L9<C10)*L9-(H9<C10)*C10-(H9>=C10)*H9+
(L10>=C11)*C11+(L10<C11)*L10-(H10<C11)*C11-(H10>=C11)*H10+(L11>=C12)*C12+ (L11<C12)*L11-(H11<C12)*C12-(H11>=C12)*H11+(L12>=C13)*C13+(L12<C13)*L12- (H12<C13)*C13-(H12>=C13)*H12+
(L13>=C14)*C14+(L13<C14)*L13-(H13<C14)*C14-(H13>=C14)*H13)/14)
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Bruce, Doug and I are working on a formula for you that should work better. As a side note, all of our development and programming is done in-house. The ADX is calculated by the program, not downloaded from an outside source. Stay tuned for our solution.
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
cwbwin,
I've officially dubbed Trainer Bruce "PCF KING"! Below is a formula he came up with. It assumes you are using a period of 14 with an average of 1. I would love to see the ability to visually sort by the +/- DI in the future.
Be warned, this PCF will send you computer to a CRAWL in calculating your PCFs. I would not use the formula for a custom indicator (why would you when ADX is already in the program).
Try it out and let us know if it worked!
+DI14:
200*(138541*(H-H1)*(H>H1)*((H-H1)>(L1-L)) +128645*(H1-H2)*(H1>H2)*((H1-H2)>(L2-L1)) +119456*(H2-H3)*(H2>H3)*((H2-H3)>(L3-L2)) +110924*(H3-H4)*(H3>H4)*((H3-H4)>(L4-L3)) +103001*(H4-H5)*(H4>H5)*((H4-H5)>(L5-L4)) +95643*(H5-H6)*(H5>H6)*((H5-H6)>(L6-L5)) +88812*(H6-H7)*(H6>H7)*((H6-H7)>(L7-L6)) +82468*(H7-H8)*(H7>H8)*((H7-H8)>(L8-L7)) +76577*(H8-H9)*(H8>H9)*((H8-H9)>(L9-L8)) +71108*(H9-H10)*(H9>H10)*((H9-H10)>(L10-L9)) +66029*(H10-H11)*(H10>H11)*((H10-H11)>(L11-L10)) +61312*(H11-H12)*(H11>H12)*((H11-H12)>(L12-L11)) +56933*(H12-H13)*(H12>H13)*((H12-H13)>(L13-L12)) +52866*(H13-H14)*(H13>H14)*((H13-H14)>(L14-L13)) +49090*(H14-H15)*(H14>H15)*((H14-H15)>(L15-L14)) +45584*(H15-H16)*(H15>H16)*((H15-H16)>(L16-L15)) +42328*(H16-H17)*(H16>H17)*((H16-H17)>(L17-L16)) +39304*(H17-H18)*(H17>H18)*((H17-H18)>(L18-L17)) +36497*(H18-H19)*(H18>H19)*((H18-H19)>(L19-L18)) +33890*(H19-H20)*(H19>H20)*((H19-H20)>(L20-L19)) +31469*(H20-H21)*(H20>H21)*((H20-H21)>(L21-L20)) +29221*(H21-H22)*(H21>H22)*((H21-H22)>(L22-L21)) +27134*(H22-H23)*(H22>H23)*((H22-H23)>(L23-L22)) +25196*(H23-H24)*(H23>H24)*((H23-H24)>(L24-L23)) +23396*(H24-H25)*(H24>H25)*((H24-H25)>(L25-L24)) +21725*(H25-H26)*(H25>H26)*((H25-H26)>(L26-L25)) +20173*(H26-H27)*(H26>H27)*((H26-H27)>(L27-L26)) +18732*(H27-H28)*(H27>H28)*((H27-H28)>(L28-L27)) +17394*(H28-H29)*(H28>H29)*((H28-H29)>(L29-L28)) +16152*(H29-H30)*(H29>H30)*((H29-H30)>(L30-L29)) +14998*(H30-H31)*(H30>H31)*((H30-H31)>(L31-L30)) +13927*(H31-H32)*(H31>H32)*((H31-H32)>(L32-L31)) +12932*(H32-H33)*(H32>H33)*((H32-H33)>(L33-L32)) +12008*(H33-H34)*(H33>H34)*((H33-H34)>(L34-L33)) +11151*(H34-H35)*(H34>H35)*((H34-H35)>(L35-L34)) +10354*(H35-H36)*(H35>H36)*((H35-H36)>(L36-L35)) +9615*(H36-H37)*(H36>H37)*((H36-H37)>(L37-L36)) +8928*(H37-H38)*(H37>H38)*((H37-H38)>(L38-L37)) +8290*(H38-H39)*(H38>H39)*((H38-H39)>(L39-L38)) +7698*(H39-H40)*(H39>H40)*((H39-H40)>(L40-L39)) +7148*(H40-H41)*(H40>H41)*((H40-H41)>(L41-L40)) +6638*(H41-H42)*(H41>H42)*((H41-H42)>(L42-L41)) +6163*(H42-H43)*(H42>H43)*((H42-H43)>(L43-L42)) +5723*(H43-H44)*(H43>H44)*((H43-H44)>(L44-L43)) +5314*(H44-H45)*(H44>H45)*((H44-H45)>(L45-L44)) +4935*(H45-H46)*(H45>H46)*((H45-H46)>(L46-L45)) +4582*(H46-H47)*(H46>H47)*((H46-H47)>(L47-L46)) +4255*(H47-H48)*(H47>H48)*((H47-H48)>(L48-L47)) +3951*(H48-H49)*(H48>H49)*((H48-H49)>(L49-L48)) +3669*(H49-H50)*(H49>H50)*((H49-H50)>(L50-L49)) +3407*(H50-H51)*(H50>H51)*((H50-H51)>(L51-L50)) +3163*(H51-H52)*(H51>H52)*((H51-H52)>(L52-L51)) +2937*(H52-H53)*(H52>H53)*((H52-H53)>(L53-L52)) +2728*(H53-H54)*(H53>H54)*((H53-H54)>(L54-L53)) +2533*(H54-H55)*(H54>H55)*((H54-H55)>(L55-L54)) +2352*(H55-H56)*(H55>H56)*((H55-H56)>(L56-L55)) +2184*(H56-H57)*(H56>H57)*((H56-H57)>(L57-L56)) +2028*(H57-H58)*(H57>H58)*((H57-H58)>(L58-L57)) +1883*(H58-H59)*(H58>H59)*((H58-H59)>(L59-L58)) +1749*(H59-H60)*(H59>H60)*((H59-H60)>(L60-L59)) +1624*(H60-H61)*(H60>H61)*((H60-H61)>(L61-L60)) +1508*(H61-H62)*(H61>H62)*((H61-H62)>(L62-L61)) +1400*(H62-H63)*(H62>H63)*((H62-H63)>(L63-L62)))/(1921375*XAVGH27-1921375*XAVGL27 +138541*(ABS(C1-L)+ABS(C1-H)) +128645*(ABS(C2-L1)+ABS(C2-H1)) +119456*(ABS(C3-L2)+ABS(C3-H2)) +110924*(ABS(C4-L3)+ABS(C4-H3)) +103001*(ABS(C5-L4)+ABS(C5-H4)) +95643*(ABS(C6-L5)+ABS(C6-H5)) +88812*(ABS(C7-L6)+ABS(C7-H6)) +82468*(ABS(C8-L7)+ABS(C8-H7)) +76577*(ABS(C9-L8)+ABS(C9-H8)) +71108*(ABS(C10-L9)+ABS(C10-H9)) +66029*(ABS(C11-L10)+ABS(C11-H10)) +61312*(ABS(C12-L11)+ABS(C12-H11)) +56933*(ABS(C13-L12)+ABS(C13-H12)) +52866*(ABS(C14-L13)+ABS(C14-H13)) +49090*(ABS(C15-L14)+ABS(C15-H14)) +45584*(ABS(C16-L15)+ABS(C16-H15)) +42328*(ABS(C17-L16)+ABS(C17-H16)) +39304*(ABS(C18-L17)+ABS(C18-H17)) +36497*(ABS(C19-L18)+ABS(C19-H18)) +33890*(ABS(C20-L19)+ABS(C20-H19)) +31469*(ABS(C21-L20)+ABS(C21-H20)) +29221*(ABS(C22-L21)+ABS(C22-H21)) +27134*(ABS(C23-L22)+ABS(C23-H22)) +25196*(ABS(C24-L23)+ABS(C24-H23)) +23396*(ABS(C25-L24)+ABS(C25-H24)) +21725*(ABS(C26-L25)+ABS(C26-H25)) +20173*(ABS(C27-L26)+ABS(C27-H26)) +18732*(ABS(C28-L27)+ABS(C28-H27)) +17394*(ABS(C29-L28)+ABS(C29-H28)) +16152*(ABS(C30-L29)+ABS(C30-H29)) +14998*(ABS(C31-L30)+ABS(C31-H30)) +13927*(ABS(C32-L31)+ABS(C32-H31)) +12932*(ABS(C33-L32)+ABS(C33-H32)) +12008*(ABS(C34-L33)+ABS(C34-H33)) +11151*(ABS(C35-L34)+ABS(C35-H34)) +10354*(ABS(C36-L35)+ABS(C36-H35)) +9615*(ABS(C37-L36)+ABS(C37-H36)) +8928*(ABS(C38-L37)+ABS(C38-H37)) +8290*(ABS(C39-L38)+ABS(C39-H38)) +7698*(ABS(C40-L39)+ABS(C40-H39)) +7148*(ABS(C41-L40)+ABS(C41-H40)) +6638*(ABS(C42-L41)+ABS(C42-H41)) +6163*(ABS(C43-L42)+ABS(C43-H42)) +5723*(ABS(C44-L43)+ABS(C44-H43)) +5314*(ABS(C45-L44)+ABS(C45-H44)) +4935*(ABS(C46-L45)+ABS(C46-H45)) +4582*(ABS(C47-L46)+ABS(C47-H46)) +4255*(ABS(C48-L47)+ABS(C48-H47)) +3951*(ABS(C49-L48)+ABS(C49-H48)) +3669*(ABS(C50-L49)+ABS(C50-H49)) +3407*(ABS(C51-L50)+ABS(C51-H50)) +3163*(ABS(C52-L51)+ABS(C52-H51)) +2937*(ABS(C53-L52)+ABS(C53-H52)) +2728*(ABS(C54-L53)+ABS(C54-H53)) +2533*(ABS(C55-L54)+ABS(C55-H54)) +2352*(ABS(C56-L55)+ABS(C56-H55)) +2184*(ABS(C57-L56)+ABS(C57-H56)) +2028*(ABS(C58-L57)+ABS(C58-H57)) +1883*(ABS(C59-L58)+ABS(C59-H58)) +1749*(ABS(C60-L59)+ABS(C60-H59)) +1624*(ABS(C61-L60)+ABS(C61-H60)) +1508*(ABS(C62-L61)+ABS(C62-H61)) +1400*(ABS(C63-L62)+ABS(C63-H62)))
-DI14:
200*(138541*(L1-L)*(L1>L)*((L1-L)>(H-H1)) +128645*(L2-L1)*(L2>L1)*((L2-L1)>(H1-H2)) +119456*(L3-L2)*(L3>L2)*((L3-L2)>(H2-H3)) +110924*(L4-L3)*(L4>L3)*((L4-L3)>(H3-H4)) +103001*(L5-L4)*(L5>L4)*((L5-L4)>(H4-H5)) +95643*(L6-L5)*(L6>L5)*((L6-L5)>(H5-H6)) +88812*(L7-L6)*(L7>L6)*((L7-L6)>(H6-H7)) +82468*(L8-L7)*(L8>L7)*((L8-L7)>(H7-H8)) +76577*(L9-L8)*(L9>L8)*((L9-L8)>(H8-H9)) +71108*(L10-L9)*(L10>L9)*((L10-L9)>(H9-H10)) +66029*(L11-L10)*(L11>L10)*((L11-L10)>(H10-H11)) +61312*(L12-L11)*(L12>L11)*((L12-L11)>(H11-H12)) +56933*(L13-L12)*(L13>L12)*((L13-L12)>(H12-H13)) +52866*(L14-L13)*(L14>L13)*((L14-L13)>(H13-H14)) +49090*(L15-L14)*(L15>L14)*((L15-L14)>(H14-H15)) +45584*(L16-L15)*(L16>L15)*((L16-L15)>(H15-H16)) +42328*(L17-L16)*(L17>L16)*((L17-L16)>(H16-H17)) +39304*(L18-L17)*(L18>L17)*((L18-L17)>(H17-H18)) +36497*(L19-L18)*(L19>L18)*((L19-L18)>(H18-H19)) +33890*(L20-L19)*(L20>L19)*((L20-L19)>(H19-H20)) +31469*(L21-L20)*(L21>L20)*((L21-L20)>(H20-H21)) +29221*(L22-L21)*(L22>L21)*((L22-L21)>(H21-H22)) +27134*(L23-L22)*(L23>L22)*((L23-L22)>(H22-H23)) +25196*(L24-L23)*(L24>L23)*((L24-L23)>(H23-H24)) +23396*(L25-L24)*(L25>L24)*((L25-L24)>(H24-H25)) +21725*(L26-L25)*(L26>L25)*((L26-L25)>(H25-H26)) +20173*(L27-L26)*(L27>L26)*((L27-L26)>(H26-H27)) +18732*(L28-L27)*(L28>L27)*((L28-L27)>(H27-H28)) +17394*(L29-L28)*(L29>L28)*((L29-L28)>(H28-H29)) +16152*(L30-L29)*(L30>L29)*((L30-L29)>(H29-H30)) +14998*(L31-L30)*(L31>L30)*((L31-L30)>(H30-H31)) +13927*(L32-L31)*(L32>L31)*((L32-L31)>(H31-H32)) +12932*(L33-L32)*(L33>L32)*((L33-L32)>(H32-H33)) +12008*(L34-L33)*(L34>L33)*((L34-L33)>(H33-H34)) +11151*(L35-L34)*(L35>L34)*((L35-L34)>(H34-H35)) +10354*(L36-L35)*(L36>L35)*((L36-L35)>(H35-H36)) +9615*(L37-L36)*(L37>L36)*((L37-L36)>(H36-H37)) +8928*(L38-L37)*(L38>L37)*((L38-L37)>(H37-H38)) +8290*(L39-L38)*(L39>L38)*((L39-L38)>(H38-H39)) +7698*(L40-L39)*(L40>L39)*((L40-L39)>(H39-H40)) +7148*(L41-L40)*(L41>L40)*((L41-L40)>(H40-H41)) +6638*(L42-L41)*(L42>L41)*((L42-L41)>(H41-H42)) +6163*(L43-L42)*(L43>L42)*((L43-L42)>(H42-H43)) +5723*(L44-L43)*(L44>L43)*((L44-L43)>(H43-H44)) +5314*(L45-L44)*(L45>L44)*((L45-L44)>(H44-H45)) +4935*(L46-L45)*(L46>L45)*((L46-L45)>(H45-H46)) +4582*(L47-L46)*(L47>L46)*((L47-L46)>(H46-H47)) +4255*(L48-L47)*(L48>L47)*((L48-L47)>(H47-H48)) +3951*(L49-L48)*(L49>L48)*((L49-L48)>(H48-H49)) +3669*(L50-L49)*(L50>L49)*((L50-L49)>(H49-H50)) +3407*(L51-L50)*(L51>L50)*((L51-L50)>(H50-H51)) +3163*(L52-L51)*(L52>L51)*((L52-L51)>(H51-H52)) +2937*(L53-L52)*(L53>L52)*((L53-L52)>(H52-H53)) +2728*(L54-L53)*(L54>L53)*((L54-L53)>(H53-H54)) +2533*(L55-L54)*(L55>L54)*((L55-L54)>(H54-H55)) +2352*(L56-L55)*(L56>L55)*((L56-L55)>(H55-H56)) +2184*(L57-L56)*(L57>L56)*((L57-L56)>(H56-H57)) +2028*(L58-L57)*(L58>L57)*((L58-L57)>(H57-H58)) +1883*(L59-L58)*(L59>L58)*((L59-L58)>(H58-H59)) +1749*(L60-L59)*(L60>L59)*((L60-L59)>(H59-H60)) +1624*(L61-L60)*(L61>L60)*((L61-L60)>(H60-H61)) +1508*(L62-L61)*(L62>L61)*((L62-L61)>(H61-H62)) +1400*(L63-L62)*(L63>L62)*((L63-L62)>(H62-H63)))/(1921375*XAVGH27-1921375*XAVGL27 +138541*(ABS(C1-L)+ABS(C1-H)) +128645*(ABS(C2-L1)+ABS(C2-H1)) +119456*(ABS(C3-L2)+ABS(C3-H2)) +110924*(ABS(C4-L3)+ABS(C4-H3)) +103001*(ABS(C5-L4)+ABS(C5-H4)) +95643*(ABS(C6-L5)+ABS(C6-H5)) +88812*(ABS(C7-L6)+ABS(C7-H6)) +82468*(ABS(C8-L7)+ABS(C8-H7)) +76577*(ABS(C9-L8)+ABS(C9-H8)) +71108*(ABS(C10-L9)+ABS(C10-H9)) +66029*(ABS(C11-L10)+ABS(C11-H10)) +61312*(ABS(C12-L11)+ABS(C12-H11)) +56933*(ABS(C13-L12)+ABS(C13-H12)) +52866*(ABS(C14-L13)+ABS(C14-H13)) +49090*(ABS(C15-L14)+ABS(C15-H14)) +45584*(ABS(C16-L15)+ABS(C16-H15)) +42328*(ABS(C17-L16)+ABS(C17-H16)) +39304*(ABS(C18-L17)+ABS(C18-H17)) +36497*(ABS(C19-L18)+ABS(C19-H18)) +33890*(ABS(C20-L19)+ABS(C20-H19)) +31469*(ABS(C21-L20)+ABS(C21-H20)) +29221*(ABS(C22-L21)+ABS(C22-H21)) +27134*(ABS(C23-L22)+ABS(C23-H22)) +25196*(ABS(C24-L23)+ABS(C24-H23)) +23396*(ABS(C25-L24)+ABS(C25-H24)) +21725*(ABS(C26-L25)+ABS(C26-H25)) +20173*(ABS(C27-L26)+ABS(C27-H26)) +18732*(ABS(C28-L27)+ABS(C28-H27)) +17394*(ABS(C29-L28)+ABS(C29-H28)) +16152*(ABS(C30-L29)+ABS(C30-H29)) +14998*(ABS(C31-L30)+ABS(C31-H30)) +13927*(ABS(C32-L31)+ABS(C32-H31)) +12932*(ABS(C33-L32)+ABS(C33-H32)) +12008*(ABS(C34-L33)+ABS(C34-H33)) +11151*(ABS(C35-L34)+ABS(C35-H34)) +10354*(ABS(C36-L35)+ABS(C36-H35)) +9615*(ABS(C37-L36)+ABS(C37-H36)) +8928*(ABS(C38-L37)+ABS(C38-H37)) +8290*(ABS(C39-L38)+ABS(C39-H38)) +7698*(ABS(C40-L39)+ABS(C40-H39)) +7148*(ABS(C41-L40)+ABS(C41-H40)) +6638*(ABS(C42-L41)+ABS(C42-H41)) +6163*(ABS(C43-L42)+ABS(C43-H42)) +5723*(ABS(C44-L43)+ABS(C44-H43)) +5314*(ABS(C45-L44)+ABS(C45-H44)) +4935*(ABS(C46-L45)+ABS(C46-H45)) +4582*(ABS(C47-L46)+ABS(C47-H46)) +4255*(ABS(C48-L47)+ABS(C48-H47)) +3951*(ABS(C49-L48)+ABS(C49-H48)) +3669*(ABS(C50-L49)+ABS(C50-H49)) +3407*(ABS(C51-L50)+ABS(C51-H50)) +3163*(ABS(C52-L51)+ABS(C52-H51)) +2937*(ABS(C53-L52)+ABS(C53-H52)) +2728*(ABS(C54-L53)+ABS(C54-H53)) +2533*(ABS(C55-L54)+ABS(C55-H54)) +2352*(ABS(C56-L55)+ABS(C56-H55)) +2184*(ABS(C57-L56)+ABS(C57-H56)) +2028*(ABS(C58-L57)+ABS(C58-H57)) +1883*(ABS(C59-L58)+ABS(C59-H58)) +1749*(ABS(C60-L59)+ABS(C60-H59)) +1624*(ABS(C61-L60)+ABS(C61-H60)) +1508*(ABS(C62-L61)+ABS(C62-H61)) +1400*(ABS(C63-L62)+ABS(C63-H62)))
Can you imagine trying to find a misplaced paranthesis in this one? 
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 799
Location: Duluth, GA
|
There is another thread, "PCF for Wilder's Directional Movement DMI-crossovers" located here:
PCF for Wilder's Directional Movement DMI-crossovers
and one that follows it, "PCF for Wilder's DX, and/or a CI for Wilder's ADX" located here:
PCF for Wilder's DX, and/or a CI for Wilder's ADX
which VERY fully cover the core theory and formulae required to answer this question.
The formula above is an example of the solution, based on those principles. But the other two articles are a bit more readable :D
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
Starting to understand the ADX Indicator and have searched but not found the PCFs for the following settings, I presume they are going to be long.
ADX Settings:
1. DX Period 10, Average 10, Today
2. DX Period 10, Average 10, Yesterday
3. +DI 10, Today
4. –DI 10, Today
5. +DI 10, Yesterday
6. -DI 10, Yesterday
Once I have the six PCFs one should be able to scan for different criteria, crossovers, ADX above or below a value, etc.
The formula for +DI Crossing -DI is as follows:
SGN((+DI 10 Today) - (-DI 10 Today)) - SGN((+DI 10 Yesterday) - (-DI 10Yesterday))
Thanks
Winnie
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
A workable PCF for ADX is not possible. Check out the links Tanstaafl gives above.
- Craig
Here to Help!
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
What about numbers 3-6
Thanks
Winnie
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Winnie,
You could try the following for a crossover based on a DX Period set to 10 (you can adjust the accuracy and speed by adjusting the number of terms included in each of the SGN() functions):
SGN((H - H1) * (H - H1 > L1 - L) * (H > H1) - (L1 - L) * (H - H1 < L1 - L) * (L < L1) + .9 * ((H1 - H2) * (H1 - H2 > L2 - L1) * (H1 > H2) - (L2 - L1) * (H1 - H2 < L2 - L1) * (L1 < L2) + .9 * ((H2 - H3) * (H2 - H3 > L3 - L2) * (H2 > H3) - (L3 - L2) * (H2 - H3 < L3 - L2) * (L2 < L3) + .9 * ((H3 - H4) * (H3 - H4 > L4 - L3) * (H3 > H4) - (L4 - L3) * (H3 - H4 < L4 - L3) * (L3 < L4) + .9 * ((H4 - H5) * (H4 - H5 > L5 - L4) * (H4 > H5) - (L5 - L4) * (H4 - H5 < L5 - L4) * (L4 < L5) + .9 * ((H5 - H6) * (H5 - H6 > L6 - L5) * (H5 > H6) - (L6 - L5) * (H5 - H6 < L6 - L5) * (L5 < L6) + .9 * ((H6 - H7) * (H6 - H7 > L7 - L6) * (H6 > H7) - (L7 - L6) * (H6 - H7 < L7 - L6) * (L6 < L7) + .9 * ((H7 - H8) * (H7 - H8 > L8 - L7) * (H7 > H8) - (L8 - L7) * (H7 - H8 < L8 - L7) * (L7 < L8) + .9 * ((H8 - H9) * (H8 - H9 > L9 - L8) * (H8 > H9) - (L9 - L8) * (H8 - H9 < L9 - L8) * (L8 < L9) + .9 * ((H9 - H10) * (H9 - H10 > L10 - L9) * (H9 > H10) - (L10 - L9) * (H9 - H10 < L10 - L9) * (L9 < L10) + .9 * ((H10 - H11) * (H10 - H11 > L11 - L10) * (H10 > H11) - (L11 - L10) * (H10 - H11 < L11 - L10) * (L10 < L11) + .9 * ((H11 - H12) * (H11 - H12 > L12 - L11) * (H11 > H12) - (L12 - L11) * (H11 - H12 < L12 - L11) * (L11 < L12) + .9 * ((H12 - H13) * (H12 - H13 > L13 - L12) * (H12 > H13) - (L13 - L12) * (H12 - H13 < L13 - L12) * (L12 < L13) + .9 * ((H13 - H14) * (H13 - H14 > L14 - L13) * (H13 > H14) - (L14 - L13) * (H13 - H14 < L14 - L13) * (L13 < L14) + .9 * ((H14 - H15) * (H14 - H15 > L15 - L14) * (H14 > H15) - (L15 - L14) * (H14 - H15 < L15 - L14) * (L14 < L15) + .9 * ((H15 - H16) * (H15 - H16 > L16 - L15) * (H15 > H16) - (L16 - L15) * (H15 - H16 < L16 - L15) * (L15 < L16) + .9 * ((H16 - H17) * (H16 - H17 > L17 - L16) * (H16 > H17) - (L17 - L16) * (H16 - H17 < L17 - L16) * (L16 < L17) + .9 * ((H17 - H18) * (H17 - H18 > L18 - L17) * (H17 > H18) - (L18 - L17) * (H17 - H18 < L18 - L17) * (L17 < L18) + .9 * ((H18 - H19) * (H18 - H19 > L19 - L18) * (H18 > H19) - (L19 - L18) * (H18 - H19 < L19 - L18) * (L18 < L19) + .9 * ((H19 - H20) * (H19 - H20 > L20 - L19) * (H19 > H20) - (L20 - L19) * (H19 - H20 < L20 - L19) * (L19 < L20) + .9 * ((H20 - H21) * (H20 - H21 > L21 - L20) * (H20 > H21) - (L21 - L20) * (H20 - H21 < L21 - L20) * (L20 < L21) + .9 * ((H21 - H22) * (H21 - H22 > L22 - L21) * (H21 > H22) - (L22 - L21) * (H21 - H22 < L22 - L21) * (L21 < L22) + .9 * ((H22 - H23) * (H22 - H23 > L23 - L22) * (H22 > H23) - (L23 - L22) * (H22 - H23 < L23 - L22) * (L22 < L23) + .9 * ((H23 - H24) * (H23 - H24 > L24 - L23) * (H23 > H24) - (L24 - L23) * (H23 - H24 < L24 - L23) * (L23 < L24) + .9 * ((H24 - H25) * (H24 - H25 > L25 - L24) * (H24 > H25) - (L25 - L24) * (H24 - H25 < L25 - L24) * (L24 < L25) + .9 * ((H25 - H26) * (H25 - H26 > L26 - L25) * (H25 > H26) - (L26 - L25) * (H25 - H26 < L26 - L25) * (L25 < L26) + .9 * ((H26 - H27) * (H26 - H27 > L27 - L26) * (H26 > H27) - (L27 - L26) * (H26 - H27 < L27 - L26) * (L26 < L27) + .9 * ((H27 - H28) * (H27 - H28 > L28 - L27) * (H27 > H28) - (L28 - L27) * (H27 - H28 < L28 - L27) * (L27 < L28) + .9 * ((H28 - H29) * (H28 - H29 > L29 - L28) * (H28 > H29) - (L29 - L28) * (H28 - H29 < L29 - L28) * (L28 < L29) + .9 * ((H29 - H30) * (H29 - H30 > L30 - L29) * (H29 > H30) - (L30 - L29) * (H29 - H30 < L30 - L29) * (L29 < L30) + .9 * ((H30 - H31) * (H30 - H31 > L31 - L30) * (H30 > H31) - (L31 - L30) * (H30 - H31 < L31 - L30) * (L30 < L31) + .9 * ((H31 - H32) * (H31 - H32 > L32 - L31) * (H31 > H32) - (L32 - L31) * (H31 - H32 < L32 - L31) * (L31 < L32) + .9 * ((H32 - H33) * (H32 - H33 > L33 - L32) * (H32 > H33) - (L33 - L32) * (H32 - H33 < L33 - L32) * (L32 < L33) + .9 * ((H33 - H34) * (H33 - H34 > L34 - L33) * (H33 > H34) - (L34 - L33) * (H33 - H34 < L34 - L33) * (L33 < L34) + .9 * ((H34 - H35) * (H34 - H35 > L35 - L34) * (H34 > H35) - (L35 - L34) * (H34 - H35 < L35 - L34) * (L34 < L35) + .9 * ((H35 - H36) * (H35 - H36 > L36 - L35) * (H35 > H36) - (L36 - L35) * (H35 - H36 < L36 - L35) * (L35 < L36) + .9 * ((H36 - H37) * (H36 - H37 > L37 - L36) * (H36 > H37) - (L37 - L36) * (H36 - H37 < L37 - L36) * (L36 < L37) + .9 * ((H37 - H38) * (H37 - H38 > L38 - L37) * (H37 > H38) - (L38 - L37) * (H37 - H38 < L38 - L37) * (L37 < L38) + .9 * ((H38 - H39) * (H38 - H39 > L39 - L38) * (H38 > H39) - (L39 - L38) * (H38 - H39 < L39 - L38) * (L38 < L39) + .9 * ((H39 - H40) * (H39 - H40 > L40 - L39) * (H39 > H40) - (L40 - L39) * (H39 - H40 < L40 - L39) * (L39 < L40) + .9 * ((H40 - H41) * (H40 - H41 > L41 - L40) * (H40 > H41) - (L41 - L40) * (H40 - H41 < L41 - L40) * (L40 < L41) + .9 * ((H41 - H42) * (H41 - H42 > L42 - L41) * (H41 > H42) - (L42 - L41) * (H41 - H42 < L42 - L41) * (L41 < L42) + .9 * ((H42 - H43) * (H42 - H43 > L43 - L42) * (H42 > H43) - (L43 - L42) * (H42 - H43 < L43 - L42) * (L42 < L43) + .9 * ((H43 - H44) * (H43 - H44 > L44 - L43) * (H43 > H44) - (L44 - L43) * (H43 - H44 < L44 - L43) * (L43 < L44) + .9 * ((H44 - H45) * (H44 - H45 > L45 - L44) * (H44 > H45) - (L45 - L44) * (H44 - H45 < L45 - L44) * (L44 < L45) + .9 * ((H45 - H46) * (H45 - H46 > L46 - L45) * (H45 > H46) - (L46 - L45) * (H45 - H46 < L46 - L45) * (L45 < L46) + .9 * ((H46 - H47) * (H46 - H47 > L47 - L46) * (H46 > H47) - (L47 - L46) * (H46 - H47 < L47 - L46) * (L46 < L47) + .9 * ((H47 - H48) * (H47 - H48 > L48 - L47) * (H47 > H48) - (L48 - L47) * (H47 - H48 < L48 - L47) * (L47 < L48) + .9 * ((H48 - H49) * (H48 - H49 > L49 - L48) * (H48 > H49) - (L49 - L48) * (H48 - H49 < L49 - L48) * (L48 < L49) + .9 * ((H49 - H50) * (H49 - H50 > L50 - L49) * (H49 > H50) - (L50 - L49) * (H49 - H50 < L50 - L49) * (L49 < L50) + .9 * ((H50 - H51) * (H50 - H51 > L51 - L50) * (H50 > H51) - (L51 - L50) * (H50 - H51 < L51 - L50) * (L50 < L51) + .9 * ((H51 - H52) * (H51 - H52 > L52 - L51) * (H51 > H52) - (L52 - L51) * (H51 - H52 < L52 - L51) * (L51 < L52) + .9 * ((H52 - H53) * (H52 - H53 > L53 - L52) * (H52 > H53) - (L53 - L52) * (H52 - H53 < L53 - L52) * (L52 < L53) + .9 * ((H53 - H54) * (H53 - H54 > L54 - L53) * (H53 > H54) - (L54 - L53) * (H53 - H54 < L54 - L53) * (L53 < L54) + .9 * ((H54 - H55) * (H54 - H55 > L55 - L54) * (H54 > H55) - (L55 - L54) * (H54 - H55 < L55 - L54) * (L54 < L55) + .9 * ((H55 - H56) * (H55 - H56 > L56 - L55) * (H55 > H56) - (L56 - L55) * (H55 - H56 < L56 - L55) * (L55 < L56) + .9 * ((H56 - H57) * (H56 - H57 > L57 - L56) * (H56 > H57) - (L57 - L56) * (H56 - H57 < L57 - L56) * (L56 < L57) + .9 * ((H57 - H58) * (H57 - H58 > L58 - L57) * (H57 > H58) - (L58 - L57) * (H57 - H58 < L58 - L57) * (L57 < L58) + .9 * ((H58 - H59) * (H58 - H59 > L59 - L58) * (H58 > H59) - (L59 - L58) * (H58 - H59 < L59 - L58) * (L58 < L59) + .9 * ((H59 - H60) * (H59 - H60 > L60 - L59) * (H59 > H60) - (L60 - L59) * (H59 - H60 < L60 - L59) * (L59 < L60) + .9 * ((H60 - H61) * (H60 - H61 > L61 - L60) * (H60 > H61) - (L61 - L60) * (H60 - H61 < L61 - L60) * (L60 < L61) + .9 * ((H61 - H62) * (H61 - H62 > L62 - L61) * (H61 > H62) - (L62 - L61) * (H61 - H62 < L62 - L61) * (L61 < L62) + .9 * ((H62 - H63) * (H62 - H63 > L63 - L62) * (H62 > H63) - (L63 - L62) * (H62 - H63 < L63 - L62) * (L62 < L63) + .9 * ((H63 - H64) * (H63 - H64 > L64 - L63) * (H63 > H64) - (L64 - L63) * (H63 - H64 < L64 - L63) * (L63 < L64) + .9 * ((H64 - H65) * (H64 - H65 > L65 - L64) * (H64 > H65) - (L65 - L64) * (H64 - H65 < L65 - L64) * (L64 < L65) + .9 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66) - (L66 - L65) * (H65 - H66 < L66 - L65) * (L65 < L66))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - SGN((H1 - H2) * (H1 - H2 > L2 - L1) * (H1 > H2) - (L2 - L1) * (H1 - H2 < L2 - L1) * (L1 < L2) + .9 * ((H2 - H3) * (H2 - H3 > L3 - L2) * (H2 > H3) - (L3 - L2) * (H2 - H3 < L3 - L2) * (L2 < L3) + .9 * ((H3 - H4) * (H3 - H4 > L4 - L3) * (H3 > H4) - (L4 - L3) * (H3 - H4 < L4 - L3) * (L3 < L4) + .9 * ((H4 - H5) * (H4 - H5 > L5 - L4) * (H4 > H5) - (L5 - L4) * (H4 - H5 < L5 - L4) * (L4 < L5) + .9 * ((H5 - H6) * (H5 - H6 > L6 - L5) * (H5 > H6) - (L6 - L5) * (H5 - H6 < L6 - L5) * (L5 < L6) + .9 * ((H6 - H7) * (H6 - H7 > L7 - L6) * (H6 > H7) - (L7 - L6) * (H6 - H7 < L7 - L6) * (L6 < L7) + .9 * ((H7 - H8) * (H7 - H8 > L8 - L7) * (H7 > H8) - (L8 - L7) * (H7 - H8 < L8 - L7) * (L7 < L8) + .9 * ((H8 - H9) * (H8 - H9 > L9 - L8) * (H8 > H9) - (L9 - L8) * (H8 - H9 < L9 - L8) * (L8 < L9) + .9 * ((H9 - H10) * (H9 - H10 > L10 - L9) * (H9 > H10) - (L10 - L9) * (H9 - H10 < L10 - L9) * (L9 < L10) + .9 * ((H10 - H11) * (H10 - H11 > L11 - L10) * (H10 > H11) - (L11 - L10) * (H10 - H11 < L11 - L10) * (L10 < L11) + .9 * ((H11 - H12) * (H11 - H12 > L12 - L11) * (H11 > H12) - (L12 - L11) * (H11 - H12 < L12 - L11) * (L11 < L12) + .9 * ((H12 - H13) * (H12 - H13 > L13 - L12) * (H12 > H13) - (L13 - L12) * (H12 - H13 < L13 - L12) * (L12 < L13) + .9 * ((H13 - H14) * (H13 - H14 > L14 - L13) * (H13 > H14) - (L14 - L13) * (H13 - H14 < L14 - L13) * (L13 < L14) + .9 * ((H14 - H15) * (H14 - H15 > L15 - L14) * (H14 > H15) - (L15 - L14) * (H14 - H15 < L15 - L14) * (L14 < L15) + .9 * ((H15 - H16) * (H15 - H16 > L16 - L15) * (H15 > H16) - (L16 - L15) * (H15 - H16 < L16 - L15) * (L15 < L16) + .9 * ((H16 - H17) * (H16 - H17 > L17 - L16) * (H16 > H17) - (L17 - L16) * (H16 - H17 < L17 - L16) * (L16 < L17) + .9 * ((H17 - H18) * (H17 - H18 > L18 - L17) * (H17 > H18) - (L18 - L17) * (H17 - H18 < L18 - L17) * (L17 < L18) + .9 * ((H18 - H19) * (H18 - H19 > L19 - L18) * (H18 > H19) - (L19 - L18) * (H18 - H19 < L19 - L18) * (L18 < L19) + .9 * ((H19 - H20) * (H19 - H20 > L20 - L19) * (H19 > H20) - (L20 - L19) * (H19 - H20 < L20 - L19) * (L19 < L20) + .9 * ((H20 - H21) * (H20 - H21 > L21 - L20) * (H20 > H21) - (L21 - L20) * (H20 - H21 < L21 - L20) * (L20 < L21) + .9 * ((H21 - H22) * (H21 - H22 > L22 - L21) * (H21 > H22) - (L22 - L21) * (H21 - H22 < L22 - L21) * (L21 < L22) + .9 * ((H22 - H23) * (H22 - H23 > L23 - L22) * (H22 > H23) - (L23 - L22) * (H22 - H23 < L23 - L22) * (L22 < L23) + .9 * ((H23 - H24) * (H23 - H24 > L24 - L23) * (H23 > H24) - (L24 - L23) * (H23 - H24 < L24 - L23) * (L23 < L24) + .9 * ((H24 - H25) * (H24 - H25 > L25 - L24) * (H24 > H25) - (L25 - L24) * (H24 - H25 < L25 - L24) * (L24 < L25) + .9 * ((H25 - H26) * (H25 - H26 > L26 - L25) * (H25 > H26) - (L26 - L25) * (H25 - H26 < L26 - L25) * (L25 < L26) + .9 * ((H26 - H27) * (H26 - H27 > L27 - L26) * (H26 > H27) - (L27 - L26) * (H26 - H27 < L27 - L26) * (L26 < L27) + .9 * ((H27 - H28) * (H27 - H28 > L28 - L27) * (H27 > H28) - (L28 - L27) * (H27 - H28 < L28 - L27) * (L27 < L28) + .9 * ((H28 - H29) * (H28 - H29 > L29 - L28) * (H28 > H29) - (L29 - L28) * (H28 - H29 < L29 - L28) * (L28 < L29) + .9 * ((H29 - H30) * (H29 - H30 > L30 - L29) * (H29 > H30) - (L30 - L29) * (H29 - H30 < L30 - L29) * (L29 < L30) + .9 * ((H30 - H31) * (H30 - H31 > L31 - L30) * (H30 > H31) - (L31 - L30) * (H30 - H31 < L31 - L30) * (L30 < L31) + .9 * ((H31 - H32) * (H31 - H32 > L32 - L31) * (H31 > H32) - (L32 - L31) * (H31 - H32 < L32 - L31) * (L31 < L32) + .9 * ((H32 - H33) * (H32 - H33 > L33 - L32) * (H32 > H33) - (L33 - L32) * (H32 - H33 < L33 - L32) * (L32 < L33) + .9 * ((H33 - H34) * (H33 - H34 > L34 - L33) * (H33 > H34) - (L34 - L33) * (H33 - H34 < L34 - L33) * (L33 < L34) + .9 * ((H34 - H35) * (H34 - H35 > L35 - L34) * (H34 > H35) - (L35 - L34) * (H34 - H35 < L35 - L34) * (L34 < L35) + .9 * ((H35 - H36) * (H35 - H36 > L36 - L35) * (H35 > H36) - (L36 - L35) * (H35 - H36 < L36 - L35) * (L35 < L36) + .9 * ((H36 - H37) * (H36 - H37 > L37 - L36) * (H36 > H37) - (L37 - L36) * (H36 - H37 < L37 - L36) * (L36 < L37) + .9 * ((H37 - H38) * (H37 - H38 > L38 - L37) * (H37 > H38) - (L38 - L37) * (H37 - H38 < L38 - L37) * (L37 < L38) + .9 * ((H38 - H39) * (H38 - H39 > L39 - L38) * (H38 > H39) - (L39 - L38) * (H38 - H39 < L39 - L38) * (L38 < L39) + .9 * ((H39 - H40) * (H39 - H40 > L40 - L39) * (H39 > H40) - (L40 - L39) * (H39 - H40 < L40 - L39) * (L39 < L40) + .9 * ((H40 - H41) * (H40 - H41 > L41 - L40) * (H40 > H41) - (L41 - L40) * (H40 - H41 < L41 - L40) * (L40 < L41) + .9 * ((H41 - H42) * (H41 - H42 > L42 - L41) * (H41 > H42) - (L42 - L41) * (H41 - H42 < L42 - L41) * (L41 < L42) + .9 * ((H42 - H43) * (H42 - H43 > L43 - L42) * (H42 > H43) - (L43 - L42) * (H42 - H43 < L43 - L42) * (L42 < L43) + .9 * ((H43 - H44) * (H43 - H44 > L44 - L43) * (H43 > H44) - (L44 - L43) * (H43 - H44 < L44 - L43) * (L43 < L44) + .9 * ((H44 - H45) * (H44 - H45 > L45 - L44) * (H44 > H45) - (L45 - L44) * (H44 - H45 < L45 - L44) * (L44 < L45) + .9 * ((H45 - H46) * (H45 - H46 > L46 - L45) * (H45 > H46) - (L46 - L45) * (H45 - H46 < L46 - L45) * (L45 < L46) + .9 * ((H46 - H47) * (H46 - H47 > L47 - L46) * (H46 > H47) - (L47 - L46) * (H46 - H47 < L47 - L46) * (L46 < L47) + .9 * ((H47 - H48) * (H47 - H48 > L48 - L47) * (H47 > H48) - (L48 - L47) * (H47 - H48 < L48 - L47) * (L47 < L48) + .9 * ((H48 - H49) * (H48 - H49 > L49 - L48) * (H48 > H49) - (L49 - L48) * (H48 - H49 < L49 - L48) * (L48 < L49) + .9 * ((H49 - H50) * (H49 - H50 > L50 - L49) * (H49 > H50) - (L50 - L49) * (H49 - H50 < L50 - L49) * (L49 < L50) + .9 * ((H50 - H51) * (H50 - H51 > L51 - L50) * (H50 > H51) - (L51 - L50) * (H50 - H51 < L51 - L50) * (L50 < L51) + .9 * ((H51 - H52) * (H51 - H52 > L52 - L51) * (H51 > H52) - (L52 - L51) * (H51 - H52 < L52 - L51) * (L51 < L52) + .9 * ((H52 - H53) * (H52 - H53 > L53 - L52) * (H52 > H53) - (L53 - L52) * (H52 - H53 < L53 - L52) * (L52 < L53) + .9 * ((H53 - H54) * (H53 - H54 > L54 - L53) * (H53 > H54) - (L54 - L53) * (H53 - H54 < L54 - L53) * (L53 < L54) + .9 * ((H54 - H55) * (H54 - H55 > L55 - L54) * (H54 > H55) - (L55 - L54) * (H54 - H55 < L55 - L54) * (L54 < L55) + .9 * ((H55 - H56) * (H55 - H56 > L56 - L55) * (H55 > H56) - (L56 - L55) * (H55 - H56 < L56 - L55) * (L55 < L56) + .9 * ((H56 - H57) * (H56 - H57 > L57 - L56) * (H56 > H57) - (L57 - L56) * (H56 - H57 < L57 - L56) * (L56 < L57) + .9 * ((H57 - H58) * (H57 - H58 > L58 - L57) * (H57 > H58) - (L58 - L57) * (H57 - H58 < L58 - L57) * (L57 < L58) + .9 * ((H58 - H59) * (H58 - H59 > L59 - L58) * (H58 > H59) - (L59 - L58) * (H58 - H59 < L59 - L58) * (L58 < L59) + .9 * ((H59 - H60) * (H59 - H60 > L60 - L59) * (H59 > H60) - (L60 - L59) * (H59 - H60 < L60 - L59) * (L59 < L60) + .9 * ((H60 - H61) * (H60 - H61 > L61 - L60) * (H60 > H61) - (L61 - L60) * (H60 - H61 < L61 - L60) * (L60 < L61) + .9 * ((H61 - H62) * (H61 - H62 > L62 - L61) * (H61 > H62) - (L62 - L61) * (H61 - H62 < L62 - L61) * (L61 < L62) + .9 * ((H62 - H63) * (H62 - H63 > L63 - L62) * (H62 > H63) - (L63 - L62) * (H62 - H63 < L63 - L62) * (L62 < L63) + .9 * ((H63 - H64) * (H63 - H64 > L64 - L63) * (H63 > H64) - (L64 - L63) * (H63 - H64 < L64 - L63) * (L63 < L64) + .9 * ((H64 - H65) * (H64 - H65 > L65 - L64) * (H64 > H65) - (L65 - L64) * (H64 - H65 < L65 - L64) * (L64 < L65) + .9 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66) - (L66 - L65) * (H65 - H66 < L66 - L65) * (L65 < L66) + .9 * ((H66 - H67) * (H66 - H67 > L67 - L66) * (H66 > H67) - (L67 - L66) * (H66 - H67 < L67 - L66) * (L66 < L67)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
It's easier, and probably quicker, to use the the method described by Tanstaafl in his Wednesday, December 15, 2004 7:35:09 AM ET post in PCF for Wilder's Directional Movement DMI-crossovers.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
Bruce – Thanks so much, I tested the PCF and all the returns were OK. I’ll also look at Tanstaafl method when I have time to understand more about the ADX indicator.
Can you explain your comment:
(you can adjust the accuracy and speed by adjusting the number of terms included in each of the SGN() functions):
Side Note: If one wants to reference areas from previous posts, similar to above, I’ve seen grayed areas, how do you do this.
Many Thanks
Winnie
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Winnie) If one wants to reference areas from previous posts, similar to above, I’ve seen grayed areas, how do you do this.
Using the Quote button in the upper right hand corner of a post will quote the entire post. Just delete everything you don't want to include.
QUOTE (Winnie) Can you explain your comment: (you can adjust the accuracy and speed by adjusting the number of terms included in each of the SGN() functions):
Each part of the formula currently has 66 terms. The last term of the first part of the formula is:
+ .9 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66) - (L66 - L65) * (H65 - H66 < L66 - L65) * (L65 < L66))
If you take it out, there would only be 65 terms. The formula would be trading off a little bit of accuracy for a little bit of extra speed. The effect would not be particularly significant. But if you do this 30 times instead of once, the effect on both speed and accuracy is more dramatic. You can add additional terms as well by following the pattern (the last parenthesis in each term goes at the end of the formula, not the end of the term).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
Great, got it.
Thanks
Winnie
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
Bruce - thanks for your crossover PCF, works great, there’s no way I could have come up with the formula.
SGN ((H - H1) * (H - H1 > L1 - L) * (H > H1) - (L1 - L) * (H - H1 < L1 - L) * (L < L1)
+ .9 * ((H1 - H2) * (H1 - H2 > L2 - L1) * (H1 > H2) - (L2 - L1) * (H1 - H2 < L2 - L1) * (L1 < L2)
+ .9 * ((H2 - H3) * (H2 - H3 > L3 - L2) * (H2 > H3) - (L3 - L2) * (H2 - H3 < L3 - L2) * (L2 <
………………
+ .9 * ((H64 - H65) * (H64 - H65 > L65 - L64) * (H64 > H65) - (L65 - L64) * (H64 - H65 < L65 - L64) * (L64 < L65)
+ .9 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66) - (L66 - L65) * (H65 - H66 < L66 - L65) * (L65 < L66)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
- SGN ((H1 - H2) * (H1 - H2 > L2 - L1) * (H1 > H2) - (L2 - L1) * (H1 - H2 < L2 - L1) * (L1 < L2)
+ .9 * ((H2 - H3) * (H2 - H3 > L3 - L2) * (H2 > H3) - (L3 - L2) * (H2 - H3 < L3 - L2) * (L2 < L3)
………………
+ .9 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66) - (L66 - L65) * (H65 - H66 < L66 - L65) * (L65 < L66)
+ .9 * ((H66 - H67) * (H66 - H67 > L67 - L66) * (H66 > H67) - (L67 - L66) * (H66 - H67 < L67 - L66) * (L66 < L67)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Which on is the +DI and which one is the -DI?
Still like construct a scan for ADX10,10 where the +DI is at a certain selected value, say < 10 and the -DI is at another selected value, say > 40 or vice versa. Is there a PCF that will do this? I’ve included an image of SYY at the beginning of August as an example.
Thanks
Winnie
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
Hi Bruce – over the weekend I looked very close at the ADX Indicator, I went through various books and hundreds of charts to see the relationship of the Price, ADX, +DI and –DI.
I’m very interested to understand and write PCFs for each line, like to be able to do the following.
1. Write a PCF to assign a value say  < or > for the +DI or –DI
2. Write a PCF to assign a slope or ROC say for the last 2-5 Days for the +DI or –DI
3. Write a PCF to assign a value for the ADX, my understanding from Craig’s post this can’t be done?
4. If the program can sort the ADX by ( a – e ) noted below, I presume a PCF can be written:
a. Visual Value
b. Visual Change
c. Actual Value
d. Net Change
e. % Change
I apologize if I seem naïve, I don’t know much about the indicator but am determined to understand and feel comfortable using it and writing ADX PCFs.
Just like the Linear Regression Indicator, I didn’t have a clue but thanks to your math genius and explanations, I can write any LR, the Price Crossover, Value, Slope, % Slope etc., hopefully we can do the same for the ADX Indicator.
Thanks
Winnie
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Winnie) Which on is the +DI and which one is the -DI?
Have you had a chance to read through the topics Tanstaafl referenced in his Saturday, December 11, 2004 2:36:44 AM ET post? The +DI and -DI are not required to detect crossovers of the +DI and -DI and were not included because doing so would significantly increase both the length of the formula and the time required for calculation. (H - H1) * (H - H1 > L1 - L) * (H > H1) is the first bar of the +DMI calculation and (L1 - L) * (H - H1 < L1 - L) * (L < L1) is the first bar of the -DMI calculation. The subtraction is done before the Moving Average is applied because it shortens the formula significantly. +DI is +DMI divided by the ATR and -DI is -DMI divided by the ATR.
QUOTE (Winnie) Write a PCF to assign a value say < or > for the +DI or –DI
I'll post formulas for +DI and -DI, but it will be some time before they are posted. I don't have a spreadsheet for them because I don't consider the formulas practical. Then again, they will probably be about the same size as the crossover formula.
QUOTE (Winnie) Write a PCF to assign a slope or ROC say for the last 2-5 Days for the +DI or –DI
I'm not writing a slope formula. I'll take a look at the ROC formula, but it will probably be about twice as long as the +DI or -DI formulas.
QUOTE (Winnie) Write a PCF to assign a value for the ADX, my understanding from Craig’s post this can’t be done?
If the program can sort the ADX by ( a – e ) noted below, I presume a PCF can be written:
a. Visual Value
b. Visual Change
c. Actual Value
d. Net Change
e. % Change
Craig is correct when indicating an ADX formula using TeleChart's Personal Criteria Formula Language is not practical. Your presumption that formulas can be written for ADX Indicator Sorts is incorrect. All would require at least one ADX formula in their calculation.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 799
Location: Duluth, GA
|
Bruce -
Thanks, once again, for maintaining support on these "monster" formulae that I originally posted before SnapSheets was available.
Much of this is very practical to do in SnapSheets. I presume that soon SS will include Scan/Filter watchlist capabilities as well, which would put the icing on the cake.
Even tho SS is still a work in progress, I'd encourage anyone who is seriously considering using these massive ADX/DMI formulae (or other long ones) to move their operations over to SS as soon as possible.
Jim Dean
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Tanstaafl) I'd encourage anyone who is seriously considering using these massive ADX/DMI formulae (or other long ones) to move their operations over to SS as soon as possible.
I agree. There currently isn't anything built into SnapSheets equivalent to TeleChart's EasyScan, but this feature has already been announced as one that will be added. Having a basic understanding of SnapSheets when the feature does become available seems better than waiting.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
Bruce – Thanks for the explanation and future PCFs, it answers some of my questions, I will read Tanstaafl previous posts and your and his recommendation to move to SS, please note, there is no urgency with all this.
Thanks for your help, have a great day
Winnie
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
10-Period +DI:
10.0095591785708 * ((H - H1) * (H - H1 > L1 - L) * (H > H1) + .9 * ((H1 - H2) * (H1 - H2 > L2 - L1) * (H1 > H2) + .9 * ((H2 - H3) * (H2 - H3 > L3 - L2) * (H2 > H3) + .9 * ((H3 - H4) * (H3 - H4 > L4 - L3) * (H3 > H4) + .9 * ((H4 - H5) * (H4 - H5 > L5 - L4) * (H4 > H5) + .9 * ((H5 - H6) * (H5 - H6 > L6 - L5) * (H5 > H6) + .9 * ((H6 - H7) * (H6 - H7 > L7 - L6) * (H6 > H7) + .9 * ((H7 - H8) * (H7 - H8 > L8 - L7) * (H7 > H8) + .9 * ((H8 - H9) * (H8 - H9 > L9 - L8) * (H8 > H9) + .9 * ((H9 - H10) * (H9 - H10 > L10 - L9) * (H9 > H10) + .9 * ((H10 - H11) * (H10 - H11 > L11 - L10) * (H10 > H11) + .9 * ((H11 - H12) * (H11 - H12 > L12 - L11) * (H11 > H12) + .9 * ((H12 - H13) * (H12 - H13 > L13 - L12) * (H12 > H13) + .9 * ((H13 - H14) * (H13 - H14 > L14 - L13) * (H13 > H14) + .9 * ((H14 - H15) * (H14 - H15 > L15 - L14) * (H14 > H15) + .9 * ((H15 - H16) * (H15 - H16 > L16 - L15) * (H15 > H16) + .9 * ((H16 - H17) * (H16 - H17 > L17 - L16) * (H16 > H17) + .9 * ((H17 - H18) * (H17 - H18 > L18 - L17) * (H17 > H18) + .9 * ((H18 - H19) * (H18 - H19 > L19 - L18) * (H18 > H19) + .9 * ((H19 - H20) * (H19 - H20 > L20 - L19) * (H19 > H20) + .9 * ((H20 - H21) * (H20 - H21 > L21 - L20) * (H20 > H21) + .9 * ((H21 - H22) * (H21 - H22 > L22 - L21) * (H21 > H22) + .9 * ((H22 - H23) * (H22 - H23 > L23 - L22) * (H22 > H23) + .9 * ((H23 - H24) * (H23 - H24 > L24 - L23) * (H23 > H24) + .9 * ((H24 - H25) * (H24 - H25 > L25 - L24) * (H24 > H25) + .9 * ((H25 - H26) * (H25 - H26 > L26 - L25) * (H25 > H26) + .9 * ((H26 - H27) * (H26 - H27 > L27 - L26) * (H26 > H27) + .9 * ((H27 - H28) * (H27 - H28 > L28 - L27) * (H27 > H28) + .9 * ((H28 - H29) * (H28 - H29 > L29 - L28) * (H28 > H29) + .9 * ((H29 - H30) * (H29 - H30 > L30 - L29) * (H29 > H30) + .9 * ((H30 - H31) * (H30 - H31 > L31 - L30) * (H30 > H31) + .9 * ((H31 - H32) * (H31 - H32 > L32 - L31) * (H31 > H32) + .9 * ((H32 - H33) * (H32 - H33 > L33 - L32) * (H32 > H33) + .9 * ((H33 - H34) * (H33 - H34 > L34 - L33) * (H33 > H34) + .9 * ((H34 - H35) * (H34 - H35 > L35 - L34) * (H34 > H35) + .9 * ((H35 - H36) * (H35 - H36 > L36 - L35) * (H35 > H36) + .9 * ((H36 - H37) * (H36 - H37 > L37 - L36) * (H36 > H37) + .9 * ((H37 - H38) * (H37 - H38 > L38 - L37) * (H37 > H38) + .9 * ((H38 - H39) * (H38 - H39 > L39 - L38) * (H38 > H39) + .9 * ((H39 - H40) * (H39 - H40 > L40 - L39) * (H39 > H40) + .9 * ((H40 - H41) * (H40 - H41 > L41 - L40) * (H40 > H41) + .9 * ((H41 - H42) * (H41 - H42 > L42 - L41) * (H41 > H42) + .9 * ((H42 - H43) * (H42 - H43 > L43 - L42) * (H42 > H43) + .9 * ((H43 - H44) * (H43 - H44 > L44 - L43) * (H43 > H44) + .9 * ((H44 - H45) * (H44 - H45 > L45 - L44) * (H44 > H45) + .9 * ((H45 - H46) * (H45 - H46 > L46 - L45) * (H45 > H46) + .9 * ((H46 - H47) * (H46 - H47 > L47 - L46) * (H46 > H47) + .9 * ((H47 - H48) * (H47 - H48 > L48 - L47) * (H47 > H48) + .9 * ((H48 - H49) * (H48 - H49 > L49 - L48) * (H48 > H49) + .9 * ((H49 - H50) * (H49 - H50 > L50 - L49) * (H49 > H50) + .9 * ((H50 - H51) * (H50 - H51 > L51 - L50) * (H50 > H51) + .9 * ((H51 - H52) * (H51 - H52 > L52 - L51) * (H51 > H52) + .9 * ((H52 - H53) * (H52 - H53 > L53 - L52) * (H52 > H53) + .9 * ((H53 - H54) * (H53 - H54 > L54 - L53) * (H53 > H54) + .9 * ((H54 - H55) * (H54 - H55 > L55 - L54) * (H54 > H55) + .9 * ((H55 - H56) * (H55 - H56 > L56 - L55) * (H55 > H56) + .9 * ((H56 - H57) * (H56 - H57 > L57 - L56) * (H56 > H57) + .9 * ((H57 - H58) * (H57 - H58 > L58 - L57) * (H57 > H58) + .9 * ((H58 - H59) * (H58 - H59 > L59 - L58) * (H58 > H59) + .9 * ((H59 - H60) * (H59 - H60 > L60 - L59) * (H59 > H60) + .9 * ((H60 - H61) * (H60 - H61 > L61 - L60) * (H60 > H61) + .9 * ((H61 - H62) * (H61 - H62 > L62 - L61) * (H61 > H62) + .9 * ((H62 - H63) * (H62 - H63 > L63 - L62) * (H62 > H63) + .9 * ((H63 - H64) * (H63 - H64 > L64 - L63) * (H63 > H64) + .9 * ((H64 - H65) * (H64 - H65 > L65 - L64) * (H64 > H65) + .9 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (XAVGH19 - XAVGL19 + .100095591785708 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + .9 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + .9 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + .9 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + .9 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + .9 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + .9 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + .9 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + .9 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + .9 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + .9 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + .9 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + .9 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + .9 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + .9 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + .9 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + .9 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + .9 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + .9 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + .9 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + .9 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + .9 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + .9 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + .9 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + .9 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + .9 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + .9 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + .9 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + .9 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + .9 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + .9 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + .9 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + .9 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + .9 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + .9 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + .9 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + .9 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + .9 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + .9 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + .9 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + .9 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + .9 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + .9 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + .9 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + .9 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + .9 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + .9 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + .9 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + .9 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + .9 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + .9 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + .9 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + .9 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + .9 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + .9 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + .9 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + .9 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + .9 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + .9 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + .9 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + .9 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + .9 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + .9 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + .9 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + .9 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + .9 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
10-Period -DI:
10.0095591785708 * ((L1 - L) * (H - H1 < L1 - L) * (L < L1) + .9 * ((L2 - L1) * (H1 - H2 < L2 - L1) * (L1 < L2) + .9 * ((L3 - L2) * (H2 - H3 < L3 - L2) * (L2 < L3) + .9 * ((L4 - L3) * (H3 - H4 < L4 - L3) * (L3 < L4) + .9 * ((L5 - L4) * (H4 - H5 < L5 - L4) * (L4 < L5) + .9 * ((L6 - L5) * (H5 - H6 < L6 - L5) * (L5 < L6) + .9 * ((L7 - L6) * (H6 - H7 < L7 - L6) * (L6 < L7) + .9 * ((L8 - L7) * (H7 - H8 < L8 - L7) * (L7 < L8) + .9 * ((L9 - L8) * (H8 - H9 < L9 - L8) * (L8 < L9) + .9 * ((L10 - L9) * (H9 - H10 < L10 - L9) * (L9 < L10) + .9 * ((L11 - L10) * (H10 - H11 < L11 - L10) * (L10 < L11) + .9 * ((L12 - L11) * (H11 - H12 < L12 - L11) * (L11 < L12) + .9 * ((L13 - L12) * (H12 - H13 < L13 - L12) * (L12 < L13) + .9 * ((L14 - L13) * (H13 - H14 < L14 - L13) * (L13 < L14) + .9 * ((L15 - L14) * (H14 - H15 < L15 - L14) * (L14 < L15) + .9 * ((L16 - L15) * (H15 - H16 < L16 - L15) * (L15 < L16) + .9 * ((L17 - L16) * (H16 - H17 < L17 - L16) * (L16 < L17) + .9 * ((L18 - L17) * (H17 - H18 < L18 - L17) * (L17 < L18) + .9 * ((L19 - L18) * (H18 - H19 < L19 - L18) * (L18 < L19) + .9 * ((L20 - L19) * (H19 - H20 < L20 - L19) * (L19 < L20) + .9 * ((L21 - L20) * (H20 - H21 < L21 - L20) * (L20 < L21) + .9 * ((L22 - L21) * (H21 - H22 < L22 - L21) * (L21 < L22) + .9 * ((L23 - L22) * (H22 - H23 < L23 - L22) * (L22 < L23) + .9 * ((L24 - L23) * (H23 - H24 < L24 - L23) * (L23 < L24) + .9 * ((L25 - L24) * (H24 - H25 < L25 - L24) * (L24 < L25) + .9 * ((L26 - L25) * (H25 - H26 < L26 - L25) * (L25 < L26) + .9 * ((L27 - L26) * (H26 - H27 < L27 - L26) * (L26 < L27) + .9 * ((L28 - L27) * (H27 - H28 < L28 - L27) * (L27 < L28) + .9 * ((L29 - L28) * (H28 - H29 < L29 - L28) * (L28 < L29) + .9 * ((L30 - L29) * (H29 - H30 < L30 - L29) * (L29 < L30) + .9 * ((L31 - L30) * (H30 - H31 < L31 - L30) * (L30 < L31) + .9 * ((L32 - L31) * (H31 - H32 < L32 - L31) * (L31 < L32) + .9 * ((L33 - L32) * (H32 - H33 < L33 - L32) * (L32 < L33) + .9 * ((L34 - L33) * (H33 - H34 < L34 - L33) * (L33 < L34) + .9 * ((L35 - L34) * (H34 - H35 < L35 - L34) * (L34 < L35) + .9 * ((L36 - L35) * (H35 - H36 < L36 - L35) * (L35 < L36) + .9 * ((L37 - L36) * (H36 - H37 < L37 - L36) * (L36 < L37) + .9 * ((L38 - L37) * (H37 - H38 < L38 - L37) * (L37 < L38) + .9 * ((L39 - L38) * (H38 - H39 < L39 - L38) * (L38 < L39) + .9 * ((L40 - L39) * (H39 - H40 < L40 - L39) * (L39 < L40) + .9 * ((L41 - L40) * (H40 - H41 < L41 - L40) * (L40 < L41) + .9 * ((L42 - L41) * (H41 - H42 < L42 - L41) * (L41 < L42) + .9 * ((L43 - L42) * (H42 - H43 < L43 - L42) * (L42 < L43) + .9 * ((L44 - L43) * (H43 - H44 < L44 - L43) * (L43 < L44) + .9 * ((L45 - L44) * (H44 - H45 < L45 - L44) * (L44 < L45) + .9 * ((L46 - L45) * (H45 - H46 < L46 - L45) * (L45 < L46) + .9 * ((L47 - L46) * (H46 - H47 < L47 - L46) * (L46 < L47) + .9 * ((L48 - L47) * (H47 - H48 < L48 - L47) * (L47 < L48) + .9 * ((L49 - L48) * (H48 - H49 < L49 - L48) * (L48 < L49) + .9 * ((L50 - L49) * (H49 - H50 < L50 - L49) * (L49 < L50) + .9 * ((L51 - L50) * (H50 - H51 < L51 - L50) * (L50 < L51) + .9 * ((L52 - L51) * (H51 - H52 < L52 - L51) * (L51 < L52) + .9 * ((L53 - L52) * (H52 - H53 < L53 - L52) * (L52 < L53) + .9 * ((L54 - L53) * (H53 - H54 < L54 - L53) * (L53 < L54) + .9 * ((L55 - L54) * (H54 - H55 < L55 - L54) * (L54 < L55) + .9 * ((L56 - L55) * (H55 - H56 < L56 - L55) * (L55 < L56) + .9 * ((L57 - L56) * (H56 - H57 < L57 - L56) * (L56 < L57) + .9 * ((L58 - L57) * (H57 - H58 < L58 - L57) * (L57 < L58) + .9 * ((L59 - L58) * (H58 - H59 < L59 - L58) * (L58 < L59) + .9 * ((L60 - L59) * (H59 - H60 < L60 - L59) * (L59 < L60) + .9 * ((L61 - L60) * (H60 - H61 < L61 - L60) * (L60 < L61) + .9 * ((L62 - L61) * (H61 - H62 < L62 - L61) * (L61 < L62) + .9 * ((L63 - L62) * (H62 - H63 < L63 - L62) * (L62 < L63) + .9 * ((L64 - L63) * (H63 - H64 < L64 - L63) * (L63 < L64) + .9 * ((L65 - L64) * (H64 - H65 < L65 - L64) * (L64 < L65) + .9 * ((L66 - L65) * (H65 - H66 < L66 - L65) * (L65 < L66))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (XAVGH19 - XAVGL19 + .100095591785708 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + .9 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + .9 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + .9 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + .9 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + .9 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + .9 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + .9 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + .9 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + .9 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + .9 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + .9 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + .9 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + .9 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + .9 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + .9 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + .9 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + .9 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + .9 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + .9 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + .9 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + .9 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + .9 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + .9 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + .9 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + .9 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + .9 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + .9 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + .9 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + .9 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + .9 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + .9 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + .9 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + .9 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + .9 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + .9 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + .9 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + .9 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + .9 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + .9 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + .9 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + .9 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + .9 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + .9 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + .9 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + .9 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + .9 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + .9 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + .9 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + .9 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + .9 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + .9 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + .9 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + .9 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + .9 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + .9 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + .9 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + .9 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + .9 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + .9 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + .9 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + .9 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + .9 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + .9 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + .9 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + .9 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
Bruce - your hard work is very much appreciated, and I'll see if this works for me.
Thanks Again
Winnie
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 5/17/2006
Posts: 493
|
Bruce,
when I plug the above into a custom true 10 period +di and -di, i get an error.
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
georgematus,
The ADX +DI -DI Crossover PCF is a math PCF and can't be used in a Custom Percent True Indicator, only Boolean PCFs can be used in a Percent True Indicator.
Also, a custom indicator this size will slooooow your calculations considerably.
Hope this helps
Winnie
|
|
Registered User
Joined: 10/7/2004
Posts: 51
|
QUOTE (Bruce_L) You're welcome.
Hi, Bruce
Thank you very much for your great jobs.
How to write PCFs for DX>+DI, DX>-DI, DX turn up and DX turn down?
Thanks in advance.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Chaser,
The DX period would need to be specified for these formulas to be written. The DX Line is what would be shown in TeleChart's ADX Indicator when the Avg Period is 1 and Plot DI Lines is unchecked. For the turn up, are you looking for the current ROC of the DX to be positive and the previous ROC of the DX to be negative, or something else? You may wish to review the following:
PCF for Wilder's Directional Movement DMI-crossovers
PCF for Wilder's DX, and/or a CI for Wilder's ADX
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 51
|
Hi, Bruce,
Thank for the reply, I think I misled you, I want to write the Pcfs for the ADX value(setting 10,10), you can see the chart above from Winnie's sample "SYY", the yellow line.
Thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Chaser,
Personal Criteria Formulas for ADX are too long and slow to be practical.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
QUOTE (Winnie) I’m very interested to understand and write PCFs for each line, like to be able to do the following.
d. Net Change
Still interested in the following PCFs, I've looked at them but feel better with your help:
ADX10,10 +DI : Net Change 5 Days
ADX10,10 -DI : Net Change 5 Days
Thanks
Winnie
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Winnie) ADX10,10 +DI : Net Change 5 Days
10.0095591785708 * ((H - H1) * (H - H1 > L1 - L) * (H > H1) + .9 * ((H1 - H2) * (H1 - H2 > L2 - L1) * (H1 > H2) + .9 * ((H2 - H3) * (H2 - H3 > L3 - L2) * (H2 > H3) + .9 * ((H3 - H4) * (H3 - H4 > L4 - L3) * (H3 > H4) + .9 * ((H4 - H5) * (H4 - H5 > L5 - L4) * (H4 > H5) + .9 * ((H5 - H6) * (H5 - H6 > L6 - L5) * (H5 > H6) + .9 * ((H6 - H7) * (H6 - H7 > L7 - L6) * (H6 > H7) + .9 * ((H7 - H8) * (H7 - H8 > L8 - L7) * (H7 > H8) + .9 * ((H8 - H9) * (H8 - H9 > L9 - L8) * (H8 > H9) + .9 * ((H9 - H10) * (H9 - H10 > L10 - L9) * (H9 > H10) + .9 * ((H10 - H11) * (H10 - H11 > L11 - L10) * (H10 > H11) + .9 * ((H11 - H12) * (H11 - H12 > L12 - L11) * (H11 > H12) + .9 * ((H12 - H13) * (H12 - H13 > L13 - L12) * (H12 > H13) + .9 * ((H13 - H14) * (H13 - H14 > L14 - L13) * (H13 > H14) + .9 * ((H14 - H15) * (H14 - H15 > L15 - L14) * (H14 > H15) + .9 * ((H15 - H16) * (H15 - H16 > L16 - L15) * (H15 > H16) + .9 * ((H16 - H17) * (H16 - H17 > L17 - L16) * (H16 > H17) + .9 * ((H17 - H18) * (H17 - H18 > L18 - L17) * (H17 > H18) + .9 * ((H18 - H19) * (H18 - H19 > L19 - L18) * (H18 > H19) + .9 * ((H19 - H20) * (H19 - H20 > L20 - L19) * (H19 > H20) + .9 * ((H20 - H21) * (H20 - H21 > L21 - L20) * (H20 > H21) + .9 * ((H21 - H22) * (H21 - H22 > L22 - L21) * (H21 > H22) + .9 * ((H22 - H23) * (H22 - H23 > L23 - L22) * (H22 > H23) + .9 * ((H23 - H24) * (H23 - H24 > L24 - L23) * (H23 > H24) + .9 * ((H24 - H25) * (H24 - H25 > L25 - L24) * (H24 > H25) + .9 * ((H25 - H26) * (H25 - H26 > L26 - L25) * (H25 > H26) + .9 * ((H26 - H27) * (H26 - H27 > L27 - L26) * (H26 > H27) + .9 * ((H27 - H28) * (H27 - H28 > L28 - L27) * (H27 > H28) + .9 * ((H28 - H29) * (H28 - H29 > L29 - L28) * (H28 > H29) + .9 * ((H29 - H30) * (H29 - H30 > L30 - L29) * (H29 > H30) + .9 * ((H30 - H31) * (H30 - H31 > L31 - L30) * (H30 > H31) + .9 * ((H31 - H32) * (H31 - H32 > L32 - L31) * (H31 > H32) + .9 * ((H32 - H33) * (H32 - H33 > L33 - L32) * (H32 > H33) + .9 * ((H33 - H34) * (H33 - H34 > L34 - L33) * (H33 > H34) + .9 * ((H34 - H35) * (H34 - H35 > L35 - L34) * (H34 > H35) + .9 * ((H35 - H36) * (H35 - H36 > L36 - L35) * (H35 > H36) + .9 * ((H36 - H37) * (H36 - H37 > L37 - L36) * (H36 > H37) + .9 * ((H37 - H38) * (H37 - H38 > L38 - L37) * (H37 > H38) + .9 * ((H38 - H39) * (H38 - H39 > L39 - L38) * (H38 > H39) + .9 * ((H39 - H40) * (H39 - H40 > L40 - L39) * (H39 > H40) + .9 * ((H40 - H41) * (H40 - H41 > L41 - L40) * (H40 > H41) + .9 * ((H41 - H42) * (H41 - H42 > L42 - L41) * (H41 > H42) + .9 * ((H42 - H43) * (H42 - H43 > L43 - L42) * (H42 > H43) + .9 * ((H43 - H44) * (H43 - H44 > L44 - L43) * (H43 > H44) + .9 * ((H44 - H45) * (H44 - H45 > L45 - L44) * (H44 > H45) + .9 * ((H45 - H46) * (H45 - H46 > L46 - L45) * (H45 > H46) + .9 * ((H46 - H47) * (H46 - H47 > L47 - L46) * (H46 > H47) + .9 * ((H47 - H48) * (H47 - H48 > L48 - L47) * (H47 > H48) + .9 * ((H48 - H49) * (H48 - H49 > L49 - L48) * (H48 > H49) + .9 * ((H49 - H50) * (H49 - H50 > L50 - L49) * (H49 > H50) + .9 * ((H50 - H51) * (H50 - H51 > L51 - L50) * (H50 > H51) + .9 * ((H51 - H52) * (H51 - H52 > L52 - L51) * (H51 > H52) + .9 * ((H52 - H53) * (H52 - H53 > L53 - L52) * (H52 > H53) + .9 * ((H53 - H54) * (H53 - H54 > L54 - L53) * (H53 > H54) + .9 * ((H54 - H55) * (H54 - H55 > L55 - L54) * (H54 > H55) + .9 * ((H55 - H56) * (H55 - H56 > L56 - L55) * (H55 > H56) + .9 * ((H56 - H57) * (H56 - H57 > L57 - L56) * (H56 > H57) + .9 * ((H57 - H58) * (H57 - H58 > L58 - L57) * (H57 > H58) + .9 * ((H58 - H59) * (H58 - H59 > L59 - L58) * (H58 > H59) + .9 * ((H59 - H60) * (H59 - H60 > L60 - L59) * (H59 > H60) + .9 * ((H60 - H61) * (H60 - H61 > L61 - L60) * (H60 > H61) + .9 * ((H61 - H62) * (H61 - H62 > L62 - L61) * (H61 > H62) + .9 * ((H62 - H63) * (H62 - H63 > L63 - L62) * (H62 > H63) + .9 * ((H63 - H64) * (H63 - H64 > L64 - L63) * (H63 > H64) + .9 * ((H64 - H65) * (H64 - H65 > L65 - L64) * (H64 > H65) + .9 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (XAVGH19 - XAVGL19 + .100095591785708 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + .9 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + .9 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + .9 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + .9 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + .9 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + .9 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + .9 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + .9 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + .9 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + .9 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + .9 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + .9 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + .9 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + .9 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + .9 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + .9 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + .9 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + .9 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + .9 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + .9 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + .9 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + .9 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + .9 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + .9 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + .9 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + .9 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + .9 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + .9 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + .9 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + .9 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + .9 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + .9 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + .9 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + .9 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + .9 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + .9 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + .9 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + .9 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + .9 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + .9 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + .9 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + .9 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + .9 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + .9 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + .9 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + .9 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + .9 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + .9 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + .9 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + .9 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + .9 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + .9 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + .9 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + .9 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + .9 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + .9 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + .9 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + .9 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + .9 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + .9 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + .9 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + .9 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + .9 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + .9 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + .9 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 10.0095591785708 * ((H5 - H6) * (H5 - H6 > L6 - L5) * (H5 > H6) + .9 * ((H6 - H7) * (H6 - H7 > L7 - L6) * (H6 > H7) + .9 * ((H7 - H8) * (H7 - H8 > L8 - L7) * (H7 > H8) + .9 * ((H8 - H9) * (H8 - H9 > L9 - L8) * (H8 > H9) + .9 * ((H9 - H10) * (H9 - H10 > L10 - L9) * (H9 > H10) + .9 * ((H10 - H11) * (H10 - H11 > L11 - L10) * (H10 > H11) + .9 * ((H11 - H12) * (H11 - H12 > L12 - L11) * (H11 > H12) + .9 * ((H12 - H13) * (H12 - H13 > L13 - L12) * (H12 > H13) + .9 * ((H13 - H14) * (H13 - H14 > L14 - L13) * (H13 > H14) + .9 * ((H14 - H15) * (H14 - H15 > L15 - L14) * (H14 > H15) + .9 * ((H15 - H16) * (H15 - H16 > L16 - L15) * (H15 > H16) + .9 * ((H16 - H17) * (H16 - H17 > L17 - L16) * (H16 > H17) + .9 * ((H17 - H18) * (H17 - H18 > L18 - L17) * (H17 > H18) + .9 * ((H18 - H19) * (H18 - H19 > L19 - L18) * (H18 > H19) + .9 * ((H19 - H20) * (H19 - H20 > L20 - L19) * (H19 > H20) + .9 * ((H20 - H21) * (H20 - H21 > L21 - L20) * (H20 > H21) + .9 * ((H21 - H22) * (H21 - H22 > L22 - L21) * (H21 > H22) + .9 * ((H22 - H23) * (H22 - H23 > L23 - L22) * (H22 > H23) + .9 * ((H23 - H24) * (H23 - H24 > L24 - L23) * (H23 > H24) + .9 * ((H24 - H25) * (H24 - H25 > L25 - L24) * (H24 > H25) + .9 * ((H25 - H26) * (H25 - H26 > L26 - L25) * (H25 > H26) + .9 * ((H26 - H27) * (H26 - H27 > L27 - L26) * (H26 > H27) + .9 * ((H27 - H28) * (H27 - H28 > L28 - L27) * (H27 > H28) + .9 * ((H28 - H29) * (H28 - H29 > L29 - L28) * (H28 > H29) + .9 * ((H29 - H30) * (H29 - H30 > L30 - L29) * (H29 > H30) + .9 * ((H30 - H31) * (H30 - H31 > L31 - L30) * (H30 > H31) + .9 * ((H31 - H32) * (H31 - H32 > L32 - L31) * (H31 > H32) + .9 * ((H32 - H33) * (H32 - H33 > L33 - L32) * (H32 > H33) + .9 * ((H33 - H34) * (H33 - H34 > L34 - L33) * (H33 > H34) + .9 * ((H34 - H35) * (H34 - H35 > L35 - L34) * (H34 > H35) + .9 * ((H35 - H36) * (H35 - H36 > L36 - L35) * (H35 > H36) + .9 * ((H36 - H37) * (H36 - H37 > L37 - L36) * (H36 > H37) + .9 * ((H37 - H38) * (H37 - H38 > L38 - L37) * (H37 > H38) + .9 * ((H38 - H39) * (H38 - H39 > L39 - L38) * (H38 > H39) + .9 * ((H39 - H40) * (H39 - H40 > L40 - L39) * (H39 > H40) + .9 * ((H40 - H41) * (H40 - H41 > L41 - L40) * (H40 > H41) + .9 * ((H41 - H42) * (H41 - H42 > L42 - L41) * (H41 > H42) + .9 * ((H42 - H43) * (H42 - H43 > L43 - L42) * (H42 > H43) + .9 * ((H43 - H44) * (H43 - H44 > L44 - L43) * (H43 > H44) + .9 * ((H44 - H45) * (H44 - H45 > L45 - L44) * (H44 > H45) + .9 * ((H45 - H46) * (H45 - H46 > L46 - L45) * (H45 > H46) + .9 * ((H46 - H47) * (H46 - H47 > L47 - L46) * (H46 > H47) + .9 * ((H47 - H48) * (H47 - H48 > L48 - L47) * (H47 > H48) + .9 * ((H48 - H49) * (H48 - H49 > L49 - L48) * (H48 > H49) + .9 * ((H49 - H50) * (H49 - H50 > L50 - L49) * (H49 > H50) + .9 * ((H50 - H51) * (H50 - H51 > L51 - L50) * (H50 > H51) + .9 * ((H51 - H52) * (H51 - H52 > L52 - L51) * (H51 > H52) + .9 * ((H52 - H53) * (H52 - H53 > L53 - L52) * (H52 > H53) + .9 * ((H53 - H54) * (H53 - H54 > L54 - L53) * (H53 > H54) + .9 * ((H54 - H55) * (H54 - H55 > L55 - L54) * (H54 > H55) + .9 * ((H55 - H56) * (H55 - H56 > L56 - L55) * (H55 > H56) + .9 * ((H56 - H57) * (H56 - H57 > L57 - L56) * (H56 > H57) + .9 * ((H57 - H58) * (H57 - H58 > L58 - L57) * (H57 > H58) + .9 * ((H58 - H59) * (H58 - H59 > L59 - L58) * (H58 > H59) + .9 * ((H59 - H60) * (H59 - H60 > L60 - L59) * (H59 > H60) + .9 * ((H60 - H61) * (H60 - H61 > L61 - L60) * (H60 > H61) + .9 * ((H61 - H62) * (H61 - H62 > L62 - L61) * (H61 > H62) + .9 * ((H62 - H63) * (H62 - H63 > L63 - L62) * (H62 > H63) + .9 * ((H63 - H64) * (H63 - H64 > L64 - L63) * (H63 > H64) + .9 * ((H64 - H65) * (H64 - H65 > L65 - L64) * (H64 > H65) + .9 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66) + .9 * ((H66 - H67) * (H66 - H67 > L67 - L66) * (H66 > H67) + .9 * ((H67 - H68) * (H67 - H68 > L68 - L67) * (H67 > H68) + .9 * ((H68 - H69) * (H68 - H69 > L69 - L68) * (H68 > H69) + .9 * ((H69 - H70) * (H69 - H70 > L70 - L69) * (H69 > H70) + .9 * ((H70 - H71) * (H70 - H71 > L71 - L70) * (H70 > H71))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (XAVGH19.5 - XAVGL19.5 + 0.100095591785708 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + .9 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + .9 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + .9 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + .9 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + .9 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + .9 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + .9 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + .9 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + .9 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + .9 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + .9 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + .9 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + .9 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + .9 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + .9 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + .9 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + .9 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + .9 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + .9 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + .9 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + .9 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + .9 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + .9 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + .9 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + .9 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + .9 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + .9 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + .9 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + .9 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + .9 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + .9 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + .9 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + .9 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + .9 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + .9 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + .9 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + .9 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + .9 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + .9 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + .9 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + .9 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + .9 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + .9 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + .9 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + .9 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + .9 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + .9 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + .9 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + .9 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + .9 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + .9 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + .9 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + .9 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + .9 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + .9 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + .9 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + .9 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + .9 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + .9 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + .9 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + .9 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66) + .9 * ((H67 < C68) * (H67 - C68) + (C68 < L67) * (C68 - L67) + .9 * ((H68 < C69) * (H68 - C69) + (C69 < L68) * (C69 - L68) + .9 * ((H69 < C70) * (H69 - C70) + (C70 < L69) * (C70 - L69) + .9 * ((H70 < C71) * (H70 - C71) + (C71 < L70) * (C71 - L70))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
QUOTE (Winnie) ADX10,10 -DI : Net Change 5 Days
10.0095591785708 * ((H - H1) * (H - H1 > L1 - L) * (H > H1) + .9 * ((H1 - H2) * (H1 - H2 > L2 - L1) * (H1 > H2) + .9 * ((H2 - H3) * (H2 - H3 > L3 - L2) * (H2 > H3) + .9 * ((H3 - H4) * (H3 - H4 > L4 - L3) * (H3 > H4) + .9 * ((H4 - H5) * (H4 - H5 > L5 - L4) * (H4 > H5) + .9 * ((H5 - H6) * (H5 - H6 > L6 - L5) * (H5 > H6) + .9 * ((H6 - H7) * (H6 - H7 > L7 - L6) * (H6 > H7) + .9 * ((H7 - H8) * (H7 - H8 > L8 - L7) * (H7 > H8) + .9 * ((H8 - H9) * (H8 - H9 > L9 - L8) * (H8 > H9) + .9 * ((H9 - H10) * (H9 - H10 > L10 - L9) * (H9 > H10) + .9 * ((H10 - H11) * (H10 - H11 > L11 - L10) * (H10 > H11) + .9 * ((H11 - H12) * (H11 - H12 > L12 - L11) * (H11 > H12) + .9 * ((H12 - H13) * (H12 - H13 > L13 - L12) * (H12 > H13) + .9 * ((H13 - H14) * (H13 - H14 > L14 - L13) * (H13 > H14) + .9 * ((H14 - H15) * (H14 - H15 > L15 - L14) * (H14 > H15) + .9 * ((H15 - H16) * (H15 - H16 > L16 - L15) * (H15 > H16) + .9 * ((H16 - H17) * (H16 - H17 > L17 - L16) * (H16 > H17) + .9 * ((H17 - H18) * (H17 - H18 > L18 - L17) * (H17 > H18) + .9 * ((H18 - H19) * (H18 - H19 > L19 - L18) * (H18 > H19) + .9 * ((H19 - H20) * (H19 - H20 > L20 - L19) * (H19 > H20) + .9 * ((H20 - H21) * (H20 - H21 > L21 - L20) * (H20 > H21) + .9 * ((H21 - H22) * (H21 - H22 > L22 - L21) * (H21 > H22) + .9 * ((H22 - H23) * (H22 - H23 > L23 - L22) * (H22 > H23) + .9 * ((H23 - H24) * (H23 - H24 > L24 - L23) * (H23 > H24) + .9 * ((H24 - H25) * (H24 - H25 > L25 - L24) * (H24 > H25) + .9 * ((H25 - H26) * (H25 - H26 > L26 - L25) * (H25 > H26) + .9 * ((H26 - H27) * (H26 - H27 > L27 - L26) * (H26 > H27) + .9 * ((H27 - H28) * (H27 - H28 > L28 - L27) * (H27 > H28) + .9 * ((H28 - H29) * (H28 - H29 > L29 - L28) * (H28 > H29) + .9 * ((H29 - H30) * (H29 - H30 > L30 - L29) * (H29 > H30) + .9 * ((H30 - H31) * (H30 - H31 > L31 - L30) * (H30 > H31) + .9 * ((H31 - H32) * (H31 - H32 > L32 - L31) * (H31 > H32) + .9 * ((H32 - H33) * (H32 - H33 > L33 - L32) * (H32 > H33) + .9 * ((H33 - H34) * (H33 - H34 > L34 - L33) * (H33 > H34) + .9 * ((H34 - H35) * (H34 - H35 > L35 - L34) * (H34 > H35) + .9 * ((H35 - H36) * (H35 - H36 > L36 - L35) * (H35 > H36) + .9 * ((H36 - H37) * (H36 - H37 > L37 - L36) * (H36 > H37) + .9 * ((H37 - H38) * (H37 - H38 > L38 - L37) * (H37 > H38) + .9 * ((H38 - H39) * (H38 - H39 > L39 - L38) * (H38 > H39) + .9 * ((H39 - H40) * (H39 - H40 > L40 - L39) * (H39 > H40) + .9 * ((H40 - H41) * (H40 - H41 > L41 - L40) * (H40 > H41) + .9 * ((H41 - H42) * (H41 - H42 > L42 - L41) * (H41 > H42) + .9 * ((H42 - H43) * (H42 - H43 > L43 - L42) * (H42 > H43) + .9 * ((H43 - H44) * (H43 - H44 > L44 - L43) * (H43 > H44) + .9 * ((H44 - H45) * (H44 - H45 > L45 - L44) * (H44 > H45) + .9 * ((H45 - H46) * (H45 - H46 > L46 - L45) * (H45 > H46) + .9 * ((H46 - H47) * (H46 - H47 > L47 - L46) * (H46 > H47) + .9 * ((H47 - H48) * (H47 - H48 > L48 - L47) * (H47 > H48) + .9 * ((H48 - H49) * (H48 - H49 > L49 - L48) * (H48 > H49) + .9 * ((H49 - H50) * (H49 - H50 > L50 - L49) * (H49 > H50) + .9 * ((H50 - H51) * (H50 - H51 > L51 - L50) * (H50 > H51) + .9 * ((H51 - H52) * (H51 - H52 > L52 - L51) * (H51 > H52) + .9 * ((H52 - H53) * (H52 - H53 > L53 - L52) * (H52 > H53) + .9 * ((H53 - H54) * (H53 - H54 > L54 - L53) * (H53 > H54) + .9 * ((H54 - H55) * (H54 - H55 > L55 - L54) * (H54 > H55) + .9 * ((H55 - H56) * (H55 - H56 > L56 - L55) * (H55 > H56) + .9 * ((H56 - H57) * (H56 - H57 > L57 - L56) * (H56 > H57) + .9 * ((H57 - H58) * (H57 - H58 > L58 - L57) * (H57 > H58) + .9 * ((H58 - H59) * (H58 - H59 > L59 - L58) * (H58 > H59) + .9 * ((H59 - H60) * (H59 - H60 > L60 - L59) * (H59 > H60) + .9 * ((H60 - H61) * (H60 - H61 > L61 - L60) * (H60 > H61) + .9 * ((H61 - H62) * (H61 - H62 > L62 - L61) * (H61 > H62) + .9 * ((H62 - H63) * (H62 - H63 > L63 - L62) * (H62 > H63) + .9 * ((H63 - H64) * (H63 - H64 > L64 - L63) * (H63 > H64) + .9 * ((H64 - H65) * (H64 - H65 > L65 - L64) * (H64 > H65) + .9 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (XAVGH19 - XAVGL19 + .100095591785708 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + .9 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + .9 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + .9 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + .9 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + .9 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + .9 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + .9 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + .9 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + .9 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + .9 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + .9 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + .9 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + .9 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + .9 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + .9 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + .9 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + .9 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + .9 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + .9 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + .9 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + .9 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + .9 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + .9 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + .9 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + .9 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + .9 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + .9 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + .9 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + .9 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + .9 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + .9 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + .9 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + .9 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + .9 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + .9 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + .9 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + .9 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + .9 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + .9 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + .9 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + .9 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + .9 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + .9 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + .9 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + .9 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + .9 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + .9 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + .9 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + .9 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + .9 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + .9 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + .9 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + .9 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + .9 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + .9 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + .9 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + .9 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + .9 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + .9 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + .9 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + .9 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + .9 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + .9 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + .9 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + .9 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 10.0095591785708 * ((L6 - L5) * (H5 - H6 < L6 - L5) * (L5 < L6) + .9 * ((L7 - L6) * (H6 - H7 < L7 - L6) * (L6 < L7) + .9 * ((L8 - L7) * (H7 - H8 < L8 - L7) * (L7 < L8) + .9 * ((L9 - L8) * (H8 - H9 < L9 - L8) * (L8 < L9) + .9 * ((L10 - L9) * (H9 - H10 < L10 - L9) * (L9 < L10) + .9 * ((L11 - L10) * (H10 - H11 < L11 - L10) * (L10 < L11) + .9 * ((L12 - L11) * (H11 - H12 < L12 - L11) * (L11 < L12) + .9 * ((L13 - L12) * (H12 - H13 < L13 - L12) * (L12 < L13) + .9 * ((L14 - L13) * (H13 - H14 < L14 - L13) * (L13 < L14) + .9 * ((L15 - L14) * (H14 - H15 < L15 - L14) * (L14 < L15) + .9 * ((L16 - L15) * (H15 - H16 < L16 - L15) * (L15 < L16) + .9 * ((L17 - L16) * (H16 - H17 < L17 - L16) * (L16 < L17) + .9 * ((L18 - L17) * (H17 - H18 < L18 - L17) * (L17 < L18) + .9 * ((L19 - L18) * (H18 - H19 < L19 - L18) * (L18 < L19) + .9 * ((L20 - L19) * (H19 - H20 < L20 - L19) * (L19 < L20) + .9 * ((L21 - L20) * (H20 - H21 < L21 - L20) * (L20 < L21) + .9 * ((L22 - L21) * (H21 - H22 < L22 - L21) * (L21 < L22) + .9 * ((L23 - L22) * (H22 - H23 < L23 - L22) * (L22 < L23) + .9 * ((L24 - L23) * (H23 - H24 < L24 - L23) * (L23 < L24) + .9 * ((L25 - L24) * (H24 - H25 < L25 - L24) * (L24 < L25) + .9 * ((L26 - L25) * (H25 - H26 < L26 - L25) * (L25 < L26) + .9 * ((L27 - L26) * (H26 - H27 < L27 - L26) * (L26 < L27) + .9 * ((L28 - L27) * (H27 - H28 < L28 - L27) * (L27 < L28) + .9 * ((L29 - L28) * (H28 - H29 < L29 - L28) * (L28 < L29) + .9 * ((L30 - L29) * (H29 - H30 < L30 - L29) * (L29 < L30) + .9 * ((L31 - L30) * (H30 - H31 < L31 - L30) * (L30 < L31) + .9 * ((L32 - L31) * (H31 - H32 < L32 - L31) * (L31 < L32) + .9 * ((L33 - L32) * (H32 - H33 < L33 - L32) * (L32 < L33) + .9 * ((L34 - L33) * (H33 - H34 < L34 - L33) * (L33 < L34) + .9 * ((L35 - L34) * (H34 - H35 < L35 - L34) * (L34 < L35) + .9 * ((L36 - L35) * (H35 - H36 < L36 - L35) * (L35 < L36) + .9 * ((L37 - L36) * (H36 - H37 < L37 - L36) * (L36 < L37) + .9 * ((L38 - L37) * (H37 - H38 < L38 - L37) * (L37 < L38) + .9 * ((L39 - L38) * (H38 - H39 < L39 - L38) * (L38 < L39) + .9 * ((L40 - L39) * (H39 - H40 < L40 - L39) * (L39 < L40) + .9 * ((L41 - L40) * (H40 - H41 < L41 - L40) * (L40 < L41) + .9 * ((L42 - L41) * (H41 - H42 < L42 - L41) * (L41 < L42) + .9 * ((L43 - L42) * (H42 - H43 < L43 - L42) * (L42 < L43) + .9 * ((L44 - L43) * (H43 - H44 < L44 - L43) * (L43 < L44) + .9 * ((L45 - L44) * (H44 - H45 < L45 - L44) * (L44 < L45) + .9 * ((L46 - L45) * (H45 - H46 < L46 - L45) * (L45 < L46) + .9 * ((L47 - L46) * (H46 - H47 < L47 - L46) * (L46 < L47) + .9 * ((L48 - L47) * (H47 - H48 < L48 - L47) * (L47 < L48) + .9 * ((L49 - L48) * (H48 - H49 < L49 - L48) * (L48 < L49) + .9 * ((L50 - L49) * (H49 - H50 < L50 - L49) * (L49 < L50) + .9 * ((L51 - L50) * (H50 - H51 < L51 - L50) * (L50 < L51) + .9 * ((L52 - L51) * (H51 - H52 < L52 - L51) * (L51 < L52) + .9 * ((L53 - L52) * (H52 - H53 < L53 - L52) * (L52 < L53) + .9 * ((L54 - L53) * (H53 - H54 < L54 - L53) * (L53 < L54) + .9 * ((L55 - L54) * (H54 - H55 < L55 - L54) * (L54 < L55) + .9 * ((L56 - L55) * (H55 - H56 < L56 - L55) * (L55 < L56) + .9 * ((L57 - L56) * (H56 - H57 < L57 - L56) * (L56 < L57) + .9 * ((L58 - L57) * (H57 - H58 < L58 - L57) * (L57 < L58) + .9 * ((L59 - L58) * (H58 - H59 < L59 - L58) * (L58 < L59) + .9 * ((L60 - L59) * (H59 - H60 < L60 - L59) * (L59 < L60) + .9 * ((L61 - L60) * (H60 - H61 < L61 - L60) * (L60 < L61) + .9 * ((L62 - L61) * (H61 - H62 < L62 - L61) * (L61 < L62) + .9 * ((L63 - L62) * (H62 - H63 < L63 - L62) * (L62 < L63) + .9 * ((L64 - L63) * (H63 - H64 < L64 - L63) * (L63 < L64) + .9 * ((L65 - L64) * (H64 - H65 < L65 - L64) * (L64 < L65) + .9 * ((L66 - L65) * (H65 - H66 < L66 - L65) * (L65 < L66) + .9 * ((L67 - L66) * (H66 - H67 < L67 - L66) * (L66 < L67) + .9 * ((L68 - L67) * (H67 - H68 < L68 - L67) * (L67 < L68) + .9 * ((L69 - L68) * (H68 - H69 < L69 - L68) * (L68 < L69) + .9 * ((L70 - L69) * (H69 - H70 < L70 - L69) * (L69 < L70) + .9 * ((L71 - L70) * (H70 - H71 < L71 - L70) * (L70 < L71))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (XAVGH19.5 - XAVGL19.5 + 0.100095591785708 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + .9 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + .9 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + .9 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + .9 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + .9 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + .9 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + .9 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + .9 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + .9 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + .9 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + .9 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + .9 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + .9 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + .9 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + .9 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + .9 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + .9 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + .9 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + .9 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + .9 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + .9 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + .9 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + .9 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + .9 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + .9 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + .9 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + .9 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + .9 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + .9 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + .9 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + .9 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + .9 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + .9 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + .9 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + .9 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + .9 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + .9 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + .9 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + .9 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + .9 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + .9 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + .9 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + .9 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + .9 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + .9 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + .9 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + .9 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + .9 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + .9 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + .9 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + .9 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + .9 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + .9 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + .9 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + .9 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + .9 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + .9 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + .9 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + .9 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + .9 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + .9 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66) + .9 * ((H67 < C68) * (H67 - C68) + (C68 < L67) * (C68 - L67) + .9 * ((H68 < C69) * (H68 - C69) + (C69 < L68) * (C69 - L68) + .9 * ((H69 < C70) * (H69 - C70) + (C70 < L69) * (C70 - L69) + .9 * ((H70 < C71) * (H70 - C71) + (C71 < L70) * (C71 - L70))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
Bruce,
Very much appreciate the PCF, have my order in for a super computer, now takes about 13 minutes to calculate total time for an update. Similar to watching the grass grow. :) Great work.
Thanks again
Winnie
|
|
|
Guest-1 |