{"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":37,"n_cols":16,"rows_kept":37,"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","10.45%SRNCD ECL FIN-SR-N9-11/03/18","INE804I07ZJ5","UTI Mutual Fund","Uti - Liquid Cash Plan","11/03/2018","73","T+0 Sal","28/12/2017",null,"28/12/2017","1250000","1256010000",null,null,"Interscheme"]
["2","10.45%SRNCD ECL FIN-SR-N9-11/03/18","INE804I07ZJ5","UTI Mutual Fund","Uti - Money Market Fund","11/03/2018","73","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","1250000","1256010000","1004.781","7.63859669","Interscheme"]
["3","7.37% SR66 NTPC SRBOND-14/12/2031","INE733E07KI9","UTI Mutual Fund","Uti - Bond Fund","14/12/2031","5099","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","450","428228100","954820","7.90994144","Market"]
["4","7.37% SR66 NTPC SRBOND-14/12/2031","INE733E07KI9","UTI Mutual Fund","Uti - Dynamic Bond Fund","14/12/2031","5099","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","500","475809000","954820","7.90994144","Market"]
["5","0% SRNCD IDFC OBB-05-II-25/04/2018","INE092T08AB2","UTI Mutual Fund","Uti - Treasury Advantage Fund","25/04/2018","119","T+1 Sal","27/12/2017","27/12/2017","28/12/2017","1500","1865656500","1244027","7.7285096","Market"]
["6","8.97%SRNCD UPPOWER(3C)15/02/2023","INE540P07061","UTI Mutual Fund","Uti - Short Term Income Fund","15/02/2023","1875","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","500","514631500","1029348","8.46772538","Market"]
["7","8.97%SRNCD UPPOWER(3D)15/02/2024","INE540P07079","UTI Mutual Fund","Uti - Short Term Income Fund","15/02/2024","2240","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","500","517077500","1034241","8.46792706","Market"]
["8","7.2% SRNCD PGC (SR-LX)-09/08/27","INE752E07OG5","UTI Mutual Fund","Uti - Dynamic Bond Fund","09/08/2027","3511","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","500","478144000","955821","7.85740232","Market"]
["9","7.2% SRNCD PGC (SR-LX)-09/08/27","INE752E07OG5","UTI Mutual Fund","Uti - Bond Fund","09/08/2027","3511","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","450","430329600","955821","7.85740232","Market"]
["10","CP - GRUH FINANCE - 26/03/2018","INE580B14HC5","UTI Mutual Fund","Uti - Money Market Fund","26/03/2018","88","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","2000000000","1967974000","98.4513","6.599628","Off Market"]
["11","CP - AXIS FINANCE - 28/03/2018","INE891K14FH0","UTI Mutual Fund","Uti - Liquid Cash Plan","28/03/2018","90","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","1000000000","983056000","98.3312","6.960105","Off Market"]
["12","CD - IDFC BANK - 26/03/2018","INE092T16CN6","UTI Mutual Fund","Uti - Money Market Fund","26/03/2018","88","T+0 Sal","28/12/2017",null,"28/12/2017","4250000000","4186313750",null,null,"Interscheme"]
["13","CD - IDFC BANK - 26/03/2018","INE092T16CN6","UTI Mutual Fund","Uti - Liquid Cash Plan","26/03/2018","88","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","4250000000","4186313750","98.5009","6.385046","Interscheme"]
["14","CD - IDFC BANK - 26/03/2018","INE092T16CN6","UTI Mutual Fund","Uti - Liquid Cash Plan","26/03/2018","88","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","2000000000","1970018000","98.5009","6.385046","Market"]
["15","CD - IDFC BANK - 26/03/2018","INE092T16CN6","UTI Mutual Fund","Uti - Liquid Cash Plan","26/03/2018","88","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","750000000","738756750","98.5009","6.385046","Market"]
["16","CD - IDFC BANK - 26/03/2018","INE092T16CN6","UTI Mutual Fund","Uti - Money Market Fund","26/03/2018","89","T+1 Pur","27/12/2017","27/12/2017","28/12/2017","3250000000","3201298750","98.5015","6.309924","Market"]
["17","CD - IDFC BANK - 26/03/2018","INE092T16CN6","UTI Mutual Fund","Uti - Money Market Fund","26/03/2018","89","T+1 Pur","27/12/2017","27/12/2017","28/12/2017","1000000000","985015000","98.5015","6.309924","Market"]
["18","CP - S I D B I -12/02/18","INE556F14FR8","UTI Mutual Fund","Uti - Money Market Fund","12/02/2018","46","T+0 Sal","28/12/2017",null,"28/12/2017","5000000000","4960955000",null,null,"Interscheme"]
["19","CP - S I D B I -12/02/18","INE556F14FR8","UTI Mutual Fund","Uti - Liquid Cash Plan","12/02/2018","46","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","5000000000","4960955000","99.2359","6.245421","Interscheme"]
["20","8.90%SNCD DILIP BUILDCON I-28/12/19","INE917M07019","UTI Mutual Fund","Uti - Income Opportunities Fund","28/12/2019","730","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.09773044","Off Market"]
["21","8.9%SNCD DILIP BUILDCON II-28/03/20","INE917M07027","UTI Mutual Fund","Uti - Income Opportunities Fund","28/03/2020","821","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.09768834","Off Market"]
["22","8.9%SNCD DILIP BUILDCO III-28/06/20","INE917M07035","UTI Mutual Fund","Uti - Income Opportunities Fund","28/06/2020","913","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.08835571","Off Market"]
["23","8.9%SNCD DILIP BUILDCON IV-28/09/20","INE917M07043","UTI Mutual Fund","Uti - Income Opportunities Fund","28/09/2020","1005","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.09746663","Off Market"]
["24","8.9%SNCD DILIP BUILDCON V-28/12/20","INE917M07050","UTI Mutual Fund","Uti - Income Opportunities Fund","28/12/2020","1096","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.08971795","Off Market"]
["25","8.9%SNCD DILIP BUILDCON VI-28/03/21","INE917M07068","UTI Mutual Fund","Uti - Income Opportunities Fund","28/03/2021","1186","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.09715807","Off Market"]
["26","8.9%SNCD DILIP BUILDCO VII-28/06/21","INE917M07076","UTI Mutual Fund","Uti - Income Opportunities Fund","28/06/2021","1278","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.09082258","Off Market"]
["27","8.9%SNCD DILIP BUILDC VIII-28/09/21","INE917M07084","UTI Mutual Fund","Uti - Income Opportunities Fund","28/09/2021","1370","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.09706443","Off Market"]
["28","8.9%SNCD DILIP BUILDCON IX-28/12/21","INE917M07092","UTI Mutual Fund","Uti - Income Opportunities Fund","28/12/2021","1461","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.0915343","Off Market"]
["29","8.9%SNCD DILIP BUILDCON X-28/03/22","INE917M07100","UTI Mutual Fund","Uti - Income Opportunities Fund","28/03/2022","1551","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.09687887","Off Market"]
["30","8.9%SNCD DILIP BUILDCON XI-28/06/22","INE917M07118","UTI Mutual Fund","Uti - Income Opportunities Fund","28/06/2022","1643","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.09218661","Off Market"]
["31","8.9%SNCD DILIP BUILDC XII -28/09/22","INE917M07126","UTI Mutual Fund","Uti - Income Opportunities Fund","28/09/2022","1735","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","150","150000000","1000000","9.09683276","Off Market"]
["32","8.9%SNCD DILIP BUILDC XIII-28/12/22","INE917M07134","UTI Mutual Fund","Uti - Income Opportunities Fund","28/12/2022","1826","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","200","200000000","1000000","9.0926186","Off Market"]
["33","0% SRNCD REL HOME FIN-06/04/2021","INE217K07AZ5","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Iii (1203 Days)","06/04/2021","1195","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","60","30000000","500000","8.45738835","Off Market"]
["34","0% SRNCD REL HOME FIN-06/04/2021","INE217K07AZ5","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Ii (1210 Days)","06/04/2021","1195","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","120","60000000","500000","8.45738835","Off Market"]
["35","0% SRNCD REL HOME FIN-06/04/2021","INE217K07AZ5","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan I (1230 Days)","06/04/2021","1195","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","300","150000000","500000","8.45738835","Off Market"]
["36","0% SRNCD REL HOME FIN-06/04/2021","INE217K07AZ5","UTI Mutual Fund","Uti - C.R.T.S. 1981","06/04/2021","1195","T+0 Pur","28/12/2017","28/12/2017","28/12/2017","20","10000000","500000","8.45738835","Off Market"]