2 Replies Latest reply on Mar 5, 2016 2:29 PM by Mosin K

    Standard Deviation bands on measured values




      I'm trying to create some simple volatility bands around a data series and getting very confused in the process.


      The attached workbook contains 2 lines (N Day & N Day - SPY). I want to create an X standard deviation band around one of the lines (e.g. N Day aka "Other Value") but the calculation I am using is clearly incorrect. What's also confusing is the fact that if I reorder the measures in the Measure Values list, the lines rearrange. Further, the values showing at the end of each line do not correspond to the Y axis values.


      Any enlightenment would be helpful as clearly I'm doing something fundamentally wrong here.