Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Creating Columns for Conditions/Using a layout as a spreadsheet. Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
agbrina
Posted : Saturday, April 20, 2013 3:20:03 PM
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

 

agbrina
Posted : Sunday, April 21, 2013 11:36:12 PM
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. 

Bruce_L
Posted : Monday, April 22, 2013 7:35:42 AM


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
agbrina
Posted : Monday, April 22, 2013 9:31:02 AM
Registered User
Joined: 6/25/2008
Posts: 14

Thanks!

Bruce_L
Posted : Monday, April 22, 2013 9:31:45 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.