Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Stochastic Price Divergences Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Tiago
Posted : Wednesday, September 3, 2014 6:23:15 AM
Registered User
Joined: 2/5/2014
Posts: 3

Hi Folks! I'm trying to creat a formula that scans stochastic price divergences but I can't realize how I program stochastic to measure the actual crossover on stochastic with the 10 previus candles crossover signal! 

On price history my condition is:

L < L1 AND L1 < L2 AND L2 < L3 AND L3 < L4 AND L4 < L5 AND L5 < L6 AND L6 < L7 AND L7 < L8 AND L8 < L9 AND L9 < L10

think that is ok to scan lower lows but now I whant stochastic give me the divergences! I mean when price history goes down (doing a lower low on previous10 candles) I whant to know when the stochastic crossover signal goes up comparing to a previous cross under 20 or near that value.

 

An exempel 

 

Please give me some gidance guys! And correct me if price history scan that I made is wrong (cause when I scan I get just a few results on entire US Stocks, like 2 or 3)!

I'm working on Daily time frame

Bruce_L
Posted : Thursday, September 4, 2014 3:09:05 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

There is nothing wrong with the syntax for your Condition Formula checking for lower lows on each of the ten most recent bars. It is just relatively rare to have that many consecutive lower lows in a row.

A Condition Formula to check for the type of divergence you are attempting to accomplish is relative complicated. It needs to determine the number of bars ago that the most recent crossup under 20 happened so it can calculate both the lows and the stochastics values at the time.

The following Condition Formula uses the techniques in the Days Since Last Peak (or other day-counting needs) topic to calculate these values.

It is quite long even though it is restricted to checking 30 prior bars for the crossup to have happened (it will not check further back without increasing the size of the formula).

It also uses the value of the the low and stochastic from the bar prior to the crossup when comparing values. It does not actually try to determine if those values are the deflection points or not as that would make the formula way too long and slow to be practical or post in the forums.

