Here are the steps on how to make a Gann calculator in Excel:
Create a new Excel spreadsheet.
In the first cell, enter the following formula:
=SQRT(A1)-1.4
This formula will calculate the Gann level for the price in cell A1.
3. Copy the formula down the column for all of the prices that you want to calculate Gann levels for.
4. To calculate the Gann levels for the high and low prices, enter the following formulas:
=SQRT(MAX(A:A))-1.4
=SQRT(MIN(A:A))-1.4
To calculate the Gann levels for the target price, enter the following formula:
=SQRT(A1)+1.4
You can also calculate the Gann levels for other prices, such as the open, close, and average price. To do this, simply enter the appropriate price in cell A1 and then copy the formula down the column.
Here is an example of a Gann calculator in Excel:
Price | Gann Level
-------|------------
100 | 86.6
110 | 97.2
120 | 107.8
130 | 118.4
140 | 129
This calculator can be used to help you identify potential support and resistance levels in the market. You can also use it to set target prices for your trades.
Here are some additional tips for using a Gann calculator in Excel:
Use the "AutoFill" feature to quickly fill in the Gann levels for all of the prices in your spreadsheet.
Use conditional formatting to highlight the Gann levels that are currently in play.
Use the "Solver" add-in to find the best entry and exit points for your trades.
I hope this helps!