{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Summary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"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","formulas":"cached_only"}

{"sheet":"Summary","index":0,"n_rows":58,"n_cols":24,"rows_kept":58,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Sr no","Name of the Security","ISIN (If applicable, otherwise keep it blank)","Type of security #","Most Conservative Rating  of Security at the time of transaction (If applicable, otherwise keep it blank)","Name of Rating Agency","Transaction Type (Buy/Sell)","Listed status of security ##","Mutual Fund Name","Scheme Name","Type of Scheme $","Final Maturity Date $$","Residual days to Final Maturity","Deemed Maturity date @","Trade Date $$","Settlement Date $$","Quantity traded","Face Value Per Unit (In INR)","Price at which Traded @@ (In INR)","Total Interest Accrued for the transaction, if any (In INR)","Value of the Trade U={(Q*R*S/1 00)+T)","Yield at which Traded*","Yield at which Valued* *","Type of trade* **"]
[1,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Liquidity Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",223090253.87,1,99.974472,0,223033304,0.0466,0.0466,"Other- TREPS"]
[2,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Liquid ETF","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",78991.91,1,99.974478,0,78971.75,0.0466,0.0466,"Other- TREPS"]
[3,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Overnight Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",3472792.16,1,99.974472,0,3471905.64,0.0466,0.0466,"Other- TREPS"]
[4,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Flexi Cap Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",2958688.4,1,99.974472,0,2957933.11,0.0466,0.0466,"Other- TREPS"]
[5,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP India T.I.G.E.R Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",264702.75,1,99.974473,0,264635.18,0.0466,0.0466,"Other- TREPS"]
[6,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Equity Opportunities Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",1174846.23,1,99.974472,0,1174546.32,0.0466,0.0466,"Other- TREPS"]
[7,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Mid Cap Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",46251957.23,1,99.974472,0,46240150.16,0.0466,0.0466,"Other- TREPS"]
[8,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP TOP 100 EQUITY","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",196820.72,1,99.974474,0,196770.48,0.0466,0.0466,"Other- TREPS"]
[9,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Tax Saver Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",2703977.74,1,99.974472,0,2703287.48,0.0466,0.0466,"Other- TREPS"]
[10,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP World Agriculture Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",1286.04,1,99.97434,0,1285.71,0.0466,0.0466,"Other- TREPS"]
[11,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Small Cap Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",29600651.04,1,99.974472,0,29593094.67,0.0466,0.0466,"Other- TREPS"]
[12,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Equity & Bond Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",4191176.44,1,99.974472,0,4190106.53,0.0466,0.0466,"Other- TREPS"]
[13,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Government Securities Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",5491612.87,1,99.974472,0,5490210.99,0.0466,0.0466,"Other- TREPS"]
[14,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Savings Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",8854187.7,1,99.974472,0,8851927.43,0.0466,0.0466,"Other- TREPS"]
[15,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Regular Savings Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",2828.44,1,99.974544,0,2827.72,0.0466,0.0466,"Other- TREPS"]
[16,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Natural Resources & New Energy Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",63743.34,1,99.974476,0,63727.07,0.0466,0.0466,"Other- TREPS"]
[17,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Bond Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",10312.44,1,99.974497,0,10309.81,0.0466,0.0466,"Other- TREPS"]
[18,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Short Term Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",156429.71,1,99.974474,0,156389.78,0.0466,0.0466,"Other- TREPS"]
[19,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Strategic Bond Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",70648.16,1,99.974479,0,70630.13,0.0466,0.0466,"Other- TREPS"]
[20,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Ultra Short Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",316683373.99,1,99.974472,0,316602531.92,0.0466,0.0466,"Other- TREPS"]
[21,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Credit Risk Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",25165.66,1,99.974489,0,25159.24,0.0466,0.0466,"Other- TREPS"]
[22,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP World Gold Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",19965.94,1,99.974456,0,19960.84,0.0466,0.0466,"Other- TREPS"]
[23,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP World Energy Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",1757.88,1,99.974401,0,1757.43,0.0466,0.0466,"Other- TREPS"]
[24,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP World Mining Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",2843.22,1,99.974325,0,2842.49,0.0466,0.0466,"Other- TREPS"]
[25,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Focus Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",454777.19,1,99.974473,0,454661.1,0.0466,0.0466,"Other- TREPS"]
[26,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP US Flexible Equity Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",128597.72,1,99.974471,0,128564.89,0.0466,0.0466,"Other- TREPS"]
[27,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Banking and PSU Debt Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",114278.14,1,99.974475,0,114248.97,0.0466,0.0466,"Other- TREPS"]
[28,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Dynamic Asset Allocation Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",5134004.2,1,99.974472,0,5132693.61,0.0466,0.0466,"Other- TREPS"]
[29,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Global Allocation Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",29933.13,1,99.974476,0,29925.49,0.0466,0.0466,"Other- TREPS"]
[30,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP 10Y G-Sec Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",728.39,1,99.973915,0,728.2,0.0466,0.0466,"Other- TREPS"]
[31,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Low Duration Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",12823061.37,1,99.974472,0,12819787.93,0.0466,0.0466,"Other- TREPS"]
[32,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Equity Savings Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",32320.39,1,99.974474,0,32312.14,0.0466,0.0466,"Other- TREPS"]
[33,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Equal Nifty 50 Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",51019.93,1,99.974481,0,51006.91,0.0466,0.0466,"Other- TREPS"]
[34,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Arbitrage Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",8113585.64,1,99.974472,0,8111514.43,0.0466,0.0466,"Other- TREPS"]
[35,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Corporate Bond Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",13004.37,1,99.97447,0,13001.05,0.0466,0.0466,"Other- TREPS"]
[36,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Healthcare Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",148054.72,1,99.974469,0,148016.92,0.0466,0.0466,"Other- TREPS"]
[37,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Nifty 50 Index Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",170900.88,1,99.974471,0,170857.25,0.0466,0.0466,"Other- TREPS"]
[38,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Nifty Next 50 Index Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",112357.56,1,99.974474,0,112328.88,0.0466,0.0466,"Other- TREPS"]
[39,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Quant Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",499713.05,1,99.974471,0,499585.48,0.0466,0.0466,"Other- TREPS"]
[40,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Value Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",2970977.97,1,99.974472,0,2970219.55,0.0466,0.0466,"Other- TREPS"]
[41,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Floater Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",63012.97,1,99.974466,0,62996.88,0.0466,0.0466,"Other- TREPS"]
[42,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP FMP Series 264 - 60M - 17D","Close Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",81.25,1,99.975385,0,81.23,0.0466,0.0466,"Other- TREPS"]
[43,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Nifty 50 Equal Weight ETF","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",281.06,1,99.975094,0,280.99,0.0466,0.0466,"Other- TREPS"]
[44,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Nifty 50 ETF","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",8.33,1,100,0,8.33,0.0466,0.0466,"Other- TREPS"]
[45,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Nifty Midcap 150 Quality 50 ETF","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",885.44,1,99.974024,0,885.21,0.0466,0.0466,"Other- TREPS"]
[46,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Global Innovation Fund of Fund","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",31087718.88,1,99.974472,0,31079782.89,0.0466,0.0466,"Other- TREPS"]
[47,"TREPS 20-Jun-2022","IDIA00275004","TREPS","","Not Applicable","Buy","Not Applicable","DSP Mutual Fund","DSP Nifty SDL Plus G-Sec Jun 2028","Open Ended","2022-06-20",2,"2022-06-20","2022-06-18","2022-06-18",2681683.57,1,99.974472,0,2680999,0.0466,0.0466,"Other- TREPS"]
[]
[]
["#  Nomenclature of \"Type of security\" shall be strictly mentioned as Commercial Paper, Certificate of Deposit, Corporate Bond, Debentures, Securitised Debt, Zero Coupon Bonds, AT1 Bond, Government Bonds (Include State Development Loans, special purpose bonds such as Uday Bonds, Fertilizer Bonds, etc), Tresury Bills, Cash Management Bills, Bill Rediscounting Scheme, Corporate Bond Repo, Reverse Repo, TREPS, Others (pls specify)    "]
["## Nomenclature of \"Listed status of security\" shall be strictly mentioned as Listed, Unlisted, Awaiting Listing, Not Applicable"]
["$ Nomenclature of \"Type of scheme\" shall be strictly mentioned as Close ended, Open ended, Interval"]
["@ Deemed Maturity date may be \"put or/and call date\" or \"coupon reset date\" etc. whichever is used for pricing"]
["@@ Please mention Clean price per 100 Rupee atleast upto 6 decimal places (In case of Zero Coupon Bonds please mention dirty price per 100 Rupee)"]
["* Please mention traded yield in percentage term atleast upto 4 decimal"]
["**  Yield at which said security valued on previous day in NAV in case of security already held by any scheme of the Mutual Fund and yield at which said security valued at the end of day in NAV in case of first time buy. Please mention traded yield in percentage term atleast upto 4 decimal"]
["*** Inter Scheme Transfer/Primary/Secondary through market/ Secondary through off-market/Buyback/Other(Specify)"]