Serving the Quantitative Finance Community
Plot a volatility surface using excel charts
Could someone please help me in plotting a volatility surface in excel.I have implied volatility, time (days) to expiry , strike price, I also have the corresponding spot.No matter what I do, I donot get the familar vol surface looking plot, BTW the data was all got frombloomberg.Regards
Plot a volatility surface using excel charts
It looks like i should have had a grid of x and y values with the intersection as the z value then it all worksfine. thanks