The Option function string is comprised of required elements as well as optional elements.
Required Elements
=ICEOptions(<Symbol>,<Array of underlying Fields>,<Array of Call Fields>,<Array of Put Fields>)
Optional Elements
Optional Elements |
|
| NumberofDisplayedOptions= | Defines the number of strikes, dynamically centered around the at the money strike |
| UseDefaultBSParameters= | Set to False allows the definition of specific Black Scholes parameters |
| InterestRate= | Set the interest rate used in Black Scholes Calculation |
| DividendRate= | Set the dividend rate used in Black Scholes Calculation |
| OptionPriceField= | Set the price source used in Black Scholes Calculation |
| UnderlyingPriceField= | Set the underlying price source used in Black Scholes Calculation |
| Precision= | Sets the excel formatting on the output |
| ShowNA= | Fills blank cells with =NA() function which generates "#N/A" error message in cells to be ignored by charts. |