Excel Templates

Description

This page contains downloadable templates that users of cmdtyView for Excel can use to create stunning visualizations that leverage all of the data in our ecosystem. We are continuously adding to this repository, so please check for updates.

Templates

Template

Description

File Download

Other

Preview

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.

 

 

Commodities Covered

  • Ag

  • Energy

  • Metals

Data Products Used

 

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.

 

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.

 

Commodities Covered

  • Corn

  • Soybeans

  • Wheat

Data Products Used

 

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

 

 

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

 

 

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.

 

Commodities Covered

  • Crude Oil

  • Ultra-low Sulfur Diesel

Data Products Used

 

 

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

 

 

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

 

 

 

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

 

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