Workspaces

Excel 365 SEQUENCE Function

Jul 08, 2024

Excel 365 SQUENCE function populates a column or row with sequential integers, such as 1,2,3,4, etc.

The function has four parameters:

SEQUENCE(rows, [columns], [start], [step])

more

Excel 365 XMATCH Function

Jul 01, 2024

This post, which includes a downloadable Excel sample at the bottom of the post, describes how to use Excel's XMATCH function to search a large table. The table used consists of the constituents… more

CBOE Europe Derivatives

Jun 26, 2024
Introduction

Cboe Europe Derivatives (CEDX) is a European derivatives marketplace which enables participants to access equity derivatives markets for quotes and trade execution.

CEDX offers a… more

CQG Primer: Study Recalculation Setting and RTD Parameters

Jun 20, 2024

CQG IC and QTrader offer the ability to set recalculation rates for studies. In addition, RTD study formulas have a recalculation rate parameter.

In CQG select a chart and then Setup/Chart… more

Excel 365 LARGE and XLOOKUP Functions

Jun 17, 2024

Excel 365 offers the LARGE and XLOOKUP functions. This post details using both for tracking market performance.

The image below is a table from Excel where the data presented are percent net… more

Excel's Implicit Intersection Operator: =@CQGContractData("EP", "LastTrade",, "T")

Jun 10, 2024

The RTD function displayed in the title of the post includes the "@" sign. If you use the CQG RTD Toolkit installed on the Excel Ribbon when either CQG IC or QTrader are installed to pull in "… more

Excel Heat Mapping Using Check Boxes

Jun 06, 2024

Heat mapping is a data visualization technique that highlights market performance using colors. Typically, bright green for the top performers and bright red for the weakest performers and… more

Excel Quick Analysis Tool

Jun 03, 2024

This post introduces using Excel's Quick Analysis Tool. First, a walkthrough of a typical application of one of Excel's data visualization features (heatmapping). In the image below heatmapping… more

Sign Up for New Workspace Notifications

May 30, 2024

Sign up to receive a list of the most recent posts to Workspaces. Learn about new features in IC and QTrader, how to work with Excel and RTD formulas, downloadable sample Excel spreadsheets, and… more

FRED and CQG's XData

May 28, 2024

This post offers two topics: An introduction to the website FRED (Federal Reserve Economic Data) maintained by the Federal Reserve Bank of St. Louis and CQG's XData functionality, which is the… more