Blogs

TFlow and DOMTracker, Part 1: Their Uses in Spread Trading

Shaun Downey
Jul 01, 2011

Here, I am going to go through some specific techniques for using TFlow® in spread trading. Certain spreads, such as Heating Oil against Crude, lend themselves to sustained trends. TFlow, in combination with the DOMTracker, can be used to... more

Tricks to Building Excel Spreadsheets from CQG

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

Opinion: Illiquidity and the Danger It Fosters for World Equity Markets©, Part 2 by Joe DiNapoli

Jun 27, 2011

Today, we can look eastward to the China Stock Index futures contract and see the similarities between its size and the size of the S&P contract back in 1986, except in China, the situation is worse. In a sincere effort to protect its... more

Opinion: Illiquidity and the Danger It Fosters for World Equity Markets©, Part 1 by Joe DiNapoli

Jun 20, 2011

I trade daily. I traded Over-The-Counter options in the '60s. I have traded US Stock Index futures since the day they started in 1982. I was there in October 1987 when we experienced the 500-point single day decline known as Black Monday. In fact... more

Better Visualize Your Data in Microsoft Excel

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

Interview with Denise K. Shull on Market Mind Games Part 2

Jun 08, 2011

This is the second of a two-part interview (listen to part 1) 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

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