Hi Bruce,

I'd like to create a Custom PCF Price Channel. It would be similar to a Keltner Channel but I can't use the off-the-shelf Keltner Channel because I'd prefer to use my own calculation for the centerline.

My channel lines, however, are like a Keltner Channel (i.e., the Average True Range is calculated over a time period and multiplied by a multiple to form the upper & lower channel.)

Having said that, is it possible to write PCFs for the Channel Width Formula for 5-bar, 8-bar, 13-bar, and 21-bar periods?

Thanks.

A 5-Period Exponential Average True Range could be written as:

XAVGH5 - XAVGL5 + 0.333559032545198 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 4 / 6 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 4 / 6 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 4 / 6 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 4 / 6 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 4 / 6 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 4 / 6 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 4 / 6 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 4 / 6 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 4 / 6 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 4 / 6 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 4 / 6 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 4 / 6 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 4 / 6 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 4 / 6 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 4 / 6 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 4 / 6 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 4 / 6 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17)))))))))))))))))))

An 8-Period Exponential Average True Range could be written as:

XAVGH8 - XAVGL8 + 0.222417712077508 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 7 / 9 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 7 / 9 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 7 / 9 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 7 / 9 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 7 / 9 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 7 / 9 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 7 / 9 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 7 / 9 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 7 / 9 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 7 / 9 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 7 / 9 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 7 / 9 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 7 / 9 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 7 / 9 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 7 / 9 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 7 / 9 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 7 / 9 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 7 / 9 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 7 / 9 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 7 / 9 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 7 / 9 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 7 / 9 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 7 / 9 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 7 / 9 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 7 / 9 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 7 / 9 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 7 / 9 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27)))))))))))))))))))))))))))))

A 13-Period Exponential Average True Range could be written as:

XAVGH13 - XAVGL13 + 0.142996048056393 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 12 / 14 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 12 / 14 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 12 / 14 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 12 / 14 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 12 / 14 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 12 / 14 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 12 / 14 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 12 / 14 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 12 / 14 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 12 / 14 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 12 / 14 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 12 / 14 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 12 / 14 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 12 / 14 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 12 / 14 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 12 / 14 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 12 / 14 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 12 / 14 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 12 / 14 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 12 / 14 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 12 / 14 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 12 / 14 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 12 / 14 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 12 / 14 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 12 / 14 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 12 / 14 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 12 / 14 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 12 / 14 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 12 / 14 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 12 / 14 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 12 / 14 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 12 / 14 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 12 / 14 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 12 / 14 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 12 / 14 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 12 / 14 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 12 / 14 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 12 / 14 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 12 / 14 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 12 / 14 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 12 / 14 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 12 / 14 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 12 / 14 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 12 / 14 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44))))))))))))))))))))))))))))))))))))))))))))))

A 21-Period Exponential Average True Range could be written as:

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

Thanks Bruce!

Hi Bruce,

I'm just going through my notes, and in the past you've provided me with PCFs for Linear Regression Slope and R-Squared ... but I don't think I've ever asked for the actual Linear Regression Line itself, which is what I'd like to use as the centerline for my Custom PCF Price Channel above.

When you get a chance can you list the PCFs for 5-period, 8-period, 13-period, and 21-period Linear Regression Lines?

Thanks again.

It is not possible to create the Linear Regression Line as a Custom Indicator. It is possible to plot the Moving Linear Regression however (which is the right endpoints of the Linear Regression Line plotted in series like a Moving Average).

The 5-Period Linear Regression could be written as:

AVGC5 + 2 * (2 * C + C1 - C3 - 2 * C4) / 10

The 8-Period Linear Regression could be written as:

AVGC8 + 3.5 * (3.5 * C + 2.5 * C1 + 1.5 * C2 + .5 * C3 - .5 * C4 - 1.5 * C5 - 2.5 * C6 - 3.5 * C7) / 42

The 13-Period Linear Regression could be written as:

AVGC13 + 6 * (6 * C + 5 * C1 + 4 * C2 + 3 * C3 + 2 * C4 + C5 - C7 - 2 * C8 - 3 * C9 - 4 * C10 - 5 * C11 - 6 * C12) / 182

The 21-Period Linear Regression could be written as:

