{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cash & Liquidity","CrCn","InFund","InSecurity","InTB","InCBCC","InTFHol"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":0,"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":"Cash & Liquidity","index":0,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,1,4,2],[5,1,5,2],[2,4,2,6],[3,4,3,6],[2,1,2,2],[3,1,3,2]]}
[null,"FEEDER FUND CASH MANAGEMENT"]
[]
[null,"Fund Code:",null,"GD1",{"$f":"UPPER(VLOOKUP(FeederFund,InFund!A:B,2,0))","v":"BIMB-ARABESQUE I GLOBAL DIVIDEND FUND 1"}]
[null,"Target Fund (Security Code):",null,"LU1245544975",{"$f":"UPPER(VLOOKUP(TargetFund,InSecurity!A:B,2,0))","v":"ARABESQUE Q3.17 SICAV SYSTEMATIC (USD)"}]
[null,"Last Value Date:",null,"2018-09-03"]
[null,"Value Date:",null,"2018-09-04"]
[null,"Exchange Rate (USD/MYR)",null,4.1379999999999999,"Using Currency Rate Dated : 04-Sep-2018"]
[null,"Target Fund Price (t or last available)",null,118.63]
[]
[null,null,null,null,null,null,"Summary"]
[null,null,null,{"$f":"VLOOKUP(FeederFund,InFund!A:C,3,0)","v":"USD"},null,null,null,"%",null,"UNITS",null,{"$f":"VLOOKUP(FeederFund,InFund!A:C,3,0)","v":"USD"}]
[null,null,"New Cash - USD:",{"$f":"SUMIFS(CrCn!F:F,CrCn!B:B,\">\"&D$5,CrCn!B:B,\"<=\"&D$6,CrCn!E:E,\"USD\")","v":0},null,null,"Analysis"]
[null,null,"New Cash - MYR:",{"$f":"SUMIFS(CrCn!F:F,CrCn!B:B,\">\"&D$5,CrCn!B:B,\"<=\"&D$6,CrCn!E:E,\"MYR\")/D7","v":0},null,null,"Last TB Close NAV",null,null,null,null,{"$f":"SUMPRODUCT((InTB!$A$3:$A$5001=D5)*InTB!$K$3:$K$5001)+D12+D13","v":161605527.06}]
[null,null,"Bank Balance:",null,null,null,"Minimum Target Investment",0.7,null,null,null,{"$f":"ROUNDDOWN(H14*L13,-5)","v":113100000}]
[null,null,"MYR",{"$f":"SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(InTB!$D$3:$D$5001=C15)*(LEFT(InTB!$E$3:$E$5001,1)=\"5\")*InTB!$K$3:$K$5001)","v":72661.94}]
[null,null,"USD",{"$f":"SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(InTB!$D$3:$D$5001=C16)*(LEFT(InTB!$E$3:$E$5001,1)=\"5\")*InTB!$K$3:$K$5001)","v":365555.17},null,null,"Current Holding",null,null,{"$f":"L16/TFPrice","v":1289343},null,{"$f":"SUMIF(InTFHol!E:E,TargetFund,InTFHol!J:J)","v":152954760.09}]
[null,null,"Money Market:",{"$f":"SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(LEFT(InTB!$E$3:$E$5001,6)=\"100000\")*(LEFT(InTB!$F$3:$F$5001,1)=\"2\")*InTB!$K$3:$K$5001)+SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(LEFT(InTB!$E$3:$E$5001,6)=\"139000\")*(LEFT(InTB!$F$3:$F$5001,1)=\"2\")*InTB!$K$3:$K$5001)+SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(LEFT(InTB!$E$3:$E$5001,6)=\"199000\")*(LEFT(InTB!$F$3:$F$5001,1)=\"2\")*InTB!$K$3:$K$5001)","v":6008475.3399999999},null,null,"Booking Trade","2019-06-13",null,11531,null,{"$f":"ROUNDUP(J17*TFPrice,-5)","v":1400000}]
[" ",null,"Creation/Cancellation:",null,null,null,"Booking Trade",null,null,null,null,{"$f":"ROUNDUP(J18*TFPrice,-5)","v":0}]
[null,null,"Debtor",{"$f":"SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(LEFT(InTB!$E$3:$E$5001,6)=\"200800\")*InTB!$K$3:$K$5001)-SUMPRODUCT((RIGHT(InCBCC!$G$3:$G$500,6)=\"200800\")*InCBCC!$J$3:$J$500)","v":3606104.4899999998},null,null,"Booking Trade",null,null,null,null,{"$f":"ROUNDUP(J19*TFPrice,-5)","v":0}]
[null,null,"Creditor",{"$f":"SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(LEFT(InTB!$E$3:$E$5001,6)=\"300800\")*InTB!$K$3:$K$5001)-SUMPRODUCT((RIGHT(InCBCC!$G$3:$G$500,6)=\"300800\")*InCBCC!$J$3:$J$500)","v":0},null,null,"Total Porfolio holding to date",{"$f":"ValueDate","v":"2018-09-04"},null,null,null,{"$f":"SUM(L16:L19)","v":154354760.09}]
[null,null,"Security Transaction:"]
[null,null,"Debtor",{"$f":"SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(LEFT(InTB!$E$3:$E$5001,3)=\"200\")*InTB!$K$3:$K$5001)-SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(LEFT(InTB!$E$3:$E$5001,6)=\"200800\")*InTB!$K$3:$K$5001)","v":0},null,null,"Mandatory Transaction"]
[null,null,"Creditor",{"$f":"SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(LEFT(InTB!$E$3:$E$5001,3)=\"300\")*InTB!$K$3:$K$5001)-SUMPRODUCT((InTB!$A$3:$A$5001=D5)*(LEFT(InTB!$E$3:$E$5001,6)=\"300800\")*InTB!$K$3:$K$5001)","v":-1201722.8600000001},null,null,"Value (Creation)",null,null,{"$f":"ROUNDDOWN(L23/TFPrice,0)","v":0},null,{"$f":"IF(MAX(0,L14-L20)>=0,MAX(0,L14-L20),0)","v":0}]
[null,null,null,null,null,null,"Units (Redemption)",null,null,null,null,{"$f":"IF(MAX(0,L14-L16)<0,IF(TFPrice=0,0,ROUNDDOWN(L23/TFPrice,0)),0)","v":0}]
[null,null,"Total Liquidity:",{"$f":"SUM(D12:D23)","v":8851074.0800000001}]
[null,null,null,null,null,null,"Transaction for Target of",0.97,null,null,null,{"$f":"ROUNDDOWN(H26*L13,-5)","v":156700000}]
[null,null,"Estimate Unit Create/Redeem:",{"$f":"IF(TFPrice = 0,0,ROUNDDOWN(D25/TFPrice,0))","v":74610},null,null,"Value (Creation)",null,null,{"$f":"ROUNDDOWN(L27/TFPrice,0)","v":20230},null,{"$f":"ROUNDDOWN(IF(H26*L13-L20>=0,H26*L13-L20,0),-5)","v":2400000}]
[null,null,"Estimate Value Create/Redeem:",{"$f":"ROUNDDOWN(D25,0)","v":8851074},null,null,"Units (Redemption)",null,null,{"$f":"-ROUNDDOWN(L28/TFPrice,0)","v":0},null,{"$f":"ROUNDDOWN(IF(H26*L13-L20<=0,H26*L13-L20,0),-5)","v":0}]
[]
[null,null,null,null,null,null,"Take Profit"]
[null,null,null,null,null,null,"Target",0.25]
[null,null,null,null,null,null,"Current Holding (USD)",null,null,null,null,{"$f":"L20-SUMIFS(InTFHol!J:J,InTFHol!E:E,TargetFund,InTFHol!A:A,\"FO\")","v":154354760.09}]
[null,null,null,null,null,null,"Current Holding (Units)",null,null,null,null,{"$f":"J16","v":1289343}]
[null,null,null,null,null,null,"Current Gains (100% holdings in TF):",null,null,null,null,{"$f":"SUMIF(InTFHol!E:E,TargetFund,InTFHol!L:L)+SUMIF(InTFHol!E:E,TargetFund,InTFHol!M:M)","v":10108809.279999999}]
[null,null,null,null,null,null,"% Gains:",null,null,null,null,{"$f":"IF(L32=0,0,L34/L32)","v":6.5490751785729384E-2}]
[null,null,null,null,null,null,"Remarks:",null,null,null,null,{"$f":"IF(L35>=H31,\"TAKE PROFIT\",\"N/A\")","v":"N/A"}]
[null,null,null,null,null,null,"Redeem Unit (Take Profit)",null,null,null,null,{"$f":"ROUNDDOWN(IF(TFPrice=0,0,H31*L32/TFPrice),0)","v":325286}]
[null,null,null,null,null,null,"Realised gain from redeem units",null,null,null,null,{"$f":"ROUND(H31*L34,2)","v":2527202.3199999998}]

