{"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":29,"n_cols":16,"rows_kept":29,"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","8.24% URNCD NABARD(PB5SA4)22/03/29","INE261F08BF1","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","22/03/2029","3226","T+4 Sal","22/05/2020","22/05/2020","26/05/2020","100","110298890.72","1102217","6.79402669","Market"]
["2","7.25% URNCD -  L &T LTD - 24/4/23","INE018A08AY9","UTI Mutual Fund","Uti - Treasury Advantage Fund","24/04/2023","1067","T+4 Sal","22/05/2020","22/05/2020","26/05/2020","500","514177500","1028443","6.15041414","Market"]
["3","6.35% UNCD EXIM-SRV01-18/02/25","INE514E08FT8","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","18/02/2025","1729","T+0 Sal","26/05/2020",null,"26/05/2020","120","122904886.77",null,null,"Market"]
["4","6.35% UNCD EXIM-SRV01-18/02/25","INE514E08FT8","UTI Mutual Fund","Uti - Short Term Income Fund","18/02/2025","1729","T+0 Sal","26/05/2020",null,"26/05/2020","130","133146960.66997",null,null,"Market"]
["5","6.35% UNCD EXIM-SRV01-18/02/25","INE514E08FT8","UTI Mutual Fund","Uti - Floater Fund","18/02/2025","1729","T+0 Sal","26/05/2020",null,"26/05/2020","50","51210369.49",null,null,"Market"]
["6","6.35% UNCD EXIM-SRV01-18/02/25","INE514E08FT8","UTI Mutual Fund","Uti - Floater Fund","18/02/2025","1729","T+0 Sal","26/05/2020",null,"26/05/2020","200","204841477.96",null,null,"Market"]
["7","PTC-FIRST BUSINESS REC-SR18-1/07/24","INE0BTV15188","UTI Mutual Fund","Uti - Credit Risk Fund.","01/07/2024","1501","T+4 Sal","22/05/2020",null,"26/05/2020","5","35445400",null,null,"Market"]
["8","PTC-FIRST BUSINESS REC-SR19-1/10/24","INE0BTV15196","UTI Mutual Fund","Uti - Credit Risk Fund.","01/10/2024","1593","T+4 Sal","22/05/2020",null,"26/05/2020","5","34703850",null,null,"Market"]
["9","7.33% SRNCD LHF(TR-398)12/02/2025","INE115A07OS8","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","12/02/2025","1723","T+0 Sal","26/05/2020",null,"26/05/2020","100","101342275.78",null,null,"Market"]
["10","CP - TATA STEEL  - 24/08/20","INE081A14AT5","UTI Mutual Fund","Uti - Liquid Cash Plan","24/08/2020","90","T+0 Pur","26/05/2020","26/05/2020","26/05/2020","2500000000","2471057500","98.855","4.750176","Off Market"]
["11","CP - HDFC LTD - 25/05/21","INE001A14WP5","UTI Mutual Fund","Uti - Arbitrage Fund","25/05/2021","364","T+0 Pur","26/05/2020","26/05/2020","26/05/2020","500000000","472661000","94.5464","5.799954","Off Market"]
["12","6.75% URNCD PFC (OPT-A)-22/05/2023","INE134E08KS7","UTI Mutual Fund","Uti - Treasury Advantage Fund","22/05/2023","1091","T+0 Sal","26/05/2020","26/05/2020","26/05/2020","500","502626000","1004174","6.59035639","Market"]
["13","6.75% URNCD PFC (OPT-A)-22/05/2023","INE134E08KS7","UTI Mutual Fund","Uti - Short Term Income Fund","22/05/2023","1091","T+0 Sal","26/05/2020","26/05/2020","26/05/2020","200","201050400","1004174","6.59035639","Market"]
["14","6.75% URNCD PFC (OPT-A)-22/05/2023","INE134E08KS7","UTI Mutual Fund","Uti - Floater Fund","22/05/2023","1091","T+0 Sal","26/05/2020","26/05/2020","26/05/2020","200","201050400","1004174","6.59035639","Market"]
["15","6.75% URNCD PFC (OPT-A)-22/05/2023","INE134E08KS7","UTI Mutual Fund","Uti - Treasury Advantage Fund","22/05/2023","1091","T+0 Sal","26/05/2020","26/05/2020","26/05/2020","100","100525200","1004174","6.59035639","Market"]
["16","6.75% URNCD PFC (OPT-A)-22/05/2023","INE134E08KS7","UTI Mutual Fund","Uti - Treasury Advantage Fund","22/05/2023","1091","T+0 Pur","26/05/2020","26/05/2020","26/05/2020","700","700000000","1004174","6.59035639","Market"]
["17","6.75% URNCD PFC (OPT-A)-22/05/2023","INE134E08KS7","UTI Mutual Fund","Uti - Treasury Advantage Fund","22/05/2023","1091","T+0 Pur","26/05/2020","26/05/2020","26/05/2020","300","300000000","1004174","6.59035639","Market"]
["18","6.75% URNCD PFC (OPT-A)-22/05/2023","INE134E08KS7","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","22/05/2023","1095","T+4 Pur","22/05/2020","22/05/2020","26/05/2020","250","250652250","1005008","6.56029366","Market"]
["19","CD - IDFC FIRST BANK - 20/08/20","INE092T16OS0","UTI Mutual Fund","Uti - Liquid Cash Plan","20/08/2020","86","T+0 Pur","26/05/2020","26/05/2020","26/05/2020","5000000000","4947540000","98.9652","4.490016","Off Market"]
["20","7.79% URNCD REC (SR-198-B)-21/05/30","INE020B08CW3","UTI Mutual Fund","Uti - Bond Fund","21/05/2030","3651","T+4 Pur","22/05/2020","22/05/2020","26/05/2020","300","300000000","1003383","7.73573394","Market"]
["21","7.79% URNCD REC (SR-198-B)-21/05/30","INE020B08CW3","UTI Mutual Fund","Uti - Dynamic Bond Fund.","21/05/2030","3651","T+4 Pur","22/05/2020","22/05/2020","26/05/2020","300","300000000","1003383","7.73573394","Market"]
["22","7.79% URNCD REC (SR-198-B)-21/05/30","INE020B08CW3","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","21/05/2030","3651","T+4 Pur","22/05/2020","22/05/2020","26/05/2020","130","130000000","1003383","7.73573394","Market"]
["23","7.79% URNCD REC (SR-198-B)-21/05/30","INE020B08CW3","UTI Mutual Fund","Uti - Short Term Income Fund","21/05/2030","3651","T+4 Pur","22/05/2020","22/05/2020","26/05/2020","270","270000000","1003383","7.73573394","Market"]
["24","CP - NTPC - 03/08/20","INE733E14773","UTI Mutual Fund","Uti - Liquid Cash Plan","03/08/2020","73","T+4 Sal","22/05/2020",null,"26/05/2020","2500000000","2485435000",null,null,"Market"]
["25","7.79% URNCD PFC(SR-202C)-22/07/2030","INE134E08KU3","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","22/07/2030","3709","T+0 Pur","26/05/2020","26/05/2020","26/05/2020","100","100000000","1001002","7.77335804","Market"]
["26","7.79% URNCD PFC(SR-202C)-22/07/2030","INE134E08KU3","UTI Mutual Fund","Uti - Floater Fund","22/07/2030","3709","T+0 Pur","26/05/2020","26/05/2020","26/05/2020","300","300000000","1001002","7.77335804","Market"]
["27","7.79% URNCD PFC(SR-202C)-22/07/2030","INE134E08KU3","UTI Mutual Fund","Uti - Dynamic Bond Fund.","22/07/2030","3709","T+0 Pur","26/05/2020","26/05/2020","26/05/2020","100","100000000","1001002","7.77335804","Market"]
["28","7.79% URNCD PFC(SR-202C)-22/07/2030","INE134E08KU3","UTI Mutual Fund","Uti - Short Term Income Fund","22/07/2030","3709","T+0 Pur","26/05/2020","26/05/2020","26/05/2020","500","500000000","1001002","7.77335804","Market"]