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

Aroon Oscillator Equivelant Value 2 days in a row Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
investit
Posted : Tuesday, February 19, 2013 5:09:42 PM
Gold Customer 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

                                                                                                           

StockGuy
Posted : Tuesday, February 19, 2013 5:19:00 PM

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.

Bruce_L
Posted : Wednesday, February 20, 2013 8:20:33 AM


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
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.