I want to know the price of options at 20 delta, irrespective of the presence of a strike exactly at 20 delta.
Does this assume that you’ll have the option chain with prices of other options at published strikes?
Oh, then you can approximate. Someone here may be able to help. Some historical option data sellers (like OptionWorks) actually sell historical option data that doesn’t have any specific prices or option chains, just variables of a math function (6-degree polynomials) that allow you to calculate any option prices at any imagined strike or delta, even in Excel. Similarly, you could also use Excel to curve fit your existing deltas from the options chain and then obtain prices at any other specified delta. Or you may be able to use the Forecast function in Excel to keep it simple. If no one else here helps then you could even hire anyone good with Excel, or someone to write a few lines of code if you need to access your data from some CSV files. You may still want to provide more info about what you want: just Excel function/code, or some program that reads your option prices from some files, etc.
Yes, you can get this, not sure about feed providers for this, but probably your best shot to get this is through either Bloomberg or Refinitiv (Both will be expensive, either on terminal or as feed). You can calculate it though, you need Bid/Ask IV real-time data (For the range of strikes having deltas between at least 70D and 10D). Plot the IVs against fixed deltas instead of against strike prices, i.e. plot IVs against 10D, 20D, etc... How do you do this? By interpolating the IVs across the delta range. Your X-axis (Deltas) in this case will be fixed but instead of the IVs only moving on the Y-axis (i.e. moving up or down), IVs will move up/down as well as right/left (As IVs not only change in their value, but also change against deltas). This curve will be interpolated in between the points, all you need to do after that is to pick the 20D IV and reverse it back to the option price. Hope it's clear enough.
So here is quick Excel example that may not be very accurate as it's not using IV, just fitting poly curve between Deltas. You'd need to enter several known Deltas that you have into Excel, and use LINEST function to obtain poly coefficients: =LINEST(B$2:B11,A$2:A11^{1,2,3},TRUE,FALSE) Then calculate price for a specified Delta using the poly output function like this: =D2*D5^3+E2*D5^2+F2*D5+G2 Now you can enter some new Delta and it will show you the estimated price:
Hi Gowthamn You can get the IV at that delta and calculate the price straightforwardly using our Monies API: Here's a call right at the 20 delta: the SMV (smooth market value) is 36.6.