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.
Excel add-in 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.
Excel add-in utilizes native Excel RTD calls and .NET to provide an efficient, responsive and integrated tool. From simple requests to complicated formulas and forward curves, Excel add-in offers an easy and effective way to utilize data in Excel.
Upgrade to the latest Excel add-in, without the need to modify exisiting ICE Connect spreadsheets
A flexible tool that allows for requests of meta data, live values or a value from a point in time
Formula builder offers a step-by-step guide to create a personal library of studies, or utilize our arsenal of existing studies
Build complex forward curve expressions in this easy to use window
Uses native Excel supported RTD calls, is intuitive, and easy to use
Recalls "Most Recently Used" and "Frequently Used" functions and symbols, for quick navigation and symbol search
Live option output creates option tables that can be customized and expanded
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 quickly creates a real-time data table
Refresh a workbook, worksheet or a selection to update any aspect of the spreadsheet
Generates time series data with unparalleled flexibility and power
A library of pre-built templates to help you get started
Filter and extract time and sales data directly into excel
Retrieve data from ZEMA’s data collection of over 400 data providers, stored proprietary marks, and internal curves