Registered User Joined: 5/27/2010 Posts: 153
|
Good Morning Bruce,
Is it possible to write a PCF or scan that can be run intraday to show me a list of stocks that are at or past there Average True Range now, using the ATR of 20 days.
Thank You
|
Worden Staff
Joined: 7/23/2013 Posts: 211
|
Rick17,
The easiest way to do this is with an EasyScan.
First, plot the Average True Range indicator on your chart.
Next, add the Simple Moving Average indicator to the Avearge True Range indicator.
Edit the Average True Range indicator and set the period to 1 (for the ATR now).
Edit the Moving Average period to 20(this is the same as the 20-period ATR).
Now, click on the indicator label for ATR 1 and select Create Scan Condition.
Click the Condition box (Greater Than) and select Above Moving Average 20.
Now you can choose to Add to an Existing Watchlist or Scan -OR- Scan in New Window.
You are ready to Scan.
|
Registered User Joined: 5/27/2010 Posts: 153
|
The results are showing some that are there now and also some that occurred hours ago.
Is there anyway to tighten this to show only the ones that are there now.
Meaning when I scanI would like the results to show only the ones that are still at or past their atr right now and not ones that were earlier and are now back in their atr ranges.
Thank you
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
True Range is defined by subtracting the lower of either the low of the current bar or the close of the previous bar from the higher of either the high of the current bar or the close of the previous bar.
The value of True Range never gets smaller during the day. The True Range can only get bigger.
Average True Range is just a moving average of True Range.
20-Day Average True Range
Price itself is neither higher nor lower than True Range. The scale for price is normally dramatically higher than the scale for True Range or Average True Range.
You could check for the current price being at least the 20-period ATR above the lower of either the low of the current bar or the close of the previous bar using:
C >= (L + C1 - ABS(L - C1)) / 2 + (AVGH20 - AVGL20) / 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) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17) + ABS(H18 - C19) + ABS(C19 - L18) + ABS(H19 - C20) + ABS(C20 - L19)) / 40
You could check for the current price being at least the 20-period ATR below the higher of either the high of the current bar or the low of the previous bar using:
C <= (H + C1 + ABS(H - C1)) / 2 - (AVGH20 - AVGL20) / 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) + ABS(H14 - C15) + ABS(C15 - L14) + ABS(H15 - C16) + ABS(C16 - L15) + ABS(H16 - C17) + ABS(C17 - L16) + ABS(H17 - C18) + ABS(C18 - L17) + ABS(H18 - C19) + ABS(C19 - L18) + ABS(H19 - C20) + ABS(C20 - L19)) / 40
-Bruce Personal Criteria Formulas TC2000 Support Articles
|