{"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":48,"n_cols":16,"rows_kept":48,"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.65%SRNCD JUBI LIF SC(3)27/01/2021","INE700A07030","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","27/01/2021","1055","T+0 Sal","09/03/2018",null,"09/03/2018","100","98285100",null,null,"Interscheme"]
["2","8.75% SRNCD VEDANTA(SR 3)15/04/2021","INE205A07063","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","15/04/2021","1133","T+0 Sal","09/03/2018","09/03/2018","09/03/2018","100","100775400","1007585","8.4921869","Interscheme"]
["3","7.90% SRNCD BHARAT ALUMIN-31/07/20","INE738C07069","UTI Mutual Fund","Uti - C.R.T.S. 1981","31/07/2020","875","T+0 Sal","09/03/2018","09/03/2018","09/03/2018","100","97941000","979227","8.8535593","Interscheme"]
["4","8.28% SRNCD O N B H L-SR-A-30/03/21","INE105N07092","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","30/03/2021","1117","T+0 Sal","09/03/2018","09/03/2018","09/03/2018","1000","100623100","100597.3","8.20719915","Interscheme"]
["5","9% SRNCD RHFL-SR B-16/03/2021","INE217K07661","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","16/03/2021","1103","T+0 Sal","09/03/2018",null,"09/03/2018","200","99346400",null,null,"Interscheme"]
["6","CP - EXIM BANK - 14/03/18","INE514E14LY4","UTI Mutual Fund","Uti - Money Market Fund","14/03/2018","5","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1000000000","999138000","99.931","6.300597","Market"]
["7","CP - INDIABULL COMM CREDIT-26/03/18","INE244L14AE8","UTI Mutual Fund","Uti - Money Market Fund","26/03/2018","17","T+0 Sal","09/03/2018",null,"09/03/2018","2700000000","2691162900",null,null,"Market"]
["8","CD - ICICI BANK - 16/03/18","INE090A167K9","UTI Mutual Fund","Uti - Money Market Fund","16/03/2018","7","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","750000000","749094750","99.8965","6.302773","Market"]
["9","CD - HDFC BANK - 20/03/18","INE040A16BM9","UTI Mutual Fund","Uti - Money Market Fund","20/03/2018","11","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","3750000000","3742893750","99.8277","6.299805","Market"]
["10","CD - ICICI BANK - 19/03/18","INE090A166K1","UTI Mutual Fund","Uti - Money Market Fund","19/03/2018","10","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1500000000","1497415500","99.8449","6.299938","Market"]
["11","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Bond Fund","30/11/2022","1727","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","500","488104000","977254","8.0274776","Interscheme"]
["12","CP - NATIONAL HSG BANK - 07/06/2018","INE557F14EE7","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","90","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1000000000","982675000","98.2864","7.150211","Market"]
["13","CP - NATIONAL HSG BANK - 07/06/2018","INE557F14EE7","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","90","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1000000000","982675000","98.2864","7.150211","Market"]
["14","CP - KOTAK SECURITIES-08/06/18","INE028E14DM7","UTI Mutual Fund","Uti - Liquid Cash Plan","08/06/2018","91","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1500000000","1470739500","98.0703","7.979996","Off Market"]
["15","CP - INDIABULLS HSG FIN - 07/06/18","INE148I14VD5","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","90","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","5000000000","4908855000","98.197","7.530093","Off Market"]
["16","CP - INDIABULLS COMM CRED-07/06/18","INE244L14AM1","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","90","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","5200000000","5101012800","98.1172","7.869767","Off Market"]
["17","CP - N A B A R D -05/06/18","INE261F14CP6","UTI Mutual Fund","Uti - Liquid Cash Plan","05/06/2018","88","T+0 Sal","09/03/2018","09/03/2018","09/03/2018","2000000000","1965874000","98.3128","7.19996","Market"]
["18","CP - CAPITAL FIRST - 23/03/18","INE688I14FI2","UTI Mutual Fund","Uti - Liquid Cash Plan","23/03/2018","14","T+0 Sal","09/03/2018","09/03/2018","09/03/2018","1000000000","997223000","99.7421","7.259761","Interscheme"]
["19","CD - INDUSIND BANK - 12/03/18","INE095A16WH9","UTI Mutual Fund","Uti - Liquid Cash Plan","12/03/2018","3","T+0 Sal","09/03/2018",null,"09/03/2018","2500000000","2498717500",null,null,"Market"]
["20","CD - INDUSIND BANK - 12/03/18","INE095A16WH9","UTI Mutual Fund","Uti - Liquid Cash Plan","12/03/2018","3","T+0 Sal","09/03/2018",null,"09/03/2018","500000000","499743500",null,null,"Market"]
["21","CD - INDUSIND BANK - 12/03/18","INE095A16WH9","UTI Mutual Fund","Uti - Liquid Cash Plan","12/03/2018","3","T+0 Sal","09/03/2018",null,"09/03/2018","1000000000","999487000",null,null,"Market"]
["22","CD - INDUSIND BANK - 12/03/18","INE095A16WH9","UTI Mutual Fund","Uti - Liquid Cash Plan","12/03/2018","3","T+0 Sal","09/03/2018",null,"09/03/2018","1000000000","999487000",null,null,"Market"]
["23","CD - AXIS BANK - 12/03/18","INE238A16W01","UTI Mutual Fund","Uti - Liquid Cash Plan","12/03/2018","3","T+0 Sal","09/03/2018","09/03/2018","09/03/2018","4650000000","4647516900","99.9644","6.499314","Market"]
["24","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Short Term Income Fund","08/03/2019","364","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","10000000000","9311270000","93.1303","7.417081","Market"]
["25","CD - AXIS BANK LTD - 07/03/19","INE238A16Z24","UTI Mutual Fund","Uti - Short Term Income Fund","07/03/2019","363","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","9000000000","8377623000","93.1239","7.445011","Off Market"]
["26","8.30%SNCD JORABAT SHILLO -01/03/21.","INE944Y07034","UTI Mutual Fund","Uti - Short Term Income Fund","01/03/2021","1088","T+0 Sal","09/03/2018","09/03/2018","09/03/2018","1000","99924700","99901.5","8.50452207","Interscheme"]
["27","9.5% SRNCD B B N HLSRC11/09/2020.","INE333L07037","UTI Mutual Fund","Uti - Short Term Income Fund","11/09/2020","917","T+0 Sal","09/03/2018","09/03/2018","09/03/2018","100","106434400","1064150","10.30589898","Interscheme"]
["28","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Treasury Advantage Fund","08/03/2019","364","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","9000000000","8380143000","93.1303","7.417081","Market"]
["29","CP - N A B A R D - 31/07/18","INE261F14CM3","UTI Mutual Fund","Uti - Floating Rate Fund Stp","31/07/2018","144","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","4000000000","3883556000","97.1788","7.410016","Off Market"]
["30","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Floating Rate Fund Stp","08/03/2019","364","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","500000000","465563500","93.1303","7.417081","Market"]
["31","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Floating Rate Fund Stp","08/03/2019","364","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","2000000000","1862254000","93.1303","7.417081","Market"]
["32","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Floating Rate Fund Stp","08/03/2019","364","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","500000000","465563500","93.1303","7.417081","Market"]
["33","CD - AXIS BANK LTD - 07/03/19","INE238A16Z24","UTI Mutual Fund","Uti - Floating Rate Fund Stp","07/03/2019","363","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1500000000","1396270500","93.1239","7.445011","Off Market"]
["34","CP - INDIABULL COMM CREDIT-26/03/18","INE244L14AE8","UTI Mutual Fund","Uti - Spread Fund","26/03/2018","17","T+0 Sal","09/03/2018",null,"09/03/2018","1000000000","996727000",null,null,"Market"]
["35","CP - CAPITAL FIRST - 23/03/18","INE688I14FI2","UTI Mutual Fund","Uti - Spread Fund","23/03/2018","14","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1000000000","997223000","99.7421","7.259761","Interscheme"]
["36","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Spread Fund","08/03/2019","364","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1250000000","1163908750","93.1303","7.417081","Market"]
["37","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Dynamic Bond Fund","08/03/2019","364","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1000000000","931127000","93.1303","7.417081","Market"]
["38","CD - AXIS BANK LTD - 07/03/19","INE238A16Z24","UTI Mutual Fund","Uti - Dynamic Bond Fund","07/03/2019","363","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1000000000","930847000","93.1239","7.445011","Off Market"]
["39","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Dynamic Bond Fund","30/11/2022","1727","T+0 Sal","09/03/2018","09/03/2018","09/03/2018","500","488104000","977254","8.0274776","Interscheme"]
["40","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Income Opportunities Fund","08/03/2019","364","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","2000000000","1862254000","93.1303","7.417081","Market"]
["41","8.28% SRNCD O N B H L-SR-A-30/03/21","INE105N07092","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan X (1153 Days)","30/03/2021","1117","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1000","100623100","100597.3","8.20719915","Interscheme"]
["42","9% SRNCD RHFL-SR B-16/03/2021","INE217K07661","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan X (1153 Days)","16/03/2021","1103","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","200","99346400","496740","9.24619201","Interscheme"]
["43","8.30%SNCD JORABAT SHILLO -01/03/21.","INE944Y07034","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan X (1153 Days)","01/03/2021","1088","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","1000","99924700","99901.5","8.50452207","Interscheme"]
["44","9.5% SRNCD B B N HLSRC11/09/2020.","INE333L07037","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan X (1153 Days)","11/09/2020","917","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","100","106434400","1064150","10.30589898","Interscheme"]
["45","7.90% SRNCD BHARAT ALUMIN-31/07/20","INE738C07069","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan X (1153 Days)","31/07/2020","875","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","100","97941000","979227","8.8535593","Interscheme"]
["46","8.65%SRNCD JUBI LIF SC(3)27/01/2021","INE700A07030","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan X (1153 Days)","27/01/2021","1055","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","100","98285100","982628","9.55318902","Interscheme"]
["47","8.75% SRNCD VEDANTA(SR 3)15/04/2021","INE205A07063","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan X (1153 Days)","15/04/2021","1133","T+0 Pur","09/03/2018","09/03/2018","09/03/2018","100","100775400","1007585","8.4921869","Interscheme"]