Purpose

The Options feature in ICE XL enables the ability to produce a custom futures or stock options matrix within an Excel spreadsheet.  This feature gives great power to customize the output as well as utilize the returned data into formulas across spreadsheets and across ICE Connect products.  Whether using the default Black Scholes parameters or creating your own, the ICE XL Options feature provides all the pricing data you need along with the Greeks and customizable formatting capabilities. 

Options Interface

Choose between Stock and Futures options at the menu ribbon:

options.png

Dialogue Window

dialogwindow.png

OUTPUT

output.png