{"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":48,"n_cols":16,"rows_kept":48,"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","7.85% URNCD PFC (SR177)-03/04/2028","INE134E08JP5","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","03/04/2028","3653","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","500","500000000","1000000","7.99749206","Off Market"]
["2","7.85% URNCD PFC (SR177)-03/04/2028","INE134E08JP5","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","03/04/2028","3653","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","500","500000000","1000000","7.99749206","Off Market"]
["3","CP - CHENNAI PETRO CORP-03/05/18","INE178A14CN8","UTI Mutual Fund","Uti - Money Market Fund","03/05/2018","30","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","5500000000","5471086500","99.4917","6.430254","Off Market"]
["4","CP - ADANI PORTS & SPL ECO-25/06/18","INE742F14ES5","UTI Mutual Fund","Uti - Money Market Fund","25/06/2018","83","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","3000000000","2955972000","98.5498","6.550149","Off Market"]
["5","CP - HDFC LTD. - 20/06/2018","INE001A14RX9","UTI Mutual Fund","Uti - Money Market Fund","20/06/2018","78","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","986196000","98.632","6.574616","Market"]
["6","CP - ADITYA BIRLA FINANCE-14/05/18","INE860H14C54","UTI Mutual Fund","Uti - Money Market Fund","14/05/2018","47","T+6 Sal","28/03/2018","28/03/2018","03/04/2018","50000000","49513350","98.9093","8.749903","Market"]
["7","CD - UJJIVAN SMALL FIN BANK-27/4/18","INE551W16198","UTI Mutual Fund","Uti - Money Market Fund","27/04/2018","30","T+6 Pur","28/03/2018","28/03/2018","03/04/2018","50000000","49741600","99.3762","7.90056","Market"]
["8","CD - ICICI BANK- 29/06/18","INE090A160M0","UTI Mutual Fund","Uti - Money Market Fund","29/06/2018","87","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","2500000000","2462435000","98.5122","6.409866","Off Market"]
["9","CD - COOP RABO BANK - 21/05/18","INE480Q16200","UTI Mutual Fund","Uti - Money Market Fund","21/05/2018","48","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","2000000000","1983178000","99.1763","6.449947","Off Market"]
["10","CD - SOUTH INDIAN BANK -23/05/18","INE683A16KG9","UTI Mutual Fund","Uti - Money Market Fund","23/05/2018","56","T+6 Sal","28/03/2018","28/03/2018","03/04/2018","50000000","49458000","98.8089","7.999859","Market"]
["11","CD - IDFC BANK - 09/05/18","INE092T16DB9","UTI Mutual Fund","Uti - Money Market Fund","09/05/2018","42","T+6 Sal","28/03/2018","28/03/2018","03/04/2018","50000000","49628000","99.1535","7.600251","Market"]
["12","CD - COOP RABO BANK - 21/05/18","INE480Q16200","UTI Mutual Fund","Uti - Money Market Fund","21/05/2018","48","T+0 Sal","03/04/2018","03/04/2018","03/04/2018","1000000000","991589000","99.1763","6.449947","Market"]
["13","7.85% URNCD PFC (SR177)-03/04/2028","INE134E08JP5","UTI Mutual Fund","Uti - Bond Fund","03/04/2028","3653","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000","1000000000","1000000","7.99749206","Off Market"]
["14","CP -CHAMBAL FERT & CHEM-31/05/18","INE085A14DI3","UTI Mutual Fund","Uti - Liquid Cash Plan","31/05/2018","58","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","3000000000","2969658000","99.0059","6.429645","Off Market"]
["15","CP - KEC INTL -29/06/18","INE389H14CU1","UTI Mutual Fund","Uti - Liquid Cash Plan","29/06/2018","87","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","2500000000","2460760000","98.4482","6.689942","Off Market"]
["16","CP -  NEWORK18 MEDIA & INV-11/05/18","INE870H14FA5","UTI Mutual Fund","Uti - Liquid Cash Plan","11/05/2018","38","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","2000000000","1986762000","99.3554","6.400147","Off Market"]
["17","CP - MAGMA FINCORP - 04/06/18","INE511C14RV7","UTI Mutual Fund","Uti - Liquid Cash Plan","04/06/2018","62","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","2000000000","1975836000","98.8111","7.199505","Off Market"]
["18","CP - MAGMA FINCORP - 31/05/18","INE511C14RO2","UTI Mutual Fund","Uti - Liquid Cash Plan","31/05/2018","58","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","988688000","98.8881","7.20012","Off Market"]
["19","CP - REDINGTON INDIA-01/06/18","INE891D14QQ3","UTI Mutual Fund","Uti - Liquid Cash Plan","01/06/2018","59","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","989650000","98.9824","6.469698","Off Market"]
["20","CP -  TV18 BROADCAST-25/05/18","INE886H14CE0","UTI Mutual Fund","Uti - Liquid Cash Plan","25/05/2018","52","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","500000000","495482500","99.1137","6.399849","Off Market"]
["21","CP - DALMIA CEMENT (BHARAT)04/06/18","INE755K14781","UTI Mutual Fund","Uti - Liquid Cash Plan","04/06/2018","62","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","500000000","494498000","98.9172","6.549972","Off Market"]
["22","CP - APL APOLLO TUBES-28/06/18","INE702C14848","UTI Mutual Fund","Uti - Liquid Cash Plan","28/06/2018","86","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","250000000","246086250","98.4524","6.75004","Off Market"]
["23","CP - APL APOLLO TUBES-29/06/18","INE702C14863","UTI Mutual Fund","Uti - Liquid Cash Plan","29/06/2018","87","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","984166000","98.4345","6.749944","Off Market"]
["24","CP - MAGMA FINCORP -27/04/18","INE511C14RT1","UTI Mutual Fund","Uti - Liquid Cash Plan","27/04/2018","24","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","995353000","99.5546","7.099927","Off Market"]
["25","CP - FUTURE RETAIL - 05/06/18","INE752P14654","UTI Mutual Fund","Uti - Liquid Cash Plan","05/06/2018","63","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","750000000","740629500","98.7702","7.330097","Off Market"]
["26","CP - FUTURE RETAIL - 01/06/18","INE752P14670","UTI Mutual Fund","Uti - Liquid Cash Plan","01/06/2018","59","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","988290000","98.8486","7.33028","Off Market"]
["27","CP - FUTURE RETAIL - 04/06/18","INE752P14662","UTI Mutual Fund","Uti - Liquid Cash Plan","04/06/2018","62","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","750000000","740776500","98.7898","7.330069","Off Market"]
["28","CP - POWER FIN CORP - 25/06/18","INE134E14972","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","83","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","500000000","492629000","98.5651","6.480037","Market"]
["29","CP - POWER FIN CORP - 25/06/18","INE134E14972","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","83","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","500000000","492629000","98.5651","6.480037","Market"]
["30","CP - POWER FIN CORP - 25/06/18","INE134E14972","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","83","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","985258000","98.5651","6.480037","Market"]
["31","CP - POWER FIN CORP - 25/06/18","INE134E14972","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","83","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","500000000","492629000","98.5651","6.480037","Market"]
["32","CP - NATIONAL HSG BANK - 07/06/2018","INE557F14EE7","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","65","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","500000000","494278500","98.8843","6.434769","Market"]
["33","CP - NATIONAL HSG BANK - 07/06/2018","INE557F14EE7","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","65","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","500000000","494278500","98.8843","6.434769","Market"]
["34","CP - L&T FINANCE LTD -22/06/18","INE027E14DM9","UTI Mutual Fund","Uti - Liquid Cash Plan","22/06/2018","80","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","984996000","98.5234","6.924513","Market"]
["35","CP - NABARD - 21/05/18","INE261F14CL5","UTI Mutual Fund","Uti - Liquid Cash Plan","21/05/2018","54","T+6 Sal","28/03/2018","28/03/2018","03/04/2018","50000000","49511650","98.9929","7.006249","Market"]
["36","CP - PIRAMAL ENTERP - 18/05/18","INE140A14SK0","UTI Mutual Fund","Uti - Liquid Cash Plan","18/05/2018","51","T+6 Sal","28/03/2018","28/03/2018","03/04/2018","50000000","49526800","98.9495","7.750064","Market"]
["37","CP - BHARAT ALUMN CO-07/05/18","INE738C14EB6","UTI Mutual Fund","Uti - Liquid Cash Plan","07/05/2018","40","T+6 Sal","28/03/2018","28/03/2018","03/04/2018","50000000","49630150","99.1524","8.000479","Market"]
["38","CP - NTPC LTD - 27/06/18","INE733E14112","UTI Mutual Fund","Uti - Liquid Cash Plan","27/06/2018","85","T+0 Sal","03/04/2018",null,"03/04/2018","1000000000","985270000",null,null,"Market"]
["39","CD - ICICI BANK - 04/05/2018","INE090A165O5","UTI Mutual Fund","Uti - Liquid Cash Plan","04/05/2018","37","T+6 Pur","28/03/2018","28/03/2018","03/04/2018","50000000","49685600","99.2705","7.450672","Market"]
["40","CD - ICICI BANK- 29/06/18","INE090A160M0","UTI Mutual Fund","Uti - Liquid Cash Plan","29/06/2018","87","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","2500000000","2462435000","98.5122","6.409866","Off Market"]
["41","CD - INDIAN BANK - 26/06/2018","INE562A16IL9","UTI Mutual Fund","Uti - Liquid Cash Plan","26/06/2018","84","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","985485000","98.5655","6.400154","Market"]
["42","CD - INDIAN BANK - 26/06/2018","INE562A16IL9","UTI Mutual Fund","Uti - Liquid Cash Plan","26/06/2018","84","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","985485000","98.5655","6.400154","Market"]
["43","CD - INDIAN BANK - 26/06/2018","INE562A16IL9","UTI Mutual Fund","Uti - Liquid Cash Plan","26/06/2018","84","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000000000","985485000","98.5655","6.400154","Market"]
["44","CD - AXIS BANK - 22/02/2019","INE238A16Y66","UTI Mutual Fund","Uti - Short Term Income Fund","22/02/2019","325","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1500000000","1409640000","94.0594","7.115017","Market"]
["45","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Treasury Advantage Fund","08/03/2019","339","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1500000000","1406571000","93.8512","7.075004","Market"]
["46","9.38% SRNCD R E C - 06.11.18","INE020B07HY0","UTI Mutual Fund","Uti - Treasury Advantage Fund","06/11/2018","223","T+6 Pur","28/03/2018","28/03/2018","03/04/2018","1000","1010270000","1010506","7.41140999","Market"]
["47","7.85% URNCD PFC (SR177)-03/04/2028","INE134E08JP5","UTI Mutual Fund","Uti - Dynamic Bond Fund","03/04/2028","3653","T+0 Pur","03/04/2018","03/04/2018","03/04/2018","1000","1000000000","1000000","7.99749206","Off Market"]