MarketView®ExcelTools™
copy
MarketView ExcelTools delivers both real-time and historical energy market data into Excel spreadsheets allowing users to customize and categorize the data for their own intricate analysis.
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 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.
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.
Charts
Insert a historical data 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.).
MarketView ExcelTools Unique Features and Advantages
- ExcelTools is a standalone component (it does NOT require an active workstation connection or subscription.)
- Uses a clean, easy-to-use interface that streamlines the way you request quotes or historical data.
- Streams data utilizing Excel Real-Time Data (RTD) components (vs. DDE), for a fast, reliable, and robust interface.
- Your workflow is simplified, as queries are automatically updated with new data.
- Optionally insert static data on a historical query.
- Navigate exchanges quickly with the ExcelTools Symbol Tree.
- Access your User-Defined Formulas that were created in MarketView Desktop.
- Access ISO (Independent System Operator) electricity/power data.
- One-click capabilities: automatically convert all symbol inputs to capital letters (for spreadsheet consistency and accuracy) and utilize drag-and-drop functionality between cells.
- New software upgrades happen seamlessly in the background when you open Excel.
- Supports multiple historical time-series queries, including intraday, daily, weekly, monthly, and seasonal.
Learn more about ExcelTools with our online ExcelTools Help Guide.