Thom Hartle

Spread Bars

Feb 03, 2016

Request:

I want to chart the DDH6-EPH6*5 spread using a Heikin-Ashi chart. On a bar chart, I just see a closing line chart and it will not work in a Heikin-Ashi chart.

Solution:

Use the Spread function:

Spread(DDH6-EPH6... more

Check Out CQG IC's Calendar of Events

Jun 10, 2014

Have you used CQG's new Calendar of Events? The Calendar of Events allows you to track economic releases with a concise calendar. It provides details for key global macroeconomic indicators, regional economic indicators, and events. An event is a... more

Updating Your Microsoft Excel Dashboards in CQG with Microsoft Office 2013

Jan 27, 2014

If you use Windows® 7 and have upgraded to Office 2013, you may have noticed that price updates in your CQG-powered Excel dashboards now look like little slot machine quotes with prices rolling instead of just updating. The reason is that... more

Introduction to Market Profile Charts and Studies

Jan 17, 2014

CQG's roots are in the world of market action data. The premise was that traders needed clear and informative market charts on various time frames and would use studies in conjunction with the charts in order to make trading decisions. When... more

How Frequency Distribution Analysis Can Improve Your Decisions

Mar 05, 2013

Frequency distribution is simply how often a value appears within a group of values. For example, a group of values is a range from 1 to 5. The collection of numbers is 1, 3, 1, 2, 3, 4, 1, and 4. In this series, we see that the integer 1 occurs... more

Getting Started Using CQG, RTD, and Excel®

Mar 02, 2012

CQG supports the Microsoft Excel RealTimeData (RTD) function in CQG Integrated Client version 8.4 and greater for delivering market data and other information to Excel. Through the combination of CQG and Excel, you can create highly-customized... more

Design Your Spreadsheets to Look Like Your Trader Screens

Jul 11, 2011

Today, designing Microsoft Excel® spreadsheets can be more than just creating tables with a lot of numbers. As shown here in my columns, you can use conditional formatting such as heat mapping, data bars, and other Excel features to... more

Tricks to Building Excel Spreadsheets from CQG

Jun 30, 2011

When designing Excel® spreadsheets like the example below, there are a few shortcuts you can use to make the process easier. Here, we will use the CQG Symbol Search and Quote SpreadSheet to add RealTimeData (RTD) formulas for displaying market... more

Better Visualize Your Data in Microsoft Excel

Jun 08, 2011

RTD allows you to build elaborate quote displays that go beyond straight market quotes such as spread quotes between two markets. However, with more distant delivery months, there may be instances where one market is being quoted, but another... more

Merging Market Data with Text in Excel

May 27, 2011

When designing spreadsheets to visualize the markets, it is tempting to title rows and columns, but then you have to scan top to bottom and left to right to identify exactly what you are viewing. This isn't a problem when the quote display is... more