{"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":33,"n_cols":16,"rows_kept":33,"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","CP - MANAPURAM FIN - MAT - 21/05/18","INE522D14HQ3","UTI Mutual Fund","Uti - Money Market Fund","21/05/2018","40","T+1 Pur","11/04/2018","11/04/2018","12/04/2018","50000000","49641950","99.2839","6.7503","Market"]
["2","CP - SHRIRAM TRANS FIN CO-30/05/18","INE721A14AX8","UTI Mutual Fund","Uti - Money Market Fund","30/05/2018","49","T+1 Sal","11/04/2018","11/04/2018","12/04/2018","50000000","49560050","99.1201","6.750302","Market"]
["3","CD - IDFC BANK - 12/07/18","INE092T16EF8","UTI Mutual Fund","Uti - Money Market Fund","12/07/2018","91","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","2000000000","1967188000","98.3771","6.690339","Market"]
["4","CD - IDFC BANK - 12/07/18","INE092T16EF8","UTI Mutual Fund","Uti - Money Market Fund","12/07/2018","91","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","2000000000","1967188000","98.3771","6.690339","Market"]
["5","CD - IDFC BANK - 12/07/18","INE092T16EF8","UTI Mutual Fund","Uti - Money Market Fund","12/07/2018","91","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","800000000","786875200","98.3771","6.690339","Market"]
["6","CP - ICICI SEC - MAT - 29/05/2018","INE763G14FO5","UTI Mutual Fund","Uti - Liquid Cash Plan","29/05/2018","48","T+1 Pur","11/04/2018","11/04/2018","12/04/2018","50000000","49572300","99.1446","6.700314","Market"]
["7","CP - EXIM BANK - 12/07/18","INE514E14NJ1","UTI Mutual Fund","Uti - Liquid Cash Plan","12/07/2018","91","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","6000000000","5899254000","98.339","6.850057","Off Market"]
["8","CP - CHENNAI PETRO CORP-11/06/18","INE178A14CP3","UTI Mutual Fund","Uti - Liquid Cash Plan","11/06/2018","60","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","500000000","494794500","98.9761","6.399824","Off Market"]
["9","CP - DCM SHRIRAM - 30/05/18","INE499A14BE9","UTI Mutual Fund","Uti - Liquid Cash Plan","30/05/2018","48","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","500000000","495730000","99.1636","6.550233","Off Market"]
["10","CP - RAMCO CEMENT -16/05/18","INE331A14FX5","UTI Mutual Fund","Uti - Liquid Cash Plan","16/05/2018","34","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","500000000","496935500","99.405","6.620452","Off Market"]
["11","CP - IIFL WEALTH FINANCE -12/07/18","INE248U14DR6","UTI Mutual Fund","Uti - Liquid Cash Plan","12/07/2018","91","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","2000000000","1962328000","98.1367","7.700194","Off Market"]
["12","CP - INDIA INFOLINE FIN-11/07/18","INE866I14XX6","UTI Mutual Fund","Uti - Liquid Cash Plan","11/07/2018","90","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","2500000000","2454012500","98.1806","7.599856","Off Market"]
["13","CP - SHRIRAM TRANSPORT FIN-04/06/18","INE721A14AY6","UTI Mutual Fund","Uti - Liquid Cash Plan","04/06/2018","54","T+1 Sal","11/04/2018","11/04/2018","12/04/2018","50000000","49514700","99.0294","6.749835","Market"]
["14","CP - INDIABULLS HSG FIN - 07/06/18","INE148I14VD5","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","57","T+1 Sal","11/04/2018","11/04/2018","12/04/2018","50000000","49517600","99.0352","6.34969","Market"]
["15","CP - SHRIRAM TRANSP FIN CO-21/06/18","INE721A14BB2","UTI Mutual Fund","Uti - Liquid Cash Plan","21/06/2018","70","T+0 Sal","12/04/2018","12/04/2018","12/04/2018","3000000000","2960316000","98.6959","6.989652","Market"]
["16","CD - UNION BANK OF INDIA-25/06/18","INE692A16EX8","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","74","T+0 Sal","12/04/2018","12/04/2018","12/04/2018","750000000","740437500","98.742","6.370136","Market"]
["17","CD - KOTAK MAH BANK - 22/06/18","INE237A164D5","UTI Mutual Fund","Uti - Short Term Income Fund","22/06/2018","71","T+0 Sal","12/04/2018",null,"12/04/2018","3000000000","2962884000",null,null,"Market"]
["18","CD - KOTAK MAH BANK - 22/06/18","INE237A164D5","UTI Mutual Fund","Uti - Short Term Income Fund","22/06/2018","71","T+0 Sal","12/04/2018",null,"12/04/2018","1000000000","987628000",null,null,"Market"]
["19","CD - AXIS BANK - 19/07/18","INE238A16T06","UTI Mutual Fund","Uti - Treasury Advantage Fund","19/07/2018","98","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","2000000000","1963364000","98.2007","6.894617","Market"]
["20","8.85% SRNCD JM FIN CAP-29/09/2020","INE901W07012","UTI Mutual Fund","Uti - Ultra Short Term Fund","29/03/2019","351","T+0 Sal","12/04/2018",null,"12/04/2018","300","299481600",null,null,"Interscheme"]
["21","9.52% URNCD RAYMOND (SR1)10/04/2019","INE301A08415","UTI Mutual Fund","Uti - Ultra Short Term Fund","10/04/2019","363","T+0 Sal","12/04/2018",null,"12/04/2018","900","907799400",null,null,"Interscheme"]
["22","7.60% SRNCD PIRAMAL ENT-15/03/2019","INE140A07393","UTI Mutual Fund","Uti - Credit Risk Fund","15/03/2019","338","T+1 Sal","11/04/2018",null,"12/04/2018","1100","1095776000",null,null,"Market"]
["23","8.15% SRNCD PIRAMAL ENT-14/06/2019","INE140A07344","UTI Mutual Fund","Uti - Credit Risk Fund","14/06/2019","429","T+1 Sal","11/04/2018",null,"12/04/2018","100","99954300",null,null,"Market"]
["24","7.45% SRNCD L H F (351)17/10/2022","INE115A07MO1","UTI Mutual Fund","Uti - Credit Risk Fund","17/10/2022","1650","T+1 Sal","11/04/2018",null,"12/04/2018","250","244639000",null,null,"Market"]
["25","8.13%SRNCD PIRAMAL ENT-27/06/2019","INE140A07369","UTI Mutual Fund","Uti - Credit Risk Fund","27/06/2019","442","T+1 Sal","11/04/2018",null,"12/04/2018","220","219834780",null,null,"Market"]
["26","11.1% URNCD HIND LEY FIN-10/04/2022","INE146O08092","UTI Mutual Fund","Uti - Credit Risk Fund","08/04/2022","1457","T+0 Sal","12/04/2018",null,"12/04/2018","200","208164800",null,null,"Market"]
["27","8.85% SRNCD JM FIN CAP-29/09/2020","INE901W07012","UTI Mutual Fund","Uti - Credit Risk Fund","29/03/2019","351","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","300","299481600","997834","8.98967912","Interscheme"]
["28","9.52% URNCD RAYMOND (SR1)10/04/2019","INE301A08415","UTI Mutual Fund","Uti - Credit Risk Fund","10/04/2019","363","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","900","907799400","1008452","8.58996414","Interscheme"]
["29","8.13%SRNCD PIRAMAL ENT-27/06/2019","INE140A07369","UTI Mutual Fund","Uti - Medium Term Fund","27/06/2019","442","T+1 Sal","11/04/2018",null,"12/04/2018","30","29977470",null,null,"Market"]
["30","7.60% SRNCD PIRAMAL ENT-15/03/2019","INE140A07393","UTI Mutual Fund","Uti - Medium Term Fund","15/03/2019","338","T+1 Sal","11/04/2018",null,"12/04/2018","50","49808000",null,null,"Market"]
["31","9.70% UNCD TATA MOTORS-18/06/2020","INE155A08068","UTI Mutual Fund","Uti - Ftif - Series Xxvii - Plan Ii (1161 Days)","18/06/2020","798","T+0 Sal","12/04/2018","12/04/2018","12/04/2018","1","1036795","1036659","7.77041401","Interscheme"]
["32","9.70% UNCD TATA MOTORS-18/06/2020","INE155A08068","UTI Mutual Fund","Uti - Ftif - Series Xxvii - Plan Iv (1113 Days)","18/06/2020","798","T+0 Pur","12/04/2018","12/04/2018","12/04/2018","1","1036795","1036659","7.77041401","Interscheme"]