How To Import Derivatives

Futures

1. Download the Import template
   1. Template

      Derivatives_Futures_Template.csv

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 Defination

   1. Column Name	Data Type	Requirements
      Broker	Alphanumeric characters	Broker Field in the Brokerage Accounts  Entered data in the spread should be existing in the current records.
      AccountNumber	Alphanumeric characters	Account Number in the Brokerage Accounts
      MarketName	Alphanumeric characters
      InstrumentType	Alphanumeric characters
      CommodityCode	Alphanumeric characters
      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. Template

      Derivatives_Options_Template.csv

2. Field Definition and Requirements