Workspaces

Thom Hartle
Apr 26, 2021
Updated: Apr 26, 2021

Microsoft® Excel offers the Radar Chart. This chart does not use the typical X-axis versus Y-axis. Instead, the radar chart is a graphic display of multivariate data in the form of a two-dimensional chart.

Viewing the radar chart shows... more

Thom Hartle
Feb 05, 2021
Updated: Apr 12, 2021

The CQG RTD Toolkit Add-in has been updated. This updated Excel add-in is automatically installed with CQG IC 21-12-8042 Beta and higher. The updates are to the Orders and Positions tabs. New features and benefits include the ability to pull in... more

Thom Hartle
Apr 09, 2021
Updated: Apr 09, 2021

Sparklines have been available beginning with Microsoft® Excel 2010. A Sparkline is a simple chart that is displayed within a cell or a group of merged cells. Sparklines are a nice addition to a quote display as the quote display shows current... more

Thom Hartle
Jul 27, 2017
Updated: Apr 09, 2021

This Microsoft Excel® spreadsheet tracks the constituents of the DJIA Index (symbol: DJIA).

Throughout the trading session, the thirty individual stocks are dynamically ranked and displayed in the histogram bar chart with their respective... more

Thom Hartle
Mar 22, 2021
Updated: Mar 31, 2021

This Microsoft® Excel dashboard presents a range of market data using CME Forex Symbols. However, you can enter in your own symbols.

Always use upper case for symbols. Enter into the Symbol Box the symbol.

The top row is the... more

Thom Hartle
Mar 09, 2021
Updated: Mar 09, 2021

Traders and investors have a multitude of opportunities for theme investing. That is, ETFs are structured to invest in companies that are part of an industry, such as Biotech, Internet, Aerospace, etc. One such example is the SPDR® S&P Kensho... more

Anthony Cohen
Mar 04, 2021
Updated: Mar 04, 2021

The BarInt function can be useful when creating Custom Studies or Conditions which can be applied to different timeframe but where a point of reference may be different whether you are looking at an intraday chart or a Historical chart (Daily... more

Anthony Cohen
Mar 04, 2021
Updated: Mar 04, 2021

One of the simplest examples for this function is to find out whether a value is an even number.

Modulus (Close(@),2) = 0

In other words, the result of the formula above would give us the remainder of the operation Closing Price/2. If the... more

Thom Hartle
Nov 23, 2020
Updated: Feb 10, 2021

This post expands on the use of Microsoft® Excel function “CountIF.” The CountIF functions was detailed in the post “Dynamic Ranking in Excel” as a method for dealing with ties when ranking various markets’ performance based on percentage net... more

Thom Hartle
Jan 19, 2021
Updated: Jan 19, 2021

Perhaps you are pulling market data into Microsoft Excel using RTD functions from CQG and you would like to chart the data in Excel. When you setup the chart you would likely use “Auto” for the high and low values for scaling the vertical axis.... more