{"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":32,"n_cols":16,"rows_kept":32,"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 - HDFC LTD. - 07/06/2018","INE001A14RY7","UTI Mutual Fund","Uti - Money Market Fund","07/06/2018","83","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","250000000","246222250","98.4572","6.974951","Market"]
["2","CP - HDFC LTD. - 07/06/2018","INE001A14RY7","UTI Mutual Fund","Uti - Money Market Fund","07/06/2018","83","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","750000000","738666750","98.4572","6.974951","Market"]
["3","CP - MAGMA FINCORP - 27/03/18","INE511C14RN4","UTI Mutual Fund","Uti - Money Market Fund","27/03/2018","11","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","50000000","49907000","99.7676","8.502359","Market"]
["4","CP - MAGMA FINCORP LTD.-28/03/18","INE511C14RJ2","UTI Mutual Fund","Uti - Money Market Fund","28/03/2018","12","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","50000000","49895400","99.7444","8.503006","Market"]
["5","CP - BAHADUR CHAND INVT -08/05/18","INE087M14116","UTI Mutual Fund","Uti - Money Market Fund","08/05/2018","53","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","50000000","49397750","98.7479","8.900218","Market"]
["6","CP - BAHADUR CHAND INVT -23/04/18","INE087M14199","UTI Mutual Fund","Uti - Money Market Fund","23/04/2018","38","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","50000000","49576900","99.1059","8.899748","Market"]
["7","CP - CHENNAI PETRO CORP-28/03/18","INE178A14CM0","UTI Mutual Fund","Uti - Money Market Fund","28/03/2018","9","T+0 Pur","19/03/2018","19/03/2018","19/03/2018","5000000000","4991520000","99.8492","6.890641","Off Market"]
["8","CD - SOUTH INDIAN BANK-25/04/18","INE683A16KD6","UTI Mutual Fund","Uti - Money Market Fund","25/04/2018","40","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","50000000","49602750","99.1629","7.900533","Market"]
["9","CP - TMF HOLDINGS LTD -24/04/18","INE909H14MA7","UTI Mutual Fund","Uti - Liquid Cash Plan","24/04/2018","39","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","50000000","49564900","99.0819","8.900306","Market"]
["10","CP - BAHADUR CHAND INVT -04/05/18","INE087M14223","UTI Mutual Fund","Uti - Liquid Cash Plan","04/05/2018","49","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","50000000","49445400","98.8431","8.900227","Market"]
["11","CP - HDFC LTD -03/04/18","INE001A14RW1","UTI Mutual Fund","Uti - Liquid Cash Plan","03/04/2018","18","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","50000000","49815950","99.583","8.990727","Market"]
["12","CP - TATA CAP FIN - 02/05/2018","INE306N14MR8","UTI Mutual Fund","Uti - Liquid Cash Plan","02/05/2018","47","T+3 Sal","16/03/2018","16/03/2018","19/03/2018","50000000","49472200","98.8969","8.850488","Market"]
["13","CP - SHRIRAM CITY UNION FIN-30/4/18","INE722A14BU0","UTI Mutual Fund","Uti - Liquid Cash Plan","30/04/2018","45","T+3 Sal","16/03/2018","16/03/2018","19/03/2018","50000000","49493150","98.9385","8.9001","Market"]
["14","CP - KOTAK SECURITIES-15/05/18","INE028E14DK1","UTI Mutual Fund","Uti - Liquid Cash Plan","15/05/2018","60","T+3 Sal","16/03/2018","16/03/2018","19/03/2018","50000000","49345000","98.6447","8.499679","Market"]
["15","CP - RELIANCE JIOP INFO-23/03/18","INE110L14FY8","UTI Mutual Fund","Uti - Liquid Cash Plan","23/03/2018","4","T+0 Sal","19/03/2018",null,"19/03/2018","600000000","599586000",null,null,"Market"]
["16","CP - RELIANCE JIOP INFO-23/03/18","INE110L14FY8","UTI Mutual Fund","Uti - Liquid Cash Plan","23/03/2018","4","T+0 Sal","19/03/2018",null,"19/03/2018","1850000000","1848723500",null,null,"Market"]
["17","CP - HIND PETRO CORP LTD-28/03/18","INE094A14CW8","UTI Mutual Fund","Uti - Liquid Cash Plan","28/03/2018","9","T+0 Sal","19/03/2018","19/03/2018","19/03/2018","1000000000","998412000","99.8588","6.451359","Market"]
["18","CP - HIND PETRO CORP LTD-28/03/18","INE094A14CW8","UTI Mutual Fund","Uti - Liquid Cash Plan","28/03/2018","9","T+0 Sal","19/03/2018","19/03/2018","19/03/2018","1000000000","998412000","99.8588","6.451359","Market"]
["19","CD - DENA BANK - 15/06/18","INE077A16ET0","UTI Mutual Fund","Uti - Liquid Cash Plan","15/06/2018","88","T+0 Pur","19/03/2018","19/03/2018","19/03/2018","1000000000","983403000","98.3589","6.999951","Market"]
["20","CD - DENA BANK - 15/06/18","INE077A16ET0","UTI Mutual Fund","Uti - Liquid Cash Plan","15/06/2018","88","T+0 Pur","19/03/2018","19/03/2018","19/03/2018","2000000000","1966806000","98.3589","6.999951","Market"]
["21","CD - ICICI BANK - 28/03/18","INE090A162O2","UTI Mutual Fund","Uti - Liquid Cash Plan","28/03/2018","12","T+3 Sal","16/03/2018","16/03/2018","19/03/2018","50000000","49912600","99.7864","7.102808","Market"]
["22","8.3406% SRNCD CHOL INVTN 19/09/2019","INE121A07OG1","UTI Mutual Fund","Uti - Treasury Advantage Fund","19/09/2019","549","T+0 Pur","19/03/2018","19/03/2018","19/03/2018","2000","2000000000","1000000","8.51366507","Off Market"]
["23","7.90% URNCD NABARD(16F)27/11/2018","INE261F08550","UTI Mutual Fund","Uti - Floating Rate Fund Stp","27/11/2018","253","T+0 Pur","19/03/2018","19/03/2018","19/03/2018","1500","1503171000","1002105","7.48253661","Market"]
["24","9.38% SRNCD R E C - 06.11.18","INE020B07HY0","UTI Mutual Fund","Uti - Floating Rate Fund Stp","06/11/2018","232","T+0 Pur","19/03/2018","19/03/2018","19/03/2018","1400","1414501200","1010331","7.51592685","Market"]
["25","9.38% SRNCD R E C - 06.11.18","INE020B07HY0","UTI Mutual Fund","Uti - Floating Rate Fund Stp","06/11/2018","232","T+0 Pur","19/03/2018","19/03/2018","19/03/2018","250","252589500","1010331","7.51592685","Market"]
["26","7.90% URNCD NABARD(16F)27/11/2018","INE261F08550","UTI Mutual Fund","Uti - Floating Rate Fund Stp","27/11/2018","253","T+0 Pur","19/03/2018","19/03/2018","19/03/2018","250","250528500","1002105","7.48253661","Market"]
["27","SBI1YR BMK+105 BPS ECSL -12/02/2021","INE657N07456","UTI Mutual Fund","Uti - Income Opportunities Fund","12/02/2021","1061","T+0 Pur","19/03/2018","19/03/2018","19/03/2018","50","50035700","1000822","8.94471297","Interscheme"]
["28","9.75% SRNCD REL UTIL & POW-02/08/24","INE936D07075","UTI Mutual Fund","Uti - Income Opportunities Fund","02/08/2024","2331","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","250","263222250","1053098","8.60640499","Market"]
["29","9.75% SRNCD REL UTIL & POW-02/08/24","INE936D07075","UTI Mutual Fund","Uti - Income Opportunities Fund","02/08/2024","2331","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","850","894955650","1053098","8.60640499","Market"]
["30","SBI1YR BMK+105 BPS ECSL -12/02/2021","INE657N07456","UTI Mutual Fund","Uti - Medium Term Fund","12/02/2021","1061","T+0 Sal","19/03/2018",null,"19/03/2018","50","50035700",null,null,"Interscheme"]
["31","9.75% SRNCD REL UTIL & POW-02/08/24","INE936D07075","UTI Mutual Fund","Uti - Medium Term Fund","02/08/2024","2331","T+3 Pur","16/03/2018","16/03/2018","19/03/2018","150","157933350","1053098","8.60640499","Market"]