Registered User Joined: 6/25/2008 Posts: 14
|
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
|
Registered User Joined: 6/25/2008 Posts: 14
|
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.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
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
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 6/25/2008 Posts: 14
|
Thanks!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|