I have set up a series of Easyscans, which work quite well to identify stocks/etfs which meet my criteria. They are all set to run on a daily timeframe. But I find it tedious to manually sort through the symbols in each scan, in order to select the ones for which I would buy calls, and the ones for which I would buy puts.

I wish that I could use one of my layouts as a spreadsheet; and on that spreadsheet, I wish to have a column for each of my easyscans, in which a checkmark or true/false mark would indicate whether a stock/etf in my watchlist showed up in that easyscan. I could then sort the watchlist for each column, and with a glance see in how many and in which scans individual stocks and etfs show up.

I think that I may get part of the way there, if the separate conditions used in each scan were set up as columns within a watchlist.

This is the list of easyscans which I most often use:

Close above R2

Close below S2

Close above 2 std.dev. envelope channel for 100 Regression Line

Close below 2 std.dev. envelope channel for 100 Regression Line

Cross Top Bollinger Band Down

Cross Bottom Bollinger Band Up

MACD Crossing Its Signal Line Down

MACD Crossing Its Signal Line Up

Moving Avg.10 Crossing Moving Avg.20 Down

Moving Avg. 10 Crossing Moving Avg.20 Up

Stochastics %K>80 And Crossing %D Down

Stochastics %K<20 And Crossing %D Up

Can you do all this work for me? Or could you lay out the steps That I should take in order to set up a sortable watchlist with these conditions?

Thank you

I worked on this, setting up conditions for scanning, and columns in a layout. I got pretty close to what I wanted; but I couldn't figure how to get the dual criteria for Stochastics the way I wanted to.

I set up a condition for when Stochastics %K 15-5 crosses %D5 up or down; but I couldn't come up with a way to set the parameters that %K still was above 80, or below 20. 

I will assume from your most recent post that you have figured out how to make WatchList Columns. If you want to combine multiple Conditions into a single WatchList Column, you will normally want to create a Condition Formula and then use that Condition Formula as a WatchList Column.

The following Condition Formula is for a Simple Stochastic 15,5 %K being above 80 and crossing down through its own 5-Period Simple %D:

80 < STOC15.5 AND STOC15.5 < AVG(STOC15.5,5) AND STOC15.5.1 >= AVG(STOC15.5.1,5)

The following Condition Formula is for a Simple Stochastic 15,5 %K being below 20 and crossing up through its own 5-Period Simple %D:

20 > STOC15.5 AND STOC15.5 > AVG(STOC15.5,5) AND STOC15.5.1 <= AVG(STOC15.5.1,5)

Understanding Stochastics

Thanks!

You're welcome.