Workspaces

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
Aug 17, 2015
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays volume and open interest data for soybeans, soybean meal, and soybean oil contracts for tracking the rolls. All of the active deliveries for each individual symbol are displayed in a single dashboard... more

Thom Hartle
Aug 24, 2015
Updated: Sep 14, 2018

This spreadsheet shows you the RTD formulas for pulling historical data into Microsoft Excel® by using dates and time. The sample spreadsheet pulls the closing price and the value of the RSI study by a date and by a time during the day. Subminute... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for CME Globex-traded soybeans, corn, and wheat.

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
Jan 20, 2016
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays market data for Soybean Crush Spreads traded on the CME Globex platform. These spreads have an added layer of complexity due to the soybean contract not always having the same expiration month as the... more

Thom Hartle
Jan 10, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays key market information for contracts traded on the CME Exchange and the Globex platform. The markets are grouped by these products:

Equity Indices Fixed Income Metals Energy Agriculture​ Forex

Two... more

Thom Hartle
Mar 21, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays market data for grain spreads traded on the Globex platform using a matrix-style format. The outrights are along the top row and the start of each row. The best bid and best ask are also included. If the... more

Thom Hartle
Apr 07, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the options on soybeans, wheat, and corn (Globex) futures markets for volume. It displays strikes ranked by the volume traded for each expiry listed. The scan covers options traded ten strikes above... more