Intraday Reversal Time Calculator

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

Moderator: admin

Intraday Reversal Time Calculator

Postby logicgate » Sun Apr 14, 2019 11:13 am

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
FXCodeBase: Graduate
 
Posts: 268
Joined: Tue Dec 11, 2018 7:54 am

Re: Intraday Reversal Time Calculator

Postby Apprentice » Thu Apr 18, 2019 6:01 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
User avatar
Apprentice
FXCodeBase: Confirmed User
 
Posts: 22093
Joined: Thu Dec 31, 2009 11:59 am
Location: Zagreb, Croatia

Re: Intraday Reversal Time Calculator

Postby logicgate » Sat Apr 20, 2019 6:15 pm

Here is a file for reference
Attachments
FORMULA TO GET DEGREE.xlsx
(9.46 KiB) Downloaded 60 times
logicgate
FXCodeBase: Graduate
 
Posts: 268
Joined: Tue Dec 11, 2018 7:54 am

Re: Intraday Reversal Time Calculator

Postby logicgate » Sat Apr 20, 2019 6:16 pm

The input in the formula posted is for price only
logicgate
FXCodeBase: Graduate
 
Posts: 268
Joined: Tue Dec 11, 2018 7:54 am



Return to Indicator and Signal Requests

Who is online

Users browsing this forum: No registered users and 1 guest