{"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":23,"n_cols":16,"rows_kept":23,"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.30% URNCD IHFL- 29/06/2026","INE148I08215","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","29/06/2026","2999","T+0 Sal","13/04/2018",null,"13/04/2018","2500","255542750",null,null,"Market"]
["2","8.64%SNCD POWERGRID(33-E)08/07/2018","INE752E07HG9","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","08/07/2018","87","T+1 Pur","12/04/2018","12/04/2018","13/04/2018","200","250527800","1253598.75","7.12612543","Market"]
["3","8.05% SRNCD M&M FIN-SR3-24/07/2032","INE774D08MM1","UTI Mutual Fund","Uti - Hybrid Equity Fund","24/07/2032","5217","T+1 Sal","12/04/2018","12/04/2018","13/04/2018","150000","146688750","950.805","8.65815411","Market"]
["4","8.45% NCD SUNDARAM FIN-07/06/2027","INE660A08BW0","UTI Mutual Fund","Uti - Hybrid Equity Fund","07/06/2027","3343","T+1 Sal","12/04/2018",null,"13/04/2018","52","52217932",null,null,"Market"]
["5","CD - SOUTH INDIAN BANK-25/05/18","INE683A16KH7","UTI Mutual Fund","Uti - Money Market Fund","25/05/2018","43","T+1 Sal","12/04/2018","12/04/2018","13/04/2018","50000000","49640150","99.2803","6.299876","Market"]
["6","CD - PUNJAB & SIND BANK-30/05/18","INE608A16NY3","UTI Mutual Fund","Uti - Money Market Fund","30/05/2018","47","T+0 Sal","13/04/2018","13/04/2018","13/04/2018","2000000000","1983704000","99.2024","6.379667","Market"]
["7","CD - ICICI BANK - 02/05/18","INE090A166O3","UTI Mutual Fund","Uti - Money Market Fund","02/05/2018","19","T+0 Sal","13/04/2018","13/04/2018","13/04/2018","1500000000","1494942000","99.6827","6.454619","Market"]
["8","CD - ICICI BANK - 02/05/18","INE090A166O3","UTI Mutual Fund","Uti - Money Market Fund","02/05/2018","19","T+0 Sal","13/04/2018","13/04/2018","13/04/2018","1250000000","1245850000","99.6827","6.454619","Market"]
["9","CD - IDFC BANK - 09/05/18","INE092T16DB9","UTI Mutual Fund","Uti - Money Market Fund","09/05/2018","26","T+0 Sal","13/04/2018",null,"13/04/2018","2000000000","1990782000",null,null,"Market"]
["10","CD - IDFC BANK - 09/05/18","INE092T16DB9","UTI Mutual Fund","Uti - Money Market Fund","09/05/2018","26","T+0 Sal","13/04/2018",null,"13/04/2018","1750000000","1741934250",null,null,"Market"]
["11","8.30%SNCD JORABAT SHILLO -01/03/22.","INE944Y07042","UTI Mutual Fund","Uti - Bond Fund","01/03/2022","1418","T+0 Pur","13/04/2018","13/04/2018","13/04/2018","1000","100036100","99962","8.47301105","Interscheme"]
["12","CP - MAGMA FINCORP - 11/06/18","INE511C14RQ7","UTI Mutual Fund","Uti - Liquid Cash Plan","11/06/2018","59","T+0 Pur","13/04/2018","13/04/2018","13/04/2018","1000000000","988132000","98.8331","7.430125","Off Market"]
["13","CP - IIFL WEALTH FINANCE-02/05/18","INE248U14CR8","UTI Mutual Fund","Uti - Liquid Cash Plan","02/05/2018","20","T+1 Pur","12/04/2018","12/04/2018","13/04/2018","50000000","49824950","99.6499","6.749234","Market"]
["14","CP - ADITYA BIRLA FA & RET-12/06/18","INE647O14AZ1","UTI Mutual Fund","Uti - Liquid Cash Plan","12/06/2018","60","T+0 Pur","13/04/2018","13/04/2018","13/04/2018","750000000","742047000","98.9571","6.519834","Off Market"]
["15","CP - INDIABULLS HSG FIN -11/06/18","INE148I14VF0","UTI Mutual Fund","Uti - Liquid Cash Plan","11/06/2018","60","T+1 Sal","12/04/2018","12/04/2018","13/04/2018","50000000","49481700","98.9634","6.480036","Market"]
["16","7.79% SRNCD LHF(308-1)-19/06/2020","INE115A07KI7","UTI Mutual Fund","Uti - Short Term Income Fund","19/06/2020","798","T+0 Pur","13/04/2018","13/04/2018","13/04/2018","250","249234750","996947","7.91511846","Interscheme"]
["17","8.93%SNCDPOWERGRID-STC-XLVII201018","INE752E07LS6","UTI Mutual Fund","Uti - Treasury Advantage Fund","20/10/2018","190","T+0 Pur","13/04/2018","13/04/2018","13/04/2018","100","100720800","1007163","7.31016561","Interscheme"]
["18","9.75% SRNCD REL UTIL & POW-02/08/24","INE936D07075","UTI Mutual Fund","Uti - Credit Risk Fund","02/08/2024","2304","T+1 Sal","12/04/2018","12/04/2018","13/04/2018","1000","1070344000","1066711","8.32274836","Market"]
["19","9.75% SRNCD REL UTIL & POW-02/08/24","INE936D07075","UTI Mutual Fund","Uti - Credit Risk Fund","02/08/2024","2303","T+0 Pur","13/04/2018","13/04/2018","13/04/2018","1000","1066544000","1066633","8.32393904","Market"]
["20","7.79% SRNCD LHF(308-1)-19/06/2020","INE115A07KI7","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","19/06/2020","798","T+0 Sal","13/04/2018","13/04/2018","13/04/2018","250","249234750","996947","7.91511846","Interscheme"]
["21","8.93%SNCDPOWERGRID-STC-XLVII201018","INE752E07LS6","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","20/10/2018","190","T+0 Sal","13/04/2018",null,"13/04/2018","100","100720800",null,null,"Interscheme"]
["22","8.30%SNCD JORABAT SHILLO -01/03/22.","INE944Y07042","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","01/03/2022","1418","T+0 Sal","13/04/2018","13/04/2018","13/04/2018","1000","100036100","99962","8.47301105","Interscheme"]