Help Files
About Excel Tools

MarketView Excel Tools allows you to import both real-time and historical energy market data into Excel spreadsheets for further individual analysis and integration. Excel Tools offers the best of data management technology with the widest breadth of real-time and historical information in the energy industry.

Excel Tools is a stand-alone product that runs as an add-on to Microsoft Excel, and appears in its own unique toolbar at the top of the Excel application.

Excel Tools is designed to run in the Windows environment, and runs on the Microsoft .NET API platform. It was built to stream data utilizing Excel Real-time Data (RTD) components (vs. DDE), and provides a fast, reliable, and robust interface.

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 Excel Tools’ real-time interface gives you access to all of your energy publication data as it happens, greatly reducing end-of-day reporting time over those vendors who only provide historical data access.

Real-time data is available for the exchanges to which you subscribe. Access to delayed data is also available at No Charge, assuming you are subscribed to the exchange in delay mode. Please contact us to change your exchange subscription.

Historical Data

The historical data 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. You may also customize the data using Unit and Currency conversions, along with other custom download options.

Charts

Insert a historical data table on your spreadsheet and let Excel Tools automatically format the data as a chart. Choose from numerous time series (intraday, daily, weekly, monthly, seasonal, etc.) and from several chart types (bar, candlestick, volume, etc.)

Option Analytics

Keep up-to-date on your options values as the market moves. Choose from any combination of the five different options models available in which to perform in depth analysis. Options can be mixed and matched via the Quote dialog or can be quickly viewed by the root commodity symbol using the Option Chain dialog.