Options workbook guide
IBKR options IV and Greeks in Excel for Mac
Use XLNative formulas to bring option quotes, implied volatility, Greeks, model price, and underlying price from your local TWS or IB Gateway session into Excel cells.
=XN.MARKET("AAPL:call:205:20260821","bid")=XN.MARKET("AAPL:call:205:20260821","ask")=XN.MARKET("AAPL:call:205:20260821","modeliv")=XN.MARKET("AAPL:call:205:20260821","delta")=XN.MARKET("AAPL:call:205:20260821","theta")The workflow
Keep option data beside your own Excel model
An option workbook often needs more than a last price. You may want the current bid and ask, model implied volatility, bid or ask IV, delta, gamma, theta, vega, model price, and the underlying price in adjacent cells. XLNative exposes those fields through one XN.MARKET function with a field argument.
Excel remains responsible for the workbook logic: scenario analysis, spread calculations, position sizing, charts, conditional formatting, and any model you build around the incoming values.
Option fields available to a workbook
Use an explicit option symbol
XLNative option symbols identify the underlying, right, strike, and expiration. A call can use a value such as AAPL:call:205:20260821. Change the field argument to place related values in separate workbook columns.
=XN.MARKET("AAPL:call:205:20260821","bid")=XN.MARKET("AAPL:call:205:20260821","ask")=XN.MARKET("AAPL:call:205:20260821","modeliv")=XN.MARKET("AAPL:call:205:20260821","delta")=XN.MARKET("AAPL:call:205:20260821","theta")Requirements and data permissions
- An M-series Mac and the Microsoft Excel for Mac desktop app
- TWS or IB Gateway running locally with API access enabled
- The relevant IBKR market-data permissions for the option and underlying
- A valid option contract description and expiration
XLNative does not sell exchange data. It uses the market data available through your signed-in local IBKR session. A missing permission or unavailable model field can affect what IBKR returns.
Start with a small option view
Begin with one known contract and a few fields—bid, ask, model IV, and delta. Once those values update correctly, copy the formula pattern into the workbook layout you need.