ICE Connect
ICE XL
Microsoft Excel™ is ubiquitous in the data analysis space. However, the complexity of the markets and incongruent datasets from multiple sources make it difficult for traders and analysts to use.
ICE XL was built specifically for the needs of the Financial Markets. The tool allows users to access real-time and historical data in an intuitive, flexible and powerful interface for clean visualization and statistical analysis. The functionality and workflow encourages users to create dynamic worksheets that increase productivity and minimize risk.
ICE XL utilizes native Excel RTD calls and .NET to provide an efficient, responsive and integrated tool. From simple requests to complicated formulas and forward curves, ICE XL offers an easy and effective way to utilize data in Excel.
Capability Highlights
- Compatibility
Upgrade to the latest ICE XL, without the need to modify existing ICE Connect spreadsheets - Datapoint
A flexible tool that allows for requests of meta data, live values or a value from a point in time - Formula
Formula builder offers a step-by-step guide to create a personal library of studies, or utilize our arsenal of existing studies - Forward Curve
Build complex forward curve expressions in this easy to use window - Framework
Uses native Excel supported RTD calls, is intuitive, and easy to use. - Navigation
Recalls "Most Recently Used" and "Frequently Used" functions and symbols, for quick navigation and symbol search. - Options
Live option output creates option tables that can be customized and expanded
- Personalization and Sharing
Allows users to store own selection of symbols, fields and formulas for quick access and fewer mistakes. Sheets can be easily shared and distributed. - Quote Table
Quote table quickly creates a real-time data table - Refresh
Refresh a workbook, worksheet or a selection to update any aspect of the spreadsheet - Series
Generates time series data with unparalleled flexibility and power - Templates
A library of pre-built templates to help you get started - Time and Sales
Filter and extract time and sales data directly into excel - ZE Data
Retrieve data from ZEMA’s data collection of over 400 data providers, stored proprietary marks, and internal curves
ICE XL Support
ICE Excel Add-In templates give you the tools needed to build simple to complex real-time market analysis spreadsheets. The historical data feature provides access to ICE Data Services’ deep historical databases.