Hi Bruce,

Can you please provide PCF for TSV Crossing Exponential Moving Average(applied to TSV) in Either Direction.

For example PCF for

(TSV38 crossing EMA19 in either direction) or (TSV28 crossing EMA14 in either direction)

Regards

AJ

Well it depends on the if the TSV is simple or exponential. For example, if the TSV38 is simple:

SGN(TSV38 - XAVG(TSV38,19)) <> SGN(TSV38.1 - XAVG(TSV38.1,19))

But if we did your TSV28 example with an exponential TSV:

SGN(XAVG(TSV,28) - XAVG(TSV,14)) <> SGN(XAVG(TSV1.1,28) - XAVG(TSV1.1,14))

Cascades of Moving Averages

Thanks Bruce. It solves my query.  One more PCF please.

CCI60 crossing any of the values -150 -100 100 150 in either direction.

It is too bad you aren't talking about crossing 0 as that formula is rather short.

SGN(H + L + C - AVGH60 - AVGL60 - AVGC60) <> SGN(H1 + L1 + C1 - AVGH60.1 - AVGL60.1 - AVGC60.1)

Crossing -150 can be written as follows.

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

Crossing -100 can be written as follows.

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

Crossing +100 can be written as follows.

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

Crossing +150 can can be written as follows.

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

Thanks Bruce. But CCI is now available as indicator in TC2000 Ver 16. Can above formulas be shortened?

No, the formula cannot be shortened (well not siginificantly anyway). But you can click on the indicator and select Create Scan Condition to create conditions for crossing up and for crossing down. You just can't OR the conditions to create a single EasyScan for crossing up or crossing down to check for either happening in the same EasyScan.

Thanks Bruce. Will "OR" condition be provided in Easy Scan in future? It will be a very useful

I do not know when or if "OR" might be built into EasyScans. Thank you for your suggestion.