Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

ATR Discrepancies Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
truetrend
Posted : Sunday, January 8, 2017 10:29:06 PM
Registered User
Joined: 6/16/2005
Posts: 131

I have inserted both a few of Bruce’s ATR formula’s (from the forums) and the built in Worden formula and I am getting different results. I want to use a 9 period ATR and I need to use it in 3 ways.

1 - I want to have it post the results on the tool bar. I can get this from a PCF ATR, but not from the Worden built in version. How can I have the built in ATR post on the tool bar?

2 - How can I write a PCF where yesterdays range (H1-L1) => 150% of the 9 day ATR?

3 - Which ATR is correct for a 9 period ATR? For example, the below formulas yields a 9 dayATR of 1.67 & 1.39 while TC2000’s built in ATR 9 day yields an ATR of 1.53 (on MSFT). Which is correct?

((AVGH14 - AVGL14) / 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) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

((AVGH14 - AVGL14) / 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) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9) + ABS(H10 - C11) + ABS(C11 - L10) + ABS(H11 - C12) + ABS(C12 - L11) + ABS(H12 - C13) + ABS(C13 - L12) + ABS(H13 - C14) + ABS(C14 - L13)) / 28)

Bruce_L
Posted : Monday, January 9, 2017 10:33:51 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

See those 14s near the beginning of the formula? Those formulas are set up to match a 14 period ATR in TC2000 and not a 9 period ATR. An Indicator Formula for a 9 period average true range would be the following instead (although a much shorter version should be available soon).

(AVGH9 - AVGL9) / 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) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8)) / 18

There isn't a way to add a 9 period average true range to the toolbar without making a Personal Criteria Formula first.

A Condition Fomula for yesterday's range being greater than or equal to 150% of the 9 period average true range as of yesterday can be written as follows.

H1 - L1 >= 1.5 * ((AVGH9.1 - AVGL9.1) / 2 + (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) + ABS(H7 - C8) + ABS(C8 - L7) + ABS(H8 - C9) + ABS(C9 - L8) + ABS(H9 - C10) + ABS(C10 - L9)) / 18)

Both of the formulas given your post return the same value and both match the value of a 14 period ATR.

 



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
truetrend
Posted : Monday, January 9, 2017 12:26:10 PM
Registered User
Joined: 6/16/2005
Posts: 131

Thx Bruce but I am getting a syntax error on the top 9 period ATR indicator formula you posted above.
 

 

Bruce_L
Posted : Monday, January 9, 2017 12:40:03 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

There isn't anything wrong with the formula itself. Try copying and pasting the formula into a text editor (like Notepad and not a word processor like Word). Then copy and paste from the text editor into TC2000.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
truetrend
Posted : Monday, January 9, 2017 1:06:36 PM
Registered User
Joined: 6/16/2005
Posts: 131


A little weird I cannot copy and paste directly from the web site but I can if I paste/copy it into Notepad in between.  Thanks.  I get the same #s for your version and the built in version. 

I'll test the other formula out tonght.

Bruce_L
Posted : Monday, January 9, 2017 1:09:53 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.