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

Need a formula for 2 indicators Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
johnny2127
Posted : Tuesday, June 18, 2013 3:09:13 PM
Registered User
Joined: 6/18/2013
Posts: 7

I need 2 formulas to add 2 indicators to version 7.

The indicators are:

1) Directional Movement (+DI -DI), with a period of 15

2) Aroon Oscillator, with a period of 14

 

Thank you so much in advance for the help.

Bruce_L
Posted : Tuesday, June 18, 2013 3:52:15 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

A 15-Period +DI can be written as:

6.732837 * ((H - H1) * (H - H1 > L1 - L) * (H > H1) + 14 / 15 * ((H1 - H2) * (H1 - H2 > L2 - L1) * (H1 > H2) + 14 / 15 * ((H2 - H3) * (H2 - H3 > L3 - L2) * (H2 > H3) + 14 / 15 * ((H3 - H4) * (H3 - H4 > L4 - L3) * (H3 > H4) + 14 / 15 * ((H4 - H5) * (H4 - H5 > L5 - L4) * (H4 > H5) + 14 / 15 * ((H5 - H6) * (H5 - H6 > L6 - L5) * (H5 > H6) + 14 / 15 * ((H6 - H7) * (H6 - H7 > L7 - L6) * (H6 > H7) + 14 / 15 * ((H7 - H8) * (H7 - H8 > L8 - L7) * (H7 > H8) + 14 / 15 * ((H8 - H9) * (H8 - H9 > L9 - L8) * (H8 > H9) + 14 / 15 * ((H9 - H10) * (H9 - H10 > L10 - L9) * (H9 > H10) + 14 / 15 * ((H10 - H11) * (H10 - H11 > L11 - L10) * (H10 > H11) + 14 / 15 * ((H11 - H12) * (H11 - H12 > L12 - L11) * (H11 > H12) + 14 / 15 * ((H12 - H13) * (H12 - H13 > L13 - L12) * (H12 > H13) + 14 / 15 * ((H13 - H14) * (H13 - H14 > L14 - L13) * (H13 > H14) + 14 / 15 * ((H14 - H15) * (H14 - H15 > L15 - L14) * (H14 > H15) + 14 / 15 * ((H15 - H16) * (H15 - H16 > L16 - L15) * (H15 > H16) + 14 / 15 * ((H16 - H17) * (H16 - H17 > L17 - L16) * (H16 > H17) + 14 / 15 * ((H17 - H18) * (H17 - H18 > L18 - L17) * (H17 > H18) + 14 / 15 * ((H18 - H19) * (H18 - H19 > L19 - L18) * (H18 > H19) + 14 / 15 * ((H19 - H20) * (H19 - H20 > L20 - L19) * (H19 > H20) + 14 / 15 * ((H20 - H21) * (H20 - H21 > L21 - L20) * (H20 > H21) + 14 / 15 * ((H21 - H22) * (H21 - H22 > L22 - L21) * (H21 > H22) + 14 / 15 * ((H22 - H23) * (H22 - H23 > L23 - L22) * (H22 > H23) + 14 / 15 * ((H23 - H24) * (H23 - H24 > L24 - L23) * (H23 > H24) + 14 / 15 * ((H24 - H25) * (H24 - H25 > L25 - L24) * (H24 > H25) + 14 / 15 * ((H25 - H26) * (H25 - H26 > L26 - L25) * (H25 > H26) + 14 / 15 * ((H26 - H27) * (H26 - H27 > L27 - L26) * (H26 > H27) + 14 / 15 * ((H27 - H28) * (H27 - H28 > L28 - L27) * (H27 > H28) + 14 / 15 * ((H28 - H29) * (H28 - H29 > L29 - L28) * (H28 > H29) + 14 / 15 * ((H29 - H30) * (H29 - H30 > L30 - L29) * (H29 > H30) + 14 / 15 * ((H30 - H31) * (H30 - H31 > L31 - L30) * (H30 > H31) + 14 / 15 * ((H31 - H32) * (H31 - H32 > L32 - L31) * (H31 > H32) + 14 / 15 * ((H32 - H33) * (H32 - H33 > L33 - L32) * (H32 > H33) + 14 / 15 * ((H33 - H34) * (H33 - H34 > L34 - L33) * (H33 > H34) + 14 / 15 * ((H34 - H35) * (H34 - H35 > L35 - L34) * (H34 > H35) + 14 / 15 * ((H35 - H36) * (H35 - H36 > L36 - L35) * (H35 > H36) + 14 / 15 * ((H36 - H37) * (H36 - H37 > L37 - L36) * (H36 > H37) + 14 / 15 * ((H37 - H38) * (H37 - H38 > L38 - L37) * (H37 > H38) + 14 / 15 * ((H38 - H39) * (H38 - H39 > L39 - L38) * (H38 > H39) + 14 / 15 * ((H39 - H40) * (H39 - H40 > L40 - L39) * (H39 > H40) + 14 / 15 * ((H40 - H41) * (H40 - H41 > L41 - L40) * (H40 > H41) + 14 / 15 * ((H41 - H42) * (H41 - H42 > L42 - L41) * (H41 > H42) + 14 / 15 * ((H42 - H43) * (H42 - H43 > L43 - L42) * (H42 > H43) + 14 / 15 * ((H43 - H44) * (H43 - H44 > L44 - L43) * (H43 > H44) + 14 / 15 * ((H44 - H45) * (H44 - H45 > L45 - L44) * (H44 > H45) + 14 / 15 * ((H45 - H46) * (H45 - H46 > L46 - L45) * (H45 > H46) + 14 / 15 * ((H46 - H47) * (H46 - H47 > L47 - L46) * (H46 > H47) + 14 / 15 * ((H47 - H48) * (H47 - H48 > L48 - L47) * (H47 > H48) + 14 / 15 * ((H48 - H49) * (H48 - H49 > L49 - L48) * (H48 > H49) + 14 / 15 * ((H49 - H50) * (H49 - H50 > L50 - L49) * (H49 > H50) + 14 / 15 * ((H50 - H51) * (H50 - H51 > L51 - L50) * (H50 > H51) + 14 / 15 * ((H51 - H52) * (H51 - H52 > L52 - L51) * (H51 > H52) + 14 / 15 * ((H52 - H53) * (H52 - H53 > L53 - L52) * (H52 > H53) + 14 / 15 * ((H53 - H54) * (H53 - H54 > L54 - L53) * (H53 > H54) + 14 / 15 * ((H54 - H55) * (H54 - H55 > L55 - L54) * (H54 > H55) + 14 / 15 * ((H55 - H56) * (H55 - H56 > L56 - L55) * (H55 > H56) + 14 / 15 * ((H56 - H57) * (H56 - H57 > L57 - L56) * (H56 > H57) + 14 / 15 * ((H57 - H58) * (H57 - H58 > L58 - L57) * (H57 > H58) + 14 / 15 * ((H58 - H59) * (H58 - H59 > L59 - L58) * (H58 > H59) + 14 / 15 * ((H59 - H60) * (H59 - H60 > L60 - L59) * (H59 > H60) + 14 / 15 * ((H60 - H61) * (H60 - H61 > L61 - L60) * (H60 > H61) + 14 / 15 * ((H61 - H62) * (H61 - H62 > L62 - L61) * (H61 > H62) + 14 / 15 * ((H62 - H63) * (H62 - H63 > L63 - L62) * (H62 > H63) + 14 / 15 * ((H63 - H64) * (H63 - H64 > L64 - L63) * (H63 > H64) + 14 / 15 * ((H64 - H65) * (H64 - H65 > L65 - L64) * (H64 > H65) + 14 / 15 * ((H65 - H66) * (H65 - H66 > L66 - L65) * (H65 > H66) + 14 / 15 * ((H66 - H67) * (H66 - H67 > L67 - L66) * (H66 > H67)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (XAVGH29 - XAVGL29 + .06732837 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 14 / 15 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 14 / 15 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 14 / 15 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 14 / 15 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 14 / 15 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 14 / 15 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 14 / 15 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 14 / 15 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 14 / 15 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 14 / 15 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 14 / 15 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 14 / 15 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 14 / 15 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 14 / 15 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 14 / 15 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 14 / 15 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 14 / 15 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 14 / 15 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 14 / 15 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 14 / 15 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 14 / 15 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 14 / 15 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 14 / 15 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 14 / 15 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 14 / 15 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 14 / 15 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 14 / 15 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 14 / 15 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 14 / 15 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 14 / 15 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 14 / 15 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 14 / 15 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 14 / 15 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 14 / 15 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 14 / 15 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 14 / 15 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 14 / 15 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 14 / 15 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 14 / 15 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 14 / 15 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 14 / 15 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 14 / 15 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 14 / 15 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 14 / 15 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 14 / 15 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 14 / 15 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 14 / 15 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 14 / 15 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 14 / 15 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 14 / 15 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 14 / 15 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + 14 / 15 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + 14 / 15 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + 14 / 15 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + 14 / 15 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + 14 / 15 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + 14 / 15 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + 14 / 15 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + 14 / 15 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + 14 / 15 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + 14 / 15 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + 14 / 15 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + 14 / 15 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + 14 / 15 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + 14 / 15 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + 14 / 15 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
 
A 15-Period -DI can be writtten as:
 
6.732837 * ((L1 - L) * (H - H1 < L1 - L) * (L < L1) + 14 / 15 * ((L2 - L1) * (H1 - H2 < L2 - L1) * (L1 < L2) + 14 / 15 * ((L3 - L2) * (H2 - H3 < L3 - L2) * (L2 < L3) + 14 / 15 * ((L4 - L3) * (H3 - H4 < L4 - L3) * (L3 < L4) + 14 / 15 * ((L5 - L4) * (H4 - H5 < L5 - L4) * (L4 < L5) + 14 / 15 * ((L6 - L5) * (H5 - H6 < L6 - L5) * (L5 < L6) + 14 / 15 * ((L7 - L6) * (H6 - H7 < L7 - L6) * (L6 < L7) + 14 / 15 * ((L8 - L7) * (H7 - H8 < L8 - L7) * (L7 < L8) + 14 / 15 * ((L9 - L8) * (H8 - H9 < L9 - L8) * (L8 < L9) + 14 / 15 * ((L10 - L9) * (H9 - H10 < L10 - L9) * (L9 < L10) + 14 / 15 * ((L11 - L10) * (H10 - H11 < L11 - L10) * (L10 < L11) + 14 / 15 * ((L12 - L11) * (H11 - H12 < L12 - L11) * (L11 < L12) + 14 / 15 * ((L13 - L12) * (H12 - H13 < L13 - L12) * (L12 < L13) + 14 / 15 * ((L14 - L13) * (H13 - H14 < L14 - L13) * (L13 < L14) + 14 / 15 * ((L15 - L14) * (H14 - H15 < L15 - L14) * (L14 < L15) + 14 / 15 * ((L16 - L15) * (H15 - H16 < L16 - L15) * (L15 < L16) + 14 / 15 * ((L17 - L16) * (H16 - H17 < L17 - L16) * (L16 < L17) + 14 / 15 * ((L18 - L17) * (H17 - H18 < L18 - L17) * (L17 < L18) + 14 / 15 * ((L19 - L18) * (H18 - H19 < L19 - L18) * (L18 < L19) + 14 / 15 * ((L20 - L19) * (H19 - H20 < L20 - L19) * (L19 < L20) + 14 / 15 * ((L21 - L20) * (H20 - H21 < L21 - L20) * (L20 < L21) + 14 / 15 * ((L22 - L21) * (H21 - H22 < L22 - L21) * (L21 < L22) + 14 / 15 * ((L23 - L22) * (H22 - H23 < L23 - L22) * (L22 < L23) + 14 / 15 * ((L24 - L23) * (H23 - H24 < L24 - L23) * (L23 < L24) + 14 / 15 * ((L25 - L24) * (H24 - H25 < L25 - L24) * (L24 < L25) + 14 / 15 * ((L26 - L25) * (H25 - H26 < L26 - L25) * (L25 < L26) + 14 / 15 * ((L27 - L26) * (H26 - H27 < L27 - L26) * (L26 < L27) + 14 / 15 * ((L28 - L27) * (H27 - H28 < L28 - L27) * (L27 < L28) + 14 / 15 * ((L29 - L28) * (H28 - H29 < L29 - L28) * (L28 < L29) + 14 / 15 * ((L30 - L29) * (H29 - H30 < L30 - L29) * (L29 < L30) + 14 / 15 * ((L31 - L30) * (H30 - H31 < L31 - L30) * (L30 < L31) + 14 / 15 * ((L32 - L31) * (H31 - H32 < L32 - L31) * (L31 < L32) + 14 / 15 * ((L33 - L32) * (H32 - H33 < L33 - L32) * (L32 < L33) + 14 / 15 * ((L34 - L33) * (H33 - H34 < L34 - L33) * (L33 < L34) + 14 / 15 * ((L35 - L34) * (H34 - H35 < L35 - L34) * (L34 < L35) + 14 / 15 * ((L36 - L35) * (H35 - H36 < L36 - L35) * (L35 < L36) + 14 / 15 * ((L37 - L36) * (H36 - H37 < L37 - L36) * (L36 < L37) + 14 / 15 * ((L38 - L37) * (H37 - H38 < L38 - L37) * (L37 < L38) + 14 / 15 * ((L39 - L38) * (H38 - H39 < L39 - L38) * (L38 < L39) + 14 / 15 * ((L40 - L39) * (H39 - H40 < L40 - L39) * (L39 < L40) + 14 / 15 * ((L41 - L40) * (H40 - H41 < L41 - L40) * (L40 < L41) + 14 / 15 * ((L42 - L41) * (H41 - H42 < L42 - L41) * (L41 < L42) + 14 / 15 * ((L43 - L42) * (H42 - H43 < L43 - L42) * (L42 < L43) + 14 / 15 * ((L44 - L43) * (H43 - H44 < L44 - L43) * (L43 < L44) + 14 / 15 * ((L45 - L44) * (H44 - H45 < L45 - L44) * (L44 < L45) + 14 / 15 * ((L46 - L45) * (H45 - H46 < L46 - L45) * (L45 < L46) + 14 / 15 * ((L47 - L46) * (H46 - H47 < L47 - L46) * (L46 < L47) + 14 / 15 * ((L48 - L47) * (H47 - H48 < L48 - L47) * (L47 < L48) + 14 / 15 * ((L49 - L48) * (H48 - H49 < L49 - L48) * (L48 < L49) + 14 / 15 * ((L50 - L49) * (H49 - H50 < L50 - L49) * (L49 < L50) + 14 / 15 * ((L51 - L50) * (H50 - H51 < L51 - L50) * (L50 < L51) + 14 / 15 * ((L52 - L51) * (H51 - H52 < L52 - L51) * (L51 < L52) + 14 / 15 * ((L53 - L52) * (H52 - H53 < L53 - L52) * (L52 < L53) + 14 / 15 * ((L54 - L53) * (H53 - H54 < L54 - L53) * (L53 < L54) + 14 / 15 * ((L55 - L54) * (H54 - H55 < L55 - L54) * (L54 < L55) + 14 / 15 * ((L56 - L55) * (H55 - H56 < L56 - L55) * (L55 < L56) + 14 / 15 * ((L57 - L56) * (H56 - H57 < L57 - L56) * (L56 < L57) + 14 / 15 * ((L58 - L57) * (H57 - H58 < L58 - L57) * (L57 < L58) + 14 / 15 * ((L59 - L58) * (H58 - H59 < L59 - L58) * (L58 < L59) + 14 / 15 * ((L60 - L59) * (H59 - H60 < L60 - L59) * (L59 < L60) + 14 / 15 * ((L61 - L60) * (H60 - H61 < L61 - L60) * (L60 < L61) + 14 / 15 * ((L62 - L61) * (H61 - H62 < L62 - L61) * (L61 < L62) + 14 / 15 * ((L63 - L62) * (H62 - H63 < L63 - L62) * (L62 < L63) + 14 / 15 * ((L64 - L63) * (H63 - H64 < L64 - L63) * (L63 < L64) + 14 / 15 * ((L65 - L64) * (H64 - H65 < L65 - L64) * (L64 < L65) + 14 / 15 * ((L66 - L65) * (H65 - H66 < L66 - L65) * (L65 < L66) + 14 / 15 * ((L67 - L66) * (H66 - H67 < L67 - L66) * (L66 < L67)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / (XAVGH29 - XAVGL29 + .06732837 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 14 / 15 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 14 / 15 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 14 / 15 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 14 / 15 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 14 / 15 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 14 / 15 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 14 / 15 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 14 / 15 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 14 / 15 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 14 / 15 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 14 / 15 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 14 / 15 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 14 / 15 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 14 / 15 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 14 / 15 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 14 / 15 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 14 / 15 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 14 / 15 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 14 / 15 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 14 / 15 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 14 / 15 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 14 / 15 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 14 / 15 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 14 / 15 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 14 / 15 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 14 / 15 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 14 / 15 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 14 / 15 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 14 / 15 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 14 / 15 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 14 / 15 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 14 / 15 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 14 / 15 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 14 / 15 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 14 / 15 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 14 / 15 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 14 / 15 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 14 / 15 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 14 / 15 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 14 / 15 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 14 / 15 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 14 / 15 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 14 / 15 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 14 / 15 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 14 / 15 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 14 / 15 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 14 / 15 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 14 / 15 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 14 / 15 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 14 / 15 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 14 / 15 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + 14 / 15 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + 14 / 15 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + 14 / 15 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + 14 / 15 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + 14 / 15 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + 14 / 15 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + 14 / 15 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + 14 / 15 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + 14 / 15 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + 14 / 15 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + 14 / 15 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + 14 / 15 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + 14 / 15 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + 14 / 15 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + 14 / 15 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

A 14-Period Aroon Oscillator can be written as:

100 * ((L1 = MINL15) * (L1 < L) + 2 * (L2 = MINL15) * (L2 < MINL2) + 3 * (L3 = MINL15) * (L3 < MINL3) + 4 * (L4 = MINL15) * (L4 < MINL4) + 5 * (L5 = MINL15) * (L5 < MINL5) + 6 * (L6 = MINL15) * (L6 < MINL6) + 7 * (L7 = MINL15) * (L7 < MINL7) + 8 * (L8 = MINL15) * (L8 < MINL8) + 9 * (L9 = MINL15) * (L9 < MINL9) + 10 * (L10 = MINL15) * (L10 < MINL10) + 11 * (L11 = MINL15) * (L11 < MINL11) + 12 * (L12 = MINL15) * (L12 < MINL12) + 13 * (L13 = MINL15) * (L13 < MINL13) + 14 * (L14 = MINL15) * (L14 < MINL14) - (H1 = MAXH15) * (H1 > H) - 2 * (H2 = MAXH15) * (H2 > MAXH2) - 3 * (H3 = MAXH15) * (H3 > MAXH3) - 4 * (H4 = MAXH15) * (H4 > MAXH4) - 5 * (H5 = MAXH15) * (H5 > MAXH5) - 6 * (H6 = MAXH15) * (H6 > MAXH6) - 7 * (H7 = MAXH15) * (H7 > MAXH7) - 8 * (H8 = MAXH15) * (H8 > MAXH8) - 9 * (H9 = MAXH15) * (H9 > MAXH9) - 10 * (H10 = MAXH15) * (H10 > MAXH10) - 11 * (H11 = MAXH15) * (H11 > MAXH11) - 12 * (H12 = MAXH15) * (H12 > MAXH12) - 13 * (H13 = MAXH15) * (H13 > MAXH13) - 14 * (H14 = MAXH15) * (H14 > MAXH14)) / 14



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chagall
Posted : Friday, September 6, 2013 11:18:57 AM
Registered User
Joined: 9/11/2012
Posts: 92

I tried to display the +DI using that formula in V12( I wanted to go on and display the difference between +DI and -DI as an idicator ,) but I got the message "missing argument near *".

Can you help again?

 

Thank you,

Franz Josef

Bruce_L
Posted : Friday, September 6, 2013 11:28:10 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The formula does not generate any error messages on my system. My best guess would be that you you have some extra or missing characters. Make sure you are copying and pasting the entire formula with absolutely nothing extra.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chagall
Posted : Friday, September 6, 2013 11:56:21 AM
Registered User
Joined: 9/11/2012
Posts: 92

Thank you. I made sure to copy and paste exactly the formula, the error persists and is there too trying to display the -DI. Any second guess? Maybe Something with my german keyboard, but it would be the first time.

 

thank you,

 

Franz Josef

Bruce_L
Posted : Friday, September 6, 2013 11:58:38 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

There are two periods being used as decimal points in each formula that you might need to change to commas instead if you aren't using US regional settings.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chagall
Posted : Friday, September 6, 2013 4:31:48 PM
Registered User
Joined: 9/11/2012
Posts: 92

Bruce, got it. Thank you very much !

 

FRanz Josef

Chagall
Posted : Saturday, September 7, 2013 3:57:36 PM
Registered User
Joined: 9/11/2012
Posts: 92

Bruce,

it&acute;s not about a problem, but please hep me understand something. Sometimes I read your hint, that a user is better off using the built-in capabilities of TC2000 fo EasyScanning than to work with a PCF, e. g. maybe scanning for a crossing of 2 indicators. Do you say that regarding the conveniance of applying the idea for the user (not to have to deal with PCFs) or do you say that for optimization of the the calculation speed ?

Is there - e. g. - any difference in calculation speed with displaying the +DI as a TC2000 built in indicator versusdisplaying it via PCF, as you gave it in this thread?

I know that "all" calculations are done by the Worden "cloud"-servers, but Worden gives a hint that locally installing the software  makes a better performance.

When I am was new to TC 2000, I tried it on different PC&acute;s, and I found that the performance of the local hardware was clearly critical for the performnance of real working with the software. Since that time  i am using a system very close  to the max system performance values as measured by Win 7.

 

thank you,

 

FRanz Josef

 

thank

 

johnny2127
Posted : Saturday, September 7, 2013 5:30:37 PM
Registered User
Joined: 6/18/2013
Posts: 7

The formula you gave for the +DI 15 -DI 15  isn't matching up with the one built into Version 12.  Its constantly 1-3 days different or late in its cross overs versus the one in Version 12.  

Can you help fix it so it matches up correctly?

Bruce_L
Posted : Monday, September 9, 2013 8:15:05 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Chagall,
Clicking on the indicator and selecting Create Scan Condition is almost always going to be more efficient than creating a Personal Criteria Formula based condition to do the same thing. It normally uses less in the way of resources and calculates quicker.

johnny2127,
The formula is correct and does not need to be changed. Minor differences in values can occur because of differing amounts of data used in calculating the built in indicators and the formulas (and there are no changes in the formula which could be made to account for this), but constantly being 1-3 different in its crossovers does not happen.

My best guesses would be that you are either charting something other than a 15-Period Directional Movement (+DI -DI) indicator for comparison or that you have not plotted the +DI 15 and -DI 15 indicators in the same scale.

Adding and Moving Indicators



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.