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 |

stocks crossing their 20 day moving average Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
tpdavis
Posted : Friday, May 19, 2006 12:19:28 PM
Registered User
Joined: 4/2/2006
Posts: 38
Hey Craig and Bruce, how are you guys !!!

I've been gone for a while so I'm finally back, I had to wipe my entire hard drive clean due to viruses. So I'm starting over from scratch because I didn't realize that I could have backed up to your server.

Well, can you send me a pcf that would scan for all stocks with the following parameteters:

-Crossed it's 20 day moving average by 15days
-$1 to $10 per share
-Good EPS over the past year(one year would coverthe last four quarters)
-Volume in the thousands over the past 5 days so I know its liquid

I tried to do this on my own but I made a big mess today so I'm frustrated already. I figured I'd better call the doctor's I missed you guys also, glad to be back.

Thanks guys
Bruce_L
Posted : Friday, May 19, 2006 12:48:42 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (tpdavis)
Crossed it's 20 day moving average by 15days

I have absolutely no idea what this means, so I'll take a wild guess (since my guess will probably be wrong, consider this a starting point that we can change after some clarification). My guess is... the Closing Price crossed the 20-Period Exponential Moving Average of Price at least once in either direction during the last 15-Periods:

C crossed XAVGC20 15-Periods:

(C > XAVGC20) + (C1 > XAVGC20.1) + (C2 > XAVGC20.2) + (C3 > XAVGC20.3) + (C4 > XAVGC20.4) + (C5 > XAVGC20.5) + (C6 > XAVGC20.6) + (C7 > XAVGC20.7) + (C8 > XAVGC20.8) + (C9 > XAVGC20.9) + (C10 > XAVGC20.10) + (C11 > XAVGC20.11) + (C12 > XAVGC20.12) + (C13 > XAVGC20.13) + (C14 > XAVGC20.14) < 0 AND (C < XAVGC20) + (C1 < XAVGC20.1) + (C2 < XAVGC20.2) + (C3 < XAVGC20.3) + (C4 < XAVGC20.4) + (C5 < XAVGC20.5) + (C6 < XAVGC20.6) + (C7 < XAVGC20.7) + (C8 < XAVGC20.8) + (C9 < XAVGC20.9) + (C10 < XAVGC20.10) + (C11 < XAVGC20.11) + (C12 < XAVGC20.12) + (C13 < XAVGC20.13) + (C14 < XAVGC20.14) < 0

Then create an EasyScan:

Select New | New EasyScan.
- Watchlist: All Stocks
- C crossed XAVGC20 15-Periods: True
- Price Per Share: 1 to 10
- Volume 5-Day: Value: ? to Max
- EPS Latest Qtr: ? to Max
- EPS Percent Change Latest Yr: ? to Max
- EPS Percent Change Latest Qtr: ? to Max
- EPS Percent Change 2nd Qtr Back: ? to Max
- EPS Percent Change 3rd Qtr Back: ? to Max
- EPS Percent Change 4th Qtr Back: ? to Max

I included all of the EPS criteria but can't suggest which you should actually use (or even if you should use Value, Market Rank or List Rank). I also cannot suggest what ranges to use where I put question marks. You may wish to review the following:

Using EasyScan to find stocks that meet your own criteria
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
Definitions of all built in scanning and sorting criteria

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tpdavis
Posted : Friday, May 19, 2006 2:42:18 PM
Registered User
Joined: 4/2/2006
Posts: 38
Hey Bruce,

I got the response back from you, I don't want to use an exponential moving average, I'd rather use a simple moving average first of all.

Second, forget all the other stuff that I put into the criteria, redo the formula for stocks that have crossed above its 20 day moving average for the past 15 days.

Don't worry about volume, EPS, or anything else that was previously mentioned.

tpdavis
Bruce_L
Posted : Friday, May 19, 2006 3:20:50 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Here are a two possibilities to try. Let me know how they work and we can go from there:

Price crossed up through SMA20 last 15-Periods:
C > AVGC20 AND (C1 < AVGC20.1 OR C2 < AVGC20.2 OR C3 < AVGC20.3 OR C4 < AVGC20.4 OR C5 < AVGC20.5 OR C6 < AVGC20.6 OR C7 < AVGC20.7 OR C8 < AVGC20.8 OR C9 < AVGC20.9 OR C10 < AVGC20.10 OR C11 < AVGC20.11 OR C12 < AVGC20.12 OR C13 < AVGC20.13 OR C14 < AVGC20.14)

Price above SMA20 for last 15-Periods:
C > AVGC20 AND C1 > AVGC20.1 AND C2 > AVGC20.2 AND C3 > AVGC20.3 AND C4 > AVGC20.4 AND C5 > AVGC20.5 AND C6 > AVGC20.6 AND C7 > AVGC20.7 AND C8 > AVGC20.8 AND C9 > AVGC20.9 AND C10 > AVGC20.10 AND C11 > AVGC20.11 AND C12 > AVGC20.12 AND C13 > AVGC20.13 AND C14 > AVGC20.14

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