...
Assume that tag 9707 (MiFIDID) from the Trade Capture Report message (MsgType = "AE") should be now stored in the database. Following the step-by-step instruction belowpresented above:
According to ICE Trade Capture specification (see https://community.theice.com/docs/DOC-19796), MiFIDID is located in the root of the Trade Capture Report message (MsgType = "AE").
Then the ICEReports history from the BL_Config file should be adjusted. Adding the new field to the ICEReports history:Code Block language xml title Snippet from BL_Config <History Name="ICEReports" StorageType="ODBC" MaxNumberOfRecords="15000" TableName="ICEReports" ColumnSize="256" ConnectionString="DSN=ICE_Trades;UID=ice_admin;Pwd=temp_pass;"> <KeyField ColumnName="TradeReportID" ColumnSize="256">571</KeyField> .......... <Field ColumnName="MiFIDID" ColumnSize="256">9707</Field> <Field ColumnName="ClientAppType" ColumnSize="256">9413</Field> </History>
Add the processing of new 9707 field to the ICETrdCapt.js:
Code Block language js title Snippet from ICETrdCapt.js .......... rootData = new Array(); rootTags = new Array(487,856,828,150,17,39,570,55,48,22,461,9403,202,916,917,32,31,75,60,9018,9022,552,555,1126,207,820,9820,9520,9521,9522,9523,9524,9525,9064,762,9510,...,9707/*,in code 9413*/); ..........
- Add new MiFIDID column with varchar (256) type to the ICEReports table.
...