# Beat the market with Gann square of 9 Calculator

Square of 9 from WD Gann is an unconventional method in Technical analysis which uses angular and geometric relationships among numbers to predict the stock moves. This is a very popular method among intraday traders owing to its accuracy in equities as well as commodities. The square of 9 is actually a spiral or wheel of numbers. The center of the square contains the initial value which is increased clockwise in spiral form. Each number in the square represents an angle relative to the center. In this post, we would understand in detail how to use Gann square of 9 Calculator for intraday trading. There is an excel sheet attached with the post which would help you to calculate support and resistance levels based on Gann theory.

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

# History of Gann Square

At one point in his trading career, W.D.Gann took three year’s leave to go to the U.K to study the past history of selling prices of Wheat. During his meticulous studies, he developed some very powerful and innovative techniques, none more so than his use of the tool we call the Square of 9. Gann closely guarded his secrets whilst he was alive, but almost certainly the Square of 9 calculations was pivotal in his trading methods. The Square of 9 was not created by Gann.  He actually found it inscribed in a temple in India and on the walls of the Great pyramid in Egypt, but he was certainly the first trader to recognize its importance and relevance in market trading.

Gann held a trading record which has been unsurpassed by anyone since.  In front of a customs inspector he turned \$130 into \$12,000 in less than 1 month. Again, in the presence of an independent witness, he made 286 trades, 264 winners and 22 were losses.

Gann square of 9 calculator is used to generate support and resistance levels for intraday trading. Breakouts of thee levels would be used to enter trade. The support/resistance levels are generated using the values in Gann square. In order to generate these levels, we need to input the latest trade price or weighed average price in Gann calculator (attached with the post) . LTP should be taken after at least half an hour of trade for better results , as there is lot of volatility in market during the first 30 minutes. Once you input this price the Gann levels would be automatically generated. See below:

Also, the buy/sell price and respective targets would be generated in the Excel sheet. In this particular example, we need to enter buy if the price crosses above 8418.06 and enter short if price crosses below 8395.14.

Lastly there are support resistance levels based on which targets are calculated above:

# How Gann values are calculated?

Every value in the Gann square is related to the center value. Below are the steps used to calculate these values:

1. Calculate the square root of LTP. Let’s suppose LTP=8400, then SQRT(8400)=91.65
2. Take two integers below and above the square root calculated. In this case they would be 90,91,92 and 93.
3. Square the lowest values out of the 4 calculated above. SQR(90)=8100. Put this value at the center of Gann square.
4. Now, increase 90 by 45 degrees. In numeric terms 45 degrees is equal to 0.125 (360 degree=1). So our required value is 90.125.
5. Calculate square of 90.125, and place it in adjacent block left of center block. SQR(90.125)=8122.52.
6. Increase the value further by 45 degrees. 90.125+0.125=90.25. Find out square of this value and place it at the top of where you placed 8122.52. SQR(90.25)=8145.06
7. Continue this process by increasing the value by 0.125 for each iteration.
8. Once you complete one level of square, start with the next level with values 91.125,91.25….

Resistance values are the next higher values in the Gann square above the Buy Price. While support values are the next lower values in the Gann square below Sell price. Targets are calculated based on support and resistance.

Please see the below link to download Gann square of 9 calculator Excel Sheet. You simply need to input the current market price and the excel sheet would do rest of calculation itself.  Please let us know if you have any queries. Also, send us your feedback on how to improve this sheet.

Gann Square of 9

1. Karthik

Hello Sir,

Thanks a lot for this execellent tool. Could you please let us know if you have tested it in any particular stock/index and proved success. It would be of great help if you can provide some.

Hi Karthik,

It works good for all liquid stocks with high volumes.

• Karthik

2. Abeed Gavandi

What is S.L ? Are you tested this strategy in live market?

Hi Abeed,

Initial Stop Loss should be half of Target1. For ex: if Target1 is 20 points then initial Stop Loss should be 10 points. After crossing Target1 you should trail your Stop Loss.

Yes we have tested it in Live market

• Average True Range could also help in placing S.L as it considers the volatility as well

3. Abeed Gavandi

Sir,In calculator i can put NF value?

Yes, of course.

4. amit

How to use it for positional trades.

Hi Amit,

This method is not recommended for positional trades.

5. raj

Hello Sir, Can we use this method for commodity market?

Hi Raj,

Yes, you can try this for Commodity market too.

6. raj

thanks a lot sir

7. Sir, If I place CMP, it appears at left hand side of calculator.

8. esan

sir for daily 2 targets how to trade or which time to enter

9. jyotiba

I want to apply the output of gann calclulator.But I dont know which figure is for limit buying in intraday .and which figure is for stop loss. further there are two types of targets and its 1,2,3,….when and where this 1,2,3… are placed in buy and sell?

Hi Jyotiba,

Different targets are provided so that you can trade based on your risk potential. I suggest that you should book 50% profit at Target 1, and 10% each at subsequent targets. Hope that helps.

10. Sir I would like to know as to why all the numbers are rotated in 45 degrees,
further why 8303.77 is not taken in red box left of 8281
why is the buy above price is taken as 8418.06 & not any other green boxes like 8326,8372
further how is the targets determined?
I had been through some site where in they calculate square of 9 , by taking high & low & calculating seed value & step value & rotating it in the square of 9×9, they take the low value in the centre & rotate it from the immediate left box in 3×3 once the inner circle is completed the starting point of the next circle will be from the left box of the completing circle & in this way till all 9×9 boxes are completed, the buy above price will be the starting point of the 3rd circle & the target will be last circle & all diagonals & centre lines acts as support & resistances.
I would like to know the logic of square of 9, if you guide me on the above it will be highly appreciated.
Regards

11. Rahul

Hi Rahul,

Link is towards the end of the post

12. Cry Wolfe

How one can place astrological calculations in the chart? The way I understand Mr Gann rely heavily on the aspects of the stars? Any guidance would be appreciated.

13. Fabio

How we can use with EURUSD?

Hi Fabio,

Just input the CMP for EURUSD in excel sheet, and the GANN values would be calculated automatically.

14. Chintan Gangar

what should we put price like previous close price or any particular time say 10:30 am time price.
I am getting confused on CMP, but which one ?

Hi Chintan,

It depends on the timeframe in which you trade. If it is 30 mins, then you should enter the price at the end of 30 min candle.

15. Anand

Should we use live trading price or VWAP ?

Hi Anand,

You need to use live trading price.

16. Vijay

Can we use this calculator for Bank Nifty for Intraday Trading. If so, what is the target and SL (risk-reward ratio) should be ?

Hi Vijay,

Risk reward ratio should be minimum 1:2

17. Vikram

Working fine with crude oil. Unfortunately not working with Lead and zink.

Hi Vikram,

Unfortunately technical strategies do not work equally on all instruments. Please check other strategies posted in our website too

18. Prasanna

Works fine in nifty fut.Best time to enter is btween 9.30-10.15am.Out of 6 trades so far 4 times tp hit ; out of these 2 times hit 2nd tgt.2 times sl hit.Still 6 trades r v.less ; but result poor in FOREX.