kenkozak |
Gold User, Member, TeleChart
|
Registered User |
|
|
|
|
Unsure |
|
Tuesday, November 9, 2004 |
Wednesday, October 7, 2009 10:28:54 PM |
6 [0.00% of all post / 0.00 posts per day] |
|
Thanks, I'll try that.
|
Craig, I tried to use Doug's approach to Keltner Channels but ran in to several problems. First, Doug's approach appears to be for a simple weighted channel and I can't see how to make it an exponential weighted channel. Also a key component to the Keltner Channel is the ATR multiplier and I don't see how that can be done using Doug's approach with the Custom Price Channel. So, unless I am missing something with Doug's approach or you have some other suggestion, I think I will go back to trying Bruce's PCF.
|
Thanks Craig. I'll try that.
|
As a follow up question. Is it possible to put the Keltner Channel formula into a custom indicator and use the result as part of another custom indicator? For example, calculate the value of the Keltner Channel and use a separate custome indicator to compare that value to today's close and yesterday's close.
|
I am interested in adding Keltner Channels to my chart using an exponential 20 period moving average and an exponential 20 period ATR. I read all the discussion forums that mentioned Keltner Channels and found a gem of a formula written by Bruce L. (I copied the formula below). Hats off to Bruce. He must be a genius to come up with that formula. It appears to produce the correct values and channels but is very cumbersome and sometimes causes the Telechart program to freeze up. I am wondering if there is any way to simplify the formula into a more efficient one that will produce the same result? This would be helpful in writing a custom indicator to flag price crossing the Keltner Channel because the formula would have to be entered twice to pinpoint the crossover day. Any help would be appreciated.
Bruce L's formula for 20 period Keltner Channel:
(XAVGH39 - XAVGL39 + .025024606734037 * (ABS(H - C1) + ABS(L - C1) - H + L + .95 * (ABS(H1 - C2) + ABS(L1 - C2) - H1 + L1 + .95 * (ABS(H2 - C3) + ABS(L2 - C3) - H2 + L2 + .95 * (ABS(H3 - C4) + ABS(L3 - C4) - H3 + L3 + .95 * (ABS(H4 - C5) + ABS(L4 - C5) - H4 + L4 + .95 * (ABS(H5 - C6) + ABS(L5 - C6) - H5 + L5 + .95 * (ABS(H6 - C7) + ABS(L6 - C7) - H6 + L6 + .95 * (ABS(H7 - C8) + ABS(L7 - C8) - H7 + L7 + .95 * (ABS(H8 - C9) + ABS(L8 - C9) - H8 + L8 + .95 * (ABS(H9 - C10) + ABS(L9 - C10) - H9 + L9 + .95 * (ABS(H10 - C11) + ABS(L10 - C11) - H10 + L10 + .95 * (ABS(H11 - C12) + ABS(L11 - C12) - H11 + L11 + .95 * (ABS(H12 - C13) + ABS(L12 - C13) - H12 + L12 + .95 * (ABS(H13 - C14) + ABS(L13 - C14) - H13 + L13 + .95 * (ABS(H14 - C15) + ABS(L14 - C15) - H14 + L14 + .95 * (ABS(H15 - C16) + ABS(L15 - C16) - H15 + L15 + .95 * (ABS(H16 - C17) + ABS(L16 - C17) - H16 + L16 + .95 * (ABS(H17 - C18) + ABS(L17 - C18) - H17 + L17 + .95 * (ABS(H18 - C19) + ABS(L18 - C19) - H18 + L18 + .95 * (ABS(H19 - C20) + ABS(L19 - C20) - H19 + L19 + .95 * (ABS(H20 - C21) + ABS(L20 - C21) - H20 + L20 + .95 * (ABS(H21 - C22) + ABS(L21 - C22) - H21 + L21 + .95 * (ABS(H22 - C23) + ABS(L22 - C23) - H22 + L22 + .95 * (ABS(H23 - C24) + ABS(L23 - C24) - H23 + L23 + .95 * (ABS(H24 - C25) + ABS(L24 - C25) - H24 + L24 + .95 * (ABS(H25 - C26) + ABS(L25 - C26) - H25 + L25 + .95 * (ABS(H26 - C27) + ABS(L26 - C27) - H26 + L26 + .95 * (ABS(H27 - C28) + ABS(L27 - C28) - H27 + L27 + .95 * (ABS(H28 - C29) + ABS(L28 - C29) - H28 + L28 + .95 * (ABS(H29 - C30) + ABS(L29 - C30) - H29 + L29 + .95 * (ABS(H30 - C31) + ABS(L30 - C31) - H30 + L30 + .95 * (ABS(H31 - C32) + ABS(L31 - C32) - H31 + L31 + .95 * (ABS(H32 - C33) + ABS(L32 - C33) - H32 + L32 + .95 * (ABS(H33 - C34) + ABS(L33 - C34) - H33 + L33 + .95 * (ABS(H34 - C35) + ABS(L34 - C35) - H34 + L34 + .95 * (ABS(H35 - C36) + ABS(L35 - C36) - H35 + L35 + .95 * (ABS(H36 - C37) + ABS(L36 - C37) - H36 + L36 + .95 * (ABS(H37 - C38) + ABS(L37 - C38) - H37 + L37 + .95 * (ABS(H38 - C39) + ABS(L38 - C39) - H38 + L38 + .95 * (ABS(H39 - C40) + ABS(L39 - C40) - H39 + L39 + .95 * (ABS(H40 - C41) + ABS(L40 - C41) - H40 + L40 + .95 * (ABS(H41 - C42) + ABS(L41 - C42) - H41 + L41 + .95 * (ABS(H42 - C43) + ABS(L42 - C43) - H42 + L42 + .95 * (ABS(H43 - C44) + ABS(L43 - C44) - H43 + L43 + .95 * (ABS(H44 - C45) + ABS(L44 - C45) - H44 + L44 + .95 * (ABS(H45 - C46) + ABS(L45 - C46) - H45 + L45 + .95 * (ABS(H46 - C47) + ABS(L46 - C47) - H46 + L46 + .95 * (ABS(H47 - C48) + ABS(L47 - C48) - H47 + L47 + .95 * (ABS(H48 - C49) + ABS(L48 - C49) - H48 + L48 + .95 * (ABS(H49 - C50) + ABS(L49 - C50) - H49 + L49 + .95 * (ABS(H50 - C51) + ABS(L50 - C51) - H50 + L50 + .95 * (ABS(H51 - C52) + ABS(L51 - C52) - H51 + L51 + .95 * (ABS(H52 - C53) + ABS(L52 - C53) - H52 + L52 + .95 * (ABS(H53 - C54) + ABS(L53 - C54) - H53 + L53 + .95 * (ABS(H54 - C55) + ABS(L54 - C55) - H54 + L54 + .95 * (ABS(H55 - C56) + ABS(L55 - C56) - H55 + L55 + .95 * (ABS(H56 - C57) + ABS(L56 - C57) - H56 + L56 + .95 * (ABS(H57 - C58) + ABS(L57 - C58) - H57 + L57 + .95 * (ABS(H58 - C59) + ABS(L58 - C59) - H58 + L58 + .95 * (ABS(H59 - C60) + ABS(L59 - C60) - H59 + L59 + .95 * (ABS(H60 - C61) + ABS(L60 - C61) - H60 + L60 + .95 * (ABS(H61 - C62) + ABS(L61 - C62) - H61 + L61 + .95 * (ABS(H62 - C63) + ABS(L62 - C63) - H62 + L62 + .95 * (ABS(H63 - C64) + ABS(L63 - C64) - H63 + L63 + .95 * (ABS(H64 - C65) + ABS(L64 - C65) - H64 + L64 + .95 * (ABS(H65 - C66) + ABS(L65 - C66) - H65 + L65 + .95 * (ABS(H66 - C67) + ABS(L66 - C67) - H66 + L66 + .95 * (ABS(H67 - C68) + ABS(L67 - C68) - H67 + L67 + .95 * (ABS(H68 - C69) + ABS(L68 - C69) - H68 + L68 + .95 * (ABS(H69 - C70) + ABS(L69 - C70) - H69 + L69 + .95 * (ABS(H70 - C71) + ABS(L70 - C71) - H70 + L70 + .95 * (ABS(H71 - C72) + ABS(L71 - C72) - H71 + L71 + .95 * (ABS(H72 - C73) + ABS(L72 - C73) - H72 + L72 + .95 * (ABS(H73 - C74) + ABS(L73 - C74) - H73 + L73 + .95 * (ABS(H74 - C75) + ABS(L74 - C75) - H74 + L74 + .95 * (ABS(H75 - C76) + ABS(L75 - C76) - H75 + L75 + .95 * (ABS(H76 - C77) + ABS(L76 - C77) - H76 + L76 + .95 * (ABS(H77 - C78) + ABS(L77 - C78) - H77 + L77 + .95 * (ABS(H78 - C79) + ABS(L78 - C79) - H78 + L78 + .95 * (ABS(H79 - C80) + ABS(L79 - C80) - H79 + L79 + .95 * (ABS(H80 - C81) + ABS(L80 - C81) - H80 + L80 + .95 * (ABS(H81 - C82) + ABS(L81 - C82) - H81 + L81 + .95 * (ABS(H82 - C83) + ABS(L82 - C83) - H82 + L82 + .95 * (ABS(H83 - C84) + ABS(L83 - C84) - H83 + L83 + .95 * (ABS(H84 - C85) + ABS(L84 - C85) - H84 + L84 + .95 * (ABS(H85 - C86) + ABS(L85 - C86) - H85 + L85 + .95 * (ABS(H86 - C87) + ABS(L86 - C87) - H86 + L86 + .95 * (ABS(H87 - C88) + ABS(L87 - C88) - H87 + L87 + .95 * (ABS(H88 - C89) + ABS(L88 - C89) - H88 + L88 + .95 * (ABS(H89 - C90) + ABS(L89 - C90) - H89 + L89 + .95 * (ABS(H90 - C91) + ABS(L90 - C91) - H90 + L90 + .95 * (ABS(H91 - C92) + ABS(L91 - C92) - H91 + L91 + .95 * (ABS(H92 - C93) + ABS(L92 - C93) - H92 + L92 + .95 * (ABS(H93 - C94) + ABS(L93 - C94) - H93 + L93 + .95 * (ABS(H94 - C95) + ABS(L94 - C95) - H94 + L94 + .95 * (ABS(H95 - C96) + ABS(L95 - C96) - H95 + L95 + .95 * (ABS(H96 - C97) + ABS(L96 - C97) - H96 + L96 + .95 * (ABS(H97 - C98) + ABS(L97 - C98) - H97 + L97 + .95 * (ABS(H98 - C99) + ABS(L98 - C99) - H98 + L98 + .95 * (ABS(H99 - C100) + ABS(L99 - C100) - H99 + L99 + .95 * (ABS(H100 - C101) + ABS(L100 - C101) - H100 + L100 + .95 * (ABS(H101 - C102) + ABS(L101 - C102) - H101 + L101 + .95 * (ABS(H102 - C103) + ABS(L102 - C103) - H102 + L102 + .95 * (ABS(H103 - C104) + ABS(L103 - C104) - H103 + L103 + .95 * (ABS(H104 - C105) + ABS(L104 - C105) - H104 + L104 + .95 * (ABS(H105 - C106) + ABS(L105 - C106) - H105 + L105 + .95 * (ABS(H106 - C107) + ABS(L106 - C107) - H106 + L106 + .95 * (ABS(H107 - C108) + ABS(L107 - C108) - H107 + L107 + .95 * (ABS(H108 - C109) + ABS(L108 - C109) - H108 + L108 + .95 * (ABS(H109 - C110) + ABS(L109 - C110) - H109 + L109 + .95 * (ABS(H110 - C111) + ABS(L110 - C111) - H110 + L110 + .95 * (ABS(H111 - C112) + ABS(L111 - C112) - H111 + L111 + .95 * (ABS(H112 - C113) + ABS(L112 - C113) - H112 + L112 + .95 * (ABS(H113 - C114) + ABS(L113 - C114) - H113 + L113 + .95 * (ABS(H114 - C115) + ABS(L114 - C115) - H114 + L114 + .95 * (ABS(H115 - C116) + ABS(L115 - C116) - H115 + L115 + .95 * (ABS(H116 - C117) + ABS(L116 - C117) - H116 + L116 + .95 * (ABS(H117 - C118) + ABS(L117 - C118) - H117 + L117 + .95 * (ABS(H118 - C119) + ABS(L118 - C119) - H118 + L118 + .95 * (ABS(H119 - C120) + ABS(L119 - C120) - H119 + L119 + .95 * (ABS(H120 - C121) + ABS(L120 - C121) - H120 + L120 + .95 * (ABS(H121 - C122) + ABS(L121 - C122) - H121 + L121 + .95 * (ABS(H122 - C123) + ABS(L122 - C123) - H122 + L122 + .95 * (ABS(H123 - C124) + ABS(L123 - C124) - H123 + L123 + .95 * (ABS(H124 - C125) + ABS(L124 - C125) - H124 + L124 + .95 * (ABS(H125 - C126) + ABS(L125 - C126) - H125 + L125 + .95 * (ABS(H126 - C127) + ABS(L126 - C127) - H126 + L126 + .95 * (ABS(H127 - C128) + ABS(L127 - C128) - H127 + L127 + .95 * (ABS(H128 - C129) + ABS(L128 - C129) - H128 + L128 + .95 * (ABS(H129 - C130) + ABS(L129 - C130) - H129 + L129 + .95 * (ABS(H130 - C131) + ABS(L130 - C131) - H130 + L130 + .95 * (ABS(H131 - C132) + ABS(L131 - C132) - H131 + L131 + .95 * (ABS(H132 - C133) + ABS(L132 - C133) - H132 + L132 + .95 * (ABS(H133 - C134) + ABS(L133 - C134) - H133 + L133 + .95 * (ABS(H134 - C135) + ABS(L134 - C135) - H134 + L134))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + .000001)
|
I would like to write a PCF for Average True Range (ATR) and was hoping someone had already done this so I wouldn't have to reinvent the wheel.
If not, I know the formula but I am having trouble putting it into Telchart syntax. I need to calculate the maximum number of these three calculations: ABS(H-L) or ABS(H-C1) or ABS(L-C1). But I don't see any way to MAX or IF/THENS.
Would appreciate any help on this problem. Thanks.
|
|