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 |

EasyScan with 2 conditions is not getting every symbol Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
thebull
Posted : Thursday, February 7, 2013 7:42:08 PM
Registered User
Joined: 8/4/2008
Posts: 7

Hi:

With the help of your support team, I have 2 conditions as follows:

True Range > Average True Range (see formula below)

and

Proce crossed any one of 3 Simple Moving Averages (see formula below)

The scan results seem to be working fine, but some symbols are not making the list.  AKAM is a good example of a symbol that was missed.  It actually crossed the 20, 50 and the 200 even though my condition is looking for anyone of these.  It also had a True Range that exceeded the ATR by a factor of over 4.

What am I missing?

Victor

 

***True Range > Average True Range condition***

 

(H -L + ABS(H - C1) + ABS(C1 - L)) / 2 > 
(AVGH14.1 - AVGL14.1) / 2 + 
(ABS(H1 - C2) + ABS(C2 - L1) + 
ABS(H2 - C3) + ABS(C3 - L2) + 
ABS(H3 - C4) + ABS(C4 - L3) + 
ABS(H4 - C5) + ABS(C5 - L4) + 
ABS(H5 - C6) + ABS(C6 - L5) + 
ABS(H6 - C7) + ABS(C7 - L6) + 
ABS(H7 - C8) + ABS(C8 - L7) + 
ABS(H8 - C9) + ABS(C9 - L8) + 
ABS(H9 - C10) + ABS(C10 - L9) + 
ABS(H10 - C11) + ABS(C11 - L10) + 
ABS(H11 - C12) + ABS(C12 - L11) + 
ABS(H12 - C13) + ABS(C13 - L12) + 
ABS(H13 - C14) + ABS(C14 - L13) + 
ABS(H14 - C15) + ABS(C15 - L14))
/ 28
 
*** Price Crossed any of 3 Simple Moving Averages ***
 
(C1 < AVGC20.1  and H > AVGC20) or (C1 > AVGC20.1  and L < AVGC20) or
(C1 < AVGC50.1  and H > AVGC50) or  (C1 > AVGC50.1  and L < AVGC50) or
(C1 < AVGC200.1  and H > AVGC200) or (C1 > AVGC200.1  and L < AVGC200)
Bruce_L
Posted : Friday, February 8, 2013 8:17:54 AM


Worden Trainer

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

Both formulas definitely return true for February 7, 2013 on a Daily Chart of AKAM and AKAM also shows up in an EasyScan containing both Conditions as EasyScan Conditions.

Does the List to Scan in your EasyScan include AKAM? Do you have any other EasyScan Conditions besides the two given in your post?

 



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thebull
Posted : Friday, February 8, 2013 8:49:53 AM
Registered User
Joined: 8/4/2008
Posts: 7

AKAM did not show up in my list.  My other conditions are as follows:

- Optionable is True

- Capitalization > 1000 (one billion)

- ATR < .70

- Volume 90-Day > 250000

Again, AKAM fits the conditions.

 

Victor

 

 

 

Bruce_L
Posted : Friday, February 8, 2013 8:55:53 AM


Worden Trainer

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

What is the period of your ATR that it is < .70 for AKAM?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thebull
Posted : Friday, February 8, 2013 11:42:26 AM
Registered User
Joined: 8/4/2008
Posts: 7

ATR = 14

Bruce_L
Posted : Friday, February 8, 2013 11:45:31 AM


Worden Trainer

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

ATR14 was 1.34 for AKAM on a February 7, 2013 daily chart.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thebull
Posted : Friday, February 8, 2013 12:06:30 PM
Registered User
Joined: 8/4/2008
Posts: 7

Right.....ATR14 of $1.34 is greater that 70 cents.

I'm having the same problem with LNKD today.  It was on my scan list this morning, but now it's gone.

 

Victor

Bruce_L
Posted : Friday, February 8, 2013 12:11:45 PM


Worden Trainer

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

The condition as listed in your post is for ATR < .70. That is less that 70 cents, not greater than 70 cents.

LNKD did not cross its 20, 50 or 200-Period Simple Moving Averages between yesterday and today no matter what the other requirements might be. It closed above all three moving averages on February 7, 2013 And has remained above all three moving averages so far today.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thebull
Posted : Friday, February 8, 2013 12:50:36 PM
Registered User
Joined: 8/4/2008
Posts: 7

Sorry, the post was wrong.  My condition is looking for symbols where ATR is greater than 70 cents.  

With regard to AKAM yesterday and LNKD today, both made the list early in the day and somehow got dropped off the list.  None of my conditions sould remove symbols once they've met the criteria.

Victor

Bruce_L
Posted : Friday, February 8, 2013 12:52:56 PM


Worden Trainer

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

Please contact technical support.



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