Hi Bruce, 

Hope my question don't sound weird.

I would like to ask if I can calculate using PCF the average value of the ATR(14) for the last 28 days? Please kindly advise is that possible? Thank you

This MAY help, depending on what you want to achieve. Once you have added ATR to your chart, you can add "Add Plot Here", a moving average of ATR. You could add the value of the last bar to a Watchlist, Create Scan Condition, etc.

Hi

Thank you for your feedback.

I was trying to have a formula or calculations of taking the last 28 candles ATR to give me that average value today.

(sum of ATR(14) of 28 days)/28

The technique given by bcochrane will in fact give you the desired value, it just doesn't do it as a formula.

Please provide a description and PCF for calculating an ATR value to be used as a stop loss value

(AVG(AVGH14,28) - AVG(AVGL14,28)) / 2 + (ABS(H - C1) + ABS(C1 - L) + 2 * (ABS(H1 - C2) + ABS(C2 - L1)) + 3 * (ABS(H2 - C3) + ABS(C3 - L2)) + 4 * (ABS(H3 - C4) + ABS(C4 - L3)) + 5 * (ABS(H4 - C5) + ABS(C5 - L4)) + 6 * (ABS(H5 - C6) + ABS(C6 - L5)) + 7 * (ABS(H6 - C7) + ABS(C7 - L6)) + 8 * (ABS(H7 - C8) + ABS(C8 - L7)) + 9 * (ABS(H8 - C9) + ABS(C9 - L8)) + 10 * (ABS(H9 - C10) + ABS(C10 - L9)) + 11 * (ABS(H10 - C11) + ABS(C11 - L10)) + 12 * (ABS(H11 - C12) + ABS(C12 - L11)) + 13 * (ABS(H12 - C13) + ABS(C13 - L12)) + 14 * (ABS(H13 - C14) + ABS(C14 - L13) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17) + ABS(H18 - C19) + ABS(C19 - L18) + ABS(H19 - C20) + ABS(C20 - L19) + ABS(H20 - C21) + ABS(C21 - L20) + ABS(H21 - C22) + ABS(C22 - L21) + ABS(H22 - C23) + ABS(C23 - L22) + ABS(H23 - C24) + ABS(C24 - L23) + ABS(H24 - C25) + ABS(C25 - L24) + ABS(H25 - C26) + ABS(C26 - L25) + ABS(H26 - C27) + ABS(C27 - L26) + ABS(H27 - C28) + ABS(C28 - L27)) + 13 * (ABS(H28 - C29) + ABS(C29 - L28)) + 12 * (ABS(H29 - C30) + ABS(C30 - L29)) + 11 * (ABS(H30 - C31) + ABS(C31 - L30)) + 10 * (ABS(H31 - C32) + ABS(C32 - L31)) + 9 * (ABS(H32 - C33) + ABS(C33 - L32)) + 8 * (ABS(H33 - C34) + ABS(C34 - L33)) + 7 * (ABS(H34 - C35) + ABS(C35 - L34)) + 6 * (ABS(H35 - C36) + ABS(C36 - L35)) + 5 * (ABS(H36 - C37) + ABS(C37 - L36)) + 4 * (ABS(H37 - C38) + ABS(C38 - L37)) + 3 * (ABS(H38 - C39) + ABS(C39 - L38)) + 2 * (ABS(H39 - C40) + ABS(C40 - L39)) + ABS(H40 - C41) + ABS(C41 - L40)) / 784

Thanks Bruce!!

Happy new year to you and team!!

Hi Bruce,

If I want to increase to say 90 days, I just change the 28 to 90?

Unfortunately no. You would also have to change the number of terms and the denominator in the second part of the formula.

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

Thank you again for churning out the numbers. thumbs up!!

You're welcome.