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… more
Blogs
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… more
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… more
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… more
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… more
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.… more
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… more
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… more
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… more
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… more