{"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":51,"n_cols":16,"rows_kept":51,"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 - Retirement Benefit Pension Fund","18/06/2020","995","T+0 Sal","27/09/2017",null,"27/09/2017","6","6326106",null,null,"Interscheme"]
["2","9.70% UNCD TATA MOTORS-18/06/2020","INE155A08068","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","18/06/2020","995","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","30","31630530","1054297","7.38787831","Interscheme"]
["3","9.70% UNCD TATA MOTORS-18/06/2020","INE155A08068","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Ix (1160 Days)","18/06/2020","995","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","6","6326106","1054297","7.38787831","Interscheme"]
["4","9.70% UNCD TATA MOTORS-18/06/2020","INE155A08068","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Ix (1160 Days)","18/06/2020","995","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","30","31630530","1054297","7.38787831","Interscheme"]
["5","8.37%URNCD RURAL ELEC COR14/08/2020","INE020B08948","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","14/08/2020","1052","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","26","26875316","1033587","7.03517433","Interscheme"]
["6","8.37%URNCD RURAL ELEC COR14/08/2020","INE020B08948","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Viii (1117 Days)","14/08/2020","1052","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","26","26875316","1033587","7.03517433","Interscheme"]
["7","CP - INDIABULLS COM CREDIT-15/12/17","INE244L14966","UTI Mutual Fund","Uti - Money Market Fund","15/12/2017","79","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","3800000000","3744884800","98.5677","6.799823","Off Market"]
["8","8.73% SRNCD PGC-(SR21-K)-11/10/2020","INE752E07BY5","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","11/10/2020","1110","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","20","26143775","1306980","7.00129993","Interscheme"]
["9","8.73% SRNCD PGC-(SR21-K)-11/10/2020","INE752E07BY5","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Viii (1117 Days)","11/10/2020","1110","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","20","26143775","1306980","7.00129993","Interscheme"]
["10","8.9% SRNCD IHFL-SRIIIB-26/09/2021","INE148I07GF5","UTI Mutual Fund","Uti - Income Opportunities Fund","26/09/2021","1460","T+0 Sal","27/09/2017",null,"27/09/2017","50000","51428200",null,null,"Market"]
["11","8.9% SRNCD IHFL-SRIIIB-26/09/2021","INE148I07GF5","UTI Mutual Fund","Uti - Income Opportunities Fund","26/09/2021","1460","T+0 Sal","27/09/2017",null,"27/09/2017","500000","514282000",null,null,"Market"]
["12","8.9% SRNCD IHFL-SRIIIB-26/09/2021","INE148I07GF5","UTI Mutual Fund","Uti - Medium Term Fund","26/09/2021","1460","T+0 Sal","27/09/2017",null,"27/09/2017","50000","51428200",null,null,"Market"]
["13","11.25%URNCD INDIA INFO FIN 05/09/20","INE866I08196","UTI Mutual Fund","Uti - C.R.T.S. 1981","05/09/2020","1074","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","1","1060220","1059899","8.82727155","Interscheme"]
["14","11.25%URNCD INDIA INFO FIN 05/09/20","INE866I08196","UTI Mutual Fund","Uti - C.R.T.S. 1981","05/09/2020","1074","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","22","23324840","1059899","8.82727155","Interscheme"]
["15","11.25%URNCD INDIA INFO FIN 05/09/20","INE866I08196","UTI Mutual Fund","Uti - C.R.T.S. 1981","05/09/2020","1074","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","39","41348580","1059899","8.82727155","Interscheme"]
["16","11.25%URNCD INDIA INFO FIN 05/09/20","INE866I08196","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Viii (1117 Days)","05/09/2020","1074","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","1","1060220","1059899","8.82727155","Interscheme"]
["17","11.25%URNCD INDIA INFO FIN 05/09/20","INE866I08196","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Viii (1117 Days)","05/09/2020","1074","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","22","23324840","1059899","8.82727155","Interscheme"]
["18","11.25%URNCD INDIA INFO FIN 05/09/20","INE866I08196","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Ix (1160 Days)","05/09/2020","1074","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","39","41348580","1059899","8.82727155","Interscheme"]
["19","7.09%URNC BOND SIDBI-II- 19/06/2020","INE556F08IW4","UTI Mutual Fund","Uti - Short Term Income Fund","19/11/2018","418","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","28","28058380","1001759","6.99338093","Interscheme"]
["20","7.09%URNC BOND SIDBI-II- 19/06/2020","INE556F08IW4","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Viii (1117 Days)","19/11/2018","418","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","28","28058380","1001759","6.99338093","Interscheme"]
["21","7.60%HDFC SRNCD-R14-26/06/2020","INE001A07QP1","UTI Mutual Fund","Uti - Short Term Income Fund","26/06/2020","1003","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","2","20076280","10042900","7.39285053","Interscheme"]
["22","7.60%HDFC SRNCD-R14-26/06/2020","INE001A07QP1","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Viii (1117 Days)","26/06/2020","1003","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","2","20076280","10042900","7.39285053","Interscheme"]
["23","7.46% URNCD PFC SR 166-05/06/2020","INE134E08IZ6","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","05/06/2020","982","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","28","28204736","1007159","7.13144959","Interscheme"]
["24","7.46% URNCD PFC SR 166-05/06/2020","INE134E08IZ6","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Viii (1117 Days)","05/06/2020","982","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","28","28204736","1007159","7.13144959","Interscheme"]
["25","8.47% SRNCD LHF(302) 07/07/2020","INE115A07JV2","UTI Mutual Fund","Uti - Short Term Income Fund","07/07/2020","1014","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","28","28692216","1025067","7.40795441","Interscheme"]
["26","8.47% SRNCD LHF(302) 07/07/2020","INE115A07JV2","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Viii (1117 Days)","07/07/2020","1014","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","28","28692216","1025067","7.40795441","Interscheme"]
["27","CP - HDFC LTD - 28/09/17","INE001A14RA7","UTI Mutual Fund","Uti - Liquid Cash Plan","28/09/2017","1","T+0 Sal","27/09/2017",null,"27/09/2017","1750000000","1749702500",null,null,"Market"]
["28","CP - HDFC LTD - 28/09/17","INE001A14RA7","UTI Mutual Fund","Uti - Money Market Fund","28/09/2017","1","T+0 Sal","27/09/2017",null,"27/09/2017","900000000","899847000",null,null,"Market"]
["29","CP - HDFC LTD - 28/09/17","INE001A14RA7","UTI Mutual Fund","Uti - Money Market Fund","28/09/2017","1","T+0 Sal","27/09/2017",null,"27/09/2017","500000000","499915000",null,null,"Market"]
["30","CP - HDFC LTD - 28/09/17","INE001A14RA7","UTI Mutual Fund","Uti - Money Market Fund","28/09/2017","1","T+0 Sal","27/09/2017",null,"27/09/2017","400000000","399932000",null,null,"Market"]
["31","CP - HDFC LTD - 28/09/17","INE001A14RA7","UTI Mutual Fund","Uti - Liquid Cash Plan","28/09/2017","1","T+0 Sal","27/09/2017",null,"27/09/2017","1000000000","999830000",null,null,"Market"]
["32","CP - MANAPPURAM FINANCE-02/11/17","INE522D14GL6","UTI Mutual Fund","Uti - Money Market Fund","02/11/2017","37","T+1 Sal","26/09/2017","26/09/2017","27/09/2017","50000000","49657150","99.3143","7.000237","Market"]
["33","7.90% SRNCD BHARAT ALUMIN-31/07/20","INE738C07069","UTI Mutual Fund","Uti - Smart Woman Savings Plan","31/07/2020","1038","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","40","39853800","996219","8.03104744","Interscheme"]
["34","7.90% SRNCD BHARAT ALUMIN-31/07/20","INE738C07069","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Ix (1160 Days)","31/07/2020","1038","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","40","39853800","996219","8.03104744","Interscheme"]
["35","0% SRNCD EDEL HSG FIN-02/06/2020","INE530L07285","UTI Mutual Fund","Uti - Smart Woman Savings Plan","02/06/2020","979","T+0 Sal","27/09/2017",null,"27/09/2017","35","35928305",null,null,"Interscheme"]
["36","0% SRNCD EDEL HSG FIN-02/06/2020","INE530L07285","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Ix (1160 Days)","02/06/2020","979","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","35","35928305","1026498","8.46487713","Interscheme"]
["37","CP - BAJAJ FINANCE - 29/09/17","INE296A14MK3","UTI Mutual Fund","Uti - Liquid Cash Plan","29/09/2017","2","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","1000000000","999658000","99.9829","6.242567","Market"]
["38","8.65% UNCD BOB (T-1) PERP SR-IX","INE028A08117","UTI Mutual Fund","Uti - Wealth Builder Fund","11/08/2022","1779","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","250","247461500","989944","8.89733493","Market"]
["39","CD - AXIS BANK - 05/12/2017","INE238A16T89","UTI Mutual Fund","Uti - Floating Rate Fund Stp","05/12/2017","69","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","1000000000","988526000","98.869","6.140255","Market"]
["40","CD - AXIS BANK - 05/12/2017","INE238A16T89","UTI Mutual Fund","Uti - Floating Rate Fund Stp","05/12/2017","69","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","1000000000","988526000","98.869","6.140255","Market"]
["41","0% SRNCD JM FIN CR SL(II)15/09/2020","INE651J07499","UTI Mutual Fund","Uti - Smart Woman Savings Plan","15/09/2020","1084","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","24","24027000","1001088","8.94649242","Interscheme"]
["42","0% SRNCD JM FIN CR SL(II)15/09/2020","INE651J07499","UTI Mutual Fund","Uti - Smart Woman Savings Plan","15/09/2020","1084","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","40","40045000","1001088","8.94649242","Interscheme"]
["43","0% SRNCD JM FIN CR SL(II)15/09/2020","INE651J07499","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Viii (1117 Days)","15/09/2020","1084","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","24","24027000","1001088","8.94649242","Interscheme"]
["44","0% SRNCD JM FIN CR SL(II)15/09/2020","INE651J07499","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Ix (1160 Days)","15/09/2020","1084","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","40","40045000","1001088","8.94649242","Interscheme"]
["45","8.20%URNCD PIRAMAL ENT-27/07/2020","INE140A08SW7","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","27/07/2020","1034","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","40","40140560","1003384","8.03742876","Interscheme"]
["46","8.20%URNCD PIRAMAL ENT-27/07/2020","INE140A08SW7","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Ix (1160 Days)","27/07/2020","1034","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","40","40140560","1003384","8.03742876","Interscheme"]
["47","CP - NABHA POWER LTD-22/12/17","INE445L14639","UTI Mutual Fund","Uti - Money Market Fund","22/12/2017","86","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","500000000","492709500","98.5654","6.250004","Off Market"]
["48","CD - KOTAK MAH BANK-10/11/17","INE237A165A8","UTI Mutual Fund","Uti - Money Market Fund","10/11/2017","45","T+1 Sal","26/09/2017","26/09/2017","27/09/2017","50000000","49626100","99.2522","6.250079","Market"]
["49","7.85%SNCD TALWAND SABO POW-04/08/20","INE694L07107","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","04/08/2020","1042","T+0 Sal","27/09/2017","27/09/2017","27/09/2017","41","40895286","997319","7.93600786","Interscheme"]
["50","7.85%SNCD TALWAND SABO POW-04/08/20","INE694L07107","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan Ix (1160 Days)","04/08/2020","1042","T+0 Pur","27/09/2017","27/09/2017","27/09/2017","41","40895286","997319","7.93600786","Interscheme"]