Intraday Reversal Time Calculator
Posted: Sun Apr 14, 2019 11:13 amHello brother, hope all is good.
Can you please create this calculator in excel? I found this formula which uses Gann's square of 9 to find intraday reversal times. This is the formula:
=MOD((SQRT(Price)*180)-225,360)
Let's say opening price is 9801, then =MOD((SQRT(9801)*180)-225,360) which equals 315 degrees.
So we convert degrees to time dividing 315 by 60 minutes which is 5.3 (5 hours and 18 minutes). So we add this to the opening price of the day 09:00AM then we get 14:18PM. This is the probable reversal time. But sometimes price keeps going, so it is good to have some extra time
projections, so need to add more degrees to the main result like 30, 60, 90. Can you implement this in the excel file so we can have a field to put:
- the opening price
- the opening time
Then we click ok to calculate so we get the probable reversal time plus extra 30, 60, 90, 120 and 180 degrees projections (in the case the main one fails).
thanks!!
Can you please create this calculator in excel? I found this formula which uses Gann's square of 9 to find intraday reversal times. This is the formula:
=MOD((SQRT(Price)*180)-225,360)
Let's say opening price is 9801, then =MOD((SQRT(9801)*180)-225,360) which equals 315 degrees.
So we convert degrees to time dividing 315 by 60 minutes which is 5.3 (5 hours and 18 minutes). So we add this to the opening price of the day 09:00AM then we get 14:18PM. This is the probable reversal time. But sometimes price keeps going, so it is good to have some extra time
projections, so need to add more degrees to the main result like 30, 60, 90. Can you implement this in the excel file so we can have a field to put:
- the opening price
- the opening time
Then we click ok to calculate so we get the probable reversal time plus extra 30, 60, 90, 120 and 180 degrees projections (in the case the main one fails).
thanks!!