Bruce,

I want to create a pcf for the following conditions:

BBands 21 2 Channel Top Price History value below 1.1 ATR Channel Top

BBands 21 2 Channel Bottom Price History value above 1.1 ATR Channel Bottom

I use a 21 EMA and would like to look at 100 days of history

I can create the two conditions separately in TC2000, but can't merge them together into one column.

Thanks, William

I don't have a built in ATR Channel in my copy of TC2000 version 12.1. Is it a Custom PCF Channel Indicator of some sort?

When you say you use a 21-EMA, is that the centerline of the Bollinger Bands or the ATR Channel?

When you say you would like to look at 100 days of history, are you talking about a 100-Period Simple Moving Average of Average True Range or are you somehow trying to test if this is true at some point or at every point over the most recent 100-bars of history?

I guess if you just tell me all of the details of exactly what you are currently doing to create the individual Conditions, I might be able to create the combined Condition. I suspect this will require supplying the information requested above anyway however.

Bruce,

I use the 21-EMA as the centerline for both the Bollinger Bands and ATR Channel

The 100 days of history may not  be relevant. I just want to see if the condition exists now.

I use the Keltner channel indicator in TC2000 - I just call itt ATR. Sorry.

To create the conditions I just click on the BBand indicator and create the conditons referenced above.

What I want is the BBand to be inside the 1.1 ATR channel, but have to do it separately for the top and bottom of the channel. I would like to combine them into one reading so I can have it as a column in my watchlists.

Thanks

Please try the following Condition Formula:

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

Thanks Bruce. It's not perfect, but it generates the squeeze condition I am looking for.

Would you mind doing the same forumula for a BBand 21 2 channel  inside a 1.5 ATR Channel.

Appreciate it.

Wm

You just need to change the 1.1 * to a 1.5 * after the < sign:

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

Thanks Bruce. Nice work as usual. Appreciate it.

commodities

Any way to do easy scans on commodities. Thanks

No. We do not carry commodities.

TC2000 does however have some commodity ETN, ETF, and Index Funds which might, to some degree, track the actual commodities.

I have an indicator for The Squeeze that works beautifully. You can easily create Scan Conditions from this as well. When the indicator hits 0 the squeeze is on. When it rises back above 0 it is an action signal.

(SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) * 4 / 3 / ((AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20)) / 40 + .000001))-1

The Squeeze indicator of Telework works very well. Thankz for that! I use it also in Easy Scans.

But I also really want to scan on tickers which are in squeeze for the first time today. Simply said, the squeeze situation of today has te be compared by the situation yesterday.

My knowledge of programming a PCF or indicator is too little to do this myself. Does anyone have a solution?   

You may want to take a look at the TTM Squeeze -- Conditional Statement modification Bruce topic.

Hi Bruce...in the squeeze formula provided above by Telework, could you please amend to base it on a 13 period moving average?

The formula provided was:

(SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) * 4 / 3 / ((AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20)) / 40 + .000001))-1

Many thanks,

Piers

Please try the following.

SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 - 13 * AVGC13 ^ 2) / 13) * 4 / 3 / ((AVGH13 - AVGL13) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13)) / 26 + .000001) - 1