Spreadsheet: 89d88509-532b-40ce-928f-4a358ca37327
Sheet: Warrants and Certificates Notes

Instrument Type | Exchange | Issuer | Market Maker | Round Lot | Settlement Type | Excercise type | Listing Date | Trading Currency | Issuer Code | Market Maker Code
The order of the fields have changed!
Fields common to all instruments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Optional |  |  | Optional
 |  |  |  |  |  |  |  | Optional? |  | Optional | Optional | Optional | Optional | Optional | Optional | Optional | Optional | Underlying Instrument 1
Short Name | Long Name | ISIN code | Direction | Instruments Per Underlying | Instrument Currency | Last Trading Date | Expiration Date | Reimbursement Date | Number of Issued Instruments | Description | Strike Price | [NAME] | Knock-out level | Asian Tail Start Date | Asian Tail End Date | Leverage | Level of funding | Underlying Class | Underlying Instrument | ISIN Code for Underlying Instrument | Underlying Free Text | Basket Share | Etc… (more underlyings)
 |  |  | This field should also |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drop down: | Dropdown: | Lookup value | Read this in all cases | Mandatory
 |  |  | generate the PUT/CALL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shares | <All available underlyings> |  | [NAME] 60 char
 |  |  | field as this is removed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Commodities | (Based on value in column S) | Verify vs spin?
 |  |  | from template |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indices
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FX | Change:
 |  |  | PUT/CALL is mandatory |  |  |  |  |  |  |  |  |  |  |  |  |  |  | etc | Issuer MUST select an item
Field | Comments |  | in INET |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | from the dropdown
Ideas: | Matrix for mandatory fields in the ILA code?
 | - Output based on Subtype? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dropdown Tests
 | - Validation?
 | New message template for ETNs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No 2 |  | Prefered
Changes
Field | Comments | Questions
Instrument Type | New list of subtypes
Reimbursement Date |  | Optional?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Brent Crude Oil | Agricultural - Agricultural Index
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Natural Gas | Agricultural - Corn
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fracking/Cracking | Agricultural - Lean Hogs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heating Oil | Agricultural - Live Cattle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gasoline | Agricultural - Soybeans
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coal | Agricultural - Wheat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WTI Crude Oil | Base Metals - Aluminium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Energy Index | Base Metals - Base Metals Index
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electricity | Base Metals - Copper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emission Rights | Base Metals - Lead
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Commodity Index | Base Metals - Nickel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Solar | Base Metals - Tin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wind | Base Metals - Zinc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biofuels | Energy - Brent Crude Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Base Metals Index | Energy - Coal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Copper | Energy - Electricity
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aluminium | Energy - Energy Index
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zinc | Energy - Fracking/Cracking
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lead | Energy - Gasoline
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nickel | Energy - Heating Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tin | Energy - Natural Gas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Precious Metals Index | Energy - WTI Crude Oil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gold | Other - Commodity Index
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Silver | Other - Emission Rights
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Platinum | Precious Metals - Gold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Palladium | Precious Metals - Palladium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Agricultural Index | Precious Metals - Platinum
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Corn | Precious Metals - Precious Metals Index
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wheat | Precious Metals - Silver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soybeans | Renewables - Biofuels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Live Cattle | Renewables - Solar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coffee | Softs - Cocoa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cocoa | Softs - Coffee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sugar | Softs - Cotton
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cotton | Softs - Sugar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Orange juice | Softs - Orange juice