# Intraday Trading Using Gann Calculator

#### jinjin

##### New Member
How can I thank you for such a wonderful post. Keep giving us similar tutorials.
I have made the Gann calculator on excel and will try using it in my next endeavour.
Nevertheless Thanks.

Last edited:

#### sujittalukder

##### Active Member
I have made the Gann calculator on excel and will try using it in my next endeavour. Thanks.
Hi jinjin,

Could you upload the Excel file, I tried but failed to make the excel file.

regards
Sujit

#### Karanm

##### Active Member
Sir, Kindly explain the following :

1. You are having two threads and both have diffrent Calculators - One
gives only one option - Long or Short and the second gives both the
options - Long above ---- & Short below ----, which Calculator we have
to use.

2. As per you knowledge, what is the Success Ratio & Risk/Reward Ratio we
can expect while trading with this Statergy of yours.

Regards
Karanm
Sir, I am waiting for your Reply.
Regards
Karanm

#### sujittalukder

##### Active Member
Dear radha555,

I have the following queries?
1. How to make the calculator in Excel ie the formula we need to use? Please elaborate.

2. The calculator you provided is based on single price. However some calculators are there which are based on High and Low prices. Whats the difference between the two approach and could you throw some light on these two approches.

3. Why the cell position of LTP changes when we change the LTP like this as shown in image?
Does it carry any significance?

4. Also in the below image, how to move clockwise, anticlock wise?

regards
Sujit Talukder

#### radha55

##### Well-Known Member
All your questions are very trivial.

Still i will try to guide u.

I have the following queries?
1. How to make the calculator in Excel ie the formula we need to use? Please elaborate.
I have already given the formulas in initial 10 post.

2. The calculator you provided is based on single price. However some calculators are there which are based on High and Low prices. Whats the difference between the two approach and could you throw some light on these two approches.
I dont know about others. but i have designed this calculator based on my understanding of Gann Squar of 9.

3. Why the cell position of LTP changes when we change the LTP like this as shown in image?
Does it carry any significance?
Yes it carry a significance. It shows u on which angle the price falls.(degress - u need to learn some geometry to understand this)

4. Also in the below image, how to move clockwise, anticlock wise?
Please read initial 10 post or google search clockwise and anticlockwise.

#### radha55

##### Well-Known Member
Sir, Kindly explain the following :

1. You are having two threads and both have diffrent Calculators - One
gives only one option - Long or Short and the second gives both the
options - Long above ---- & Short below ----, which Calculator we have
to use.

2. As per you knowledge, what is the Success Ratio & Risk/Reward Ratio we
can expect while trading with this Statergy of yours.

Regards
Karanm
Its upto u whichever suits u.

Whenever someone like me comes up with some system, you can do some paper trade and then follow the system which suits u.

I dont have any sucess/failure ratio as of now.
Because its only one month this tool is developed.

#### radha55

##### Well-Known Member
Hi All,

The WAP of Nifty Futures in morning at around 9:10 am was 5280.

We get below calculation by entering this price.

Now Buy Triggered at 5296. Target 1 achieved at 5308.
Profit = 5308 - 5296 = 12 points.

Sell call was below 5274. See the low for today in Nifty Futures. It is 5276. This is the accuracy of this system.

#### jinjin

##### New Member
Hi jinjin,

Could you upload the Excel file, I tried but failed to make the excel file.

regards
Sujit
Hey Sujit,

I hadn't came on this thread since then. Here I've uploaded the excel file for the benefit of you and other users whomsoever need this. Enjoy and must also thank Radha. Links for download are below. :thumb:

#### White

##### New Member
Hi All,

The WAP of Nifty Futures in morning at around 9:10 am was 5280.

We get below calculation by entering this price.

Now Buy Triggered at 5296. Target 1 achieved at 5308.
Profit = 5308 - 5296 = 12 points.

Sell call was below 5274. See the low for today in Nifty Futures. It is 5276. This is the accuracy of this system.
Hi radha,
How to calculate WAP?