{"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","8.75% SRNCD VEDANTA(SR 3)15/04/2021","INE205A07063","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","15/04/2021","1093","T+0 Sal","18/04/2018","18/04/2018","18/04/2018","120","121879800","1012476","8.33068272","Interscheme"]
["2","CD - SOUTH INDIAN BANK -23/05/18","INE683A16KG9","UTI Mutual Fund","Uti - Money Market Fund","23/05/2018","36","T+1 Sal","17/04/2018","17/04/2018","18/04/2018","50000000","49686500","99.373","6.579971","Market"]
["3","CD - UNION BANK OF INDIA-25/06/18","INE692A16EX8","UTI Mutual Fund","Uti - Money Market Fund","25/06/2018","68","T+0 Sal","18/04/2018","18/04/2018","18/04/2018","1500000000","1482189000","98.8299","6.449896","Market"]
["4","CP - MAGMA FINCORP - 31/05/18","INE511C14RO2","UTI Mutual Fund","Uti - Liquid Cash Plan","31/05/2018","44","T+1 Pur","17/04/2018","17/04/2018","18/04/2018","250000000","248056750","99.1816","7.004206","Market"]
["5","CP - NORTHERN ARC CAPITAL -29/06/18","INE850M14661","UTI Mutual Fund","Uti - Liquid Cash Plan","29/06/2018","72","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","250000000","245996750","98.4206","8.249747","Off Market"]
["6","CP - CHENNAI PETRO CORP-18/06/18","INE178A14CR9","UTI Mutual Fund","Uti - Liquid Cash Plan","18/06/2018","61","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","1750000000","1730937250","98.9284","6.589513","Off Market"]
["7","CP - RELIANCE INDS - 17/07/2018","INE002A14AC7","UTI Mutual Fund","Uti - Liquid Cash Plan","17/07/2018","90","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","5000000000","4915520000","98.3336","6.949926","Off Market"]
["8","CP - MAGMA FINCORP - 11/06/18","INE511C14RQ7","UTI Mutual Fund","Uti - Liquid Cash Plan","11/06/2018","55","T+1 Sal","17/04/2018","17/04/2018","18/04/2018","250000000","247564250","99.0257","6.650341","Market"]
["9","CP - BHARAT ALUMN CO-13/06/18","INE738C14EE0","UTI Mutual Fund","Uti - Liquid Cash Plan","13/06/2018","57","T+1 Sal","17/04/2018","17/04/2018","18/04/2018","50000000","49513800","99.0276","6.4002","Market"]
["10","CD - JAMMU & KASHMIR BANK-11/06/18","INE168A16LJ3","UTI Mutual Fund","Uti - Liquid Cash Plan","11/06/2018","55","T+1 Pur","17/04/2018","17/04/2018","18/04/2018","50000000","49538300","99.0766","6.299671","Market"]
["11","CD - AXIS BANK - 22/05/2018","INE238A16Y58","UTI Mutual Fund","Uti - Liquid Cash Plan","22/05/2018","35","T+1 Pur","17/04/2018","17/04/2018","18/04/2018","50000000","49706000","99.412","6.349689","Market"]
["12","CD - IDFC BANK - 18/07/2018","INE092T16EG6","UTI Mutual Fund","Uti - Liquid Cash Plan","18/07/2018","91","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","1500000000","1474993500","98.3509","6.800158","Market"]
["13","CD - IDFC BANK - 18/07/2018","INE092T16EG6","UTI Mutual Fund","Uti - Liquid Cash Plan","18/07/2018","91","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","1500000000","1474993500","98.3509","6.800158","Market"]
["14","CD - IDFC BANK - 18/07/2018","INE092T16EG6","UTI Mutual Fund","Uti - Liquid Cash Plan","18/07/2018","91","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","2000000000","1966658000","98.3509","6.800158","Market"]
["15","CD - JAMMU & KASHMIR BANK-04/06/18","INE168A16LG9","UTI Mutual Fund","Uti - Liquid Cash Plan","04/06/2018","48","T+1 Sal","17/04/2018","17/04/2018","18/04/2018","50000000","49597650","99.1953","6.299962","Market"]
["16","CD - DENA BANK - 15/06/18","INE077A16ET0","UTI Mutual Fund","Uti - Liquid Cash Plan","15/06/2018","58","T+0 Sal","18/04/2018","18/04/2018","18/04/2018","1000000000","989839000","99.0012","6.460351","Market"]
["17","CD - ANDHRA BANK - 25/06/18","INE434A16PD3","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","68","T+0 Sal","18/04/2018","18/04/2018","18/04/2018","900000000","889313400","98.8299","6.449896","Market"]
["18","CD - INDIAN BANK - 25/06/2018","INE562A16IK1","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","68","T+0 Sal","18/04/2018",null,"18/04/2018","1000000000","988126000",null,null,"Market"]
["19","CD - UNION BANK OF INDIA-25/06/18","INE692A16EX8","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","68","T+0 Sal","18/04/2018","18/04/2018","18/04/2018","250000000","247031500","98.8299","6.449896","Market"]
["20","7.99% URNCD PFC (OP-B)-20/12/2022","INE134E08JO8","UTI Mutual Fund","Uti - Credit Risk Fund","20/12/2022","1707","T+0 Sal","18/04/2018","18/04/2018","18/04/2018","250","249657250","998908","8.0224337","Market"]
["21","7.99% URNCD PFC (OP-B)-20/12/2022","INE134E08JO8","UTI Mutual Fund","Uti - Credit Risk Fund","20/12/2022","1707","T+0 Sal","18/04/2018","18/04/2018","18/04/2018","50","49950300","998908","8.0224337","Market"]
["22","9.02%SRNCD RURAL ELEC CORP18.06.19","INE020B07IV4","UTI Mutual Fund","Uti - Ftif Series Xxiv - Ix (1183 Days)","18/06/2019","426","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","4","4061596","1015645","7.52465443","Market"]
["23","9.02%SRNCD RURAL ELEC CORP18.06.19","INE020B07IV4","UTI Mutual Fund","Uti - Ftif Series Xxiv - Xv (1099 Days)","18/06/2019","426","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","7","7107793","1015645","7.52465443","Market"]
["24","9.02%SRNCD RURAL ELEC CORP18.06.19","INE020B07IV4","UTI Mutual Fund","Uti - Ftif Series Xxiv - Xvii (1098 Days)","18/06/2019","426","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","10","10153990","1015645","7.52465443","Market"]
["25","9.02%SRNCD RURAL ELEC CORP18.06.19","INE020B07IV4","UTI Mutual Fund","Uti - Ftif Series Xxv - I (1099 Days)","18/06/2019","426","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","8","8123192","1015645","7.52465443","Market"]
["26","9.02%SRNCD RURAL ELEC CORP18.06.19","INE020B07IV4","UTI Mutual Fund","Uti - Ftif Series Xxv - Ii (1097 Days)","18/06/2019","426","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","11","11169389","1015645","7.52465443","Market"]
["27","9.02%SRNCD RURAL ELEC CORP18.06.19","INE020B07IV4","UTI Mutual Fund","Uti - Ftif Series Xxv - Iii (1100 Days)","18/06/2019","426","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","10","10153990","1015645","7.52465443","Market"]
["28","0% SRNCD EDEL HSG FIN-04/05/2021.","INE530L07335","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiii (1134 Days)","04/05/2021","1112","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","450","452083500","1004630","8.70815583","Market"]
["29","8.75% SRNCD VEDANTA(SR 3)15/04/2021","INE205A07063","UTI Mutual Fund","Uti - Fixed Term Income Fund - Series Xxix - I (1134 Days)","15/04/2021","1093","T+0 Pur","18/04/2018","18/04/2018","18/04/2018","120","121879800","1012476","8.33068272","Interscheme"]