53

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:

Excel Based Trading Systems

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.

Intraday Trading using Gann square of 9 Calculator

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:

Gann Square of 9 Calculator

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.

Buy Sell Targets

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

Support Resistance Levels

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.

Download link for Gann square of 9 calculator

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


Spreadsheets for Success

Related Posts

53 Comments

  1. 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 Kartik;
      I’hv traded on NIFTY FUT.- the best time2enter is 9.40 am. Gives excellent results , now I’m using it in trading INTERNATIONAL FOREX along with STOCH.; 78% 1st TGT.HITTTT.

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

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

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

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

    • Hi Fabio,

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

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

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

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

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

    • Hi Prasanna,

      Thanks for your evaluation. For Forex, you may try other strategies posted in the website.

  9. When we should initiate the buy or sell entry? Is it immediately after crossing the buy above or sell below line or after closing of candle above or below these line. And how to move the sl or tsl is it immediately after crossing the target lines or after closing the price above or below target lines. Please help.

    • Hi Hrushikesh,

      Both entry and SL rules can work, however the latter one is recommended if you are a conservative trader and just starting out

  10. Dear Sir,
    I m unable to find out Gann calculator download link. so, Please send me Gann Square of 9 excel sheet on my given mail id..
    Regards,
    Kishor Kanase

  11. मुझे डाउनलोड करने के लिए लिंक नही मिली

  12. Dear sir,
    When I press the ‘Get Data’ button, I get an “run time error ‘1004’. Unable to open the http:….. Cannot download the information requested”. Please help in fixing the bug.

  13. Hello Sir,
    Thanks for your excellent work, it shows the perfect values for nifty future

    But when I tried it for currency, the results were quite suspicious. For example, on 19.06.20 it was showing sell USD/INR below 74.39, target 72.25 when CMP was 76.22 and we all know that’s an impossible target for intraday currency

    So can you please make the necessary modifications

  14. Hi, thank you so much for this sheet. Is there any chance you can edit it to take values for forex please? I have been trying to customise it but not getting anywhere, unfortunately 🙂

    • Hi Charles,

      I don’t think the sheet needs to be edited for forex. Just add the price levels and the GANN values would be calculated automatically

  15. Thanks very much . Cud you write something on CoG: centre of Gravity too some time. Tks & Best Regds

Leave a Reply

Your email address will not be published.