{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet","index":0,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["s_no","security_name","isin","fund_house","scheme_name","mat_date","daystomat","settlement_type","trade_date","valuation_date","settlement_date","quantity_traded","value_of_trade","valued_price","ytm","mkt_ist"]
["1","8.35% SRNCD SAIL SR-BB-09/06/2018","INE114A07901","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","09/06/2018","101","T+0 Sal","28/02/2018",null,"28/02/2018","110","109865800",null,null,"Interscheme"]
["2","CP - DALMIA CEM BHARAT-28/05/2018","INE755K14740","UTI Mutual Fund","Uti - Money Market Fund","28/05/2018","89","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","1000000000","981876000","98.2076","7.570072","Off Market"]
["3","CP - FULLER INDIA HOME FIN-30/05/18","INE213W14042","UTI Mutual Fund","Uti - Money Market Fund","30/05/2018","91","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","300000000","294133500","98.0656","7.999815","Off Market"]
["4","CP - INDIA INFOLINE FIN - 28/05/18","INE866I14XD8","UTI Mutual Fund","Uti - Money Market Fund","28/05/2018","89","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","3000000000","2941545000","98.073","8.149715","Off Market"]
["5","CP - INDIA INFOLINE HSG FIN-15/5/18","INE477L14CR2","UTI Mutual Fund","Uti - Money Market Fund","15/05/2018","76","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","500000000","492009000","98.4225","7.800215","Off Market"]
["6","CP - RELIANCE HOME FIN-07/05/18","INE217K14DB6","UTI Mutual Fund","Uti - Money Market Fund","07/05/2018","68","T+0 Sal","28/02/2018",null,"28/02/2018","30000000","29550780",null,null,"Interscheme"]
["7","CP - ADANI TRANSMISSION-29/05/18","INE931S14773","UTI Mutual Fund","Uti - Liquid Cash Plan","29/05/2018","90","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","2000000000","1963686000","98.2041","7.499899","Off Market"]
["8","CP - MAGMA FINCORP - 27/03/18","INE511C14RN4","UTI Mutual Fund","Uti - Liquid Cash Plan","27/03/2018","27","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","2000000000","1988966000","99.4686","7.499893","Off Market"]
["9","CP - DEWAN HSG FIN CORP-23/03/18","INE202B14LM7","UTI Mutual Fund","Uti - Liquid Cash Plan","23/03/2018","23","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","3000000000","2987295000","99.5948","6.749987","Off Market"]
["10","CP - RELIANCE HOME FIN-07/05/18","INE217K14DB6","UTI Mutual Fund","Uti - Liquid Cash Plan","07/05/2018","68","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","30000000","29550780","98.5082","8.250044","Interscheme"]
["11","0% SNCD HDFC LTD (L-4)-30/10/2018","INE001A07LW8","UTI Mutual Fund","Uti - Short Term Income Fund","30/10/2018","244","T+0 Sal","28/02/2018",null,"28/02/2018","1000","1500111000",null,null,"Market"]
["12","7.77% URNCD REC - 16/09/2019","INE020B08AU1","UTI Mutual Fund","Uti - Short Term Income Fund","16/09/2019","565","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","4500","4500000000","1000000","7.81945446","Off Market"]
["13","7.09%URNC BOND SIDBI-II- 19/06/2020","INE556F08IW4","UTI Mutual Fund","Uti - Short Term Income Fund","19/11/2018","265","T+1 Sal","27/02/2018","27/02/2018","28/02/2018","1000","994687000","994687","7.32723111","Market"]
["14","7.09%URNC BOND SIDBI-II- 19/06/2020","INE556F08IW4","UTI Mutual Fund","Uti - Short Term Income Fund","19/11/2018","265","T+1 Sal","27/02/2018","27/02/2018","28/02/2018","1700","1690967900","994687","7.32723111","Market"]
["15","7.09%URNC BOND SIDBI-II- 19/06/2020","INE556F08IW4","UTI Mutual Fund","Uti - Short Term Income Fund","19/11/2018","265","T+1 Sal","27/02/2018","27/02/2018","28/02/2018","250","248671750","994687","7.32723111","Market"]
["16","7.09%URNC BOND SIDBI-II- 19/06/2020","INE556F08IW4","UTI Mutual Fund","Uti - Short Term Income Fund","19/11/2018","265","T+1 Sal","27/02/2018","27/02/2018","28/02/2018","500","497343500","994687","7.32723111","Market"]
["17","7.81% URNCD EXIM-SR-S5-05/11/2018","INE514E08ER5","UTI Mutual Fund","Uti - Short Term Income Fund","05/11/2018","250","T+0 Sal","28/02/2018",null,"28/02/2018","1000","998947027.39",null,null,"Market"]
["18","7.77% URNCD REC - 16/09/2019","INE020B08AU1","UTI Mutual Fund","Uti - Treasury Advantage Fund","16/09/2019","565","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","2000","2000000000","1000000","7.81945446","Off Market"]
["19","7.81% URNCD EXIM-SR-S5-05/11/2018","INE514E08ER5","UTI Mutual Fund","Uti - Treasury Advantage Fund","05/11/2018","250","T+0 Sal","28/02/2018",null,"28/02/2018","400","399578810.95",null,null,"Market"]
["20","8.39% URNCD PFC-SR-134B-28/05/2018","INE134E08HM6","UTI Mutual Fund","Uti - Treasury Advantage Fund","28/05/2018","89","T+0 Sal","28/02/2018",null,"28/02/2018","250","250223284.24",null,null,"Market"]
["21","7.81% URNCD EXIM-SR-S5-05/11/2018","INE514E08ER5","UTI Mutual Fund","Uti - Treasury Advantage Fund","05/11/2018","250","T+0 Sal","28/02/2018",null,"28/02/2018","500","499473513.7",null,null,"Market"]
["22","8.39% URNCD PFC-SR-134B-28/05/2018","INE134E08HM6","UTI Mutual Fund","Uti - Treasury Advantage Fund","28/05/2018","89","T+0 Sal","28/02/2018",null,"28/02/2018","750","750669852.74025",null,null,"Market"]
["23","9.5% UNCD YES BANK(PERP)-23/12/2021","INE528G08352","UTI Mutual Fund","Uti - Income Opportunities Fund","23/12/2021","1395","T+1 Sal","27/02/2018","27/02/2018","28/02/2018","50","49420750","985899","9.93282887","Market"]
["24","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","10/04/2018","41","T+0 Sal","28/02/2018",null,"28/02/2018","44","44008057.8872",null,null,"Interscheme"]
["25","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","10/04/2018","41","T+0 Sal","28/02/2018",null,"28/02/2018","58","58010621.7604",null,null,"Interscheme"]
["26","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","10/04/2018","41","T+0 Sal","28/02/2018",null,"28/02/2018","66","66012086.8308",null,null,"Interscheme"]
["27","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","10/04/2018","41","T+0 Sal","28/02/2018",null,"28/02/2018","10","10001831.338",null,null,"Interscheme"]
["28","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","10/04/2018","41","T+0 Sal","28/02/2018",null,"28/02/2018","50","50009156.69",null,null,"Interscheme"]
["29","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","10/04/2018","41","T+0 Sal","28/02/2018",null,"28/02/2018","18","18003296.4084",null,null,"Interscheme"]
["30","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","10/04/2018","41","T+0 Sal","28/02/2018",null,"28/02/2018","4","4000732.5352",null,null,"Interscheme"]
["31","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Capital Protection Oriented Scheme - Series V - Ii (1135 Days)","10/04/2018","41","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","58","58010621.7604","1000183.133793","7.55331863","Interscheme"]
["32","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Ftif Series Xxii - I (1099 Days)","10/04/2018","41","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","44","44008057.8872","1000183.133864","7.55331863","Interscheme"]
["33","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Ftif Series Xxii - Ii (1099 Days)","10/04/2018","41","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","18","18003296.4084","1000183.133889","7.55331863","Interscheme"]
["34","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Ftif Series Xxii - Iii (1099 Days)","10/04/2018","41","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","50","50009156.69","1000183.1338","7.55331863","Interscheme"]
["35","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Ftif Series Xxii - Iv (1098 Days)","10/04/2018","41","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","10","10001831.338","1000183.134","7.55331863","Interscheme"]
["36","8.35% SRNCD SAIL SR-BB-09/06/2018","INE114A07901","UTI Mutual Fund","Uti - Ftif Series Xxii - Vi (1098 Days)","09/06/2018","101","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","110","109865800","998786","8.55323232","Interscheme"]
["37","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Ftif Series Xxii - Vi (1098 Days)","10/04/2018","41","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","66","66012086.8308","1000183.133857","7.55331863","Interscheme"]
["38","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Ftif Series Xxii - Vi (1098 Days)","10/04/2018","41","T+0 Pur","28/02/2018","28/02/2018","28/02/2018","4","4000732.5352","1000183.133857","7.55331863","Interscheme"]