Loadpussy666

• Gann Square Of 9 Excel Formula

Gann, a remarkable Analyst & Trader, who with his precise prediction of Time & Price analysis has been able to put the analysts of today to research his veiled coded secrets to predict markets. Gann has always been a mystery known as for his high accuracy rate & incredible market predictions with 85%+ success rate.
The proof of his ability to call the precise time for the market turns have been found in Ticker & Investment Digest, volume 5, number 2, December 1909, which shows that W.D. Gann took a total of 286 trades in the presence of William E. Gilley of which, 264 trades were profitable winning trades. His success rate during this 25 days trading period was amazingly 92%. In this 25-day period, on which the article covers in Ticker & Investment Digest, Gann was able to double his initial capital ten times for a gain of 1000% on his margin money.
During these trade recording period, it has been reported that W.D. Gann carried a miniature version of Square of Nine with him into the trading pits. The source of this information is Mr. Renato Alghini an associate of Gann’s for nearly six years. Gann believed that every top & bottom in the market has a mathematical correlation in both Time & Price. He quoted Faraday saying “there is no chance in nature, because mathematical principles of the highest order lie at the foundation of all things. There is nothing in the Universe but mathematical points of force”.
Since Gann was famous for using veiled language so that nobody could judge what his exact method of Trading/Analysis are, he would often call the same thing in different words; Square of Nine was also referred as “Pyramid” or “Old Square”.
What is Gann’s Square of Nine
The Square of Nine is similar to a wheel or a circle, it starts with the number one in the centre of the circle and then radiates out to the first square of nine. Starting with the number two to the left of the centre or the number one. It then spirals clockwise to the number nine, to form its first rotation around the Square of Nine. This rotation then continues by shifting one unit to the left of nine and will commence the next rotation at the number ten and then around to the number twenty. This spiralling expansion of numbers just continues out until you end up with a grid of numbers, relevant in price to the market your trading. The Square of Nine is essentially a time and price calculator, and calculates the square root of numbers, both odd and even numbers as well as their midpoints. It also looks for both time and price alignments from a specific starting point or price level E.g. a significant high or low point in a market. If you were to look at the numbers on the grid running down to the bottom left hand corner on the Square of Nine, you will find they are the square root of odd numbers E.g. 5x5 = 25. If you were to look at the numbers running up to the top right hand corner on the Square of Nine you will find they are the square root of even numbers e.g. 4x4 = 16. If you then look at the numbers running down to the bottom right hand corner on the Square of Nine you would find the midpoint between the square s of odd and even numbers. Using the numbers 16 and 25 as an example of our odd and even numbers you will find the number 21 representing their midpoint.
The Source of Gann’s Square of 9
Gann’s Square of Nine is one of the more exotic tools he incorporated in his trading, and while this is a relatively daunting tool that requires a fare amount of practice to master, it can certainly add a whole new dimension to your analysis. Gann never claimed to be the inventor of this tool; however he certainly developed it and refined it to be used in conjunction with financial markets. The Square of Nine has origins that date back to early Egyptian days, and when looking at it onegets the impression your actually viewing a pyramid looking down from its very top or apex and then looking down further to its actual base. It is said Gann actually discovered the Square of Nine during his travels in India, which he saw being used as a calculator by traders in the region selling their goods.

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. 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.

Basic Usage of the Gann Square of Nine Excel Workbook First it is an Excel 2007 file so you need a newer version of Excel to work with it. You also need the VBA enabled in the workbook to use it as the Gann Square functions are implemented in Excel VBA. Nov 16, 2016 Every value in the Gann square is related to the center value. Below are the steps used to calculate these values: Calculate the square root of LTP. Let’s suppose LTP=8400, then SQRT (8400)=91.65 Take two integers below and above the square root calculated. 360 DEGREE PRICE ANALYSIS. 119.18 45 90 120 135 180 225 240 270 315 360. Square Of Nine; Gann Square Of 9 Excel; In GANN SQUARE OF 9 angles are very important and all calculations are made in degrees. There are four cardinal crosses 90, 180, 270, 360. But the Calculator forms a static number series. Gann square of nine desktop calculator for using in day trading and positional trading as well. 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). Customization And Utilization Of The Gann Square of Nine Excel VBA Library 1. Make a copy of the workbook using a different name as you need the VBA code library from the workbook. On the spreadsheet that you want to create a new Gann Square, locate the cell that you want to put.

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. Gann said that 90 degrees is very important for the stock market, and our own experience with the major stock market indexes confirms that, but there very well could be other very important factors for different stock market indexes, currencies, commodities or individual stocks. There is probably much more that remains unknown and undiscovered about the application of the Square of Nine than we can imagine, so experimentation is encouraged for those willing to do the work.

Now that we've decided to use a Factor of .250 (representing 45 degrees) we can begin to actually construct the chart. We'll use our starting point, the low at 1166.31, to calculate price levels for the horizontal lines. Here's the math:

(SQRT(1166.31) + .250) ^2 = 1183.45

(SQRT(1166.31) + .500) ^2 = 1200.71

(SQRT(1166.31) + .750) ^2 = 1218.10

Eyeball these price levels on your Excel chart and draw in a horizontal line at each price level. The chart will look like this.

Let's add the vertical time lines. Use the same low price of 1166.31. Find the square root (34.15) and round it to the next whole number (34). To complete the vertical time lines all that must be done is draw the lines in 34 bar increments from the starting point of the bar at 1166.31. Draw as many vertical time lines as will fit on the chart. The chart will look like this.

You're almost there. Add one more vertical line at the starting point price bar at the low of 1166.31 and draw diagonal lines through the intersections of the horizontal and vertical lines. The chart-in-progress will show you graphically what and where to connect things better then any verbal description.

That's all there is to it! You've created a Roadmap Chart. Once you get a feel for the rhythm of the tickers you trade the most, and the Factor that best represents that rhythm, you can create a new Roadmap Chart within minutes of a suspected pivot point. The Roadmap Chart is self-defining. If the trend has changed then the new Roadmap Chart will contain the future price bars for the life of the trend. If the suspected pivot point bombs-out you will know immediately when price bars bust the channels.

One obvious thing we did not mention is that if you're drawing a new Roadmap from a high then you would subtract, not add, the Factor from the square root of the starting price. The vertical line, time calculation, would be the same. Depending on the quote price of your ticker you may get weird results in your early attempts to create a new chart. You will have to experiment, but generally, you want to convert prices into three significant digits (i.e three numbers to the left of the decimal point) to get proportional results. Use a multiple of 10 (multiply or divide by 1/10, 10, 100, 1000, etc.) to convert your prices to three significant digits before calculating the price levels of the horizontal lines. You do not have to change the price scale of the chart, only the price to use when calculating the horizontal price lines. We use natural S&P prices, which currently are four significant digits, for our charts and everything works just fine so like most everything else about the Square of Nine there are no absolutes, and the value you receive is directionally proportional to the effort you make..

We think the Roadmap Chart is a great trading tool without learning another thing about the Square of Nine. How many tools allow you to define a trend ahead of time? Ideally, price will move across the width of the channels before ending the trend. Reactions that do not end the trend often occur near the midpoint of the time lines or the midpoint of the major horizontal price lines. There's no substitute for experience in learning the natural rhythm of your tickers and how to use the Roadmap Charts to your advantage. Although the Roadmap Chart is based on Square of Nine principles, and as elegant as we believe the Roadmap Chart to be, it does not square price and time. To do that you must first convert both price and time to degrees of a circle and measure them from defined starting points. The Roadmap Chart does not do that.

Gann Square Of 9 Excel Formula