Gann's Square of 9 (Nine) Calculator Select Your Currency Enter Current Market Price Gann Square of 9 Recommendation: Buy At / Above Stoploss Sell At. Fill every cell in the region for Gann Square with this single formula, 3a. The example spreadsheets named the center cells as gann and gannc. On the spreadsheet that you want to create a new Gann Square, locate the cell that you want to put the Gann Square to and give it a name using Name A Range command in Excel. This Tool is useful for traders, who are already. The FataFat Gann calculator supports calculation based on Yesterday’s closing price and Today’s opening price. This new tool calculates the Square of 9 Gann Value for all FNO stocks, The Nifty and Bank Nifty Index and displays it on one screen. The New Gann Square of 9 Calculator, Automatic. This calculator is meant for trading only intraday. Normally the center value is 1 and the step is one creating the spiral Read more. This value is then increased by moving in a spiral form. The initial value can be found in the center of the spiral. The Square of 9 is basically a spiral of numbers.