Merging Market Data with Text in Excel

Thom Hartle
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

Interview with Denise K. Shull on Trading Psychology

May 27, 2011

This is the first of a two-part interview (listen to part 2) with Denise K. Shull, CEO of The ReThink Group, which is the parent company of TraderPsyches. Denise is a thought-leader in the psychology of risk, uncertainty, and exceptional... more

Conditional Formatting in Excel using CQG's RTD Bate Function

Thom Hartle
May 23, 2011

One valuable feature in Excel® is conditional formatting. There is a wide array of rules available in the Conditional Formatting group after you select the Home tab in Excel. Here, we will use a simple color the cell condition if the last quote... more

Formatting Price Data using RTD and Excel

Thom Hartle
May 05, 2011

When writing formulas for calling market prices into Microsoft Excel® using RTD, you can choose between four different formats for the values returned. Here, I will review those formats and offer a custom view of fixed income market data that... more

Adjusting the RTD Interval Throttle in Microsoft Excel

Thom Hartle
Apr 28, 2011

CQG Integrated Client version 8.4 supports RealTimeData for sending data and other market information to Microsoft Excel®. This feature opens up many opportunities for creating custom displays and other ways to better manage your workflow. One... more

CQG Displays and Microsoft Excel

Thom Hartle
Mar 17, 2011

I recently received a question regarding one of my images illustrating how I use Microsoft Excel® with CQG. In the image below, there is an Excel spreadsheet detailing current market activity along with CQG News and a CQG chart. It appears that... more

Heat Maps in Microsoft Excel

Thom Hartle
Mar 03, 2011

Today's traders and analysts simultaneously track many different markets within the same or different asset classes, looking for markets that may be at extreme price levels relative to other markets. Those markets that are at extremes may be... more