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 |

Moving average crossing scan Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
srkaldi
Posted : Monday, October 23, 2006 1:05:54 AM
Registered User
Joined: 12/15/2004
Posts: 81
Hi There,

My dislyxia is mesning me up on this scan....for pfc...

I would like a scan for when the 20, 50 and 200 day moving averages meet.

This is not a bullish or bearish reqquirement, just when they meet at any price.

Thanks

Loyal and faithful TC-2000 client !
Craig_S
Posted : Monday, October 23, 2006 8:20:46 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Try sorting any WatchList by this condition in ASCENDING order:

100*(ABS(AVGC20-AVGC50) +ABS(AVGC20-AVGC200) +ABS(AVGC50-AVGC200) +ABS(C-AVGC20) +ABS(C-AVGC50) +ABS(C-AVGC200))/AVGC200

Here are two videos to review: How to create a Personal Criteria Forumula (PCF)
Create your own stock rankings using WatchLists and Sort conditions

- Craig
Here to Help!
bustermu
Posted : Monday, October 23, 2006 10:10:13 AM
Registered User
Joined: 1/1/2005
Posts: 2,645
Craig,

The PCF could return a large number under the conditions:

AVGC20 = AVGC50 = AVGC200

There was no requirement that C be close to the three moving averages.

A PCF for the maximum distance apart of the three moving averages (MAs) as a percent of the average of the MAs is:

100*(ABS(AVGC20-AVGC50)+ABS(AVGC20-AVGC200)+ABS(AVGC50-AVGC200))
/(2*(AVGC20+AVGC50+AVGC200)/3)

Warning: This form does not extend directly to four or more MAs.

Thanks,
Jim Murphy
Craig_S
Posted : Monday, October 23, 2006 10:12:58 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
I misread "they meet at any price" to say "meet at price".

- Craig
Here to Help!
srkaldi
Posted : Monday, October 23, 2006 8:51:39 PM
Registered User
Joined: 12/15/2004
Posts: 81
Hi,

I do not want the maximun distance apart, I want them all touching,,,the 20, the 50 and the 200...


Thanks

Srk
diceman
Posted : Monday, October 23, 2006 8:57:01 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
srkaldi

You best case will be when the
maximum is low.

It is very unlikly they will
touch.

They will just get close.


Thanks
diceman
srkaldi
Posted : Monday, October 23, 2006 9:19:29 PM
Registered User
Joined: 12/15/2004
Posts: 81

Thanks DICEMAN and, you are as wet as the ATLANTIC ocean...

There are many...look at ARNA IN June...all 3 met !

Feedback is good, unknowledgable, guessing feedback is BAD...

Steve
diceman
Posted : Monday, October 23, 2006 9:47:28 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
Are you sure you have your averages are plotted correctly?

(averages of price)

They do not meet on ARNA.

Why do you think you received the answers you did?

(using a relative sort)

I assure you it is very rare for all three to have the exact same value.
(on the same day)

You can try.

AVGC20=AVGC50ANDAVGC50=AVGC200

I don't think you will get many hits.

(that's why it is best to search for how close they are)

Thanks
diceman (still underwater)





diceman
Posted : Monday, October 23, 2006 10:04:28 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
What I don't think you are understanding.
(assuming you have your averages plotted correctly)
On ARNA
The 20 touches the 200 (may just be close) on about 5-25-06
The 50 touches the 200 (may just be close) on about 6-20-06

How would we scan on 5-25-06 for what will happen on 6-20-06?

My statement referred to all three touching on the same day.

It makes more sense to look for a tight grouping of averages.
What good is a scan that gives no hits?

This is why you received the answers you did from
Craig, bustermu, and myself.

Thanks
diceman




srkaldi
Posted : Monday, October 23, 2006 10:25:10 PM
Registered User
Joined: 12/15/2004
Posts: 81


MAT in June 06, SIRF May 05 , SNPS Aug 05 , BWNG IN OCT 05...HOW MANY DO YOU WANT ??????\

I think I got the amnswer because you guys are NOT in the game......

I trade OPTIONS for a living !

diceman
Posted : Monday, October 23, 2006 11:01:37 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
None of your examples passed a % true scan.

They are close.
They touch(or are close) on different dates.

But there is not one instance in the charts you supplied.

of the 20= the 50 and the 50 = the 200

On the same day.

Good luck with your options trading for a living.

Thanks
diceman
(not in the game)
(still under water)



srkaldi
Posted : Tuesday, October 24, 2006 12:18:41 AM
Registered User
Joined: 12/15/2004
Posts: 81
Well it is simple, you are just 100% W R O N G

I do very well in my trading...

Good luck under water and out of the game...

If you got in on those trades you would be out of the water !
srkaldi
Posted : Tuesday, October 24, 2006 12:24:42 AM
Registered User
Joined: 12/15/2004
Posts: 81


Craig,

The formula is perfect.....thanks....

On Land, in the game !
Craig_S
Posted : Tuesday, October 24, 2006 5:37:56 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
My pleasure.

- Craig
Here to Help!
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.