AVGC21 + 10 * (10 * C + 9 * C1 + 8 * C2 + 7 * C3 + 6 * C4 + 5 * C5 + 4 * C6 + 3 * C7 + 2 * C8 + C9 - C11 - 2 * C12 - 3 * C13 - 4 * C14 - 5 * C15 - 6 * C16 - 7 * C17 - 8 * C18 - 9 * C19 - 10 * C20) / 770

Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis

Thanks Bruce!

Hi Bruce,

Earlier in this thread you provided PCFs for:

• 5-Period Exponential Average True Range
• 8-Period Exponential Average True Range
• 13-Period Exponential Average True Range
• 21-Period Exponential Average True Range

I'm still working on understanding the different methods (and Pros & Cons) of calculating ATR. Would it be possible to create PCFs for "Wilder's Smoothed" ATRs for 5, 8, 13, and 21 bars, or would the formulas be too long to be practical?

Also, if you have a link to a good dsicussion of the different ATRs, that would be fantastic!

Thanks.

A 5-Period Wilder's Smoothed ATR would be the same as a 9-Period Exponential Moving Average of True Range:

XAVGH9 - XAVGL9 + .200198266760174 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + .8 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + .8 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + .8 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + .8 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + .8 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + .8 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + .8 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + .8 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + .8 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + .8 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + .8 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + .8 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + .8 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + .8 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + .8 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + .8 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + .8 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + .8 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + .8 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + .8 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + .8 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + .8 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + .8 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + .8 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + .8 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + .8 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + .8 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + .8 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + .8 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + .8 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30))))))))))))))))))))))))))))))))

An 8-Period Wilder's Smoothed ATR would be the same as a 15-Period Exponential Moving Average of True Range:

XAVGH15 - XAVGL15 + .125120711309662 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 7 / 8 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 7 / 8 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 7 / 8 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 7 / 8 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 7 / 8 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 7 / 8 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 7 / 8 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 7 / 8 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 7 / 8 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 7 / 8 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 7 / 8 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 7 / 8 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 7 / 8 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 7 / 8 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 7 / 8 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 7 / 8 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 7 / 8 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 7 / 8 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 7 / 8 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 7 / 8 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 7 / 8 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 7 / 8 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 7 / 8 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 7 / 8 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 7 / 8 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 7 / 8 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 7 / 8 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 7 / 8 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 7 / 8 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 7 / 8 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 7 / 8 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 7 / 8 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 7 / 8 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 7 / 8 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 7 / 8 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 7 / 8 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 7 / 8 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 7 / 8 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 7 / 8 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 7 / 8 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 7 / 8 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 7 / 8 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 7 / 8 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 7 / 8 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 7 / 8 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 7 / 8 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 7 / 8 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 7 / 8 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 7 / 8 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 7 / 8 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 7 / 8 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51)))))))))))))))))))))))))))))))))))))))))))))))))))))

A 13-Period Wilder's Smoothed ATR would be the same as a 25-Period Exponential Moving Average of True Range:

