Elliott Wave Analysis Excel Sheet

Elliott Wave Theory is one of the most popular prediction model to speculate the direction of prices in Stock Market. It was developed by R.N. Elliott and got popular through the efforts of Robert Prechter. Elliott Wave theory is primarily based on Dow theory which asserts that stock prices moves in cycles. These cycles are a result of mass psychology which shows up repetitive patterns when applied on stock charts. Every single element of these patterns are termed as waves in Elliott wave theory. In this post we would understand Elliott Wave patterns in detail and learn how to compute waves in Elliott Wave Analysis Excel Sheet. This excel sheet is downloadable at the end of this post.

Check out some of our very popular Excel based trading systems in the below link:

Excel Based Trading Systems

Deep Dive into Elliott Wave Theory

As per Elliott Wave Theory, a combination of 8 waves constitute a complete price cycle. Out of these 5 are called Impulsive waves and 3 are called Corrective waves.

When the primary market trend is bullish, impulsive waves are in direction of trend (upwards) while corrective waves are opposite to the trend (downwards).

Elliott Wave UptrendSimilarly, when the primary market trend is bearish, impulsive waves are in direction of trend (downwards) while corrective waves are opposite to the trend (upwards).

Elliott Wave Downtrend

The above pattern formation does not depend on timeframe. You can observe Elliott wave patterns in intraday charts as well as monthly charts. However, the probability of false waves decreases in higher time frame charts.

There are 3 guiding principles or rules regarding the wave lengths in Elliott Wave cycle:

Rule 1: Wave 2 cannot retrace more than 100% of Wave 1.

Rule 2: Wave 3 can never be the shortest of the three impulse waves.

Rule 3: Wave 4 can never overlap Wave 1.

Elliott Wave Theory Example Chart

Below is the practical application of Elliott wave theory in Crude Oil chart:

Elliott Wave Example

Reference: http://atozforex.com/wp-content/uploads/2016/11/Crude-oil-weekly.png

Elliott Wave Analysis Excel Sheet Overview

This excel sheet calculates the possible range and time period of Elliott waves based on the input for wave 1. See the below description:

Parameter Description
Worksheet Name Elliot Wave Calculator
Inputs Number of candles (B5,B16) Number of candles or bars wave 1 lasted.
Start Price (C5,C16) Starting price for wave 1
End Price (D5,D16) End price for wave 1
Outputs Time Period (column E) Time Period for each wave
Wave 2,3,4,5,a,b,c range and time period The probable range and time period of other waves based on input given for wave 1

Screenshot

Elliott Wave Analysis Excel Sheet

How to use this Excel Sheet?

Please follow the below instructions to download multiple stock quotes into Excel for free:

Step 1: Download the sheet from the end of this post to your local computer.

Step 2: Open this Excel file and input parameters for wave 1 in the highlighted yellow cells.

Step 3: Check probable range of other waves and plan your trades accordingly.

Download Link for Elliott Wave Analysis Excel Sheet

Please download the Excel sheet from the below link. Let us know in the comments section if you have any queries.

Elliott Wave Analysis Spreadsheet

10 Comments

  1. Much appreciated work!
    Could you please enlighten us how to use this i.e in highlighted area we have have to enter the last day data or last 5th day data?
    How to evaluate the results?
    what the wave 2,3,4,5 and ABC are indicating?
    Please do not mind I never used the Elliot wave and even doesn’t know much about it but listened a lot so curious to learn about it
    One more thing I am working on my option strategy project so could you help me how to calculate Implied volatility in excel for indian market?
    Would be greatful if you help me to figure out this
    Thanks

    • Hi Avtar,
      Request you to read the article once again. Pretty much all of your questions are answered there. Why do you want to calculate implied volatility, its already available in NSE website.

  2. Thanks for the Reply actually I am doing my own project to find the best option for trading in excel sheet just like you are doing lot of projects in excel but not able yet to calculate the Implied Volatility by putting the following data
    Stock Price,Strike Price,Option Price,Days remaining….etc
    And am damn sure that will help the traders to make a lot through options so if you or anyone can help me in this forum would be greatful for that
    with nse data have to work a lot and in the mean time high chances to miss the opurtunity like today in axis Bank and you know my project saves me by preventing not to enter in TCS call

  3. Hi, thanks for the article . I want to know from where to get the Number of candles no. And what is this start price / end price.

    Secondly after putting data, what will be the outcome and what is it significance

    • Hi Rahul,

      Number of candles, start price and end price is the length of 1st wave which you need to observe in the chart. Please read the article to understand the significance of output values

  4. Many thanks for the great work!

    What would the time period 200 mean over here?

    Does it mean 200/ 5bars = 40mins each candle represents

    • Hi Neha,

      It means 200 candles. So if you are studying 1 min chart, it would be 200 minutes.

  5. Hi Great Job.
    Just needed a Clarification .. if i am looking at a weekly chart , the time period that i get is to be considered as weeks or days?

Leave a Reply

Your email address will not be published. Required fields are marked *