Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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. (smile)

View file
namecmdtyView Excel - Futures Dashboard.xlsx

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.

View file
namecmdtyView 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
namecmdtyView Excel - Cash Forward and Seasonality.xlsm

Commodities Covered

  • Corn

  • Soybeans

  • Wheat

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

View file
namecmdtyView Excel - Tools for Ag Media (Basis Analysis).xlsx

Commodities Covered

  • Corn

  • Soybeans

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.

View file
namecmdtyView Excel - US Retail Fuel Prices.xlsx

Commodities Covered

  • Retail Gasoline - Reg, Mid, Prem

  • Ultra-low Sulfur Diesel

  • DEF

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.

View file
namecmdtyViewOptionsTheoreticalCalculator .xlsm

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.

View file
nameOptions Strategy Builder cmdtyView complete.xlsm

Commodities Covered

  • Ag

  • Energy

  • Metals

Data Products Used

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.

View file
nameUS Corn Yield Forecast Data.xlsx

Commodities Covered

  • Corn

Data Products Used

  • Yield Forecasts

image-20240913-194344.png

WASDE - Corn Balance Sheet

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

View file
nameWASDE Corn Balance Sheet.xlsx

Commodities Covered

  • Corn

Data Products Used

  • USDA Data

  • Futures Prices

image-20240904-181937.png

WASDE - Soybean Balance Sheet

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

View file
nameWASDE Soybean Balance Sheet.xlsx

Commodities Covered

  • Soybeans

Data Products Used

  • USDA Data

  • Futures Prices

image-20240904-182154.png

WASDE - Wheat Balance Sheet

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

View file
nameWASDE Wheat Balance Sheet.xlsx

Commodities Covered

  • Wheat

Data Products Used

  • USDA Data

  • Futures Prices

image-20240904-182337.png

USDA Crop Conditions

USDA National and State corn conditions

View file
nameUS Corn Crop Conditions.xlsx

Commodities Covered

  • Corn

Data Products Used

  • USDA Data

image-20240904-185220.png

Wheat VSR Calculator

Wheat Variable Storage Rate (VSR) Calculator

  • Fully automated - just click refresh all to update with the latest prices

  • Pre-made worksheets for each spread in 2025

  • Key dates are pre-set

  • CME holidays accounted for

View file
nameBarchart Wheat VSR Calulator 2025.xlsx

Commodities Covered

  • Wheat

Image Added