'0.5' is the increment value for each step. '3' in the formula is the centre cell value. 'RC' in the formula is the current cell relative reference in R1C1 style. The formula is essentially a reverse calculation of the ring value based on the property of Gann Square which I will discuss in a separate article.įollowing is the conditional formatting formula used in the custom gann square example, Ring color formatting in the examples are done using conditional formatting in Excel. =gannValueCustom (center cell name, center square value, increment value)Ĥ. if you want to experiment with custom Gann Square configuration you can use the following formula instead, Fill every cell in the region for Gann Square with this single formula,ģa. 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. Advanced Excel users can do it in one of many other ways in including the code library.Ģ. Make a copy of the workbook using a different name as you need the VBA code library from the workbook. When you want to go one step further and build your own customized Gann Square, then you need to follow the following steps.ġ. It showcases the possibility of constructing custom gann sqaure based on different initial settings.Ĭustomization And Utilization Of The Gann Square of Nine Excel VBA Library There is also a second spreadsheet in there called Gann Square Custom. Print it out for reference, look up values from there, etc.

And before anyone asking why not do it in Google spreadsheet, it is not a good idea at all because Excel is way better in this aspect in terms of customization and application building.Īfter opening the workbook, the example gann square will show up. You also need the VBA enabled in the workbook to use it as the Gann Square functions are implemented in Excel VBA.

Basic Usage of the Gann Square of Nine Excel Workbookįirst it is an Excel 2007 file so you need a newer version of Excel to work with it. It is better to upload the Excel workbook and the code library first and then follow up with the articles. Then I realized that without a working Gann Square on hand it will be difficult for many people to understand what I am talking about. I have some material written on the subject of Gann Square that I planned to publish soon. This is a brief documentation for the free Gann Square of Nine Excel Workbook file located in the software store.

Gann square of 9 formula in excel