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

PCF for TSV Crossing Exponential Moving Average(applied to TSV) in Either Direction. Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
one100mil2016
Posted : Wednesday, September 21, 2016 11:47:23 PM
Registered User
Joined: 7/18/2016
Posts: 13

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

 
Bruce_L
Posted : Thursday, September 22, 2016 9:12:59 AM


Worden Trainer

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

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
one100mil2016
Posted : Thursday, September 22, 2016 4:41:50 PM
Registered User
Joined: 7/18/2016
Posts: 13

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

 

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

 

Bruce_L
Posted : Friday, September 23, 2016 10:39:19 AM


Worden Trainer

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

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)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
one100mil2016
Posted : Friday, September 23, 2016 12:11:18 PM
Registered User
Joined: 7/18/2016
Posts: 13

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

Bruce_L
Posted : Friday, September 23, 2016 12:42:54 PM


Worden Trainer

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

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.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
one100mil2016
Posted : Friday, September 23, 2016 1:32:50 PM
Registered User
Joined: 7/18/2016
Posts: 13

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

Bruce_L
Posted : Friday, September 23, 2016 2:09:54 PM


Worden Trainer

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

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



-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.