Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Where the 200, 50 & 10 day moving averages cross or close to eachother Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
stevekava
Posted : Thursday, May 11, 2006 3:15:59 PM
Registered User
Joined: 3/29/2006
Posts: 5
Hello

Is there a formula that would show me stocks where the 200, 50 and 10 day moving averages are touching or that are close together.

Thank You

Steve

Craig_S
Posted : Thursday, May 11, 2006 3:19:31 PM


Worden Trainer

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

(ABS(AVGC200-AVGC50)+ ABS(AVGC10-AVGC50)+ ABS(AVGC200-AVGC10))/MINC200

You should see your stocks at the top of the list.

Here are two videos to review:

Create your own stock rankings using WatchLists and Sort conditions

How to create a Personal Criteria Forumula (PCF)

- Craig
Here to Help!
jesloc25
Posted : Sunday, May 21, 2006 10:35:29 PM
Registered User
Joined: 5/19/2006
Posts: 32
Hi,

Could you also please write a PCF to find stock with their 10, 20, and 50 simple moving average close together or touching.

also one with their 20/50/200.

Thank you very much.

Jesse
Doug_H
Posted : Sunday, May 21, 2006 10:41:38 PM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
10/20/50
(ABS(AVGC50-AVGC20)+ ABS(AVGC10-AVGC20)+ ABS(AVGC50-AVGC10))/MINC50

20/50/200
(ABS(AVGC200-AVGC50)+ ABS(AVGC20-AVGC50)+ ABS(AVGC200-AVGC20))/MINC200



- Doug
Teaching Online!
jesloc25
Posted : Monday, May 22, 2006 7:23:55 PM
Registered User
Joined: 5/19/2006
Posts: 32
Thank you Very Much Doug!

Jesse
henrietta
Posted : Thursday, June 1, 2006 11:55:34 AM
Registered User
Joined: 6/1/2006
Posts: 23
I am new to the system and having a tough time setting formulas
I am mostly interested in MA crossovers say stocks that have crossed up for the last 3 days using 10 and 50 day MA. Also, stocks that have crossed down.

Please help!
Craig_S
Posted : Thursday, June 1, 2006 11:59:05 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
For starters, welcome to the TeleChart community.

Have you had a chance to review these videos?

If you are new to TeleChart READ THIS FIRST!

Below Bruce has the formulas for both simple and exponential. Be sure to review the videos I linked above... they will save you a ton of time in the future.

- Craig
Here to Help!
Bruce_L
Posted : Thursday, June 1, 2006 11:59:34 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
henrietta,
Please try the following (SMA is a Simple Moving Average while EMA is an Exponential Moving Average):

10-Period SMA up thru 50-Period SMA (last three days):

AVGC10 > AVGC50 AND (AVGC10.1 < AVGC50.1 OR AVGC10.2 < AVGC50.2 OR AVGC10.3 < AVGC50.3)

10-Period EMA up thru 50-Period EMA (last three days):

XAVGC10 > XAVGC50 AND (XAVGC10.1 < XAVGC50.1 OR XAVGC10.2 < XAVGC50.2 OR XAVGC10.3 < XAVGC50.3)

10-Period SMA down thru 50-Period SMA (last three days):

AVGC10 < AVGC50 AND (AVGC10.1 > AVGC50.1 OR AVGC10.2 > AVGC50.2 OR AVGC10.3 > AVGC50.3)

10-Period EMA down thru 50-Period EMA (last three days):

XAVGC10 < XAVGC50 AND (XAVGC10.1 > XAVGC50.1 OR XAVGC10.2 > XAVGC50.2 OR XAVGC10.3 > XAVGC50.3)

You may wish to review the following:

Create PCFs and EasyScans to find moving average crossovers
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
henrietta
Posted : Thursday, June 1, 2006 12:10:05 PM
Registered User
Joined: 6/1/2006
Posts: 23
wow! this is what i called fast response! first of all, tx.
i am still experiencing problems. must be doing something wrong. i cut and pasted the formula and it says (not calculated) next to the name that i have gived to it. and when i try to test it, I get: result false
criterion information: market days needed to calculate criterion: 54

please help!
henrietta
Bruce_L
Posted : Thursday, June 1, 2006 12:13:16 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
henrietta,
A False result is not an error message, it just means it isn't True for test symbol. You will need to update your Personal Criteria Formulas. Select Databank | Personal Criteria Formulas | Update All Criteria. This is all covered in more detail in the second of the free training videos referenced in my previous post.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Craig_S
Posted : Thursday, June 1, 2006 12:22:54 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Be sure you watch the videos we linked for you... they will answer these types of questions and save you tons of time.

- Craig
Here to Help!
henrietta
Posted : Thursday, June 1, 2006 12:41:28 PM
Registered User
Joined: 6/1/2006
Posts: 23
tx
Bruce_L
Posted : Thursday, June 1, 2006 12:42:26 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Craig_S
Posted : Thursday, June 1, 2006 12:42:28 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Our pleasure!

- Craig
Here to Help!
henrietta
Posted : Thursday, June 1, 2006 12:50:50 PM
Registered User
Joined: 6/1/2006
Posts: 23
I finally got the formulas to work but it really seems to have some flaws in them. Perhaps it's me For example:
10-Period SMA up thru 50-Period SMA (last three days):

AVGC10 > AVGC50 AND (AVGC10.1 < AVGC50.1 OR AVGC10.2 < AVGC50.2 OR AVGC10.3 < AVGC50.3)

i am using S&P 500 for scanning purpose and I am getting 14 stocks that have crossed up for the past 3 days but reviewing the charts like SYK, it surely hasn't crossed anything... Please help!
Bruce_L
Posted : Thursday, June 1, 2006 12:54:13 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
henrietta,
On my computer, the Moving Averages do cross if the chart is using Simple Moving Averages and don't cross if the chart is using Exponential Moving Averages. Please try the Exponential version of the formula (the version you posted uses Simple Moving Averages) or adjust the settings on your charts to use Simple Moving Averages. You may wish to review the following:

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

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
henrietta
Posted : Thursday, June 1, 2006 1:05:56 PM
Registered User
Joined: 6/1/2006
Posts: 23
tx
Bruce_L
Posted : Thursday, June 1, 2006 1:06:53 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

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