Posts by ashwin1490

    Re: Zig zag oscillator formula


    Quote from Rob Xaos;525121

    Well after a bit more formula wrangling...
    =IF($D28<$D27,IF($D29<$D28,NA(),IF(ABS($K28)>$M$27,$D28,NA())),IF($D29>$D28,NA(),IF(ABS($K28)>$M$27,$D28,NA())))

    Seems to do the trick. Although to exactly match your example I had to use 4.3%. Its not a very mathematically elegant solution so I may have a muddle over it again at some point if it grabs my fancy. However it works.


    this is quite accurate! however i haven't been able to drag this along for a larger data set as this is an array. any suggestions?