The Excel AGGREGATE function returns an aggregate calculation such as AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, etc., applied to a list of data while optionally ignoring hidden rows and errors. Nineteen operations are available. The choice is... more
Monitoring market data in Excel may be enhanced by including Forward Curve charts. However, there are issues with Excel charting and the purpose of this post is to offer solutions using Excel functions.
The UDS functionality in CQG Version 2022 has been significantly updated with many more strategies, as well as the available strategies are now grouped by exchanges. This post introduces UDS functionality and includes a walkthrough by CQG Product... more
When designing Excel quote dashboards there should be a commitment to have it be a clean looking dashboard. However, sometimes an RTD call for market data can generate an error in Excel. For example, this is the RTD call for percent net change.... more