| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 9/1/2006
Posts: 19
|
Hi -
I thought I saw a formula a week or so ago on the boards for a way to create Keltner Channels. Am I imagining this, or was there such a post? If so, and you can provide with that link, I would appreciate, because I have been unable to find it. If not, can you tell me if there is a way to write a PCF for 3 Keltner channels with a 1.75, 2.75 and 3.75?
Thanks for your great service and attention.
Randy
|
|
Registered User
Joined: 12/30/2004
Posts: 369
|
If you do a "search" (top right corner of this page) for "Keltner Channel" you will come up with about two pages of information.
-amberpax
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I found this:
Help with writing a scan
I found this by searching the forums. You too can search these forums for anything. Watch this short video on how to get the most from these forums: Learn how to use the forums: post a new topic, reply, Search existing topics
- Craig
Here to Help!
|
|
 Gold Customer
Joined: 11/9/2004
Posts: 6
|
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)
|
|
Gold Customer
Joined: 11/9/2004
Posts: 6
|
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.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Not as such.
Bruce's formula should not be plotted as a custom indicator. Follow the link in my Sunday, October 08, 2006 6:41:42 AM post above. Doug gives the method for creating a custom channel indicator to plot the Keltner.
Bruce's formula was meant to be used as a PCF in EasyScan.
That being said, you should explore this idea:
Plot the Keltner using Doug's instructions THEN use the Channel Sorting feature in TeleChart to find stocks with a visual channel sort value near either +100 or -100. They will be the onese that either crossed or are threatening to cross.
Check out this short video: Sort using envelopes, regression channels and Bollinger bands
QUOTEIs it possible to put the Keltner Channel formula into a custom indicator and use the result as part of another custom indicator?
Not in TeleChart. We cannot refer to a plotted indictator's value directly in the PCF language. The formula for the plotted inicator must be used.
- Craig
Here to Help!
|
|
Gold Customer
Joined: 11/9/2004
Posts: 6
|
Thanks Craig. I'll try that.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
My pleasure.
- Craig
Here to Help!
|
|
Gold Customer
Joined: 11/9/2004
Posts: 6
|
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.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Try this for me:
Create a new Custom Price Channel with the following settings:
Smoothing Average: 10
Exponential
Width Multiplier: 10
Indicator line formula:
(C+H+L)/3
Channel Width Formula:
H-L
You can then use the Channel sorting method OR Bruce's PCF in EasyScan.
- Craig
Here to Help!
|
|
Gold Customer
Joined: 11/9/2004
Posts: 6
|
Thanks, I'll try that.
|
|
Gold Customer
Joined: 6/29/2005
Posts: 885
|
Hi gentleman
Hope you are well.
I would like to add a basic Keltner Channel
to my chart. I see there are pages of posts about this, using it as indicators and pcfs..
Can you direct me to the appropriate post that tells me how to get this cleanly and simply into my chart with default settings, which I believe are
20 length
1.5 ATR's
 
Thanks much
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
cgross,
Unfortunately, no I can't. There is no universal agreement on how they are actually calculated, so knowing your settings doesn't really help that much. Here are two possibilities (that are rather obviously different):
Select Chart Template | Add Indicator | Price Channel.
- Visible: Checked
- Plot Formula Line: Up to you.
- Smoothing Average: 20
- Average Type: Simple
- Width Multiplier: 15
- Indicator Line Formula: C
- Channel Width Formula: (H - L + ABS(H - C1) + ABS(C1 - L)) / 2
Select Chart Template | Add Indicator | Price Channel.
- Visible: Checked
- Plot Formula Line: Up to you.
- Smoothing Average: 20
- Average Type: Simple
- Width Multiplier: 15
- Indicator Line Formula: (C + H + L) / 3
- Channel Width Formula: H - L
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 6/29/2005
Posts: 885
|
Thanks. I see some folks were trying to replicate the tradestation version settings..Did that ever get resolved.? I think they may have wanted it as a pcf or something, but would there have been a formula for that I could use to put on the chart? That would probably be good enough for my purposes...
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
cgross,
I'm not sure how it is calculated in Tradestation. When I search for Keltner and Tradestation, your post is the only result that comes up. If it uses Average True Range, the first is version from my Monday, July 16, 2007 5:54:45 PM ET post is probably going to be closer than the second.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |