Energize your spreadsheets with streaming real-time and historical market data using MarketView ExcelTools. Perform complex analysis, generate curves, and build models upon dynamically updating datasets. Seamlessly integrate the MarketView Desktop with drag and drop functionality.

Users of MarketView Desktop will be instantly familiar with the steps needed for accessing and embedding real-time and historical data into their spreadsheets using ExcelTools. Intimately tied to the Desktop, ExcelTools allows users to manipulate and analyze dynamic datasets accessed right from the spreadsheet or dropped in directly from Desktop.

Icon 1 - page Options Analytics
default greyed background
Icon 1 - page Options Analytics

Options Analytics

Take options analytics to the next level in MarketView ExcelTools. Choose from the Black, Black-Scholes, Binomial, Whaley, or Garman-Kohlhagen models and configure with user preferences. Watch a single strike or a range of options for an underlying futures contract, including theoretical value, in real-time, or user-defined volatility. Greeks include delta, gamma, theta, vega, and rho.

Icon 2 - page Real-Time Quotes
default greyed background
Icon 2 - page Real-Time Quotes

Real-Time Quotes

Track your positions in real-time for the energy or agricultural markets key to your business. Or, watch the market’s term structure while trading. The MarketView ExcelTools real-time quotes interface keeps you up-to-date and is a time-saver for end-of-day reporting.

Icon 3 - page Historical Commodity Data
default greyed background
Icon 3 - page Historical Commodity Data

Historical Commodity Data

Embed deep historical commodity data into your spreadsheets with automated data filling methods, units, and currency conversion. It’s also an option to create price charts. Historical data is available on an intraday, daily, weekly, monthly, and seasonal basis.

Icon 4 - page Commodity Charting Software
default greyed background
Icon 4 - page Commodity Charting Software

Commodity Charting Software

Automatically format historical commodity data in an Excel table into a chart with the commodity charting software in MarketView ExcelTools. Choose from intraday, daily, weekly, monthly, or seasonal data. And, select a variety of chart types such as bar, candlestick, or volume.

Icon 5 - page Strip and Spread Matrix
default greyed background
Icon 5 - page Strip and Spread Matrix

Strip and Spread Matrix

Quickly view a spread between any two contracts in a futures chain using the built-in Spread Matrix. The Strip Matrix will automatically string together a range of contracts for simple view of any strip price.

Icon 6 - page Real-Time Proprietary Data Sharing
default greyed background
Icon 6 - page Real-Time Proprietary Data Sharing

Real-Time Proprietary Data Sharing

Harness the power of real-time proprietary data sharing with colleagues and customers via cloud-based MarketView Xchange that uses an easy-to-use Excel interface. Eliminate manual updating and emailing of spreadsheets to distribution groups and save spreadsheets and data to a specific location for others to access.