Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 11/19/2015 Posts: 459
|
Hello.
The built-in ATR is in dollars, correct? Is there an absolute-value ATR (in percent)? If not, could you please help me with building one? Thank you.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
ATR is going to be in US dollars for stocks traded on US exchanges.
If you are going to return ATR as a percentage, you need to determine the basis to use for the calculations. If you want to use the previous close.
100 * ATR / C1
If you want to use the current price.
100 * ATR / C
If you want to use something else, just replace the C1 or C in the formula.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/19/2015 Posts: 459
|
Bruce, thank you. This makes sense.
|
|
Registered User Joined: 11/19/2015 Posts: 459
|
To follow up on this, what is the period being averaged for the ATR in th example calcuation? I assume it's one period base on the information in the data window when hovering over the plot and since there's no parameter for the period. I'm looking at WBMD, with a calcuation of .03 percent.
Can the period be used in the same calcuations, like:
100 * ATR(14) /C
|
|
Registered User Joined: 11/19/2015 Posts: 459
|
To add to the above, when I use:
TrueInRow(100 * ATR(14) / C, 5) < .50
as a column condition, I'm not seeing the true condition appear where I expect it to. For example, SPLS has been under .50 for at least 5 days in a row, but it doesn't validate as such using the above....
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
ATR defaults to a period of 1 (which is essentially true range and not average true range). So if you want to use a 14 period average true range, then it can be written exactly as you have already done.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/19/2015 Posts: 459
|
Ah, ok. Yes, I knew that it was the true range, also, but didn't want to assume and thought something else might be happening.
|
|
Registered User Joined: 11/19/2015 Posts: 459
|
Is this it?
100 * ((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) / C
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
100 * ATR(14) / C
Is the same as the longer formula (at least if you are using TC2000 v17).
100 * ((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) / C
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/19/2015 Posts: 459
|
Thank you very much. This helps a ton. Thanks again.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |