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. The excel provides both the square of nine as well as the hexagon charts introduced by W.D. Gann in an excel table format. The square of nine table format and the context behind it is explained very well in Daniel Ferrara’s book The Gann Pyramid, Square of Nine Essentials.
- Gann Square Of Nine Indicator
- Gann Square Of 9 Excel
- Gann Square Of Nine Calculator
- Gann Square Of Nine Excel
This is a brief documentation for the free Gann Square of Nine Excel Workbook file located in the software store.
I have some material written on the subject of Gann Square that I planned to publish soon. 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. It is better to upload the Excel workbook and the code library first and then follow up with the articles.
Basic Usage of the Gann Square of Nine Excel Workbook
First it is an Excel 2007 file so you need a newer version of Excel to work with it. You also need the VBA enabled in the workbook to use it as the Gann Square functions are implemented in Excel VBA. 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.
After opening the workbook, the example gann square will show up. You can use it as is. Print it out for reference, look up values from there, etc.
There is also a second spreadsheet in there called Gann Square Custom. It showcases the possibility of constructing custom gann sqaure based on different initial settings.
Customization And Utilization Of The Gann Square of Nine Excel VBA Library
When you want to go one step further and build your own customized Gann Square, then you need to follow the following steps.
1. Make a copy of the workbook using a different name as you need the VBA code library from the workbook. Advanced Excel users can do it in one of many other ways in including the code library.
2. 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. The example spreadsheets named the center cells as gann and gannc.
3. Fill every cell in the region for Gann Square with this single formula,
=gannValue (center cell name)
3a. if you want to experiment with custom Gann Square configuration you can use the following formula instead,
=gannValueCustom (center cell name, center square value, increment value)
4. Ring color formatting in the examples are done using conditional formatting in Excel. 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.
Following is the conditional formatting formula used in the custom gann square example,
=MOD(ROUNDUP((SQRT((RC-3)/0.5+1)-1)/2,0),2)=0
'RC' in the formula is the current cell relative reference in R1C1 style.
'3' in the formula is the centre cell value.
Gann Square Of Nine Indicator
'0.5' is the increment value for each step.
Purpose Of The Workbook
It is a useful building block for anyone interested in constructing Gann Square but do not know how it can be done without hard coding formulas in a spreadsheet.
Anyone interested in additional functions added to the library please let me know.
Chart Reading Skill Matters
Gann square is not a tool that can work by itself. You need proper training in classic chart reading to be able to fully utilize the information you get from Gann Square. To upgrade your chart reading skill, I suggest you start with my book Art of Chart Reading available at Amazon.
How to download?
The download contains
- Gann Calculator Sheet
Gann Calculator is a popular tool for short term trading. I would recommend you understanding it first before downloading and using it. As using the tool without proper understanding may lead to great loss.
I have explained the tool in details in separate article. The article also has two videos. The videos explain the concept and how to use it for real trading with examples.
The video provides download password for the Excel Sheet as well. You should watch the video to understand the calculator, how to use the calculator for trading and password to download the Excel sheet.
Password Link – Password is given in the Video. You can watch either Hindi Video or English Video. Both of them have explanation as well as password.
Once you have the password you can click on below link and enter the password to download the Excel sheets.
Gann Square Of 9 Excel
Online Gann Calculator
Gann Square Of Nine Calculator
I have also created Online Gann calculators for Nifty and Bank Nifty. You can use these online calculators if you are not comfortable with Excel Sheet. I have not created online versions for stocks as there are too many stocks and many traders prefer the Index to make short term trades due to Liquidity.
In case you are interested in Stocks then you can use the Excel Sheet version. Note you may notice slight difference in my version of Gann calculator and other Gann calculators online. I prefer using the closing prices instead of live prices. Closing prices give you better picture of what to expect in next day trade.
It also helps you plan better and execute that plan in next day trade. The usage of online calculators in explained in the video as well. In case you have any questions then you can post on website forum or YouTube.
Nifty Gann Calculator
Bank Nifty Gann Calculator
Download Link – First Get the password from Videos above