{"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":27,"n_cols":16,"rows_kept":27,"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.70% UNCD TATA MOTORS-18/06/2020","INE155A08068","UTI Mutual Fund","Uti - Ftif - Series Xxvii - Plan Iv (1113 Days)","18/06/2020","924","T+0 Sal","07/12/2017",null,"07/12/2017","20","20924640",null,null,"Interscheme"]
["2","9.70% UNCD TATA MOTORS-18/06/2020","INE155A08068","UTI Mutual Fund","Uti - Ftif - Series Xxvii - Plan Ii (1161 Days)","18/06/2020","924","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","20","20924640","1046185","7.57504136","Interscheme"]
["3","0% UNCD  NABARD MAT - 01/02/2019","INE261F09EX6","UTI Mutual Fund","Uti - Ftif Series Xxiii - Xiii (1100 Days)","01/02/2019","421","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","300","5531676","18481.66","7.10229832","Market"]
["4","CP - SUN PHARMA INDS - 08/12/17","INE044A14245","UTI Mutual Fund","Uti - Liquid Cash Plan","08/12/2017","1","T+0 Sal","07/12/2017",null,"07/12/2017","3000000000","2999514000",null,null,"Market"]
["5","CP - INDIA INFOLINE FIN - 02/02/18","INE866I14VS0","UTI Mutual Fund","Uti - Liquid Cash Plan","02/02/2018","58","T+1 Sal","06/12/2017","06/12/2017","07/12/2017","50000000","49459350","98.9187","6.999803","Market"]
["6","CP - RELIANCE INDS -15/12/17","INE002A14672","UTI Mutual Fund","Uti - Floating Rate Fund Stp","15/12/2017","8","T+0 Sal","07/12/2017",null,"07/12/2017","2000000000","1997330000",null,null,"Interscheme"]
["7","CP - RELIANCE INDS -15/12/17","INE002A14672","UTI Mutual Fund","Uti - Liquid Cash Plan","15/12/2017","8","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","2000000000","1997330000","99.8832","6.097407","Interscheme"]
["8","CP - NABARD - 08/12/17","INE261F14BU8","UTI Mutual Fund","Uti - Liquid Cash Plan","08/12/2017","1","T+0 Sal","07/12/2017",null,"07/12/2017","1650000000","1649736000",null,null,"Market"]
["9","CP - NABARD - 08/12/17","INE261F14BU8","UTI Mutual Fund","Uti - Liquid Cash Plan","08/12/2017","1","T+0 Sal","07/12/2017",null,"07/12/2017","500000000","499919000",null,null,"Market"]
["10","CP - NABARD - 08/12/17","INE261F14BU8","UTI Mutual Fund","Uti - Liquid Cash Plan","08/12/2017","1","T+0 Sal","07/12/2017",null,"07/12/2017","1350000000","1349781300",null,null,"Market"]
["11","CP - NABARD - 08/12/17","INE261F14BU8","UTI Mutual Fund","Uti - Liquid Cash Plan","08/12/2017","1","T+0 Sal","07/12/2017",null,"07/12/2017","250000000","249959500",null,null,"Market"]
["12","CP - NABARD - 08/12/17","INE261F14BU8","UTI Mutual Fund","Uti - Liquid Cash Plan","08/12/2017","1","T+0 Sal","07/12/2017",null,"07/12/2017","1000000000","999838000",null,null,"Market"]
["13","CP - NABARD - 08/12/17","INE261F14BU8","UTI Mutual Fund","Uti - Liquid Cash Plan","08/12/2017","1","T+0 Sal","07/12/2017",null,"07/12/2017","750000000","749878500",null,null,"Market"]
["14","CP - ADITYA BIRLA FIN- 15/02/18","INE860H14A64","UTI Mutual Fund","Uti - Treasury Advantage Fund","15/02/2018","70","T+0 Sal","07/12/2017",null,"07/12/2017","1500000000","1480578000",null,null,"Market"]
["15","CD - HDFC BANK - 21/12/17","INE040A16BV0","UTI Mutual Fund","Uti - Liquid Cash Plan","21/12/2017","15","T+1 Sal","06/12/2017","06/12/2017","07/12/2017","50000000","49882350","99.7647","6.149076","Market"]
["16","0% SRNCD EDELW COM(SR-II)02/06/2020","INE657N07340","UTI Mutual Fund","Uti - Ftif - Series Xxvii - Plan Iv (1113 Days)","02/06/2020","908","T+0 Sal","07/12/2017","07/12/2017","07/12/2017","7","7327775","1047062","8.59763495","Interscheme"]
["17","0% SRNCD EDELW COM(SR-II)02/06/2020","INE657N07340","UTI Mutual Fund","Uti - Dual Advantage Fixed Term Fund Series Ii-V (1997 Days)","02/06/2020","908","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","7","7327775","1047062","8.59763495","Interscheme"]
["18","CP - HDFC LTD - 30/05/18","INE001A14RR1","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/05/2018","174","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","1000000000","967708000","96.7887","7.00008","Off Market"]
["19","CD - EQUITAS SMALL FIN BANK-7/03/18","INE063P16115","UTI Mutual Fund","Uti - Money Market Fund","07/03/2018","90","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","1500000000","1476159000","98.428","6.549931","Off Market"]
["20","CP - L &T FINANCE - 29/12/17","INE027E14EM7","UTI Mutual Fund","Uti - Liquid Cash Plan","29/12/2017","22","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","2000000000","1991956000","99.616","6.700014","Off Market"]
["21","CP - L&T HSG FINANCE-31/05/18","INE476M14AJ3","UTI Mutual Fund","Uti - Floating Rate Fund Stp","31/05/2018","175","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","2000000000","1932814000","96.6593","7.249991","Off Market"]
["22","CP -FULLERTON INDIA CREDIT-22/12/17","INE535H14GI5","UTI Mutual Fund","Uti - Liquid Cash Plan","22/12/2017","15","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","500000000","498606500","99.7398","6.801483","Off Market"]
["23","CP - HINDUJA LEYLAND FIN-07/03/18","INE146O14348","UTI Mutual Fund","Uti - Liquid Cash Plan","07/03/2018","90","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","1000000000","983033000","98.3218","6.999979","Off Market"]
["24","CP - INDIA INFOLINE FINANC-29/12/17","INE866I14VY8","UTI Mutual Fund","Uti - Liquid Cash Plan","29/12/2017","23","T+1 Sal","06/12/2017","06/12/2017","07/12/2017","50000000","49789950","99.5799","6.999245","Market"]
["25","0% UNCD  NABARD MAT - 01/08/2020","INE261F09FJ2","UTI Mutual Fund","Uti - Ftif - Series Xxvii - Plan Iv (1113 Days)","01/08/2020","968","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","250","4147800","16591.2","7.30782386","Market"]
["26","CP - IIFL WEALTH FINANCE-08/03/18","INE248U14CC0","UTI Mutual Fund","Uti - Liquid Cash Plan","08/03/2018","91","T+0 Pur","07/12/2017","07/12/2017","07/12/2017","2000000000","1965358000","98.2866","7.069925","Off Market"]