Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

ATR ? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
stratone
Posted : Friday, January 12, 2007 3:01:32 PM
Registered User
Joined: 1/1/2007
Posts: 49
How would I write a pcf for An average true range of 7 or above ?
Bruce_L
Posted : Friday, January 12, 2007 3:19:39 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
True Range is the largest of the High minus the Low, the High minus the previous Close or the previous Close minus the Low. A very useful way of calculating this value for the purpose of creating Personal Criteria Formulas is:

(H -L + ABS(H - C1) + ABS(C1 - L)) / 2

Average True Range is the Moving Average of this value and will have different formulas for different periods and Moving Average types. I'm going to use a Period of 7 because that is what was mentioned in the topic that seems to be prompting this request(The mechanics of bottom feeding ?). It could be calculated using a Simple Moving Average:

7-Period Simple Moving Average of True Range:

(AVGH7 - AVGL7) / 2 + (ABS(H - C1) + ABS(C1 - L) + ABS(H1 - C2) + ABS(C2 - L1) + ABS(H2 - C3) + ABS(C3 - L2) + ABS(H3 - C4) + ABS(C4 - L3) + ABS(H4 - C5) + ABS(C5 - L4) + ABS(H5 - C6) + ABS(C6 - L5) + ABS(H6 - C7) + ABS(C7 - L6)) / 14

It is usually calculated using Wilder's Smoothing however. Wilder's Smoothing is a variation of an Exponential Moving Average. You can double the Wilder Period and subtract one to get the Exponential Moving Average Period:

7-Period Average True Range (Wilder's Smoothed):

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

Here's an Exponential version to round things out:

7-Period Exponential Moving Average of True Range:

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

To find if any of these is above 7, just add a > 7 to the end. Based on my reading, this does not specifically appear to be what HaveNoCents is suggesting in the topic mentioned above however. You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
riptide681
Posted : Tuesday, March 6, 2007 10:45:48 AM
Registered User
Joined: 12/13/2006
Posts: 14
Bruce:
How would I add Volume to the PCF so that I would only get stocks that trade above 90,000 shares per day and less than 200,000? Thanks
Craig_S
Posted : Tuesday, March 6, 2007 10:47:48 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
No need for a PCF

Just add Volume 90-day to your EasyScan and limit the VALUE range to 900 to 2000

- Craig
Here to Help!
riptide681
Posted : Tuesday, March 6, 2007 2:05:19 PM
Registered User
Joined: 12/13/2006
Posts: 14
I don't have an easy scan for ATR, can you help me with that?
Bruce_L
Posted : Tuesday, March 6, 2007 2:11:57 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
riptide681,
To create an EasyScan based on Average True Range, create a Personal Criteria Formula for ATR and use it as an EasyScan Condition. You may wish to review the following:

Using EasyScan to find stocks that meet your own criteria

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
riptide681
Posted : Tuesday, March 6, 2007 2:15:15 PM
Registered User
Joined: 12/13/2006
Posts: 14
Thanks Bruce, I will review the instructions, and try it.
Bruce_L
Posted : Tuesday, March 6, 2007 2:15:45 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
riptide681
Posted : Tuesday, March 6, 2007 2:31:35 PM
Registered User
Joined: 12/13/2006
Posts: 14
Hi Bruce, watched the video, but now can you tell me where I can find out about making a personal criteria formula? Thanks
Craig_S
Posted : Tuesday, March 6, 2007 2:33:28 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Check out this video (linked by Bruce above)

How to create a Personal Criteria Forumula (PCF)

You should review all of these videos: If you are new to TeleChart READ THIS FIRST!

- Craig
Here to Help!
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.