Workspaces

Thom Hartle
Sep 24, 2018
Updated: Nov 19, 2018

This Microsoft Excel® spreadsheet pulls in live cattle, feeder cattle, and lean hogs market data traded on CME Globex.

The forward curves display today's data. If the last price is outside of the best bid and best ask, then the mid... more

Thom Hartle
Aug 25, 2017
Updated: Nov 08, 2018

These two Microsoft Excel® dashboard display market quotes for tradable UDS for the crude oil contract and the E-mini S&P 500 traded on Globex. There is also a quote display with at-the-money (ATM) calls and puts with one strike... more

Thom Hartle
Jun 18, 2018
Updated: Nov 08, 2018

This Microsoft Excel® dashboard presents two charts of the Nasdaq-100 futures contract and market data for the one hundred stocks that are constituents of the Nasdaq 100 Index.

The chart in the top left corner displays... more

Thom Hartle
Oct 12, 2015
Updated: Oct 18, 2018

These Microsoft Excel® spreadsheets determine the at-the-money option and display a table of thirty strikes above and below the at-the-money. The tables consist of market data and the implied volatilities for each of the sixty-one strikes. The... more

Thom Hartle
Sep 25, 2017
Updated: Oct 01, 2018

CQG charts have a setting called the BATS Charts Preferences. Here, you select what data to use to build the chart. You can use the default setting where the chart is built using trade and settlement data. You can uncheck Use default ... more

Thom Hartle
Aug 03, 2016
Updated: Sep 25, 2018

This Microsoft Excel® dashboard offers a two-window view for tracking market performance (You have to enable macros when this dashboard is first opened.) The top half displays market data using whatever symbols (such as indices, stocks, and... more

Thom Hartle
Apr 23, 2012
Updated: Sep 14, 2018

CQG supports the Microsoft Excel® RealTimeData (RTD) function in CQG Integrated Client version 8.4 and greater for delivering market data and other information to Excel. Through the combination of CQG and Excel, you can create highly-customized... more

Thom Hartle
Sep 07, 2012
Updated: Sep 14, 2018

This spreadsheet outlines the basic syntax of RTD formulas and then details more complex formulas. Included is a collection of popular RTD formulas, which you can simply copy and paste into your own spreadsheet.

*Requires Microsoft... more

Thom Hartle
Sep 07, 2012
Updated: Sep 14, 2018

This spreadsheet provides a list of all available labels in market data in all types of contracts, including synthetic spreads. Orders and related statistics data include number of filled orders, open position, open trade equity, and... more

Thom Hartle
Nov 05, 2012
Updated: Sep 14, 2018

This spreadsheet provides a list of RTD formulas for historical bars and charting, requesting study data and study-related curves, calling a set of historical bars of all supported types, and requesting a set of historical study values created in... more