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 |

EZ scan for stiocks with 3-5 consecutive down days Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
BRGZZ
Posted : Monday, July 20, 2009 2:07:21 AM
Registered User
Joined: 6/1/2006
Posts: 48
-Is there a scan I can use to find stocks with the last 3 days having been 3 consecutive down days, each with lower highs and lower lows than the previous day's high and low?

-Another for 3 to 5 consecutive down days within the most recent 3-5 days (each having lower consecutive daily highs and lows from the previous days high and low)?

-Another for stocks with higher consecutive weekly highs, and higher consecutive weekly lows over a period (such as a period of 5 to 10  weeks), 

Ultimately, the idea would be to take a list of stocks (such as the S&P 500), and filter out the ones that meet the above criteria ...a 3 to 5 day period of lower daily highs and lower daily lows, within the context of a longer term weekly uptrend with higher weekly highs and higher weekly lows. 
Not sure if I need a scan, a formila, or a filter to combine these criteria.

Thank you!
BRGZZ
Posted : Monday, July 20, 2009 2:12:51 AM
Registered User
Joined: 6/1/2006
Posts: 48
PS- Actually, 3-5 consecutive lower daily highs would be needed to find  (lower daily lows would not be necessary for the daily scan). The weekly part should be higher weekly highs AND higher weekly lows.
Bruce_L
Posted : Monday, July 20, 2009 1:38:18 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (BRGZZ)
Is there a scan I can use to find stocks with the last 3 days having been 3 consecutive down days, each with lower highs and lower lows than the previous day's high and low?

If you need at least 3 consecutive down days with lower highs and lowers lows:

H < H1 AND H1 < H2 AND H2 < H3 AND L < L1 AND L1 < L2 AND L2 < L3

If you need exactly 3 consecutive down days with lower highs and lower lows:

H < H1 AND H1 < H2 AND H2 < H3 AND L < L1 AND L1 < L2 AND L2 < L3 AND (H3 >= H4 OR L3 >= L4)

QUOTE (BRGZZ)
Another for 3 to 5 consecutive down days within the most recent 3-5 days (each having lower consecutive daily highs and lows from the previous days high and low)?

ABS(H < H1 AND L < L1) - (H1 < H2 AND L1 < L2) - (H2 < H3 AND L2 < L3) - (H3 < H4 AND L3 < L4) - (H4 < H5 AND L4 < L5) >= 3

QUOTE (BRGZZ)
Another for stocks with higher consecutive weekly highs, and higher consecutive weekly lows over a period (such as a period of 5 to 10  weeks)

For this to have happened over at least 5-Weeks (5-Trading Days being a Week), please try the following:

MAXH5 > MAXH5.5 AND MAXH5.5 > MAXH5.10 AND MAXH5.10 > MAXH5.15 AND MAXH5.15 > MAXH5.20 AND MAXH5.20 > MAXH5.25 AND MINL5 > MINL5.5 AND MINL5.5 > MINL5.10 AND MINL5.10 > MINL5.15 AND MINL5.15 > MINL5.20 AND MINL5.20 > MINL5.25

QUOTE (BRGZZ)
Ultimately, the idea would be to take a list of stocks (such as the S&P 500), and filter out the ones that meet the above criteria ...a 3 to 5 day period of lower daily highs and lower daily lows, within the context of a longer term weekly uptrend with higher weekly highs and higher weekly lows.

MAXH5 > MAXH5.5 AND MAXH5.5 > MAXH5.10 AND MAXH5.10 > MAXH5.15 AND MAXH5.15 > MAXH5.20 AND MAXH5.20 > MAXH5.25 AND MINL5 > MINL5.5 AND MINL5.5 > MINL5.10 AND MINL5.10 > MINL5.15 AND MINL5.15 > MINL5.20 AND MINL5.20 > MINL5.25 AND H < H1 AND H1 < H2 AND H2 < H3 AND L < L1 AND L1 < L2 AND L2 < L3

QUOTE (BRGZZ)
Actually, 3-5 consecutive lower daily highs would be needed to find  (lower daily lows would not be necessary for the daily scan). The weekly part should be higher weekly highs AND higher weekly lows.

MAXH5 > MAXH5.5 AND MAXH5.5 > MAXH5.10 AND MAXH5.10 > MAXH5.15 AND MAXH5.15 > MAXH5.20 AND MAXH5.20 > MAXH5.25 AND MINL5 > MINL5.5 AND MINL5.5 > MINL5.10 AND MINL5.10 > MINL5.15 AND MINL5.15 > MINL5.20 AND MINL5.20 > MINL5.25 AND H < H1 AND H1 < H2 AND H2 < H3

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
BRGZZ
Posted : Monday, July 20, 2009 2:13:29 PM
Registered User
Joined: 6/1/2006
Posts: 48
QUOTE (BRGZZ)
Ultimately, the idea would be to take a list of stocks (such as the S&P 500), and filter out the ones that meet the above criteria ...a 3 to 5 day period of lower daily highs and lower daily lows, within the context of a longer term weekly uptrend with higher weekly highs and higher weekly lows.

