Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I can give you the general structure of the formula out to where the first low can be up to 6 bars ago, but it gets too long and slow to be practical or post in the forums if you go out any further than that.
AVG(H1 + L1, 5) < AVG(H1 + L1, 34) AND TrueInRow(AVG(H + L, 5) - AVG(H + L, 34) > AVG(H1 + L1, 5) - AVG(H1 + L1, 34), 2) = 1 AND L1 < IIF(AVG(H3 + L3, 5) < AVG(H3 + L3, 34) AND TrueInRow(AVG(H2 + L2, 5) - AVG(H2 + L2, 34) > AVG(H3 + L3, 5) - AVG(H3 + L3, 34), 2) = 1, IIF(AVG(H + L, 5) - AVG(H + L, 34) > AVG(H3 + L3, 5) - AVG(H3 + L3, 34), L2, L1), IIF(AVG(H4 + L4, 5) < AVG(H4 + L4, 34) AND TrueInRow(AVG(H3 + L3, 5) - AVG(H3 + L3, 34) > AVG(H4 + L4, 5) - AVG(H4 + L4, 34), 2) = 1, IIF(AVG(H + L, 5) - AVG(H + L, 34) > AVG(H4 + L4, 5) - AVG(H4 + L4, 34), L3, L1), IIF(AVG(H5 + L5, 5) < AVG(H5 + L5, 34) AND TrueInRow(AVG(H4 + L4, 5) - AVG(H4 + L4, 34) > AVG(H5 + L5, 5) - AVG(H5 + L5, 34), 2) = 1, IIF(AVG(H + L, 5) - AVG(H + L, 34) > AVG(H5 + L5, 5) - AVG(H5 + L5, 34), L4, L1), IIF(AVG(H6 + L6, 5) < AVG(H6 + L6, 34) AND TrueInRow(AVG(H5 + L5, 5) - AVG(H5 + L5, 34) > AVG(H6 + L6, 5) - AVG(H6 + L6, 34), 2) = 1, IIF(AVG(H + L, 5) - AVG(H + L, 34) > AVG(H6 + L6, 5) - AVG(H6 + L6, 34), L5, L1), IIF(AVG(H7 + L7, 5) < AVG(H7 + L7, 34) AND TrueInRow(AVG(H6 + L6, 5) - AVG(H6 + L6, 34) > AVG(H7 + L7, 5) - AVG(H7 + L7, 34), 2) = 1, IIF(AVG(H + L, 5) - AVG(H + L, 34) > AVG(H7 + L7, 5) - AVG(H7 + L7, 34), L6, L1), L1)))))
The inverse has the same limitations.
AVG(H1 + L1, 5) > AVG(H1 + L1, 34) AND TrueInRow(AVG(H + L, 5) - AVG(H + L, 34) < AVG(H1 + L1, 5) - AVG(H1 + L1, 34), 2) = 1 AND H1 > IIF(AVG(H3 + L3, 5) > AVG(H3 + L3, 34) AND TrueInRow(AVG(H2 + L2, 5) - AVG(H2 + L2, 34) < AVG(H3 + L3, 5) - AVG(H3 + L3, 34), 2) = 1, IIF(AVG(H + L, 5) - AVG(H + L, 34) < AVG(H3 + L3, 5) - AVG(H3 + L3, 34), H2, H1), IIF(AVG(H4 + L4, 5) > AVG(H4 + L4, 34) AND TrueInRow(AVG(H3 + L3, 5) - AVG(H3 + L3, 34) < AVG(H4 + L4, 5) - AVG(H4 + L4, 34), 2) = 1, IIF(AVG(H + L, 5) - AVG(H + L, 34) < AVG(H4 + L4, 5) - AVG(H4 + L4, 34), H3, H1), IIF(AVG(H5 + L5, 5) > AVG(H5 + L5, 34) AND TrueInRow(AVG(H4 + L4, 5) - AVG(H4 + L4, 34) < AVG(H5 + L5, 5) - AVG(H5 + L5, 34), 2) = 1, IIF(AVG(H + L, 5) - AVG(H + L, 34) < AVG(H5 + L5, 5) - AVG(H5 + L5, 34), H4, H1), IIF(AVG(H6 + L6, 5) > AVG(H6 + L6, 34) AND TrueInRow(AVG(H5 + L5, 5) - AVG(H5 + L5, 34) < AVG(H6 + L6, 5) - AVG(H6 + L6, 34), 2) = 1, IIF(AVG(H + L, 5) - AVG(H + L, 34) < AVG(H6 + L6, 5) - AVG(H6 + L6, 34), H5, H1), IIF(AVG(H7 + L7, 5) > AVG(H7 + L7, 34) AND TrueInRow(AVG(H6 + L6, 5) - AVG(H6 + L6, 34) < AVG(H7 + L7, 5) - AVG(H7 + L7, 34), 2) = 1, IIF(AVG(H + L, 5) - AVG(H + L, 34) < AVG(H7 + L7, 5) - AVG(H7 + L7, 34), H6, H1), H1)))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|