Once you have the password you can click on below link and enter the password to download the Excel sheets. 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. 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.
When you want to go one step further and build your own customized Gann Square, then you need to follow the following steps.
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. 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.
The Square of 9 is basically a spiral of numbers. The initial value can be found in the center of the spiral. This value is then increased by moving in a spiral form. Normally the center value is 1 and the step is one creating the spiral Read more This calculator is meant for trading only intraday.
0コメント