Main Function
The Bond Analytics Main function string is comprised of required elements as well as optional elements.
Required Elements
ICEIPA(<Input range>,<Input range headers>,<Output headers>)
Optional Elements
Optional Elements |
|
| Title= | Defines the Title displayed in the main output cell |
| Snapshot= | Set to "False" to output live RTDs rather than snapshot hard-coded values |
| Plot= | Plot styles can be set to vertical or horizontal. Horizontal plots are default |
| Precision= | Set the Excel formatting precision |
| ShowNA= | Set to "True" to output empty values as an =NA() error term |
Cell Function
ICEIPABOND(<Field>,<Symbol>,<Date>,<Price Type>,<Price>,<Calculate>)
Only the field and the symbol are required for a simple RTD request.
Default behavior
Date will default to today
Price type will default to "Price"
Price will default to Bond Analytics pricing
Calculate will default to "True"