Bug with MS 10.1 Average True Range

  •  09-07-2009, 7:13

    Bug with MS 10.1 Average True Range

    Hello,
     

    I am having difficulties getting a correct value of the Average True Range Indicator.  For example, the values for the last 3 days of Hang Seng Mini index are:

    Date         High Low Close

    2/Sep/2009 19503 19295 19425
    3/Sep/2009 19715 19442 19570
    4/Sep/2009 20430 19625 20379

     

    So, by the definition for Average True Range, it is calculated as a (1) maximum of the following for each day:

    Distance between a day's High & Low. So for each day above the values are:
    2/Sep/2009 208
    3/Sep/2009 273
    4/Sep/2009 805

    Distance between a day's High &yesterday's close

    2/Sep/2009 151
    3/Sep/2009 290
    4/Sep/2009 860

    Distance between a day's Low & yeseday's close

    2/Sep/2009 359
    3/Sep/2009 17
    4/Sep/2009 55


    (2) Then we add the maximum distances for each day and divide by the number of days.  In my example it is: (359+290+860)/3=503


    So, in my example I wanted to get the ATR over 3 days.  According to the calculation above, it is 503, however, accordign to my MS chart it is 522.

     

    Why is the MS ATR not functioning properly? Is it a bug?

     

    Rgds
    Damien

View Complete Thread