Page History

...

1. Download the Import template

   1. Expand
      title Template
      View file name Derivatives_Futures_Template.csv height 250

2. Enter all data needed to be imported.
3. From Risk Management | Derivative Entry clink on Import
4. When Import screen opens, click on Browse and select the csv file then click the Import button
5. Field DefinationDefinition

   1. Column Name	Data Type	Requirements
      Broker	Alphanumeric characters	Broker Field in the Brokerage Accounts  Entered data in the spread sheet should be existing in the

      current records

      Brokerage Accounts  records. This is a required field.
      AccountNumber	Alphanumeric characters	Account Number in the Brokerage Accounts  Entered data in the spread sheet should be existing in the Brokerage Accounts  records. This is a required field.
      MarketName	Alphanumeric characters	Market Name in the Future Market screen Entered data in the spread sheet should be existing in the Futures Market records. This is a required field.
      InstrumentType	Alphanumeric characters	Futures
      CommodityCode	Alphanumeric characters	Market Name in the Future Market screen
      LocationName	Alphanumeric characters
      Salesperson	Alphanumeric characters
      Currency	Alphanumeric characters
      BrokerTradeNo	Alphanumeric characters
      BuySell	Alphanumeric characters
      NoOfContract	Numbers
      FutureMonth	Alphanumeric characters
      OptionMonth	Alphanumeric characters
      OptionType	Alphanumeric characters
      Strike	Numbers
      Price	Numbers
      Reference	Alphanumeric characters
      Status	Alphanumeric characters
      FilledDate	Date
      Book	Alphanumeric characters
      SubBook	Alphanumeric characters
      CreateDateTime	Date

Options

1. Download the Import template

   1. Expand
      title Template
      View file name Derivatives_Options_Template.csv height 250

2. Field Definition and Requirements