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 |

what's wrong with this formula? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Mortyk
Posted : Monday, January 3, 2011 3:48:58 PM
Registered User
Joined: 2/15/2009
Posts: 9
(AVGC10.1<AVG20.1 AND AVGC10>AVGC20)
diceman
Posted : Monday, January 3, 2011 3:53:44 PM
Registered User
Joined: 1/28/2005
Posts: 6,049

(AVGC10.1<AVG    20.1ANDAVGC10>AVGC20) 

No close where space is, you probably ment this:


(AVGC10.1<AVGC20.1ANDAVGC10>AVGC20) 



Thanks
diceman

montecarlos
Posted : Tuesday, January 4, 2011 1:11:03 AM

Registered User
Joined: 4/10/2007
Posts: 38

Consider this:

SMA10 crossing SMA20 today & the Slope of SMA10 > 5% in five days
and slope of SMA20 > 8% in ten days

Taking Diceman's syntax fix and screen additionally for 

.... an upsloping SMA10 over 5 days 

.... and/or an SMA20 over 10 days.

Just cut & paste as you see fit:

(AVGC10.1<AVGC20.1ANDAVGC10>AVGC20) and

( 100 * ((SMA10 / SMA10.5) -1) > 5 and

( 100 * ((SMA20 / SMA20.10) -1) > 8

This will eliminate "flat" trending SMA crossovers (which aren't
exactly the holy grail) and keep you focused on crossover charts 
which also possess currently upsloping SMA10's or SMA20's.

Experiment with additional filter's, market cap, ROE,
etc. and adjust the "5" or "8" price percent gain value to any other 
(PPG) you deem appropriate for a 10 or 20 day period.

Slope of the SMA is measured as a PPG to normalize the various price
values.

I think you will be pleased.

Note that your "today only" crossover screen will not produce symbols tomorrow which 
have continued upward after today's crossover - so you may be missing some
good crossover trades who left the station yesterday and are now headed
steadily northeast.

You can adjust your screen back a day like this to find yesterdays 
SMA10/20 crossovers, and then see how they are doing today:

(AVGC10.2<AVGC20.2ANDAVGC10.1>AVGC20.1)

and the day before yesterday's SMA10/20 crossovers

(AVGC10.3<AVGC20.3ANDAVGC10.2>AVGC20.2)

and so forth.

You can also screen for crossovers based upon an average
of the high's vice a close price ... just substitute an "H" for the 
C's.

Or the SMA20 crossing the SMA50:

AVGC20 > AVGC50
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.