{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","EquityPortfolio","Data"],"not_rendered":{"charts":0,"images":0,"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":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"TNB-RBTF"]
[null,"Nomura Equity Portfolio",null,null,null,null,null,"TNB-RBTFI"]
[null,null,null,null,"Fund ","Output File Name","Date Format",{"$f":"EOMONTH(ValueDate,0)","v":"2022-03-31"}]
[null,"Fund Code:","TNB-RBTFI",null,"TNB-RBTF","Nomura-RBTF-Equity Portfolio (Islamic)",{"$f":"ROUNDUP(MONTH(ValueDate)/3,0) & \"Q\" & YEAR(ValueDate)","v":"1Q2022"},{"$f":"EOMONTH(ValueDate,-1) + 1","v":"2022-03-01"}]
[null,null,null,null,null,null,null,{"$f":"ValueDate-1","v":"2022-03-30"}]
[null,"Value Date:","2022-03-31"]
[]
[null,"Output File Name:",{"$f":"F4","v":"Nomura-RBTF-Equity Portfolio (Islamic)"}]
[]
[null,"Output Path:","ThisWorkbook.Path"]

{"sheet":"EquityPortfolio","index":1,"n_rows":129,"n_cols":11,"rows_kept":129,"cut":false,"hidden":false,"merged":[[125,1,125,2],[123,1,123,2],[124,3,124,4],[124,5,124,6],[3,8,3,9],[124,1,124,2],[124,7,124,8],[126,3,126,4],[126,5,126,6],[126,7,126,8],[123,7,123,8],[123,3,123,4],[123,5,123,6],[125,3,125,4],[125,5,125,6],[125,7,125,8]]}
[]
[]
[null,"RETIREMENT BENEFIT TRUST FUND"]
[null,"MONTHLY PORTFOLIO SUMMARY REPORT for NOMURA",null,null,null,null,null,null,{"$f":"ValueDate","v":"2022-03-31"}]
[null,"SECURITY","QUANTITY","AVE.","TOTAL","CURR.","GROSS","UNREALISED GAIN OR",null,"HOLDING ON"]
[null,null,null,"PRICE","COST","PRICE","CURR. VALUE","(LOSS)",null,"COST","VALUE"]
[null,null,"(UNITS)","(RM)","(RM)","(RM)","(RM)","(RM)","(%)","(%)","(%)"]
[]
[null,"CLOSED END FUND"]
["","","","","","","","","","",""]
["","","","","","","","","","",""]
[]
[null,"SUB-TOTAL",0,null,0,null,0,0,0,0,0]
[]
[null,"CONSTRUCTION"]
[1,"GAMUDA BHD",2096381,3.05,6393962.0499999998,3.46,7253478.2599999998,859516.21,13.44,2.2656419054355408,2.6861968653666302]
[2,"IJM CORP BHD",3550000,1.87,6638500,1.67,5928500,-710000,-10.7,2.3522916888807366,2.1955146959144631]
[3,"SUNWAY CONSTRUCTION GROUP BH",2300000,1.66,3818000,1.72,3956000,138000,3.61,1.3528733400838522,1.4650343488298245]
[]
[null,"SUB-TOTAL",7946381,null,16850462.050000001,null,17137978.259999998,287516.20999999996,1.7062808672359222,5.9708069344001293,6.3467459101109167]
[]
[null,"CONSUMER PRODUCTS & SERVICES"]
[1,"FARM FRESH BHD",188600,1.36,257308.87,1.64,309304,51995.13,20.21,9.1175042008931825E-2,0.11454524373874117]
[2,"MR DIY GROUP M BHD",682200,3.9,2660580,3.46,2360412,-300168,-11.28,0.94275216112108318,0.87413666769213949]
[3,"NESTLE (MALAYSIA) BERHAD",37700,134.80000000000001,5081960,133.6,5036720,-45240,-0.89,1.8007459925019731,1.8652598092614141]
[4,"QL RESOURCES BHD",1724900,5.45,9394915.5800000001,5.0199999999999996,8658998,-735917.58,-7.83,3.3290023102463127,3.2067061416705647]
[]
[null,"SUB-TOTAL",2633400,null,17394764.449999999,null,16365434,-1029330.45,-5.9174727715269526,6.1636755058783006,6.0606478623628597]
[]
[null,"ENERGY"]
[1,"DIALOG GROUP BHD",590000,2.39,1408643.55,2.74,1616600,207956.45,14.76,0.49913994355056962,0.59867910220381559]
[]
[null,"SUB-TOTAL",590000,null,1408643.55,null,1616600,207956.45,14.762886608184164,0.49913994355056962,0.59867910220381559]
[]
[null,"FINANCIAL SERVICES"]
[1,"BANK ISLAM MALAYSIA BHD",3465000,3.14,10896223.449999999,2.95,10221750,-674473.45,-6.19,3.8609770070983487,3.7854435933142718]
[2,"BURSA MALAYSIA BHD",410000,6.89,2825654.55,7.07,2898700,73045.45,2.59,1.0012448163912087,1.0734820695027838]
[3,"SYARIKAT TAKAFUL MALAYSIA KE",2140700,4.38,9376266,3.63,7770741,-1605525,-17.12,3.3223940023401415,2.877755935505617]
[]
[null,"SUB-TOTAL",6015700,null,23098144,null,20891191,-2206953,-9.5546767740299821,8.1846158258296988,7.7366815983226722]
[]
[null,"HEALTH CARE"]
[1,"IHH HEALTHCARE BHD",1899300,6.54,12421422,6.2,11775660,-645762,-5.2,4.4014171476508759,4.3609065672753822]
[]
[null,"SUB-TOTAL",1899300,null,12421422,null,11775660,-645762,-5.1987767584097861,4.4014171476508759,4.3609065672753822]
[]
[null,"INDUSTRIAL PRODUCTS & SERVICES"]
[1,"PETRONAS CHEMICALS GROUP BHD",1840000,8.64,15894449.74,9.6,17664000,1769550.26,11.13,5.6320527261782916,6.5415487203564266]
[2,"PRESS METAL ALUMINIUM HOLDIN",2185000,5.58,12192300,6.2,13547000,1354700,11.11,4.3202298649304218,5.0168908805858532]
[3,"SCIENTEX BHD",2013800,4.53,9130558.3000000007,4.0599999999999996,8176028,-954530.3,-10.45,3.235329728693384,3.0278467788155745]
[4,"SKP RESOURCES BHD",1354575,1.84,2492418,1.41,1909950.75,-582467.25,-23.37,0.88316549621401641,0.70731634310497604]
[5,"SUNWAY BHD",5571504,1.75,9750132,1.75,9750132,0,0,3.4548699960970271,3.6107882420689674]
[6,"UCHI TECHNOLOGIES BHD",1938700,3.18,6165066,3.02,5854874,-310192,-5.03,2.1845346860286523,2.1682486142746891]
[]
[null,"SUB-TOTAL",14903579,null,55624924.040000007,null,56901984.75,1277060.71,2.2958426137924484,19.710182498141798,21.072639579206488]
[]
[null,"PLANTATION"]
[1,"KUALA LUMPUR KEPONG BHD",335000,22.68,7598123.6699999999,25.2,8442000,843876.33,11.11,2.6923255494507798,3.1263447858496916]
[]
[null,"SUB-TOTAL",335000,null,7598123.6699999999,null,8442000,843876.33,11.10637792501211,2.6923255494507798,3.1263447858496916]
[]
[null,"PROPERTY"]
[1,"ECO WORLD DEVELOPMENT GROUP",5529900,0.83,4591320.5,0.99,5474601,883280.5,19.239999999999998,1.626892378268848,2.0274212616628176]
[]
[null,"SUB-TOTAL",5529900,null,4591320.5,null,5474601,883280.5,19.238049271445981,1.626892378268848,2.0274212616628176]
[]
[null,"REAL ESTATE INVESTMENT TRUSTS"]
[1,"AXIS REAL ESTATE INVESTMENT",7000000,1.93,13510000,1.86,13020000,-490000,-3.63,4.7871447942726144,4.8217257891214151]
[2,"KLCCP STAPLED GROUP",1722100,6.55,11279755,6.56,11296976,17221,0.15,3.9968778999941152,4.1836344484090384]
[]
[null,"SUB-TOTAL",8722100,null,24789755,null,24316976,-472779,-1.9071547903559354,8.7840226942667297,9.0053602375304536]
[]
[null,"TECHNOLOGY"]
[1,"CTOS DIGITAL BHD",2019300,1.83,3705388.47,1.58,3190494,-514894.47,-13.9,1.3129704755675995,1.1815427956864162]
[2,"D&O GREEN TECHNOLOGIES BHD",1215000,5.54,6727406.1799999997,4.5,5467500,-1259906.18,-18.73,2.383794779685005,2.024791532413313]
[3,"DAGANG NEXCHANGE BHD",5240000,1.1299999999999999,5937699.0800000001,1.01,5292400,-645299.07999999996,-10.87,2.103969299835625,1.9599463568622255]
[4,"KESM INDUSTRIES BHD",360600,12.28,4428168,8.6,3101160,-1327008,-29.97,1.5690807838167709,1.14845953519138]
[5,"MALAYSIAN PACIFIC INDUSTRIES",154900,43.49,6736622.5199999996,36.4,5638360,-1098262.52,-16.3,2.3870605053736242,2.08806649925888]
[6,"UWC BHD",1406400,5.56,7819584,3.91,5499024,-2320560,-29.68,2.7707979895616157,2.0364658860059599]
[7,"VITROX CORP BHD",736600,9.5,6997700,8.1999999999999993,6040120,-957580,-13.68,2.4795709198283844,2.2368511807517697]
[]
[null,"SUB-TOTAL",11132800,null,42352568.25,null,34229058,-8123510.25,-19.180679202376353,15.007244753668624,12.676123786169944]
[]
[null,"TELECOMMUNICATIONS & MEDIA"]
[1,"AXIATA GROUP BERHAD",1987200,4.04,8028288,3.79,7531488,-496800,-6.19,2.844750340941621,2.7891528356419713]
[2,"DIGI.COM BHD",1890000,4.4800000000000004,8467200,3.9,7371000,-1096200,-12.95,3.0002747891980075,2.729718954809059]
[3,"TELEKOM MALAYSIA BHD",1230000,5.7,7009283.5899999999,4.8899999999999997,6014700,-994583.59,-14.19,2.4836754588785319,2.2274373351634851]
[4,"TIME DOTCOM BHD",1270000,4.58,5822769.1100000003,4.3,5461000,-361769.11,-6.21,2.0632449173344103,2.022384372841171]
[]
[null,"SUB-TOTAL",6377200,null,29327540.699999999,null,26378188,-2949352.6999999997,-10.056597415275261,10.39194550635257,9.7686934984556864]
[]
[null,"TRANSPORTATION & LOGISTICS"]
[1,"MISC BHD",715000,7.35,5257670.55,7.35,5255250,-2420.5500000000002,-0.05,1.8630074169824526,1.9461885140768291]
[2,"WESTPORTS HOLDINGS BHD",1735800,4.32,7499391.9100000001,4,6943200,-556191.91,-7.42,2.6573408543424621,2.5712908217379269]
[]
[null,"SUB-TOTAL",2450800,null,12757062.460000001,null,12198450,-558612.46000000008,-4.3788486710913226,4.5203482713249148,4.5174793358147562]
[]
[null,"UTILITIES"]
[1,"MEGA FIRST CORP BHD",1643140,3.52,5783852.7999999998,3.72,6112480.7999999998,328628,5.68,2.0494552792271716,2.263648718039132]
[2,"PETRONAS GAS BHD",283700,16.760000000000002,4754812,16.66,4726442,-28370,-0.6,1.6848240942668364,1.7503538619190935]
[]
[null,"SUB-TOTAL",1926840,null,10538664.800000001,null,10838922.800000001,300258,2.8491085512084982,3.7342793734940081,4.0140025799582251]
[]
[null,"EQUITY TOTAL",70463000,null,258753395.47000006,null,246567043.81,-12186351.66,-4.7096393219747679,91.686896382277865,91.311726104923707]
[]
[]
[null,"MALAYSIAN RINGGIT"]
[1,"MONEY MARKET",null,null,22087000,null,22087000,null,null,7.826326208075443,8.1795282261386095]
[2,"CASH",null,null,107155.18,null,107155.18,null,null,3.796945685539193E-2,3.9683018037169525E-2]
[3,"OUTSTANDING INCOME RECEIVED",null,null,1173647.01,null,1173647.01,null,null,0.41587107137195556,0.43463932837497993]
[4,"OUTSTANDING PURCHASES SETTLEMENT",null,null,0,null,0,null,null,0,0]
[5,"SHORT TERM INTEREST CALCULATION",null,null,0,null,0,null,null,0,0]
[6,"DIVIDEND RECEIVABLES",null,null,295670.36,null,295670.36,null,null,0.10476808472943819,0.10949626727271987]
[null,"LIQUIDITY TOTAL",null,null,23663472.550000001,null,23663472.550000001,null,null,8.3849348210322283,8.7633468398234786]
[]
[1,"Management Fee Accrual as of previous month",null,null,-133513.04999999999,null,-133513.04999999999,null,null,-4.7309126741299723E-2,-4.9444187125134931E-2]
[]
[null,"GROSS ASSET VALUE",null,null,282283354.97000003,null,270097003.31]
[]
[1,"Management Fee Accrual as of current month",null,null,-69204.77,null,-69204.77,null,null,-2.4522076568788572E-2,-2.56287576220596E-2]
[]
[null,"NET ASSET VALUE",null,null,282214150.20000005,null,270027798.54000002,-12186351.66,null,100,100]
[]
[null,"Performance Summary                                          Rate of Return in % (TWRR)"]
[null,"Total Portfolio"]
[null,"Equities only"]
[null,"KL Composite Index",{"$error":"#N/A"}]
[]
[null,"* Investment breach"]

{"sheet":"Data","index":2,"n_rows":38,"n_cols":23,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["qFundCode","qStockCode","StockName","UnitFaceValue","PriceCurr","CostSC","MarketValueSC","AvgPrice","qIntSector","SectorName","UnRealisedGL","UnRealisedGLPerc",null,"TBDate","qFundCode","qCurrencyCode","ShortGL","qAssetAccType","TotalAmount"]
["TNB-RBTFI","6359881","GAMUDA BHD",2096381,3.46,6393962.0499999998,7253478.2599999998,3.05,1,"CONSTRUCTION",859516.21,13.44,null,"2022-03-31","TNB-RBTFI","MYR",100000,210,22087000,null,"TNB-RBTFI","TNBRBI-MYR000-320103",-202717.82]
["TNB-RBTFI","6455217","IJM CORP BHD",3550000,1.67,6638500,5928500,1.87,1,"CONSTRUCTION",-710000,-10.7,null,"2022-03-31","TNB-RBTFI","MYR",200000,10,1173647.01,null,"TNB-RBTFI","TNBRBI-MYR000-320103",-69204.77]
["TNB-RBTFI","BX909K4","SUNWAY CONSTRUCTION GROUP BH",2300000,1.72,3818000,3956000,1.66,1,"CONSTRUCTION",138000,3.61,null,"2022-03-31","TNB-RBTFI","MYR",299000,10,295670.36]
["TNB-RBTFI","BNDMT28","FARM FRESH BHD",188600,1.64,257308.87,309304,1.36,2,"CONSUMER PRODUCTS & SERVICES",51995.13,20.21,null,"2022-03-31","TNB-RBTFI","MYR",500000,0,107155.18]
["TNB-RBTFI","BN4JBJ9","MR DIY GROUP M BHD",682200,3.46,2660580,2360412,3.9,2,"CONSUMER PRODUCTS & SERVICES",-300168,-11.28]
["TNB-RBTFI","6629335","NESTLE (MALAYSIA) BERHAD",37700,133.6,5081960,5036720,134.80000000000001,2,"CONSUMER PRODUCTS & SERVICES",-45240,-0.89]
["TNB-RBTFI","B00G234","QL RESOURCES BHD",1724900,5.0199999999999996,9394915.5800000001,8658998,5.45,2,"CONSUMER PRODUCTS & SERVICES",-735917.58,-7.83]
["TNB-RBTFI","B00MRS2","DIALOG GROUP BHD",590000,2.74,1408643.55,1616600,2.39,3,"ENERGY",207956.45,14.76]
["TNB-RBTFI","6100379","BANK ISLAM MALAYSIA BHD",3465000,2.95,10896223.449999999,10221750,3.14,4,"FINANCIAL SERVICES",-674473.45,-6.19]
["TNB-RBTFI","B06FV38","BURSA MALAYSIA BHD",410000,7.07,2825654.55,2898700,6.89,4,"FINANCIAL SERVICES",73045.45,2.59]
["TNB-RBTFI","6808123","SYARIKAT TAKAFUL MALAYSIA KE",2140700,3.63,9376266,7770741,4.38,4,"FINANCIAL SERVICES",-1605525,-17.12]
["TNB-RBTFI","B83X6P8","IHH HEALTHCARE BHD",1899300,6.2,12421422,11775660,6.54,5,"HEALTH CARE",-645762,-5.2]
["TNB-RBTFI","B5KQGT3","PETRONAS CHEMICALS GROUP BHD",1840000,9.6,15894449.74,17664000,8.64,6,"INDUSTRIAL PRODUCTS & SERVICES",1769550.26,11.13]
["TNB-RBTFI","BF0J5S4","PRESS METAL ALUMINIUM HOLDIN",2185000,6.2,12192300,13547000,5.58,6,"INDUSTRIAL PRODUCTS & SERVICES",1354700,11.11]
["TNB-RBTFI","B1VZ5G1","SCIENTEX BHD",2013800,4.0599999999999996,9130558.3000000007,8176028,4.53,6,"INDUSTRIAL PRODUCTS & SERVICES",-954530.3,-10.45]
["TNB-RBTFI","B03DHR1","SKP RESOURCES BHD",1354575,1.41,2492418,1909950.75,1.84,6,"INDUSTRIAL PRODUCTS & SERVICES",-582467.25,-23.37]
["TNB-RBTFI","B6VGS93","SUNWAY BHD",5571504,1.75,9750132,9750132,1.75,6,"INDUSTRIAL PRODUCTS & SERVICES",0,0]
["TNB-RBTFI","B00PSW2","UCHI TECHNOLOGIES BHD",1938700,3.02,6165066,5854874,3.18,6,"INDUSTRIAL PRODUCTS & SERVICES",-310192,-5.03]
["TNB-RBTFI","6497446","KUALA LUMPUR KEPONG BHD",335000,25.2,7598123.6699999999,8442000,22.68,7,"PLANTATION",843876.33,11.11]
["TNB-RBTFI","6773737","ECO WORLD DEVELOPMENT GROUP",5529900,0.99,4591320.5,5474601,0.83,8,"PROPERTY",883280.5,19.239999999999998]
["TNB-RBTFI","B0CMCL8","AXIS REAL ESTATE INVESTMENT",7000000,1.86,13510000,13020000,1.93,9,"REAL ESTATE INVESTMENT TRUSTS",-490000,-3.63]
["TNB-RBTFI","B92NSW7","KLCCP STAPLED GROUP",1722100,6.56,11279755,11296976,6.55,9,"REAL ESTATE INVESTMENT TRUSTS",17221,0.15]
["TNB-RBTFI","BN7GZ51","CTOS DIGITAL BHD",2019300,1.58,3705388.47,3190494,1.83,10,"TECHNOLOGY",-514894.47,-13.9]
["TNB-RBTFI","B05DWZ2","D&O GREEN TECHNOLOGIES BHD",1215000,4.5,6727406.1799999997,5467500,5.54,10,"TECHNOLOGY",-1259906.18,-18.73]
["TNB-RBTFI","6891833","DAGANG NEXCHANGE BHD",5240000,1.01,5937699.0800000001,5292400,1.1299999999999999,10,"TECHNOLOGY",-645299.07999999996,-10.87]
["TNB-RBTFI","6489755","KESM INDUSTRIES BHD",360600,8.6,4428168,3101160,12.28,10,"TECHNOLOGY",-1327008,-29.97]
["TNB-RBTFI","6556693","MALAYSIAN PACIFIC INDUSTRIES",154900,36.4,6736622.5199999996,5638360,43.49,10,"TECHNOLOGY",-1098262.52,-16.3]
["TNB-RBTFI","BJ17CJ5","UWC BHD",1406400,3.91,7819584,5499024,5.56,10,"TECHNOLOGY",-2320560,-29.68]
["TNB-RBTFI","B0KLDR0","VITROX CORP BHD",736600,8.1999999999999993,6997700,6040120,9.5,10,"TECHNOLOGY",-957580,-13.68]
["TNB-RBTFI","B2QZGV5","AXIATA GROUP BERHAD",1987200,3.79,8028288,7531488,4.04,11,"TELECOMMUNICATIONS & MEDIA",-496800,-6.19]
["TNB-RBTFI","6086242","DIGI.COM BHD",1890000,3.9,8467200,7371000,4.4800000000000004,11,"TELECOMMUNICATIONS & MEDIA",-1096200,-12.95]
["TNB-RBTFI","6868398","TELEKOM MALAYSIA BHD",1230000,4.8899999999999997,7009283.5899999999,6014700,5.7,11,"TELECOMMUNICATIONS & MEDIA",-994583.59,-14.19]
["TNB-RBTFI","6336538","TIME DOTCOM BHD",1270000,4.3,5822769.1100000003,5461000,4.58,11,"TELECOMMUNICATIONS & MEDIA",-361769.11,-6.21]
["TNB-RBTFI","6557997","MISC BHD",715000,7.35,5257670.55,5255250,7.35,12,"TRANSPORTATION & LOGISTICS",-2420.5500000000002,-0.05]
["TNB-RBTFI","BDFM1K8","WESTPORTS HOLDINGS BHD",1735800,4,7499391.9100000001,6943200,4.32,12,"TRANSPORTATION & LOGISTICS",-556191.91,-7.42]
["TNB-RBTFI","6575740","MEGA FIRST CORP BHD",1643140,3.72,5783852.7999999998,6112480.7999999998,3.52,13,"UTILITIES",328628,5.68]
["TNB-RBTFI","6703972","PETRONAS GAS BHD",283700,16.66,4754812,4726442,16.760000000000002,13,"UTILITIES",-28370,-0.6]