Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
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
|
|
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
|
|
Guest-1 |