As the first target was achieved, the stop loss order was re modified as Gann Square Of 9 Excel. If the suspected pivot point bombs-out you will know immediately when price bars bust the channels.This theory is mainly used. If the trend has changed then the new Roadmap Chart will contain the future price bars for the life of the trend. Once you get a feel for the rhythm of the tickers you trade the most, and the Factor that best represents that rhythm, you can create a new Roadmap Chart within minutes of a suspected pivot point. That's all there is to it! You've created a Roadmap Chart. Add one more vertical line at the starting point price bar at the low of The chart-in-progress will show you graphically what and where to connect things better then any verbal description. Use the same low price of Find the square root To complete the vertical time lines all that must be done is draw the lines in 34 bar increments from the starting point of the bar at Draw as many vertical time lines as will fit on the chart. Eyeball these price levels on your Excel chart and draw in a horizontal line at each price level. We'll use our starting point, the low at Here's the math. Now that we've decided to use a Factor of. There is probably much more that remains unknown and undiscovered about the application of the Square of Nine than we can imagine, so experimentation is encouraged for those willing to do the work. Gann said that 90 degrees is very important for the stock market, and our own experience with the major stock market indexes confirms that, but there very well could be other very important factors for different stock market indexes, currencies, commodities or individual stocks. In practice, you can use any Factor you want and odds are that at least one will fit your trending data points exactly, even though it would have allowed you to draw the Roadmap Chart before the fact. If you want to work with Daily or Weekly data then we suggest using 90 or degree Factors, which are.
We're working with Hourly data and because 90 degrees may be too granular we use 45 degrees which is an exact division of 90 degrees for our Hourly Roadmap Charts. Many, if not most, major stock market moves end on a multiple of 90 degrees. A paper version of the Square of Nine uses rounded numbers and Just so we have some common language to work with we call the "2" we added to the square root of 15 a Factor of 2. In the example on the Roadmap Theory page we moved from 15 to 34, which is directly above 15 on the Square of Nine, by taking the square root of 15 3. In this case we want to start the Roadmap from the low at From the Square Root Theory you learned that we can move degrees around the Square of Nine by adding 2 to the square root of a number and squaring the resulting sum. When you scroll around on your Excel chart while working in the program itself, the value of the data point under the mouse cursor will appear in a little window. We used high-low-close bars but if the chart doesn't get too crowded candles also work nicely. This is what the plain-jane stock chart looks like.
We will assume that you already know how to create a stock chart in Excel. Pay attention, these four price levels will be immediately displayed in the Main screen.Hourly charts are good to practice with because conditions change quickly and you get many opportunities to experiment. In order to do that, just click your mouse on the cell and highlight the appropriate item of this menu. Here is the example of some huge table that covers almost Suppose we will analyze the price level gold and we want to find quickly the points that are located on 90,degrees in respect to this point. If you work with big tables, we recommend to decrease the Font size parameter. Scale parameter allows specifying the scale between the digits on this diagram and the real price.Ĭycles parameter allows to increase the table range.
Initial, steps: h ere you can define the value of the central cell and the step i. How to work with this module? First of all, define the major parameters for your chart. You, as the user of our software, have an advantage: you can verify all these theories using SQ9 module. Here the angle between two turning points A and B is defined by the angle between Venus and Jupiter. According to another theory, the key angle is defined by the angle between two planets. For example, the angle between two succeeding turning points A and B is 90 degrees. In other words, the turning points are located along these red angles. According to the theory, the turning points price levels are located at the Major angles such as 0, 45, 90, degrees. As an example, for digit 91 the corresponding angle is 45 degrees. The digits in this table are arranged in some order.