MAXH5 > MAXH5.5 AND MAXH5.5 > MAXH5.10 AND MAXH5.10 > MAXH5.15 AND MAXH5.15 > MAXH5.20 AND MAXH5.20 > MAXH5.25 AND MINL5 > MINL5.5 AND MINL5.5 > MINL5.10 AND MINL5.10 > MINL5.15 AND MINL5.15 > MINL5.20 AND MINL5.20 > MINL5.25 AND H < H1 AND H1 < H2 AND H2 < H3 AND L < L1 AND L1 < L2 AND L2 < L3

---when I am creating a PCF using the above code, and I click the TEST button, I get the following:

"Result: False ... Criterion Information- Market data needed to calculate criterion 31

also with this code:

QUOTE (BRGZZ)
Actually, 3-5 consecutive lower daily highs would be needed to find  (lower daily lows would not be necessary for the daily scan). The weekly part should be higher weekly highs AND higher weekly lows.

MAXH5 > MAXH5.5 AND MAXH5.5 > MAXH5.10 AND MAXH5.10 > MAXH5.15 AND MAXH5.15 > MAXH5.20 AND MAXH5.20 > MAXH5.25 AND MINL5 > MINL5.5 AND MINL5.5 > MINL5.10 AND MINL5.10 > MINL5.15 AND MINL5.15 > MINL5.20 AND MINL5.20 > MINL5.25 AND H < H1 AND H1 < H2 AND H2 < H3



Bruce_L
Posted : Monday, July 20, 2009 2:18:03 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
The message is not an error message. It is an informative message letting you know the formula is not True for the test symbol and will not calculate for symbols with less than 31 market days of data.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
BRGZZ
Posted : Monday, July 20, 2009 10:16:15 PM
Registered User
Joined: 6/1/2006
Posts: 48

I created a PCF with your code as follows:

MAXH5 > MAXH5.5 AND MAXH5.5 > MAXH5.10 AND MAXH5.10 > MAXH5.15 AND MAXH5.15 > MAXH5.20 AND MAXH5.20 > MAXH5.25 AND MINL5 > MINL5.5 AND MINL5.5 > MINL5.10 AND MINL5.10 > MINL5.15 AND MINL5.15 > MINL5.20 AND MINL5.20 > MINL5.25 AND H < H1 AND H1 < H2 AND H2 < H3


Then I created an Easy Scan of
Russell 3000
with the PCF as a condition

Some of the results seem to be in weekly downtrends.

---------------------------------------------------

By using a your PCF to find 3 down days as follows:


H < H1 AND H1 < H2 AND H2 < H3 AND L < L1 AND L1 < L2 AND L2 < L3 AND (H3 >= H4 OR L3 >= L4) 


...I get mostly good results. But, I'd like to create an EZ scan that takes the Russell 3000 stocks and picks out only the ones with 3 consecutive down days (as the above code seems to do), and add the condition that the stocks must be above their 50-day SMA. 

PS: Is there a way to futher limit the stocks to those with an uptrending 50-day SMA or 10-day SMA?

Thanks again Bruce!

BRGZZ
Posted : Monday, July 20, 2009 10:29:36 PM
Registered User
Joined: 6/1/2006
Posts: 48

,,,For example, the other condition to add could be that the 50-day SMA is above the 200-day SMA
and the 20-day SMA is above the 40-day SMA 

Bruce_L
Posted : Tuesday, July 21, 2009 9:40:23 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (BRGZZ)
I created a PCF with your code as follows:

MAXH5 > MAXH5.5 AND MAXH5.5 > MAXH5.10 AND MAXH5.10 > MAXH5.15 AND MAXH5.15 > MAXH5.20 AND MAXH5.20 > MAXH5.25 AND MINL5 > MINL5.5 AND MINL5.5 > MINL5.10 AND MINL5.10 > MINL5.15 AND MINL5.15 > MINL5.20 AND MINL5.20 > MINL5.25 AND H < H1 AND H1 < H2 AND H2 < H3


Then I created an Easy Scan of
Russell 3000
with the PCF as a condition

Some of the results seem to be in weekly downtrends.

Can you provide some of these anomalous results as examples?

QUOTE (BRGZZ)
By using a your PCF to find 3 down days as follows:


H < H1 AND H1 < H2 AND H2 < H3 AND L < L1 AND L1 < L2 AND L2 < L3 AND (H3 >= H4 OR L3 >= L4) 


...I get mostly good results. But, I'd like to create an EZ scan that takes the Russell 3000 stocks and picks out only the ones with 3 consecutive down days (as the above code seems to do), and add the condition that the stocks must be above their 50-day SMA.

Just add AND C > AVGC50 to the end of the formula:

H < H1 AND H1 < H2 AND H2 < H3 AND L < L1 AND L1 < L2 AND L2 < L3 AND (H3 >= H4 OR L3 >= L4) AND C > AVGC50

