Monitoring Options Deltas in Excel

If you set up a Microsoft Excel® dashboard to monitor options prices and their respective deltas you may see the delta values disappear occasionally in the dashboard. In other words, the value for the options deltas, especially far out of the money options, will be temporarily blank. This has nothing to do with Excel. It is due to the settings used in your CQG Options Windows that are for the calculations. Two settings in the Options Preferences will insure the deltas are calculated and displayed continuously: Volatility and Price filter.

Open the Options Window, Right-click on the title bar and then select “Preferences.”

Click on the Volatility tab, select “Use Average Volatility” and select “RTD & Operator values.” Then click “Apply.”

Next, click on the Price Filter tab.

Select “Bid, Ask, Last Trade and Yesterday’s Close” for both Option price and Underlying price and select “RTD & Operator values.”  Last, click “Apply”.

This Excel sample will pull in the at-the-money (ATM) call and put option symbols, option symbols ten strikes above and below the ATM option and their respective deltas.

Download

Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries.