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