QUOTE (BRGZZ)
Is there a way to futher limit the stocks to those with an uptrending 50-day SMA or 10-day SMA?
...
For example, the other condition to add could be that the 50-day SMA is above the 200-day SMA
and the 20-day SMA is above the 40-day SMA

Just add AND AVGC50 > AVGC200 AND AVGC20 > AVGC40 to the end of the formula:

H < H1 AND H1 < H2 AND H2 < H3 AND L < L1 AND L1 < L2 AND L2 < L3 AND (H3 >= H4 OR L3 >= L4) AND C > AVGC50 AND AVGC50 > AVGC200 AND AVGC20 > AVGC40

You may wish to review the following:

Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
BRGZZ
Posted : Wednesday, July 22, 2009 1:52:55 PM
Registered User
Joined: 6/1/2006
Posts: 48
Thanks Bruce ,,,I appreciate that!

One final question:
What would be the code to add a formula condition that reqires the stock's most recent quarterly EPS to have increased over the previous quarter? Over the previous 2 quarters?

Also, another seperate condition to require that the most recent quaterly EPS be up a minimum of 25% over the previous quarter.


Thanks again~
Bruce_L
Posted : Wednesday, July 22, 2009 2:26:12 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Fundamental Criteria in TeleChart are limited to the most recent value of the built in Fundamental System Criteria because TeleChart's Personal Criteria Formula Language does not have syntax for referencing other symbols, past values or fundamentals.

This means there isn't a formula you could use. The closest built  in Fundamental System Criteria that you could use as EasyScan Conditions would be:

Definitions of all built in scanning and sorting criteria
Using EasyScan to find stocks that meet your own criteria

EPS Latest Qtr - Fully Diluted earnings per share from Total Operations, as taken from the latest 3-month ending period.

EPS Percent Change (Latest Q) - The percentage change in earnings per share from the comparable quarter a year before. Timely stocks will usually have strong recent quarterly earnings to validate the annual earnings strength. This reads in percentage.

EPS Percent Change (2nd Q back) - The percentage change in earnings per share from the comparable quarter a year before.

EPS Percent Change (3rd Q back) - The percentage change in earnings per share from the comparable quarter a year before.

EPS Percent Change (4th Q back) - The percentage change in earnings per share from the comparable quarter a year before.

EPS Percent Change (Latest Yr) - The percentage change in earnings for the latest 4 quarters compared to the preceding 4 quarters. An appropriate criterion to include in many types of screens. Also a common criterion to sort by, with the best earners on top.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Quiktdr
Posted : Monday, January 8, 2018 2:12:24 PM
Registered User
Joined: 10/7/2004
Posts: 794

I created this PCF for consecutive highs and when I test it reads true or false but when I use it on my chart even for DJ-30 components it reads FORMULA ERROR!!! Not enough data to calculate

When I use similar formula for consecutive lows there is no problem

 

{10H} ABS(C > C9 AND C > C8 AND C > C7 AND C > C6 AND C > C5 AND C > C4 AND C > C3 AND C > C2 AND C >C1)*H AND C<XAVGC200

Bruce_L
Posted : Monday, January 8, 2018 2:31:48 PM


Worden Trainer

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

The part of the formula requiring the most data is the XAVGC200.

Select Databank | Personal Criteria Formulas and make sure Include criteria which require more than 250 days of history (slower) is checked.

If this does not resolve the issue, please contact technical support.

That said, I am not sure what the * H thing is supposed to do this in this case. This will cause the formula to return a numeric value for the part of the formula before the AND and true or false for the portion of the formua after the end.

You probably want either:

C > MAXC9.1 AND C < XAVGC200

Or:

H > MAXH9.1 AND C < XAVGC200



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Quiktdr
Posted : Monday, January 8, 2018 2:45:31 PM
Registered User
Joined: 10/7/2004
Posts: 794

I understand your response but when I test it reads true or false it just doesn't show on chart as the

{10 DAY LOW} ABS(C < C9 AND C < C8 AND C < C7 AND C < C6 AND C < C5 AND C < C4 AND C < C3 AND C < C2 AND C < C1) * L AND C > XAVGC200  

 

Reads True or false on tests and shows on chart 

Thank you Bruce

Bruce_L
Posted : Monday, January 8, 2018 2:48:33 PM


Worden Trainer

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

Even if it works (because the part before the AND is either zero or not zero), you really shouldn't write it that way.

That should either be (probably the first one if you want it to match the old version):

C < MINC9.1 AND C > XAVGC200

Or:

L < MINL9.1 AND C > XAVGC200



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Quiktdr
Posted : Monday, January 8, 2018 2:53:31 PM
Registered User
Joined: 10/7/2004
Posts: 794

Okay thank you Bruce!!

Bruce_L
Posted : Monday, January 8, 2018 2:54:01 PM


Worden Trainer

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

You're welcome. Note I did make a change to the formulas. They had used MINC9, MAXC9, MINL9, and MAXH9, but should have used MINC9.1, MAXC9.1, MINL9.1, and MAXH9.1.



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