Excel
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
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
Conditional Formatting in Excel using CQG's RTD Bate Function
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
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
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
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