{"sheet":"CrCn","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Key Date","Value Date","Fund Code","Creation / Redeem","Currency","Proceed"]
["2015-09-01","2015-09-01","GIP1","Create","MYR",500000]
["2015-09-01","2015-09-01","GIP1","Create","USD",1000000]
["2015-09-02","2015-09-02","GIP1","Create","MYR",20000000]
["2015-09-02","2015-09-02","GIP1","Create","USD",10000000]
["2015-09-03","2015-09-03","GIP1","Create","MYR",25025]
["2015-09-03","2015-09-03","GIP1","Create","USD",400480]

{"sheet":"InFund","index":2,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["qFundCode","FundName","FundCurrency"]
["BAPAC","BIMB-ARABESQUE ASIA PACIFIC","USD"]
["BAPACMYR","BAPAC (MYR)","MYR"]
["BAPACUSD","BAPAC (USD)","USD"]
["BICMF","BIMB I Cash Management Fund","MYR"]
["BICMF3","BIMB I Cash Management Fund 3","MYR"]
["BIMMF","BIMB Invest Money Market Fund","MYR"]
["BIW","BIMB Invest Wafiyah","MYR"]
["BMSEF","BIMB-Arabesque Malaysia Shariah-ESG Equity Fund","MYR"]
["BMSEFEUR","BMSEF (EUR)","EUR"]
["BMSEFMYR","BMSEF (MYR)","MYR"]
["BMSEFSGD","BMSEF (SGD)","SGD"]
["BMSEFUSD","BMSEF (USD)","USD"]
["BSF","BIMB ESG Sukuk Fund","MYR"]
["BSF-Class A","BSF-Class A","MYR"]
["BSF-Class B","BSF-Class B","USD"]
["BSF-Class C","BSF-Class C","SGD"]
["BSF-Class D","BSF-Class D","MYR"]
["BSF-Class E","BSF-Class E","USD"]
["BVMSEF","BIMB-Arabesque Valuecap Malaysia Shariah-ESG Eqt","MYR"]
["GD1","BIMB-Arabesque i Global Dividend Fund 1","USD"]
["GD1MYR","BIMB-Arabesque i Global Dividend Fund 1 (MYR)","MYR"]
["GD1RM","BIMB i Global Dividend Fund 1 (MYR)","MYR"]
["GD1USD","BIMB-Arabesque i Global Dividend Fund 1 (USD)","USD"]
["IB","BIMB Dana Al-Fakhim","MYR"]
["ID","BIMB Dana Al-Falah","MYR"]
["IF","BIMB I Flexi Fund","MYR"]
["IP","BIMB I Dividend Fund","MYR"]
["IS","BIMB Dana Al-Munsif","MYR"]
["TP","BIMB I Growth","MYR"]

{"sheet":"InSecurity","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["qStockCode","StockName","Description","Stock Currency"]
["0821EA","MYETFDJ","MYETF DOW JONES ISLAMIC MARKET MALAYSIA","MYR"]
[1155,"MAYBANK","Malayan Banking Berhad","MYR"]
[4324,"HENGYUAN","HENGYUAN REFINING COMPANY BERHAD","MYR"]
[5110,"UOAREIT","UOA Reits","MYR"]
[5120,"AMFIRST","AMFIRST Reits","MYR"]
[5131,"ZHULIAN","ZHULIAN Corporation Berhad","MYR"]
[5878,"KPJ","KPJ Healthcare Berhad","MYR"]
["LU1245544975","Arabesque Q3.17 SICAV Systematic (USD)","Arabesque Q3.17 SICAV - Arabesque Q3.17 Systematic (USD)","USD"]

{"sheet":"InTB","index":4,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
["TBDate","GLCode","qFundCode","qCurrencyCode","ShortGL","qAssetAccType","DebitAmt","CreditAmt","SumDrCr","Ex Rate","SumDrCrFC"]
["2018-09-03","GD1-MYR000-200800","GD1","MYR",200800,"000",442057535.56999999,-434791707.41000003,7265828.1600000001,0.2422,1759783.58]
["2018-09-03","GD1-MYR000-500000","GD1","MYR",500000,"000",2390519142.5300002,-2390219134.5100002,300008.02,0.2422,72661.94]
["2018-09-03","GD1-USD000-200800","GD1","USD",200800,"000",7082893.3300000001,-5235251.1100000003,1847642.22,1,1847642.22]
["2018-09-03","GD1-USD000-220103","GD1","USD",220103,"000",1044782.04,-935131.88,109650.16,1,109650.16]
["2018-09-03","GD1-USD000-300300","GD1","USD",300300,"000",0,-1201722.8600000001,-1201722.8600000001,1,-1201722.8600000001]
["2018-09-03","GD1-USD000-320103","GD1","USD",320103,"000",2376569.35,-2631280.79,-254711.44,1,-254711.44]
["2018-09-03","GD1-USD000-320104","GD1","USD",320104,"000",65249.25,-73739.62,-8490.3700000000008,1,-8490.3700000000008]
["2018-09-03","GD1-USD000-320105","GD1","USD",320105,"000",8141.84,-11715.23,-3573.39,1,-3573.39]
["2018-09-03","GD1-USD000-320107","GD1","USD",320107,"000",4040.62,-5237.5,-1196.8800000000001,1,-1196.8800000000001]
["2018-09-03","GD1-USD000-320209","GD1","USD",320209,"000",38269.65,-42898.97,-4629.32,1,-4629.32]
["2018-09-03","GD1-USD000-320883","GD1","USD",320883,"000",3.11,0,3.11,1,3.11]
["2018-09-03","GD1-USD000-500000","GD1","USD",500000,"000",174936543.34,-174570988.16999999,365555.17,1,365555.17]
["2018-09-03","GD1-USD210-100000","GD1","USD",100000,"210",345337397.69,-339312063.64999998,6025334.04,1,6025334.04]
["2018-09-03","GD1-USD210-139000","GD1","USD",139000,"210",1931,0,1931,1,1931]
["2018-09-03","GD1-USD210-199000","GD1","USD",199000,"210",0,-18789.7,-18789.7,1,-18789.7]
["2018-09-03","GD1-USD415-100000","GD1","USD",100000,"415",165673265.69999999,-22827314.890000001,142845950.81,1,142845950.81]
["2018-09-03","GD1-USD415-189000","GD1","USD",189000,"415",10070128.99,0,10070128.99,1,10070128.99]
["2018-09-04","GD1-MYR000-200800","GD1","MYR",200800,"000",442057535.56999999,-435403288.5,6654247.0700000003,0.24129999999999999,1605669.82]
["2018-09-04","GD1-MYR000-500000","GD1","MYR",500000,"000",2406487876.8200002,-2405568368.1100001,919508.71,0.24129999999999999,221877.45]
["2018-09-04","GD1-USD000-200800","GD1","USD",200800,"000",7082893.3300000001,-5235251.1100000003,1847642.22,1,1847642.22]
["2018-09-04","GD1-USD000-220103","GD1","USD",220103,"000",1044782.04,-935131.88,109650.16,1,109650.16]
["2018-09-04","GD1-USD000-300300","GD1","USD",300300,"000",0,-1201722.8600000001,-1201722.8600000001,1,-1201722.8600000001]
["2018-09-04","GD1-USD000-320103","GD1","USD",320103,"000",2376569.35,-2631280.79,-254711.44,1,-254711.44]
["2018-09-04","GD1-USD000-320104","GD1","USD",320104,"000",65249.25,-73739.62,-8490.3700000000008,1,-8490.3700000000008]
["2018-09-04","GD1-USD000-320105","GD1","USD",320105,"000",8141.84,-11715.23,-3573.39,1,-3573.39]
["2018-09-04","GD1-USD000-320107","GD1","USD",320107,"000",4040.62,-5237.5,-1196.8800000000001,1,-1196.8800000000001]
["2018-09-04","GD1-USD000-320209","GD1","USD",320209,"000",38269.65,-42898.97,-4629.32,1,-4629.32]
["2018-09-04","GD1-USD000-320883","GD1","USD",320883,"000",3.11,0,3.11,1,3.11]
["2018-09-04","GD1-USD000-500000","GD1","USD",500000,"000",175786467.22999999,-174570988.16999999,1215479.06,1,1215479.06]
["2018-09-04","GD1-USD210-100000","GD1","USD",100000,"210",348195577.73000002,-343049366.68000001,5146211.05,1,5146211.05]
["2018-09-04","GD1-USD210-139000","GD1","USD",139000,"210",664.88,0,664.88,1,664.88]
["2018-09-04","GD1-USD210-199000","GD1","USD",199000,"210",0,-5529.32,-5529.32,1,-5529.32]
["2018-09-04","GD1-USD415-100000","GD1","USD",100000,"415",165673265.69999999,-22827314.890000001,142845950.81,1,142845950.81]
["2018-09-04","GD1-USD415-189000","GD1","USD",189000,"415",10108809.279999999,0,10108809.279999999,1,10108809.279999999]

{"sheet":"InCBCC","index":5,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["qEventTrxID","qTrnCode","qFundCode","AccDate","PayDate","SCNetProceed","AccSCNetProceed","SettCurrency","ExRate","FCAmount"]
["CSH*180900065I","CB","GD1","2018-09-03","2018-09-13",5455.46,"GD1-MYR000-200800","MYR",0.2422,1321.31]

{"sheet":"InTFHol","index":6,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["Office","HistoryDate","qProductType","qFundCode","qStockCode","UnitFaceValue","CostSC","CostFC","MarketValueSC","MarketValueFC","RefMarketValueFC","UnrealisedGainsStock","UnrealisedGainsExchg"]
["BO","2018-09-04","EQT","GD1","LU1245544975",1289343,142845950.81,142845950.81,152954760.09,152954760.09,152954760.09,10108809.279999999,0]