{"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":30,"n_cols":16,"rows_kept":30,"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%SNCD TALWAND SABO POW-04/08/20","INE694L07107","UTI Mutual Fund","Uti - Ccf - Saving Plan","04/08/2020","847","T+1 Sal","10/04/2018",null,"11/04/2018","500","495500500",null,null,"Market"]
["2","7.85%SNCD TALWAND SABO POW-04/08/20","INE694L07107","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","04/08/2020","847","T+1 Sal","10/04/2018",null,"11/04/2018","100","99100100",null,null,"Market"]
["3","CP - SHRIRAM TRANS FIN CO-30/05/18","INE721A14AX8","UTI Mutual Fund","Uti - Money Market Fund","30/05/2018","50","T+1 Sal","10/04/2018","10/04/2018","11/04/2018","50000000","49541100","99.0822","6.900002","Market"]
["4","CD - DENA BANK - 11/06/18","INE077A16EV6","UTI Mutual Fund","Uti - Money Market Fund","11/06/2018","61","T+0 Sal","11/04/2018","11/04/2018","11/04/2018","3000000000","2968449000","98.9654","6.359613","Market"]
["5","CD - PUNJAB & SIND BANK-12/06/18","INE608A16NX5","UTI Mutual Fund","Uti - Money Market Fund","12/06/2018","62","T+0 Sal","11/04/2018",null,"11/04/2018","1000000000","989312000",null,null,"Market"]
["6","CD - AXIS BANK - 29/06/18","INE238A16Z99","UTI Mutual Fund","Uti - Money Market Fund","29/06/2018","79","T+0 Pur","11/04/2018","11/04/2018","11/04/2018","3000000000","2959011000","98.6508","6.399912","Interscheme"]
["7","CD - ICICI BANK- 29/06/18","INE090A160M0","UTI Mutual Fund","Uti - Money Market Fund","29/06/2018","79","T+0 Pur","11/04/2018","11/04/2018","11/04/2018","2500000000","2465947500","98.6549","6.380198","Interscheme"]
["8","8.20% URNCD NABARD(G-PA3)16/03/2028","INE261F08AE6","UTI Mutual Fund","Uti - Bond Fund","16/03/2028","3628","T+1 Sal","10/04/2018","10/04/2018","11/04/2018","100","102229300","1022482","8.01626589","Market"]
["9","8.20% URNCD NABARD(G-PA3)16/03/2028","INE261F08AE6","UTI Mutual Fund","Uti - Bond Fund","16/03/2028","3627","T+0 Sal","11/04/2018","11/04/2018","11/04/2018","500","511479000","1017178","8.09623922","Market"]
["10","CP - VEDANTA - 14/05/2018","INE205A14MB3","UTI Mutual Fund","Uti - Liquid Cash Plan","14/05/2018","34","T+1 Pur","10/04/2018","10/04/2018","11/04/2018","50000000","49714600","99.4292","6.349638","Market"]
["11","CP - MOTILAL OSWAL SEC -11/06/18","INE886I14994","UTI Mutual Fund","Uti - Liquid Cash Plan","11/06/2018","61","T+0 Pur","11/04/2018","11/04/2018","11/04/2018","4000000000","3953224000","98.8495","7.080334","Off Market"]
["12","CP - INDIA INFOLINE FIN - 28/05/18","INE866I14XD8","UTI Mutual Fund","Uti - Liquid Cash Plan","28/05/2018","48","T+1 Sal","10/04/2018","10/04/2018","11/04/2018","50000000","49569150","99.1383","6.750091","Market"]
["13","CD - IDFC BANK - 06/07/18","INE092T16EC5","UTI Mutual Fund","Uti - Liquid Cash Plan","06/07/2018","86","T+0 Pur","11/04/2018","11/04/2018","11/04/2018","200000000","196896400","98.466","6.689798","Market"]
["14","CD - IDFC BANK - 06/07/18","INE092T16EC5","UTI Mutual Fund","Uti - Liquid Cash Plan","06/07/2018","86","T+0 Pur","11/04/2018","11/04/2018","11/04/2018","3500000000","3445687000","98.466","6.689798","Market"]
["15","CD - IDFC BANK - 06/07/18","INE092T16EC5","UTI Mutual Fund","Uti - Liquid Cash Plan","06/07/2018","86","T+0 Pur","11/04/2018","11/04/2018","11/04/2018","1300000000","1279826600","98.466","6.689798","Market"]
["16","CD - IDFC BANK -22/05/18","INE092T16DK0","UTI Mutual Fund","Uti - Liquid Cash Plan","22/05/2018","41","T+0 Pur","11/04/2018","11/04/2018","11/04/2018","500000000","496320500","99.2819","6.600058","Market"]
["17","CD - ANDHRA BANK - 25/06/18","INE434A16PD3","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","75","T+0 Sal","11/04/2018","11/04/2018","11/04/2018","1000000000","987140000","98.7211","6.389807","Market"]
["18","CD - DENA BANK - 26/06/18","INE077A16EX2","UTI Mutual Fund","Uti - Liquid Cash Plan","26/06/2018","76","T+0 Sal","11/04/2018","11/04/2018","11/04/2018","500000000","493465000","98.71","6.360045","Market"]
["19","CD - PUNJAB & SIND BANK-12/06/18","INE608A16NX5","UTI Mutual Fund","Uti - Liquid Cash Plan","12/06/2018","62","T+0 Sal","11/04/2018",null,"11/04/2018","1000000000","989312000",null,null,"Market"]
["20","CD - AXIS BANK - 29/06/18","INE238A16Z99","UTI Mutual Fund","Uti - Liquid Cash Plan","29/06/2018","79","T+0 Sal","11/04/2018",null,"11/04/2018","3000000000","2959011000",null,null,"Interscheme"]
["21","CD - ICICI BANK- 29/06/18","INE090A160M0","UTI Mutual Fund","Uti - Liquid Cash Plan","29/06/2018","79","T+0 Sal","11/04/2018",null,"11/04/2018","2500000000","2465947500",null,null,"Interscheme"]
["22","7.60%HDFC SRNCD-R14-26/06/2020","INE001A07QP1","UTI Mutual Fund","Uti - Ultra Short Term Fund","26/06/2020","808","T+1 Sal","10/04/2018","10/04/2018","11/04/2018","15","149195400","9947300","7.83518583","Market"]
["23","7.60%HDFC SRNCD-R14-26/06/2020","INE001A07QP1","UTI Mutual Fund","Uti - Ultra Short Term Fund","26/06/2020","808","T+1 Sal","10/04/2018","10/04/2018","11/04/2018","5","49731800","9947300","7.83518583","Market"]
["24","8.20% URNCD NABARD(G-PA3)16/03/2028","INE261F08AE6","UTI Mutual Fund","Uti - Dynamic Bond Fund","16/03/2028","3628","T+1 Sal","10/04/2018",null,"11/04/2018","400","408917200",null,null,"Market"]
["25","8.20% URNCD NABARD(G-PA3)16/03/2028","INE261F08AE6","UTI Mutual Fund","Uti - Dynamic Bond Fund","16/03/2028","3628","T+1 Sal","10/04/2018",null,"11/04/2018","500","511146500",null,null,"Market"]
["26","7.28% URNCD PFC SR 168A-10/06/2022","INE134E08JB5","UTI Mutual Fund","Uti - Credit Risk Fund","10/06/2022","1522","T+1 Sal","10/04/2018",null,"11/04/2018","600","588101400",null,null,"Market"]
["27","7.03% URNCD REC (SR-150)-07/09/2022","INE020B08AK2","UTI Mutual Fund","Uti - Credit Risk Fund","07/09/2022","1610","T+0 Sal","11/04/2018",null,"11/04/2018","250","242838750",null,null,"Market"]
["28","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Credit Risk Fund","30/11/2022","1694","T+0 Sal","11/04/2018",null,"11/04/2018","250","246494000",null,null,"Market"]
["29","8.13%SRNCD PIRAMAL ENT-27/06/2019","INE140A07369","UTI Mutual Fund","Uti - Credit Risk Fund","27/06/2019","442","T+0 Sal","11/04/2018",null,"11/04/2018","750","749433000",null,null,"Market"]