{"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":53,"n_cols":16,"rows_kept":53,"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 - Short Term Income Fund","18/06/2020","897","T+1 Sal","03/01/2018","03/01/2018","04/01/2018","100","104074224.66","1040964","7.75158634","Market"]
["2","9.70% UNCD TATA MOTORS-18/06/2020","INE155A08068","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","18/06/2020","897","T+1 Sal","03/01/2018",null,"04/01/2018","400","416296898.63",null,null,"Market"]
["3","0% SNCD KKR FIN SERV (SR-4)-16/1/21","INE321N07046","UTI Mutual Fund","Uti - Floating Rate Fund Stp","16/01/2021","1108","T+0 Sal","04/01/2018","04/01/2018","04/01/2018","2","28014840","14010740","9.0364377","Interscheme"]
["4","0% SNCD KKR FIN SERV (SR-4)-16/1/21","INE321N07046","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Iii (1203 Days)","16/01/2021","1108","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","2","28014840","14010740","9.0364377","Interscheme"]
["5","9.69% URNCD PFC-SR-113-02/03/2019","INE134E07513","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","02/03/2019","422","T+0 Sal","04/01/2018",null,"04/01/2018","3","3070197",null,null,"Interscheme"]
["6","9.69% URNCD PFC-SR-113-02/03/2019","INE134E07513","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","02/03/2019","422","T+0 Sal","04/01/2018",null,"04/01/2018","10","10233990",null,null,"Interscheme"]
["7","9.69% URNCD PFC-SR-113-02/03/2019","INE134E07513","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","02/03/2019","422","T+0 Sal","04/01/2018",null,"04/01/2018","10","10233990",null,null,"Interscheme"]
["8","9.69% URNCD PFC-SR-113-02/03/2019","INE134E07513","UTI Mutual Fund","Uti - Childrens Career Balanced Plan","02/03/2019","422","T+0 Sal","04/01/2018",null,"04/01/2018","8","8187192",null,null,"Interscheme"]
["9","9.69% URNCD PFC-SR-113-02/03/2019","INE134E07513","UTI Mutual Fund","Uti - Ftif Series Xxiv - Viii (1184 Days)","02/03/2019","422","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","3","3070197","1023242","7.46997662","Interscheme"]
["10","9.69% URNCD PFC-SR-113-02/03/2019","INE134E07513","UTI Mutual Fund","Uti - Ftif Series Xxiv - X (1118 Days)","02/03/2019","422","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","10","10233990","1023242","7.46997662","Interscheme"]
["11","9.69% URNCD PFC-SR-113-02/03/2019","INE134E07513","UTI Mutual Fund","Uti - Ftif Series Xxiv - Vii (1182 Days)","02/03/2019","422","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","10","10233990","1023242","7.46997662","Interscheme"]
["12","9.69% URNCD PFC-SR-113-02/03/2019","INE134E07513","UTI Mutual Fund","Uti - Ftif Series Xxiv - V (1132 Days)","02/03/2019","422","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","8","8187192","1023242","7.46997662","Interscheme"]
["13","7.95%URNCD P F C SR148-13/05/2019.","INE134E08IF8","UTI Mutual Fund","Uti - C.R.T.S. 1981","13/05/2019","494","T+0 Sal","04/01/2018",null,"04/01/2018","20","20094980",null,null,"Interscheme"]
["14","7.95%URNCD P F C SR148-13/05/2019.","INE134E08IF8","UTI Mutual Fund","Uti - Ftif Series Xxiv - Vi (1181 Days)","13/05/2019","494","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","20","20094980","1004616","7.52560388","Interscheme"]
["15","8.72% SRNCD IL&FS (I-B)-21/01/2025.","INE871D07NL7","UTI Mutual Fund","Uti - Dynamic Bond Fund","21/01/2025","2575","T+1 Pur","03/01/2018","03/01/2018","04/01/2018","300000","304027500","1008.842","8.5383635","Market"]
["16","8.79% SRNCD M&M FIN-SRAB-23/01/2025","INE774D07KW6","UTI Mutual Fund","Uti - Bond Fund","23/01/2025","2577","T+1 Pur","03/01/2018","03/01/2018","04/01/2018","450","460982410.2801","1025051","8.29698564","Market"]
["17","7.37% SR66 NTPC SRBOND-14/12/2031","INE733E07KI9","UTI Mutual Fund","Uti - Dynamic Bond Fund","14/12/2031","5093","T+1 Sal","03/01/2018",null,"04/01/2018","500","475803000",null,null,"Market"]
["18","7.37% SR66 NTPC SRBOND-14/12/2031","INE733E07KI9","UTI Mutual Fund","Uti - Bond Fund","14/12/2031","5093","T+1 Sal","03/01/2018",null,"04/01/2018","450","428222700",null,null,"Market"]
["19","CP - BHARTI TELECOM - 31/01/18","INE403D14015","UTI Mutual Fund","Uti - Money Market Fund","31/01/2018","27","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","150000000","149309700","99.5568","6.249544","Market"]
["20","CP - INDIABULLS HSG FIN -12/01/18","INE148I14TL2","UTI Mutual Fund","Uti - Money Market Fund","12/01/2018","8","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","1750000000","1747548250","99.8774","6.400561","Market"]
["21","CD - AXIS BANK - 27/02/18","INE238A16V02","UTI Mutual Fund","Uti - Liquid Cash Plan","27/02/2018","55","T+1 Sal","03/01/2018","03/01/2018","04/01/2018","250000000","247727750","99.0911","6.199841","Market"]
["22","CP - TATA MOTOR FINANCE-15/01/18","INE601U14240","UTI Mutual Fund","Uti - Money Market Fund","15/01/2018","11","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","1000000000","998045000","99.8222","6.501259","Market"]
["23","CP - MUTHOOT FINANCE- 16/02/2018","INE414G14GK1","UTI Mutual Fund","Uti - Money Market Fund","16/02/2018","44","T+1 Sal","03/01/2018","03/01/2018","04/01/2018","50000000","49620050","99.2401","6.499705","Market"]
["24","0%UNCD IDFC BK(OBB05-I)05/04/2018","INE092T08AA4","UTI Mutual Fund","Uti - Short Term Income Fund","05/04/2018","91","T+0 Sal","04/01/2018",null,"04/01/2018","3000","3733893000",null,null,"Market"]
["25","8.97%SRNCD UPPOWER(3A)15/02/2021","INE540P07046","UTI Mutual Fund","Uti - Dynamic Bond Fund","15/02/2021","1138","T+0 Sal","04/01/2018","04/01/2018","04/01/2018","2","2040882","1020307","8.37392067","Interscheme"]
["26","8.97%SRNCD UPPOWER(3A)15/02/2021","INE540P07046","UTI Mutual Fund","Uti - Dynamic Bond Fund","15/02/2021","1138","T+0 Sal","04/01/2018","04/01/2018","04/01/2018","18","18367938","1020307","8.37392067","Interscheme"]
["27","8.97%SRNCD UPPOWER(3A)15/02/2021","INE540P07046","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Iii (1203 Days)","15/02/2021","1138","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","2","2040882","1020307","8.37392067","Interscheme"]
["28","8.97%SRNCD UPPOWER(3A)15/02/2021","INE540P07046","UTI Mutual Fund","Uti - Ftif Series Xxviii - Plan Iii (1203 Days)","15/02/2021","1138","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","18","18367938","1020307","8.37392067","Interscheme"]
["29","7.2% SRNCD PGC (SR-LX)-09/08/27","INE752E07OG5","UTI Mutual Fund","Uti - Bond Fund","09/08/2027","3505","T+1 Sal","03/01/2018",null,"04/01/2018","450","430350300",null,null,"Market"]
["30","7.2% SRNCD PGC (SR-LX)-09/08/27","INE752E07OG5","UTI Mutual Fund","Uti - Dynamic Bond Fund","09/08/2027","3505","T+1 Sal","03/01/2018",null,"04/01/2018","500","478167000",null,null,"Market"]
["31","CD - ICICI BANK - 31/05/18","INE090A160O6","UTI Mutual Fund","Uti - Floating Rate Fund Stp","31/05/2018","148","T+1 Sal","03/01/2018",null,"04/01/2018","500000000","486195500",null,null,"Market"]
["32","CD - HDFC BANK - 12/06/18","INE040A16BO5","UTI Mutual Fund","Uti - Floating Rate Fund Stp","12/06/2018","160","T+1 Sal","03/01/2018",null,"04/01/2018","250000000","242551000",null,null,"Market"]
["33","CD - HDFC BANK - 12/06/18","INE040A16BO5","UTI Mutual Fund","Uti - Treasury Advantage Fund","12/06/2018","159","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","250000000","242602250","97.059","6.999951","Market"]
["34","CD - HDFC BANK - 12/06/18","INE040A16BO5","UTI Mutual Fund","Uti - Treasury Advantage Fund","12/06/2018","159","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","500000000","485204500","97.059","6.999951","Market"]
["35","CD - SOUTH INDIAN BANK - 28/02/18","INE683A16JY4","UTI Mutual Fund","Uti - Money Market Fund","28/02/2018","56","T+1 Sal","03/01/2018","03/01/2018","04/01/2018","50000000","49537200","99.0744","6.200005","Market"]
["36","CP - VEDANTA LTD - 09/01/18","INE205A14KN2","UTI Mutual Fund","Uti - Money Market Fund","09/01/2018","5","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","1950000000","1948399050","99.9343","5.999066","Market"]
["37","CP - HDFC LTD. - 02/02/2018","INE001A14RN0","UTI Mutual Fund","Uti - Liquid Cash Plan","02/02/2018","29","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","250000000","248764750","99.5229","6.249154","Market"]
["38","CP - SUN PHARMA INDS-26/02/18","INE044A14278","UTI Mutual Fund","Uti - Liquid Cash Plan","26/02/2018","54","T+1 Pur","03/01/2018","03/01/2018","04/01/2018","500000000","495503000","99.1006","6.250195","Market"]
["39","CD - SOUTH INDIAN BANK -26/02/18","INE683A16KA2","UTI Mutual Fund","Uti - Money Market Fund","26/02/2018","54","T+1 Sal","03/01/2018","03/01/2018","04/01/2018","50000000","49553900","99.1078","6.19971","Market"]
["40","CP - JM FINANCIAL -26/02/18","INE780C14984","UTI Mutual Fund","Uti - Liquid Cash Plan","26/02/2018","54","T+1 Sal","03/01/2018","03/01/2018","04/01/2018","50000000","49532500","99.065","6.499925","Market"]
["41","CP  NABHA POWER - 16/02/18","INE445L14712","UTI Mutual Fund","Uti - Liquid Cash Plan","16/02/2018","44","T+1 Pur","03/01/2018","03/01/2018","04/01/2018","50000000","49637450","99.2749","6.199874","Market"]
["42","9%URNCD RELIANCE JIO-OP-2-21.01.25","INE110L08060","UTI Mutual Fund","Uti - Dynamic Bond Fund","21/01/2025","2575","T+1 Pur","03/01/2018","03/01/2018","04/01/2018","350","361325002.7401","1032128","8.36869643","Market"]
["43","CP - INDIABULL COMM CREDIT-23/02/18","INE244L14AG3","UTI Mutual Fund","Uti - Money Market Fund","23/02/2018","51","T+1 Pur","03/01/2018","03/01/2018","04/01/2018","50000000","49558700","99.1174","6.500352","Market"]
["44","CD - SOUTH INDIAN BANK-23/02/18","INE683A16JX6","UTI Mutual Fund","Uti - Liquid Cash Plan","23/02/2018","51","T+1 Pur","03/01/2018","03/01/2018","04/01/2018","50000000","49578900","99.1578","6.200279","Market"]
["45","CP - HDFC LTD - 17/05/18","INE001A14RS9","UTI Mutual Fund","Uti - Treasury Advantage Fund","17/05/2018","133","T+0 Sal","04/01/2018",null,"04/01/2018","250000000","243263250",null,null,"Market"]
["46","CP - HDFC LTD - 17/05/18","INE001A14RS9","UTI Mutual Fund","Uti - Treasury Advantage Fund","17/05/2018","133","T+0 Sal","04/01/2018",null,"04/01/2018","1000000000","973053000",null,null,"Market"]
["47","CP - HDFC LTD - 17/05/18","INE001A14RS9","UTI Mutual Fund","Uti - Treasury Advantage Fund","17/05/2018","134","T+1 Sal","03/01/2018","03/01/2018","04/01/2018","250000000","243418750","97.3675","7.419858","Market"]
["48","CP - VEDANATA LTD - 06/03/18","INE205A14LG4","UTI Mutual Fund","Uti - Liquid Cash Plan","06/03/2018","62","T+1 Sal","03/01/2018",null,"04/01/2018","1200000000","1187104800",null,null,"Market"]
["49","CP - VEDANATA LTD - 06/03/18","INE205A14LG4","UTI Mutual Fund","Uti - Liquid Cash Plan","06/03/2018","62","T+1 Sal","03/01/2018",null,"04/01/2018","1000000000","989254000",null,null,"Market"]
["50","CD - AXIS BANK - 28/03/18","INE238A16W68","UTI Mutual Fund","Uti - Liquid Cash Plan","28/03/2018","83","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","2500000000","2463752500","98.5673","6.469957","Off Market"]
["51","CP - ADITYA BIRLA HSG FIN-28/02/18","INE831R14819","UTI Mutual Fund","Uti - Liquid Cash Plan","28/02/2018","55","T+0 Pur","04/01/2018","04/01/2018","04/01/2018","3000000000","2970147000","99.0228","6.670331","Off Market"]
["52","CP - SUN PHARMA LAB -26/02/18","INE915T14154","UTI Mutual Fund","Uti - Liquid Cash Plan","26/02/2018","54","T+1 Sal","03/01/2018","03/01/2018","04/01/2018","250000000","247751500","99.1006","6.250195","Market"]