{"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":27,"n_cols":16,"rows_kept":27,"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.30% URNCD RIL (PPD-J)-08/03/2022","INE002A08575","UTI Mutual Fund","Uti - Short Term Income Fund","08/03/2022","650","T+1 Pur","27/05/2020","27/05/2020","28/05/2020","250","258271500","1033604","6.21927274","Market"]
["2","8.41% URNCD HUDCO (SR-V)15/03/2029","INE031A08699","UTI Mutual Fund","Uti - Regular Savings Fund.","15/03/2029","3214","T+1 Sal","27/05/2020","27/05/2020","28/05/2020","100","111530241.41","1116273","6.74738482","Market"]
["3","8.75%SRNCD AMBA RIV COKE10/02/2022","INE503N07023","UTI Mutual Fund","Uti - Medium Term Fund","10/02/2022","623","T+0 Sal","28/05/2020","28/05/2020","28/05/2020","50","49393950","987667","9.51322314","Interscheme"]
["4","8.75%SRNCD AMBA RIV COKE10/02/2022","INE503N07023","UTI Mutual Fund","Uti - Regular Savings Fund.","10/02/2022","623","T+0 Pur","28/05/2020","28/05/2020","28/05/2020","50","49393950","987667","9.51322314","Interscheme"]
["5","8.29%URNCD NABARD(SBM-G SA2)24/1/29","INE261F08AY4","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","24/01/2029","3164","T+1 Sal","27/05/2020","27/05/2020","28/05/2020","50","55353727.7","1107311","6.74487192","Market"]
["6","6.85% UNCD PGC LXVII67-15/04/2025","INE752E08643","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","15/04/2025","1783","T+0 Sal","28/05/2020",null,"28/05/2020","100","104322800",null,null,"Market"]
["7","6.85% UNCD PGC LXVII67-15/04/2025","INE752E08643","UTI Mutual Fund","Uti - Short Term Income Fund","15/04/2025","1784","T+1 Sal","27/05/2020",null,"28/05/2020","250","260807000",null,null,"Market"]
["8","CD - SYNDICATE BANK - 01/06/2020.","INE667A16GX5","UTI Mutual Fund","Uti - Liquid Cash Plan","01/06/2020","4","T+0 Sal","28/05/2020","28/05/2020","28/05/2020","1000000000","999644000","99.967825","3.918929","Market"]
["9","0% SRNCD KOTAK MAH PR(3685)23/12/20","INE916DA7PH7","UTI Mutual Fund","Uti - Arbitrage Fund","23/12/2020","210","T+1 Pur","27/05/2020","27/05/2020","28/05/2020","1500","1823388000","1213249","5.56156933","Market"]
["10","7.05% PPD REL IND (SR-M1) 13/09/23","INE002A08625","UTI Mutual Fund","Uti - Short Term Income Fund","13/09/2023","1203","T+0 Sal","28/05/2020","28/05/2020","28/05/2020","250","254064500","1017361","6.46149933","Market"]
["11","7.05% PPD REL IND (SR-M1) 13/09/23","INE002A08625","UTI Mutual Fund","Uti - Floater Fund","13/09/2023","1203","T+0 Sal","28/05/2020","28/05/2020","28/05/2020","350","356199900","1017361","6.46149933","Market"]
["12","6.75% URNCD PFC (OPT-A)-22/05/2023","INE134E08KS7","UTI Mutual Fund","Uti - Short Term Income Fund","22/05/2023","1089","T+0 Sal","28/05/2020","28/05/2020","28/05/2020","200","201046200","1004170","6.58981396","Market"]
["13","6.75% URNCD PFC (OPT-A)-22/05/2023","INE134E08KS7","UTI Mutual Fund","Uti - Regular Savings Fund.","22/05/2023","1090","T+1 Pur","27/05/2020","27/05/2020","28/05/2020","500","501296500","1001779","6.68090815","Market"]
["14","5.05%URBOND INDIANOIL(SR17)25/11/22","INE242A08460","UTI Mutual Fund","Uti - Short Term Income Fund","25/11/2022","911","T+0 Pur","28/05/2020","28/05/2020","28/05/2020","1000","1000000000","999242","5.09496216","Market"]
["15","6.99% SNCD NHAI BOND-SII-28/05/2035","INE906B07IC4","UTI Mutual Fund","Uti - Regular Savings Fund.","28/05/2035","5478","T+0 Pur","28/05/2020","28/05/2020","28/05/2020","250","250000000","1000000","6.98604097","Off Market"]
["16","6.99% SNCD NHAI BOND-SII-28/05/2035","INE906B07IC4","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","28/05/2035","5478","T+0 Pur","28/05/2020","28/05/2020","28/05/2020","250","250000000","1000000","6.98604097","Off Market"]
["17","6.99% SNCD NHAI BOND-SII-28/05/2035","INE906B07IC4","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","28/05/2035","5478","T+0 Pur","28/05/2020","28/05/2020","28/05/2020","500","500000000","1000000","6.98604097","Off Market"]
["18","5.80% URNCD N HSG BANK-15/05/2023","INE557F08FJ5","UTI Mutual Fund","Uti - Arbitrage Fund","15/05/2023","1083","T+1 Sal","27/05/2020","27/05/2020","28/05/2020","250","253196250","1012785","5.32052166","Market"]
["19","5.80% URNCD N HSG BANK-15/05/2023","INE557F08FJ5","UTI Mutual Fund","Uti - Arbitrage Fund","15/05/2023","1083","T+1 Sal","27/05/2020","27/05/2020","28/05/2020","250","253196250","1012785","5.32052166","Market"]
["20","5.80% URNCD N HSG BANK-15/05/2023","INE557F08FJ5","UTI Mutual Fund","Uti - Arbitrage Fund","15/05/2023","1083","T+1 Sal","27/05/2020","27/05/2020","28/05/2020","250","253196250","1012785","5.32052166","Market"]
["21","7.40% UNCD PFC- 08/05/2030","INE134E08KQ1","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","08/05/2030","3632","T+0 Pur","28/05/2020","28/05/2020","28/05/2020","150","146287050","975526","7.75574998","Market"]
["22","7.68% UNCD PFC- 15/07/30","INE134E08KR9","UTI Mutual Fund","Uti - Bond Fund","15/07/2030","3701","T+1 Sal","27/05/2020","27/05/2020","28/05/2020","150","148537350","997836","7.70869821","Market"]
["23","7.68% UNCD PFC- 15/07/30","INE134E08KR9","UTI Mutual Fund","Uti - Short Term Income Fund","15/07/2030","3701","T+1 Pur","27/05/2020","27/05/2020","28/05/2020","300","298094100","997836","7.70869821","Market"]
["24","7.68% UNCD PFC- 15/07/30","INE134E08KR9","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","15/07/2030","3701","T+1 Pur","27/05/2020","27/05/2020","28/05/2020","100","99364700","997836","7.70869821","Market"]
["25","7.68% UNCD PFC- 15/07/30","INE134E08KR9","UTI Mutual Fund","Uti - Bond Fund","15/07/2030","3701","T+1 Pur","27/05/2020","27/05/2020","28/05/2020","50","49682350","997836","7.70869821","Market"]
["26","7.68% UNCD PFC- 15/07/30","INE134E08KR9","UTI Mutual Fund","Uti - Dynamic Bond Fund.","15/07/2030","3701","T+1 Pur","27/05/2020","27/05/2020","28/05/2020","50","49682350","997836","7.70869821","Market"]