Posts by ergostelios

    Re: Zig zag oscillator formula


    Hi Rob,

    Thank you for your reply and for pulling it into an excel. This is really excellent and quite close to what i am looking for. Perhaps, i was not very clear in my previous post. I am trying to connect the higher high with the lower lows. Please find attachemnt with the file you created in which i have put the zig zag values i need in column E, which are also illustrated in a chart.

    Thanks,
    Stelios

    Hi all,

    i am trying to find a zigzag formula in Excel that takes the minimum and highest prices in a series of data of a day-low and a day-high. i want it to generate only one column of prices that each number represents the period high and the period low after the price has changed by a given rate (i.e. +/-4%). I have put below sample of the data that i am currently working on. I hope that someone can help me out. Thank you in advance.

    Stelios

    DAY-HIGH DAY-LOW 11,880 11,575 11,606 11,160 11,067 10,825 11,138 10,883 11,382 11,121 11,269 10,920 10,959 10,823 11,170 10,828 11,206 10,975 11,394 11,194 11,355 11,034 11,134 10,932 11,258 10,970 11,072 10,907 11,142 10,911 10,899 10,810 11,041 10,924 11,292 11,085 11,308 10,990 10,960 10,772 10,988 10,841 11,216 10,927 11,563 11,209