If you need an Indicator or Signal developed or translated from other language, please post all Indicator development REQUESTS to this section here.

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

Posts: 205
Joined: Tue Dec 11, 2018 7:54 am

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 Apprentice
FXCodeBase: Confirmed User

Posts: 21599
Joined: Thu Dec 31, 2009 11:59 am
Location: Zagreb, Croatia

Here is a file for reference
Attachments FORMULA TO GET DEGREE.xlsx
logicgate

Posts: 205
Joined: Tue Dec 11, 2018 7:54 am

The input in the formula posted is for price only
logicgate

Posts: 205
Joined: Tue Dec 11, 2018 7:54 am Apprentice
FXCodeBase: Confirmed User

Posts: 21599
Joined: Thu Dec 31, 2009 11:59 am
Location: Zagreb, Croatia