Microsoft Excel 2016 introduced the IFS function. This function can replace using nested IF functions. Below is an example of nested IF functions:
=IF(N2=0,"#",IF(N2=1,"#.0",IF(N2=2,"#.00",IF(N2=3,"#.000",IF(N2=4,"#.0000",IF(N2=5,"#.00000",IF(N2=6,"#.000000",IF(N2=7,"#.0000000"))))))))The… more
Excel 365 includes the SORT and SORTBY functions which provide users with a simple way to dynamically sort data on a real-time basis. A common use would be to dynamically sort market performance by percentage net change using RTD calls to highlight the leaders and laggards in a group of markets… more
A post titled "Excel Indirect Function and More" was published on February 22, 2022, that detailed using Excel's INDIRECT function, as well as details to automatically format cells for displaying price quotes with the correct number of decimal places.
In this post the use of the INDIRECT… more
Microsoft® Excel 365 includes a Text function that makes pulling text out of a string much easier than before Excel 365 was released. To illustrate, we will review the steps before Excel 365 was released.
Excel's Right function will trim a text string from the right. For example, the RTD… more
If you use Microsoft® Excel as part of your workflow with CQG IC or QTrader then you may or may not be using Excel keyboard shortcuts. This post details using keyboard shortcuts in Excel 365 to make your workflow more efficient.
Two popular keyboard shortcuts are Ctrl + C to copy contents… more
The Net Change Curve chart displays a collection of symbols’ daily net price change or daily net percentage change making it easy to compare on a relative basis each market’s current session’s performance. In addition, you can choose to set the net change curve chart to the current time and see… more
In this post, the aspects of becoming a good rule-based trader are discussed. But first, an illustrative story...
While attending college I worked in warehouses on Seattle's waterfront and was a member of the Teamsters Union, local 741. A fellow Teamster was an avid steelhead… more
CQG One provides an "Active RFQ" widget. A Request for Quote (RFQ) is functionality provided for traders to access electronic quotes on multi-leg options strategies. It is an electronic message that is sent by the exchange to all market participants that are expressing interest in a strategy or… more
This post details the use of the CQG function: Time Average (TimeAvg), which calculates the average for values taken at the same time of day over the lookback period.
In this example, the average values calculated is the average “traded volume” using the same bar by session time over the… more
CQG IC and QTrader offer charts that utilize volume for the horizontal scale, not time. The first chart type to discuss is Constant Volume Bars.
Constant Volume Bar (CVB)
The Constant Volume Bar chart uses a customer selected parameter of traded volume (either exchange volume or tick… more