{"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","9.02% URNCD R E C - 19/11/2022","INE020B08807","UTI Mutual Fund","Uti - Medium Term Fund","19/11/2022","1821","T+3 Sal","24/11/2017","24/11/2017","27/11/2017","3","3188118","1064647","7.41570067","Market"]
["2","9.02% URNCD R E C - 19/11/2022","INE020B08807","UTI Mutual Fund","Uti - Medium Term Fund","19/11/2022","1821","T+3 Sal","24/11/2017","24/11/2017","27/11/2017","47","49947182","1064647","7.41570067","Market"]
["3","0% SNCD KKR FIN SERV (SR-4)-16/1/21","INE321N07046","UTI Mutual Fund","Uti - Floating Rate Fund Stp","16/01/2021","1146","T+0 Sal","27/11/2017","27/11/2017","27/11/2017","11","152724000","13887290","9.03099549","Interscheme"]
["4","0% SNCD KKR FIN SERV (SR-4)-16/1/21","INE321N07046","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan I (1230 Days)","16/01/2021","1146","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","11","152724000","13887290","9.03099549","Interscheme"]
["5","9.5% SRNCD B B N H L-SRC14/09/2020","INE333L07060","UTI Mutual Fund","Uti - Short Term Income Fund","14/09/2020","1022","T+0 Sal","27/11/2017","27/11/2017","27/11/2017","140","149861460","1070093","9.97019207","Interscheme"]
["6","9.5% SRNCD B B N H L-SRC14/09/2020","INE333L07060","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan I (1230 Days)","14/09/2020","1022","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","140","149861460","1070093","9.97019207","Interscheme"]
["7","7.99%UNCD TATA POWER(SR1)16/11/2020","INE245A08091","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan I (1230 Days)","16/11/2020","1085","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","120","120552720","1004689","7.79630925","Market"]
["8","7.99%UNCD TATA POWER(SR1)16/11/2020","INE245A08091","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","16/11/2020","1085","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","130","130598780","1004689","7.79630925","Market"]
["9","CP - PIRAMAL ENTERPRISES-23/02/18","INE140A14QK4","UTI Mutual Fund","Uti - Liquid Cash Plan","23/02/2018","88","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","2000000000","1968908000","98.4871","6.444726","Market"]
["10","8.65%SRNCD JUBI LIF SC(3)27/01/2021","INE700A07030","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","27/01/2021","1157","T+0 Sal","27/11/2017","27/11/2017","27/11/2017","149","148059363","993306","9.07941071","Interscheme"]
["11","8.65%SRNCD JUBI LIF SC(3)27/01/2021","INE700A07030","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan I (1230 Days)","27/01/2021","1157","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","149","148059363","993306","9.07941071","Interscheme"]
["12","CP - DEWAN HSG FIN -29/01/18","INE202B14KW8","UTI Mutual Fund","Uti - Money Market Fund","29/01/2018","63","T+0 Sal","27/11/2017","27/11/2017","27/11/2017","750000000","741691500","98.9063","6.509917","Market"]
["13","9.45% SNCD VEDANTA-17/08/2020","INE205A07030","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","17/08/2020","994","T+0 Sal","27/11/2017","27/11/2017","27/11/2017","130","134613830","1035090","7.92590971","Interscheme"]
["14","9.45% SNCD VEDANTA-17/08/2020","INE205A07030","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan I (1230 Days)","17/08/2020","994","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","130","134613830","1035090","7.92590971","Interscheme"]
["15","CP - N A B A R D -30/01/18","INE261F14CA8","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/01/2018","64","T+0 Sal","27/11/2017",null,"27/11/2017","250000000","247290000",null,null,"Market"]
["16","CP - N A B A R D -30/01/18","INE261F14CA8","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/01/2018","64","T+0 Sal","27/11/2017",null,"27/11/2017","250000000","247290000",null,null,"Market"]
["17","CP - N A B A R D -30/01/18","INE261F14CA8","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/01/2018","64","T+0 Sal","27/11/2017",null,"27/11/2017","2000000000","1978320000",null,null,"Market"]
["18","CP - N A B A R D -30/01/18","INE261F14CA8","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/01/2018","64","T+0 Sal","27/11/2017",null,"27/11/2017","500000000","494580000",null,null,"Market"]
["19","CP - N A B A R D -30/01/18","INE261F14CA8","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/01/2018","64","T+0 Sal","27/11/2017",null,"27/11/2017","1500000000","1483740000",null,null,"Market"]
["20","CP - N A B A R D -30/01/18","INE261F14CA8","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/01/2018","64","T+0 Sal","27/11/2017",null,"27/11/2017","500000000","494580000",null,null,"Market"]
["21","CP - SUN PHARMA INDS - 28/11/17","INE044A14237","UTI Mutual Fund","Uti - Liquid Cash Plan","28/11/2017","1","T+0 Sal","27/11/2017",null,"27/11/2017","500000000","499917000",null,null,"Market"]
["22","CP - SUN PHARMA INDS - 28/11/17","INE044A14237","UTI Mutual Fund","Uti - Liquid Cash Plan","28/11/2017","1","T+0 Sal","27/11/2017",null,"27/11/2017","2500000000","2499585000",null,null,"Market"]
["23","9.91% SRNCD DALMIA(SR-C)08/01/2021","INE755K07207","UTI Mutual Fund","Uti - Income Opportunities Fund","08/01/2021","1138","T+0 Sal","27/11/2017",null,"27/11/2017","90","94316670",null,null,"Interscheme"]
["24","9.91% SRNCD DALMIA(SR-C)08/01/2021","INE755K07207","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan I (1230 Days)","08/01/2021","1138","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","90","94316670","1047527","8.30280313","Interscheme"]
["25","CD - HDFC BANK - 20/03/18","INE040A16BM9","UTI Mutual Fund","Uti - Treasury Advantage Fund","20/03/2018","113","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","500000000","490531500","98.1227","6.235037","Market"]
["26","CP - N A B A R D -30/11/17","INE261F14BT0","UTI Mutual Fund","Uti - Liquid Cash Plan","30/11/2017","3","T+0 Sal","27/11/2017","27/11/2017","27/11/2017","2000000000","1999006000","99.9669","6.04275","Market"]
["27","CP - INDIABULLS HSG FIN -30/01/18","INE148I14TO6","UTI Mutual Fund","Uti - Money Market Fund","30/01/2018","64","T+0 Sal","27/11/2017","27/11/2017","27/11/2017","750000000","741600000","98.8973","6.459892","Market"]
["28","7.85%SNCD TALWAND SABO POW-04/08/20","INE694L07107","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","04/08/2020","981","T+0 Sal","27/11/2017","27/11/2017","27/11/2017","149","147952381","992623","8.13060342","Interscheme"]
["29","7.85%SNCD TALWAND SABO POW-04/08/20","INE694L07107","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan I (1230 Days)","04/08/2020","981","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","149","147952381","992623","8.13060342","Interscheme"]
["30","CP - INFRA LSG & FIN SERV-09/02/18","INE871D14IA6","UTI Mutual Fund","Uti - Money Market Fund","09/02/2018","74","T+0 Sal","27/11/2017","27/11/2017","27/11/2017","750000000","739653000","98.6213","6.989869","Market"]
["31","8.97%SRNCD UPPOWER(3A)15/02/2021","INE540P07046","UTI Mutual Fund","Uti - Bond Fund","15/02/2021","1176","T+0 Sal","27/11/2017",null,"27/11/2017","100","102406600",null,null,"Interscheme"]
["32","8.97%SRNCD UPPOWER(3A)15/02/2021","INE540P07046","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan I (1230 Days)","15/02/2021","1176","T+0 Pur","27/11/2017","27/11/2017","27/11/2017","100","102406600","1023683","8.26344321","Interscheme"]
["33","CP - L&T HOUSING FINANCE-26/12/17","INE476M14970","UTI Mutual Fund","Uti - Money Market Fund","26/12/2017","32","T+3 Pur","24/11/2017","24/11/2017","27/11/2017","50000000","49756850","99.4803","6.151015","Market"]