{"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":20,"n_cols":16,"rows_kept":20,"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.10% PP SRNCD S T F C I-23/05/2019","INE721A07ND7","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","23/05/2019","448","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","5000","250000000","50000","8.14400038","Off Market"]
["2","10.45%FPNC REL FIN3B-F23-18/07/2018","INE958G07BP1","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","18/07/2018","140","T+1 Sal","28/02/2018","28/02/2018","01/03/2018","500","500000000","987146.8249","14.06999898","Market"]
["3","8.25% URNCD  TATA SONS 24/03/2021","INE895D08899","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","24/03/2021","1119","T+0 Sal","01/03/2018","01/03/2018","01/03/2018","100","99785700","995111","8.43545053","Market"]
["4","8.10% PP SRNCD S T F C I-23/05/2019","INE721A07ND7","UTI Mutual Fund","Uti - Balanced Fund","23/05/2019","448","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","5000","250000000","50000","8.14400038","Off Market"]
["5","CP -CAPITAL FIRST HOME FIN-27/03/18","INE965U14173","UTI Mutual Fund","Uti - Money Market Fund","27/03/2018","26","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","500000000","497466500","99.5127","7.149419","Off Market"]
["6","CP - DEWAN HOUSING FIN - 31/05/18","INE202B14LW6","UTI Mutual Fund","Uti - Money Market Fund","31/05/2018","91","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","2000000000","1962328000","98.1367","7.700194","Off Market"]
["7","CP - PIRAMAL ENTERP-30/05/18","INE140A14SD5","UTI Mutual Fund","Uti - Money Market Fund","30/05/2018","90","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","2500000000","2454310000","98.1923","7.550084","Off Market"]
["8","CP - SHRIRAM TRANS FIN CO-30/05/18","INE721A14AX8","UTI Mutual Fund","Uti - Money Market Fund","30/05/2018","90","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","9500000000","9313971000","98.0631","8.100362","Off Market"]
["9","CP - RELIANCE COMM FINANCE-27/03/18","INE126D14251","UTI Mutual Fund","Uti - Liquid Cash Plan","27/03/2018","26","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","1500000000","1491501000","99.4551","7.999127","Off Market"]
["10","CP - RELIANCE COMM FINANCE-28/03/18","INE126D14319","UTI Mutual Fund","Uti - Liquid Cash Plan","28/03/2018","27","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","1500000000","1491175500","99.4334","7.999518","Off Market"]
["11","CP -CHAMBAL FERT & CHEM-28/03/18","INE085A14DE2","UTI Mutual Fund","Uti - Liquid Cash Plan","28/03/2018","27","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","2000000000","1990502000","99.5426","6.450698","Off Market"]
["12","CP - DEWAN HOUSING FIN - 31/05/18","INE202B14LW6","UTI Mutual Fund","Uti - Liquid Cash Plan","31/05/2018","91","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","3000000000","2943492000","98.1367","7.700194","Off Market"]
["13","CP - CAPITAL FIRST - 23/03/18","INE688I14FI2","UTI Mutual Fund","Uti - Liquid Cash Plan","23/03/2018","22","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","1500000000","1493455500","99.5834","7.271197","Off Market"]
["14","CP - N A B A R D - 30/05/2018","INE261F14CO9","UTI Mutual Fund","Uti - Liquid Cash Plan","30/05/2018","90","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","5000000000","4911115000","98.2417","7.340066","Off Market"]
["15","CP - INDIA INFOLINE FIN - 28/05/18","INE866I14XD8","UTI Mutual Fund","Uti - Liquid Cash Plan","28/05/2018","88","T+0 Pur","01/03/2018","01/03/2018","01/03/2018","7000000000","6865103000","98.1002","8.12478","Off Market"]
["16","CP - INDIABULLS HSG FINANC-04/06/18","INE148I14UE5","UTI Mutual Fund","Uti - Short Term Income Fund","04/06/2018","95","T+0 Sal","01/03/2018","01/03/2018","01/03/2018","500000000","490214000","98.0543","7.705028","Market"]
["17","CP - INDIABULLS HSG FINANC-04/06/18","INE148I14UE5","UTI Mutual Fund","Uti - Treasury Advantage Fund","04/06/2018","95","T+0 Sal","01/03/2018","01/03/2018","01/03/2018","500000000","490214000","98.0543","7.705028","Market"]
["18","7.78% HDFC SRNCD R4-24/03/2020","INE001A07QF2","UTI Mutual Fund","Uti - Floating Rate Fund Stp","24/03/2020","755","T+1 Sal","28/02/2018","28/02/2018","01/03/2018","50","495966500","9911230","8.24446069","Market"]
["19","7.60%HDFC SRNCD-R14-26/06/2020","INE001A07QP1","UTI Mutual Fund","Uti - Floating Rate Fund Stp","26/06/2020","849","T+1 Pur","28/02/2018","28/02/2018","01/03/2018","50","492650000","9853980","8.27517111","Market"]