STOC14.3.1 < 20 AND STOC14.3 > AVG(STOC14.3,3) AND STOC14.3.1 <= AVG(STOC14.3.1,3) AND L1 < ABS(STOC14.3.3 < 20 AND STOC14.3.2 > AVG(STOC14.3.2,3) AND STOC14.3.3 <= AVG(STOC14.3.3,3)) * L3 + ABS(STOC14.3.3 >= 20 OR STOC14.3.2 <= AVG(STOC14.3.2,3) OR STOC14.3.3 > AVG(STOC14.3.3,3)) * (ABS(STOC14.3.4 < 20 AND STOC14.3.3 > AVG(STOC14.3.3,3) AND STOC14.3.4 <= AVG(STOC14.3.4,3)) * L4 + ABS(STOC14.3.4 >= 20 OR STOC14.3.3 <= AVG(STOC14.3.3,3) OR STOC14.3.4 > AVG(STOC14.3.4,3)) * (ABS(STOC14.3.5 < 20 AND STOC14.3.4 > AVG(STOC14.3.4,3) AND STOC14.3.5 <= AVG(STOC14.3.5,3)) * L5 + ABS(STOC14.3.5 >= 20 OR STOC14.3.4 <= AVG(STOC14.3.4,3) OR STOC14.3.5 > AVG(STOC14.3.5,3)) * (ABS(STOC14.3.6 < 20 AND STOC14.3.5 > AVG(STOC14.3.5,3) AND STOC14.3.6 <= AVG(STOC14.3.6,3)) * L6 + ABS(STOC14.3.6 >= 20 OR STOC14.3.5 <= AVG(STOC14.3.5,3) OR STOC14.3.6 > AVG(STOC14.3.6,3)) * (ABS(STOC14.3.7 < 20 AND STOC14.3.6 > AVG(STOC14.3.6,3) AND STOC14.3.7 <= AVG(STOC14.3.7,3)) * L7 + ABS(STOC14.3.7 >= 20 OR STOC14.3.6 <= AVG(STOC14.3.6,3) OR STOC14.3.7 > AVG(STOC14.3.7,3)) * (ABS(STOC14.3.8 < 20 AND STOC14.3.7 > AVG(STOC14.3.7,3) AND STOC14.3.8 <= AVG(STOC14.3.8,3)) * L8 + ABS(STOC14.3.8 >= 20 OR STOC14.3.7 <= AVG(STOC14.3.7,3) OR STOC14.3.8 > AVG(STOC14.3.8,3)) * (ABS(STOC14.3.9 < 20 AND STOC14.3.8 > AVG(STOC14.3.8,3) AND STOC14.3.9 <= AVG(STOC14.3.9,3)) * L9 + ABS(STOC14.3.9 >= 20 OR STOC14.3.8 <= AVG(STOC14.3.8,3) OR STOC14.3.9 > AVG(STOC14.3.9,3)) * (ABS(STOC14.3.10 < 20 AND STOC14.3.9 > AVG(STOC14.3.9,3) AND STOC14.3.10 <= AVG(STOC14.3.10,3)) * L10 + ABS(STOC14.3.10 >= 20 OR STOC14.3.9 <= AVG(STOC14.3.9,3) OR STOC14.3.10 > AVG(STOC14.3.10,3)) * (ABS(STOC14.3.11 < 20 AND STOC14.3.10 > AVG(STOC14.3.10,3) AND STOC14.3.11 <= AVG(STOC14.3.11,3)) * L11 + ABS(STOC14.3.11 >= 20 OR STOC14.3.10 <= AVG(STOC14.3.10,3) OR STOC14.3.11 > AVG(STOC14.3.11,3)) * (ABS(STOC14.3.12 < 20 AND STOC14.3.11 > AVG(STOC14.3.11,3) AND STOC14.3.12 <= AVG(STOC14.3.12,3)) * L12 + ABS(STOC14.3.12 >= 20 OR STOC14.3.11 <= AVG(STOC14.3.11,3) OR STOC14.3.12 > AVG(STOC14.3.12,3)) * (ABS(STOC14.3.13 < 20 AND STOC14.3.12 > AVG(STOC14.3.12,3) AND STOC14.3.13 <= AVG(STOC14.3.13,3)) * L13 + ABS(STOC14.3.13 >= 20 OR STOC14.3.12 <= AVG(STOC14.3.12,3) OR STOC14.3.13 > AVG(STOC14.3.13,3)) * (ABS(STOC14.3.14 < 20 AND STOC14.3.13 > AVG(STOC14.3.13,3) AND STOC14.3.14 <= AVG(STOC14.3.14,3)) * L14 + ABS(STOC14.3.14 >= 20 OR STOC14.3.13 <= AVG(STOC14.3.13,3) OR STOC14.3.14 > AVG(STOC14.3.14,3)) * (ABS(STOC14.3.15 < 20 AND STOC14.3.14 > AVG(STOC14.3.14,3) AND STOC14.3.15 <= AVG(STOC14.3.15,3)) * L15 + ABS(STOC14.3.15 >= 20 OR STOC14.3.14 <= AVG(STOC14.3.14,3) OR STOC14.3.15 > AVG(STOC14.3.15,3)) * (ABS(STOC14.3.16 < 20 AND STOC14.3.15 > AVG(STOC14.3.15,3) AND STOC14.3.16 <= AVG(STOC14.3.16,3)) * L16 + ABS(STOC14.3.16 >= 20 OR STOC14.3.15 <= AVG(STOC14.3.15,3) OR STOC14.3.16 > AVG(STOC14.3.16,3)) * (ABS(STOC14.3.17 < 20 AND STOC14.3.16 > AVG(STOC14.3.16,3) AND STOC14.3.17 <= AVG(STOC14.3.17,3)) * L17 + ABS(STOC14.3.17 >= 20 OR STOC14.3.16 <= AVG(STOC14.3.16,3) OR STOC14.3.17 > AVG(STOC14.3.17,3)) * (ABS(STOC14.3.18 < 20 AND STOC14.3.17 > AVG(STOC14.3.17,3) AND STOC14.3.18 <= AVG(STOC14.3.18,3)) * L18 + ABS(STOC14.3.18 >= 20 OR STOC14.3.17 <= AVG(STOC14.3.17,3) OR STOC14.3.18 > AVG(STOC14.3.18,3)) * (ABS(STOC14.3.19 < 20 AND STOC14.3.18 > AVG(STOC14.3.18,3) AND STOC14.3.19 <= AVG(STOC14.3.19,3)) * L19 + ABS(STOC14.3.19 >= 20 OR STOC14.3.18 <= AVG(STOC14.3.18,3) OR STOC14.3.19 > AVG(STOC14.3.19,3)) * (ABS(STOC14.3.20 < 20 AND STOC14.3.19 > AVG(STOC14.3.19,3) AND STOC14.3.20 <= AVG(STOC14.3.20,3)) * L20 + ABS(STOC14.3.20 >= 20 OR STOC14.3.19 <= AVG(STOC14.3.19,3) OR STOC14.3.20 > AVG(STOC14.3.20,3)) * (ABS(STOC14.3.21 < 20 AND STOC14.3.20 > AVG(STOC14.3.20,3) AND STOC14.3.21 <= AVG(STOC14.3.21,3)) * L21 + ABS(STOC14.3.21 >= 20 OR STOC14.3.20 <= AVG(STOC14.3.20,3) OR STOC14.3.21 > AVG(STOC14.3.21,3)) * (ABS(STOC14.3.22 < 20 AND STOC14.3.21 > AVG(STOC14.3.21,3) AND STOC14.3.22 <= AVG(STOC14.3.22,3)) * L22 + ABS(STOC14.3.22 >= 20 OR STOC14.3.21 <= AVG(STOC14.3.21,3) OR STOC14.3.22 > AVG(STOC14.3.22,3)) * (ABS(STOC14.3.23 < 20 AND STOC14.3.22 > AVG(STOC14.3.22,3) AND STOC14.3.23 <= AVG(STOC14.3.23,3)) * L23 + ABS(STOC14.3.23 >= 20 OR STOC14.3.22 <= AVG(STOC14.3.22,3) OR STOC14.3.23 > AVG(STOC14.3.23,3)) * (ABS(STOC14.3.24 < 20 AND STOC14.3.23 > AVG(STOC14.3.23,3) AND STOC14.3.24 <= AVG(STOC14.3.24,3)) * L24 + ABS(STOC14.3.24 >= 20 OR STOC14.3.23 <= AVG(STOC14.3.23,3) OR STOC14.3.24 > AVG(STOC14.3.24,3)) * (ABS(STOC14.3.25 < 20 AND STOC14.3.24 > AVG(STOC14.3.24,3) AND STOC14.3.25 <= AVG(STOC14.3.25,3)) * L25 + ABS(STOC14.3.25 >= 20 OR STOC14.3.24 <= AVG(STOC14.3.24,3) OR STOC14.3.25 > AVG(STOC14.3.25,3)) * (ABS(STOC14.3.26 < 20 AND STOC14.3.25 > AVG(STOC14.3.25,3) AND STOC14.3.26 <= AVG(STOC14.3.26,3)) * L26 + ABS(STOC14.3.26 >= 20 OR STOC14.3.25 <= AVG(STOC14.3.25,3) OR STOC14.3.26 > AVG(STOC14.3.26,3)) * (ABS(STOC14.3.27 < 20 AND STOC14.3.26 > AVG(STOC14.3.26,3) AND STOC14.3.27 <= AVG(STOC14.3.27,3)) * L27 + ABS(STOC14.3.27 >= 20 OR STOC14.3.26 <= AVG(STOC14.3.26,3) OR STOC14.3.27 > AVG(STOC14.3.27,3)) * (ABS(STOC14.3.28 < 20 AND STOC14.3.27 > AVG(STOC14.3.27,3) AND STOC14.3.28 <= AVG(STOC14.3.28,3)) * L28 + ABS(STOC14.3.28 >= 20 OR STOC14.3.27 <= AVG(STOC14.3.27,3) OR STOC14.3.28 > AVG(STOC14.3.28,3)) * (ABS(STOC14.3.29 < 20 AND STOC14.3.28 > AVG(STOC14.3.28,3) AND STOC14.3.29 <= AVG(STOC14.3.29,3)) * L29 + ABS(STOC14.3.29 >= 20 OR STOC14.3.28 <= AVG(STOC14.3.28,3) OR STOC14.3.29 > AVG(STOC14.3.29,3)) * (ABS(STOC14.3.30 < 20 AND STOC14.3.29 > AVG(STOC14.3.29,3) AND STOC14.3.30 <= AVG(STOC14.3.30,3)) * L30 + ABS(STOC14.3.30 >= 20 OR STOC14.3.29 <= AVG(STOC14.3.29,3) OR STOC14.3.30 > AVG(STOC14.3.30,3)) * (ABS(STOC14.3.31 < 20 AND STOC14.3.30 > AVG(STOC14.3.30,3) AND STOC14.3.31 <= AVG(STOC14.3.31,3)) * L31 + ABS(STOC14.3.31 >= 20 OR STOC14.3.30 <= AVG(STOC14.3.30,3) OR STOC14.3.31 > AVG(STOC14.3.31,3)) * (ABS(STOC14.3.32 < 20 AND STOC14.3.31 > AVG(STOC14.3.31,3) AND STOC14.3.32 <= AVG(STOC14.3.32,3)) * L32 + ABS(STOC14.3.32 >= 20 OR STOC14.3.31 <= AVG(STOC14.3.31,3) OR STOC14.3.32 > AVG(STOC14.3.32,3)) * (L1 - 1)))))))))))))))))))))))))))))) AND STOC14.3.1 > ABS(STOC14.3.3 < 20 AND STOC14.3.2 > AVG(STOC14.3.2,3) AND STOC14.3.3 <= AVG(STOC14.3.3,3)) * STOC14.3.3 + ABS(STOC14.3.3 >= 20 OR STOC14.3.2 <= AVG(STOC14.3.2,3) OR STOC14.3.3 > AVG(STOC14.3.3,3)) * (ABS(STOC14.3.4 < 20 AND STOC14.3.3 > AVG(STOC14.3.3,3) AND STOC14.3.4 <= AVG(STOC14.3.4,3)) * STOC14.3.4 + ABS(STOC14.3.4 >= 20 OR STOC14.3.3 <= AVG(STOC14.3.3,3) OR STOC14.3.4 > AVG(STOC14.3.4,3)) * (ABS(STOC14.3.5 < 20 AND STOC14.3.4 > AVG(STOC14.3.4,3) AND STOC14.3.5 <= AVG(STOC14.3.5,3)) * STOC14.3.5 + ABS(STOC14.3.5 >= 20 OR STOC14.3.4 <= AVG(STOC14.3.4,3) OR STOC14.3.5 > AVG(STOC14.3.5,3)) * (ABS(STOC14.3.6 < 20 AND STOC14.3.5 > AVG(STOC14.3.5,3) AND STOC14.3.6 <= AVG(STOC14.3.6,3)) * STOC14.3.6 + ABS(STOC14.3.6 >= 20 OR STOC14.3.5 <= AVG(STOC14.3.5,3) OR STOC14.3.6 > AVG(STOC14.3.6,3)) * (ABS(STOC14.3.7 < 20 AND STOC14.3.6 > AVG(STOC14.3.6,3) AND STOC14.3.7 <= AVG(STOC14.3.7,3)) * STOC14.3.7 + ABS(STOC14.3.7 >= 20 OR STOC14.3.6 <= AVG(STOC14.3.6,3) OR STOC14.3.7 > AVG(STOC14.3.7,3)) * (ABS(STOC14.3.8 < 20 AND STOC14.3.7 > AVG(STOC14.3.7,3) AND STOC14.3.8 <= AVG(STOC14.3.8,3)) * STOC14.3.8 + ABS(STOC14.3.8 >= 20 OR STOC14.3.7 <= AVG(STOC14.3.7,3) OR STOC14.3.8 > AVG(STOC14.3.8,3)) * (ABS(STOC14.3.9 < 20 AND STOC14.3.8 > AVG(STOC14.3.8,3) AND STOC14.3.9 <= AVG(STOC14.3.9,3)) * STOC14.3.9 + ABS(STOC14.3.9 >= 20 OR STOC14.3.8 <= AVG(STOC14.3.8,3) OR STOC14.3.9 > AVG(STOC14.3.9,3)) * (ABS(STOC14.3.10 < 20 AND STOC14.3.9 > AVG(STOC14.3.9,3) AND STOC14.3.10 <= AVG(STOC14.3.10,3)) * STOC14.3.10 + ABS(STOC14.3.10 >= 20 OR STOC14.3.9 <= AVG(STOC14.3.9,3) OR STOC14.3.10 > AVG(STOC14.3.10,3)) * (ABS(STOC14.3.11 < 20 AND STOC14.3.10 > AVG(STOC14.3.10,3) AND STOC14.3.11 <= AVG(STOC14.3.11,3)) * STOC14.3.11 + ABS(STOC14.3.11 >= 20 OR STOC14.3.10 <= AVG(STOC14.3.10,3) OR STOC14.3.11 > AVG(STOC14.3.11,3)) * (ABS(STOC14.3.12 < 20 AND STOC14.3.11 > AVG(STOC14.3.11,3) AND STOC14.3.12 <= AVG(STOC14.3.12,3)) * STOC14.3.12 + ABS(STOC14.3.12 >= 20 OR STOC14.3.11 <= AVG(STOC14.3.11,3) OR STOC14.3.12 > AVG(STOC14.3.12,3)) * (ABS(STOC14.3.13 < 20 AND STOC14.3.12 > AVG(STOC14.3.12,3) AND STOC14.3.13 <= AVG(STOC14.3.13,3)) * STOC14.3.13 + ABS(STOC14.3.13 >= 20 OR STOC14.3.12 <= AVG(STOC14.3.12,3) OR STOC14.3.13 > AVG(STOC14.3.13,3)) * (ABS(STOC14.3.14 < 20 AND STOC14.3.13 > AVG(STOC14.3.13,3) AND STOC14.3.14 <= AVG(STOC14.3.14,3)) * STOC14.3.14 + ABS(STOC14.3.14 >= 20 OR STOC14.3.13 <= AVG(STOC14.3.13,3) OR STOC14.3.14 > AVG(STOC14.3.14,3)) * (ABS(STOC14.3.15 < 20 AND STOC14.3.14 > AVG(STOC14.3.14,3) AND STOC14.3.15 <= AVG(STOC14.3.15,3)) * STOC14.3.15 + ABS(STOC14.3.15 >= 20 OR STOC14.3.14 <= AVG(STOC14.3.14,3) OR STOC14.3.15 > AVG(STOC14.3.15,3)) * (ABS(STOC14.3.16 < 20 AND STOC14.3.15 > AVG(STOC14.3.15,3) AND STOC14.3.16 <= AVG(STOC14.3.16,3)) * STOC14.3.16 + ABS(STOC14.3.16 >= 20 OR STOC14.3.15 <= AVG(STOC14.3.15,3) OR STOC14.3.16 > AVG(STOC14.3.16,3)) * (ABS(STOC14.3.17 < 20 AND STOC14.3.16 > AVG(STOC14.3.16,3) AND STOC14.3.17 <= AVG(STOC14.3.17,3)) * STOC14.3.17 + ABS(STOC14.3.17 >= 20 OR STOC14.3.16 <= AVG(STOC14.3.16,3) OR STOC14.3.17 > AVG(STOC14.3.17,3)) * (ABS(STOC14.3.18 < 20 AND STOC14.3.17 > AVG(STOC14.3.17,3) AND STOC14.3.18 <= AVG(STOC14.3.18,3)) * STOC14.3.18 + ABS(STOC14.3.18 >= 20 OR STOC14.3.17 <= AVG(STOC14.3.17,3) OR STOC14.3.18 > AVG(STOC14.3.18,3)) * (ABS(STOC14.3.19 < 20 AND STOC14.3.18 > AVG(STOC14.3.18,3) AND STOC14.3.19 <= AVG(STOC14.3.19,3)) * STOC14.3.19 + ABS(STOC14.3.19 >= 20 OR STOC14.3.18 <= AVG(STOC14.3.18,3) OR STOC14.3.19 > AVG(STOC14.3.19,3)) * (ABS(STOC14.3.20 < 20 AND STOC14.3.19 > AVG(STOC14.3.19,3) AND STOC14.3.20 <= AVG(STOC14.3.20,3)) * STOC14.3.20 + ABS(STOC14.3.20 >= 20 OR STOC14.3.19 <= AVG(STOC14.3.19,3) OR STOC14.3.20 > AVG(STOC14.3.20,3)) * (ABS(STOC14.3.21 < 20 AND STOC14.3.20 > AVG(STOC14.3.20,3) AND STOC14.3.21 <= AVG(STOC14.3.21,3)) * STOC14.3.21 + ABS(STOC14.3.21 >= 20 OR STOC14.3.20 <= AVG(STOC14.3.20,3) OR STOC14.3.21 > AVG(STOC14.3.21,3)) * (ABS(STOC14.3.22 < 20 AND STOC14.3.21 > AVG(STOC14.3.21,3) AND STOC14.3.22 <= AVG(STOC14.3.22,3)) * STOC14.3.22 + ABS(STOC14.3.22 >= 20 OR STOC14.3.21 <= AVG(STOC14.3.21,3) OR STOC14.3.22 > AVG(STOC14.3.22,3)) * (ABS(STOC14.3.23 < 20 AND STOC14.3.22 > AVG(STOC14.3.22,3) AND STOC14.3.23 <= AVG(STOC14.3.23,3)) * STOC14.3.23 + ABS(STOC14.3.23 >= 20 OR STOC14.3.22 <= AVG(STOC14.3.22,3) OR STOC14.3.23 > AVG(STOC14.3.23,3)) * (ABS(STOC14.3.24 < 20 AND STOC14.3.23 > AVG(STOC14.3.23,3) AND STOC14.3.24 <= AVG(STOC14.3.24,3)) * STOC14.3.24 + ABS(STOC14.3.24 >= 20 OR STOC14.3.23 <= AVG(STOC14.3.23,3) OR STOC14.3.24 > AVG(STOC14.3.24,3)) * (ABS(STOC14.3.25 < 20 AND STOC14.3.24 > AVG(STOC14.3.24,3) AND STOC14.3.25 <= AVG(STOC14.3.25,3)) * STOC14.3.25 + ABS(STOC14.3.25 >= 20 OR STOC14.3.24 <= AVG(STOC14.3.24,3) OR STOC14.3.25 > AVG(STOC14.3.25,3)) * (ABS(STOC14.3.26 < 20 AND STOC14.3.25 > AVG(STOC14.3.25,3) AND STOC14.3.26 <= AVG(STOC14.3.26,3)) * STOC14.3.26 + ABS(STOC14.3.26 >= 20 OR STOC14.3.25 <= AVG(STOC14.3.25,3) OR STOC14.3.26 > AVG(STOC14.3.26,3)) * (ABS(STOC14.3.27 < 20 AND STOC14.3.26 > AVG(STOC14.3.26,3) AND STOC14.3.27 <= AVG(STOC14.3.27,3)) * STOC14.3.27 + ABS(STOC14.3.27 >= 20 OR STOC14.3.26 <= AVG(STOC14.3.26,3) OR STOC14.3.27 > AVG(STOC14.3.27,3)) * (ABS(STOC14.3.28 < 20 AND STOC14.3.27 > AVG(STOC14.3.27,3) AND STOC14.3.28 <= AVG(STOC14.3.28,3)) * STOC14.3.28 + ABS(STOC14.3.28 >= 20 OR STOC14.3.27 <= AVG(STOC14.3.27,3) OR STOC14.3.28 > AVG(STOC14.3.28,3)) * (ABS(STOC14.3.29 < 20 AND STOC14.3.28 > AVG(STOC14.3.28,3) AND STOC14.3.29 <= AVG(STOC14.3.29,3)) * STOC14.3.29 + ABS(STOC14.3.29 >= 20 OR STOC14.3.28 <= AVG(STOC14.3.28,3) OR STOC14.3.29 > AVG(STOC14.3.29,3)) * (ABS(STOC14.3.30 < 20 AND STOC14.3.29 > AVG(STOC14.3.29,3) AND STOC14.3.30 <= AVG(STOC14.3.30,3)) * STOC14.3.30 + ABS(STOC14.3.30 >= 20 OR STOC14.3.29 <= AVG(STOC14.3.29,3) OR STOC14.3.30 > AVG(STOC14.3.30,3)) * (ABS(STOC14.3.31 < 20 AND STOC14.3.30 > AVG(STOC14.3.30,3) AND STOC14.3.31 <= AVG(STOC14.3.31,3)) * STOC14.3.31 + ABS(STOC14.3.31 >= 20 OR STOC14.3.30 <= AVG(STOC14.3.30,3) OR STOC14.3.31 > AVG(STOC14.3.31,3)) * (ABS(STOC14.3.32 < 20 AND STOC14.3.31 > AVG(STOC14.3.31,3) AND STOC14.3.32 <= AVG(STOC14.3.32,3)) * STOC14.3.32 + ABS(STOC14.3.32 >= 20 OR STOC14.3.31 <= AVG(STOC14.3.31,3) OR STOC14.3.32 > AVG(STOC14.3.32,3)) * (STOC14.3.1 + 1))))))))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Tiago
Posted : Thursday, September 4, 2014 6:59:33 PM
Registered User
Joined: 2/5/2014
Posts: 3
is slow but it works just fine! I never thought that you would do something that specific but I'm very thankful for that.
 
Thanks Bruce
go4it
Posted : Thursday, September 4, 2014 9:20:00 PM
Registered User
Joined: 10/7/2004
Posts: 18

Would it be simpler to calculate a slope angle (slope index) in relation to a horizontal 0 line i.e. upward or positive (+)  and downward or negative (-) for the or stochastic,  compared to the slope index of price over x number of days?

It would seem that the difference in slope is the more critical factor here.

And then, could a PCF be created to show a variable for the difference between the two.  This could be sorted  to survey charts with small or large differences in their slope angles between stochastic and price.

Also, his method could likely be used to show divergences between ANY 2 plots, be it two indicators or price + any other indicator.

I had created a slope index indicator with a single factor to evaluate the upward or downward slope of TSV  for sorting using TSV slope, but until now I never thought of using it to compare to the price trend via a variable.

Do you think it would work, Bruce?

go4it

Bruce_L
Posted : Friday, September 5, 2014 9:52:24 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

We suggest simple scans like this for divergence all the time. While it doesn't take into account all the intricacies of the traditional divergence pattern, it usually finds very similar candidates.

A simple way to search for a divergence between Price History and Stochastics over the most recent 10-bars.

Click on Price History and select Create Scan Condition. Then select Moving Up from the Condition drop-down menu. Then set the Period of the Condition to the number of bars over which you wish to check for a divergence (in this case, 10).

Create Conditions from Your Chart (5:25)

Then do the same thing with the Stochastics indicator, but choose Moving Down instead of Moving Up.

You can then add both the Conditions to the same EasyScan. Checking for a divergence where Price History was Moving Down and Stochastics was Moving Up would just be a matter of switching around how you created the Conditions.

Building a Scan with Multiple Conditions (7:29)

Creating a "slope index" for both price and stochastics (or TSV) and then adding then combining them is a bit more difficult because the scales for price and stochastic (or TSV) are quite different.

You would probably want to use percent change for price (or probably a multiple of percent change) and net change for stochastics. You could get complicated and use linear regression lines to calculate a percent slope for price and a net slope for stochastics, but I don't know if it would work any better than just the net change.

This may sound odd, but you might actually want to take a stochastic of the TSV if you need to create a slope index of some sort that needs to be combined with price. A PCF for this is fairly straightforward with a simple TSV and almost impossible for an exponential TSV. You could then compare the TSV to a percent change in price or maybe to a stochastic of price.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Tiago
Posted : Thursday, November 20, 2014 2:30:07 PM
Registered User
Joined: 2/5/2014
Posts: 3

Hi again! I'm here one more time to ask please for a pcf code that can scan divergences but this time the conditions are the inverse:

Stochastic making new lows while the price makes new relative highs!
It's the exact same periods! I already changed this PCF code that you gave me a while ago, I changed the ABS(STOC14.3.27 >= 20 to ABS(STOC14.3.27 <= 80 and all the other code that contains <20 to >80!
 
Obviously didn't work and I can't figure this out. How can I recicle this pcf code to build the inverse indicator signal? 
 
Thank you for your time!
Bruce_L
Posted : Thursday, November 20, 2014 4:18:38 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try the following.

STOC14.3.1 > 80 AND STOC14.3 < AVG(STOC14.3,3) AND STOC14.3.1 >= AVG(STOC14.3.1,3) AND H1 > ABS(STOC14.3.3 > 80 AND STOC14.3.2 < AVG(STOC14.3.2,3) AND STOC14.3.3 >= AVG(STOC14.3.3,3)) * H3 + ABS(STOC14.3.3 <= 80 OR STOC14.3.2 >= AVG(STOC14.3.2,3) OR STOC14.3.3 < AVG(STOC14.3.3,3)) * (ABS(STOC14.3.4 > 80 AND STOC14.3.3 < AVG(STOC14.3.3,3) AND STOC14.3.4 >= AVG(STOC14.3.4,3)) * H4 + ABS(STOC14.3.4 <= 80 OR STOC14.3.3 >= AVG(STOC14.3.3,3) OR STOC14.3.4 < AVG(STOC14.3.4,3)) * (ABS(STOC14.3.5 > 80 AND STOC14.3.4 < AVG(STOC14.3.4,3) AND STOC14.3.5 >= AVG(STOC14.3.5,3)) * H5 + ABS(STOC14.3.5 <= 80 OR STOC14.3.4 >= AVG(STOC14.3.4,3) OR STOC14.3.5 < AVG(STOC14.3.5,3)) * (ABS(STOC14.3.6 > 80 AND STOC14.3.5 < AVG(STOC14.3.5,3) AND STOC14.3.6 >= AVG(STOC14.3.6,3)) * H6 + ABS(STOC14.3.6 <= 80 OR STOC14.3.5 >= AVG(STOC14.3.5,3) OR STOC14.3.6 < AVG(STOC14.3.6,3)) * (ABS(STOC14.3.7 > 80 AND STOC14.3.6 < AVG(STOC14.3.6,3) AND STOC14.3.7 >= AVG(STOC14.3.7,3)) * H7 + ABS(STOC14.3.7 <= 80 OR STOC14.3.6 >= AVG(STOC14.3.6,3) OR STOC14.3.7 < AVG(STOC14.3.7,3)) * (ABS(STOC14.3.8 > 80 AND STOC14.3.7 < AVG(STOC14.3.7,3) AND STOC14.3.8 >= AVG(STOC14.3.8,3)) * H8 + ABS(STOC14.3.8 <= 80 OR STOC14.3.7 >= AVG(STOC14.3.7,3) OR STOC14.3.8 < AVG(STOC14.3.8,3)) * (ABS(STOC14.3.9 > 80 AND STOC14.3.8 < AVG(STOC14.3.8,3) AND STOC14.3.9 >= AVG(STOC14.3.9,3)) * H9 + ABS(STOC14.3.9 <= 80 OR STOC14.3.8 >= AVG(STOC14.3.8,3) OR STOC14.3.9 < AVG(STOC14.3.9,3)) * (ABS(STOC14.3.10 > 80 AND STOC14.3.9 < AVG(STOC14.3.9,3) AND STOC14.3.10 >= AVG(STOC14.3.10,3)) * H10 + ABS(STOC14.3.10 <= 80 OR STOC14.3.9 >= AVG(STOC14.3.9,3) OR STOC14.3.10 < AVG(STOC14.3.10,3)) * (ABS(STOC14.3.11 > 80 AND STOC14.3.10 < AVG(STOC14.3.10,3) AND STOC14.3.11 >= AVG(STOC14.3.11,3)) * H11 + ABS(STOC14.3.11 <= 80 OR STOC14.3.10 >= AVG(STOC14.3.10,3) OR STOC14.3.11 < AVG(STOC14.3.11,3)) * (ABS(STOC14.3.12 > 80 AND STOC14.3.11 < AVG(STOC14.3.11,3) AND STOC14.3.12 >= AVG(STOC14.3.12,3)) * H12 + ABS(STOC14.3.12 <= 80 OR STOC14.3.11 >= AVG(STOC14.3.11,3) OR STOC14.3.12 < AVG(STOC14.3.12,3)) * (ABS(STOC14.3.13 > 80 AND STOC14.3.12 < AVG(STOC14.3.12,3) AND STOC14.3.13 >= AVG(STOC14.3.13,3)) * H13 + ABS(STOC14.3.13 <= 80 OR STOC14.3.12 >= AVG(STOC14.3.12,3) OR STOC14.3.13 < AVG(STOC14.3.13,3)) * (ABS(STOC14.3.14 > 80 AND STOC14.3.13 < AVG(STOC14.3.13,3) AND STOC14.3.14 >= AVG(STOC14.3.14,3)) * H14 + ABS(STOC14.3.14 <= 80 OR STOC14.3.13 >= AVG(STOC14.3.13,3) OR STOC14.3.14 < AVG(STOC14.3.14,3)) * (ABS(STOC14.3.15 > 80 AND STOC14.3.14 < AVG(STOC14.3.14,3) AND STOC14.3.15 >= AVG(STOC14.3.15,3)) * H15 + ABS(STOC14.3.15 <= 80 OR STOC14.3.14 >= AVG(STOC14.3.14,3) OR STOC14.3.15 < AVG(STOC14.3.15,3)) * (ABS(STOC14.3.16 > 80 AND STOC14.3.15 < AVG(STOC14.3.15,3) AND STOC14.3.16 >= AVG(STOC14.3.16,3)) * H16 + ABS(STOC14.3.16 <= 80 OR STOC14.3.15 >= AVG(STOC14.3.15,3) OR STOC14.3.16 < AVG(STOC14.3.16,3)) * (ABS(STOC14.3.17 > 80 AND STOC14.3.16 < AVG(STOC14.3.16,3) AND STOC14.3.17 >= AVG(STOC14.3.17,3)) * H17 + ABS(STOC14.3.17 <= 80 OR STOC14.3.16 >= AVG(STOC14.3.16,3) OR STOC14.3.17 < AVG(STOC14.3.17,3)) * (ABS(STOC14.3.18 > 80 AND STOC14.3.17 < AVG(STOC14.3.17,3) AND STOC14.3.18 >= AVG(STOC14.3.18,3)) * H18 + ABS(STOC14.3.18 <= 80 OR STOC14.3.17 >= AVG(STOC14.3.17,3) OR STOC14.3.18 < AVG(STOC14.3.18,3)) * (ABS(STOC14.3.19 > 80 AND STOC14.3.18 < AVG(STOC14.3.18,3) AND STOC14.3.19 >= AVG(STOC14.3.19,3)) * H19 + ABS(STOC14.3.19 <= 80 OR STOC14.3.18 >= AVG(STOC14.3.18,3) OR STOC14.3.19 < AVG(STOC14.3.19,3)) * (ABS(STOC14.3.20 > 80 AND STOC14.3.19 < AVG(STOC14.3.19,3) AND STOC14.3.20 >= AVG(STOC14.3.20,3)) * H20 + ABS(STOC14.3.20 <= 80 OR STOC14.3.19 >= AVG(STOC14.3.19,3) OR STOC14.3.20 < AVG(STOC14.3.20,3)) * (ABS(STOC14.3.21 > 80 AND STOC14.3.20 < AVG(STOC14.3.20,3) AND STOC14.3.21 >= AVG(STOC14.3.21,3)) * H21 + ABS(STOC14.3.21 <= 80 OR STOC14.3.20 >= AVG(STOC14.3.20,3) OR STOC14.3.21 < AVG(STOC14.3.21,3)) * (ABS(STOC14.3.22 > 80 AND STOC14.3.21 < AVG(STOC14.3.21,3) AND STOC14.3.22 >= AVG(STOC14.3.22,3)) * H22 + ABS(STOC14.3.22 <= 80 OR STOC14.3.21 >= AVG(STOC14.3.21,3) OR STOC14.3.22 < AVG(STOC14.3.22,3)) * (ABS(STOC14.3.23 > 80 AND STOC14.3.22 < AVG(STOC14.3.22,3) AND STOC14.3.23 >= AVG(STOC14.3.23,3)) * H23 + ABS(STOC14.3.23 <= 80 OR STOC14.3.22 >= AVG(STOC14.3.22,3) OR STOC14.3.23 < AVG(STOC14.3.23,3)) * (ABS(STOC14.3.24 > 80 AND STOC14.3.23 < AVG(STOC14.3.23,3) AND STOC14.3.24 >= AVG(STOC14.3.24,3)) * H24 + ABS(STOC14.3.24 <= 80 OR STOC14.3.23 >= AVG(STOC14.3.23,3) OR STOC14.3.24 < AVG(STOC14.3.24,3)) * (ABS(STOC14.3.25 > 80 AND STOC14.3.24 < AVG(STOC14.3.24,3) AND STOC14.3.25 >= AVG(STOC14.3.25,3)) * H25 + ABS(STOC14.3.25 <= 80 OR STOC14.3.24 >= AVG(STOC14.3.24,3) OR STOC14.3.25 < AVG(STOC14.3.25,3)) * (ABS(STOC14.3.26 > 80 AND STOC14.3.25 < AVG(STOC14.3.25,3) AND STOC14.3.26 >= AVG(STOC14.3.26,3)) * H26 + ABS(STOC14.3.26 <= 80 OR STOC14.3.25 >= AVG(STOC14.3.25,3) OR STOC14.3.26 < AVG(STOC14.3.26,3)) * (ABS(STOC14.3.27 > 80 AND STOC14.3.26 < AVG(STOC14.3.26,3) AND STOC14.3.27 >= AVG(STOC14.3.27,3)) * H27 + ABS(STOC14.3.27 <= 80 OR STOC14.3.26 >= AVG(STOC14.3.26,3) OR STOC14.3.27 < AVG(STOC14.3.27,3)) * (ABS(STOC14.3.28 > 80 AND STOC14.3.27 < AVG(STOC14.3.27,3) AND STOC14.3.28 >= AVG(STOC14.3.28,3)) * H28 + ABS(STOC14.3.28 <= 80 OR STOC14.3.27 >= AVG(STOC14.3.27,3) OR STOC14.3.28 < AVG(STOC14.3.28,3)) * (ABS(STOC14.3.29 > 80 AND STOC14.3.28 < AVG(STOC14.3.28,3) AND STOC14.3.29 >= AVG(STOC14.3.29,3)) * H29 + ABS(STOC14.3.29 <= 80 OR STOC14.3.28 >= AVG(STOC14.3.28,3) OR STOC14.3.29 < AVG(STOC14.3.29,3)) * (ABS(STOC14.3.30 > 80 AND STOC14.3.29 < AVG(STOC14.3.29,3) AND STOC14.3.30 >= AVG(STOC14.3.30,3)) * H30 + ABS(STOC14.3.30 <= 80 OR STOC14.3.29 >= AVG(STOC14.3.29,3) OR STOC14.3.30 < AVG(STOC14.3.30,3)) * (ABS(STOC14.3.31 > 80 AND STOC14.3.30 < AVG(STOC14.3.30,3) AND STOC14.3.31 >= AVG(STOC14.3.31,3)) * H31 + ABS(STOC14.3.31 <= 80 OR STOC14.3.30 >= AVG(STOC14.3.30,3) OR STOC14.3.31 < AVG(STOC14.3.31,3)) * (ABS(STOC14.3.32 > 80 AND STOC14.3.31 < AVG(STOC14.3.31,3) AND STOC14.3.32 >= AVG(STOC14.3.32,3)) * H32 + ABS(STOC14.3.32 <= 80 OR STOC14.3.31 >= AVG(STOC14.3.31,3) OR STOC14.3.32 < AVG(STOC14.3.32,3)) * (H1 + 1)))))))))))))))))))))))))))))) AND STOC14.3.1 < ABS(STOC14.3.3 > 80 AND STOC14.3.2 < AVG(STOC14.3.2,3) AND STOC14.3.3 >= AVG(STOC14.3.3,3)) * STOC14.3.3 + ABS(STOC14.3.3 <= 80 OR STOC14.3.2 >= AVG(STOC14.3.2,3) OR STOC14.3.3 < AVG(STOC14.3.3,3)) * (ABS(STOC14.3.4 > 80 AND STOC14.3.3 < AVG(STOC14.3.3,3) AND STOC14.3.4 >= AVG(STOC14.3.4,3)) * STOC14.3.4 + ABS(STOC14.3.4 <= 80 OR STOC14.3.3 >= AVG(STOC14.3.3,3) OR STOC14.3.4 < AVG(STOC14.3.4,3)) * (ABS(STOC14.3.5 > 80 AND STOC14.3.4 < AVG(STOC14.3.4,3) AND STOC14.3.5 >= AVG(STOC14.3.5,3)) * STOC14.3.5 + ABS(STOC14.3.5 <= 80 OR STOC14.3.4 >= AVG(STOC14.3.4,3) OR STOC14.3.5 < AVG(STOC14.3.5,3)) * (ABS(STOC14.3.6 > 80 AND STOC14.3.5 < AVG(STOC14.3.5,3) AND STOC14.3.6 >= AVG(STOC14.3.6,3)) * STOC14.3.6 + ABS(STOC14.3.6 <= 80 OR STOC14.3.5 >= AVG(STOC14.3.5,3) OR STOC14.3.6 < AVG(STOC14.3.6,3)) * (ABS(STOC14.3.7 > 80 AND STOC14.3.6 < AVG(STOC14.3.6,3) AND STOC14.3.7 >= AVG(STOC14.3.7,3)) * STOC14.3.7 + ABS(STOC14.3.7 <= 80 OR STOC14.3.6 >= AVG(STOC14.3.6,3) OR STOC14.3.7 < AVG(STOC14.3.7,3)) * (ABS(STOC14.3.8 > 80 AND STOC14.3.7 < AVG(STOC14.3.7,3) AND STOC14.3.8 >= AVG(STOC14.3.8,3)) * STOC14.3.8 + ABS(STOC14.3.8 <= 80 OR STOC14.3.7 >= AVG(STOC14.3.7,3) OR STOC14.3.8 < AVG(STOC14.3.8,3)) * (ABS(STOC14.3.9 > 80 AND STOC14.3.8 < AVG(STOC14.3.8,3) AND STOC14.3.9 >= AVG(STOC14.3.9,3)) * STOC14.3.9 + ABS(STOC14.3.9 <= 80 OR STOC14.3.8 >= AVG(STOC14.3.8,3) OR STOC14.3.9 < AVG(STOC14.3.9,3)) * (ABS(STOC14.3.10 > 80 AND STOC14.3.9 < AVG(STOC14.3.9,3) AND STOC14.3.10 >= AVG(STOC14.3.10,3)) * STOC14.3.10 + ABS(STOC14.3.10 <= 80 OR STOC14.3.9 >= AVG(STOC14.3.9,3) OR STOC14.3.10 < AVG(STOC14.3.10,3)) * (ABS(STOC14.3.11 > 80 AND STOC14.3.10 < AVG(STOC14.3.10,3) AND STOC14.3.11 >= AVG(STOC14.3.11,3)) * STOC14.3.11 + ABS(STOC14.3.11 <= 80 OR STOC14.3.10 >= AVG(STOC14.3.10,3) OR STOC14.3.11 < AVG(STOC14.3.11,3)) * (ABS(STOC14.3.12 > 80 AND STOC14.3.11 < AVG(STOC14.3.11,3) AND STOC14.3.12 >= AVG(STOC14.3.12,3)) * STOC14.3.12 + ABS(STOC14.3.12 <= 80 OR STOC14.3.11 >= AVG(STOC14.3.11,3) OR STOC14.3.12 < AVG(STOC14.3.12,3)) * (ABS(STOC14.3.13 > 80 AND STOC14.3.12 < AVG(STOC14.3.12,3) AND STOC14.3.13 >= AVG(STOC14.3.13,3)) * STOC14.3.13 + ABS(STOC14.3.13 <= 80 OR STOC14.3.12 >= AVG(STOC14.3.12,3) OR STOC14.3.13 < AVG(STOC14.3.13,3)) * (ABS(STOC14.3.14 > 80 AND STOC14.3.13 < AVG(STOC14.3.13,3) AND STOC14.3.14 >= AVG(STOC14.3.14,3)) * STOC14.3.14 + ABS(STOC14.3.14 <= 80 OR STOC14.3.13 >= AVG(STOC14.3.13,3) OR STOC14.3.14 < AVG(STOC14.3.14,3)) * (ABS(STOC14.3.15 > 80 AND STOC14.3.14 < AVG(STOC14.3.14,3) AND STOC14.3.15 >= AVG(STOC14.3.15,3)) * STOC14.3.15 + ABS(STOC14.3.15 <= 80 OR STOC14.3.14 >= AVG(STOC14.3.14,3) OR STOC14.3.15 < AVG(STOC14.3.15,3)) * (ABS(STOC14.3.16 > 80 AND STOC14.3.15 < AVG(STOC14.3.15,3) AND STOC14.3.16 >= AVG(STOC14.3.16,3)) * STOC14.3.16 + ABS(STOC14.3.16 <= 80 OR STOC14.3.15 >= AVG(STOC14.3.15,3) OR STOC14.3.16 < AVG(STOC14.3.16,3)) * (ABS(STOC14.3.17 > 80 AND STOC14.3.16 < AVG(STOC14.3.16,3) AND STOC14.3.17 >= AVG(STOC14.3.17,3)) * STOC14.3.17 + ABS(STOC14.3.17 <= 80 OR STOC14.3.16 >= AVG(STOC14.3.16,3) OR STOC14.3.17 < AVG(STOC14.3.17,3)) * (ABS(STOC14.3.18 > 80 AND STOC14.3.17 < AVG(STOC14.3.17,3) AND STOC14.3.18 >= AVG(STOC14.3.18,3)) * STOC14.3.18 + ABS(STOC14.3.18 <= 80 OR STOC14.3.17 >= AVG(STOC14.3.17,3) OR STOC14.3.18 < AVG(STOC14.3.18,3)) * (ABS(STOC14.3.19 > 80 AND STOC14.3.18 < AVG(STOC14.3.18,3) AND STOC14.3.19 >= AVG(STOC14.3.19,3)) * STOC14.3.19 + ABS(STOC14.3.19 <= 80 OR STOC14.3.18 >= AVG(STOC14.3.18,3) OR STOC14.3.19 < AVG(STOC14.3.19,3)) * (ABS(STOC14.3.20 > 80 AND STOC14.3.19 < AVG(STOC14.3.19,3) AND STOC14.3.20 >= AVG(STOC14.3.20,3)) * STOC14.3.20 + ABS(STOC14.3.20 <= 80 OR STOC14.3.19 >= AVG(STOC14.3.19,3) OR STOC14.3.20 < AVG(STOC14.3.20,3)) * (ABS(STOC14.3.21 > 80 AND STOC14.3.20 < AVG(STOC14.3.20,3) AND STOC14.3.21 >= AVG(STOC14.3.21,3)) * STOC14.3.21 + ABS(STOC14.3.21 <= 80 OR STOC14.3.20 >= AVG(STOC14.3.20,3) OR STOC14.3.21 < AVG(STOC14.3.21,3)) * (ABS(STOC14.3.22 > 80 AND STOC14.3.21 < AVG(STOC14.3.21,3) AND STOC14.3.22 >= AVG(STOC14.3.22,3)) * STOC14.3.22 + ABS(STOC14.3.22 <= 80 OR STOC14.3.21 >= AVG(STOC14.3.21,3) OR STOC14.3.22 < AVG(STOC14.3.22,3)) * (ABS(STOC14.3.23 > 80 AND STOC14.3.22 < AVG(STOC14.3.22,3) AND STOC14.3.23 >= AVG(STOC14.3.23,3)) * STOC14.3.23 + ABS(STOC14.3.23 <= 80 OR STOC14.3.22 >= AVG(STOC14.3.22,3) OR STOC14.3.23 < AVG(STOC14.3.23,3)) * (ABS(STOC14.3.24 > 80 AND STOC14.3.23 < AVG(STOC14.3.23,3) AND STOC14.3.24 >= AVG(STOC14.3.24,3)) * STOC14.3.24 + ABS(STOC14.3.24 <= 80 OR STOC14.3.23 >= AVG(STOC14.3.23,3) OR STOC14.3.24 < AVG(STOC14.3.24,3)) * (ABS(STOC14.3.25 > 80 AND STOC14.3.24 < AVG(STOC14.3.24,3) AND STOC14.3.25 >= AVG(STOC14.3.25,3)) * STOC14.3.25 + ABS(STOC14.3.25 <= 80 OR STOC14.3.24 >= AVG(STOC14.3.24,3) OR STOC14.3.25 < AVG(STOC14.3.25,3)) * (ABS(STOC14.3.26 > 80 AND STOC14.3.25 < AVG(STOC14.3.25,3) AND STOC14.3.26 >= AVG(STOC14.3.26,3)) * STOC14.3.26 + ABS(STOC14.3.26 <= 80 OR STOC14.3.25 >= AVG(STOC14.3.25,3) OR STOC14.3.26 < AVG(STOC14.3.26,3)) * (ABS(STOC14.3.27 > 80 AND STOC14.3.26 < AVG(STOC14.3.26,3) AND STOC14.3.27 >= AVG(STOC14.3.27,3)) * STOC14.3.27 + ABS(STOC14.3.27 <= 80 OR STOC14.3.26 >= AVG(STOC14.3.26,3) OR STOC14.3.27 < AVG(STOC14.3.27,3)) * (ABS(STOC14.3.28 > 80 AND STOC14.3.27 < AVG(STOC14.3.27,3) AND STOC14.3.28 >= AVG(STOC14.3.28,3)) * STOC14.3.28 + ABS(STOC14.3.28 <= 80 OR STOC14.3.27 >= AVG(STOC14.3.27,3) OR STOC14.3.28 < AVG(STOC14.3.28,3)) * (ABS(STOC14.3.29 > 80 AND STOC14.3.28 < AVG(STOC14.3.28,3) AND STOC14.3.29 >= AVG(STOC14.3.29,3)) * STOC14.3.29 + ABS(STOC14.3.29 <= 80 OR STOC14.3.28 >= AVG(STOC14.3.28,3) OR STOC14.3.29 < AVG(STOC14.3.29,3)) * (ABS(STOC14.3.30 > 80 AND STOC14.3.29 < AVG(STOC14.3.29,3) AND STOC14.3.30 >= AVG(STOC14.3.30,3)) * STOC14.3.30 + ABS(STOC14.3.30 <= 80 OR STOC14.3.29 >= AVG(STOC14.3.29,3) OR STOC14.3.30 < AVG(STOC14.3.30,3)) * (ABS(STOC14.3.31 > 80 AND STOC14.3.30 < AVG(STOC14.3.30,3) AND STOC14.3.31 >= AVG(STOC14.3.31,3)) * STOC14.3.31 + ABS(STOC14.3.31 <= 80 OR STOC14.3.30 >= AVG(STOC14.3.30,3) OR STOC14.3.31 < AVG(STOC14.3.31,3)) * (ABS(STOC14.3.32 > 80 AND STOC14.3.31 < AVG(STOC14.3.31,3) AND STOC14.3.32 >= AVG(STOC14.3.32,3)) * STOC14.3.32 + ABS(STOC14.3.32 <= 80 OR STOC14.3.31 >= AVG(STOC14.3.31,3) OR STOC14.3.32 < AVG(STOC14.3.32,3)) * (STOC14.3.1 - 1))))))))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
MoreAces
Posted : Sunday, February 8, 2015 10:42:18 AM
Registered User
Joined: 8/23/2013
Posts: 245

Great Formulas (thanks) you  have

 

1) Price making Lower Lows and Stoch making higher lows  (Bullish Divergence)

2) Price making Higher highs and Stoch making Lower Highs (Bearish Divergence)

 

CAN YOU CREATE THESE

3) Price making Lower Highs and Stoch Making Higher Highs

4) Price Making Higher Lows ad Stoch makin Lower Lows

 

Thanks

Bruce_L
Posted : Tuesday, February 10, 2015 11:54:20 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try the following for price making lower highs and stochastics making higher highs.

STOC14.3.1 > 80 AND STOC14.3 < AVG(STOC14.3,3) AND STOC14.3.1 >= AVG(STOC14.3.1,3) AND H1 < ABS(STOC14.3.3 > 80 AND STOC14.3.2 < AVG(STOC14.3.2,3) AND STOC14.3.3 >= AVG(STOC14.3.3,3)) * H3 + ABS(STOC14.3.3 <= 80 OR STOC14.3.2 >= AVG(STOC14.3.2,3) OR STOC14.3.3 < AVG(STOC14.3.3,3)) * (ABS(STOC14.3.4 > 80 AND STOC14.3.3 < AVG(STOC14.3.3,3) AND STOC14.3.4 >= AVG(STOC14.3.4,3)) * H4 + ABS(STOC14.3.4 <= 80 OR STOC14.3.3 >= AVG(STOC14.3.3,3) OR STOC14.3.4 < AVG(STOC14.3.4,3)) * (ABS(STOC14.3.5 > 80 AND STOC14.3.4 < AVG(STOC14.3.4,3) AND STOC14.3.5 >= AVG(STOC14.3.5,3)) * H5 + ABS(STOC14.3.5 <= 80 OR STOC14.3.4 >= AVG(STOC14.3.4,3) OR STOC14.3.5 < AVG(STOC14.3.5,3)) * (ABS(STOC14.3.6 > 80 AND STOC14.3.5 < AVG(STOC14.3.5,3) AND STOC14.3.6 >= AVG(STOC14.3.6,3)) * H6 + ABS(STOC14.3.6 <= 80 OR STOC14.3.5 >= AVG(STOC14.3.5,3) OR STOC14.3.6 < AVG(STOC14.3.6,3)) * (ABS(STOC14.3.7 > 80 AND STOC14.3.6 < AVG(STOC14.3.6,3) AND STOC14.3.7 >= AVG(STOC14.3.7,3)) * H7 + ABS(STOC14.3.7 <= 80 OR STOC14.3.6 >= AVG(STOC14.3.6,3) OR STOC14.3.7 < AVG(STOC14.3.7,3)) * (ABS(STOC14.3.8 > 80 AND STOC14.3.7 < AVG(STOC14.3.7,3) AND STOC14.3.8 >= AVG(STOC14.3.8,3)) * H8 + ABS(STOC14.3.8 <= 80 OR STOC14.3.7 >= AVG(STOC14.3.7,3) OR STOC14.3.8 < AVG(STOC14.3.8,3)) * (ABS(STOC14.3.9 > 80 AND STOC14.3.8 < AVG(STOC14.3.8,3) AND STOC14.3.9 >= AVG(STOC14.3.9,3)) * H9 + ABS(STOC14.3.9 <= 80 OR STOC14.3.8 >= AVG(STOC14.3.8,3) OR STOC14.3.9 < AVG(STOC14.3.9,3)) * (ABS(STOC14.3.10 > 80 AND STOC14.3.9 < AVG(STOC14.3.9,3) AND STOC14.3.10 >= AVG(STOC14.3.10,3)) * H10 + ABS(STOC14.3.10 <= 80 OR STOC14.3.9 >= AVG(STOC14.3.9,3) OR STOC14.3.10 < AVG(STOC14.3.10,3)) * (ABS(STOC14.3.11 > 80 AND STOC14.3.10 < AVG(STOC14.3.10,3) AND STOC14.3.11 >= AVG(STOC14.3.11,3)) * H11 + ABS(STOC14.3.11 <= 80 OR STOC14.3.10 >= AVG(STOC14.3.10,3) OR STOC14.3.11 < AVG(STOC14.3.11,3)) * (ABS(STOC14.3.12 > 80 AND STOC14.3.11 < AVG(STOC14.3.11,3) AND STOC14.3.12 >= AVG(STOC14.3.12,3)) * H12 + ABS(STOC14.3.12 <= 80 OR STOC14.3.11 >= AVG(STOC14.3.11,3) OR STOC14.3.12 < AVG(STOC14.3.12,3)) * (ABS(STOC14.3.13 > 80 AND STOC14.3.12 < AVG(STOC14.3.12,3) AND STOC14.3.13 >= AVG(STOC14.3.13,3)) * H13 + ABS(STOC14.3.13 <= 80 OR STOC14.3.12 >= AVG(STOC14.3.12,3) OR STOC14.3.13 < AVG(STOC14.3.13,3)) * (ABS(STOC14.3.14 > 80 AND STOC14.3.13 < AVG(STOC14.3.13,3) AND STOC14.3.14 >= AVG(STOC14.3.14,3)) * H14 + ABS(STOC14.3.14 <= 80 OR STOC14.3.13 >= AVG(STOC14.3.13,3) OR STOC14.3.14 < AVG(STOC14.3.14,3)) * (ABS(STOC14.3.15 > 80 AND STOC14.3.14 < AVG(STOC14.3.14,3) AND STOC14.3.15 >= AVG(STOC14.3.15,3)) * H15 + ABS(STOC14.3.15 <= 80 OR STOC14.3.14 >= AVG(STOC14.3.14,3) OR STOC14.3.15 < AVG(STOC14.3.15,3)) * (ABS(STOC14.3.16 > 80 AND STOC14.3.15 < AVG(STOC14.3.15,3) AND STOC14.3.16 >= AVG(STOC14.3.16,3)) * H16 + ABS(STOC14.3.16 <= 80 OR STOC14.3.15 >= AVG(STOC14.3.15,3) OR STOC14.3.16 < AVG(STOC14.3.16,3)) * (ABS(STOC14.3.17 > 80 AND STOC14.3.16 < AVG(STOC14.3.16,3) AND STOC14.3.17 >= AVG(STOC14.3.17,3)) * H17 + ABS(STOC14.3.17 <= 80 OR STOC14.3.16 >= AVG(STOC14.3.16,3) OR STOC14.3.17 < AVG(STOC14.3.17,3)) * (ABS(STOC14.3.18 > 80 AND STOC14.3.17 < AVG(STOC14.3.17,3) AND STOC14.3.18 >= AVG(STOC14.3.18,3)) * H18 + ABS(STOC14.3.18 <= 80 OR STOC14.3.17 >= AVG(STOC14.3.17,3) OR STOC14.3.18 < AVG(STOC14.3.18,3)) * (ABS(STOC14.3.19 > 80 AND STOC14.3.18 < AVG(STOC14.3.18,3) AND STOC14.3.19 >= AVG(STOC14.3.19,3)) * H19 + ABS(STOC14.3.19 <= 80 OR STOC14.3.18 >= AVG(STOC14.3.18,3) OR STOC14.3.19 < AVG(STOC14.3.19,3)) * (ABS(STOC14.3.20 > 80 AND STOC14.3.19 < AVG(STOC14.3.19,3) AND STOC14.3.20 >= AVG(STOC14.3.20,3)) * H20 + ABS(STOC14.3.20 <= 80 OR STOC14.3.19 >= AVG(STOC14.3.19,3) OR STOC14.3.20 < AVG(STOC14.3.20,3)) * (ABS(STOC14.3.21 > 80 AND STOC14.3.20 < AVG(STOC14.3.20,3) AND STOC14.3.21 >= AVG(STOC14.3.21,3)) * H21 + ABS(STOC14.3.21 <= 80 OR STOC14.3.20 >= AVG(STOC14.3.20,3) OR STOC14.3.21 < AVG(STOC14.3.21,3)) * (ABS(STOC14.3.22 > 80 AND STOC14.3.21 < AVG(STOC14.3.21,3) AND STOC14.3.22 >= AVG(STOC14.3.22,3)) * H22 + ABS(STOC14.3.22 <= 80 OR STOC14.3.21 >= AVG(STOC14.3.21,3) OR STOC14.3.22 < AVG(STOC14.3.22,3)) * (ABS(STOC14.3.23 > 80 AND STOC14.3.22 < AVG(STOC14.3.22,3) AND STOC14.3.23 >= AVG(STOC14.3.23,3)) * H23 + ABS(STOC14.3.23 <= 80 OR STOC14.3.22 >= AVG(STOC14.3.22,3) OR STOC14.3.23 < AVG(STOC14.3.23,3)) * (ABS(STOC14.3.24 > 80 AND STOC14.3.23 < AVG(STOC14.3.23,3) AND STOC14.3.24 >= AVG(STOC14.3.24,3)) * H24 + ABS(STOC14.3.24 <= 80 OR STOC14.3.23 >= AVG(STOC14.3.23,3) OR STOC14.3.24 < AVG(STOC14.3.24,3)) * (ABS(STOC14.3.25 > 80 AND STOC14.3.24 < AVG(STOC14.3.24,3) AND STOC14.3.25 >= AVG(STOC14.3.25,3)) * H25 + ABS(STOC14.3.25 <= 80 OR STOC14.3.24 >= AVG(STOC14.3.24,3) OR STOC14.3.25 < AVG(STOC14.3.25,3)) * (ABS(STOC14.3.26 > 80 AND STOC14.3.25 < AVG(STOC14.3.25,3) AND STOC14.3.26 >= AVG(STOC14.3.26,3)) * H26 + ABS(STOC14.3.26 <= 80 OR STOC14.3.25 >= AVG(STOC14.3.25,3) OR STOC14.3.26 < AVG(STOC14.3.26,3)) * (ABS(STOC14.3.27 > 80 AND STOC14.3.26 < AVG(STOC14.3.26,3) AND STOC14.3.27 >= AVG(STOC14.3.27,3)) * H27 + ABS(STOC14.3.27 <= 80 OR STOC14.3.26 >= AVG(STOC14.3.26,3) OR STOC14.3.27 < AVG(STOC14.3.27,3)) * (ABS(STOC14.3.28 > 80 AND STOC14.3.27 < AVG(STOC14.3.27,3) AND STOC14.3.28 >= AVG(STOC14.3.28,3)) * H28 + ABS(STOC14.3.28 <= 80 OR STOC14.3.27 >= AVG(STOC14.3.27,3) OR STOC14.3.28 < AVG(STOC14.3.28,3)) * (ABS(STOC14.3.29 > 80 AND STOC14.3.28 < AVG(STOC14.3.28,3) AND STOC14.3.29 >= AVG(STOC14.3.29,3)) * H29 + ABS(STOC14.3.29 <= 80 OR STOC14.3.28 >= AVG(STOC14.3.28,3) OR STOC14.3.29 < AVG(STOC14.3.29,3)) * (ABS(STOC14.3.30 > 80 AND STOC14.3.29 < AVG(STOC14.3.29,3) AND STOC14.3.30 >= AVG(STOC14.3.30,3)) * H30 + ABS(STOC14.3.30 <= 80 OR STOC14.3.29 >= AVG(STOC14.3.29,3) OR STOC14.3.30 < AVG(STOC14.3.30,3)) * (ABS(STOC14.3.31 > 80 AND STOC14.3.30 < AVG(STOC14.3.30,3) AND STOC14.3.31 >= AVG(STOC14.3.31,3)) * H31 + ABS(STOC14.3.31 <= 80 OR STOC14.3.30 >= AVG(STOC14.3.30,3) OR STOC14.3.31 < AVG(STOC14.3.31,3)) * (ABS(STOC14.3.32 > 80 AND STOC14.3.31 < AVG(STOC14.3.31,3) AND STOC14.3.32 >= AVG(STOC14.3.32,3)) * H32 + ABS(STOC14.3.32 <= 80 OR STOC14.3.31 >= AVG(STOC14.3.31,3) OR STOC14.3.32 < AVG(STOC14.3.32,3)) * (H1 - 1)))))))))))))))))))))))))))))) AND STOC14.3.1 > ABS(STOC14.3.3 > 80 AND STOC14.3.2 < AVG(STOC14.3.2,3) AND STOC14.3.3 >= AVG(STOC14.3.3,3)) * STOC14.3.3 + ABS(STOC14.3.3 <= 80 OR STOC14.3.2 >= AVG(STOC14.3.2,3) OR STOC14.3.3 < AVG(STOC14.3.3,3)) * (ABS(STOC14.3.4 > 80 AND STOC14.3.3 < AVG(STOC14.3.3,3) AND STOC14.3.4 >= AVG(STOC14.3.4,3)) * STOC14.3.4 + ABS(STOC14.3.4 <= 80 OR STOC14.3.3 >= AVG(STOC14.3.3,3) OR STOC14.3.4 < AVG(STOC14.3.4,3)) * (ABS(STOC14.3.5 > 80 AND STOC14.3.4 < AVG(STOC14.3.4,3) AND STOC14.3.5 >= AVG(STOC14.3.5,3)) * STOC14.3.5 + ABS(STOC14.3.5 <= 80 OR STOC14.3.4 >= AVG(STOC14.3.4,3) OR STOC14.3.5 < AVG(STOC14.3.5,3)) * (ABS(STOC14.3.6 > 80 AND STOC14.3.5 < AVG(STOC14.3.5,3) AND STOC14.3.6 >= AVG(STOC14.3.6,3)) * STOC14.3.6 + ABS(STOC14.3.6 <= 80 OR STOC14.3.5 >= AVG(STOC14.3.5,3) OR STOC14.3.6 < AVG(STOC14.3.6,3)) * (ABS(STOC14.3.7 > 80 AND STOC14.3.6 < AVG(STOC14.3.6,3) AND STOC14.3.7 >= AVG(STOC14.3.7,3)) * STOC14.3.7 + ABS(STOC14.3.7 <= 80 OR STOC14.3.6 >= AVG(STOC14.3.6,3) OR STOC14.3.7 < AVG(STOC14.3.7,3)) * (ABS(STOC14.3.8 > 80 AND STOC14.3.7 < AVG(STOC14.3.7,3) AND STOC14.3.8 >= AVG(STOC14.3.8,3)) * STOC14.3.8 + ABS(STOC14.3.8 <= 80 OR STOC14.3.7 >= AVG(STOC14.3.7,3) OR STOC14.3.8 < AVG(STOC14.3.8,3)) * (ABS(STOC14.3.9 > 80 AND STOC14.3.8 < AVG(STOC14.3.8,3) AND STOC14.3.9 >= AVG(STOC14.3.9,3)) * STOC14.3.9 + ABS(STOC14.3.9 <= 80 OR STOC14.3.8 >= AVG(STOC14.3.8,3) OR STOC14.3.9 < AVG(STOC14.3.9,3)) * (ABS(STOC14.3.10 > 80 AND STOC14.3.9 < AVG(STOC14.3.9,3) AND STOC14.3.10 >= AVG(STOC14.3.10,3)) * STOC14.3.10 + ABS(STOC14.3.10 <= 80 OR STOC14.3.9 >= AVG(STOC14.3.9,3) OR STOC14.3.10 < AVG(STOC14.3.10,3)) * (ABS(STOC14.3.11 > 80 AND STOC14.3.10 < AVG(STOC14.3.10,3) AND STOC14.3.11 >= AVG(STOC14.3.11,3)) * STOC14.3.11 + ABS(STOC14.3.11 <= 80 OR STOC14.3.10 >= AVG(STOC14.3.10,3) OR STOC14.3.11 < AVG(STOC14.3.11,3)) * (ABS(STOC14.3.12 > 80 AND STOC14.3.11 < AVG(STOC14.3.11,3) AND STOC14.3.12 >= AVG(STOC14.3.12,3)) * STOC14.3.12 + ABS(STOC14.3.12 <= 80 OR STOC14.3.11 >= AVG(STOC14.3.11,3) OR STOC14.3.12 < AVG(STOC14.3.12,3)) * (ABS(STOC14.3.13 > 80 AND STOC14.3.12 < AVG(STOC14.3.12,3) AND STOC14.3.13 >= AVG(STOC14.3.13,3)) * STOC14.3.13 + ABS(STOC14.3.13 <= 80 OR STOC14.3.12 >= AVG(STOC14.3.12,3) OR STOC14.3.13 < AVG(STOC14.3.13,3)) * (ABS(STOC14.3.14 > 80 AND STOC14.3.13 < AVG(STOC14.3.13,3) AND STOC14.3.14 >= AVG(STOC14.3.14,3)) * STOC14.3.14 + ABS(STOC14.3.14 <= 80 OR STOC14.3.13 >= AVG(STOC14.3.13,3) OR STOC14.3.14 < AVG(STOC14.3.14,3)) * (ABS(STOC14.3.15 > 80 AND STOC14.3.14 < AVG(STOC14.3.14,3) AND STOC14.3.15 >= AVG(STOC14.3.15,3)) * STOC14.3.15 + ABS(STOC14.3.15 <= 80 OR STOC14.3.14 >= AVG(STOC14.3.14,3) OR STOC14.3.15 < AVG(STOC14.3.15,3)) * (ABS(STOC14.3.16 > 80 AND STOC14.3.15 < AVG(STOC14.3.15,3) AND STOC14.3.16 >= AVG(STOC14.3.16,3)) * STOC14.3.16 + ABS(STOC14.3.16 <= 80 OR STOC14.3.15 >= AVG(STOC14.3.15,3) OR STOC14.3.16 < AVG(STOC14.3.16,3)) * (ABS(STOC14.3.17 > 80 AND STOC14.3.16 < AVG(STOC14.3.16,3) AND STOC14.3.17 >= AVG(STOC14.3.17,3)) * STOC14.3.17 + ABS(STOC14.3.17 <= 80 OR STOC14.3.16 >= AVG(STOC14.3.16,3) OR STOC14.3.17 < AVG(STOC14.3.17,3)) * (ABS(STOC14.3.18 > 80 AND STOC14.3.17 < AVG(STOC14.3.17,3) AND STOC14.3.18 >= AVG(STOC14.3.18,3)) * STOC14.3.18 + ABS(STOC14.3.18 <= 80 OR STOC14.3.17 >= AVG(STOC14.3.17,3) OR STOC14.3.18 < AVG(STOC14.3.18,3)) * (ABS(STOC14.3.19 > 80 AND STOC14.3.18 < AVG(STOC14.3.18,3) AND STOC14.3.19 >= AVG(STOC14.3.19,3)) * STOC14.3.19 + ABS(STOC14.3.19 <= 80 OR STOC14.3.18 >= AVG(STOC14.3.18,3) OR STOC14.3.19 < AVG(STOC14.3.19,3)) * (ABS(STOC14.3.20 > 80 AND STOC14.3.19 < AVG(STOC14.3.19,3) AND STOC14.3.20 >= AVG(STOC14.3.20,3)) * STOC14.3.20 + ABS(STOC14.3.20 <= 80 OR STOC14.3.19 >= AVG(STOC14.3.19,3) OR STOC14.3.20 < AVG(STOC14.3.20,3)) * (ABS(STOC14.3.21 > 80 AND STOC14.3.20 < AVG(STOC14.3.20,3) AND STOC14.3.21 >= AVG(STOC14.3.21,3)) * STOC14.3.21 + ABS(STOC14.3.21 <= 80 OR STOC14.3.20 >= AVG(STOC14.3.20,3) OR STOC14.3.21 < AVG(STOC14.3.21,3)) * (ABS(STOC14.3.22 > 80 AND STOC14.3.21 < AVG(STOC14.3.21,3) AND STOC14.3.22 >= AVG(STOC14.3.22,3)) * STOC14.3.22 + ABS(STOC14.3.22 <= 80 OR STOC14.3.21 >= AVG(STOC14.3.21,3) OR STOC14.3.22 < AVG(STOC14.3.22,3)) * (ABS(STOC14.3.23 > 80 AND STOC14.3.22 < AVG(STOC14.3.22,3) AND STOC14.3.23 >= AVG(STOC14.3.23,3)) * STOC14.3.23 + ABS(STOC14.3.23 <= 80 OR STOC14.3.22 >= AVG(STOC14.3.22,3) OR STOC14.3.23 < AVG(STOC14.3.23,3)) * (ABS(STOC14.3.24 > 80 AND STOC14.3.23 < AVG(STOC14.3.23,3) AND STOC14.3.24 >= AVG(STOC14.3.24,3)) * STOC14.3.24 + ABS(STOC14.3.24 <= 80 OR STOC14.3.23 >= AVG(STOC14.3.23,3) OR STOC14.3.24 < AVG(STOC14.3.24,3)) * (ABS(STOC14.3.25 > 80 AND STOC14.3.24 < AVG(STOC14.3.24,3) AND STOC14.3.25 >= AVG(STOC14.3.25,3)) * STOC14.3.25 + ABS(STOC14.3.25 <= 80 OR STOC14.3.24 >= AVG(STOC14.3.24,3) OR STOC14.3.25 < AVG(STOC14.3.25,3)) * (ABS(STOC14.3.26 > 80 AND STOC14.3.25 < AVG(STOC14.3.25,3) AND STOC14.3.26 >= AVG(STOC14.3.26,3)) * STOC14.3.26 + ABS(STOC14.3.26 <= 80 OR STOC14.3.25 >= AVG(STOC14.3.25,3) OR STOC14.3.26 < AVG(STOC14.3.26,3)) * (ABS(STOC14.3.27 > 80 AND STOC14.3.26 < AVG(STOC14.3.26,3) AND STOC14.3.27 >= AVG(STOC14.3.27,3)) * STOC14.3.27 + ABS(STOC14.3.27 <= 80 OR STOC14.3.26 >= AVG(STOC14.3.26,3) OR STOC14.3.27 < AVG(STOC14.3.27,3)) * (ABS(STOC14.3.28 > 80 AND STOC14.3.27 < AVG(STOC14.3.27,3) AND STOC14.3.28 >= AVG(STOC14.3.28,3)) * STOC14.3.28 + ABS(STOC14.3.28 <= 80 OR STOC14.3.27 >= AVG(STOC14.3.27,3) OR STOC14.3.28 < AVG(STOC14.3.28,3)) * (ABS(STOC14.3.29 > 80 AND STOC14.3.28 < AVG(STOC14.3.28,3) AND STOC14.3.29 >= AVG(STOC14.3.29,3)) * STOC14.3.29 + ABS(STOC14.3.29 <= 80 OR STOC14.3.28 >= AVG(STOC14.3.28,3) OR STOC14.3.29 < AVG(STOC14.3.29,3)) * (ABS(STOC14.3.30 > 80 AND STOC14.3.29 < AVG(STOC14.3.29,3) AND STOC14.3.30 >= AVG(STOC14.3.30,3)) * STOC14.3.30 + ABS(STOC14.3.30 <= 80 OR STOC14.3.29 >= AVG(STOC14.3.29,3) OR STOC14.3.30 < AVG(STOC14.3.30,3)) * (ABS(STOC14.3.31 > 80 AND STOC14.3.30 < AVG(STOC14.3.30,3) AND STOC14.3.31 >= AVG(STOC14.3.31,3)) * STOC14.3.31 + ABS(STOC14.3.31 <= 80 OR STOC14.3.30 >= AVG(STOC14.3.30,3) OR STOC14.3.31 < AVG(STOC14.3.31,3)) * (ABS(STOC14.3.32 > 80 AND STOC14.3.31 < AVG(STOC14.3.31,3) AND STOC14.3.32 >= AVG(STOC14.3.32,3)) * STOC14.3.32 + ABS(STOC14.3.32 <= 80 OR STOC14.3.31 >= AVG(STOC14.3.31,3) OR STOC14.3.32 < AVG(STOC14.3.32,3)) * (STOC14.3.1 + 1))))))))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Bruce_L
Posted : Tuesday, February 10, 2015 11:57:44 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try the following for price making higher lows and stochastics making lower lows.

STOC14.3.1 < 20 AND STOC14.3 > AVG(STOC14.3,3) AND STOC14.3.1 <= AVG(STOC14.3.1,3) AND L1 > ABS(STOC14.3.3 < 20 AND STOC14.3.2 > AVG(STOC14.3.2,3) AND STOC14.3.3 <= AVG(STOC14.3.3,3)) * L3 + ABS(STOC14.3.3 >= 20 OR STOC14.3.2 <= AVG(STOC14.3.2,3) OR STOC14.3.3 > AVG(STOC14.3.3,3)) * (ABS(STOC14.3.4 < 20 AND STOC14.3.3 > AVG(STOC14.3.3,3) AND STOC14.3.4 <= AVG(STOC14.3.4,3)) * L4 + ABS(STOC14.3.4 >= 20 OR STOC14.3.3 <= AVG(STOC14.3.3,3) OR STOC14.3.4 > AVG(STOC14.3.4,3)) * (ABS(STOC14.3.5 < 20 AND STOC14.3.4 > AVG(STOC14.3.4,3) AND STOC14.3.5 <= AVG(STOC14.3.5,3)) * L5 + ABS(STOC14.3.5 >= 20 OR STOC14.3.4 <= AVG(STOC14.3.4,3) OR STOC14.3.5 > AVG(STOC14.3.5,3)) * (ABS(STOC14.3.6 < 20 AND STOC14.3.5 > AVG(STOC14.3.5,3) AND STOC14.3.6 <= AVG(STOC14.3.6,3)) * L6 + ABS(STOC14.3.6 >= 20 OR STOC14.3.5 <= AVG(STOC14.3.5,3) OR STOC14.3.6 > AVG(STOC14.3.6,3)) * (ABS(STOC14.3.7 < 20 AND STOC14.3.6 > AVG(STOC14.3.6,3) AND STOC14.3.7 <= AVG(STOC14.3.7,3)) * L7 + ABS(STOC14.3.7 >= 20 OR STOC14.3.6 <= AVG(STOC14.3.6,3) OR STOC14.3.7 > AVG(STOC14.3.7,3)) * (ABS(STOC14.3.8 < 20 AND STOC14.3.7 > AVG(STOC14.3.7,3) AND STOC14.3.8 <= AVG(STOC14.3.8,3)) * L8 + ABS(STOC14.3.8 >= 20 OR STOC14.3.7 <= AVG(STOC14.3.7,3) OR STOC14.3.8 > AVG(STOC14.3.8,3)) * (ABS(STOC14.3.9 < 20 AND STOC14.3.8 > AVG(STOC14.3.8,3) AND STOC14.3.9 <= AVG(STOC14.3.9,3)) * L9 + ABS(STOC14.3.9 >= 20 OR STOC14.3.8 <= AVG(STOC14.3.8,3) OR STOC14.3.9 > AVG(STOC14.3.9,3)) * (ABS(STOC14.3.10 < 20 AND STOC14.3.9 > AVG(STOC14.3.9,3) AND STOC14.3.10 <= AVG(STOC14.3.10,3)) * L10 + ABS(STOC14.3.10 >= 20 OR STOC14.3.9 <= AVG(STOC14.3.9,3) OR STOC14.3.10 > AVG(STOC14.3.10,3)) * (ABS(STOC14.3.11 < 20 AND STOC14.3.10 > AVG(STOC14.3.10,3) AND STOC14.3.11 <= AVG(STOC14.3.11,3)) * L11 + ABS(STOC14.3.11 >= 20 OR STOC14.3.10 <= AVG(STOC14.3.10,3) OR STOC14.3.11 > AVG(STOC14.3.11,3)) * (ABS(STOC14.3.12 < 20 AND STOC14.3.11 > AVG(STOC14.3.11,3) AND STOC14.3.12 <= AVG(STOC14.3.12,3)) * L12 + ABS(STOC14.3.12 >= 20 OR STOC14.3.11 <= AVG(STOC14.3.11,3) OR STOC14.3.12 > AVG(STOC14.3.12,3)) * (ABS(STOC14.3.13 < 20 AND STOC14.3.12 > AVG(STOC14.3.12,3) AND STOC14.3.13 <= AVG(STOC14.3.13,3)) * L13 + ABS(STOC14.3.13 >= 20 OR STOC14.3.12 <= AVG(STOC14.3.12,3) OR STOC14.3.13 > AVG(STOC14.3.13,3)) * (ABS(STOC14.3.14 < 20 AND STOC14.3.13 > AVG(STOC14.3.13,3) AND STOC14.3.14 <= AVG(STOC14.3.14,3)) * L14 + ABS(STOC14.3.14 >= 20 OR STOC14.3.13 <= AVG(STOC14.3.13,3) OR STOC14.3.14 > AVG(STOC14.3.14,3)) * (ABS(STOC14.3.15 < 20 AND STOC14.3.14 > AVG(STOC14.3.14,3) AND STOC14.3.15 <= AVG(STOC14.3.15,3)) * L15 + ABS(STOC14.3.15 >= 20 OR STOC14.3.14 <= AVG(STOC14.3.14,3) OR STOC14.3.15 > AVG(STOC14.3.15,3)) * (ABS(STOC14.3.16 < 20 AND STOC14.3.15 > AVG(STOC14.3.15,3) AND STOC14.3.16 <= AVG(STOC14.3.16,3)) * L16 + ABS(STOC14.3.16 >= 20 OR STOC14.3.15 <= AVG(STOC14.3.15,3) OR STOC14.3.16 > AVG(STOC14.3.16,3)) * (ABS(STOC14.3.17 < 20 AND STOC14.3.16 > AVG(STOC14.3.16,3) AND STOC14.3.17 <= AVG(STOC14.3.17,3)) * L17 + ABS(STOC14.3.17 >= 20 OR STOC14.3.16 <= AVG(STOC14.3.16,3) OR STOC14.3.17 > AVG(STOC14.3.17,3)) * (ABS(STOC14.3.18 < 20 AND STOC14.3.17 > AVG(STOC14.3.17,3) AND STOC14.3.18 <= AVG(STOC14.3.18,3)) * L18 + ABS(STOC14.3.18 >= 20 OR STOC14.3.17 <= AVG(STOC14.3.17,3) OR STOC14.3.18 > AVG(STOC14.3.18,3)) * (ABS(STOC14.3.19 < 20 AND STOC14.3.18 > AVG(STOC14.3.18,3) AND STOC14.3.19 <= AVG(STOC14.3.19,3)) * L19 + ABS(STOC14.3.19 >= 20 OR STOC14.3.18 <= AVG(STOC14.3.18,3) OR STOC14.3.19 > AVG(STOC14.3.19,3)) * (ABS(STOC14.3.20 < 20 AND STOC14.3.19 > AVG(STOC14.3.19,3) AND STOC14.3.20 <= AVG(STOC14.3.20,3)) * L20 + ABS(STOC14.3.20 >= 20 OR STOC14.3.19 <= AVG(STOC14.3.19,3) OR STOC14.3.20 > AVG(STOC14.3.20,3)) * (ABS(STOC14.3.21 < 20 AND STOC14.3.20 > AVG(STOC14.3.20,3) AND STOC14.3.21 <= AVG(STOC14.3.21,3)) * L21 + ABS(STOC14.3.21 >= 20 OR STOC14.3.20 <= AVG(STOC14.3.20,3) OR STOC14.3.21 > AVG(STOC14.3.21,3)) * (ABS(STOC14.3.22 < 20 AND STOC14.3.21 > AVG(STOC14.3.21,3) AND STOC14.3.22 <= AVG(STOC14.3.22,3)) * L22 + ABS(STOC14.3.22 >= 20 OR STOC14.3.21 <= AVG(STOC14.3.21,3) OR STOC14.3.22 > AVG(STOC14.3.22,3)) * (ABS(STOC14.3.23 < 20 AND STOC14.3.22 > AVG(STOC14.3.22,3) AND STOC14.3.23 <= AVG(STOC14.3.23,3)) * L23 + ABS(STOC14.3.23 >= 20 OR STOC14.3.22 <= AVG(STOC14.3.22,3) OR STOC14.3.23 > AVG(STOC14.3.23,3)) * (ABS(STOC14.3.24 < 20 AND STOC14.3.23 > AVG(STOC14.3.23,3) AND STOC14.3.24 <= AVG(STOC14.3.24,3)) * L24 + ABS(STOC14.3.24 >= 20 OR STOC14.3.23 <= AVG(STOC14.3.23,3) OR STOC14.3.24 > AVG(STOC14.3.24,3)) * (ABS(STOC14.3.25 < 20 AND STOC14.3.24 > AVG(STOC14.3.24,3) AND STOC14.3.25 <= AVG(STOC14.3.25,3)) * L25 + ABS(STOC14.3.25 >= 20 OR STOC14.3.24 <= AVG(STOC14.3.24,3) OR STOC14.3.25 > AVG(STOC14.3.25,3)) * (ABS(STOC14.3.26 < 20 AND STOC14.3.25 > AVG(STOC14.3.25,3) AND STOC14.3.26 <= AVG(STOC14.3.26,3)) * L26 + ABS(STOC14.3.26 >= 20 OR STOC14.3.25 <= AVG(STOC14.3.25,3) OR STOC14.3.26 > AVG(STOC14.3.26,3)) * (ABS(STOC14.3.27 < 20 AND STOC14.3.26 > AVG(STOC14.3.26,3) AND STOC14.3.27 <= AVG(STOC14.3.27,3)) * L27 + ABS(STOC14.3.27 >= 20 OR STOC14.3.26 <= AVG(STOC14.3.26,3) OR STOC14.3.27 > AVG(STOC14.3.27,3)) * (ABS(STOC14.3.28 < 20 AND STOC14.3.27 > AVG(STOC14.3.27,3) AND STOC14.3.28 <= AVG(STOC14.3.28,3)) * L28 + ABS(STOC14.3.28 >= 20 OR STOC14.3.27 <= AVG(STOC14.3.27,3) OR STOC14.3.28 > AVG(STOC14.3.28,3)) * (ABS(STOC14.3.29 < 20 AND STOC14.3.28 > AVG(STOC14.3.28,3) AND STOC14.3.29 <= AVG(STOC14.3.29,3)) * L29 + ABS(STOC14.3.29 >= 20 OR STOC14.3.28 <= AVG(STOC14.3.28,3) OR STOC14.3.29 > AVG(STOC14.3.29,3)) * (ABS(STOC14.3.30 < 20 AND STOC14.3.29 > AVG(STOC14.3.29,3) AND STOC14.3.30 <= AVG(STOC14.3.30,3)) * L30 + ABS(STOC14.3.30 >= 20 OR STOC14.3.29 <= AVG(STOC14.3.29,3) OR STOC14.3.30 > AVG(STOC14.3.30,3)) * (ABS(STOC14.3.31 < 20 AND STOC14.3.30 > AVG(STOC14.3.30,3) AND STOC14.3.31 <= AVG(STOC14.3.31,3)) * L31 + ABS(STOC14.3.31 >= 20 OR STOC14.3.30 <= AVG(STOC14.3.30,3) OR STOC14.3.31 > AVG(STOC14.3.31,3)) * (ABS(STOC14.3.32 < 20 AND STOC14.3.31 > AVG(STOC14.3.31,3) AND STOC14.3.32 <= AVG(STOC14.3.32,3)) * L32 + ABS(STOC14.3.32 >= 20 OR STOC14.3.31 <= AVG(STOC14.3.31,3) OR STOC14.3.32 > AVG(STOC14.3.32,3)) * (L1 + 1)))))))))))))))))))))))))))))) AND STOC14.3.1 < ABS(STOC14.3.3 < 20 AND STOC14.3.2 > AVG(STOC14.3.2,3) AND STOC14.3.3 <= AVG(STOC14.3.3,3)) * STOC14.3.3 + ABS(STOC14.3.3 >= 20 OR STOC14.3.2 <= AVG(STOC14.3.2,3) OR STOC14.3.3 > AVG(STOC14.3.3,3)) * (ABS(STOC14.3.4 < 20 AND STOC14.3.3 > AVG(STOC14.3.3,3) AND STOC14.3.4 <= AVG(STOC14.3.4,3)) * STOC14.3.4 + ABS(STOC14.3.4 >= 20 OR STOC14.3.3 <= AVG(STOC14.3.3,3) OR STOC14.3.4 > AVG(STOC14.3.4,3)) * (ABS(STOC14.3.5 < 20 AND STOC14.3.4 > AVG(STOC14.3.4,3) AND STOC14.3.5 <= AVG(STOC14.3.5,3)) * STOC14.3.5 + ABS(STOC14.3.5 >= 20 OR STOC14.3.4 <= AVG(STOC14.3.4,3) OR STOC14.3.5 > AVG(STOC14.3.5,3)) * (ABS(STOC14.3.6 < 20 AND STOC14.3.5 > AVG(STOC14.3.5,3) AND STOC14.3.6 <= AVG(STOC14.3.6,3)) * STOC14.3.6 + ABS(STOC14.3.6 >= 20 OR STOC14.3.5 <= AVG(STOC14.3.5,3) OR STOC14.3.6 > AVG(STOC14.3.6,3)) * (ABS(STOC14.3.7 < 20 AND STOC14.3.6 > AVG(STOC14.3.6,3) AND STOC14.3.7 <= AVG(STOC14.3.7,3)) * STOC14.3.7 + ABS(STOC14.3.7 >= 20 OR STOC14.3.6 <= AVG(STOC14.3.6,3) OR STOC14.3.7 > AVG(STOC14.3.7,3)) * (ABS(STOC14.3.8 < 20 AND STOC14.3.7 > AVG(STOC14.3.7,3) AND STOC14.3.8 <= AVG(STOC14.3.8,3)) * STOC14.3.8 + ABS(STOC14.3.8 >= 20 OR STOC14.3.7 <= AVG(STOC14.3.7,3) OR STOC14.3.8 > AVG(STOC14.3.8,3)) * (ABS(STOC14.3.9 < 20 AND STOC14.3.8 > AVG(STOC14.3.8,3) AND STOC14.3.9 <= AVG(STOC14.3.9,3)) * STOC14.3.9 + ABS(STOC14.3.9 >= 20 OR STOC14.3.8 <= AVG(STOC14.3.8,3) OR STOC14.3.9 > AVG(STOC14.3.9,3)) * (ABS(STOC14.3.10 < 20 AND STOC14.3.9 > AVG(STOC14.3.9,3) AND STOC14.3.10 <= AVG(STOC14.3.10,3)) * STOC14.3.10 + ABS(STOC14.3.10 >= 20 OR STOC14.3.9 <= AVG(STOC14.3.9,3) OR STOC14.3.10 > AVG(STOC14.3.10,3)) * (ABS(STOC14.3.11 < 20 AND STOC14.3.10 > AVG(STOC14.3.10,3) AND STOC14.3.11 <= AVG(STOC14.3.11,3)) * STOC14.3.11 + ABS(STOC14.3.11 >= 20 OR STOC14.3.10 <= AVG(STOC14.3.10,3) OR STOC14.3.11 > AVG(STOC14.3.11,3)) * (ABS(STOC14.3.12 < 20 AND STOC14.3.11 > AVG(STOC14.3.11,3) AND STOC14.3.12 <= AVG(STOC14.3.12,3)) * STOC14.3.12 + ABS(STOC14.3.12 >= 20 OR STOC14.3.11 <= AVG(STOC14.3.11,3) OR STOC14.3.12 > AVG(STOC14.3.12,3)) * (ABS(STOC14.3.13 < 20 AND STOC14.3.12 > AVG(STOC14.3.12,3) AND STOC14.3.13 <= AVG(STOC14.3.13,3)) * STOC14.3.13 + ABS(STOC14.3.13 >= 20 OR STOC14.3.12 <= AVG(STOC14.3.12,3) OR STOC14.3.13 > AVG(STOC14.3.13,3)) * (ABS(STOC14.3.14 < 20 AND STOC14.3.13 > AVG(STOC14.3.13,3) AND STOC14.3.14 <= AVG(STOC14.3.14,3)) * STOC14.3.14 + ABS(STOC14.3.14 >= 20 OR STOC14.3.13 <= AVG(STOC14.3.13,3) OR STOC14.3.14 > AVG(STOC14.3.14,3)) * (ABS(STOC14.3.15 < 20 AND STOC14.3.14 > AVG(STOC14.3.14,3) AND STOC14.3.15 <= AVG(STOC14.3.15,3)) * STOC14.3.15 + ABS(STOC14.3.15 >= 20 OR STOC14.3.14 <= AVG(STOC14.3.14,3) OR STOC14.3.15 > AVG(STOC14.3.15,3)) * (ABS(STOC14.3.16 < 20 AND STOC14.3.15 > AVG(STOC14.3.15,3) AND STOC14.3.16 <= AVG(STOC14.3.16,3)) * STOC14.3.16 + ABS(STOC14.3.16 >= 20 OR STOC14.3.15 <= AVG(STOC14.3.15,3) OR STOC14.3.16 > AVG(STOC14.3.16,3)) * (ABS(STOC14.3.17 < 20 AND STOC14.3.16 > AVG(STOC14.3.16,3) AND STOC14.3.17 <= AVG(STOC14.3.17,3)) * STOC14.3.17 + ABS(STOC14.3.17 >= 20 OR STOC14.3.16 <= AVG(STOC14.3.16,3) OR STOC14.3.17 > AVG(STOC14.3.17,3)) * (ABS(STOC14.3.18 < 20 AND STOC14.3.17 > AVG(STOC14.3.17,3) AND STOC14.3.18 <= AVG(STOC14.3.18,3)) * STOC14.3.18 + ABS(STOC14.3.18 >= 20 OR STOC14.3.17 <= AVG(STOC14.3.17,3) OR STOC14.3.18 > AVG(STOC14.3.18,3)) * (ABS(STOC14.3.19 < 20 AND STOC14.3.18 > AVG(STOC14.3.18,3) AND STOC14.3.19 <= AVG(STOC14.3.19,3)) * STOC14.3.19 + ABS(STOC14.3.19 >= 20 OR STOC14.3.18 <= AVG(STOC14.3.18,3) OR STOC14.3.19 > AVG(STOC14.3.19,3)) * (ABS(STOC14.3.20 < 20 AND STOC14.3.19 > AVG(STOC14.3.19,3) AND STOC14.3.20 <= AVG(STOC14.3.20,3)) * STOC14.3.20 + ABS(STOC14.3.20 >= 20 OR STOC14.3.19 <= AVG(STOC14.3.19,3) OR STOC14.3.20 > AVG(STOC14.3.20,3)) * (ABS(STOC14.3.21 < 20 AND STOC14.3.20 > AVG(STOC14.3.20,3) AND STOC14.3.21 <= AVG(STOC14.3.21,3)) * STOC14.3.21 + ABS(STOC14.3.21 >= 20 OR STOC14.3.20 <= AVG(STOC14.3.20,3) OR STOC14.3.21 > AVG(STOC14.3.21,3)) * (ABS(STOC14.3.22 < 20 AND STOC14.3.21 > AVG(STOC14.3.21,3) AND STOC14.3.22 <= AVG(STOC14.3.22,3)) * STOC14.3.22 + ABS(STOC14.3.22 >= 20 OR STOC14.3.21 <= AVG(STOC14.3.21,3) OR STOC14.3.22 > AVG(STOC14.3.22,3)) * (ABS(STOC14.3.23 < 20 AND STOC14.3.22 > AVG(STOC14.3.22,3) AND STOC14.3.23 <= AVG(STOC14.3.23,3)) * STOC14.3.23 + ABS(STOC14.3.23 >= 20 OR STOC14.3.22 <= AVG(STOC14.3.22,3) OR STOC14.3.23 > AVG(STOC14.3.23,3)) * (ABS(STOC14.3.24 < 20 AND STOC14.3.23 > AVG(STOC14.3.23,3) AND STOC14.3.24 <= AVG(STOC14.3.24,3)) * STOC14.3.24 + ABS(STOC14.3.24 >= 20 OR STOC14.3.23 <= AVG(STOC14.3.23,3) OR STOC14.3.24 > AVG(STOC14.3.24,3)) * (ABS(STOC14.3.25 < 20 AND STOC14.3.24 > AVG(STOC14.3.24,3) AND STOC14.3.25 <= AVG(STOC14.3.25,3)) * STOC14.3.25 + ABS(STOC14.3.25 >= 20 OR STOC14.3.24 <= AVG(STOC14.3.24,3) OR STOC14.3.25 > AVG(STOC14.3.25,3)) * (ABS(STOC14.3.26 < 20 AND STOC14.3.25 > AVG(STOC14.3.25,3) AND STOC14.3.26 <= AVG(STOC14.3.26,3)) * STOC14.3.26 + ABS(STOC14.3.26 >= 20 OR STOC14.3.25 <= AVG(STOC14.3.25,3) OR STOC14.3.26 > AVG(STOC14.3.26,3)) * (ABS(STOC14.3.27 < 20 AND STOC14.3.26 > AVG(STOC14.3.26,3) AND STOC14.3.27 <= AVG(STOC14.3.27,3)) * STOC14.3.27 + ABS(STOC14.3.27 >= 20 OR STOC14.3.26 <= AVG(STOC14.3.26,3) OR STOC14.3.27 > AVG(STOC14.3.27,3)) * (ABS(STOC14.3.28 < 20 AND STOC14.3.27 > AVG(STOC14.3.27,3) AND STOC14.3.28 <= AVG(STOC14.3.28,3)) * STOC14.3.28 + ABS(STOC14.3.28 >= 20 OR STOC14.3.27 <= AVG(STOC14.3.27,3) OR STOC14.3.28 > AVG(STOC14.3.28,3)) * (ABS(STOC14.3.29 < 20 AND STOC14.3.28 > AVG(STOC14.3.28,3) AND STOC14.3.29 <= AVG(STOC14.3.29,3)) * STOC14.3.29 + ABS(STOC14.3.29 >= 20 OR STOC14.3.28 <= AVG(STOC14.3.28,3) OR STOC14.3.29 > AVG(STOC14.3.29,3)) * (ABS(STOC14.3.30 < 20 AND STOC14.3.29 > AVG(STOC14.3.29,3) AND STOC14.3.30 <= AVG(STOC14.3.30,3)) * STOC14.3.30 + ABS(STOC14.3.30 >= 20 OR STOC14.3.29 <= AVG(STOC14.3.29,3) OR STOC14.3.30 > AVG(STOC14.3.30,3)) * (ABS(STOC14.3.31 < 20 AND STOC14.3.30 > AVG(STOC14.3.30,3) AND STOC14.3.31 <= AVG(STOC14.3.31,3)) * STOC14.3.31 + ABS(STOC14.3.31 >= 20 OR STOC14.3.30 <= AVG(STOC14.3.30,3) OR STOC14.3.31 > AVG(STOC14.3.31,3)) * (ABS(STOC14.3.32 < 20 AND STOC14.3.31 > AVG(STOC14.3.31,3) AND STOC14.3.32 <= AVG(STOC14.3.32,3)) * STOC14.3.32 + ABS(STOC14.3.32 >= 20 OR STOC14.3.31 <= AVG(STOC14.3.31,3) OR STOC14.3.32 > AVG(STOC14.3.32,3)) * (STOC14.3.1 - 1))))))))))))))))))))))))))))))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
MoreAces
Posted : Tuesday, February 10, 2015 3:40:05 PM
Registered User
Joined: 8/23/2013
Posts: 245

Thanks Bruce

MoreAces
Posted : Wednesday, February 11, 2015 12:52:52 PM
Registered User
Joined: 8/23/2013
Posts: 245

Bruce i am still not finding what i am looking for (i am looking for 4 different setups on Stochastics)


2 involve the tops or peaks of the stochastic and 2 involve the bottoms

i wish to scan for the 2 most recents peaks of the stochastic line, it could be a higher high or a lower high, THEN for the same candle time frame i wish to compare the price history candles at the same point of reference of the stochastic peaks

Example Stochastics peaks 2 times happens to fall 22 bars apart and the lastest peak was a lower high, once those points are identified  I wish to Know if the lastest peak Price High was Lower or higher than the Candle 22 bars ago High (this would be he candle of the 1st of the 2 stochastic peaks of reference

(if thats not possible is it possible just to scan stochastics fo the 2 peaks and then Manually and visually check the candles )

 

The Bottom would be he reverse

Thanks


 
 

Bruce_L
Posted : Thursday, February 12, 2015 2:50:53 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The formulas, despite the long lengths, are not particularly sophisticated. That they would not identify the types of divergences you want is not suprprising. What is suprising to me is that you would like the first two formulas but not like the second two formulas since they use identical techniques.

Tops are identified in the stochastic when the stochastic %K is above both 80 and the %D during the previous bar and drops below %D during the current bar.

Bottoms are identified in the stochastic when the stochastic %K is below both 20 and the %D during the previous bar and rises above %D during the current bar.

No attempt at all is made to identify tops and bottoms in price. The formulas just compares the highs or lows where tops and bottoms are identified in the stochastic.

The first formula from my Thursday, September 04, 2014 3:09:05 PM ET post checks for the low in price at the current low in stochastics to be below the low in price at the most recently identified previous low in stochastics and for the current low in stochastics to be above the the most recently identified previous low in stochstics.

The second formula from my Thursday, November 20, 2014 4:18:38 PM ET post checks for the high in price at the current high in stochastics to be above the high in price at the most recently identified previous high in stochastics and for the current high in stochastics to be below the the most recently identified previous high in stochstics.

The third formula from my Tuesday, February 10, 2015 11:54:20 AM ET post checks for the high in price at the current high in stochastics to be below the high in price at the most recently identified previous high in stochastics and for the current high in stochastics to be above the the most recently identified previous high in stochstics.

The fourth formula from my Thursday, Tuesday, February 10, 2015 11:57:44 AM ET post checks for the low in price at the current low in stochastics to be above the low in price at the most recently identified previous low in stochastics and for the current low in stochastics to be below the the most recently identified previous low in stochstics.

I've read through your request quite a few time and the comparisons seem to be in the correct directions, so I don't know why the first two formulas would work for you but the second two formulas wouldn't.

If you plot the following formulas as Custom PCF Indicators in the same pane and scale as price using the Dots Plot Style, they should plot dots at the bar where the stochastic tops and bottoms are identified (which is the bar of the cross). It will plot the value being used for the comparison (versus the most recent dot from the same Custom PCF Indicator).

The Formula for the Top is as follows.

H1 * ABS(STOC14.3.1 > 80 AND STOC14.3 < AVG(STOC14.3,3) AND STOC14.3.1 >= AVG(STOC14.3.1,3))

The Formula for the Bottoms is as follows.

L1 * ABS(STOC14.3.1 < 20 AND STOC14.3 > AVG(STOC14.3,3) AND STOC14.3.1 <= AVG(STOC14.3.1,3))

You can line this up fairly easily with the stochastic plot. You would be comparing the values of the stochastic from the bar before the dot is plotted on the chart.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
MoreAces
Posted : Friday, February 13, 2015 8:33:03 AM
Registered User
Joined: 8/23/2013
Posts: 245

That is nice and simple. I just done know how to compare the last trigger to the previous trigger or to the last several triggers.  ON Price History I did a formula for Higher lows on Price as follows:

MINL10.00 > MINL10.6 OR MINL10.00 > MINL10.12 OR MINL10.00 > MINL10.18 OR MINL10.00 > MINL10.24  

I am running ths on 10 minute chart

What should I use to replace the MINL with to represent Stochastics 14,3

 

Bruce_L
Posted : Friday, February 13, 2015 10:52:36 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

MINL10 > MINL10.6 OR MINL10 > MINL10.12 OR MINL10 > MINL10.18 OR MINL10 > MINL10.24

Would be the following when expressed for STOC14.3 instead price.

MIN(STOC14.3,10) > MIN(STOC14.3.6,10) OR MIN(STOC14.3,10) > MIN(STOC14.3.12,10) OR MIN(STOC14.3,10) > MIN(STOC14.3.18,10) OR MIN(STOC14.3,10) > MIN(STOC14.3.24,10)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
MoreAces
Posted : Friday, February 13, 2015 1:15:07 PM
Registered User
Joined: 8/23/2013
Posts: 245

Back to your original H1 Top andL1 Bottom Formulas

 

I just don't know how to compare the last trigger to the previous trigger or to the last several triggers. Without actually visually looking.  How do I scan if the Value the Stochastic Top at the current Trigger/Alert is  a higher Value or Lower Value than the Value of the Preceding Alert

Bruce_L
Posted : Friday, February 13, 2015 2:03:04 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The really long formulas given in my Thursday, September 04, 2014 3:09:05 PM ET, Thursday, November 20, 2014 4:18:38 PM ET, Tuesday, February 10, 2015 11:54:20 AM ET and Tuesday, February 10, 2015 11:57:44 AM ET posts already compare the top or bottom to the previous top or bottom if it happened within the last 31 bars.

I can't really think of a reasonable way to create a formula which would check for the top or bottom before that instead.

I'm guessing the reason you want to do so in the first place is that there are intervening tops or bottoms which are identified by the formula that you don't visually see as being tops or bottows. The solution to that is to come up with a better definition of tops and bottows than the %K crossing through %D while above 80 or below 20. By better, I mean more closely matches what you consider a top or bottom in the Stochastic.

Note that it still needs to be something that can be identified with a relatively short formula, because the basic structure needs to be used twice for each period being checked. That's why the formulas are so long even though they are only checking 30 bars.

The formulas given in my Thursday, February 12, 2015 2:50:53 PM ET post were more a way to visualize where the tops and bottoms being compared are happening than anything else. They weren't really designed to allow you to actually scan for anything, just to allow you to understand how the other formulas work.



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