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 |

Formula for crossing moving averages Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
kiranpatel42
Posted : Friday, September 23, 2005 1:35:50 PM
Registered User
Joined: 2/20/2005
Posts: 6
I have plotted moving average of 50 & 200 on the price graph. I am trying to find the crossing point for various stocks by following PCF.

AVGC200.2 > AVGC50.2 AND AVGC50 > AVGC200

It doesn't seem to work.
Craig_S
Posted : Friday, September 23, 2005 1:48:21 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Are you averages simple or exponetial?

If exponential you need:

XAVGC200.2 > XAVGC50.2 AND XAVGC50 > XAVGC200

Also be sure you are looking at a daily chart.

- Craig
Here to Help!
kiranpatel42
Posted : Friday, September 23, 2005 1:54:47 PM
Registered User
Joined: 2/20/2005
Posts: 6
I have tried both simle and exponetial and I am looking at daily chart.
Craig_S
Posted : Friday, September 23, 2005 1:58:23 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Click the edit button on your chart.

Are your moving averages both indented under price BUT flush left with each other

OR

is one average indented farther than the other.

If they are not flush-left with each other, your second average is an average of the parent above it, not of price. Delete it and click the PLUE "+" next to price and add it as an average of PRICE not the other average.

- Craig
Here to Help!
kiranpatel42
Posted : Friday, September 23, 2005 2:09:18 PM
Registered User
Joined: 2/20/2005
Posts: 6
I think when I did add moving averages first I took from + of price and then second I took from moving average.

I redefined the moving averages from price + sign and nowing it is working. Thank you.
Craig_S
Posted : Friday, September 23, 2005 2:47:39 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Glad to hear it.

- Craig
Here to Help!
pkolble
Posted : Sunday, February 5, 2006 7:54:21 PM
Registered User
Joined: 12/13/2004
Posts: 4
I'm trying to do an EasyScan for stocks crossing up above a moving average. As an example, I'd like a list that displays stocks that were below the 40 day simple moving average yesterday, but closing above that average today. I'm using the PCF: (C > AVGC40 ) AND (C1 < AVGC40.1 ). This gives me a nice list, however, I notice that it is not an accurate list. Some of the stocks meet that criteria and others do not. From Fridays list (2/03) I showed MYL which met this scan criteria perfectly, however, I also had MHP which is a nice stock, but the crossover of the 40 MA was on 1/27, a full week back.

Where am I going wrong?

THX
Craig_S
Posted : Sunday, February 5, 2006 7:56:22 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Your PCF is fine if you are using simple averages. If your 40 is exponential use this PCF:

(C > XAVGC40 ) AND (C1 < XAVGC40.1 )

If that does not fix things, please go through this check list:

Things to check if your moving averages don't "seem right" or "seem to match"

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