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)

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.

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

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.

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.

You're welcome.