Interactive Brokers Option Greeks Excel Formulas

Excel spreadsheet
Ready to use spreadsheet: Click the button below to download the Interactive Brokers Options Greeks Excel Formulas example spreadsheet and save it to your PC, then open it in Excel.

This spreadsheet demonstrates many of the option Greeks fields available using the Interactive Brokers Options & Greeks formulas.

To use it, simply change the ticker, expiry date and strikes. Don't forget to connect to Interactive Brokers to start streaming.

For a broader overview of streaming Interactive Brokers holdings, market data and Greeks into Excel, see the Interactive Brokers Holdings & Market Data use case.

Interactive Brokers Excel Options & Greeks formulas example Excel spreadsheet