Intraday Reversal Time Calculator

[logicgate]

Hello 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!!

[Apprentice]

Do you have some web reference of pdf e-book?
Can you specify input in your formula?
Is it X from my version?
MOD((SQRT(Price)*X)-225,360)

Your request is added to the development list under Id Number 4604

[logicgate]

Here is a file for reference

[logicgate]

The input in the formula posted is for price only

[Apprentice]

Try this version.
viewtopic.php?f=17&t=68376