Crude Oil Options Excel Dashboard

This Microsoft Excel® dashboard displays the current crude oil options market ranked by the time of the last trade. It has two columns for two different expiry months. There are two tabs where you enter in the delivery month and the start and end range of strike prices. If you see a trade for today with no traded contract volume, it is because the trade is part of a spread.

Make sure to lower your Excel RealTimeData (RTD) throttle to 50 milliseconds. Learn how to do that here.

Requirements: CQG Integrated Client, data enablements for all symbols displayed in this spreadsheet, and Excel 2010 or more recent.

Downloads

Disclaimer

Trading and investment carry a high level of risk, and CQG, Inc. does not make any recommendations for buying or selling any financial instruments. We offer educational information on ways to use our sophisticated CQG trading tools, but it is up to our customers and other readers to make their own trading and investment decisions or to consult with a registered investment advisor. The opinions expressed here are solely those of the author and do not reflect the opinions of CQG, Inc. or its affiliates.