{"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":78,"n_cols":16,"rows_kept":78,"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","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","08/03/2019","346","T+0 Sal","27/03/2018",null,"27/03/2018","250000000","233674750",null,null,"Interscheme"]
["2","BCOP SRNCD MAGMA FIN(PP)-26/03/2021","INE511C07623","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","26/03/2021","1095","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","100","150000000","1500000","9.09124924","Off Market"]
["3","7.90% SRNCD BHARAT ALUMIN-31/07/20","INE738C07069","UTI Mutual Fund","Uti - C.R.T.S. 1981","31/07/2020","857","T+0 Sal","27/03/2018",null,"27/03/2018","110","107680980",null,null,"Interscheme"]
["4","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","08/03/2019","346","T+0 Sal","27/03/2018",null,"27/03/2018","250000000","233674750",null,null,"Interscheme"]
["5","9.20%UNCD ICICI BANKPERP-17/03/2022","INE090A08TW2","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","17/03/2022","1451","T+0 Sal","27/03/2018",null,"27/03/2018","250","250802750",null,null,"Market"]
["6","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","1099","T+0 Sal","27/03/2018",null,"27/03/2018","1500","151312050",null,null,"Interscheme"]
["7","BCOP SRNCD MAGMA FIN(PP)-26/03/2021","INE511C07623","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","26/03/2021","1095","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","100","150000000","1500000","9.09124924","Off Market"]
["8","9.20%UNCD ICICI BANKPERP-17/03/2022","INE090A08TW2","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","17/03/2022","1451","T+0 Sal","27/03/2018",null,"27/03/2018","250","250802750",null,null,"Market"]
["9","8.75% SRNCD VEDANTA(SR 3)15/04/2021","INE205A07063","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","15/04/2021","1115","T+0 Sal","27/03/2018",null,"27/03/2018","400","403186800",null,null,"Interscheme"]
["10","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Balanced Fund","08/03/2019","346","T+0 Sal","27/03/2018",null,"27/03/2018","750000000","701024250",null,null,"Interscheme"]
["11","8.30%URNCD RURAL ELEC COR-10.04.25.","INE020B08930","UTI Mutual Fund","Uti - Balanced Fund","10/04/2025","2572","T+1 Sal","26/03/2018",null,"27/03/2018","100","99993400",null,null,"Market"]
["12","8.30%URNCD RURAL ELEC COR-10.04.25.","INE020B08930","UTI Mutual Fund","Uti - Balanced Fund","10/04/2025","2572","T+1 Sal","26/03/2018",null,"27/03/2018","150","149990100",null,null,"Market"]
["13","7.2% SRNCD PGC (SR-LX)-09/08/27","INE752E07OG5","UTI Mutual Fund","Uti - Balanced Fund","09/08/2027","3422","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","950","906200250","951251","7.9424554","Market"]
["14","7.37% SR66 NTPC SRBOND-14/12/2031","INE733E07KI9","UTI Mutual Fund","Uti - Balanced Fund","14/12/2031","5010","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","500","477796000","947697","7.99974073","Market"]
["15","CP - NABHA POWER - 25/05/2018","INE445L14811","UTI Mutual Fund","Uti - Money Market Fund","25/05/2018","60","T+1 Pur","26/03/2018","26/03/2018","27/03/2018","50000000","49464300","98.9286","6.699936","Market"]
["16","CP -  SIDBI - 02/05/18","INE556F14FU2","UTI Mutual Fund","Uti - Money Market Fund","02/05/2018","37","T+1 Pur","26/03/2018","26/03/2018","27/03/2018","100000000","99377600","99.3776","6.349967","Market"]
["17","CP - CHENNAI PETRO CORP-28/03/18","INE178A14CM0","UTI Mutual Fund","Uti - Money Market Fund","28/03/2018","1","T+0 Sal","27/03/2018",null,"27/03/2018","2000000000","1999616000",null,null,"Market"]
["18","CP - ADANI PORTS & SPL ECO-28/03/18","INE742F14ER7","UTI Mutual Fund","Uti - Money Market Fund","28/03/2018","1","T+0 Sal","27/03/2018",null,"27/03/2018","1250000000","1249760000",null,null,"Market"]
["19","CP - ADANI PORTS & SPL ECO-28/03/18","INE742F14ER7","UTI Mutual Fund","Uti - Money Market Fund","28/03/2018","1","T+0 Sal","27/03/2018",null,"27/03/2018","2000000000","1999616000",null,null,"Market"]
["20","CP - ADANI PORTS & SPL ECO-28/03/18","INE742F14ER7","UTI Mutual Fund","Uti - Money Market Fund","28/03/2018","1","T+0 Sal","27/03/2018",null,"27/03/2018","1750000000","1749664000",null,null,"Market"]
["21","CP - CHENNAI PETRO CORP-28/03/18","INE178A14CM0","UTI Mutual Fund","Uti - Money Market Fund","28/03/2018","1","T+0 Sal","27/03/2018",null,"27/03/2018","2000000000","1999616000",null,null,"Market"]
["22","CP - CHENNAI PETRO CORP-28/03/18","INE178A14CM0","UTI Mutual Fund","Uti - Money Market Fund","28/03/2018","1","T+0 Sal","27/03/2018",null,"27/03/2018","1000000000","999808000",null,null,"Market"]
["23","CP - MANAPPURAM FINANCE-28/03/18","INE522D14HO8","UTI Mutual Fund","Uti - Money Market Fund","28/03/2018","1","T+0 Sal","27/03/2018",null,"27/03/2018","2800000000","2799389600",null,null,"Interscheme"]
["24","CP - INDIABULLS COMM CRED-07/06/18","INE244L14AM1","UTI Mutual Fund","Uti - Money Market Fund","07/06/2018","72","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","2800000000","2758590800","98.5375","7.630076","Interscheme"]
["25","CD - IDFC BANK -14/05/2018","INE092T16DD5","UTI Mutual Fund","Uti - Money Market Fund","14/05/2018","49","T+1 Pur","26/03/2018","26/03/2018","27/03/2018","50000000","49563300","99.1266","6.699997","Market"]
["26","CD - UNION BANK OF INDIA-25/06/18","INE692A16EX8","UTI Mutual Fund","Uti - Money Market Fund","25/06/2018","90","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","3000000000","2949099000","98.3218","6.999979","Off Market"]
["27","CD - IDFC BANK - 09/05/18","INE092T16DB9","UTI Mutual Fund","Uti - Money Market Fund","09/05/2018","44","T+1 Sal","26/03/2018","26/03/2018","27/03/2018","100000000","99257500","99.2575","6.349763","Market"]
["28","CD - INDIAN BANK - 25/06/2018","INE562A16IK1","UTI Mutual Fund","Uti - Money Market Fund","25/06/2018","90","T+0 Sal","27/03/2018","27/03/2018","27/03/2018","1000000000","983653000","98.3218","6.999979","Market"]
["29","CD - IDFC BANK - 06/04/18","INE092T16CW7","UTI Mutual Fund","Uti - Money Market Fund","06/04/2018","10","T+0 Sal","27/03/2018","27/03/2018","27/03/2018","250000000","249419250","99.7909","8.497936","Market"]
["30","CD - IDFC BANK - 05/04/18","INE092T16CU1","UTI Mutual Fund","Uti - Money Market Fund","05/04/2018","9","T+0 Sal","27/03/2018","27/03/2018","27/03/2018","2000000000","1995546000","99.802","9.051672","Market"]
["31","CD - IDFC BANK - 05/04/18","INE092T16CU1","UTI Mutual Fund","Uti - Money Market Fund","05/04/2018","9","T+0 Sal","27/03/2018","27/03/2018","27/03/2018","500000000","498886500","99.802","9.051672","Market"]
["32","7.90% SRNCD BHARAT ALUMIN-31/07/20","INE738C07069","UTI Mutual Fund","Uti - Smart Woman Savings Plan","31/07/2020","857","T+0 Sal","27/03/2018",null,"27/03/2018","160","156626880",null,null,"Interscheme"]
["33","CP - TATA MOTOR FINANCE-27/04/18","INE601U14422","UTI Mutual Fund","Uti - Liquid Cash Plan","27/04/2018","32","T+1 Pur","26/03/2018","26/03/2018","27/03/2018","100000000","99459400","99.4594","6.399726","Market"]
["34","CP - DEWAN HSG FIN CORP-14/05/18","INE202B14LD6","UTI Mutual Fund","Uti - Liquid Cash Plan","14/05/2018","49","T+1 Pur","26/03/2018","26/03/2018","27/03/2018","100000000","99165400","99.1654","6.399851","Market"]
["35","CP - AXIS FINANCE-21/05/18","INE891K14FN8","UTI Mutual Fund","Uti - Liquid Cash Plan","21/05/2018","56","T+1 Pur","26/03/2018","26/03/2018","27/03/2018","100000000","99044800","99.0448","6.400189","Market"]
["36","CP - L&T INFRA FIN CO-25/06/18","INE691I14HH4","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","90","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","5000000000","4909215000","98.2041","7.499899","Off Market"]
["37","CP - IIFL WEALTH FINANCE-04/05/18","INE248U14CW8","UTI Mutual Fund","Uti - Liquid Cash Plan","04/05/2018","39","T+1 Sal","26/03/2018","26/03/2018","27/03/2018","100000000","99338100","99.3381","6.400086","Market"]
["38","CP - BAHADUR CHAND INVT -04/05/18","INE087M14223","UTI Mutual Fund","Uti - Liquid Cash Plan","04/05/2018","39","T+1 Sal","26/03/2018","26/03/2018","27/03/2018","100000000","99338100","99.3381","6.400086","Market"]
["39","CP - KOTAK SECURITIES-15/05/18","INE028E14DK1","UTI Mutual Fund","Uti - Liquid Cash Plan","15/05/2018","50","T+1 Sal","26/03/2018","26/03/2018","27/03/2018","100000000","99148100","99.1481","6.40031","Market"]
["40","CP - BHARAT ALUMN CO-07/05/18","INE738C14EB6","UTI Mutual Fund","Uti - Liquid Cash Plan","07/05/2018","42","T+1 Sal","26/03/2018","26/03/2018","27/03/2018","100000000","99253000","99.253","6.700172","Market"]
["41","CP - INDIABULLS COMM CRED-07/06/18","INE244L14AM1","UTI Mutual Fund","Uti - Liquid Cash Plan","07/06/2018","72","T+0 Sal","27/03/2018","27/03/2018","27/03/2018","2800000000","2758590800","98.5375","7.630076","Interscheme"]
["42","CP - MANAPPURAM FINANCE-28/03/18","INE522D14HO8","UTI Mutual Fund","Uti - Liquid Cash Plan","28/03/2018","1","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","2800000000","2799389600","100","0","Interscheme"]
["43","CD - ANDHRA BANK - 25/06/18","INE434A16PD3","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","90","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","2000000000","1966828000","98.3525","6.869781","Market"]
["44","CD - ANDHRA BANK - 25/06/18","INE434A16PD3","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","90","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","3000000000","2950242000","98.3525","6.869781","Market"]
["45","CD - VIJAYA BANK - 26/06/18","INE705A16QE2","UTI Mutual Fund","Uti - Liquid Cash Plan","26/06/2018","91","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","2000000000","1966754000","98.3072","6.98346","Market"]
["46","CD - DENA BANK - 26/06/18","INE077A16EX2","UTI Mutual Fund","Uti - Liquid Cash Plan","26/06/2018","91","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","2500000000","2458442500","98.3557","6.780034","Market"]
["47","CD - ANDHRA BANK - 25/06/18","INE434A16PD3","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","90","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","5000000000","4916355000","98.3525","6.869781","Market"]
["48","CD - VIJAYA BANK - 26/06/18","INE705A16QE2","UTI Mutual Fund","Uti - Liquid Cash Plan","26/06/2018","91","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","3500000000","3439418500","98.3072","6.98346","Market"]
["49","CD - VIJAYA BANK - 26/06/18","INE705A16QE2","UTI Mutual Fund","Uti - Liquid Cash Plan","26/06/2018","91","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","1500000000","1474036500","98.3072","6.98346","Market"]
["50","CD - SOUTH INDIA BANK - 25/06/18","INE683A16KO3","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","90","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","2000000000","1965732000","98.3053","7.069989","Market"]
["51","CD - SOUTH INDIA BANK - 25/06/18","INE683A16KO3","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","90","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","500000000","491433000","98.3053","7.069989","Market"]
["52","CD - UNION BANK OF INDIA-25/06/18","INE692A16EX8","UTI Mutual Fund","Uti - Liquid Cash Plan","25/06/2018","90","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","17000000000","16711561000","98.3218","6.999979","Off Market"]
["53","9.5% SRNCD B B N H L-SRC14/09/2020","INE333L07060","UTI Mutual Fund","Uti - Short Term Income Fund","14/09/2020","902","T+0 Sal","27/03/2018","27/03/2018","27/03/2018","350","373678200","1070821","10.01885037","Interscheme"]
["54","CP -  SHRIRAM CITY UNI FIN-28/02/19","INE722A14CF9","UTI Mutual Fund","Uti - Treasury Advantage Fund","28/02/2019","338","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","1500000000","1391742000","92.8026","8.399984","Off Market"]
["55","CP - HDFC LTD. - 22/01/2019","INE001A14SL2","UTI Mutual Fund","Uti - Treasury Advantage Fund","22/01/2019","301","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","2500000000","2347092500","93.9028","7.899935","Off Market"]
["56","CP - POWER FIN CORP - 10/08/18","INE134E14923","UTI Mutual Fund","Uti - Treasury Advantage Fund","10/08/2018","136","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","250000000","243269750","97.3491","7.362419","Interscheme"]
["57","7.98%URNCD NABARD(SR16J)13/03/2019","INE261F08592","UTI Mutual Fund","Uti - Treasury Advantage Fund","13/03/2019","351","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","500","501995000","1004648","7.44870405","Interscheme"]
["58","CD - AXIS BANK LTD - 07/03/19","INE238A16Z24","UTI Mutual Fund","Uti - Floating Rate Fund Stp","07/03/2019","345","T+0 Sal","27/03/2018",null,"27/03/2018","500000000","467334500",null,null,"Market"]
["59","CD - AXIS BANK LTD - 07/03/19","INE238A16Z24","UTI Mutual Fund","Uti - Floating Rate Fund Stp","07/03/2019","345","T+0 Sal","27/03/2018",null,"27/03/2018","100000000","93466900",null,null,"Market"]
["60","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Spread Fund","08/03/2019","346","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","750000000","701024250","93.562","7.279897","Interscheme"]
["61","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Spread Fund","08/03/2019","346","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","250000000","233674750","93.562","7.279897","Interscheme"]
["62","CD - HDFC BANK - 08/3/19","INE040A16CC8","UTI Mutual Fund","Uti - Spread Fund","08/03/2019","346","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","250000000","233674750","93.562","7.279897","Interscheme"]
["63","7.28% URNCD PFC SR 168A-10/06/2022","INE134E08JB5","UTI Mutual Fund","Uti - Income Opportunities Fund","10/06/2022","1536","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","100","97959400","979695","7.84751233","Market"]
["64","7.99% URNCD PFC (OP-B)-20/12/2022","INE134E08JO8","UTI Mutual Fund","Uti - Income Opportunities Fund","20/12/2022","1729","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","250","251511000","1006130","7.8374818","Market"]
["65","7.8409% SRNCD BFL SR208(I)-29/06/20","INE296A07OY4","UTI Mutual Fund","Uti - Income Opportunities Fund","29/06/2020","825","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","100","99514700","995253","8.09280413","Market"]
["66","CP - POWER FIN CORP - 10/08/18","INE134E14923","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","10/08/2018","136","T+0 Sal","27/03/2018",null,"27/03/2018","250000000","243269750",null,null,"Interscheme"]
["67","7.98%URNCD NABARD(SR16J)13/03/2019","INE261F08592","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","13/03/2019","351","T+0 Sal","27/03/2018",null,"27/03/2018","500","501995000",null,null,"Interscheme"]
["68","7.65% URNCBONDSIDBI-XII-15/04/2021","INE556F08JD2","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Ix (1168 Days)","15/04/2021","1115","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","15","15000000","1002292","7.56266777","Market"]
["69","7.65% URNCBONDSIDBI-XII-15/04/2021","INE556F08JD2","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xii (1154 Days)","15/04/2021","1115","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","85","85000000","1002292","7.56266777","Market"]
["70","7.65% URNCBONDSIDBI-XII-15/04/2021","INE556F08JD2","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiii (1134 Days)","15/04/2021","1115","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","60","60000000","1002292","7.56266777","Market"]
["71","9.5% SRNCD B B N H L-SRC14/09/2020","INE333L07060","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiii (1134 Days)","14/09/2020","902","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","350","373678200","1070821","10.01885037","Interscheme"]
["72","7.90% SRNCD BHARAT ALUMIN-31/07/20","INE738C07069","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiii (1134 Days)","31/07/2020","857","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","110","107680980","981866","8.74314174","Interscheme"]
["73","7.90% SRNCD BHARAT ALUMIN-31/07/20","INE738C07069","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiii (1134 Days)","31/07/2020","857","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","160","156626880","981866","8.74314174","Interscheme"]
["74","8.28% SRNCD O N B H L-SR-A-30/03/21","INE105N07092","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiii (1134 Days)","30/03/2021","1099","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","1500","151312050","101142.1","7.99218883","Interscheme"]
["75","8.75% SRNCD VEDANTA(SR 3)15/04/2021","INE205A07063","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiii (1134 Days)","15/04/2021","1115","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","400","403186800","1011495","8.36701203","Interscheme"]
["76","0%SRNCD BAJAJ HSG FIN(3)-04/05/2021",null,"UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiv (1147 Days)","04/05/2021","1134","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","95","95778335","1007505","8.15122503","Off Market"]
["77","7.65% URNCBONDSIDBI-XII-15/04/2021","INE556F08JD2","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Xiv (1147 Days)","15/04/2021","1115","T+0 Pur","27/03/2018","27/03/2018","27/03/2018","90","90000000","1002292","7.56266777","Market"]