{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Main","MM","Setting","Trades","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":31,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,1,4,11],[9,5,9,6],[10,5,10,6],[21,5,21,6]]}
[]
[]
[]
[]
[null,"DEUTSCHE UPLOAD"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Note:"]
[null,null,"Report Details:"]
[null,null,null,null,null,null,null,null,null,null,null,"1. Press Login to connect to database"]
[null,null,null,null,"Company Name:","i-VCAP MANAGEMENT SDN BHD",null,null,null,null,null,"2. Select Fund Group Code and Value Date, then click on the button Import to import data."]
[null,null,null,null,"Company ID:","IV",null,null,null,null,null,"3. Click on Generate CSV button to export the selected sheet(s) to CSV format."]
[null,null,null,null,null,null,null,null,null,null,null,"4. For NEW Portfolio Code, NEW Broker and NEW Money Market Placement Bank setting, click on Setting button."]
[null,null,null,null,"Fund Group:","MYETFSID"]
[null,null,null,null,"Value Date:","2021-05-04"]
[null,null,null,null,"Office:","Front Office"]
[]
[null,null,null,null,null,"Sheet Name","Export","Range"]
[null,null,null,null,"Export Files:","Trades","Yes","D2:CE"]
[null,null,null,null,null,"MM","Yes","C2:CB"]
[]
[]
[null,null,null,null,"Export Path:","C:\\Users\\zuleika\\Documents\\Report"]

{"sheet":"MM","index":1,"n_rows":2,"n_cols":80,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(A1,PortfolioCodeRange,2,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,{"$f":"MM_FABrokerIdenType","v":"CLIENT_BROKER_CODE"},{"$f":"VLOOKUP(B1,CashCPRange,5,0)","v":{"$error":"#N/A"}},{"$f":"MM_FACPIdenType","v":"CLIENT_BROKER_CODE"},{"$f":"VLOOKUP(B1,CashCPRange,4,0)","v":{"$error":"#N/A"}}]
["qFundCode","qCPCode","Receiver BIC","Action","Client Reference","Previous Reference No.","Trade Type","Transaction Type","Instrument Type","Blank Column","Portfolio Group","FA Portfolio Code","Security Identifier Type","Local_Security_Code","ISIN","Security Description","Bank code","Blank Column","Blank Column","FA Broker Identifier Type","FA Broker Code","FA Counterparty Identifier Type","FA Counterparty Code","Blank Column","Blank Column","Trade Date","Settlement Date","Maturity Date","Quantity / Principal","Deal Price CCY","Deal Price","Gross Amount","Spot Rate","Forward Rate","BUY_CRNCY","SAL_CRNCY","BUY_AMT","SAL_AMT","Interest Rate","Interest Payment Frequency","Blank Column","Shariah Deposit","Interest type","Blank Column","BROKERAGE COMMISION","FUND ISSUE / REDEMPTION CHARGES","WITHOLDING TAX","DISTRIBUTION FEES PAYABLE","LOAD CHARGES","Equalization","Earn Resign (Paid to company)","Earnings Company - Resign (To Member)","COM-TRANS FROM OTHER FUND","COM-TRANS TO OTHER FUND","Donation","Switching In Fee","UNIT PREMIUM","Premium","Security transaction tax","Transaction Fee","Stamp duty","STP CHARGES ","Clearing Fee","Expense Fee","VAT","Retained Earnings","Capital gain/loss","Other Fee","Bank Charges","Blank Column","Blank Column","Blank Column","Blank Column","Exchange","Settlement CCY","Settlement Amount","Blank Column","Narrative Line 1 ","Narrative Line 2","End_of_Line_Indicator"]

{"sheet":"Setting","index":2,"n_rows":100,"n_cols":36,"rows_kept":100,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
[null,null,null,null,"TRADE SETTING",null,null,null,"PORTFOLIO CODE","PORTFOLIO CODE END",null,"MM CP SETTING",null,null,null,"MM CP SETTING END",null,"TRADE CP SETTING",null,null,"TRADE CP SETTING END",null,"FUND GROUP SDF","FUND GROUP SDF END",null,null,null,null,null,"PSET TRADE SETTING","PSET TRADE SETTING END",null,"COUNTERPARTY BIC",null,null,"COUNTERPARTY BIC END"]
[null,null,null,null,"GENERAL TRADE/MM SETTING",null,null,null,"PORTFOLIO CODE",null,null,"MM CP SETTING",null,null,null,null,null,"FA CP/BROKER CODE",null,null,null,null,"FUND GROUP SDF",null,null,"TRADE SETTING BY PORTFOLIO",null,null,null,"PSET TRADE SETTING",null,null,"Counterparty BIC"]
[null,null,null,null,"No.","Field Name","Default Value",null,"OnePortfolio Fund Code","FA Portfolio Code",null,"CP Code","CP Name","Account No.","Counterparty","Broker",null,"Trade CP Code","CP Name","FA Broker Code","FA Counterparty Code",null,"Fund Group Code","Fund Group Name",null,"Fund Code","Securities Acc No","Client Reference",null,"Currency Code","PSET",null,"qCPCode","Currency Code","LookUp","COUNTERPARTY BIC"]
[null,null,null,null,1,"Company Local Currency","MYR",null,"MYETFDJ","MYA523730N",null,"F_BIMB","Bank Islam Malaysia Berhad","MY_BIMB","MY_BIMB","MY_BIMB",null,"BIMB","BIMB Securities Sdn Bhd                 ","BSDBMYK1XXX","BSDBMYK1XXX",null,"ALLFUNDS","ALLFUNDS",null,"MYETFDJ","000523734001","DJIM",null,"AUD","ACLRAU2SXXX",null,"MIB","AUD",{"$f":"IF(OR(AG4=\"\",AH4=\"\"),\"\",AG4&AH4)","v":"MIBAUD"},"CITIAU3XXXX"]
[null,null,null,null,2,null,null,null,"MYETFID","MYA400033N",null,"F_BMMB","Bank Muamalat Malaysia Berhad","MY_MUAMALAT","MY_MUAMALAT","MY_MUAMALAT",null,"CIMB","CIMB Investment Bank Berhad             ","COIMMYKLXXX","COIMMYKLXXX",null,"DUMMY","DUMMY",null,"MYETFID","040003304001","MMID",null,"HKD","XHKCHKH1XXX",null,"MIB","HKD",{"$f":"IF(OR(AG5=\"\",AH5=\"\"),\"\",AG5&AH5)","v":"MIBHKD"},"KMESHKH1XXX"]
[null,"Legends",null,null,3,null,null,null,"MYETFSID","MYA4001061",null,"F_CIMB","CIMB Islamic Bank Berhad","MY_CIMBIS","MY_CIMBIS","MY_CIMBIS",null,"MIB","Maybank Investment Bank                 ","MBEAMYKLXXX","MBEAMYKLXXX",null,"iSEYF","i-VCAP SHARIAH ENHANCED YIELD FUND",null,"MYETFSID","040010614001","MSEAD",null,"KRW","KSDCKRSEXXX",null,"MIB","IDR","MIBIDR","KMESIDJ1XXX"]
[null,null,"User Key In",null,4,null,null,null,"MMF1",null,null,"F_KFH","Kuwait Finance House","MY_KFH","MY_KFH","MY_KFH",null,"OSK","OSK Investment Berhad                   ",null,null,null,"IVCAP","IVCAP",null,"MMF1",null,null,null,"IDR","INDOIDJAXXX",null,"MIB","KRW","MIBKRW","DSSCKRS1XXX"]
[null,null,"Downloaded Data",null,5,null,null,null,"AGRIDUMMY",null,null,"F_MIB","Maybank Islamic Berhad","MY_MBBI","MY_MBBI","MY_MBBI",null,"RHB","RHB Investment Bank Berhad              ","OSKIMYKLXXX","OSKIMYKLXXX",null,"IVCAPTAWAS","IVCAP FOR TAWAS",null,"METFAPA","040011114001","METFAPA",null,"TWD","TDCCTWTPXXX",null,"MIB","MYR","MIBMYR","MBEAMYKLXXX"]
[null,null,null,null,null,"Trades Setting",null,null,"SEEDINGDUMMY",null,null,"F_RAJHI","Al Rajhi Bank","MY_ALRAJHI","MY_AL RAJHI","MY_AL RAJHI",null,"ALLIANCE","ALLIANCE INVESTMENT BANK","MBAMMYKLXXX","MBAMMYKLXXX",null,"iVCAPVCAP","iVCAPVCAP",null,null,null,null,null,"NZD","RBNZNZ22XXX",null,"MIB","THB","MIBTHB","KESATHB1XXX"]
[null,"Go To",null,null,1,"Receiver BIC","DEUTMYKLXXX",null,"METFAPA","MYA4001111",null,"F_RHB","RHB Islamic Bank Berhad","MY_RHBIBB","MY_RHBI","MY_RHBI",null,"N/A","Not Applicable","DEUTMYKLXXX","DEUTMYKLXXX",null,"IVCAP-ZAIN","IVCAP-ZAIN",null,null,null,null,null,"THB","TSDCTHBKXXX",null,"CIMB","IDR","CIMBIDR","GOHOIDJ1XXX"]
[null,null,"General Trade Setting",null,2,"Security Identifier Code (Local)","KL_BERNAMA",null,"iSEYF",null,null,"F_AFHWA","Affin Hwang Investment Bank Berhad",null,null,null,null,"NONE","NO BROKER                               ",null,null,null,"KWAP","KWAP",null,null,null,null,null,"MYR","MCDSMYK1XXX",null,"CIMB","KRW","CIMBKRW","CSKRKRS1XXX"]
[null,null,null,null,3,"Security Identifier Code (Foreign)","MY_REUTERS",null,"METFUS50",null,null,"F_AMBNK","AmBank (M) Berhad",null,null,null,null,"AFFIN","AFFIN HWANG INVESTMENT BANK BERHAD","AFUOMYK1XXX","AFUOMYK1XXX",null,"KWAPSUKUK","KWAPSUKUK",null,null,null,null,null,"CAD",null,null,"CIMB","MYR","CIMBMYR","JUPSMYK1XXX"]
[null,null,"Portfolio Code Setting",null,4,"FA Broker Identifier Type","BIC_CODE",null,null,null,null,"F_AMISLA","AmIslamic Bank Berhad",null,null,null,null,"CIMB Taiwan","CIMB Securities Limited, Taiwan",null,null,null,"METFAPA","METFAPA",null,null,null,null,null,"CHF",null,null,"CIMB","NZD","CIMBNZD","CRGGNZ21XXX"]
[null,null,null,null,5,"FA Counterparty Identifier Type","BIC_CODE",null,null,null,null,"F_HLBNK","Hong Leong Bank Berhad",null,null,null,null,"MIDF Investment","MIDF Amanah Investment Bank Berhad","MIDFMYK1XXX","MIDFMYK1XXX",null,"METFUS50","METFUS50",null,null,null,null,null,"CNY",null,null,"CIMB","THB","CIMBTHB","COIMMYKLXXX"]
[null,null,"MM CP Setting",null,6,null,null,null,null,null,null,"F_HLISLA","Hong Leong Islamic Bank Berhad",null,null,null,null,"NA","N/A",null,null,null,"MMF1","MMF1",null,null,null,null,null,"DKK",null,null,"CIMB","TWD","CIMBTWD","CSAHTWT1XXX"]
[null,null,null,null,7,null,null,null,null,null,null,"F_HSBC","HSBC Amanah Malaysia Berhad",null,null,null,null,null,null,null,null,null,"MYETF","MYETF",null,null,null,null,null,"EUR",null,null,"BIMB","MYR","BIMBMYR","BIMBMYKLXXX"]
[null,null,"Trade CP Setting",null,8,null,null,null,null,null,null,"F_MAYINVT","Maybank Investment Bank Berhad",null,null,null,null,null,null,null,null,null,"MYETFDJ","MYETFDJ",null,null,null,null,null,"GBP",null,null,"AFFIN","MYR","AFFINMYR","AFUOMYK1XXX"]
[null,null,null,null,9,null,null,null,null,null,null,"F_MBB","Malayan Banking Berhad",null,null,null,null,null,null,null,null,null,"MYETFID","MYETFID",null,null,null,null,null,"INR",null,null,"ALLIANCE","MYR","ALLIANCEMYR","MBAMMYKLXXX"]
[null,null,"Trade Setting By Portfolio",null,10,null,null,null,null,null,null,"F_OCBC","OCBC Bank (M) Berhad",null,null,null,null,null,null,null,null,null,"MYETFSID","MYETFSID",null,null,null,null,null,"JPY",null,null,"RHB","MYR","RHBMYR","OSKIMYKLXXX"]
[null,null,null,null,11,null,null,null,null,null,null,"CIMB5","CIMB BANK BERHAD",null,null,null,null,null,null,null,null,null,"UTFUND","Unit Trust Funds",null,null,null,null,null,"PHP","PHCDPHM1XXX",null,"MIDF Investment","MYR","MIDF InvestmentMYR","MIDFMYK1XXX"]
[null,null,"PSET Trade Setting",null,12,null,null,null,null,null,null,"F-KIB","KENANGA INVESTMENT BANK","MY_KNKIN-I","MY_KNKIN-I","MY_KNKIN-I",null,null,null,null,null,null,null,null,null,null,null,null,null,"SGD","CDPLSGSGXXX",null,"MIB","SGD","MIBSGD","MKEESGS1XXX"]
[null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USD",null,null,"MIB","PHP","MIBPHP","ATSCPHM1XXX"]
[null,null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VND",null,null,"CIMB","AUD","CIMBAUD","ABAOAU41XXX"]
[null,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIMB","HKD","CIMBHKD","GKGSHKH1XXX"]
[null,null,null,null,null,"Money Market Setting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIMB","SGD","CIMBSGD","GKGTSGS1XXX"]
[null,null,null,null,1,"Receiver BIC","DEUTMYKLXXX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIMB","PHP","CIMBPHP","EQICPHM1XXX"]
[null,null,null,null,2,"Portfolio Group","MY_IVCAP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIB","TWD","MIBTWD","UWCBTWTPXXX"]
[null,null,null,null,3,"FA Broker Identifier Type","CLIENT_BROKER_CODE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIB","NZD","MIBNZD","CITINZ2XXXX"]
[null,null,null,null,4,"FA Counterparty Identifier Type","CLIENT_BROKER_CODE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHB","IDR","RHBIDR","ONSNIDJ1XXX"]
[null,null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHB","HKD","RHBHKD","OSKSHKH1XXX"]
[null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHB","AUD",{"$f":"IF(OR(AG31=\"\",AH31=\"\"),\"\",AG31&AH31)","v":"RHBAUD"},"CITIAU3XXXX"]
[null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHB","SGD","RHBSGD","DASPSGS1XXX"]
[null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHB","THB","RHBTHB","BFSOTHB1XXX"]
[null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHB","USD","RHBUSD","CITIUS33XXX"]
[null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHB","TWD","RHBTWD","SNPSTWTPXXX"]
[null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AG69=\"\",AH69=\"\"),\"\",AG69&AH69)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Trades","index":3,"n_rows":22,"n_cols":83,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,{"$f":"VLOOKUP(A1,OthTradeSetting,3,0) & RIGHT(AE1,2) &CHOOSE(MID(AE1,5,2),\"JAN\",\"FEB\",\"MAR\",\"APR\",\"MAY\",\"JUN\",\"JUL\",\"AUG\",\"SEP\",\"OCT\",\"NOV\",\"DEC\") & \"-\" & ROW()-2","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(OR(C1=\"SP\",C1=\"SS\"),VLOOKUP(A1,OthTradeSetting,2,0),\"\")","v":""},{"$f":"IF(H1<>\"C\",VLOOKUP(A1,PortfolioCodeRange,2,0),\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"IF(H1<>\"C\",VLOOKUP(B1,TradeCPCodeRange,3,0),\"\")","v":{"$error":"#N/A"}},null,{"$f":"IF(H1<>\"C\",VLOOKUP(B1,TradeCPCodeRange,4,0),\"\")","v":{"$error":"#N/A"}},{"$f":"IF(OR(C1=\"SP\",C1=\"SS\"),VLOOKUP(B1&BP1,CounterPartyBICRange,2,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(C1=\"SP\",C1=\"SS\"),VLOOKUP(BP1,PSET.Data,2,0),\"\")","v":""}]
["qFundCode","qCPCode","qTrnCode","Receiver BIC","Action","Client Reference","Previous Reference No.","Trade Type","Transaction Type","Instrument Type","Blank Column","Securities Account no","FA Portfolio Code","Security Identifier Type","Local_Security_Code","ISIN","Security Description","Blank Column","FA Broker Identifier Type","FA Broker Code","FA Counterparty Identifier Type","FA Counterparty Code","Counterparty BIC","Counterparty Description","Counterparty Account","Buyer/Seller BIC","Buyer/Seller Description","Buyer/Seller Account","Blank Column","Blank Column","Trade Date","Settlement Date"," Quantity ","Deal Price CCY","Deal Price","Gross Amount","Accrued Interest","Blank Column","Blank Column","Blank Column","Stamp Duty","Clearing Fee","Other Fee","Broker Commission","Sales Tax","Levy","GST Brokerage","GST Clearing","GST Scanning","GST Transaction","CDS Fees","CSE Fees","GOVT Cess","SEC Cess","SCCP","Bought Accrued Interest","AR-BIR CB Tax","Prepaid Tax Discount","Prepaid Tax Premium","Witholding Tax on SDA ACC Int","Blank Column","Blank Column","Blank Column","Blank Column","Blank Column","PSET","PSAFE","Settlement CCY","Settlement Amount","Blank Column","Blank Column","Narrative Line 1","Narrative Line 2","Narrative Line 3","Narrative Line 4","Registration Narrative","Blank Column","Blank Column","Blank Column","Blank Column","Blank Column","Blank Column","End_of_Line_Indicator"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-1",null,"F","DVP","E",null,"040010614001","MYA4001061","MY_REUTERS","ID1000058407","ID1000058407","UNITED TRACTORS",null,"BIC_CODE","COIMMYKLXXX","BIC_CODE","COIMMYKLXXX","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,5100,"IDR",21075,107482500,null,null,null,null,0,266017,0,145455,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",107071028,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-2",null,"F","DVP","E",null,"040010614001","MYA4001061","MY_REUTERS","ID1000095706","ID1000095706","UNILEVER INDONE",null,"BIC_CODE","COIMMYKLXXX","BIC_CODE","COIMMYKLXXX","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,33200,"IDR",5750,190900000,null,null,null,null,0,471441,0,229080,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",190199479,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-3",null,"F","DVP","E",null,"040010614001","MYA4001061","MY_REUTERS","ID1000106701","ID1000106701","PT AKR CORPORIN",null,"BIC_CODE","COIMMYKLXXX","BIC_CODE","COIMMYKLXXX","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,11100,"IDR",3240,35964000,null,null,null,null,0,88872,0,145455,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",35729673,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-4",null,"F","DVP","E",null,"040010614001","MYA4001061","MY_REUTERS","ID1000108509","ID1000108509","INDO TAMBANGRAY",null,"BIC_CODE","COIMMYKLXXX","BIC_CODE","COIMMYKLXXX","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,2400,"IDR",11850,28440000,null,null,null,null,0,70615,0,145455,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",28223930,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-5",null,"F","DVP","E",null,"040010614001","MYA4001061","MY_REUTERS","ID1000111305","ID1000111305","ADARO ENERGY TB",null,"BIC_CODE","COIMMYKLXXX","BIC_CODE","COIMMYKLXXX","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,89200,"IDR",1240,110608000,null,null,null,null,0,274216,0,145455,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",110188329,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-6",null,"F","DVP","E",null,"040010614001","MYA4001061","MY_REUTERS","ID1000116700","ID1000116700","INDOFOOD CBP SU",null,"BIC_CODE","COIMMYKLXXX","BIC_CODE","COIMMYKLXXX","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,13200,"IDR",8475,111870000,null,null,null,null,0,276059,0,145455,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",111448486,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-7",null,"F","DVP","E",null,"040010614001","MYA4001061","MY_REUTERS","ID1000129000","ID1000129000","TELEKOMUNIKASI ",null,"BIC_CODE","COIMMYKLXXX","BIC_CODE","COIMMYKLXXX","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,73400,"IDR",3190,234146000,null,null,null,null,0,578218,0,280975,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",233286807,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-8",null,"F","DVP","E",null,"040010614001","MYA4001061","MY_REUTERS","PHY1973T1008","PHY1973T1008","D&L INDUSTRIES ",null,"BIC_CODE","COIMMYKLXXX","BIC_CODE","COIMMYKLXXX","EQICPHM1XXX",null,null,null,null,null,null,null,20210504,20210507,13000,"PHP",7.3369,95379.7,null,null,null,null,0,708.41,0,489.9,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHCDPHM1XXX",null,"PHP",94181.39,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-9",null,"F","DVP","E",null,"040010614001","MYA4001061","MY_REUTERS","PHY2088F1004","PHY2088F1004","DMCI HOLDINGS I",null,"BIC_CODE","COIMMYKLXXX","BIC_CODE","COIMMYKLXXX","EQICPHM1XXX",null,null,null,null,null,null,null,20210504,20210507,24600,"PHP",5.34,131364,null,null,null,null,0,975.45,0,489.9,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHCDPHM1XXX",null,"PHP",129898.65,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-10",null,"F","DVP","E",null,"040010614001","MYA4001061","MY_REUTERS","PHY594811127","PHY594811127","MEGAWORLD CORPO",null,"BIC_CODE","COIMMYKLXXX","BIC_CODE","COIMMYKLXXX","EQICPHM1XXX",null,null,null,null,null,null,null,20210504,20210507,67900,"PHP",3.0792999999999999,209084.47,null,null,null,null,0,1558.6,0,489.9,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHCDPHM1XXX",null,"PHP",207035.97,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-11",null,"C","DVP","E",null,"040010614001","",null,null,"ID1000058407","UNITED TRACTORS",null,null,"",null,"","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,5100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",107071028,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-12",null,"C","DVP","E",null,"040010614001","",null,null,"ID1000095706","UNILEVER INDONE",null,null,"",null,"","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,33200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",190199479,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-13",null,"C","DVP","E",null,"040010614001","",null,null,"ID1000106701","PT AKR CORPORIN",null,null,"",null,"","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,11100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",35729673,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-14",null,"C","DVP","E",null,"040010614001","",null,null,"ID1000108509","INDO TAMBANGRAY",null,null,"",null,"","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,2400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",28223930,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-15",null,"C","DVP","E",null,"040010614001","",null,null,"ID1000111305","ADARO ENERGY TB",null,null,"",null,"","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,89200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",110188329,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-16",null,"C","DVP","E",null,"040010614001","",null,null,"ID1000116700","INDOFOOD CBP SU",null,null,"",null,"","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,13200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",111448486,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-17",null,"C","DVP","E",null,"040010614001","",null,null,"ID1000129000","TELEKOMUNIKASI ",null,null,"",null,"","GOHOIDJ1XXX",null,null,null,null,null,null,null,20210504,20210506,73400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOIDJAXXX",null,"IDR",233286807,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-18",null,"C","DVP","E",null,"040010614001","",null,null,"PHY1973T1008","D&L INDUSTRIES ",null,null,"",null,"","EQICPHM1XXX",null,null,null,null,null,null,null,20210504,20210507,13000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHCDPHM1XXX",null,"PHP",94181.39,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-19",null,"C","DVP","E",null,"040010614001","",null,null,"PHY2088F1004","DMCI HOLDINGS I",null,null,"",null,"","EQICPHM1XXX",null,null,null,null,null,null,null,20210504,20210507,24600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHCDPHM1XXX",null,"PHP",129898.65,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]
["MYETFSID","CIMB","SS","DEUTMYKLXXX","NEWM","MSEAD04MAY-20",null,"C","DVP","E",null,"040010614001","",null,null,"PHY594811127","MEGAWORLD CORPO",null,null,"",null,"","EQICPHM1XXX",null,null,null,null,null,null,null,20210504,20210507,67900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHCDPHM1XXX",null,"PHP",207035.97,null,null,null,null,null,null,null,null,null,null,null,null,null,"END"]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}