# Exponential Moving Average Crossovers

#### QUIKTDR

##### New Member
How would one write a Moving Average Crossover, e.g., 5 day exponential

average of the close crossing above (or below) the exponential average of

the 6 day exponential average of the open?

This is a technical indicator used in trading equities, etc.
Exponential Moving Averages:
In our last article we discussed how we can profit from exponential moving averages. Today we will learn how to determine the optimal length of a moving average. This is critical if we are to get profitable results.

Last time we looked at an example of AVL with an ema (exponential moving average) and saw an opportunity for some long positions. Here is the chart we looked at with the ema in blue and the long entry opportunities circled in red;

As you can see, two of the three would have been great long positions for swing trades. So what length did I choose for the ema and how did I choose it? That's the one million dollar question! If we choose a length that is too short, the line will run so close to the price that it will never appear to break away from it. If we choose a length that is too long, the price will never come close enough to it to invite us to open a trade.

The key to finding this "ideal" ema length is to remove the noise of the market. This is not an exact science, but an effective way to do so is to remove the dominant cycle of the price movement. If we lay out an ema that doesn't take into account the dominant cycle (major swings) of the price, then it will become more useful to us. We do this by using an ema that is 1/2 the dominant cylcle of the price movement. Now some will argue that "real mathematical cycles" seldom exist in market movement. That may be true, but more often than not there exists a rhythm in the movement of the price, and it will suffice for this purpose.

So how do we determine what the dominant cycle is? There is more than one way of doing this and depending upon who you ask, you may get different answers as to which way is best. A simple and quick way of doing this (something most of us are interested in) is to use an RSI chart. Simply look for the significant dips in the RSI. I usually count the last three from the current point on the chart. Count the distance between the first and second, then between the second and third and average the two. Lets see how this worked out for the example of AVL by adding the RSI, and a little history to our chart below;

So we can see in the above example, when we back up from our point of interest at the beginning of June that there are major or significant lows in the RSI chart, late in April, then early in March and third, late in January. I counted 33 days between the April and March dip, and 26 between the March and January dip for a total of 59 days. Divide that by 2 and you get an average dominant cycle of 29.5 days. We then further divide that number by 2 to come up with 1/2 of the dominant cycle which is 15, and that is the magic number we come up with for our ema in this example.

How long can we use the 15 day ema for? As a general rule you should at least be able to use it for the length of the current dominate cycle that has been identified. The further away you get from that point, you might want to think about recalculating.

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Replies
3
Views
244
Replies
1
Views
627
Replies
6
Views
450
Replies
3
Views
770
Replies
2
Views
2K

1,195,909
Messages
6,012,256
Members
441,687
Latest member
urimagic

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back