Purpose

The ICE XL add in allows users to access real time and historical data in an intuitive, flexible, and powerful interface.  The functionality and workflow encourages users to create dynamic worksheets that increase productivity and decrease risk.  The program uses Excel RTD calls and .NET in order to provide a light, responsive, and integrated tool.  From simple requests to complicated formulas, this Excel tool offers an easy and effective way to utilize data

Typical Workflow

workflow

  • 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.

Features

  • RTD functions use Excel syntax and are compatible with all other excel functions and VBA codes.
  • RTD syntax is clean, intuitive, and precise, enabling the user to create powerful dynamic spreadsheets.
  • From live quotes, to historical time-series values, the ICE XL framework is flexible enough to handle the full gamut of request types.
  • Allows for cell referencing, dynamic expressions, and concatenated strings to drive any aspect of your output.
  • The uncomplicated ICE XL interface generates an output that can be modified from the output syntax itself, or by returning to the interface.