Gann Square Of 9 Excel. GANN Square Of 9 Calculator. GANN Square of 9 Calculator / GANN Calculator: The GANN Square is derived from Spiral Chart by GANN. Welcome to Square of Nine. SquareofNine.com is an online trading and investing calculator based on the work and methods of W.
Square of Nine in Excel ----------------------------- HOW TO CONTRUCT A SQUARE OF NINE ROADMAP CHART IN EXCEL This tutorial will show you how to construct a Square of Nine Roadmap Chart from a regular price chart created in Excel You could also use a chart printed out from Yahoo or Big Charts or any other online service or charting program. This example uses Hourly Data (65 minutes actually) of the S&P 500. Hourly charts are good to practice with because conditions change quickly and you get many opportunities to experiment.
W D Gann Calculator
![Gann square of 9 calculator excel Gann square of 9 calculator excel](https://www.mav7.com//wp-content/uploads/lp_gann_square_of_nine.jpg)
We will assume that you already know how to create a stock chart in Excel. This is what the plain-jane stock chart looks like. We used high-low-close bars but if the chart doesn't get too crowded candles also work nicely. When you scroll around on your Excel chart while working in the program itself, the value of the data point under the mouse cursor will appear in a little window.
In this case we want to start the Roadmap from the low at 1166.31, which occurred on January 28, 2005 at the 11:40 bar. From the Square Root Theory you learned that we can move 360 degrees around the Square of Nine by adding 2 to the square root of a number and squaring the resulting sum. In the example on the Roadmap Theory page we moved from 15 to 34, which is directly above 15 on the Square of Nine, by taking the square root of 15 (3.87), adding 2 (5.87) and squaring that sum (34.49). A paper version of the Square of Nine uses rounded numbers and 34.49 was rounded down to 34. Just so we have some common language to work with we call the '2' we added to the square root of 15 a Factor of 2. We understand that Factor is a mathematical term of art, and in that sense it's being misused, but most people reading this are not mathematicians and will not be greatly offended. If a Factor of 2 represents 360 degrees or a full circle move, then 45 degrees or 1/8 circle will be represented by a Factor of.25 (360/8 = 45) and (2/8 =.25).
Many, if not most, major stock market moves end on a multiple of 90 degrees. We're working with Hourly data and because 90 degrees may be too granular we use 45 degrees which is an exact division of 90 degrees for our Hourly Roadmap Charts. If you want to work with Daily or Weekly data then we suggest using 90 or 180 degree Factors, which are.5 and 1 respectively, (360/4 = 90 and 2/4 =.5) and (360/2 = 180 and 2/2 = 1). In practice, you can use any Factor you want and odds are that at least one will fit your trending data points exactly, even though it would have allowed you to draw the Roadmap Chart before the fact.