{"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":35,"n_cols":16,"rows_kept":35,"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 - RELIANCE INDS -29/12/2017","INE002A14706","UTI Mutual Fund","Uti - Liquid Cash Plan","29/12/2017","29","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","5000000000","4975845000","99.5336","6.108346","Off Market"]
["2","8.80% SRNCD IHFL-OP-IV- 09/08/2019","INE148I07FN1","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","09/08/2019","618","T+1 Sal","29/11/2017","29/11/2017","30/11/2017","500","507136000","1014214","7.82374408","Market"]
["3","8.28% SRNCD O N B H L-SR-A-30/03/21","INE105N07092","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","30/03/2021","1216","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","2500","253036500","100772.3","8.15824837","Market"]
["4","8.93%SRNCD PGC SR-XLVIIB-20/10/2019","INE752E07LT4","UTI Mutual Fund","Uti - Short Term Income Fund","20/10/2019","689","T+0 Sal","30/11/2017",null,"30/11/2017","650","670298850",null,null,"Interscheme"]
["5","8.93%SRNCD PGC SR-XLVIIB-20/10/2019","INE752E07LT4","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","20/10/2019","689","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","650","670298850","1031180","7.08696007","Interscheme"]
["6","8.04% URNC BONDS SIDBI - 15/03/2019","INE556F09601","UTI Mutual Fund","Uti - Treasury Advantage Fund","15/03/2019","470","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","2500","2529590000","1011858","6.99636316","Market"]
["7","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Short Term Income Fund","10/04/2018","131","T+0 Sal","30/11/2017",null,"30/11/2017","250","250959000",null,null,"Interscheme"]
["8","8%URNCD NATIONAL HSG BANK10/04/2018","INE557F08EW1","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","10/04/2018","131","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","250","250959000","1003803","6.70869261","Interscheme"]
["9","2% URNCD TATA STEEL23/04/2022","INE081A08181","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","23/04/2022","1606","T+1 Sal","29/11/2017",null,"30/11/2017","150","207928950",null,null,"Market"]
["10","CP - GRUH FINANCE -12/12/17","INE580B14GT1","UTI Mutual Fund","Uti - Liquid Cash Plan","12/12/2017","12","T+0 Sal","30/11/2017",null,"30/11/2017","2250000000","2245423500",null,null,"Market"]
["11","CP - GRUH FINANCE -12/12/17","INE580B14GT1","UTI Mutual Fund","Uti - Liquid Cash Plan","12/12/2017","12","T+0 Sal","30/11/2017",null,"30/11/2017","250000000","249491500",null,null,"Market"]
["12","CP - N A B A R D -29/12/17","INE261F14BX2","UTI Mutual Fund","Uti - Money Market Fund","29/12/2017","29","T+0 Sal","30/11/2017",null,"30/11/2017","4950000000","4926561750",null,null,"Interscheme"]
["13","CP - N A B A R D -29/12/17","INE261F14BX2","UTI Mutual Fund","Uti - Liquid Cash Plan","29/12/2017","29","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","4950000000","4926561750","99.5428","5.987303","Interscheme"]
["14","7% SRNCD IRFC-SR116-10/09/2018.","INE053F07967","UTI Mutual Fund","Uti - Short Term Income Fund","10/09/2018","284","T+0 Sal","30/11/2017","30/11/2017","30/11/2017","500","500891000","1001767","6.74968699","Interscheme"]
["15","7% SRNCD IRFC-SR116-10/09/2018.","INE053F07967","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","10/09/2018","284","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","500","500891000","1001767","6.74968699","Interscheme"]
["16","CP - TATA MOTOR FINANCE-15/01/18","INE601U14240","UTI Mutual Fund","Uti - Liquid Cash Plan","15/01/2018","46","T+0 Sal","30/11/2017","30/11/2017","30/11/2017","3500000000","3471814500","99.2121","6.441497","Interscheme"]
["17","CP - TATA MOTOR FINANCE-15/01/18","INE601U14240","UTI Mutual Fund","Uti - Money Market Fund","15/01/2018","46","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","3500000000","3471814500","99.2121","6.441497","Interscheme"]
["18","CP - HDFC LTD - 18/12/17","INE001A14RG4","UTI Mutual Fund","Uti - Liquid Cash Plan","18/12/2017","18","T+0 Sal","30/11/2017",null,"30/11/2017","50000000","49847350",null,null,"Market"]
["19","CP - HDFC LTD - 18/12/17","INE001A14RG4","UTI Mutual Fund","Uti - Liquid Cash Plan","18/12/2017","18","T+0 Sal","30/11/2017",null,"30/11/2017","1900000000","1894199300",null,null,"Market"]
["20","CP - HDFC LTD - 08/12/17","INE001A14RI0","UTI Mutual Fund","Uti - Liquid Cash Plan","08/12/2017","8","T+0 Sal","30/11/2017",null,"30/11/2017","2000000000","1997286000",null,null,"Market"]
["21","CP - KOTAK SECURITIES-31/01/18","INE028E14CT4","UTI Mutual Fund","Uti - Liquid Cash Plan","31/01/2018","62","T+0 Sal","30/11/2017",null,"30/11/2017","1500000000","1482523500",null,null,"Market"]
["22","7.65% SRNCD L H F (326)17/11/2020","INE115A07LF1","UTI Mutual Fund","Uti - Short Term Income Fund","17/11/2020","1084","T+1 Pur","29/11/2017","29/11/2017","30/11/2017","1250","1251702500","1001426","7.58588565","Market"]
["23","CP - NATIONAL HSG BANK -28/12/17","INE557F14EA5","UTI Mutual Fund","Uti - Money Market Fund","28/12/2017","28","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","2500000000","2488375000","99.5515","6.090371","Off Market"]
["24","CP - VEDANTA LTD - 28/02/18","INE205A14LE9","UTI Mutual Fund","Uti - Liquid Cash Plan","28/02/2018","90","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","2000000000","1968928000","98.4634","6.400131","Off Market"]
["25","CP - COX &KINGS - 27/02/18","INE008I14KO1","UTI Mutual Fund","Uti - Money Market Fund","27/02/2018","89","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","500000000","491550000","98.3264","7.059789","Off Market"]
["26","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","30/11/2022","1826","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","250","250000000","1000000","7.44561255","Off Market"]
["27","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Dynamic Bond Fund","30/11/2022","1826","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","1500","1500000000","1000000","7.44561255","Off Market"]
["28","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Short Term Income Fund","30/11/2022","1826","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","1270","1270000000","1000000","7.44561255","Off Market"]
["29","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Bond Fund","30/11/2022","1826","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","500","500000000","1000000","7.44561255","Off Market"]
["30","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Balanced Fund","30/11/2022","1826","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","500","500000000","1000000","7.44561255","Off Market"]
["31","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","30/11/2022","1826","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","500","500000000","1000000","7.44561255","Off Market"]
["32","CP - ALTICO CAP INDIA - 01/03/18","INE587O14111","UTI Mutual Fund","Uti - Money Market Fund","01/03/2018","91","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","2350000000","2294556450","97.666","9.691875","Off Market"]
["33","CP - MAGMA FINCORP -01/02/18","INE511C14RC7","UTI Mutual Fund","Uti - Liquid Cash Plan","01/02/2018","63","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","2350000000","2312677300","98.4366","9.350066","Market"]
["34","CP - DALMIA CEMENT(BHARAT)-28/02/18","INE755K14690","UTI Mutual Fund","Uti - Money Market Fund","28/02/2018","90","T+0 Pur","30/11/2017","30/11/2017","30/11/2017","1600000000","1574952000","98.4516","6.450052","Off Market"]