Gann Square Of 9 Excel Table Gann's square of nine calculator is meant for intraday trading. It is named after William Delbert Gann, who developed this and many more financial trading analytical tools. This gann calculator uses Last Traded Price (LTP) of any stock to provide buy and sell suggestions. The Square of Nine can be considered as an exotic section in relation to Gann analysis. Square of Nine Structure Starting from the center(1) and following the numbers as they unwind, an infimite spiral becomes apparent. Looking at lower right corner of the grid, you see the squares of odd numbers.3,5,7,9,11.giving. 9,25,49,81,121, with each. Intraday Trading using Gann square of 9 Calculator Gann square of 9 calculator is used to generate support and resistance levels for intraday trading. The supportresistance levels are generated using the values in Gann square. GANN Square of 9 Calculator / GANN Calculator: The GANN Square is derived from Spiral Chart by GANN. The GANN square of 9 is a 9×9 grid. This theory is mainly used in intraday calculator and is very easy to use. Gann Analysis through Excel – GATEThe Complete Package - GATE Ultimate PLUS Get all the functionality GATE has to offer. How to use Gann's Square of Nine Intraday Calculator Gann Square of 9 - Introductio 1. This calculator is meant for trading only intraday. Enter the LTP ( or WAP - Weighed Average Price )of any stock / index/ underlying anytime during the market hours. The ideal time is 15min - 1hr after market opens.

Excel Program: Master Chart Calculator -- More Info & Samples & Videosgo back For security and global mechanics, the credit card merchant of choice is PayPal You don't have to be member of PayPal to use the 'Buy Now System'. Security is my main issue, and PayPal has proved to rank at the top of the credit card merchant list. If you purchase one or more items below please email me to let me know you made a purchase, this speeds up the process in getting your new material. cbotman33@gmail.com The program uses the basic square of nine and other excellent tools added. Accurate, fast, and has special folders to print out specific list of prices and dates that are on the major Gann angles. What use take days can be done in seconds. The Excel is limited to 64000 cells and this program takes advantage of all its space. 180x180=32400 Added Features: Master Charts of Price (square of nine), This is the most common understanding users have of the Master Chart. Except, it allows the user to input 0, 1 or any import low, in which each cell increases by a factor of 1. The main input page generates a list of all important price per angles and also dates per angles for easy printing and future resource. {example: I use 192 in the center cell, all-time low in Nov beans, then all future price angles are directly related to the low not 0 or 1} Master Charts of Dates, each cell increases one calendar day per cell from the center cell and progressively increases by 1. You can input any important historical time you wish, old high, old low dates or [example] beginning of WWII. This accurately forecasts the future angles of time. Master Charts From A Specific High Price, each cell decreases by one from the center cell input. The sample link above shows this feature. In mathematics one can Multiply, Divide, Add or (Subtract) and is equivalent and relevant. Master Charts (2), this portion of the program allows the user to input any number in the center cell and each corresponding cell will increase by the number in the center cell. (1,2,3,4) etc. I like to use 7 in the center then all the cells increase by 7, this gives data for my weekly calculations. Be flexible as long as it is mathematical. Master Charts (2 Dates), similar to the MC2 above except the corresponding inputted number transfers to dates. Each corresponding cell doubles by dates. Gann Master Chart Program in Excel: $69.00 Item 1005 You can add both excel programs to your order once in PayPal

Square of Nine

Gann Square Of 9 Excel Sheet

General idea

This is Gann�s square of nine (SQ9):

The digits in this table are arranged in some order. Each digit is related to some angle. As an example, for digit 91 the corresponding angle is 45 degrees:

According to the theory, the turning points price levels are located at the Major angles such as 0, 45, 90, 135, 180, 225, 270, 315 degrees:

In other words, the turning points are located along these red angles.

According to another theory, the angle between two succeeding turning points should be some special angle (such as 90, 120, � degrees):

For example, the angle between two succeeding turning points A and B is 90 degrees.

According to one more theory, the �key� angle where the price changes its trend is defined by a planetary position:

On this picture, the next turning point 538 is shown by the Sun�s position (you may consider other planet�s position as well).

According to another theory, the key angle is defined by the angle between two planets.

Like this one:

Here the angle between two turning points A and B is defined by the angle between Venus and Jupiter.

Each theory has its followers. You, as the user of our software, have an advantage: you can verify all these theories using SQ9 module.

Major parameters

How to work with this module? First of all, define the major parameters for your chart:

Initial, steps: here you can define the value of the central cell and the step (i.e., the difference between two cells):

Scale parameter allows specifying the scale between the digits on this diagram and the real price:

Cycles parameter allows to increase the table range:

For example, if you analyze S&P500, you need a bigger table. Increase the �Cycles� parameter to get this:

Huge tables. If you work with big tables, we recommend to decrease the Font size parameter. Here is the example of some huge table that covers almost 17.000 cells (for DJIA):

Scroll it using these scrollbars:

Square of Nine support/resistance levels

Now we are ready to work with this module.

Suppose we will analyze the price level 579 (gold); and we want to find quickly the points that are located on 90, 180, 270 degrees in respect to this point. In order to do that, just click your mouse on the cell 579 and highlight the appropriate item of this menu:

Gann Square Of 9 Excel

The program will mark these cells:

Pay attention, these four price levels will be immediately displayed in the Main screen:

This is another example based on 60 degrees pattern (hexagram, star of David) with staring cell 579=$579:

Thus you can try different figures and different starting points.

Clear chart. To clear Square of Nine chart and remove support support/resistance levels from the Main screen, use these buttons in 'Mouse action' tab:

Planets

You can display the planetary positions overlay of Square of Nine table, in 'Planets' tab you will find all necessary parameters for this charting:

To define the transit data (which is used to calculate the planetary position), click on this button:

Also you can click a mouse button anywhere on the Main screen, and the program will recalculate the planetary positions automatically.

One more feature is the possibility to shift the planetary positions for ALL planets on certain degrees:

This feature is very useful if you need to combine some cell with some planetary line. As an example, varying this shift parameter I combine the 615 cell with Jupiter line.

Catching Tops/Bottoms

There is one more possibility: you can extract top/bottom turning points from the price chart and put the price levels that correspond to these price levels o Square of Nine chart.

To do that, follow these steps:

1) In 'Mouse action' tab highlight 'Catch Top price item':

2) In the Main screen, make mouse clicks around some major tops:

The program catches the major tops and marks the cells that correspond to these tops by red color squares:

3)Next step: highlight 'Catch Bottom Price' option:

�

and make mouse clicks around bottoms in Main screen.

Finally you get the picture like this (red squares - top price levels; blue squares - bottom price levels):

Square of Nine + ULE module

Now, let me show how to use SQ9 module together with ULE module of the program. The general hypothesis is:

a)the trend changes when two key planets make some aspect;

b)the angles of these key planets point out the price levels.

Gann Square Of Nine Chart Calculator

For example, let us assume that Venus and Jupiter are the key planets for some financial instrument �X�. Consider the moments when Venus and Jupiter make any of Ptolemy aspects in Heliocentric zodiac.

In ULE window, create this event:

After the calculation, you get this:

The red stripes correspond to the moments of this aspect�s culmination.

Run SQ9 module, set Venus and Jupiter planets and Helio zodiac (run SQ9 module through Tools/Techniques menu):

Now in the Main screen click the mouse on one of the red strips (that is the moment of the exact aspect). You will get this:

These two lines point at the price targets according to this theory.

Example

There is one more example of employing SQ9 chart. I did not make a special example here as my purpose was just to demonstrate how to realize the most typical approaches of using SQ9.

This is a piece of the price chart for DJI:

�

You see there is Low $10000.46 that took place at the end of April 2005. Let's use this price level $10000 as our starting point for SQ9 chart. We will look for the next turning points here. We will use step=10.

Set these parameters - initial value, step and amount of cycles:

����������

You get this table:

Now we need to mark already known turning points.

Start with the bottoms. Just set this option to define a mouse action:

Click the mouse around major bottoms:

The program puts these prices on SQ9 table:

Then catch top points in the same manner:

Finally you will get this:

I do not see any pattern here. Do you? Still, we can try playing with time distances between the turning points.

First of all, set the initial date:

In our example, we set the initial data (4/19/2005) and the step (which is set to 1).

Set the amount of cycles to 14:

�

We need more cycles because we need to have enough cells to calculate the time distance.

Now let�s catch the dates of bottom/top points and put them on the table. Choose this point:

,

then in the Main screen click the mouse around major bottoms.

I got this picture:

As you see, we get a hint: these three bottoms are located at the same line (I did not find a similar pattern for the tops).

I think the central idea of Square of Nine technique is to find some regular pattern in location of top/bottom points on the SQ9 chart.