I would like scans that tell me when price action is at a significant area (moving average, VWAP, etc.) and Stochastics are at an oversold/overbought condition.

Basically i would like a real-time scan of a watchlist that would display columns for the following (i can make columns for each, but would like a consolidated column for VWAP crossing; Moving average crossing, etc.)

I would like:

Price crossing up or down through VWAP (a single column)

Price crossing up or down through 5 sma (a single column) - ability to chage timeframes (5min most handy at this time)

Price crossing up or down through 15 sma (a single column) - ability to chage timeframes (5min most handy at this time - i understand this may require adjusting the condition parameters)

5sma crossing up or down through 15sma (a single column) - ability to chage timeframes (5min most handy at this time - i understand this may require adjusting the condition parameters)

50sma crossing up or down through 200sma (a single column) - ability to chage timeframes (daily most handy at this time - i understand this may require adjusting the condition parameters)

Overbought on 5min Stochs (14, 3, 3)

Oversold on 5min Stochs (14, 3, 3)

Possibly price crossing Pivot points: crossing above or below

I hope this is understandable enough to create conditions. My idea is to have one watchlist that scans conditions with minimal columns.

There isn't a way to OR conditions unless they can created as a Condition Formula instead of being created by clicking on indicator and selecting Create Scan Condition. I do not know of a way to create VWAP using a formula because there is no way to determine the first bar of the day using the Personal Criteria Formula Language.

This means I can't create single WatchList Columns for price crossing either up or down through VWAP any more than you could.

Price crossing up or down through a moving average can be created. The 5-Period Simple Moving Average is:

SGN(C - AVGC5) <> SGN(C1 - AVGC5.1)

The 15-Period Simple Moving Average is:

SGN(C - AVGC15) <> SGN(C1 - AVGC15.1)

And the 200-Period Simple Moving Average is:

SGN(C - AVGC200) <> SGN(C1 - AVGC200.1)

You can create the Stochastic Conditions by just clicking on them and selecting Create Scan Condition.

I do not know of a way to create a Condition Formula for price crossing through the Pivot Points using an intraday Time Frame. We run into the same issue we did with VWAP. There is no way to determine when the trading day starts and ends to actually calculate the Pivot Points (we can only calculate them on a Daily chart).