Excel Templates
- Keith Petersen (Unlicensed)
- Will Osnato
- Brendan Hebert
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 |
|---|---|---|---|---|
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
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
| 
|
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
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:
| 
| Commodities Covered
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
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
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
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. | 
| Commodities Covered
Data Products Used
|
|
WASDE - Corn Balance Sheet | USDA WASDE Report data for US Corn. Supply & Demand balance sheet along with an evolution of revisions. | 
| Commodities Covered
Data Products Used
|
|
WASDE - Soybean Balance Sheet | USDA WASDE Report data for US Soybeans. Supply & Demand balance sheet along with an evolution of revisions. | 
| Commodities Covered
Data Products Used
|
|
WASDE - Wheat Balance Sheet | USDA WASDE Report data for US Wheat. Supply & Demand balance sheet along with an evolution of revisions. | 
| Commodities Covered
Data Products Used
|
|
USDA Crop Conditions | USDA National and State corn conditions | 
| Commodities Covered
Data Products Used
|
|
Wheat VSR Calculator | Wheat Variable Storage Rate (VSR) Calculator
| 
| Commodities Covered
|  |
