Hi. I watched some of your videos on pcf formula.

I need help on finding formula to set up  oversold stocks thats creating  higher lows in last 10 days, also nearing a  moving average with some volume! Thank you.

The trainers can't actually offer setting, interpretation or investment advice, so we can't really suggest what makes a stock "oversold" for example. We need an unambiguous objective definition of the exact pattern you are attempting to identify.

What specifically do you mean by oversold? Is stochastics or RSI above some arbitrary value? If so, what are the exact settings of the stochastic or RSI and what is the value.

Let's say you wanted a 14-period plain RSI (not Wilder's Smoothed) to be above 70. That could be written as follows.

RSI14 > 70

When you say the stock is "creating high lows in the last 10 days", do you mean that all of the lows in the most recent ten bars are increasing compared to the bar before?

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

Or do you mean that some definition of a "low" has happened in the most recent 10 days. And at the point of this "low", the value was higher than the previous time this particula definition of a "low" most recently occurred? If this is what you mean, we probably can't make a Condition Formula for it, but that would depend on the specific definitions used.

Or do you mean something else entirely?

Does "nearing a moving average" mean price is closer to the moving average than it was during the previous bar? The following would check for current or closing price to be closer to a 30-period simple moving average during this bar than the previous bar.

ABS(C - AVGC30) < ABS(C1 - AVGC30.1)

Or did you have something else in mind?

Thanks a lot, i am testing the code. I wil update you soon if thats wht i meant. its bit complex, software languages i understand that. but great help.

You're welcome. I'm fairly confident the concepts will need some refinement. Defining exactly what I want is generally the more difficult part for me. Coding the result follows from the definitions.

 It was close, not exact, Can you please create one similar to the my last question, where last 4-5 days bars are making lower highs, also its touching  lower of bollinger band!

The following Condition Formula should check for the most recent 4 bars to have lower highs and for each of these four bars to be intersected by the simple lower Bollinger Band 20, 2.00.

H < H1 AND ABS(AVGC20 - 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) - (H + L) /2) <= (H - L) / 2 AND H1 < H2 AND ABS(AVGC20.1 - 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20) - (H1 + L1) /2) <= (H1 - L1) / 2 AND H2 < H3 AND ABS(AVGC20.2 - 2 * SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 20) - (H2 + L2) /2) <= (H2 - L2) / 2 AND H3 < H4 AND ABS(AVGC20.3 - 2 * SQR(ABS(C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 - 20 * AVGC20.3 ^ 2) / 20) - (H3 + L3) /2) <= (H3 - L3) / 2

The Condition Formula would need to be adjusted for different Bollinger Band settings.

Understanding MACD

Thank you sir, appreciate it, most of the set ups showing middle of the bollinger band or higher of the band where as i expected lower of the band!! we need to tweak something in coding i believe for specific.  4 days lower high low is good, i use bollinger band 20.2 from your scanner. Examples of  stocks set up i am looking in the pcf formula something like this stocks from today  - $xon $vxx $hlf 

What symbols are you getting? What time frame are you using? When I use the Condition Formula in a daily time frame, I currently get ATHX, BCH, BORN, BSAC, ECT, GBR, MEAS, NWBO, SSTK and VMM (these symbols can change throughout the day).

All of the symbols have the lower Bollinger Band intersecting the four most recent bars. The bars are not near the upper Bollinger Band.

XON would have returned true most recently in a daily time frame on Friday, August 22, 2014. VXX has prices closer to the middle than the bottom of the Bollinger Band in a daily time frame. HLF was close to the Bollinger Bands on the two most recent bar, but the prices aren't actually touching the lower Bollinger Bands yet in a daily time frame.

Note that Daily is the shortest time frame which can be used for the formula in TC2000 Gold if you want to use it in a sort or scan. You could plot the Condition Formula as a Custom PCF % True Indicator in shorter time frames in TC2000 Gold, but you would need TC2000 Platinum to sort or scan using intraday time frames.