XAVGH25 - XAVGL25 + .0769958824343713 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 12 / 13 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 12 / 13 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 12 / 13 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 12 / 13 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 12 / 13 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 12 / 13 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 12 / 13 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 12 / 13 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 12 / 13 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 12 / 13 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 12 / 13 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 12 / 13 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 12 / 13 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 12 / 13 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 12 / 13 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 12 / 13 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 12 / 13 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 12 / 13 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 12 / 13 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 12 / 13 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 12 / 13 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 12 / 13 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 12 / 13 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 12 / 13 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 12 / 13 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 12 / 13 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 12 / 13 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 12 / 13 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 12 / 13 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 12 / 13 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 12 / 13 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 12 / 13 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 12 / 13 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 12 / 13 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 12 / 13 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 12 / 13 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 12 / 13 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 12 / 13 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 12 / 13 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 12 / 13 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 12 / 13 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 12 / 13 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 12 / 13 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 12 / 13 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 12 / 13 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 12 / 13 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 12 / 13 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 12 / 13 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 12 / 13 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 12 / 13 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 12 / 13 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51) + 12 / 13 * ((H52 < C53) * (H52 - C53) + (C53 < L52) * (C53 - L52) + 12 / 13 * ((H53 < C54) * (H53 - C54) + (C54 < L53) * (C54 - L53) + 12 / 13 * ((H54 < C55) * (H54 - C55) + (C55 < L54) * (C55 - L54) + 12 / 13 * ((H55 < C56) * (H55 - C56) + (C56 < L55) * (C56 - L55) + 12 / 13 * ((H56 < C57) * (H56 - C57) + (C57 < L56) * (C57 - L56) + 12 / 13 * ((H57 < C58) * (H57 - C58) + (C58 < L57) * (C58 - L57) + 12 / 13 * ((H58 < C59) * (H58 - C59) + (C59 < L58) * (C59 - L58) + 12 / 13 * ((H59 < C60) * (H59 - C60) + (C60 < L59) * (C60 - L59) + 12 / 13 * ((H60 < C61) * (H60 - C61) + (C61 < L60) * (C61 - L60) + 12 / 13 * ((H61 < C62) * (H61 - C62) + (C62 < L61) * (C62 - L61) + 12 / 13 * ((H62 < C63) * (H62 - C63) + (C63 < L62) * (C63 - L62) + 12 / 13 * ((H63 < C64) * (H63 - C64) + (C64 < L63) * (C64 - L63) + 12 / 13 * ((H64 < C65) * (H64 - C65) + (C65 < L64) * (C65 - L64) + 12 / 13 * ((H65 < C66) * (H65 - C66) + (C66 < L65) * (C66 - L65) + 12 / 13 * ((H66 < C67) * (H66 - C67) + (C67 < L66) * (C67 - L66) + 12 / 13 * ((H67 < C68) * (H67 - C68) + (C68 < L67) * (C68 - L67) + 12 / 13 * ((H68 < C69) * (H68 - C69) + (C69 < L68) * (C69 - L68) + 12 / 13 * ((H69 < C70) * (H69 - C70) + (C70 < L69) * (C70 - L69) + 12 / 13 * ((H70 < C71) * (H70 - C71) + (C71 < L70) * (C71 - L70) + 12 / 13 * ((H71 < C72) * (H71 - C72) + (C72 < L71) * (C72 - L71) + 12 / 13 * ((H72 < C73) * (H72 - C73) + (C73 < L72) * (C73 - L72) + 12 / 13 * ((H73 < C74) * (H73 - C74) + (C74 < L73) * (C74 - L73) + 12 / 13 * ((H74 < C75) * (H74 - C75) + (C75 < L74) * (C75 - L74) + 12 / 13 * ((H75 < C76) * (H75 - C76) + (C76 < L75) * (C76 - L75) + 12 / 13 * ((H76 < C77) * (H76 - C77) + (C77 < L76) * (C77 - L76) + 12 / 13 * ((H77 < C78) * (H77 - C78) + (C78 < L77) * (C78 - L77) + 12 / 13 * ((H78 < C79) * (H78 - C79) + (C79 < L78) * (C79 - L78) + 12 / 13 * ((H79 < C80) * (H79 - C80) + (C80 < L79) * (C80 - L79) + 12 / 13 * ((H80 < C81) * (H80 - C81) + (C81 < L80) * (C81 - L80) + 12 / 13 * ((H81 < C82) * (H81 - C82) + (C82 < L81) * (C82 - L81) + 12 / 13 * ((H82 < C83) * (H82 - C83) + (C83 < L82) * (C83 - L82) + 12 / 13 * ((H83 < C84) * (H83 - C84) + (C84 < L83) * (C84 - L83) + 12 / 13 * ((H84 < C85) * (H84 - C85) + (C85 < L84) * (C85 - L84) + 12 / 13 * ((H85 < C86) * (H85 - C86) + (C86 < L85) * (C86 - L85) + 12 / 13 * ((H86 < C87) * (H86 - C87) + (C87 < L86) * (C87 - L86))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

A 21-Period Wilder's Smoothed ATR would be the same as a 41-Period Expenontial Moving Average of True Range and ends up being too long and slow for me to post in the forums.

Interesting. Thanks Bruce!

Bruce, I could use the 34-period and 55-period Moving Linear Regression PCFs to round out my Linear Regresssion toolbox :)

Thanks!

34-Period Moving Linear Regression:

AVGC34 + 16.5 * (16.5 * C + 15.5 * C1 + 14.5 * C2 + 13.5 * C3 + 12.5 * C4 + 11.5 * C5 + 10.5 * C6 + 9.5 * C7 + 8.5 * C8 + 7.5 * C9 + 6.5 * C10 + 5.5 * C11 + 4.5 * C12 + 3.5 * C13 + 2.5 * C14 + 1.5 * C15 + .5 * C16 - .5 * C17 - 1.5 * C18 - 2.5 * C19 - 3.5 * C20 - 4.5 * C21 - 5.5 * C22 - 6.5 * C23 - 7.5 * C24 - 8.5 * C25 - 9.5 * C26 - 10.5 * C27 - 11.5 * C28 - 12.5 * C29 - 13.5 * C30 - 14.5 * C31 - 15.5 * C32 - 16.5 * C33) / 3272.5

55-Period Moving Linear Regression:

AVGC55 + 27 * (27 * C + 26 * C1 + 25 * C2 + 24 * C3 + 23 * C4 + 22 * C5 + 21 * C6 + 20 * C7 + 19 * C8 + 18 * C9 + 17 * C10 + 16 * C11 + 15 * C12 + 14 * C13 + 13 * C14 + 12 * C15 + 11 * C16 + 10 * C17 + 9 * C18 + 8 * C19 + 7 * C20 + 6 * C21 + 5 * C22 + 4 * C23 + 3 * C24 + 2 * C25 + C26 - C28 - 2 * C29 - 3 * C30 - 4 * C31 - 5 * C32 - 6 * C33 - 7 * C34 - 8 * C35 - 9 * C36 - 10 * C37 - 11 * C38 - 12 * C39 - 13 * C40 - 14 * C41 - 15 * C42 - 16 * C43 - 17 * C44 - 18 * C45 - 19 * C46 - 20 * C47 - 21 * C48 - 22 * C49 - 23 * C50 - 24 * C51 - 25 * C52 - 26 * C53 - 27 * C54) / 13860

Thanks Bruce!

Hi Bruce,

Up to now I've asked for PCFs based on Fibs (5, 8, 13, 21, 34, 55).
This time I have a single "non-fib" request.

Can you please write a PCF for a 65-Period Moving Linear Regression?
(It's a long story; I won't bore you with the details).

Thanks!

65-Period Moving Linear Regression:

AVGC65 + 32 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880

Sweet, thank you!

An Indicator Formula for a 50-period moving linear regression indicator can be written as follows.

AVGC50 + 24.5 * (24.5 * C + 23.5 * C1 + 22.5 * C2 + 21.5 * C3 + 20.5 * C4 + 19.5 * C5 + 18.5 * C6 + 17.5 * C7 + 16.5 * C8 + 15.5 * C9 + 14.5 * C10 + 13.5 * C11 + 12.5 * C12 + 11.5 * C13 + 10.5 * C14 + 9.5 * C15 + 8.5 * C16 + 7.5 * C17 + 6.5 * C18 + 5.5 * C19 + 4.5 * C20 + 3.5 * C21 + 2.5 * C22 + 1.5 * C23 + .5 * C24 - .5 * C25 - 1.5 * C26 - 2.5 * C27 - 3.5 * C28 - 4.5 * C29 - 5.5 * C30 - 6.5 * C31 - 7.5 * C32 - 8.5 * C33 - 9.5 * C34 - 10.5 * C35 - 11.5 * C36 - 12.5 * C37 - 13.5 * C38 - 14.5 * C39 - 15.5 * C40 - 16.5 * C41 - 17.5 * C42 - 18.5 * C43 - 19.5 * C44 - 20.5 * C45 - 21.5 * C46 - 22.5 * C47 - 23.5 * C48 - 24.5 * C49) / 10412.5

Hi Bruce,

From your responses above it sounds like ATR's for 21 bars or more really aren't practical.

I wanted to experiment with a channel using a 34-Period Moving Linear Regression as the centerline; I'm open to alternatives for calculating the other lines.

If I can't use ATR, is there a way to use Standard Deviations for the outside lines?

Thanks!

Ive been using H-L range.

21 bars: AVGH21-AVGL21

Much simpler and easy to adjust..

Thanks

Diceman, thanks ... I'll check it out!