Create Your Own Gann Wheel in Excel

To identify levels of resistance from a price low, use the following formulas in Excel for each of the degrees. The formulas are:

45 degrees (up) = ((SQRT($A$27)) + 0.25) * (SQRT($A$27) + 0.25)
90 degrees = ((SQRT($A$27)) + 0.5) * (SQRT($A$27) + 0.5)
120 degrees = ((SQRT($A$27)) + 0.67) * (SQRT($A$27) + 0.67)
180 degrees = ((SQRT($A$27)) + 1) * (SQRT($A$27) + 1)
240 degrees = ((SQRT($A$27)) + 1.37) * (SQRT($A$27) + 1.37)
270 degrees = ((SQRT($A$27)) + 1.5) * (SQRT($A$27) + 1.5)
315 degrees = ((SQRT($A$27)) + 1.75) * (SQRT($A$27) + 1.75)
360 degrees = ((SQRT($A$27)) + 2) * (SQRT($A$27) + 2)

$A$27 is a fixed cell location where the pivot price low is entered. I have entered 34 in column A, and row 27. Use ‘$’ if you have a habit of cut and pasting formulas in other locations within the spreadsheet and you must still reference where you entered the original price low.