{"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":31,"n_cols":16,"rows_kept":31,"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","9.3% SRNCD DHFC (SR-VI)-16/08/2026","INE202B07HV0","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","16/08/2026","3149","T+0 Sal","01/01/2018",null,"01/01/2018","100000","102092300",null,null,"Market"]
["2","7.95%0SNCD PNB H F(SR29)-18/10/2019","INE572E09395","UTI Mutual Fund","Uti - Floating Rate Fund Stp","18/10/2019","658","T+3 Sal","29/12/2017",null,"01/01/2018","900","898929000",null,null,"Market"]
["3","CP - BHARTI TELECOM - 31/01/18","INE403D14015","UTI Mutual Fund","Uti - Money Market Fund","31/01/2018","33","T+3 Pur","29/12/2017","29/12/2017","01/01/2018","100000000","99468600","99.4334","6.499608","Market"]
["4","CP - ONGC MANGALORE PETRO-15/01/18","INE053T14998","UTI Mutual Fund","Uti - Money Market Fund","15/01/2018","14","T+0 Sal","01/01/2018","01/01/2018","01/01/2018","300000000","299282400","99.7778","6.252586","Market"]
["5","CD - AXIS BANK - 12/02/18","INE238A16V51","UTI Mutual Fund","Uti - Money Market Fund","12/02/2018","45","T+3 Sal","29/12/2017","29/12/2017","01/01/2018","50000000","49643000","99.2523","6.249237","Market"]
["6","CP - PIRAMAL FINANCE-12/02/18","INE641O14AT7","UTI Mutual Fund","Uti - Money Market Fund","12/02/2018","45","T+3 Sal","29/12/2017","29/12/2017","01/01/2018","50000000","49611800","99.1869","6.800328","Market"]
["7","8.45% NCD SUNDARAM FIN-07/06/2027","INE660A08BW0","UTI Mutual Fund","Uti - Balanced Fund","07/06/2027","3447","T+3 Sal","29/12/2017","29/12/2017","01/01/2018","50","50345050","996784","8.48208024","Market"]
["8","CP - MUTHOOT FINANCE- 16/02/2018","INE414G14GK1","UTI Mutual Fund","Uti - Money Market Fund","16/02/2018","49","T+3 Pur","29/12/2017","29/12/2017","01/01/2018","50000000","49562750","99.0878","7.000378","Market"]
["9","CP - DEWAN HOUSING FIN - 15/01/2018","INE202B14KU2","UTI Mutual Fund","Uti - Liquid Cash Plan","15/01/2018","14","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","300000000","299259600","99.7708","6.450014","Market"]
["10","CP - DEWAN HOUSING FIN - 15/01/2018","INE202B14KU2","UTI Mutual Fund","Uti - Liquid Cash Plan","15/01/2018","14","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","2000000000","1995064000","99.7708","6.450014","Market"]
["11","CP - BHARAT ALUMN CO -07/02/18","INE738C14DW4","UTI Mutual Fund","Uti - Money Market Fund","07/02/2018","40","T+3 Pur","29/12/2017","29/12/2017","01/01/2018","50000000","49657700","99.3307","6.306169","Market"]
["12","CP - KOTAK MAH PRIME-15/03/18","INE916D14G41","UTI Mutual Fund","Uti - Liquid Cash Plan","15/03/2018","76","T+3 Sal","29/12/2017",null,"01/01/2018","750000000","739908000",null,null,"Market"]
["13","CP - KOTAK MAH PRIME-15/03/18","INE916D14G41","UTI Mutual Fund","Uti - Liquid Cash Plan","15/03/2018","76","T+3 Sal","29/12/2017",null,"01/01/2018","1250000000","1233180000",null,null,"Market"]
["14","CP - MANAPPURAM FIN-13/02/2018","INE522D14HB5","UTI Mutual Fund","Uti - Money Market Fund","13/02/2018","46","T+3 Pur","29/12/2017","29/12/2017","01/01/2018","50000000","49591050","99.1444","6.999757","Market"]
["15","CP - ICICI HOME FINANCE- 28/02/18","INE071G14AN6","UTI Mutual Fund","Uti - Liquid Cash Plan","28/02/2018","58","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","1000000000","989808000","98.9982","6.479951","Off Market"]
["16","CP - IIFL WEALTH FIN-01/02/18","INE248U14CB2","UTI Mutual Fund","Uti - Liquid Cash Plan","01/02/2018","31","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","100000000","99409000","99.428","6.99937","Market"]
["17","CP - MAGMA FINCORP -01/03/18","INE511C14RG8","UTI Mutual Fund","Uti - Liquid Cash Plan","01/03/2018","59","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","2500000000","2470647500","98.8456","7.349602","Off Market"]
["18","CP - ADANI PORTS SE -28/02/2018","INE742F14EM8","UTI Mutual Fund","Uti - Liquid Cash Plan","28/02/2018","58","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","2000000000","1979958000","99.015","6.370203","Off Market"]
["19","CP - CHAMBAL FER -01/03/2018","INE085A14DD4","UTI Mutual Fund","Uti - Liquid Cash Plan","01/03/2018","59","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","1000000000","989808000","98.9979","6.370154","Off Market"]
["20","CD - IDFC BANK  LTD - 09/01/18","INE092T16BW9","UTI Mutual Fund","Uti - Liquid Cash Plan","09/01/2018","8","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","1000000000","998665000","99.8832","6.097407","Market"]
["21","CP  NABHA POWER - 16/02/18","INE445L14712","UTI Mutual Fund","Uti - Money Market Fund","16/02/2018","49","T+3 Pur","29/12/2017","29/12/2017","01/01/2018","50000000","49599950","99.1654","6.399851","Market"]
["22","CP - INDIABULLS HSG FIN-20/02/18","INE148I14TW9","UTI Mutual Fund","Uti - Money Market Fund","20/02/2018","53","T+3 Pur","29/12/2017","29/12/2017","01/01/2018","100000000","99117400","99.0824","6.500495","Market"]
["23","CD - AXIS BANK - 30/05/18","INE238A16W19","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/05/2018","149","T+0 Sal","01/01/2018","01/01/2018","01/01/2018","2000000000","1945210000","97.2784","6.89984","Market"]
["24","CD - AXIS BANK - 30/05/18","INE238A16W19","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/05/2018","149","T+0 Sal","01/01/2018","01/01/2018","01/01/2018","250000000","243151250","97.2784","6.89984","Market"]
["25","CD - AXIS BANK - 30/05/18","INE238A16W19","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/05/2018","149","T+0 Sal","01/01/2018","01/01/2018","01/01/2018","250000000","243151250","97.2784","6.89984","Market"]
["26","CP - L&T FINANCE - 08/01/2018","INE027E14EC8","UTI Mutual Fund","Uti - Liquid Cash Plan","08/01/2018","7","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","2500000000","2496935000","99.8949","6.40031","Market"]
["27","CP - SUN PHARMA INDS -15/01/18","INE044A14260","UTI Mutual Fund","Uti - Liquid Cash Plan","15/01/2018","14","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","1000000000","997647000","99.7815","6.148242","Market"]
["28","CP - L&T FINANCE - 27/03/18","INE027E14EY2","UTI Mutual Fund","Uti - Liquid Cash Plan","27/03/2018","85","T+0 Sal","01/01/2018","01/01/2018","01/01/2018","1500000000","1476447000","98.448","6.850123","Interscheme"]
["29","CP - L&T FINANCE - 27/03/18","INE027E14EY2","UTI Mutual Fund","Uti - Spread Fund","27/03/2018","85","T+0 Pur","01/01/2018","01/01/2018","01/01/2018","1500000000","1476447000","98.448","6.850123","Interscheme"]
["30","CP - L&T FINANCE - 27/03/18","INE027E14EY2","UTI Mutual Fund","Uti - Liquid Cash Plan","27/03/2018","85","T+0 Sal","01/01/2018","01/01/2018","01/01/2018","100000000","98429800","98.448","6.850123","Market"]