From the ICE XL Ribbon, Click Options
Symbol |
|
Symbol |
Symbols selected |
Symbol Search |
You can click
the |
Expiration Drop Down |
Select the Option expiration in the drop down |
Fields |
|
Options Fields |
Select to specify what fields will be displayed for the options |
Underlying Fields |
Select to specify what fields will be displayed for the underlying instrument |
Black Scholes |
|
| Use Default Black Scholes Parameters | Selecting this option defaults to global Options settings |
| Interest Rate | Set the interest rate for Black Scholes calculations |
| Dividend Rate | Set the Dividend rate for Black Scholes calculation |
| Options Price | Define the option price source |
| Underlying Price | Define the underlying price source |
Other Options Window Elements |
|
Format Numbers |
Format the numbers using Excel formatting |
Number of Rows |
Set the number of rows for the output |
Show NA instead of empty |
This option will return the excel error message =NA() instead of an empty value. |
Set as Default |
Set current filter and field configuration as default |
Retrieve Data |
Select Retrieve Data to execute and build your Option table within your Excel sheet |
to access symbol search dialog