Sheet1DATEFOEA_POSITION_DATE DATETIME,CMCodeFOEA_CM_CODE VARCHAR(13),strCMCode = Trim(StrParse.Field(2))TMCodeFOEA_TM_CODE VARCHAR(13),strTMCode = Trim(StrParse.Field(3))AcTypeFOEA_ACC_TYPE VARCHAR(2),strAcType = Trim(StrParse.Field(4))PartyCodeFOEA_PARTY_CODE VARCHAR(15),strPartyCode = Trim(StrParse.Field(5))InstTypeFOEA_INST_TYPE VARCHAR(6),strInstType = Trim(StrParse.Field(6))SymbolFOEA_SYMBOL VARCHAR(12),strSymbol = Trim(StrParse.Field(7))ExpiryDateFOEA_EXPIRYDATE DATETIME,strExpiryDate = Trim(StrParse.Field(8))FOEA_STRIKE_PRICE MONEY(8),FOEA_OPTION_TYPE VARCHAR(2),BFLongQtyFOEA_BROUGHT_FORWARD_LONG_QUANTITY INT,strBFLongQty = CDbl(StrParse.Field(11))BFLongValueFOEA_BROUGHT_FORWARD_LONG_VALUE NUMERIC,strBFLongValue = CDbl(StrParse.Field(12))BFShortQtyFOEA_BROUGHT_FORWARD_SHORT_QUANTITY INT,strBFShortQty = CDbl(StrParse.Field(13))BFShortValueFOEA_BROUGHT_FORWARD_SHORT_VALUE NUMERIC,strBFShortValue = CDbl(StrParse.Field(14))DayBuyQtyFOEA_DAY_BUY_OPEN_QUANTITY INT,strDayBuyQty = CDbl(StrParse.Field(15))DayBuyValFOEA_DAY_BUY_OPEN_VALUE NUMERIC,strDayBuyVal = CDbl(StrParse.Field(16))DaySellQtyFOEA_DAY_SELL_OPEN_QUANTITY INT,strDaySellQty = CDbl(StrParse.Field(17))DaySellValFOEA_DAY_SELL_OPEN_VALUE NUMERIC,strDaySellVal = CDbl(StrParse.Field(18))PreDelLongQtyFOEA_PREEXALL_LONGQTY INT,strPreDelLongQty = StrParse.Field(19)PreDelLongValFOEA_PREEXALL_LONGVALUE NUMERIC,strPreDelLongVal = StrParse.Field(20)PreDelShortQtyFOEA_PREEXALL_SHORTQTY INT,strPreDelShortQty = StrParse.Field(21)PreDelShortValFOEA_PREEXALL_SHORTVALUE NUMERIC,strPreDelShortVal = StrParse.Field(22)BuyDelMarkQtyFOEA_EXERCISE_QTY INT,strBuyDelMarkQty = CDbl(StrParse.Field(23))SellDelMarkQtyFOEA_ALLOC_QTY INT,strSellDelMarkQty = CDbl(StrParse.Field(24))PostDelLongQtyFOEA_POSTEXALL_LONGQTY INT,strPostDelLongQty = StrParse.Field(25)PostDelLongValFOEA_POSTEXALL_LONGVALUE NUMERIC,strPostDelLongVal = StrParse.Field(26)PostDelShortQtyFOEA_POSTEXALL_SHORTQTY INT,strPostDelShortQty = StrParse.Field(27)PostDelShortValFOEA_POSTEXALL_SHORTVALUE NUMERIC,strPostDelShortVal = StrParse.Field(28)SettlePrice FOEA_SETTLEMENTPRICE NUMERIC,strSettlePrice = CDbl(StrParse.Field(29))MtomValueFOEA_NETPREMIUM NUMERIC,strMtomValue = CDbl(StrParse.Field(31))DelValueFOEA_DAILY_MTM_SETTLEMENT_VALUE NUMERIC,strDelValue = CDbl(StrParse.Field(32))foea_ike_priceFOEA_EXERCISED_ASSIGNED_VALUE NUMERIC,intfoea_strike_price = CDbl(StrParse.Field(9))foea_option_typeRESERVED2 CHAR(12),intfoea_option_type = StrParse.Field(10)foea_NetPremiumintfoea_NetPremium = CDbl(StrParse.Field(30))

Sheet2foea_position_date,strPosDt,foea_cm_code,strCMCode,foea_tm_code,strTMCode,foea_acc_type,strAcType,foea_party_code,strPartyCode,foea_inst_type,strInstType,foea_symbol,strSymbol,foea_expirydate,strExpiryDate 23:59:00,foea_Brought_Forward_long_Quantity,strBFLongQty,foea_Brought_Forward_long_Value,strBFLongValue , foea_Brought_Forward_Short_Quantity,strBFShortQty ,foea_Brought_Forward_Short_Value,strBFShortValue,foea_Day_Buy_Open_Quantity,strDayBuyQty ,foea_Day_Buy_Open_Value,strDayBuyVal,foea_Day_Sell_Open_Quantity,strDaySellQty ,foea_Day_Sell_Open_Value,strDaySellVal ,foea_preexall_longqty,strPreDelLongQty,foea_preexall_longValue,strPreDelLongVal ,foea_preexall_shortqty,strPreDelShortQty ,foea_preexall_ShortValue,strPreDelShortVal ,foea_alloc_qty,strBuyDelMarkQty,foea_exercise_qty,strSellDelMarkQty,foea_postexall_longqty,strPostDelLongQty,foea_postexall_longValue,strPostDelLongVal ,foea_postexall_shortqty,strPostDelShortQty ,foea_postexall_shortvalue,strPostDelShortVal,foea_SettlementPrice,strSettlePrice,foea_Daily_MTM_Settlement_Value,strMtomValue,foea_Exercised_Assigned_Value,strDelValue,foea_strike_price,intfoea_strike_price,foea_option_type,intfoea_option_type,foea_NetPremiumintfoea_NetPremium

Sheet3