||XLGann gives you the tools you need to implement WD Gann's master geometric chart overlay techniques including the square of 9 and a Hexagon grid|
XLGann gives you the tools you need to implement WD Gann's geometric overlay market analysis techniques. Gann was a prolific trader and writer who lived in the first part of the last century. He was also a shriner and a freemason. What he learned in those"lodges" he applied to his analysis of the markets.
You also get a Price-Time Box. Price-time boxes are similar to Don Hall's Pyrapoint but with modifications suggested by Howard Arlington in the Spring 2001 issue of Trader's World magazine.
A square of 9 grid overlay tool is also included. You can click on a single price to use in the expansion or you can choose two points and use the price span (and time span) in the expansions. Square of 9 grids are also rotatable, a powerful feature rarely seen in trading software, Of course you can choose the increment in degrees you want displayed.
Lastly you get a square of 9 curve tool. Like the Hex Grid, square of nine curve is my invention. They are only available in the XLGann. You specify the degree increment and shift the curve up or down to match the price action. If the price touches the curve then it has "squared" on the square of 9. This eliminates the need for those tedious calculations. You know instantly whether that critereon has been met.
XLGann is designed to be used with all XLTrader templates but comes with the update enabled HLC template which event enabled and configured to work seamlessly with the add-in.
You select the tool from the XLGann group on the XLTrader tab and you are asked to specify the point(s). You can change that point later on the form if you wish. Once you've chosen a point, you are asked to confirm the selection. When the program has the information it needs, you are taken to the data sheet and asked to specify a column where the overlay values will be placed. The addin then calculates and automatically plots the overlay.
All overlays are defined mathematically. When you rescale the chart the overlay is automatically scaled along with it. This is the ultimate way to do overlays.
Gann Boxes (Grids)
If you want to see more (many more) examples of these tools in action, click here8, They were all done in Microsoft® Excel with XLTrader™ add-ins.
There is also an "automatic" gann grid feature. This on decides for you based on a natal date you specify where on the time axis the grid should begin. You can use this feature on either calendar day or trading day charts. XLTrader has a list of past shut downs and future scheduled holidays for the NYSE that it uses to determine the grid location on a trading day chart.
You are asked to specify the size of the grid and the columns on the data page where you want the calculations placed. The add-in automatically draws the grid on the chart where it should be. But if for any reason you want to move the grid, that is easy to do. All you do is click on the appropriate icon Gann group on the XLTrader tab. The shift key is the accelerator key. There are also icons for resizing your grid, in either dimension or both, on the fly.
The chart on the right is an example of a grid that was placed automatically. Notice that the left edge of the grid corresponds exactly to the high in the S&P 500. As you can see, most of the grid is above the price action. We could move it down. Better yet lets just add another grid the same size below the current one. We can do that easily by choosing manual mode and selecting say the lower right corner of our automatic grid.
The chart on the right shows the new grid we placed on the chart in"manual" mode. Now we have a roadmap for the future price action. Notice how price made a bottom right on time, at the midpoint of our grid more than once! This example was not"cherry-picked". You will learn to anticipate the power of gann grids and how they will tell you what to expect next in the market.
With the hex tool you've got three overlays to choice from. Like the Gann Grids tool, provided you are using the calendar day graph, you can have the program automatically place your hex grid. But if you choose manual mode, you need to specify a point. You can choose any point on the perimeter or the center. As was explained above, you are then prompted to click on a point and confirm your selection.
To the right is an example of an automatically placed hexagon grid. Think that could help you trade? Its not at all unusual and again… the example was not cherry picked. It may be hard to notice at that scale, but there are gaps on the chart where weekends and holidays occurred. Again automatic mode only works on the calendar day chart.
The chart on the right is an example of manual mode placement. Its plotted on the trading day chart. (HLC_Chart.xlt has pre-prepared bar graphs for trading days and calendar days). I specified the center point and clicked on the low. Boom… seconds later what you see is what you get. This tool is FUN!
Price Time Boxes
Gann wasn't the only technical analyst to dabble in square root techniques. William Dunnigan in his classic: New Blueprints for Gains in Stocks and Grains had a chapter titled: Trend trading with Square Root Methods.
“The Square Root Theory offers the best single formula in respect to price levels and movements"
This tool needs to know only one piece of information: the price of the starting point. Well that's not exactly true… you also need to tell it what size increments in degrees you want. To create the chart below, all I did was click on the high and tell it I wanted 90º increments.
Its that easy! Notice how price follows the roadmap? You can put away your confusing indecisive oscillators away now. No longer needed. The question that's been bugging me for years is: WHY? Why does any of this stuff work? I don't have an answer.
Square of 9
To put a square of 9 overlay on our price chart we need two points. The price and time changes between the two selected points are the basis' to which the program adds or subtracts a user specified degree increment. The choices available are: 90º, 180º, 360º and 720º.
The chart above is an example of a longer term application using 360º increments based on the two points identified by circles.
The chart on the right was created using 90º increments. Obviously you will get a lot more price time projections the smaller the degree increments used perhaps even too many.
Here we've zoomed in on more recent price action. The overlay has 180º increments. Both price and time forecast are pretty good.
In a feature that is unique to XLGann, you can rotate your grid. In this case what you are doing is extrapolating the price-time vector defined by the two points you clicked on. As you can see in the example charts above, price tends to respect the time and price objectives defined by two earlier CITs.
Square of 9 Support & Resistance Curves