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

Moving average crossover Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
csns
Posted : Wednesday, February 27, 2008 1:45:14 PM
Registered User
Joined: 10/15/2007
Posts: 30

I want to create 6 Days EMA and13 Days EMA crossover as a criterion for myself. How can I do it?
thanks

Bruce_L
Posted : Wednesday, February 27, 2008 1:48:44 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Please try one of the following:

EMA6 xUp EMA13:

XAVGC6 > XAVGC13 AND XAVGC6.1 <= XAVGC13.1

EMA6 xDn EMA13:

XAVGC6 < XAVGC13 AND XAVGC6.1 >= XAVGC13.1

EMA6 crossing EMA13 (either direction):

SGN(XAVGC6 - XAVGC13) <> SGN(XAVGC6.1 - XAVGC13.1)

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rhollow
Posted : Thursday, February 4, 2010 10:17:41 AM
Registered User
Joined: 2/18/2009
Posts: 9

Hi,

I want to create crossover of  EMA3 + EMA5 + EMA8 over  EMA30 + EMA35 + EMA40 ( 3 ) days ago either in Telechart or Stockfinder.

Thanks,
Angel
Bruce_L
Posted : Thursday, February 4, 2010 10:53:24 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
rhollow,
I'm not quite sure what is meant by your request. A Personal Criteria Formula for EMA3, EMA5 and EMA8 all being below the EMA30, EMA35 and EMA40 3-Bars Ago but above now would be:

XAVGC3 > XAVGC30 AND XAVGC3 > XAVGC35 AND XAVGC3 > XAVGC40 AND XAVGC5 > XAVGC30 AND XAVGC5 > XAVGC35 AND XAVGC5 > XAVGC40 AND XAVGC8 > XAVGC30 AND XAVGC8 > XAVGC35 AND XAVGC8 > XAVGC40 AND XAVGC3.3 < XAVGC30.3 AND XAVGC3.3 < XAVGC35.3 AND XAVGC3.3 < XAVGC40.3 AND XAVGC5.3 < XAVGC30.3 AND XAVGC5.3 < XAVGC35.3 AND XAVGC5.3 < XAVGC40.3 AND XAVGC8.3 < XAVGC30.3 AND XAVGC8.3 < XAVGC35.3 AND XAVGC8.3 < XAVGC40.3

A PCF for EMA3, EMA5 and EMA8 all being above EMA30, EMA35 and EMA50 3-Bars Ago, but at least one of them being at or below 4-Bars Ago would be:

XAVGC3.3 > XAVGC30.3 AND XAVGC3.3 > XAVGC35.3 AND XAVGC3.3 > XAVGC40.3 AND XAVGC5.3 > XAVGC30.3 AND XAVGC5.3 > XAVGC35.3 AND XAVGC5.3 > XAVGC40.3 AND XAVGC8.3 > XAVGC30.3 AND XAVGC8.3 > XAVGC35.3 AND XAVGC8.3 > XAVGC40.3 AND XAVGC3.4 <= XAVGC30.4 AND XAVGC3.4 <= XAVGC35.4 AND XAVGC3.4 <= XAVGC40.4 AND XAVGC5.4 <= XAVGC30.4 AND XAVGC5.4 <= XAVGC35.4 AND XAVGC5.4 <= XAVGC40.4 AND XAVGC8.4 <= XAVGC30.4 AND XAVGC8.4 <= XAVGC35.4 AND XAVGC8.4 <= XAVGC40.4

If you mean something besides one of the above, I will need additional clarification from you as to your actual intent.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
osteon
Posted : Monday, February 8, 2010 3:41:51 PM
Registered User
Joined: 1/30/2005
Posts: 46
I  am trying to find a video that showed how to scan for moving average cross overs using division.  Can  you  send me the link for the video.  I am unable to find it.
Thanks,
Osteo;n
Bruce_L
Posted : Monday, February 8, 2010 3:44:12 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
osteon,
I think the Create PCFs and EasyScans to find moving average crossovers topic contains the video of interest.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
winsborrow
Posted : Sunday, August 21, 2011 1:15:38 AM
Registered User
Joined: 12/30/2004
Posts: 26
QUOTE (Bruce_L)
Please try one of the following:

EMA6 xUp EMA13:

XAVGC6 > XAVGC13 AND XAVGC6.1 <= XAVGC13.1

EMA6 xDn EMA13:

XAVGC6 < XAVGC13 AND XAVGC6.1 >= XAVGC13.1

EMA6 crossing EMA13 (either direction):

SGN(XAVGC6 - XAVGC13) <> SGN(XAVGC6.1 - XAVGC13.1)

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

Bruce,

I tried using the PCF below for a EMA Cross and the PCF EMA's values and the EMA's values from the charts don't match and I did double and triple check my PCF and made sure chart EMA's where correctly inputed.  

This is the only PCF I scaned the russell 3000 list with:

XAVGC10>XAVGC30 AND XAVGC10.1<XAVGC30.1

This scan on 8/20/2011 gave me symbols: EK, CEPH, AAP, TGT, SMOD.



Here are 2 Examples: 

EK
CHART 10EMA PLOTED VALUE: 2.50 has not quite crossed the 30
CHART 30EMA PLOTED VALUE: 2.51 
PCF 10EMA VALUE:  2.50 this shows it has crossed but chart does not show
PCF 30EMA VALUE: 2.46


CEPH
CHART 10EMA PLOTED VALUE: 79.82 yes crossed but acutally crossed 2 days ago
CHART 30EMA PLOTED VALUE: 79.75 
PCF 10EMA VALUE:  79.74  this value is lower than the 30ema ??????
PCF 30EMA VALUE: 79.83


AAP, TGT, SMOD same incompatible data.

Please help

Kirk
Bruce_L
Posted : Tuesday, August 23, 2011 9:41:22 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I would not create Personal Criteria Formulas for Moving Average crossovers in TC2000 version 12. Just plot both Moving Average indicators on the chart, click on one of the Moving Averages, select Create Condition and choose Moving Average vs Moving Average | Crossing Down Moving Average (or Crossing Up Moving Average).

Indicators, Sorting & Scanning

The resulting Condition is easier to create than a formula and more accurately represent the chart while calculating more quickly using less resources than a formula.

Formulas for Exponential Moving Averages and indicators calculated with EMAs in TC2000 version 12 normally use less data when used as a WatchList Column or as part of a Scan than they do on the chart. As a result, the formula will not always match the chart.

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