{"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":28,"n_cols":16,"rows_kept":28,"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 - ICICI BANK -17/07/2020","INE090A162V7","UTI Mutual Fund","Uti - Liquid Cash Plan","17/07/2020","35","T+0 Pur","12/06/2020","12/06/2020","12/06/2020","250000000","249205500","99.6935","3.300484","Interscheme"]
["2","CD - ICICI BANK -17/07/2020","INE090A162V7","UTI Mutual Fund","Uti - Money Market Fund","17/07/2020","35","T+0 Sal","12/06/2020",null,"12/06/2020","250000000","249205500",null,null,"Interscheme"]
["3","8.7% HDFC SRNCD U-8-15/12/20","INE001A07RN4","UTI Mutual Fund","Uti - Corporate Bond Fund","15/12/2020","186","T+0 Sal","12/06/2020",null,"12/06/2020","250","254775330.12",null,null,"Market"]
["4","CP - RELIANCE JIO INFOCOMM-20/07/20","INE110L14OB8","UTI Mutual Fund","Uti - Liquid Cash Plan","20/07/2020","38","T+0 Pur","12/06/2020","12/06/2020","12/06/2020","1000000000","996034000","99.6138","3.824581","Interscheme"]
["5","CP - RELIANCE JIO INFOCOMM-20/07/20","INE110L14OB8","UTI Mutual Fund","Uti - Money Market Fund","20/07/2020","38","T+0 Sal","12/06/2020",null,"12/06/2020","1000000000","996034000",null,null,"Interscheme"]
["6","CP-TATA CAP HOUSING FIN-05/08/20","INE033L14KK1","UTI Mutual Fund","Uti - Liquid Cash Plan","05/08/2020","54","T+0 Pur","12/06/2020","12/06/2020","12/06/2020","500000000","496839500","99.3795","4.299936","Interscheme"]
["7","CP-TATA CAP HOUSING FIN-05/08/20","INE033L14KK1","UTI Mutual Fund","Uti - Money Market Fund","05/08/2020","54","T+0 Sal","12/06/2020",null,"12/06/2020","500000000","496839500",null,null,"Interscheme"]
["8","CP - NATIONAL FERTILIZERS -03/09/20","INE870D14CZ8","UTI Mutual Fund","Uti - Liquid Cash Plan","03/09/2020","83","T+0 Pur","12/06/2020","12/06/2020","12/06/2020","250000000","247256250","98.9156","4.879819","Interscheme"]
["9","CP - NATIONAL FERTILIZERS -03/09/20","INE870D14CZ8","UTI Mutual Fund","Uti - Money Market Fund","03/09/2020","83","T+0 Sal","12/06/2020","12/06/2020","12/06/2020","250000000","247256250","98.9156","4.879819","Interscheme"]
["10","6.60% URNCD REC (SR-198-A) 21/03/22","INE020B08CV5","UTI Mutual Fund","Uti - Corporate Bond Fund","21/03/2022","648","T+1 Pur","11/06/2020","11/06/2020","12/06/2020","250","251874750","1007417","6.15497484","Market"]
["11","7.75% URNCD PFC (OPT-B)-11/06/2030","INE134E08KV1","UTI Mutual Fund","Uti - Dynamic Bond Fund.","11/06/2030","3651","T+0 Sal","12/06/2020","12/06/2020","12/06/2020","250","251460000","1004587","7.67820474","Market"]
["12","7.75% URNCD PFC (OPT-B)-11/06/2030","INE134E08KV1","UTI Mutual Fund","Uti - Bond Fund","11/06/2030","3651","T+0 Sal","12/06/2020","12/06/2020","12/06/2020","200","201579200","1004587","7.67820474","Market"]
["13","7.75% URNCD PFC (OPT-B)-11/06/2030","INE134E08KV1","UTI Mutual Fund","Uti - Short Term Income Fund","11/06/2030","3651","T+0 Sal","12/06/2020","12/06/2020","12/06/2020","50","50394800","1004587","7.67820474","Market"]
["14","7.75% URNCD PFC (OPT-B)-11/06/2030","INE134E08KV1","UTI Mutual Fund","Uti - Short Term Income Fund","11/06/2030","3652","T+1 Sal","11/06/2020","11/06/2020","12/06/2020","250","250000000","1000000","7.74568986","Market"]
["15","7.75% URNCD PFC (OPT-B)-11/06/2030","INE134E08KV1","UTI Mutual Fund","Uti - Short Term Income Fund","11/06/2030","3652","T+1 Pur","11/06/2020","11/06/2020","12/06/2020","300","300000000","1000000","7.74568986","Market"]
["16","7.75% URNCD PFC (OPT-B)-11/06/2030","INE134E08KV1","UTI Mutual Fund","Uti - Floater Fund","11/06/2030","3652","T+1 Pur","11/06/2020","11/06/2020","12/06/2020","700","700000000","1000000","7.74568986","Market"]
["17","6.72% URNCD PFC (OPT-A)-09/06/2023","INE134E08KW9","UTI Mutual Fund","Uti - Ultra Short Term Fund","09/06/2023","1092","T+0 Sal","12/06/2020",null,"12/06/2020","70","70314370",null,null,"Interscheme"]
["18","6.72% URNCD PFC (OPT-A)-09/06/2023","INE134E08KW9","UTI Mutual Fund","Uti - Treasury Advantage Fund","09/06/2023","1093","T+1 Pur","11/06/2020","11/06/2020","12/06/2020","250","250000000","1000100","6.71635178","Market"]
["19","6.72% URNCD PFC (OPT-A)-09/06/2023","INE134E08KW9","UTI Mutual Fund","Uti - Credit Risk Fund.","09/06/2023","1093","T+1 Pur","11/06/2020","11/06/2020","12/06/2020","50","50010000","1000100","6.71635178","Market"]
["20","6.72% URNCD PFC (OPT-A)-09/06/2023","INE134E08KW9","UTI Mutual Fund","Uti - Medium Term Fund","09/06/2023","1093","T+1 Pur","11/06/2020","11/06/2020","12/06/2020","100","100020000","1000100","6.71635178","Market"]
["21","6.72% URNCD PFC (OPT-A)-09/06/2023","INE134E08KW9","UTI Mutual Fund","Uti - Credit Risk Fund.","09/06/2023","1092","T+0 Pur","12/06/2020","12/06/2020","12/06/2020","70","70314370","1003425","6.58996694","Interscheme"]
["22","CP - MUTHOOT FINANCE- 11/09/2020","INE414G14OV2","UTI Mutual Fund","Uti - Liquid Cash Plan","11/09/2020","91","T+0 Pur","12/06/2020","12/06/2020","12/06/2020","2500000000","2465757500","98.6451","5.570345","Off Market"]
["23","6.75% URNCD PFC (OPT-A)-22/05/2023","INE134E08KS7","UTI Mutual Fund","Uti - Short Term Income Fund","22/05/2023","1074","T+0 Sal","12/06/2020","12/06/2020","12/06/2020","250","251271250","1005075","6.54997766","Market"]
["24","CP - HIND ZINC -26/03/2021","INE267A14424","UTI Mutual Fund","Uti - Money Market Fund","26/03/2021","287","T+0 Pur","12/06/2020","12/06/2020","12/06/2020","1500000000","1444897500","96.3389","4.849944","Market"]
["25","7.79% URNCD REC (SR-198-B)-21/05/30","INE020B08CW3","UTI Mutual Fund","Uti - Short Term Income Fund","21/05/2030","3631","T+1 Sal","11/06/2020","11/06/2020","12/06/2020","200","201606800","1008020","7.66521151","Market"]
["26","7.79% URNCD REC (SR-198-B)-21/05/30","INE020B08CW3","UTI Mutual Fund","Uti - Bond Fund","21/05/2030","3631","T+1 Sal","11/06/2020",null,"12/06/2020","50","50401700",null,null,"Market"]
["27","CP - RELIANCE JIO INFOCOMM-10/09/20","INE110L14OP8","UTI Mutual Fund","Uti - Liquid Cash Plan","10/09/2020","90","T+0 Pur","12/06/2020","12/06/2020","12/06/2020","7000000000","6931974000","99.07","3.849849","Off Market"]