| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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!
|
|
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
|
|
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!
|
|
Registered User
Joined: 5/19/2006
Posts: 32
|
Thank you Very Much Doug!
Jesse
|
|
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!
|
|
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!
|
|
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
|
|
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
|
|
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
|
|
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!
|
|
Registered User
Joined: 6/1/2006
Posts: 23
|
tx
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Our pleasure!
- Craig
Here to Help!
|
|
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!
|
|
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
|
|
Registered User
Joined: 6/1/2006
Posts: 23
|
tx
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |