Bruce_L 
Gold User, Platinum User, TeleChart, Worden Staff, Worden Training Agent

Worden Trainer 




Unsure 

Thursday, October 07, 2004 
Thursday, July 27, 2017 5:01:40 PM 
59,682 [21.16% of all post / 12.76 posts per day] 

Please try the following condition formula.
H  GREATEST(O, C) < (H  L) / 10 AND LEAST(O, C)  L > ABS(O  C) * 2 AND H1 > MAXH5.2
Bruce
Personal Criteria Formulas TC2000 Support Articles

We only carry the most recent block of pre / post market data. So the current pivot points on a 5minute chart would be calculated using the data from 9:30 AM through midnight ET yesterday when using pre / post market data.
Bruce
Personal Criteria Formulas TC2000 Support Articles

You can plot the following formulas as Custom PCF Indicators in the same pane and scale as price.
T3 (3, .7):
((7 / 10) ^ 3) * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3), 3), 3) + 3 * (((7 / 10) ^ 2) + ((7 / 10) ^ 3)) * XAVG(XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3), 3)  (6 * ((7 / 10) ^ 2) + 3 * ((7 / 10) + ((7 / 10) ^ 3))) * XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3) + (1 + 3 * (7 / 10) + ((7 / 10) ^ 3) + 3 * ((7 / 10) ^ 2)) * XAVG(XAVG(XAVGC3, 3), 3)
T3 (5, .7):
((7 / 10) ^ 3) * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5), 5), 5) + 3 * (((7 / 10) ^ 2) + ((7 / 10) ^ 3)) * XAVG(XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5), 5)  (6 * ((7 / 10) ^ 2) + 3 * ((7 / 10) + ((7 / 10) ^ 3))) * XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5) + (1 + 3 * (7 / 10) + ((7 / 10) ^ 3) + 3 * ((7 / 10) ^ 2)) * XAVG(XAVG(XAVGC5, 5), 5)
Bruce
Personal Criteria Formulas TC2000 Support Articles

You're welcome.
Bruce
Personal Criteria Formulas TC2000 Support Articles

I'm not sure if you wanted the 3 to crossup the 5 (which is what I wrote) or the 5 to crossup the 3.
XUP(((7 / 10) ^ 3) * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3), 3), 3) + 3 * (((7 / 10) ^ 2) + ((7 / 10) ^ 3)) * XAVG(XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3), 3)  (6 * ((7 / 10) ^ 2) + 3 * ((7 / 10) + ((7 / 10) ^ 3))) * XAVG(XAVG(XAVG(XAVGC3, 3), 3), 3) + (1 + 3 * (7 / 10) + ((7 / 10) ^ 3) + 3 * ((7 / 10) ^ 2)) * XAVG(XAVG(XAVGC3, 3), 3), ((7 / 10) ^ 3) * XAVG(XAVG(XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5), 5), 5) + 3 * (((7 / 10) ^ 2) + ((7 / 10) ^ 3)) * XAVG(XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5), 5)  (6 * ((7 / 10) ^ 2) + 3 * ((7 / 10) + ((7 / 10) ^ 3))) * XAVG(XAVG(XAVG(XAVGC5, 5), 5), 5) + (1 + 3 * (7 / 10) + ((7 / 10) ^ 3) + 3 * ((7 / 10) ^ 2)) * XAVG(XAVG(XAVGC5, 5), 5))
Bruce
Personal Criteria Formulas TC2000 Support Articles

You didn't specify a value, but you can change the zero in the following formula to something else.
XUP(MACD(1, 5), 0)
Bruce
Personal Criteria Formulas TC2000 Support Articles

So I am not quite sure what you want. If you want the price bar intersected by the moving average with the high above it:
'*****************************************************************
'*** StockFinder RealCode Condition  Version 5.0 www.worden.com
'*** Copy and paste this header and code into StockFinder *********
'*** Condition:Average Intersects Price Bar
'******************************************************************
If Price.High > Price.AVGC(8) AndAlso _
Price.AVGC(8) >= Price.Low Then
Pass
End If
If instead you want the high to have been at or below the moving average during the previous bar and above it now:
'*****************************************************************
'*** StockFinder RealCode Condition  Version 5.0 www.worden.com
'*** Copy and paste this header and code into StockFinder *********
'*** Condition:High Crossed Up Average
'******************************************************************
If Price.High > Price.AVGC(8) AndAlso _
Price.AVGC(8, 1) >= Price.High(1) Then
Pass
End If
If you want something else, we would need further clarification from you as to what you want.
Bruce
Personal Criteria Formulas TC2000 Support Articles

It is theoretically possible to write such formulas.
PCF for Order Statistics
And this technique can even be optimized somewhat using IIF() and CountTrue() functions. That said, writing a formula to find the 3 highest open prices in the last 6 months results in a formula which is way to long and slow to be practical or post in the forums.
Bruce
Personal Criteria Formulas TC2000 Support Articles

You're welcome.
Bruce
Personal Criteria Formulas TC2000 Support Articles

Those formulas have 26 period Bollinger Bands and 20 period Keltner Channels as mentioned in the post (because you seemed concerned about both the Keltner Channel period and average type).
If you are going to have exponential Bollinger Bands 26, 2.00 and exponential Keltner Channels 26, 1.50, then (in order of complexity of calculation):
Bollinger Bands narrower than Keltner Channels:
4 * STDDEV26 < 3 * XAVG(ATR, 26)
Both Bollinger Bands inside Keltner Channels:
XAVG((H + L + C) / 3  1.5 * ATR, 26) <= XAVGC26  2 * STDDEV26 AND XAVGC26 + 2 * STDDEV26 <= XAVG((H + L + C) / 3 + 1.5 * ATR, 26)
At least one Bollinger Band inside the Keltner Channels:
(XAVG((H + L + C) / 3  1.5 * ATR, 26) <= XAVGC26  2 * STDDEV26 AND XAVGC26  2 * STDDEV26 <= XAVG((H + L + C) / 3 + 1.5 * ATR, 26)) OR (XAVG((H + L + C) / 3  1.5 * ATR, 26) <= XAVGC26 + 2 * STDDEV26 AND XAVGC26 + 2 * STDDEV26 <= XAVG((H + L + C) / 3 + 1.5 * ATR, 26))
You can CountTrue() or TrueInRow() these formulas as desired.
Bruce
Personal Criteria Formulas TC2000 Support Articles

