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

PCFs for ADX's +DI and -DI Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
cwbwin
Posted : Friday, December 3, 2004 10:14:06 AM
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)
Craig_S
Posted : Friday, December 3, 2004 11:22:39 AM


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!
Craig_S
Posted : Friday, December 3, 2004 11:30:57 AM


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!
Tanstaafl
Posted : Saturday, December 11, 2004 2:36:44 AM
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

Winnie
Posted : Friday, September 15, 2006 3:21:55 PM
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
Craig_S
Posted : Friday, September 15, 2006 3:25:31 PM


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!
Winnie
Posted : Friday, September 15, 2006 3:34:39 PM
Registered User
Joined: 10/7/2004
Posts: 1,006
What about numbers 3-6

Thanks
Winnie
Bruce_L
Posted : Friday, September 15, 2006 4:03:54 PM


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
Winnie
Posted : Friday, September 15, 2006 4:41:58 PM
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
Bruce_L
Posted : Friday, September 15, 2006 5:01:20 PM


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
Winnie
Posted : Friday, September 15, 2006 5:11:50 PM
Registered User
Joined: 10/7/2004
Posts: 1,006
Great, got it.

Thanks
Winnie
Bruce_L
Posted : Friday, September 15, 2006 5:16:52 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Winnie
Posted : Saturday, September 16, 2006 6:07:34 PM
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

Winnie
Posted : Monday, September 18, 2006 8:57:17 AM
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
Bruce_L
Posted : Monday, September 18, 2006 9:30:52 AM


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
Tanstaafl
Posted : Monday, September 18, 2006 9:39:01 AM
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

Bruce_L
Posted : Monday, September 18, 2006 9:47:43 AM


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
Winnie
Posted : Monday, September 18, 2006 10:07:07 AM
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
Bruce_L
Posted : Tuesday, September 19, 2006 1:19:37 PM


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
Winnie
Posted : Wednesday, September 20, 2006 12:50:14 AM
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
Bruce_L
Posted : Wednesday, September 20, 2006 12:01:35 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
mktwizard123
Posted : Monday, September 25, 2006 11:38:18 PM
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.
Winnie
Posted : Tuesday, September 26, 2006 12:01:05 AM
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
xChaserx
Posted : Saturday, September 30, 2006 11:16:08 PM
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.
Bruce_L
Posted : Sunday, October 1, 2006 9:24:18 AM


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
xChaserx
Posted : Sunday, October 1, 2006 10:45:53 AM
Registered User
Joined: 10/7/2004
Posts: 51
QUOTE (Bruce_L)
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


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.
Bruce_L
Posted : Sunday, October 1, 2006 1:04:24 PM


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
Winnie
Posted : Thursday, November 2, 2006 6:08:33 PM
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
Bruce_L
Posted : Friday, November 3, 2006 10:32:24 AM


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
Winnie
Posted : Friday, November 3, 2006 10:44:30 PM
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
Users browsing this topic
Guest-1

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