We recently released cmdtyView Excel, a new solution for streaming market data in Excel alongside physical commodities pricing, and global fundamental data. cmdtyView Excel makes it easy to power bespoke research and analysis from any desktop. In our latest webinar, our Head of Strategy, Keith Petersen, gave a detailed look into cmdtyView Excel and explained how it can be used to make better business decisions. Here’s an overview of what he covered…
What is cmdtyView Excel?
cmdtyView Excel is the most powerful tool for analysis and commodity workflows. With futures prices, physical data, and fundamentals at your fingertips cmtyView excel really is whatever you need it to be. With cmdtyView Excel you can create a custom dashboard that’s built specifically for your workflow. Whether you need to build ad-hoc analysis or models you can run repeatedly, this add-in solution provides you with the tools you need for deep analysis and insight.
What’s inside cmdtyView Excel?
What happens when you put all this data together? You get the most powerful tool for analysis and commodity workflows!
Who should use cmdtyView Excel?
How to get started / Pre-built Templates
Getting cmdtyView Excel up and running is incredibly easy! After you download it from our website, and easily install the tool, you can immediately get started. It’s super user-friendly - you can pull quote data, historical data and build formulas without any prior experience with excel add-ins. For more advanced use cases, we built templates to help users to get started. These are designed to help people with very specific workflows. Take a look at a few of them below!
#1: Cash Forward and Basis Seasonality Monitor
With this template, you can calculate the historical basis for any relevant growing area within the United States for any given month going back to 2016. This allows you to chart current cash forward prices against historical averages to see where grain is rich in terms of basis pricing. Users can view year-by-year seasonality for their grain buying region and create forward models for the current year based on their own projections. Additionally, our yield forecasts can be used to predict USDA estimates and identify where supply is going to be.
#2: U.S. Crop Production Model
This template will allow users to use USDA data and our Yield Estimates to build production forecasts at the state and national levels. The final numbers from USDA recently came out and our soybean estimate was spot on with their number. Users can also incorporate county-level information or pull in the cmdty Grain Price Index forward curve to identify opportunities for hedging or speculation.
#3: U.S. Crude Oil Pipeline Dashboard
This template provides an instant overview of all relevant varieties of North America cash crude oil prices that are posted by major pipeline operators. When combined with our cmdty Retail Fuel Price Indexes users can identify where strength or weakness is likely to occur in retail ULSD markets.
#4: Scrap Yard Pricing Dashboard
This dashboard enables scrapyards to give live scrap prices out to their scrapper network - updates come with every futures tick. Users can create custom metal compositions by using streaming prices from COMEX, LME, and Shanghai. This template also allows users to use historical basis information to provide pricing offsets based on the price of scrap in a specific area.
You can take a look and download all of our templates here.
To learn more or to subscribe for a free trial of cmdtyView Excel, click here.