The square of nine or Gann Square is a method which squares price and time. The Gann square of nine gets its name because if you look at the above chart again, the number 9 represents the completion of the first square. The square of 9 is a spiral of numbers with an initial value “1” starting at the center. 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.
Gann square of nine excel free downloads, football squares 4 winner squares, excel root sum square, excel squares sheet super bowl - software for free at freeware freedownload. Excel workbook with VBA function library for constructing customized Gann Sqaure. Hi Lawrence, how I can create a larger square of 9. 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. Gann square of nine,time price,gann calculator time price - Duration: 12:27. Om gann subscriber100000 20,339 views. EXCEL's Gann Square of 9 Calculator. If we can help you in any way, please set a time for meeting or leave your details and we will get back to you.
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.
One of our goals at Optuma is to make advanced Gann analysis as simple as possible for our clients. As such, we have created a number of tools that can save you hours of research and painstaking manual calculations in your chart analyses. Not only have we taken the old wooden Square of Nine and made it fully interactive and customisable, but we have also developed a number of tools derived from it, such as the Static and Dynamic Square of 9.
The Static Square of 9 tool calculates price levels according to degree levels – or aspects – of the Square of 9 wheel, starting with 1 in the center. When the Static Square of 9 tool is applied to the chart (with a Price Unit of 1 – more about that later) the first 360 degree level will be 11, the second will be 28, the third 53, etc. Looking at the classic Square of 9 wheel you will see where these numbers appear: all are on the horizontal line to the left of the center value of 1. As each number is one complete revolution around the Square of 9 from the previous number they are said to be 360 degrees apart. Similarly, the 180 degree levels are half way around from the center starting point and directly opposite the 360 degree levels, i.e. 6, 19, 40, etc. Whilst they are 360 degrees apart from each other they are 180 degrees from the center. You will see the relationship between the classic Square of 9 wheel and the levels in the tool in this image:
The Square of 9 chart is also known as a square root calculator: pick a number on the chart, take the square root, add two, and re-square. You will see the value will be the next number around the wheel.
Example:
square root of 79 = 8.888
8.888 + 2 = 10.888
10.888 x 10.888 = 118.548
[Note: to calculate 180 degrees around the wheel add 1 to the square root before re-squaring, 90 degrees add 0.5, etc.]
This is why the distance between each successive level is never the same: each subsequent rotation around the wheel is further to travel, so for example, the distance between the 360 degree levels grows wider and wider with each revolution. This is why the distance between the 1st and 2nd 360 degree level is 17 (28 – 11) but from 3rd to 2nd the distance is 25.
Many Gann analysts use the degree levels as potential support and resistance points in the market, and they can work for any instrument in any time frame. The image below shows the Australian Dollar / US Dollar currency pair on a weekly chart, with the Static Square of 9 applied. The degree levels used are semi-square, or every 45 degrees (i.e. 45, 90, 135, 180, 225, 270, 315 and 360 degrees). As you can see, the chart has respected these levels on multiple occasions. In fact, at the time of this writing, the 225 degree level at $0.73 is proving to be a level of support.
Using the Price Unit
One important thing to remember is that the settings for the Square of 9 tool – and all Optuma tools for that matter – can be set by the user to their own specifications, whether the degree levels, the line colours, and perhaps most importantly the Price Unit. This crucial property is found in many Gann tools and it’s important to find the right value for the particular chart being analysed. In the currency chart above for example, using a Price Unit of 1 will not work on a chart trading in the $1 range with small increments. By setting the Price Unit property to 0.01, it recalculates the levels divided by 100, so that the first 360 revolution will be at 0.11 instead of 11, and the 180 degree line mentioned earlier at 1.06 is the equivalent of 106 on the wheel (as seen in Figure 1).
The software will try to select the appropriate price unit by default, but this can be manually adjusted via the tool’s Properties panel.
For more information on Price Units, Factors and Harmonics in Gann tools click here.
Going Dynamic
A variation of this tool is the Dynamic Square of 9, which, instead of looking at angles from the center square (ie 1), uses a user-defined value instead. For example, applying the tool on the low of McDonald’s in August 2015 (see chart below) shows the degree levels starting from $87.50, with the first 360 degree level at $128.92 showing resistance, and the current all-time of $178.70 being only a few cents above the second 360 revolution around the wheel from 87.5.
One other important feature of the dynamic tool is that it also works from a high going in the opposite direction, predicting potential support levels or targets. If you apply the tool to a significant high then click a second time below the level of the first click it will calculate the descending levels. The next example shows the high of Tesla at $389 with the Dynamic Square of 9 tool calculating significant support and resistance levels at descending 90 degree increments. By looking at the Square of 9 wheel you will see that the major low at $247 is exactly two 360 degree revolutions inside 389.
These are just a couple of examples of some of the advanced Gann tools that we have developed over the past 20 years which, when used in conjunction with other confirmation signals and a robust trading plan, will save you time and improve your analyses. To arrange a free trial of these tools and many more please click here, or click here to contact us.
Gann Square Of 9 Excel
Darren Hawkins, MSTA
Senior Software Specialist at Optuma
Darren is the senior Software Specialist at Optuma. He joined the company in 2009 after attending an introductory technical analysis course. Darren now instructs users all over the world, from experienced Wall Street traders and professional money managers to individual traders drawing their first trendlines.
Darren grew up in the UK and attended college in the USA where he earned a BA in Economics from St Mary's College of Maryland. He went on to spend a few years working at the Nasdaq Stock Market in Washington DC. Going on to live and work in Australia, UK and currently USA, Darren has a broad understanding of the individual needs of traders and investors utilising a wide range of methodologies.
In 2014 Darren passed the UK-based Society of Technical Analysts diploma course, and is looking forward to soon becoming a candidate for the Market Technicians Association's CMT programme.
Gann Square Of Nine Excel Workbook
When not looking at charts, Darren keeps a keen eye on England's cricket team - especially if they are playing against Australia. He recently moved to Charlotte, North Carolina with wife Wendy and their labrador, Gabba.