{"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":69,"n_cols":16,"rows_kept":69,"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 TATA MOTOR FIN-T-27/02/19","INE909H07BR8","UTI Mutual Fund","Uti - Smart Woman Savings Plan","27/02/2019","530","T+0 Sal","15/09/2017",null,"15/09/2017","1","1454662",null,null,"Interscheme"]
["2","0% SRNCD TATA MOTOR FIN-T-27/02/19","INE909H07BR8","UTI Mutual Fund","Uti - Ftif Series Xxiv - Xv (1099 Days)","27/02/2019","530","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1454662","1454664","7.71999418","Interscheme"]
["3","0% SRNCD SUN BNP PARI H F-27/02/19","INE667F07DP6","UTI Mutual Fund","Uti - C.R.T.S. 1981","27/02/2019","530","T+0 Sal","15/09/2017",null,"15/09/2017","3","4375281",null,null,"Interscheme"]
["4","0% SRNCD SUN BNP PARI H F-27/02/19","INE667F07DP6","UTI Mutual Fund","Uti - Ftif Series Xxiv - Xv (1099 Days)","27/02/2019","530","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","3","4375281","1458417","7.42001139","Interscheme"]
["5","0% SRNCD DEWAN HSG FIN-18/04/18","INE202B07DN6","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","18/04/2018","215","T+0 Sal","15/09/2017",null,"15/09/2017","1","1269128",null,null,"Interscheme"]
["6","0% SRNCD DEWAN HSG FIN-18/04/18","INE202B07DN6","UTI Mutual Fund","Uti - Ftif Series Xxii - Xiii (1100 Days)","18/04/2018","215","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1269128","1269382","7.73437933","Interscheme"]
["7","0%SRNCD I I F L(SR-7OPT-3)-02.04.18","INE866I07834","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","02/04/2018","199","T+0 Sal","15/09/2017",null,"15/09/2017","1","1322992",null,null,"Interscheme"]
["8","0%SRNCD I I F L(SR-7OPT-3)-02.04.18","INE866I07834","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","02/04/2018","199","T+0 Sal","15/09/2017",null,"15/09/2017","1","1322992",null,null,"Interscheme"]
["9","0%SRNCD I I F L(SR-7OPT-3)-02.04.18","INE866I07834","UTI Mutual Fund","Uti - Ftif Series Xxiv - Xi (1098 Days)","02/04/2018","199","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1322992","1323264","7.96435954","Interscheme"]
["10","0%SRNCD I I F L(SR-7OPT-3)-02.04.18","INE866I07834","UTI Mutual Fund","Uti - Ftif Series Xxiv - Xi (1098 Days)","02/04/2018","199","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1322992","1323264","7.96435954","Interscheme"]
["11","0% SRNCD I I H FL(S-4-OP3)02.04.18","INE477L07222","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","02/04/2018","199","T+0 Sal","15/09/2017",null,"15/09/2017","1","1323093",null,null,"Interscheme"]
["12","0% SRNCD I I H FL(S-4-OP3)02.04.18","INE477L07222","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","02/04/2018","199","T+0 Sal","15/09/2017",null,"15/09/2017","1","1323093",null,null,"Interscheme"]
["13","0% SRNCD I I H FL(S-4-OP3)02.04.18","INE477L07222","UTI Mutual Fund","Uti - Ftif Series Xxii - Xiii (1100 Days)","02/04/2018","199","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1323093","1323365","7.9491703","Interscheme"]
["14","0% SRNCD I I H FL(S-4-OP3)02.04.18","INE477L07222","UTI Mutual Fund","Uti - Ftif Series Xxii - Xiii (1100 Days)","02/04/2018","199","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1323093","1323365","7.9491703","Interscheme"]
["15","0% SRNCD I I H FL(S-5-OP4)18/04/18","INE477L07263","UTI Mutual Fund","Uti - C.R.T.S. 1981","18/04/2018","215","T+0 Sal","15/09/2017",null,"15/09/2017","1","1315125",null,null,"Interscheme"]
["16","0% SRNCD I I H FL(S-5-OP4)18/04/18","INE477L07263","UTI Mutual Fund","Uti - Ftif Series Xxii - Xiii (1100 Days)","18/04/2018","215","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1315125","1315394","7.93560175","Interscheme"]
["17","0% SRNCD DEWAN HSG FIN-02.04.18","INE202B07DG0","UTI Mutual Fund","Uti - Smart Woman Savings Plan","02/04/2018","199","T+0 Sal","15/09/2017",null,"15/09/2017","1","1274907",null,null,"Interscheme"]
["18","0% SRNCD DEWAN HSG FIN-02.04.18","INE202B07DG0","UTI Mutual Fund","Uti - Ftif Series Xxii - Xiii (1100 Days)","02/04/2018","199","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1274907","1275163","7.74730933","Interscheme"]
["19","9.11% SRNCD LIC HSG FIN--09.04.18","INE115A07DR3","UTI Mutual Fund","Uti - Balanced Fund","09/04/2018","206","T+0 Sal","15/09/2017",null,"15/09/2017","13","13133406",null,null,"Interscheme"]
["20","9.11% SRNCD LIC HSG FIN--09.04.18","INE115A07DR3","UTI Mutual Fund","Uti - Balanced Fund","09/04/2018","206","T+0 Sal","15/09/2017",null,"15/09/2017","10","10102620",null,null,"Interscheme"]
["21","9.11% SRNCD LIC HSG FIN--09.04.18","INE115A07DR3","UTI Mutual Fund","Uti - Balanced Fund","09/04/2018","206","T+0 Sal","15/09/2017",null,"15/09/2017","15","15153930",null,null,"Interscheme"]
["22","9.11% SRNCD LIC HSG FIN--09.04.18","INE115A07DR3","UTI Mutual Fund","Uti - Balanced Fund","09/04/2018","206","T+0 Sal","15/09/2017",null,"15/09/2017","12","12123144",null,null,"Interscheme"]
["23","9.11% SRNCD LIC HSG FIN--09.04.18","INE115A07DR3","UTI Mutual Fund","Uti - Ftif Series Xxiii - Vii (1098 Days)","09/04/2018","206","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","13","13133406","1010204","7.05039851","Interscheme"]
["24","9.11% SRNCD LIC HSG FIN--09.04.18","INE115A07DR3","UTI Mutual Fund","Uti - Ftif Series Xxii - Xv (1098 Days)","09/04/2018","206","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","10","10102620","1010204","7.05039851","Interscheme"]
["25","9.11% SRNCD LIC HSG FIN--09.04.18","INE115A07DR3","UTI Mutual Fund","Uti - Ftif Series Xxii - Xiii (1100 Days)","09/04/2018","206","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","15","15153930","1010204","7.05039851","Interscheme"]
["26","9.11% SRNCD LIC HSG FIN--09.04.18","INE115A07DR3","UTI Mutual Fund","Uti - Ftif Series Xxiii - Ii (1100 Days)","09/04/2018","206","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","12","12123144","1010204","7.05039851","Interscheme"]
["27","0% SRNCD I I H FL(S-6-OP4)03/04/18","INE477L07313","UTI Mutual Fund","Uti - Smart Woman Savings Plan","03/04/2018","200","T+0 Sal","15/09/2017",null,"15/09/2017","1","1306263",null,null,"Interscheme"]
["28","0% SRNCD I I H FL(S-6-OP4)03/04/18","INE477L07313","UTI Mutual Fund","Uti - Ftif Series Xxii - Xiii (1100 Days)","03/04/2018","200","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1306263","1306532","7.94825764","Interscheme"]
["29","0% SRNCD DEWAN HSG FIN - 02/04/18","INE202B07DZ0","UTI Mutual Fund","Uti - C.R.T.S. 1981","02/04/2018","199","T+0 Sal","15/09/2017",null,"15/09/2017","1","1261537",null,null,"Interscheme"]
["30","0% SRNCD DEWAN HSG FIN - 02/04/18","INE202B07DZ0","UTI Mutual Fund","Uti - Ftif Series Xxii - Xiii (1100 Days)","02/04/2018","199","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1261537","1261790","7.74723942","Interscheme"]
["31","0%SRNCD I I F L(SRA1-III)08/05/2018","INE866I07982","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","08/05/2018","235","T+0 Sal","15/09/2017",null,"15/09/2017","1","1283469",null,null,"Interscheme"]
["32","0%SRNCD I I F L(SRA1-III)08/05/2018","INE866I07982","UTI Mutual Fund","Uti - Ftif Series Xxii - Xiii (1100 Days)","08/05/2018","235","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1283469","1283731","7.93354401","Interscheme"]
["33","0% SRNCD LIC HOUSING FIN-26/11/2018","INE115A07EQ3","UTI Mutual Fund","Uti - Smart Woman Savings Plan","26/11/2018","437","T+0 Sal","15/09/2017",null,"15/09/2017","1","1474816",null,null,"Interscheme"]
["34","0% SRNCD LIC HOUSING FIN-26/11/2018","INE115A07EQ3","UTI Mutual Fund","Uti - Ftif Series Xxiii - Xv (1176 Days)","26/11/2018","437","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1","1474816","1473857","7.11499489","Interscheme"]
["35","8.05% URNCD RECL-SR-137 -07/12/2018","INE020B08971","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","07/12/2018","448","T+0 Sal","15/09/2017",null,"15/09/2017","3","3043146",null,null,"Interscheme"]
["36","8.05% URNCD RECL-SR-137 -07/12/2018","INE020B08971","UTI Mutual Fund","Uti - Ftif Series Xxiii - Xv (1176 Days)","07/12/2018","448","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","3","3043146","1014237","6.77254372","Interscheme"]
["37","7.98%URNCD NABARD(SR-16J)13/03/2019","INE261F08592","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","13/03/2019","544","T+0 Sal","15/09/2017",null,"15/09/2017","13","13207142",null,null,"Interscheme"]
["38","7.98%URNCD NABARD(SR-16J)13/03/2019","INE261F08592","UTI Mutual Fund","Uti - Ftif Series Xxiv - Xiv (1831 Days)","13/03/2019","544","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","13","13207142","1015908","6.80086052","Interscheme"]
["39","0%SRNCDDEWANHSGFIN-13-T-1-30/04/19","INE202B07AK8","UTI Mutual Fund","Uti - C.R.T.S. 1981","30/04/2019","592","T+0 Sal","15/09/2017",null,"15/09/2017","3","4419570",null,null,"Interscheme"]
["40","0%SRNCDDEWANHSGFIN-13-T-1-30/04/19","INE202B07AK8","UTI Mutual Fund","Uti - C.R.T.S. 1981","30/04/2019","592","T+0 Sal","15/09/2017",null,"15/09/2017","2","2946380",null,null,"Interscheme"]
["41","0%SRNCDDEWANHSGFIN-13-T-1-30/04/19","INE202B07AK8","UTI Mutual Fund","Uti - Ftif Series Xxiv - Xv (1099 Days)","30/04/2019","592","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","3","4419570","1473274","7.85498905","Interscheme"]
["42","0%SRNCDDEWANHSGFIN-13-T-1-30/04/19","INE202B07AK8","UTI Mutual Fund","Uti - Ftif Series Xxv - I (1099 Days)","30/04/2019","592","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","2","2946380","1473274","7.85498905","Interscheme"]
["43","7.85%URNCD NABARD(SR-17D)31/05/2019","INE261F08642","UTI Mutual Fund","Uti - C.R.T.S. 1981","31/05/2019","623","T+0 Sal","15/09/2017",null,"15/09/2017","5","5079235",null,null,"Interscheme"]
["44","7.85%URNCD NABARD(SR-17D)31/05/2019","INE261F08642","UTI Mutual Fund","Uti - Ftif Series Xxv - I (1099 Days)","31/05/2019","623","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","5","5079235","1015840","6.80002598","Interscheme"]
["45","8.73% SRNCD L H F(288) 05/04/2019","INE115A07IZ5","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","05/04/2019","567","T+0 Sal","15/09/2017",null,"15/09/2017","10","10214070",null,null,"Interscheme"]
["46","8.73% SRNCD L H F(288) 05/04/2019","INE115A07IZ5","UTI Mutual Fund","Uti - Ftif Series Xxiii - Xv (1176 Days)","05/04/2019","567","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","10","10214070","1021734","7.16000195","Interscheme"]
["47","11.10% NCD KOTAK MAH.PR(B) 30.04.18","INE916D08CI7","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","23/04/2018","220","T+0 Sal","15/09/2017","15/09/2017","15/09/2017","4","4092676","1022933","7.15989716","Interscheme"]
["48","11.10% NCD KOTAK MAH.PR(B) 30.04.18","INE916D08CI7","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","23/04/2018","220","T+0 Sal","15/09/2017","15/09/2017","15/09/2017","36","36834084","1022933","7.15989716","Interscheme"]
["49","11.10% NCD KOTAK MAH.PR(B) 30.04.18","INE916D08CI7","UTI Mutual Fund","Uti - Ftif Series Xxiii - Iii (1098 Days)","23/04/2018","220","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","4","4092676","1022933","7.15989716","Interscheme"]
["50","11.10% NCD KOTAK MAH.PR(B) 30.04.18","INE916D08CI7","UTI Mutual Fund","Uti - Ftif Series Xxiii - Iii (1098 Days)","23/04/2018","220","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","36","36834084","1022933","7.15989716","Interscheme"]
["51","CP - L&T HSG FINANCE-25/09/17","INE476M14954","UTI Mutual Fund","Uti - Liquid Cash Plan","25/09/2017","11","T+1 Sal","14/09/2017","14/09/2017","15/09/2017","50000000","49917950","99.8359","5.999495","Market"]
["52","CP - HINDUSTAN ZINC -19/09/17","INE267A14259","UTI Mutual Fund","Uti - Liquid Cash Plan","19/09/2017","4","T+0 Sal","15/09/2017","15/09/2017","15/09/2017","2000000000","1998674000","99.9503","6.04984","Interscheme"]
["53","CP - HINDUSTAN ZINC -19/09/17","INE267A14259","UTI Mutual Fund","Uti - Short Term Income Fund","19/09/2017","4","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","2000000000","1998674000","99.9503","6.04984","Interscheme"]
["54","CP - HDFC LTD - 20/09/17","INE001A14QY9","UTI Mutual Fund","Uti - Money Market Fund","20/09/2017","5","T+0 Sal","15/09/2017","15/09/2017","15/09/2017","1000000000","999097000","99.9282","6.556458","Market"]
["55","CP - HDFC LTD - 20/09/17","INE001A14QY9","UTI Mutual Fund","Uti - Money Market Fund","20/09/2017","5","T+0 Sal","15/09/2017","15/09/2017","15/09/2017","1000000000","999104000","99.9282","6.556458","Market"]
["56","CP - HDFC LTD - 20/09/17","INE001A14QY9","UTI Mutual Fund","Uti - Money Market Fund","20/09/2017","5","T+0 Sal","15/09/2017","15/09/2017","15/09/2017","4000000000","3996416000","99.9282","6.556458","Market"]
["57","CD - IDFC BANK - MAT - 18/09/2017","INE092T16BD9","UTI Mutual Fund","Uti - Liquid Cash Plan","18/09/2017","3","T+0 Sal","15/09/2017",null,"15/09/2017","250000000","249876750",null,null,"Market"]
["58","CD - IDFC BANK - MAT - 18/09/2017","INE092T16BD9","UTI Mutual Fund","Uti - Liquid Cash Plan","18/09/2017","3","T+0 Sal","15/09/2017",null,"15/09/2017","500000000","499753500",null,null,"Market"]
["59","CD - IDFC BANK - MAT - 18/09/2017","INE092T16BD9","UTI Mutual Fund","Uti - Liquid Cash Plan","18/09/2017","3","T+0 Sal","15/09/2017",null,"15/09/2017","4250000000","4247904750",null,null,"Market"]
["60","CP - RELIANCE JIO INFOCOMM-18/09/17","INE110L14DX5","UTI Mutual Fund","Uti - Liquid Cash Plan","18/09/2017","3","T+0 Sal","15/09/2017",null,"15/09/2017","2000000000","1998974000",null,null,"Market"]
["61","CP - INFINA FINANCE - 22/09/17","INE879F14AV7","UTI Mutual Fund","Uti - Liquid Cash Plan","22/09/2017","7","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1500000000","1497702000","99.8687","7.997918","Off Market"]
["62","7.3% URNCD PFC SR 169B-07/08/2027","INE134E08JE9","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","07/08/2027","3613","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","250","248666250","994658","7.3700848","Market"]
["63","CP - BHARAT ALUMN CO -09/11/17","INE738C14DR4","UTI Mutual Fund","Uti - Liquid Cash Plan","09/11/2017","56","T+1 Sal","14/09/2017","14/09/2017","15/09/2017","50000000","49532000","99.064","6.270327","Market"]
["64","CP - RELIANCE INDS - 20/11/17","INE002A14631","UTI Mutual Fund","Uti - Liquid Cash Plan","20/11/2017","66","T+0 Pur","15/09/2017","15/09/2017","15/09/2017","1500000000","1483555500","98.9201","6.130254","Off Market"]
["65","CP - TALWANDI SABO POWER-25/10/17","INE694L14EP2","UTI Mutual Fund","Uti - Money Market Fund","25/10/2017","41","T+1 Sal","14/09/2017","14/09/2017","15/09/2017","50000000","49657150","99.3143","6.300213","Market"]
["66","8.75% SRNCD IHFL(SRIII)26/09/2021","INE148I07GE8","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","26/09/2021","1473","T+1 Sal","14/09/2017","14/09/2017","15/09/2017","300000","307776000","1025.92","7.96460057","Market"]
["67","CD - ICICI BANK - 27/09/17","INE090A169J7","UTI Mutual Fund","Uti - Liquid Cash Plan","27/09/2017","12","T+0 Sal","15/09/2017","15/09/2017","15/09/2017","1000000000","997999000","99.8165","6.100057","Market"]
["68","CD - IDFC BANK - 17/11/17","INE092T16BN8","UTI Mutual Fund","Uti - Liquid Cash Plan","17/11/2017","63","T+0 Sal","15/09/2017","15/09/2017","15/09/2017","1000000000","989581000","98.9712","6.119604","Market"]