| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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.
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Registered User
Joined: 9/11/2012
Posts: 92
|
Bruce, got it. Thank you very much !
FRanz Josef
|
|
Registered User
Joined: 9/11/2012
Posts: 92
|
Bruce,
it´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´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
|
|
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?
|
|
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
|
|
|
Guest-1 |