#Gann square of 9 excel series
The static Square has the number 1 at the center and the dynamic Square has the historic low of the time series in the center. The Square of Nine, or Square as we will refer to here, can be constructed in at least two ways. Gann Square of 9 - Introduction Gann relied heavily on geometrical and numerical relationships and created several tools to help with his work.Īmong these tools are the Square of Nine, Square ofand the Hexagon. As a normal trader and reader, I was not able to understand any of them. I browsed through many forums for Gann Calculator and found many articles wrote on it. GLH3.SetPaintingStrategy(PaintingStrategy.LINE) ĪddChartBubble( barNum = BeginBar, GLH3, Concat(3 * Degrees_N, " *"), Color.To browse Academia. GLH2.SetPaintingStrategy(PaintingStrategy.LINE) ĪddChartBubble( barNum = BeginBar, GLH2, Concat(2 * Degrees_N, " *"), Color.White, yes ) GLH1.SetPaintingStrategy(PaintingStrategy.LINE) ĪddChartBubble( barNum = BeginBar, GLH1, Concat(1 * Degrees_N, " *"), Color.White, yes )
![gann square of 9 excel gann square of 9 excel](https://img2.exportersindia.com/product_images/bc-full/2020/5/6353726/wd-gann-square-of-9-certificate-course-1589798955-5437995.png)
GLH0.SetPaintingStrategy(PaintingStrategy.LINE) ĪddChartBubble( barNum = BeginBar, GLH0, Concat(0 * Degrees_N, " *"), Color.White, yes ) Then Sqr(Focus + (20 * Factor)) * Multiplier_NĮlse Sqr(Focus - (20 * Factor)) * Multiplier_N Then Sqr(Focus + (19 * Factor)) * Multiplier_NĮlse Sqr(Focus - (19 * Factor)) * Multiplier_N Then Sqr(Focus + (18 * Factor)) * Multiplier_NĮlse Sqr(Focus - (18 * Factor)) * Multiplier_N Then Sqr(Focus + (17 * Factor)) * Multiplier_NĮlse Sqr(Focus - (17 * Factor)) * Multiplier_N Then Sqr(Focus + (16 * Factor)) * Multiplier_NĮlse Sqr(Focus - (16 * Factor)) * Multiplier_N Then Sqr(Focus + (15 * Factor)) * Multiplier_NĮlse Sqr(Focus - (15 * Factor)) * Multiplier_N Then Sqr(Focus + (14 * Factor)) * Multiplier_NĮlse Sqr(Focus - (14 * Factor)) * Multiplier_N Then Sqr(Focus + (13 * Factor)) * Multiplier_NĮlse Sqr(Focus - (13 * Factor)) * Multiplier_N Then Sqr(Focus + (12 * Factor)) * Multiplier_NĮlse Sqr(Focus - (12 * Factor)) * Multiplier_N Then Sqr(Focus + (11 * Factor)) * Multiplier_NĮlse Sqr(Focus - (11 * Factor)) * Multiplier_N Then Sqr(Focus + (10 * Factor)) * Multiplier_NĮlse Sqr(Focus - (10 * Factor)) * Multiplier_N Then Sqr(Focus + (9 * Factor)) * Multiplier_NĮlse Sqr(Focus - (9 * Factor)) * Multiplier_N Then Sqr(Focus + (8 * Factor)) * Multiplier_NĮlse Sqr(Focus - (8 * Factor)) * Multiplier_N Then Sqr(Focus + (7 * Factor)) * Multiplier_NĮlse Sqr(Focus - (7 * Factor)) * Multiplier_N Then Sqr(Focus + (6 * Factor)) * Multiplier_NĮlse Sqr(Focus - (6 * Factor)) * Multiplier_N Then Sqr(Focus + (5 * Factor)) * Multiplier_NĮlse Sqr(Focus - (5 * Factor)) * Multiplier_N Then Sqr(Focus + (4 * Factor)) * Multiplier_NĮlse Sqr(Focus - (4 * Factor)) * Multiplier_N Then Sqr(Focus + (3 * Factor)) * Multiplier_NĮlse Sqr(Focus - (3 * Factor)) * Multiplier_N Then Sqr(Focus + (2 * Factor)) * Multiplier_NĮlse Sqr(Focus - (2 * Factor)) * Multiplier_N Then Sqr(Focus + (1 * Factor)) * Multiplier_NĮlse Sqr(Focus - (1 * Factor)) * Multiplier_N Plot GLH0 = if barnumber between startbar and startbar + numBars1 then BaseValue else Double.NaN ĭef GannValue = Focus + (1 * GMV) * Multiplier_N ĭef GannLevel = Sqr(Focus + (1 * Cycle))/Multiplier_N # Gann Musical Value from each musical noteĭef upward = highnumberall > lownumberall ĭef downward = highnumberall = BeginBar and BeginBarH = BeginBarĮlse if bar >= BeginBar and BeginBarL = BeginBarĭef startbar = if GetYYYYMMDD() = begindate then BarNumber() else startbar LowestLow1.AssignValueColor( GlobalColor( "L1" ) ) ĪddChartBubble( Show1 and barNum = BeginBar, HighestHigh1, Concat( "Highest High in ", Concat( months1, Concat (" Months is ", HighestHigh1)) ), GlobalColor( "H1" ), yes ) ĪddChartBubble( Show1 and barNum = BeginBar, LowestLow1, Concat( "Lowest Low in ", Concat( months1, Concat (" Months is ", LowestLow1)) ), GlobalColor( "L1" ), no ) ĭef begindate = if BarNumber() = BeginBar then GetYYYYMMDD() else begindate ĭef beginclose = if BarNumber() = BeginBar then close else beginclose ĭef enddate = if BarNumber() = BeginBar + GridSize then GetYYYYMMDD() else enddate ĭef BeginPrice = HighestAll(Min(HighestHigh1, LowestLow1)) LowestLow1.SetPaintingStrategy( PaintingStrategy.Dashes ) HighestHigh1.AssignValueColor( GlobalColor( "H1" ) ) HighestHigh1.SetPaintingStrategy( PaintingStrategy.Dashes ) Input Square = ĭef barNum = if IsNaN( close ) then Double.NaN else BarNumber() ĭef startBar1 = if lastBar = startBar1 and HighestAll(HighestHigh1) = highĭef BeginBarL = if barNum >= startBar1 and HighestAll(LowestLow1) = lowĭef BeginBar = HighestAll(Min(BeginBarH, BeginBarL)) # Frequencies for equal-tempered scale, A4 = 440 Hz # Frequencies for equal-tempered scale, A4 = 440 Hz: # The LOV number is taken from the stock's life path number # Dislaimer: For educational purposes only! Obviously, no guarantees whatsoever and use at your own risk.