Marketview
Launch 6.7
MarketView® ExcelToolstm
MarketView ExcelTools delivers both real-time and historical energy and commodity market data into Excel spreadsheets allowing you to customize and categorize the data for your own unique analysis. This real-time interface gives you tick-by-tick access to all of your publication data as it happens, greatly reducing end-of-day reporting time over those vendors who only provide historical data Excel access.

-
Streaming Real-Time and Snapshot Quotes
Track your positions in real-time for instruments such as Crude Oil, Natural Gas, or Heating Oil, or watch the term structure of the market while trading. MarketView ExcelTools real-time market data interface gives you access to all of your publication data as it happens, greatly reducing end-of-day reporting time over those vendors who only provide historical data Excel access.
To the Top -
Historical Energy Data
The historical energy and commodity data Excel module allows you to embed deep historical market information into your spreadsheets with automated data filling methods, units and currency conversion, as well as optional chart creation. Historical data is available on an intraday, daily, weekly, monthly, and seasonal basis.
To the Top -
Charts
Insert a historical data Excel table on your spreadsheet and let ExcelTools automatically format the data as a chart. Choose from numerous time series (intraday, daily, weekly, monthly, seasonal, etc.) and from numerous chart types (bar, candlestick, volume, etc.).
To the Top -
Option Chain
Easily view a single option strike or a range of options for an underlying futures contract. Display the Greeks including Delta, Gamma, Theta, Vega and Rho. View the Theoretical Value of an option and both real time Volatility or user defined Volatility. Choose from the Black, Black Scholes, Binomial, Whaley and Garman-Kohlhagen models and configure other user preferences for options modeling.
To the Top -
ExcelTools Menu
The ExcelTools menu is loaded as its own unique menu under the Data menu in Excel 2007 and 2010 and as a stand alone toolbar in Excel 2003. The menu consists of both elegant icons and text which make it incredibly easy to get started using the product.
-
Real-Time Proprietary Data Sharing
The MarketView Xchange feature via ExcelTools greatly reduces your proprietary data distribution efforts and provides greater downstream analytics for your consumer base. With Xchange's easy to use Excel interface, users can quickly update and share proprietary data with other users in real-time. MarketView Xchange eliminates the need to update and email spreadsheets to distribution groups or save spreadsheets and data to a specific location for others to consume.
To the Top