{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Main","Trades","Setting","MYR upload-BIMB Migration"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":1,"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":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,1,4,11],[9,5,9,6],[10,5,10,6]]}
[]
[]
[]
[]
[null,"SCB 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:","BIMB Investment Management Berhad",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:","BI",null,null,null,null,null,"3. Click on Generate CSV button to export the selected sheet(s) to CSV format."]
[]
[null,null,null,null,"Fund Group:","BAPAC","IB|ID|IS|BAPAC"]
[null,null,null,null,"Value Date:","2021-01-08"]
[null,null,null,null,"Front | Back Office:","Back Office"]
[null,null,null,null,"Export to Desktop:","Yes"]
[null,null,null,null,null,"Sheet Name","Export","Range"]
[null,null,null,null,"Export Files:","Trades","Yes","A3:AE"]

{"sheet":"Trades","index":1,"n_rows":2,"n_cols":31,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IFERROR(VLOOKUP(AC1,Setting!P:R,3,0),\"\")","v":""},null,null,null,{"$f":"IF(IFERROR(VLOOKUP($AF1,Setting!$D:$G,2,0),\"\")=0,\"\",IFERROR(VLOOKUP($AF1,Setting!$D:$G,2,0),\"\"))","v":""},{"$f":"IF(IFERROR(VLOOKUP($AF1,Setting!$D:$G,3,0),\"\")=0,\"\",IFERROR(VLOOKUP($AF1,Setting!$D:$G,3,0),\"\"))","v":""},{"$f":"IF(IFERROR(VLOOKUP($AF1,Setting!$D:$G,4,0),\"\")=0,\"\",IFERROR(VLOOKUP($AF1,Setting!$D:$G,4,0),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROW()-2<1,\"\",\"trade\" & ROW()-2)","v":""},{"$f":"IF(IFERROR(VLOOKUP($AC1,Setting!$L:$N,3,0),\"\")=0,\"\",IFERROR(VLOOKUP($AC1,Setting!$L:$N,3,0),\"\"))","v":""}]
["Securities Account Number","Trade Date","Settlement Date","Pur/Sal","BIC Code Counterparty","CHESS PID/CCASS ID","BIC Code Buyer/Seller","ISIN","SEDOL","Stock Name"," Quantity ","Currency"," Price ","Currency"," Gross Value ","Currency"," Brokerage\n ","Currency"," Clearing Fees ","Currency"," Stamp Duty ","Currency"," GST ","Currency"," Others\n ","Currency"," Net Value ","Currency","Stock Exchange","Customer Reference","Place of Settlement"]

{"sheet":"Setting","index":2,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["List of Brokers","Full Name","Currency (%% = All Currency)","Broker&Currency","BIC Codes","CHESS PID/CCASS ID","BIC Code Buyer/Seller",null,"Fund","Sec Acc Number",null,"Exchange Code","Exchange Name","Place of Settlement (PSET)",null,"Exchange Code","Exchange Name","Securities Account Number"]
["BR:ALLIANCEINVT","Alliance Investment Bank Bhd.","%%",{"$f":"A2&C2","v":"BR:ALLIANCEINVT%%"},"MBAMMYKL",null,null,null,"IB",null,null,"TWSE","Taiwan Stock Exchange","TDCCTWTP",null,"TWSE","Taiwan Stock Exchange",132267100076]
["BR:AmINV","AmInvestment Bank Bhd.","%%",{"$f":"A3&C3","v":"BR:AmINV%%"},"AMMBMYKL",null,null,null,"ID",null,null,"PSE","Phillipine Stock Exchange","PHCDPHM1",null,"PSE","Phillipine Stock Exchange",132267100068]
["BR:BIMBSEC","BIMB Securities Sdn. Bhd.","%%","BR:BIMBSEC%%","BSDBMYK1",null,null,null,"IS",null,null,"SET","Stock Exchange of Thailand","TSDCTHBK",null,"SET","Stock Exchange of Thailand",132267100070]
["BR:CIMBINV","CIMB Investment Bank Bhd.","%%","BR:CIMBINV%%","COIMMYKL",null,null,null,"BAPAC",132267100072,null,"XSES","Singapore Stock Exchange","CDPLSGSG",null,"XSES","Singapore Stock Exchange",132267100069]
["BR:CIMBINV","CIMB SECS LTD KOREA BRCH","KRW","BR:CIMBINVKRW","CSKRKRS1",null,null,null,null,null,null,"NZX","New Zealand Stock Exchange","RBNZNZ22",null,"NZX","New Zealand Stock Exchange",132267100074]
["BR:CIMBINV","CIMB SECS (THAI) CO LTD","THB","BR:CIMBINVTHB","SEETTHB1",null,null,null,null,null,null,"HKSE","Hong Kong Stock Exchange","XHKCHKH1",null,"HKSE","Hong Kong Stock Exchange",132267100072]
["BR:CIMBINV","CIMB-GK SEC PTE LTD","SGD","BR:CIMBINVSGD","GKGTSGS1",null,null,null,null,null,null,"TSE","Tokyo Stock Exchange","JJSDJPJT",null,"TSE","Tokyo Stock Exchange",132267100071]
["BR:CIMBINV","CIMB GROUP","HKD","BR:CIMBINVHKD","GKGSHKH1","B01347",null,null,null,null,null,"ASX","Australian Stock Exchange","CAETAU21 ",null,"ASX","Australian Stock Exchange",132267100073]
["BR:CIMBINV","CIMB GROUP","AUD","BR:CIMBINVAUD","ABAOAU41","04064",null,null,null,null,null,"KSE","Korea Stock Exchange","KSDCKRSE",null,"KSE","Korea Stock Exchange",132267100075]
["BR:CIMBINV","GOLDMAN SACHS JAPAN CO","JPY","BR:CIMBINVJPY","GOLDJPJX",null,"GSILGB2X",null,null,null,null,"China B (Shanghai)",null,"SSCECNS1",null,"China B (Shanghai)",null,132267100078]
["BR:CIMBINV","Capital Securities Corporation","TWD","BR:CIMBINVTWD","SECCTWT1",null,null,null,null,null,null,"China B (Shen Zhen)",null,"SSCCCNS1",null,"China B (Shen Zhen)",null,132267100077]
["BR:CIMBINV","PT CIMB SECURITIES INDONESIA","IDR","BR:CIMBINVIDR","GOHOIDJ1",null,null,null,null,null,null,"JSX","Jakarta Stock Exchange","KSEIIDJA",null,"JSX","Jakarta Stock Exchange",132267100080]
["BR:CIMBINV","ABN AMRO CRAIGS LTD","NZD","BR:CIMBINVNZD","CRGGNZ21",null,"GKGTSGS1",null,null,null,null,"GT","GreTai","TDCCTWTP",null,"GT","GreTai",132267100076]
["BR:HLINV","Hong Leong Investment Bank Bhd.","%%","BR:HLINV%%","HLIVMYKL"]
["BR:KAF-Seagroatt","KAF Seagroatt & Campbell Securities Sdn. Bhd.","%%","BR:KAF-Seagroatt%%","SEACMYK1"]
["BR:KENANGA","Kenanga Investment Bank Bhd.","%%","BR:KENANGA%%","KKENMYK1"]
["BR:MACSEC","Macquarie Capital Securities Sdn. Bhd.","%%","BR:MACSEC%%","MACQMYK1"]
["BR:MACSEC","Macquarie Capital Securities Sdn. Bhd.","JPY",{"$f":"A19&C19","v":"BR:MACSECJPY"},"MACQJPJ1","C00102","MACQHKHHCSH"]
["BR:MACSEC","Macquarie Capital Securities Sdn. Bhd.","HKD",{"$f":"A20&C20","v":"BR:MACSECHKD"},"MACQHKHHCSH","C00102"]
["BR:MACSEC","Macquarie Capital Securities Sdn. Bhd.","THB",{"$f":"A21&C21","v":"BR:MACSECTHB"},"IBSTTHB1"]
["BR:MACSEC","Macquarie Capital Securities Sdn. Bhd.","SGD",{"$f":"A22&C22","v":"BR:MACSECSGD"},"BSSLSGS1"]
["BR:MACSEC","Macquarie Capital Securities Sdn. Bhd.","IDR",{"$f":"A23&C23","v":"BR:MACSECIDR"},"IBSEIDJ1"]
["BR:MBBINV","Maybank Investment Bank Bhd.","%%","BR:MBBINV%%","MBEAMYKL"]
["BR:MBBINV","CITIBANK N.A, JP","JPY","BR:MBBINVJPY","CITIJPJT",339140,"CITISGSG"]
["BR:MBBINV","Cathay Securities Corporation","TWD","BR:MBBINVTWD","CTSCTWT1"]
["BR:MBBINV","Maybank Investment Bank Bhd.","THB",{"$f":"A27&C27","v":"BR:MBBINVTHB"},"KESATHB1"]
["BR:MBBINV","Maybank Investment Bank Bhd.","KRW",{"$f":"A28&C28","v":"BR:MBBINVKRW"},"KISEKRSE"]
["BR:MBBINV","Maybank Investment Bank Bhd.","SGD",{"$f":"A29&C29","v":"BR:MBBINVSGD"},"MKEESGS1"]
["BR:MBBINV","Maybank Investment Bank Bhd.","NZD",{"$f":"A30&C30","v":"BR:MBBINVNZD"},"CITINZ2X",null,"CITISGSG"]
["BR:MBBINV","Maybank Investment Bank Bhd.","HKD",{"$f":"A31&C31","v":"BR:MBBINVHKD"},"KMESHKH1","B01264"]
["BR:MBBINV","Maybank Investment Bank Bhd.","IDR","BR:MBBINVIDR","KMESIDJ1"]
["BR:MBBINV","Maybank Investment Bank Bhd.","AUD",{"$f":"A33&C33","v":"BR:MBBINVAUD"},"CITIAU3X",20018,"CITISGSG"]
["BR:MIDFAMANAH","MIDF Amanah Investment Bank Bhd.","%%","BR:MIDFAMANAH%%","MIDFMYK1"]
["BR:PBBINV","Public Investment Bank Bhd.","%%","BR:PBBINV%%","SMBBMYK1"]
["BR:RHBINV","RHB Investment Bank Bhd.","%%","BR:RHBINV%%","OSKIMYKL"]
["BR:TASEC","TA Securities Holdings Bhd.","%%","BR:TASEC%%","BOTLMY21"]
["BR:RHBSECHK","CITIGROUP PTY LIMITED","AUD","BR:RHBSECHKAUD","CITIAU3X",20018,"CITIHKHX"]
["BR:RHBSECHK","OSK ASIA SECURITIES LTD","HKD","BR:RHBSECHKHKD","OSKSHKH1","B01607"]
["BR:RHBSECHK","CITIBANK N.A, JP","JPY","BR:RHBSECHKJPY","CITIJPJT",336695,"CITIHKHX"]
["BR:RHBSECHK","Sinopac Securities Co.Ltd","TWD","BR:RHBSECHKTWD","SNPSTWTP"]
["BR:RHBSECHK","RHB Securities Hong Kong Ltd.","THB",{"$f":"A42&C42","v":"BR:RHBSECHKTHB"},"BFSOTHB1"]
["BR:RHBSECHK","PT RHB OSK SECURITIES INDONESIA","IDR","BR:RHBSECHKIDR","ONSNIDJ1"]
["BR:RHBSECHK","RHB Securities Hong Kong Ltd.","SGD",{"$f":"A44&C44","v":"BR:RHBSECHKSGD"},"DASPSGS1"]
["BR:RHBSECHK","RHB Securities Hong Kong Ltd.","NZD",{"$f":"A45&C45","v":"BR:RHBSECHKNZD"},"CITINZ2X",null,"CITIHKHX"]

{"sheet":"MYR upload-BIMB Migration","index":3,"n_rows":36,"n_cols":37,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,{"$f":"\"MIGRATION\" & ROW()-2","v":"MIGRATION-1"}]
["Sender BIC","Trade Date","SettlementDate","OrderType","Func","OrderRef (client ref)","Related Reference","SCAId","Cash Account","SecId","SchemeNum (ISIN)","CounterpartyBic1","CounterpartyBic2","CounterPartyAcct","PSetDet","ClntType","SLBCpty","SettIndicator","BuyrSellBic","Participantid","BuyrSellAcc (CDS)","RtgsIndicator","BeneIndicator","StamIndicator","QuantityQual","Quantity","SettCurrency","SettAmount","TradePlaceCode","TradePlaceNarrative","SettIndicatorDSS","LinkType","RefNumber","FXCCY","SPRO","isAdjustment","RelatedTMID"]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION1",null,132267100053,null,"MYQ0021OO004","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,114000,114000,"MYR",171058.46]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION2",null,132267100053,null,"MYQ0069OO003","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,3635000,3635000,"MYR",901899.64]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION3",null,132267100053,null,"MYQ0166OO007","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,134000,134000,"MYR",274936.40999999997]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION4",null,132267100053,null,"MYL3867OO008","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,44000,44000,"MYR",532875.66]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION5",null,132267100053,null,"MYL4588OO009","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,52000,52000,"MYR",455803.29]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION6",null,132267100053,null,"MYL5005OO003","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,129000,129000,"MYR",410761.14]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION7",null,132267100053,null,"MYL5020OO002","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,99900,99900,"MYR",125446.08]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION8",null,132267100053,null,"MYL5095OO004","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,232000,232000,"MYR",347573.8]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION9",null,132267100053,null,"MYL5101OO000","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,245000,245000,"MYR",209447.73]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION10",null,132267100053,null,"MYL5168OO009","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,59000,59000,"MYR",289447.40000000002]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION11",null,132267100053,null,"MYL6963OO002","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,144000,144000,"MYR",250152.23]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION12",null,132267100053,null,"MYL7022OO006","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,53000,53000,"MYR",270356.96999999997]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION13",null,132267100053,null,"MYL7106OO007","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,206000,206000,"MYR",427893.28]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION14",null,132267100053,null,"MYL7113OO003","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,69000,69000,"MYR",357204.85]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION15",null,132267100053,null,"MYL7153OO009","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,68500,68500,"MYR",435016.97]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION16",null,132267100053,null,"MYL7160OO004","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,81000,81000,"MYR",250438.97]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION17",null,132267100053,null,"MYBVP1202656","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,1000000,1000000,"MYR",1016600]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION18",null,132267100052,null,"MYQ0021OO004","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,130000,130000,"MYR",201835.87]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION19",null,132267100052,null,"MYQ0090OO009","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,90000,90000,"MYR",225773.75]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION20",null,132267100052,null,"MYQ0166OO007","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,528000,528000,"MYR",1084916.72]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION21",null,132267100052,null,"MYL3867OO008","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,87500,87500,"MYR",913726.99]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION22",null,132267100052,null,"MYL4634OO001","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,55000,55000,"MYR",308132.98]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION23",null,132267100052,null,"MYL5005OO003","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,274000,274000,"MYR",898396.73]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION24",null,132267100052,null,"MYL5031OO009","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,63000,63000,"MYR",570877.18000000005]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION25",null,132267100052,null,"MYL5095OO004","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,555000,555000,"MYR",831589.68]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION26",null,132267100052,null,"MYL5107OO007","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,67000,67000,"MYR",247084.05]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION27",null,132267100052,null,"MYL5168OO009","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,159000,159000,"MYR",814324.81]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION28",null,132267100052,null,"MYL6963OO002","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,230000,230000,"MYR",427739.5]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION29",null,132267100052,null,"MYL7022OO006","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,265000,265000,"MYR",1511660.23]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION30",null,132267100052,null,"MYL7113OO003","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,172000,172000,"MYR",951820.82]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION31",null,132267100052,null,"MYL7153OO009","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,111500,111500,"MYR",764731.43]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION32",null,132267100052,null,"MYL7160OO004","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,172000,172000,"MYR",583952.23]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION33",null,132267100052,null,"MYL7216OO004","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,63000,63000,"MYR",283395.12]
["SCBLMYKXXXXX",20170630,20170630,540,null,"MIGRATION34",null,132267100052,null,"MYBVP1202656","ISIN",null,null,null,"MCDSMYK1",null,null,"TRAD",null,null,null,null,null,null,4000000,4000000,"MYR",4048000]