{"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":68,"n_cols":16,"rows_kept":68,"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.70% UNCD TATA MOTORS-18/06/2020","INE155A08068","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","18/06/2020","902","T+0 Sal","29/12/2017","29/12/2017","29/12/2017","200","207794000","1040499","7.78163142","Interscheme"]
["2","9.70% UNCD TATA MOTORS-18/06/2020","INE155A08068","UTI Mutual Fund","Uti - Short Term Income Fund","18/06/2020","902","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","200","207794000","1040499","7.78163142","Interscheme"]
["3","9.5% SRNCD B B N H L-SRC14/09/2020","INE333L07060","UTI Mutual Fund","Uti - Short Term Income Fund","14/09/2020","990","T+0 Sal","29/12/2017",null,"29/12/2017","510","541242600",null,null,"Interscheme"]
["4","9.5% SRNCD B B N H L-SRC14/09/2020","INE333L07060","UTI Mutual Fund","Uti - Floating Rate Fund Stp","14/09/2020","990","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","510","541242600","1062916","10.29477545","Interscheme"]
["5","11% SRNCD D H F L -12/09/2019","INE202B07654","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","12/09/2019","622","T+0 Sal","29/12/2017",null,"29/12/2017","500","524378500",null,null,"Interscheme"]
["6","11% SRNCD D H F L -12/09/2019","INE202B07654","UTI Mutual Fund","Uti - Treasury Advantage Fund","12/09/2019","622","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","500","524378500","1049247","8.59413983","Interscheme"]
["7","8.12% SRNCD ONGC M P L-10/06/2019","INE053T07026","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","10/06/2019","528","T+0 Sal","29/12/2017",null,"29/12/2017","191","192234815",null,null,"Interscheme"]
["8","8.12% SRNCD ONGC M P L-10/06/2019","INE053T07026","UTI Mutual Fund","Uti - Short Term Income Fund","10/06/2019","528","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","191","192234815","1007389","7.54997328","Interscheme"]
["9","8.75% SRNCD LIC HSG FIN-08/03/2021","INE115A07IY8","UTI Mutual Fund","Uti - Short Term Income Fund","08/03/2021","1165","T+0 Sal","29/12/2017","29/12/2017","29/12/2017","250","255212750","1022225","7.90804234","Interscheme"]
["10","8.75% SRNCD LIC HSG FIN-08/03/2021","INE115A07IY8","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Iv (1204 Days)","08/03/2021","1165","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","250","255212750","1022225","7.90804234","Interscheme"]
["11","7.99%UNCD TATA POWER(SR1)16/11/2020","INE245A08091","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","16/11/2020","1053","T+0 Sal","29/12/2017","29/12/2017","29/12/2017","60","59675760","996326","8.11753775","Interscheme"]
["12","7.99%UNCD TATA POWER(SR1)16/11/2020","INE245A08091","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Iii (1203 Days)","16/11/2020","1053","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","60","59675760","996326","8.11753775","Interscheme"]
["13","7.95%0SNCD PNB H F(SR29)-18/10/2019","INE572E09395","UTI Mutual Fund","Uti - Floating Rate Fund Stp","18/10/2019","658","T+0 Sal","29/12/2017",null,"29/12/2017","100","99879100",null,null,"Market"]
["14","7.95%0SNCD PNB H F(SR29)-18/10/2019","INE572E09395","UTI Mutual Fund","Uti - Floating Rate Fund Stp","18/10/2019","658","T+0 Sal","29/12/2017",null,"29/12/2017","250","249697750",null,null,"Market"]
["15","7.95%0SNCD PNB H F(SR29)-18/10/2019","INE572E09395","UTI Mutual Fund","Uti - Floating Rate Fund Stp","18/10/2019","659","T+1 Sal","28/12/2017","28/12/2017","29/12/2017","250","249697750","999032","8.01468623","Market"]
["16","8.65%SRNCD JUBI LIF SC(3)27/01/2021","INE700A07030","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","27/01/2021","1125","T+0 Sal","29/12/2017","29/12/2017","29/12/2017","60","59033820","985780","9.38895682","Interscheme"]
["17","8.65%SRNCD JUBI LIF SC(3)27/01/2021","INE700A07030","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Iii (1203 Days)","27/01/2021","1125","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","60","59033820","985780","9.38895682","Interscheme"]
["18","9.5% SRNCD B B N HLSRA11/09/2018","INE333L07011","UTI Mutual Fund","Uti - Treasury Advantage Fund","11/09/2018","256","T+0 Sal","29/12/2017",null,"29/12/2017","1500","1571404500",null,null,"Interscheme"]
["19","9.5% SRNCD B B N HLSRA11/09/2018","INE333L07011","UTI Mutual Fund","Uti - Short Term Income Fund","11/09/2018","256","T+0 Sal","29/12/2017",null,"29/12/2017","250","261900750",null,null,"Interscheme"]
["20","9.5% SRNCD B B N HLSRA11/09/2018","INE333L07011","UTI Mutual Fund","Uti - Floating Rate Fund Stp","11/09/2018","256","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","1500","1571404500","1047663","9.51496744","Interscheme"]
["21","9.5% SRNCD B B N HLSRA11/09/2018","INE333L07011","UTI Mutual Fund","Uti - Floating Rate Fund Stp","11/09/2018","256","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","250","261900750","1047663","9.51496744","Interscheme"]
["22","9.5% SRNCD B B N HLSRB11/09/2019","INE333L07029","UTI Mutual Fund","Uti - Short Term Income Fund","11/09/2019","621","T+0 Sal","29/12/2017",null,"29/12/2017","500","528054000",null,null,"Interscheme"]
["23","9.5% SRNCD B B N HLSRB11/09/2019","INE333L07029","UTI Mutual Fund","Uti - Floating Rate Fund Stp","11/09/2019","621","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","500","528054000","1057191","10.03494193","Interscheme"]
["24","9.5% SRNCD B B N HLSRC11/09/2020","INE333L07037","UTI Mutual Fund","Uti - Short Term Income Fund","11/09/2020","987","T+0 Sal","29/12/2017",null,"29/12/2017","1200","1273370400",null,null,"Interscheme"]
["25","9.5% SRNCD B B N HLSRC11/09/2020","INE333L07037","UTI Mutual Fund","Uti - Short Term Income Fund","11/09/2020","987","T+0 Sal","29/12/2017",null,"29/12/2017","710","753410820",null,null,"Interscheme"]
["26","9.5% SRNCD B B N HLSRC11/09/2020","INE333L07037","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","11/09/2020","987","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","1200","1273370400","1062795","10.29647311","Interscheme"]
["27","9.5% SRNCD B B N HLSRC11/09/2020","INE333L07037","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","11/09/2020","987","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","710","753410820","1062795","10.29647311","Interscheme"]
["28","7.6%URNCD AXIS BANK(SR3)20/10/2023","INE238A08401","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","20/10/2023","2121","T+0 Sal","29/12/2017",null,"29/12/2017","500","493885000",null,null,"Interscheme"]
["29","7.6%URNCD AXIS BANK(SR3)20/10/2023","INE238A08401","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","20/10/2023","2121","T+0 Sal","29/12/2017",null,"29/12/2017","500","493885000",null,null,"Interscheme"]
["30","7.6%URNCD AXIS BANK(SR3)20/10/2023","INE238A08401","UTI Mutual Fund","Uti - Short Term Income Fund","20/10/2023","2121","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","500","493885000","988893","7.83157998","Interscheme"]
["31","7.6%URNCD AXIS BANK(SR3)20/10/2023","INE238A08401","UTI Mutual Fund","Uti - Short Term Income Fund","20/10/2023","2121","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","500","493885000","988893","7.83157998","Interscheme"]
["32","0% SRNCD IDFC OBB-05-II-25/04/2018","INE092T08AB2","UTI Mutual Fund","Uti - Treasury Advantage Fund","25/04/2018","117","T+0 Sal","29/12/2017",null,"29/12/2017","1000","1244024000",null,null,"Market"]
["33","9.45% SNCD VEDANTA-17/08/2020","INE205A07030","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","17/08/2020","962","T+0 Sal","29/12/2017","29/12/2017","29/12/2017","59","60475885","1027207","8.2117213","Interscheme"]
["34","9.45% SNCD VEDANTA-17/08/2020","INE205A07030","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Iii (1203 Days)","17/08/2020","962","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","59","60475885","1027207","8.2117213","Interscheme"]
["35","7.83% SRNCD IRFC-SR118-21/03/2027.","INE053F07983","UTI Mutual Fund","Uti - Bond Fund","21/03/2027","3370","T+1 Sal","28/12/2017",null,"29/12/2017","250","249415250",null,null,"Market"]
["36","7.83% SRNCD IRFC-SR118-21/03/2027.","INE053F07983","UTI Mutual Fund","Uti - Bond Fund","21/03/2027","3370","T+1 Sal","28/12/2017",null,"29/12/2017","250","249415250",null,null,"Market"]
["37","CP - N A B A R D -30/01/18","INE261F14CA8","UTI Mutual Fund","Uti - Floating Rate Fund Stp","30/01/2018","32","T+0 Sal","29/12/2017",null,"29/12/2017","500000000","497295500",null,null,"Interscheme"]
["38","CP - N A B A R D -30/01/18","INE261F14CA8","UTI Mutual Fund","Uti - Income Opportunities Fund","30/01/2018","32","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","500000000","497295500","99.4759","6.203367","Interscheme"]
["39","CP - RELIANCE JIO INFO - 01/02/2018","INE110L14FE0","UTI Mutual Fund","Uti - Money Market Fund","01/02/2018","34","T+0 Sal","29/12/2017",null,"29/12/2017","2000000000","1988466000",null,null,"Interscheme"]
["40","CP - RELIANCE JIO INFO - 01/02/2018","INE110L14FE0","UTI Mutual Fund","Uti - Liquid Cash Plan","01/02/2018","34","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","2000000000","1988466000","99.4402","6.226584","Interscheme"]
["41","CD - RBL BANK - 02/02/18","INE976G16GK4","UTI Mutual Fund","Uti - Money Market Fund","02/02/2018","35","T+0 Sal","29/12/2017",null,"29/12/2017","1500000000","1491087000",null,null,"Interscheme"]
["42","CD - RBL BANK - 02/02/18","INE976G16GK4","UTI Mutual Fund","Uti - Liquid Cash Plan","02/02/2018","35","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","1500000000","1491087000","99.4227","6.233471","Interscheme"]
["43","CP - BHARAT ALUMN CO -07/02/18","INE738C14DW4","UTI Mutual Fund","Uti - Money Market Fund","07/02/2018","40","T+0 Sal","29/12/2017","29/12/2017","29/12/2017","1300000000","1291104100","99.3307","6.306169","Interscheme"]
["44","CP - BHARAT ALUMN CO -07/02/18","INE738C14DW4","UTI Mutual Fund","Uti - Liquid Cash Plan","07/02/2018","40","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","1300000000","1291104100","99.3307","6.306169","Interscheme"]
["45","8.30%SNCD JORABAT SHILLO -01/03/19","INE944Y07018","UTI Mutual Fund","Uti - Treasury Advantage Fund","01/03/2019","427","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","6604","660400000","100007.2","8.4820959","Market"]
["46","8.30%SNCD JORABAT SHILLO -28/02/20","INE944Y07026","UTI Mutual Fund","Uti - Short Term Income Fund","28/02/2020","791","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","3823","382300000","99968.1","8.49891899","Market"]
["47","8.30%SNCD JORABAT SHILLO -01/03/21","INE944Y07034","UTI Mutual Fund","Uti - Short Term Income Fund","01/03/2021","1158","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","4021","402100000","99958.2","8.48738547","Market"]
["48","8.30%SNCD JORABAT SHILLO -01/03/22","INE944Y07042","UTI Mutual Fund","Uti - Short Term Income Fund","01/03/2022","1523","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","1500","150000000","99916.4","8.49677596","Market"]
["49","8.30%SNCD JORABAT SHILLO -01/03/22","INE944Y07042","UTI Mutual Fund","Uti - Short Term Income Fund","01/03/2022","1523","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","3049","304900000","99916.4","8.49677596","Market"]
["50","8.30%SNCD JORABAT SHILLO -01/03/23","INE944Y07059","UTI Mutual Fund","Uti - Short Term Income Fund","01/03/2023","1888","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","4282","428200000","100000","8.47170876","Market"]
["51","8.30%SNCD JORABAT SHILLO -01/03/24","INE944Y07067","UTI Mutual Fund","Uti - Dynamic Bond Fund","01/03/2024","2254","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","4619","461900000","100000","8.46869292","Market"]
["52","8.30%SNCD JORABAT SHILLO -28/02/25","INE944Y07075","UTI Mutual Fund","Uti - Bond Fund","28/02/2025","2618","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","4942","494200000","100000","8.46911539","Market"]
["53","8.30%SNCD JORABAT SHILLO -27/02/26","INE944Y07083","UTI Mutual Fund","Uti - Balanced Fund","27/02/2026","2982","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","6119","611900000","100000","8.46942816","Market"]
["54","8.30%SNCD JORABAT SHILLO -01/03/27","INE944Y07091","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","01/03/2027","3349","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","3000","300000000","100000","8.46956351","Market"]
["55","8.30%SNCD JORABAT SHILLO -01/03/27","INE944Y07091","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","01/03/2027","3349","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","3582","358200000","100000","8.46956351","Market"]
["56","8.30%SNCD JORABAT SHILLO -01/03/28","INE944Y07109","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","01/03/2028","3715","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","6177","617700000","100000","8.46817806","Market"]
["57","8.30%SNCD JORABAT SHILLO -01/03/29","INE944Y07117","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","01/03/2029","4080","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","3360","336000000","100000","8.46840728","Market"]
["58","8.30%SNCD JORABAT SHILLO -01/03/29","INE944Y07117","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","01/03/2029","4080","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","3239","323900000","100000","8.46840728","Market"]
["59","8.30%SNCD JORABAT SHILLO -31/01/30","INE944Y07125","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","31/01/2030","4416","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","5803","580300000","100000","8.46915634","Market"]
["60","CP - CREDI SUISSE FIN-22/03/18","INE996L14144","UTI Mutual Fund","Uti - Liquid Cash Plan","22/03/2018","83","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","1000000000","984442000","98.4627","6.949697","Off Market"]
["61","0% SRNCD I I HFL (SR-B8)06/04/2021",null,"UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Iii (1203 Days)","06/04/2021","1194","T+0 Pur","29/12/2017",null,"29/12/2017","60","60298740",null,null,"Off Market"]
["62","0% SRNCD I I HFL (SR-B8)06/04/2021",null,"UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Ii (1210 Days)","06/04/2021","1194","T+0 Pur","29/12/2017",null,"29/12/2017","60","60298740",null,null,"Off Market"]
["63","7.40% URNCD NABARD(SR18H)01/02/2021","INE261F08956","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","01/02/2021","1130","T+0 Sal","29/12/2017","29/12/2017","29/12/2017","290","287943900","995625","7.56264309","Interscheme"]
["64","7.40% URNCD NABARD(SR18H)01/02/2021","INE261F08956","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Iv (1204 Days)","01/02/2021","1130","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","290","287943900","995625","7.56264309","Interscheme"]
["65","CP - REL HOME FINANCE-27/02/18","INE217K14CZ7","UTI Mutual Fund","Uti - Liquid Cash Plan","27/02/2018","60","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","3000000000","2963559000","98.8053","7.480308","Off Market"]
["66","CP - CENTURY TEXT & INDS-09/03/18","INE055A14FT8","UTI Mutual Fund","Uti - Liquid Cash Plan","09/03/2018","70","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","4000000000","3949628000","98.7585","6.649914","Off Market"]
["67","CP - L&T FINANCE - 27/03/18","INE027E14EY2","UTI Mutual Fund","Uti - Liquid Cash Plan","27/03/2018","88","T+0 Pur","29/12/2017","29/12/2017","29/12/2017","3000000000","2950560000","98.3704","6.950086","Off Market"]