{"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":34,"n_cols":16,"rows_kept":34,"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","CP - VEDANTA LTD -28/05/18","INE205A14MF4","UTI Mutual Fund","Uti - Money Market Fund","28/05/2018","49","T+1 Pur","09/04/2018","09/04/2018","10/04/2018","50000000","49582700","99.1654","6.399851","Market"]
["2","CP - TRAPTI- 02/05/2018","INE977J14GI5","UTI Mutual Fund","Uti - Money Market Fund","02/05/2018","23","T+1 Pur","09/04/2018","09/04/2018","10/04/2018","50000000","49804850","99.6097","6.500804","Market"]
["3","CP - SHRIRAM TRANSP FIN CO-21/06/18","INE721A14BB2","UTI Mutual Fund","Uti - Money Market Fund","21/06/2018","73","T+1 Sal","09/04/2018","09/04/2018","10/04/2018","1000000000","986572000","98.6491","6.942093","Market"]
["4","CP - SHRIRAM TRANSP FIN CO-21/06/18","INE721A14BB2","UTI Mutual Fund","Uti - Money Market Fund","21/06/2018","73","T+1 Sal","09/04/2018","09/04/2018","10/04/2018","3000000000","2959716000","98.6491","6.942093","Market"]
["5","CP - ALTICO CAPITAL-04/06/18","INE587O14137","UTI Mutual Fund","Uti - Money Market Fund","04/06/2018","55","T+0 Sal","10/04/2018",null,"10/04/2018","2350000000","2323040800",null,null,"Interscheme"]
["6","CP - IFMR CAP FINANCE-02/05/18","INE850M14679","UTI Mutual Fund","Uti - Money Market Fund","02/05/2018","22","T+0 Sal","10/04/2018",null,"10/04/2018","500000000","497396000",null,null,"Interscheme"]
["7","CP - IFMR CAPITAL FINANCE-07/05/18","INE850M14687","UTI Mutual Fund","Uti - Money Market Fund","07/05/2018","27","T+0 Sal","10/04/2018",null,"10/04/2018","500000000","496851000",null,null,"Interscheme"]
["8","CP - KEC INTERNATIONAL-11/06/18","INE389H14CW7","UTI Mutual Fund","Uti - Liquid Cash Plan","11/06/2018","62","T+0 Pur","10/04/2018","10/04/2018","10/04/2018","1000000000","988947000","98.9123","6.579939","Off Market"]
["9","CP - RASH CHEM & FERT-29/06/18","INE027A14257","UTI Mutual Fund","Uti - Liquid Cash Plan","29/06/2018","80","T+0 Pur","10/04/2018","10/04/2018","10/04/2018","1500000000","1478674500","98.5958","6.580158","Off Market"]
["10","CP - KOTAK SECURITIES-08/06/18","INE028E14DM7","UTI Mutual Fund","Uti - Liquid Cash Plan","08/06/2018","60","T+1 Sal","09/04/2018","09/04/2018","10/04/2018","50000000","49460350","98.9207","6.749877","Market"]
["11","CP - INDIABULLS COMM CRED-07/06/18","INE244L14AM1","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","59","T+1 Sal","09/04/2018","09/04/2018","10/04/2018","50000000","49465500","98.931","6.80002","Market"]
["12","CP - SHRIRAM TRANSP FIN CO-21/06/18","INE721A14BB2","UTI Mutual Fund","Uti - Liquid Cash Plan","21/06/2018","72","T+0 Sal","10/04/2018","10/04/2018","10/04/2018","1000000000","986572000","98.668","6.940047","Market"]
["13","CP - ALTICO CAPITAL-04/06/18","INE587O14137","UTI Mutual Fund","Uti - Liquid Cash Plan","04/06/2018","55","T+0 Pur","10/04/2018","10/04/2018","10/04/2018","2350000000","2323040800","98.8734","7.701749","Interscheme"]
["14","CP - IFMR CAP FINANCE-02/05/18","INE850M14679","UTI Mutual Fund","Uti - Liquid Cash Plan","02/05/2018","22","T+0 Pur","10/04/2018","10/04/2018","10/04/2018","500000000","497396000","99.5028","8.684991","Interscheme"]
["15","CP - IFMR CAPITAL FINANCE-07/05/18","INE850M14687","UTI Mutual Fund","Uti - Liquid Cash Plan","07/05/2018","27","T+0 Pur","10/04/2018","10/04/2018","10/04/2018","500000000","496851000","99.3934","8.567702","Interscheme"]
["16","CD - SOUTH INDIAN BANK-25/04/18","INE683A16KD6","UTI Mutual Fund","Uti - Liquid Cash Plan","25/04/2018","15","T+0 Pur","10/04/2018","10/04/2018","10/04/2018","2000000000","1994794000","99.757","6.35079","Market"]
["17","CD - ANDHRA BANK - 25/06/18","INE434A16PD3","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","76","T+0 Sal","10/04/2018","10/04/2018","10/04/2018","2000000000","1973942000","98.714","6.340067","Market"]
["18","CD - ANDHRA BANK - 25/06/18","INE434A16PD3","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","76","T+0 Sal","10/04/2018","10/04/2018","10/04/2018","2000000000","1973942000","98.714","6.340067","Market"]
["19","CD - ICICI BANK - 28/05/18","INE090A165P2","UTI Mutual Fund","Uti - Liquid Cash Plan","28/05/2018","48","T+0 Pur","10/04/2018","10/04/2018","10/04/2018","1000000000","991654000","99.1826","6.400209","Interscheme"]
["20","CD - ICICI BANK - 28/05/18","INE090A165P2","UTI Mutual Fund","Uti - Liquid Cash Plan","28/05/2018","48","T+0 Pur","10/04/2018","10/04/2018","10/04/2018","1000000000","991654000","99.1826","6.400209","Interscheme"]
["21","CD - ICICI BANK - 28/05/18","INE090A165P2","UTI Mutual Fund","Uti - Short Term Income Fund","28/05/2018","48","T+0 Sal","10/04/2018",null,"10/04/2018","1000000000","991654000",null,null,"Interscheme"]
["22","CD - ICICI BANK - 28/05/18","INE090A165P2","UTI Mutual Fund","Uti - Treasury Advantage Fund","28/05/2018","48","T+0 Sal","10/04/2018",null,"10/04/2018","500000000","495827000",null,null,"Market"]
["23","CD - ICICI BANK - 28/05/18","INE090A165P2","UTI Mutual Fund","Uti - Treasury Advantage Fund","28/05/2018","48","T+0 Sal","10/04/2018",null,"10/04/2018","1000000000","991654000",null,null,"Interscheme"]
["24","8.20% URNCD NABARD(G-PA3)16/03/2028","INE261F08AE6","UTI Mutual Fund","Uti - Dynamic Bond Fund","16/03/2028","3629","T+1 Sal","09/04/2018","09/04/2018","10/04/2018","100","103032000","1030508","7.89631408","Market"]
["25","7.85% URNCD PFC (SR177)-03/04/2028","INE134E08JP5","UTI Mutual Fund","Uti - Dynamic Bond Fund","03/04/2028","3647","T+1 Sal","09/04/2018",null,"10/04/2018","450","450207000",null,null,"Market"]
["26","8.20% URNCD NABARD(G-PA3)16/03/2028","INE261F08AE6","UTI Mutual Fund","Uti - Dynamic Bond Fund","16/03/2028","3628","T+0 Sal","10/04/2018",null,"10/04/2018","250","255741250",null,null,"Market"]
["27","9.15% URNCD-EXIM BANK -05/09/2022","INE514E08BK6","UTI Mutual Fund","Uti - Dynamic Bond Fund","05/09/2022","1609","T+0 Pur","10/04/2018","10/04/2018","10/04/2018","250","263592250","1052084","7.68338591","Interscheme"]
["28","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Dynamic Bond Fund","30/11/2022","1695","T+0 Pur","10/04/2018","10/04/2018","10/04/2018","250","247901750","989349","7.71021281","Interscheme"]
["29","7.97%SHRIRAM CITY UNION-27/10/2020","INE722A07760","UTI Mutual Fund","Uti - Credit Risk Fund","27/10/2020","932","T+1 Sal","09/04/2018","09/04/2018","10/04/2018","100","98663600","988269","8.4557789","Market"]
["30","9% UNCD YES BANK(PERP)-18/10/2022","INE528G08394","UTI Mutual Fund","Uti - Credit Risk Fund","18/10/2022","1652","T+0 Sal","10/04/2018",null,"10/04/2018","100","98633700",null,null,"Market"]
["31","8.75%SRNCD EDEL RETFIN-2-22/03/2021","INE528S07086","UTI Mutual Fund","Uti - Credit Risk Fund","22/03/2021","1078","T+1 Pur","09/04/2018","09/04/2018","10/04/2018","1000000","987182000","987.293","9.24548191","Market"]
["32","9.15% URNCD-EXIM BANK -05/09/2022","INE514E08BK6","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","05/09/2022","1609","T+0 Sal","10/04/2018",null,"10/04/2018","250","263592250",null,null,"Interscheme"]
["33","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","30/11/2022","1695","T+0 Sal","10/04/2018",null,"10/04/2018","250","247901750",null,null,"Interscheme"]