4 parts to the chart: Time to expiration, Implied Volatility, Stock price, Greek 'ABC' (the plotted value).

Ideally, it would have Implied Volatility (IV) on the Z-axis, stock price on the X-axis, Greek 'ABC' on the Y-axis, then a slider or something that I can use to scroll the chart through time "axis."

I'm open to other programs as well, but it would be highly cumbersome to constantly copy 6+ Greeks worth of data from one program to the next. For every single stock I research... Each day.

(Here is a non-Excel example with only 2 axes + time slider: )

1 Answer

Have a look at Pivot charts using the 3-D surface chart.

For the 4th dimension, play around with using just the pivot filters, or "insert slicers" and "timelines".

With a bit of VBA coding, you could even add a slider object to your chart that controls the filter values.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy