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.


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.


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.


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.


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.


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.


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.