Gold Customer
Joined: 7/13/2007 Posts: 28
|
Could you please provide a formula for locating Aroon Oscillator 5 day period values that are equal for two days in a row
in other words -40/-40 0/0 20/20 etc. on the scale from -100 to 100
Thanks,
Investit
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Set your time frame to Daily, then click on Aroon Oscillator and select Create Scan Condition. Set the Condition to Moving Up Net. Set the Period to 1 and > to -.01 (negative value).
Save the condition or add it to a scan.
Repeat and set the 2nd condition to Moving Down Net, period to 1 and < to .01 (positive value).
Add second condition to the same scan.
This will filter the list down to only symbols where Aroon Oscillator moved up or down no more than .01. There could be a a few that slip through but I think 99.9% will all have a net change of 0 on the latest weekly bar.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
StockGuy's solution is probably better, but if you really need a Condition Formula for this, you could try the following:
(L1 = MINL6) * (L1 < L) + 2 * (L2 = MINL6) * (L2 < MINL2) + 3 * (L3 = MINL6) * (L3 < MINL3) + 4 * (L4 = MINL6) * (L4 < MINL4) + 5 * (L5 = MINL6) * (L5 < MINL5) - (H1 = MAXH6) * (H1 > H) - 2 * (H2 = MAXH6) * (H2 > MAXH2) - 3 * (H3 = MAXH6) * (H3 > MAXH3) - 4 * (H4 = MAXH6) * (H4 > MAXH4) - 5 * (H5 = MAXH6) * (H5 > MAXH5) = (L2 = MINL6.1) * (L2 < L1) + 2 * (L3 = MINL6.1) * (L3 < MINL2.1) + 3 * (L4 = MINL6.1) * (L4 < MINL3.1) + 4 * (L5 = MINL6.1) * (L5 < MINL4.1) + 5 * (L6 = MINL6.1) * (L6 < MINL5.1) - (H2 = MAXH6.1) * (H2 > H1) - 2 * (H3 = MAXH6.1) * (H3 > MAXH2.1) - 3 * (H4 = MAXH6.1) * (H4 > MAXH3.1) - 4 * (H5 = MAXH6.1) * (H5 > MAXH4.1) - 5 * (H6 = MAXH6.1) * (H6 > MAXH5.1)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|