About the Indicators
The Awesome and Acc/Dec Indicator are an interesting pair that are normally used together.
Despite the cool name, the Awesome Oscillator is a very simple indicator. As I set out in the video below, it is actually just a moving average crossover. It has fixed settings of 5 and 34 and uses the average price calculated by the (High+Low) / 2. The indicator looks similar to the MACD but it slightly slower. The green and red colours used in the Awesome Oscillator are a nice touch and are useful for quickly identifying changes in direction.
The Acc/Dec Indicator measures the momentum of the Awesome Oscillator. This is useful because it shows us whether price momentum is speeding up or slowing down. Like the Awesome Oscillator it uses green and red bars to show whether it is rising or falling.
How to Trade Using the Awesome Oscillator and Acc/Dec Indicator
In his book, New Trading Dimensions: How to Profit from Chaos in Stocks, Bonds, and Commodities, Bill Williams sets out his method of trading using these two indicators.
Awesome Oscillator buy signals are created when the indicator:
- Crosses from below 0 to above 0
- When the oscillator is above the 0 line. The oscillator changes from green (upward movement) to red (downward movement) and back to green again.
- When the oscillator is below the 0 line. The oscillator makes a higher low and turns from red to green.
Awesome Oscillator selling signals are created when the above buy signals are reversed.
Acc/Dec Indicator buy signals are created when the indicator:
- When the indicator is above the 0 line. The indicator changes from red to green and then has two consecutive green bars.
- When the indicator is below the 0 line. The indicator changes from red to green and has three consecutive green bars.
The Acc/Dec indicator sell signals are created when the above buy signals are reversed.
Putting it Together
The next part of Bill William’s trading method is the most interesting to me. He recommends trading aggressively when the market is moving in your favour.
If you have entered a long position based on one of the indicators and the next time period shows both the AO and AC green and also the market has closed higher then you should add to the position. If the following time period also has a green AO, green AC and higher close then you should again add to the position. This process should be continued up to a maximum of five positions.
I like this method because it forces us to be brave when most peoples instinct is to close out the position to protect the profit gained.
The trading strategy of adding to a winning position is the method used by Jesse Livermore in the excellent book, Reminiscences of a Stock Operator. This mindset is summed up in the following quote:
“It took me five years to learn to play the game intelligently enough to make big money when I was right.”
New Trading Dimensions
In the book, New Trading Dimensions: How to Profit from Chaos in Stocks, Bonds, and Commodities, Bill Williams explains his trading philosophy. He also introduces some excellent and very practical technical indicators. If you want to learn more about his ideas I recommend having a look at this book.
If you are interested in Bill Williams’ ideas you might also want to see the 2008 updated version of Trading Chaos: Maximize Profits with Proven Technical Techniques.
Video – How to Calculate the Awesome Oscillator & Accelerator Indicator using Excel
Average Price H4 =(D4+E4)/2
5 period Simple Moving Average I8 =AVERAGE(H4:H8)
34 period Simple Moving Average J37 =AVERAGE(H4:H37)
Awesome Oscillator K37=I37-J37
5 period SMA of Awesome Oscillator L41 =AVERAGE(K37:K41)
Accelerator/Decelerator M41 =K41-L41
If you are interested in using Excel to backtest trading strategies my new Ebook course: How to Backtest a Trading Strategy using Excel is now available in the Amazon Kindle Bookstore.
If you are interested in using Excel for trading purposes you may be interested in how to calculate the following indicators: