What is the formula in Excel for a zigzag indicator?

Answer 1

The so-called Zigzag oscillator is the output of several variables and depends on what dataset you are using and your percentage of price movement tolerance. There is no one universal formula for this. I'd suggest creating a simple model to determine the support and resistance areas in your asset price dataset. Once you have done that and if you have specific questions feel free to reply to this post and I will respond.