1. ### jinjinNew Member

Joined:
Mar 22, 2010
Messages:
4
4
Trophy Points:
3
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: Mar 29, 2010
2. ### sujittalukderActive Member

Joined:
Jan 18, 2006
Messages:
201
68
Trophy Points:
28
Hi jinjin,

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

regards
Sujit

3. ### KaranmActive Member

Joined:
Oct 18, 2009
Messages:
410
192
Trophy Points:
43
Regards
Karanm

4. ### sujittalukderActive Member

Joined:
Jan 18, 2006
Messages:
201
68
Trophy Points:
28

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

Joined:
Mar 3, 2009
Messages:
537
571
Trophy Points:
93
Location:
mumbai
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?

aabhi06, scplindia and sujittalukder like this.

Joined:
Mar 3, 2009
Messages:
537
571
Trophy Points:
93
Location:
mumbai
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.

aabhi06 and scplindia like this.

7. ### kalyanr33New Member

Joined:
Feb 18, 2010
Messages:
6
2
Trophy Points:
3

Joined:
Mar 3, 2009
Messages:
537
571
Trophy Points:
93
Location:
mumbai
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.

aabhi06 likes this.
9. ### jinjinNew Member

Joined:
Mar 22, 2010
Messages:
4
4
Trophy Points:
3
Hey Sujit,

cbosein, karin_jack and vssoma like this.

Joined:
Feb 19, 2008
Messages:
22