Overview

ICE XL is designed to empower Excel users with seamless access to comprehensive market data—both real-time and historical—through an intuitive add-in that transforms Excel into a powerful financial analysis platform. The software enables users to build dynamic, data-driven worksheets using familiar Excel syntax and RTD functions, supporting everything from simple live quote tables to sophisticated analyses including historical time series with customizable granularity, individual data points, streaming market data via Waterfall, Level 2 market depth orderbooks, forward curve modeling with mathematical formulas, and comprehensive options matrices with Greeks and Black Scholes parameters. Built on lightweight .NET technology, ICE XL provides a responsive, integrated solution that increases productivity, decreases risk, and allows users to leverage their existing Excel skills and workflows while gaining access to institutional-grade market data across all ICE Connect products.

ICE XL Quick Start Guide

  • Go to the “Settings” tab.
  • Click the “Connection” tab.
    • Enter your username and password.
      • Your username and password is the same across all ICE Connect products.
  • Once authenticated, the grayed-out menu options will become available.

Create Your First Quote Table (3 Easy Steps)

  1. Open Quote Table
    1. Click the Quote Table icon in the ribbon
  2. Add Your Data
    1. Click Add Symbols (or use the 🔍 search icon) to find and select the securities you want to track
    2. Click Add Fields to choose what data to display (price, volume, etc.)
    3. Tip: Drag fields up or down to reorder columns
  3. Get Your Data
    1. Click Retrieve Data to build your table
    2. Your live-updating quote table appears in the ICE Excel spreadsheet