Intraday Trading Using Gann Calculator

Discussion in 'Day Trading' started by radha55, Mar 17, 2010.

  1. jinjin

    jinjin New Member

    Joined:
    Mar 22, 2010
    Messages:
    4
    Likes Received:
    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
    radha55 likes this.
  2. sujittalukder

    sujittalukder Active Member

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

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

    regards
    Sujit
     
  3. Karanm

    Karanm Active Member

    Joined:
    Oct 18, 2009
    Messages:
    410
    Likes Received:
    192
    Trophy Points:
    43
    Sir, I am waiting for your Reply.
    Regards
    Karanm
     
  4. sujittalukder

    sujittalukder Active Member

    Joined:
    Jan 18, 2006
    Messages:
    201
    Likes Received:
    68
    Trophy Points:
    28
    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?

    [​IMG]
    regards
    Sujit Talukder
     
  5. radha55

    radha55 Well-Known Member

    Joined:
    Mar 3, 2009
    Messages:
    537
    Likes Received:
    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?
    Please read initial 10 post or google search clockwise and anticlockwise.
     
    aabhi06, scplindia and sujittalukder like this.
  6. radha55

    radha55 Well-Known Member

    Joined:
    Mar 3, 2009
    Messages:
    537
    Likes Received:
    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. kalyanr33

    kalyanr33 New Member

    Joined:
    Feb 18, 2010
    Messages:
    6
    Likes Received:
    2
    Trophy Points:
    3
    thanks a lot radhaa
     
  8. radha55

    radha55 Well-Known Member

    Joined:
    Mar 3, 2009
    Messages:
    537
    Likes Received:
    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.

    [​IMG]

    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. jinjin

    jinjin New Member

    Joined:
    Mar 22, 2010
    Messages:
    4
    Likes Received:
    4
    Trophy Points:
    3
    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:

     
    cbosein, karin_jack and vssoma like this.
  10. White

    White New Member

    Joined:
    Feb 19, 2008
    Messages:
    22
    Likes Received:
    6
    Trophy Points:
    3
    Hi radha,
    How to calculate WAP?
     
Loading...

Share This Page