DashboardNovice
Member
I am trying to plot a bell curve, where one standard deviation move = Stock Price x Implied Volatility (IV).
The graph needs to be able to adjust so that the user can enter different IVs.
Finally I would like to show vertical bars marking the 1st standard deviation and the 2nd standard deviation.
I have experimented with the various standard deviation functions, but I can't get them to work the way I would like. I also don't understand the last argument called "cumulative" in the NORMAL.DIST function.
The graph needs to be able to adjust so that the user can enter different IVs.
Finally I would like to show vertical bars marking the 1st standard deviation and the 2nd standard deviation.
I have experimented with the various standard deviation functions, but I can't get them to work the way I would like. I also don't understand the last argument called "cumulative" in the NORMAL.DIST function.
