Page Comparison

Template	Description	File Download	Other	Preview
Futures Market Dashboard	Here it is. Our simple, but extremely popular template, to keep an eye on futures markets. Just select the product of your choice and the most active contracts will start streaming right into your dashboard. View multiple products at a time and get a view of the current forward curve - which streams updates directly into the chart. I’d tell you more about it, but it’s really that simple.	View file name cmdtyView Excel - Futures Dashboard.xlsx	Commodities Covered Ag Energy Metals Data Products Used Futures Prices
Basis Forecast vs. Forward Curve	Our basis forecasts simplify how you price bids and market grain more effectively with 9,000+ localized basis forecasts that outperform your current forward curve Grain Merchandiser? Set your curve more easily with forecasts that combine historical seasonality and current spot pricing to generate a forward curve that more effectively predicts future spot basis. Grain Marketer? Improve your grain marketing strategies to grow your business and help your clients. Quickly identify mispriced basis opportunities and position your portfolios accordingly.	View file name cmdtyView Excel - Basis Forecast Comparison.xlsm	Commodities Covered Corn Soybeans
Cash Forward and Basis Seasonality Monitor	Users of this workbook are able to perform powerful analysis of historical basis trends for any relevant growing area within the United States. We provide users with a pre-built template to chart current cash forward prices against historical averages to identify areas where grain is relative “lean” or “rich” in terms of basis pricing. Users can view year-by-year seasonality for the grain buying region of their choice and understand where the current year is tracking relative to historical patterns. Additionally, users can create forward models for the current year based on user-defined projections using historical basis patterns. Advanced users can create a custom historical average window to exclude “abnormal” growing conditions in years past. For the most ambitious users, the integration of yield forecast information and historical production data from cmdty Statistics is possible.	View file name cmdtyView Excel - Cash Forward and Seasonality.xlsm	Commodities Covered Corn Soybeans Wheat Data Products Used cmdty Grain Basis Indexes cmdty Grain Price Indexes Futures Prices		US Crop Production Forecast Model	This worksheet provides users with a platform to build their own production forecasts at the state and national level. Historical USDA data (2016-2018) on acres planted, acres harvested, yield, and production is available in the worksheet and provides the user with a simple way to build their own estimates for harvested acres based on 2019 USDA estimates. Using historical and USDA forecasted acreage data, we provide the users with a framework for to create their own harvest estimates. Combined with the cmdty Yield Forecast Indexes users can build a bottom-up or top-down view of national grain production (across Soybeans and Corn) and compare this with USDA estimates. Advanced users may also incorporate county-level information or pull in the cmdty Grain Price Index forward curve to identify opportunities for hedging or speculation.

Commodities Covered

• Corn

• Soybeans

Data Products Used

• cmdty Yield Forecast Indexes

• cmdtyStats

Image Removed

Tools for Ag Media (Basis Analysis)

Writing about what’s going on in agriculture isn’t easy. We’re here to make it easier. We provide users with simple access to real-time basis values at the State, Region, and National level for corn and soybeans. Not only that, we’ve gone to the trouble of calculating historical averages, so understanding where current basis sits relative to seasonality patterns is as simple as opening-up the workbook. Here are examples of insights that our tool generates automatically for users:

• The cmdty National Corn Basis Index has increased by 2.58c in the past month, and is 15.38c higher than it was one year ago.

• Premiums between the Eastern and Western regions are decreasing slightly (-1c) and are up to 21.7c from a year ago (17.5c)

• Based on historical seasonality trends we typically see basis weaken by about 14% heading into next month

Commodities Covered

• Corn

• Soybeans

Data Products Used

• cmdty Grain Basis Indexes

US Crude Oil Pipeline Dashboard

This workbook provides energy professionals with a sophisticated dashboard allowing them to get an instant overview of all relevant varieties of North American cash crude oil that are posted by major pipeline operators.

