To upload your option contract parameters using an Excel document the document must follow a few rules ...
Only spreadsheets having .xlsx or .xslm extensions can be processed.
Header
The header is the first row of a worksheet. It may contain any number of columns
in any order, but it must contain at least the following values:
OptionCode | ContractCode | DividendYield | InterestRate | ParameterA | ParameterB |
ParameterC | ParameterD | ParameterE | ParameterF | ParameterG | ParameterH | PivotValue | SkewSlope | UnderlyingPrice |
Volatility | VolatilityAdjustment | VolatilityOffsetToBase | VolatilitySlope |
ParameterI | ParameterJ | ParameterK | ParameterL|
The header row may have absolutely no duplicate values at all or an error will be
reported.
Body
The program runs through the values under the OptionCode, ContractCode, DividendYield,
InterestRate, ParameterA, ParameterB, ParameterC, ParameterD,
ParameterE, ParameterF, ParameterG, ParameterH, PivotValue, SkewSlope, UnderlyingPrice,
Volatility, VolatilityAdjustment, VolatilityOffsetToBase, VolatilitySlope, ParameterI, ParameterJ, ParameterK, ParameterL columns. If the option code is empty, the row is skipped.
Worksheet Names
There is an optional Worksheet name input. If it is left blank, the first worksheet
in the workbook will be read. If a worksheet name has been entered, the program
will attempt to upload future parameters from the specified worksheet. If the worksheet
cannot be found, an error will be reported.