Natural Gas Market, Spreads, and Strips Dashboard

This Microsoft Excel® dashboard has three tabs. The first tab displays today’s market quotes, volume, and open interest data. If the last price is matching the open price, then the open price is highlighted blue. If the last price is within one tick or equal to the high, then the high is colored green. If the last price is within one tick or equal to the low, then the low is colored red.

The second tab displays 1- through 6-month calendar spreads. The dashboard offers the ability to enter a date to compare where the same calendar spreads were trading. You can enter in a date up to 300 days back.

The final tab displays winter and summer strips for the next two years. You can also enter in a date and see where the same strip was trading up to 300 days ago. All contracts on all three tabs automatically roll.

The forward curve charts, both calendars and strips, use the mid-point between the best bid and ask if there is no posted trade.

Requires CQG Integrated Client or CQG QTrader, 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.