The most simple use case involves filtering the over 200 types of crude oil by variety, company and/or state to get your morning started. More sophisticated use cases include utilizing our basis calculations to understand where divergence in price action is taking place. Combined with our cmdty Retail Fuel Price Indexes, users can quickly identify where potential strength or weakness is likely to occur in retail ULSD markets and position their books for mean reversion.

Users can use themes from this template to perform deep dives on historical correlations to develop new and novel trading strategies.

Dashboard

Commodities Covered

-

Data Products Used

• cmdty Cash Crude Oil Prices

• cmdty Retail Fuel Price Indexes

• Global Futures Prices

Image Removed

US Retail Fuel Price Dashboard - Travel Centers

This workbook provides users with an in-depth overview of the US Retail Fuel Market with a focus on Travel Center pricing. We aggregate prices from all of the major travel centers throughout the United States, and provide users with county, CRD, state, PADD, and national averages for gasoline, ULSD, and DEF.

Quickly understand trends in fuel prices throughout the country and identify where pricing outliers exist. This worksheet offers retailers, travel center operators, energy traders and investors detailed comparisons of price indexes.

Advanced users may combine our index-level data with location specific pricing to create models to price their own location in real-time.

Commodities Covered

• Retail Gasoline - Reg, Mid, Prem

• Ultra-low Sulfur Diesel

• DEF

Data Products Used

• cmdty Retail Fuel Price Indexes

Scrap Yard Pricing Dashboard

Probably the most practical template that we’ve ever built, this workbook provides an interactive dashboard for scrapyards throughout the United States to provide live pricing out to their scrapper network that update with every futures tick.

Create your own custom metal compositions using streaming prices from COMEX, LME, and Shanghai and watch how our sophisticated template provides you with instantly updated blended futures values that account for composition ratios, the underlying currency, and your preferred unit of account. Users can get started instantly with 36 of the most popular products already configured.

Advanced users may create customized bid/offer spreads to lock in their desired profit on every scrap transaction. Share the workbook with all of your decision makers and ensure that everyone is providing the same pricing out to your network.

Commodities Covered

• Scrap Metals

• Metal Futures

• Forex

Data Products Used

• cmdty Scrap Yard Price Indexes

• Futures Prices

Image Removed

Options Theoretical Calculator

Calculate an option’s theoretical price, delta, gamma, vega, theta and rho using the options theoretical calculator template. Once input parameters are set, plot any of the values against an underlying price and time to maturity.

Commodities Covered

• Ag

• Energy

• Metals

Data Products Used

• Futures Prices

Options Strategy Builder

Input underlying price, lot sizes, strikes and position to view the strategy’s cost, max profit and loss, risk reward ratio, net delta, break even levels and % change to the BE prices. Click on the refresh price to pull in the latest available price.

Commodities Covered

• Ag

• Energy

• Metals

Data Products Used

• Futures Prices

Barchart US Corn Yield Forecast

Daily US, State, and County corn yield predictions from Barchart’s enhanced forecast model, now powered by Planet's advanced satellite data.

Commodities Covered

• Corn

Data Products Used

• Yield Forecasts

WASDE - Corn Balance Sheet

USDA WASDE Report data for US Corn. Supply & Demand balance sheet along with an evolution of revisions.

Commodities Covered

• Corn

Data Products Used

• USDA Data

• Futures Prices

WASDE - Soybean Balance Sheet

USDA WASDE Report data for US Soybeans. Supply & Demand balance sheet along with an evolution of revisions.

Commodities Covered

• Soybeans

Data Products Used

• USDA Data

• Futures Prices

WASDE - Wheat Balance Sheet

USDA WASDE Report data for US Wheat. Supply & Demand balance sheet along with an evolution of revisions.

Commodities Covered

• Wheat

Data Products Used

• USDA Data

• Futures Prices

USDA Crop Conditions

USDA National and State corn conditions

Commodities Covered

• Corn

Data Products Used

• USDA Data