New Excel Add-In for Commodities Streams Market Data Directly Into Spreadsheets
Barchart has released an Excel add-in for commodities that brings live futures, cash grain, and energy pricing directly into spreadsheet workflows. The tool is designed for analysts, traders, and procurement teams who rely on Excel as their primary analysis environment but have historically had to copy and paste data from web portals or manually update static files.
The add-in connects to Barchart's data infrastructure, which aggregates price feeds from exchanges such as the CME, ICE, and NYMEX alongside cash market assessments from USDA and private sources. Users can pull settlement prices, bid-ask spreads, and historical series without leaving the spreadsheet. The integration is built on a lightweight connector that authenticates against the same credentials used for Barchart's web-based platform, so no separate login is required.
How the Tool Works
Once installed, the Excel add-in for commodities appears as a new ribbon tab. From there a user can select a commodity class - grains, oilseeds, livestock, energy, or metals - and then choose specific contracts or cash market regions. The data returns as a range of cells that can be used in formulas, pivot tables, or charts. Refresh intervals are configurable, with options ranging from real-time streaming to hourly snapshots, depending on the user's subscription tier.
Barchart has built the add-in to work with Excel on Windows and macOS, covering Office 365 and Office 2019 onward. The underlying data feed uses the same API endpoints that power the company's professional desktop and mobile applications. This means the numbers that appear in the spreadsheet are the same ones that feed Barchart's own analytical dashboards and alerting systems.
Why It Matters for Commodity Professionals
Commodity price data is notoriously fragmented. Cash grain bids change by the minute during trading hours. Natural gas basis differentials shift with storage reports. Metals premiums move on supply news. Professionals who need to track these numbers across multiple markets often end up maintaining spreadsheets that are out of date before they are finished. The Excel add-in for commodities addresses that gap by treating the spreadsheet as a live window into the market rather than a static snapshot.
For a grain merchandiser, that could mean seeing the current corn bid at the local elevator update automatically beside a forward contract price without switching screens. For a refinery margin analyst, it could mean pulling prompt-month crude oil futures into a crack spread model that recalculates every time the market moves. The tool is deliberately unopinionated about what the user does with the data - it simply provides a reliable, low-latency pipe from Barchart's databases into the cells the user chooses.
Target Audience and Use Cases
The add-in is aimed at three broad groups. The first is agricultural producers and their advisors who use Excel to track basis, carry in, and hedge ratios. The second is energy traders who need prompt-month and forward-month settlement prices for crude, gasoline, and natural gas. The third is metals and financial analysts who monitor futures spreads and rolling averages for copper, gold, or steel. In each case the common requirement is the same: get the latest market data into a spreadsheet without manual data entry.
Barchart has also designed the tool to work with its existing data sets for weather, crop progress, and export inspections. A user can, for example, build a worksheet that combines weekly export sales data from USDA with corresponding futures settlement prices, both refreshed automatically. This kind of composite analysis was previously possible only by stitching together multiple data exports or by using a custom API integration.
Installation and System Requirements
Installation is handled through a standard Office add-in package distributed via Barchart's customer portal. The installer checks for the required Excel version and, on Windows, registers the add-in with the Office Trust Center. On macOS, it uses the built-in add-in manager. No additional runtime or database client is needed because the connector communicates with Barchart's servers over HTTPS. Data is never stored locally between sessions unless the user explicitly saves the workbook.
Barchart has stated that the add-in is available immediately to existing data subscribers at no additional cost, and that it will be bundled with new subscriptions for the company's commodity data packages. A free trial version is also offered, limited to delayed data with a fifteen-minute lag, so prospective users can evaluate the workflow fit before committing.
Competitive Landscape
Several other financial data providers have offered Excel plug-ins for equities and fixed income, but few have addressed the commodity segment with the same breadth of coverage. The challenge in commodities is the sheer variety of contracts, cash market regions, and quality differentials. Wheat is not a single price; it is a matrix of classes, protein levels, and delivery locations. Natural gas is priced at dozens of hubs. Barchart's data set covers these nuances, and the add-in carries them through to the spreadsheet rather than collapsing everything into a generic futures price.
That specificity is what distinguishes this tool from a generic API wrapper. The add-in understands that a soybean bid from a specific elevator in central Illinois is not the same as the CBOT soybean futures settlement. It retrieves the exact series that the user has access to on Barchart's platform, including any custom price series the user has created. The spreadsheet sees a number, but the number is the result of a query that respects the user's data entitlements and market definitions.
Future Direction
Barchart has indicated that the add-in will receive regular updates to support new contract months as exchanges list them and to accommodate any changes to the underlying API endpoints. The company is also exploring the addition of a scheduling feature that would allow users to trigger automatic refreshes at specific times of day, such as after the release of a USDA report or after the close of a trading session. Those enhancements are not yet available but are on the product roadmap.
For now the focus is on stability and compatibility. The initial release has been tested against the major regional cash grain networks and the energy futures contracts that see the highest trading volumes. Barchart's support team has published a knowledge base article covering the most common installation questions, and the add-in itself includes a diagnostic panel that reports connectivity status and last refresh time.
About Barchart: A financial and commodity market data provider offering market data, analytics, and workflow solutions for businesses in agriculture, energy, metals, and financial services.