0910 Trade Feeder

The majority of trades to the new settlement system comes from front office trades and execution stream. But the new system allow manual input of trades. User can input a trade via the front end of the new system, or more effectively, by a spreadsheet with minimal fields.

A Excel based trade feeder benefits the operation for a few obvious reasons.

1) Comparing to the front-end, an Excel program can feed trades in bulk. By preparing the trade details in a spreadsheet, and click on one button, user can upload hundreds and thousands of trades into the new system. This is particularly useful in the BCP operation.

2) While training users to use the front end is expensive, getting them familiar to a Excel spreadsheet is much much easier.

3) While the front-office stream failed to offer necessary data to the middle/back-office, user can input the trades quickly by the Excel program.

The work-flow:

The user case:

Screen-shot: user click on Send to send trades in bulk.

Screen-shot: trade details page, user only need to input minimal fields. Other fields are populated based on configuration

A XML string that was generated and fed into bookings engine by calling web service.

<?xml version="1.0" standalone="yes"?><Trade xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Header>

<source>Manual</source>

<target>SYN</target>

<TradeType>Client</TradeType>

<overwriteCharges>N</overwriteCharges>

<overwriteSSI>Y</overwriteSSI>

<overwriteValueDate>Y</overwriteValueDate>

<ignoreCancelAmend>N</ignoreCancelAmend>

<ignoreCCA>Y</ignoreCCA>

<suspend_processing>N</suspend_processing>

<suspend_confirmation>N</suspend_confirmation>

</Header>

<Content>

<CTAC_DataStreamRef>20090210 14:00:00.000000 +0800</CTAC_DataStreamRef>

<sourceReference>Test7</sourceReference>

<sourceVersion>1</sourceVersion>

<cancel_replace_flag>N</cancel_replace_flag>

<Is_CCA>N</Is_CCA>

<trade_event>NEW</trade_event>

<tradeDate>20091107</tradeDate>

<tradeTime>12:00:00.000</tradeTime>

<valueDate>20091110</valueDate>

<buy_sell>B</buy_sell>

<softDollarIndicator>H</softDollarIndicator>

<accruedInterest>0</accruedInterest>

<price>23.67</price>

<netConsideration>286667.37</netConsideration>

<gross_consideration>286667.37</gross_consideration>

<rateDirection>M</rateDirection>

<settlementExRate>1</settlementExRate>

<settlementConsideration/>

<salesman>Asia</salesman>

<security_id>3333</security_id>

<bookingQuantity>12111</bookingQuantity>

<quantity>12111</quantity>

<trade_currency>IDR</trade_currency>

<exchange_id>HKG</exchange_id>

<settlement_currency>IDR</settlement_currency>

<orginating_entity>MSL</orginating_entity>

<executing_entity>MSL</executing_entity>

<contracting_entity>MSL</contracting_entity>

<intermediary_entity>MSL</intermediary_entity>

<subaccount_id>5555</subaccount_id>

<delivery_risk>DVP</delivery_risk>

<dealing_capacity>A</dealing_capacity>

</Content>

<CustomFields>

<BrainsField/>

</CustomFields>

<Charges>

<ChargeItems>

<code>COM</code>

<value>0.5</value>

<chargeApplied>true</chargeApplied>

</ChargeItems>

<ChargeItems>

<code>STL</code>

<value>11.11</value>

<chargeApplied>true</chargeApplied>

</ChargeItems>

<ChargeItems>

<code>SST</code>

<value>4.5</value>

<chargeApplied>true</chargeApplied>

</ChargeItems>

</Charges>

<Instructions>

<ClientSettlementInstructions>

<StockId> </StockId>

<StockAgentBankName> </StockAgentBankName>

<StockAgentBankNameBIC> </StockAgentBankNameBIC>

<StockAgentBankBeneficiary> </StockAgentBankBeneficiary>

<StockAgentBankBeneficiaryBIC> </StockAgentBankBeneficiaryBIC>

<StockAgentBankAccount> </StockAgentBankAccount>

<StockAgentRegDetails> </StockAgentRegDetails>

<StockAgentLocalCode> </StockAgentLocalCode>

<NostroId> </NostroId>

<MoneyAgentBankName> </MoneyAgentBankName>

<MoneyAgentBankNameBIC> </MoneyAgentBankNameBIC>

<MoneyAgentBankBeneficiary> </MoneyAgentBankBeneficiary>

<MoneyAgentBankBeneficiaryBIC> </MoneyAgentBankBeneficiaryBIC>

<MoneyAgentBankAccount> </MoneyAgentBankAccount>

<MoneyAgentLocalCode> </MoneyAgentLocalCode>

<MoneyAgentPset> </MoneyAgentPset>

<custody> </custody>

<settle_method> </settle_method>

<SaId> </SaId>

<OrgId> </OrgId>

<SecId> </SecId>

<Book> </Book>

<SettExchMnem> </SettExchMnem>

</ClientSettlementInstructions>

<BrokerSettlementInstructions>

<StockId> </StockId>

<StockAgentBankName> </StockAgentBankName>

<StockAgentBankNameBIC> </StockAgentBankNameBIC>

<StockAgentBankBeneficiary> </StockAgentBankBeneficiary>

<StockAgentBankBeneficiaryBIC> </StockAgentBankBeneficiaryBIC>

<StockAgentBankAccount> </StockAgentBankAccount>

<StockAgentLocalCode> </StockAgentLocalCode>

<NostroId> </NostroId>

<MoneyAgentBankName> </MoneyAgentBankName>

<MoneyAgentBankNameBIC> </MoneyAgentBankNameBIC>

<MoneyAgentBankBeneficiary> </MoneyAgentBankBeneficiary>

<MoneyAgentBankBeneficiaryBIC> </MoneyAgentBankBeneficiaryBIC>

<MoneyAgentBankAccount> </MoneyAgentBankAccount>

<MoneyAgentLocalCode> </MoneyAgentLocalCode>

<SaId> </SaId>

<OrgId> </OrgId>

<SettExchMnem> </SettExchMnem>

<SecId> </SecId>

</BrokerSettlementInstructions>

</Instructions>

</Trade>

Note, the code is company asset, and will not be revealed.

Google Sites

Report abuse