{"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":42,"n_cols":16,"rows_kept":42,"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.36% URNCD PFC-SR-140B-04/09/2020","INE134E08HV7","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","04/09/2020","1032","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","50","51445050","1028970","7.16605554","Market"]
["2","8.73% SRNCD PGC-(SR21-K)-11/10/2020","INE752E07BY5","UTI Mutual Fund","Uti - Banking & Psu Debt Fund","11/10/2020","1069","T+0 Sal","07/11/2017",null,"07/11/2017","20","26119750",null,null,"Interscheme"]
["3","8.73% SRNCD PGC-(SR21-K)-11/10/2020","INE752E07BY5","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","11/10/2020","1069","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","20","26119750","1305270","6.99102491","Interscheme"]
["4","8.36% URNCD R E C L -22/09/2020","INE020B08955","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","22/09/2020","1050","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","40","41312360","1033686","7.02360517","Market"]
["5","11.25%URNCD INDIA INFO FIN 05/09/20","INE866I08196","UTI Mutual Fund","Uti - C.R.T.S. 1981","05/09/2020","1033","T+0 Sal","07/11/2017",null,"07/11/2017","13","13734643",null,null,"Interscheme"]
["6","11.25%URNCD INDIA INFO FIN 05/09/20","INE866I08196","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","05/09/2020","1033","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","13","13734643","1055951","8.8868535","Interscheme"]
["7","7.09%URNC BOND SIDBI-II- 19/06/2020","INE556F08IW4","UTI Mutual Fund","Uti - Short Term Income Fund","19/11/2018","377","T+0 Sal","07/11/2017","07/11/2017","07/11/2017","32","32091616","1002758","6.94473249","Interscheme"]
["8","7.09%URNC BOND SIDBI-II- 19/06/2020","INE556F08IW4","UTI Mutual Fund","Uti - Short Term Income Fund","19/11/2018","377","T+0 Sal","07/11/2017","07/11/2017","07/11/2017","10","10028630","1002758","6.94473249","Interscheme"]
["9","7.09%URNC BOND SIDBI-II- 19/06/2020","INE556F08IW4","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","19/11/2018","377","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","10","10028630","1002758","6.94473249","Interscheme"]
["10","7.09%URNC BOND SIDBI-II- 19/06/2020","INE556F08IW4","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","19/11/2018","377","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","32","32091616","1002758","6.94473249","Interscheme"]
["11","8.35% SRNCD LHF(273-I) 23/10/2020","INE115A07IE0","UTI Mutual Fund","Uti - Short Term Income Fund","23/10/2020","1081","T+0 Sal","07/11/2017","07/11/2017","07/11/2017","40","40917400","1022386","7.46668474","Interscheme"]
["12","8.35% SRNCD LHF(273-I) 23/10/2020","INE115A07IE0","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","23/10/2020","1081","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","40","40917400","1022386","7.46668474","Interscheme"]
["13","CP - BHARTI TELECOM - 31/01/18","INE403D14015","UTI Mutual Fund","Uti - Liquid Cash Plan","31/01/2018","85","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","5000000000","4923750000","98.4927","6.64981","Market"]
["14","CP - FUTURE RETAIL -05/02/18","INE752P14498","UTI Mutual Fund","Uti - Money Market Fund","05/02/2018","90","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","500000000","491218500","98.2629","7.250002","Off Market"]
["15","CP - INDIA INFOLINE FIN - 02/02/18","INE866I14VS0","UTI Mutual Fund","Uti - Liquid Cash Plan","02/02/2018","87","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","3000000000","2951112000","98.3888","6.950214","Off Market"]
["16","CP - RELIANCE INDS - 30/11/17","INE002A14649","UTI Mutual Fund","Uti - Liquid Cash Plan","30/11/2017","23","T+0 Sal","07/11/2017",null,"07/11/2017","4000000000","3984696000",null,null,"Interscheme"]
["17","CP - RELIANCE INDS - 30/11/17","INE002A14649","UTI Mutual Fund","Uti - Money Market Fund","30/11/2017","23","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","4000000000","3984696000","99.634","6.094579","Interscheme"]
["18","CD - SOUTH INDIAN BANK-18/12/2017","INE683A16JT4","UTI Mutual Fund","Uti - Money Market Fund","18/12/2017","42","T+1 Pur","06/11/2017","06/11/2017","07/11/2017","50000000","49660850","99.3217","6.079763","Market"]
["19","CP - DALMIA CEMENT(BHARAT)-05/02/18","INE755K14641","UTI Mutual Fund","Uti - Money Market Fund","05/02/2018","90","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","500000000","492172500","98.4516","6.450052","Off Market"]
["20","CD - INDUSIND BANK -05/02/18","INE095A16WO5","UTI Mutual Fund","Uti - Liquid Cash Plan","05/02/2018","90","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","1000000000","984966000","98.5119","6.195071","Market"]
["21","CD - INDUSIND BANK -05/02/18","INE095A16WO5","UTI Mutual Fund","Uti - Liquid Cash Plan","05/02/2018","90","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","2000000000","1969932000","98.5119","6.195071","Market"]
["22","7.60% SRNCD PIRAMAL ENT-15/03/2019","INE140A07393","UTI Mutual Fund","Uti - Income Opportunities Fund","15/03/2019","493","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","1100","1099282800","999347","7.67981414","Market"]
["23","7.60% SRNCD PIRAMAL ENT-15/03/2019","INE140A07393","UTI Mutual Fund","Uti - Medium Term Fund","15/03/2019","493","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","50","49967400","999347","7.67981414","Market"]
["24","6.98% URNCD NABARD(SR18G)30/09/2020","INE261F08907","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","30/09/2020","1058","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","50","49969800","999478","6.98671358","Market"]
["25","6.78% URNCD REL IND(SR-B)16/09/2020","INE002A08484","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","16/09/2020","1044","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","50","49727300","994127","6.99667873","Market"]
["26","0% SRNCD EDEL HSG FIN-02/06/2020","INE530L07285","UTI Mutual Fund","Uti - C.R.T.S. 1981","02/06/2020","938","T+0 Sal","07/11/2017",null,"07/11/2017","17","17568990",null,null,"Interscheme"]
["27","0% SRNCD EDEL HSG FIN-02/06/2020","INE530L07285","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","02/06/2020","938","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","17","17568990","1033215","8.5750033","Interscheme"]
["28","CP - BAJAJ FINANCE-29/12/17","INE296A14MY4","UTI Mutual Fund","Uti - Money Market Fund","29/12/2017","53","T+1 Sal","06/11/2017","06/11/2017","07/11/2017","50000000","49541250","99.0825","6.49978","Market"]
["29","CP - HDFC LTD - 18/12/17","INE001A14RG4","UTI Mutual Fund","Uti - Money Market Fund","18/12/2017","42","T+1 Sal","06/11/2017","06/11/2017","07/11/2017","50000000","49659750","99.3195","6.099618","Market"]
["30","10.50% URNCD U B I(SRX)-27/09/2027","INE695A08048","UTI Mutual Fund","Uti - Unit Linked Insurance Plan","27/09/2027","3612","T+1 Sal","06/11/2017",null,"07/11/2017","250","254059500",null,null,"Market"]
["31","10.50% URNCD U B I(SRX)-27/09/2027","INE695A08048","UTI Mutual Fund","Uti - Retirement Benefit Pension Fund","27/09/2027","3612","T+1 Sal","06/11/2017",null,"07/11/2017","250","254059500",null,null,"Market"]
["32","0% SRNCD JM FIN CR SL(II)15/09/2020","INE651J07499","UTI Mutual Fund","Uti - Smart Woman Savings Plan","15/09/2020","1043","T+0 Sal","07/11/2017",null,"07/11/2017","6","6062376",null,null,"Interscheme"]
["33","0% SRNCD JM FIN CR SL(II)15/09/2020","INE651J07499","UTI Mutual Fund","Uti - Ftif Series Xxvii - Plan X (1118 Days)","15/09/2020","1043","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","6","6062376","1010104","8.97165183","Interscheme"]
["34","8.7%SRNCD TOYOTA FIN SER-24/11/2017","INE692Q07035","UTI Mutual Fund","Uti - Liquid Cash Plan","24/11/2017","17","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","2000","2001342000","1000671","6.82804246","Market"]
["35","CD - IDFC BANK - 17/11/17","INE092T16BN8","UTI Mutual Fund","Uti - Liquid Cash Plan","17/11/2017","10","T+0 Sal","07/11/2017",null,"07/11/2017","4000000000","3993360000",null,null,"Interscheme"]
["36","CD - IDFC BANK - 17/11/17","INE092T16BN8","UTI Mutual Fund","Uti - Money Market Fund","17/11/2017","10","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","4000000000","3993360000","99.8506","6.068066","Interscheme"]
["37","CD - KOTAK MAH BANK-10/11/17","INE237A165A8","UTI Mutual Fund","Uti - Liquid Cash Plan","10/11/2017","3","T+0 Sal","07/11/2017",null,"07/11/2017","750000000","749628750",null,null,"Market"]
["38","CD - KOTAK MAH BANK-10/11/17","INE237A165A8","UTI Mutual Fund","Uti - Liquid Cash Plan","10/11/2017","3","T+0 Sal","07/11/2017",null,"07/11/2017","500000000","499752500",null,null,"Market"]
["39","CD - KOTAK MAH BANK-10/11/17","INE237A165A8","UTI Mutual Fund","Uti - Liquid Cash Plan","10/11/2017","3","T+0 Sal","07/11/2017",null,"07/11/2017","1000000000","999505000",null,null,"Market"]
["40","CP - CANFIN HOME-06/02/18","INE477A14825","UTI Mutual Fund","Uti - Liquid Cash Plan","06/02/2018","91","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","3000000000","2952882000","98.4464","6.400144","Off Market"]
["41","CP - ONGC MANGALORE REF-05/02/18","INE053T14AB2","UTI Mutual Fund","Uti - Liquid Cash Plan","05/02/2018","90","T+0 Pur","07/11/2017","07/11/2017","07/11/2017","500000000","492387500","98.4942","6.269884","Off Market"]