{"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":70,"n_cols":16,"rows_kept":70,"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","0% SRNCD AXIS FINANC(4B)-10/05/2021","INE891K07333","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","10/05/2021","1139","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","500","505751500","1013541","8.05762654","Off Market"]
["2","7.27% SRNCD IRFC-(SR121)-15/06/2027","INE053F07AB5","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","15/06/2027","3367","T+1 Pur","27/03/2018","27/03/2018","28/03/2018","500","479801500","952656","8.01243926","Market"]
["3","9.05% SRNCD CHOL INVTN 24/03/2028","INE121A08OG9","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","24/03/2028","3649","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","500","501605445","1003210.89","8.9927459","Off Market"]
["4","7% URNCBOND SIDBI-IV-21/12/2020","INE556F08IY0","UTI Mutual Fund","Uti - C.R.T.S. 1981","21/11/2019","604","T+1 Pur","27/03/2018","27/03/2018","28/03/2018","500","495585500","991546","7.52495491","Market"]
["5","7.11% SNCD NHAI BOND-V-05/11/2022","INE906B07FX6","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","05/11/2022","1684","T+1 Pur","27/03/2018","27/03/2018","28/03/2018","750","735555750","977547","7.68574887","Market"]
["6","7.37% SR66 NTPC SRBOND-14/12/2031","INE733E07KI9","UTI Mutual Fund","Uti - Balanced Fund","14/12/2031","5009","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","500","477796500","952232","7.94228628","Market"]
["7","9.05% SRNCD CHOL INVTN 24/03/2028","INE121A08OG9","UTI Mutual Fund","Uti - Balanced Fund","24/03/2028","3649","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","500","501605445","1003210.89","8.9927459","Off Market"]
["8","CP - MAGMA HSG FINANCE-27/06/18","INE055I14CA8","UTI Mutual Fund","Uti - Money Market Fund","27/06/2018","91","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","250000000","245171250","98.0893","7.899893","Off Market"]
["9","CP - PIRAMAL ENTERPRISES-14/05/18","INE140A14RZ0","UTI Mutual Fund","Uti - Money Market Fund","14/05/2018","47","T+0 Sal","28/03/2018",null,"28/03/2018","250000000","247670000",null,null,"Interscheme"]
["10","CP - TALWANDI SABO POWER-04/05/2018","INE694L14FD5","UTI Mutual Fund","Uti - Money Market Fund","04/05/2018","37","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","250000000","248389750","99.3732","6.39514","Interscheme"]
["11","CD - SOUTH INDIAN BANK-25/04/18","INE683A16KD6","UTI Mutual Fund","Uti - Money Market Fund","25/04/2018","29","T+1 Pur","27/03/2018","27/03/2018","28/03/2018","50000000","49748100","99.4962","6.600647","Market"]
["12","CD - UJJIVAN SMALL FIN BANK-27/4/18","INE551W16198","UTI Mutual Fund","Uti - Money Market Fund","27/04/2018","31","T+1 Pur","27/03/2018","27/03/2018","28/03/2018","50000000","49713950","99.4279","7.0006","Market"]
["13","CD - SOUTH INDIAN BANK -23/05/18","INE683A16KG9","UTI Mutual Fund","Uti - Money Market Fund","23/05/2018","57","T+1 Sal","27/03/2018","27/03/2018","28/03/2018","50000000","49487500","98.975","6.749991","Market"]
["14","CD - IDFC BANK - 05/04/18","INE092T16CU1","UTI Mutual Fund","Uti - Money Market Fund","05/04/2018","8","T+0 Sal","28/03/2018",null,"28/03/2018","500000000","498906500",null,null,"Market"]
["15","CD - IDFC BANK - 05/04/18","INE092T16CU1","UTI Mutual Fund","Uti - Money Market Fund","05/04/2018","8","T+0 Sal","28/03/2018",null,"28/03/2018","500000000","498906500",null,null,"Market"]
["16","CD - IDFC BANK - 05/04/18","INE092T16CU1","UTI Mutual Fund","Uti - Money Market Fund","05/04/2018","8","T+0 Sal","28/03/2018",null,"28/03/2018","1400000000","1396938200",null,null,"Market"]
["17","CD - IDFC BANK - 06/04/18","INE092T16CW7","UTI Mutual Fund","Uti - Money Market Fund","06/04/2018","9","T+0 Sal","28/03/2018",null,"28/03/2018","750000000","748155000",null,null,"Market"]
["18","CD - IDFC BANK - 06/04/18","INE092T16CW7","UTI Mutual Fund","Uti - Money Market Fund","06/04/2018","9","T+0 Sal","28/03/2018",null,"28/03/2018","1000000000","997540000",null,null,"Market"]
["19","CD - IDFC BANK - 06/04/18","INE092T16CW7","UTI Mutual Fund","Uti - Money Market Fund","06/04/2018","9","T+0 Sal","28/03/2018",null,"28/03/2018","500000000","498770000",null,null,"Market"]
["20","CD - INDIAN BANK - 25/06/2018","INE562A16IK1","UTI Mutual Fund","Uti - Money Market Fund","25/06/2018","89","T+0 Sal","28/03/2018",null,"28/03/2018","500000000","491609000",null,null,"Market"]
["21","CD - INDIAN BANK - 25/06/2018","INE562A16IK1","UTI Mutual Fund","Uti - Money Market Fund","25/06/2018","89","T+0 Sal","28/03/2018",null,"28/03/2018","1000000000","983218000",null,null,"Market"]
["22","CD - SOUTH INDIAN BANK-25/04/18","INE683A16KD6","UTI Mutual Fund","Uti - Money Market Fund","25/04/2018","28","T+0 Sal","28/03/2018","28/03/2018","28/03/2018","500000000","497139500","99.4482","7.500909","Market"]
["23","CD - INDIAN BANK - 25/06/2018","INE562A16IK1","UTI Mutual Fund","Uti - Money Market Fund","25/06/2018","89","T+0 Sal","28/03/2018",null,"28/03/2018","2500000000","2458045000",null,null,"Interscheme"]
["24","CP - BARCLAYS INVT & LO-23/05/2018","INE704I14BD7","UTI Mutual Fund","Uti - Liquid Cash Plan","23/05/2018","57","T+1 Pur","27/03/2018","27/03/2018","28/03/2018","50000000","49356350","98.7127","8.499856","Market"]
["25","CP - INFRA LEASING FIN-09/05/18","INE871D14JX6","UTI Mutual Fund","Uti - Liquid Cash Plan","09/05/2018","42","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","2250000000","2230240500","99.1425","7.699868","Off Market"]
["26","CP - NTPC LTD - 27/06/18","INE733E14112","UTI Mutual Fund","Uti - Liquid Cash Plan","27/06/2018","91","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","1000000000","982366000","98.4226","6.499761","Off Market"]
["27","CP - MANAPPURAM FINANCE-14/06/18","INE522D14IA5","UTI Mutual Fund","Uti - Liquid Cash Plan","14/06/2018","78","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","3000000000","2950503000","98.3709","7.850245","Off Market"]
["28","CP - TALWANDI SABO POWER-04/05/2018","INE694L14FD5","UTI Mutual Fund","Uti - Liquid Cash Plan","04/05/2018","37","T+0 Sal","28/03/2018",null,"28/03/2018","250000000","248389750",null,null,"Interscheme"]
["29","CP - NATIONAL HSG BANK - 07/06/2018","INE557F14EE7","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","71","T+0 Sal","28/03/2018",null,"28/03/2018","1050000000","1035695850",null,null,"Interscheme"]
["30","CP - NATIONAL HSG BANK - 07/06/2018","INE557F14EE7","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","71","T+0 Sal","28/03/2018",null,"28/03/2018","950000000","937058150",null,null,"Interscheme"]
["31","CP - PIRAMAL ENTERPRISES-14/05/18","INE140A14RZ0","UTI Mutual Fund","Uti - Liquid Cash Plan","14/05/2018","47","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","250000000","247670000","99.0876","7.306359","Interscheme"]
["32","CD - UNION BANK OF INDIA-25/06/18","INE692A16EX8","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","89","T+0 Sal","28/03/2018","28/03/2018","28/03/2018","5000000000","4915500000","98.4921","6.350111","Market"]
["33","CD - VIJAYA BANK - 26/06/18","INE705A16QE2","UTI Mutual Fund","Uti - Liquid Cash Plan","26/06/2018","90","T+0 Sal","28/03/2018","28/03/2018","28/03/2018","1500000000","1475263500","98.4718","6.364601","Market"]
["34","CD - UNION BANK OF INDIA-25/06/18","INE692A16EX8","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","89","T+0 Sal","28/03/2018","28/03/2018","28/03/2018","750000000","737856000","98.4921","6.350111","Market"]
["35","CD - IDFC BANK - 03/04/18","INE092T16CS5","UTI Mutual Fund","Uti - Liquid Cash Plan","03/04/2018","6","T+0 Sal","28/03/2018",null,"28/03/2018","300000000","299458500",null,null,"Market"]
["36","CD - PUNJAB & SIND BANK-12/06/18","INE608A16NX5","UTI Mutual Fund","Uti - Liquid Cash Plan","12/06/2018","76","T+0 Sal","28/03/2018","28/03/2018","28/03/2018","1000000000","985533000","98.706","6.380024","Market"]
["37","CD - IDFC BANK - 05/04/18","INE092T16CU1","UTI Mutual Fund","Uti - Liquid Cash Plan","05/04/2018","8","T+0 Sal","28/03/2018",null,"28/03/2018","500000000","498906500",null,null,"Market"]
["38","CD - UNION BANK OF INDIA-25/06/18","INE692A16EX8","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","89","T+0 Sal","28/03/2018","28/03/2018","28/03/2018","2000000000","1966200000","98.4921","6.350111","Market"]
["39","CD - ICICI BANK - 28/05/18","INE090A165P2","UTI Mutual Fund","Uti - Liquid Cash Plan","28/05/2018","61","T+0 Sal","28/03/2018",null,"28/03/2018","500000000","494136500",null,null,"Market"]
["40","CD - ANDHRA BANK - 25/06/18","INE434A16PD3","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","89","T+0 Sal","28/03/2018","28/03/2018","28/03/2018","1000000000","983100000","98.4886","6.365077","Market"]
["41","CD - VIJAYA BANK - 26/06/18","INE705A16QE2","UTI Mutual Fund","Uti - Liquid Cash Plan","26/06/2018","90","T+0 Sal","28/03/2018","28/03/2018","28/03/2018","4000000000","3931652000","98.4718","6.364601","Market"]
["42","CD - ICICI BANK - 28/05/18","INE090A165P2","UTI Mutual Fund","Uti - Liquid Cash Plan","28/05/2018","61","T+0 Sal","28/03/2018",null,"28/03/2018","2500000000","2470682500",null,null,"Interscheme"]
["43","CD - PUNJAB & SIND BANK-30/05/18","INE608A16NY3","UTI Mutual Fund","Uti - Liquid Cash Plan","30/05/2018","63","T+0 Sal","28/03/2018",null,"28/03/2018","5500000000","5434066000",null,null,"Interscheme"]
["44","CP - NABARD - 21/05/18","INE261F14CL5","UTI Mutual Fund","Uti - Short Term Income Fund","21/05/2018","54","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","4000000000","3959000000","98.9929","7.006249","Market"]
["45","CD - KOTAK MAH BANK - 22/06/18","INE237A164D5","UTI Mutual Fund","Uti - Short Term Income Fund","22/06/2018","86","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","4000000000","3935096000","98.5202","6.449881","Market"]
["46","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Treasury Advantage Fund","08/03/2019","345","T+0 Sal","28/03/2018","28/03/2018","28/03/2018","1500000000","1403800500","93.7282","7.099967","Market"]
["47","CD - AXIS BANK - 22/02/2019","INE238A16Y66","UTI Mutual Fund","Uti - Treasury Advantage Fund","22/02/2019","331","T+0 Sal","28/03/2018","28/03/2018","28/03/2018","1500000000","1406865000","93.9561","7.11494","Market"]
["48","CD - INDIAN BANK - 25/06/2018","INE562A16IK1","UTI Mutual Fund","Uti - Treasury Advantage Fund","25/06/2018","89","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","2500000000","2458045000","98.4921","6.350111","Interscheme"]
["49","CD - ICICI BANK - 28/05/18","INE090A165P2","UTI Mutual Fund","Uti - Treasury Advantage Fund","28/05/2018","61","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","2500000000","2470682500","98.9549","6.424838","Interscheme"]
["50","CD - PUNJAB & SIND BANK-30/05/18","INE608A16NY3","UTI Mutual Fund","Uti - Treasury Advantage Fund","30/05/2018","63","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","5500000000","5434066000","98.9279","6.379956","Interscheme"]
["51","CP - N A B A R D - 31/07/18","INE261F14CM3","UTI Mutual Fund","Uti - Floating Rate Fund Stp","31/07/2018","126","T+1 Sal","27/03/2018","27/03/2018","28/03/2018","2000000000","1949786000","97.4893","7.52005","Market"]
["52","CP - NATIONAL HSG BANK - 07/06/2018","INE557F14EE7","UTI Mutual Fund","Uti - Floating Rate Fund Stp","07/06/2018","71","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","1050000000","1035695850","98.7781","6.45015","Interscheme"]
["53","7.65% SRNCD IRFC-SR111-30/07/2019","INE053F07918","UTI Mutual Fund","Uti - Floating Rate Fund Stp","30/07/2019","489","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","500","500808000","1002970","7.4400281","Market"]
["54","7.65% SRNCD IRFC-SR111-30/07/2019","INE053F07918","UTI Mutual Fund","Uti - Floating Rate Fund Stp","30/07/2019","489","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","500","500808000","1002970","7.4400281","Market"]
["55","7.65% SRNCD IRFC-SR111-30/07/2019","INE053F07918","UTI Mutual Fund","Uti - Floating Rate Fund Stp","30/07/2019","489","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","500","500808000","1002970","7.4400281","Market"]
["56","9.38% SRNCD R E C - 06.11.18","INE020B07HY0","UTI Mutual Fund","Uti - Floating Rate Fund Stp","06/11/2018","223","T+0 Sal","28/03/2018",null,"28/03/2018","1400","1412709200",null,null,"Market"]
["57","9.38% SRNCD R E C - 06.11.18","INE020B07HY0","UTI Mutual Fund","Uti - Floating Rate Fund Stp","06/11/2018","223","T+0 Sal","28/03/2018",null,"28/03/2018","250","252269500",null,null,"Market"]
["58","CP - INFRA LEASING FIN-09/05/18","INE871D14JX6","UTI Mutual Fund","Uti - Spread Fund","09/05/2018","42","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","1000000000","991218000","99.1425","7.699868","Off Market"]
["59","CP - NATIONAL HSG BANK - 07/06/2018","INE557F14EE7","UTI Mutual Fund","Uti - Income Opportunities Fund","07/06/2018","71","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","950000000","937058150","98.7781","6.45015","Interscheme"]
["60","7.28% URNCD PFC SR 168A-10/06/2022","INE134E08JB5","UTI Mutual Fund","Uti - Income Opportunities Fund","10/06/2022","1536","T+1 Pur","27/03/2018","27/03/2018","28/03/2018","500","489805000","979695","7.84751233","Market"]
["61","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Income Opportunities Fund","30/11/2022","1709","T+1 Pur","27/03/2018","27/03/2018","28/03/2018","200","197184000","987421","7.76025849","Market"]
["62","7.99% URNCD PFC (OP-B)-20/12/2022","INE134E08JO8","UTI Mutual Fund","Uti - Income Opportunities Fund","20/12/2022","1729","T+1 Pur","27/03/2018","27/03/2018","28/03/2018","550","553317600","1006130","7.8374818","Market"]
["63","7.65% SRNCD IRFC-SR111-30/07/2019","INE053F07918","UTI Mutual Fund","Uti - Income Opportunities Fund","30/07/2019","489","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","500","500808000","1002970","7.4400281","Market"]
["64","7.45% URNCD REC-SR-155 -30/11/2022","INE020B08AP1","UTI Mutual Fund","Uti - Medium Term Fund","30/11/2022","1709","T+1 Pur","27/03/2018","27/03/2018","28/03/2018","50","49296000","987421","7.76025849","Market"]
["65","0% SRNCD BAJAJ FIN(SR227)15/04/2021","INE296A07QJ0","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xii (1154 Days)","15/04/2021","1114","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","375","375000000","1001842","8.0423577","Off Market"]
["66","0% SNCD EDEL COMM-15/04/2021","INE657N07464","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiii (1134 Days)","15/04/2021","1114","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","460","463271520","1013567","9.079939","Market"]
["67","0% SRNCD JM FIN CR SL-04/05/2021",null,"UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiii (1134 Days)","04/05/2021","1133","T+0 Pur","28/03/2018",null,"28/03/2018","454","455800110",null,null,"Off Market"]
["68","0%SRNCD JM FIN PROD(OP-I)06/04/2021",null,"UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiii (1134 Days)","06/04/2021","1105","T+0 Pur","28/03/2018",null,"28/03/2018","250","253990750",null,null,"Off Market"]
["69","0% SRNCD BAJAJ FIN(SR227)15/04/2021","INE296A07QJ0","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiv (1147 Days)","15/04/2021","1114","T+0 Pur","28/03/2018","28/03/2018","28/03/2018","95","95000000","1001842","8.0423577","Off Market"]