{"text_format":"1","workbook":"xlsx","n_sheets":71,"sheets":["Tables","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61 ","62 ","63 ","64 ","65 ","66 ","67 ","68 ","69 ","70"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":71,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Tables","index":0,"n_rows":78,"n_cols":1,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["Tables"]
["Table 1: SEBI Registered Market Intermediaries/Institutions"]
["Table 2: Company-Wise Capital Raised through Public and Rights Issues (Equity) during October-2016"]
["Table 3: Open Offers under SEBI Takeover Code closed during October-2016"]
["Table 4: Substantial Acquisition of Shares and Takeovers"]
["Table 5: Capital Raised from the Primary Market through though Public and Rights Issues "]
["Table 6: Issues Listed on SME Platform"]
["Table 7: Industry-wise Classification of Capital Raised through Public and Rights Issues "]
["Table 8: Sector-wise and Region-wise Distribution of Capital Mobilised through Public and Rights Issues "]
["Table 9: Size-wise Classification of Capital Raised through Public and Rights Issues "]
["Table 10: Capital Raised by Listed Companies from the Primary Market through QIPs"]
["Table 11: Preferential Allotments Listed at BSE and NSE"]
["Table 12: Private Placement of Corporate Debt Reported to BSE and NSE"]
["Table 13: Trading in the Corporate Debt Market"]
["Table 14: Ratings Assigned for Long-term Corporate Debt Securities (Maturity ≥ 1 year)"]
["Table 15: Review of Accepted Ratings of Corporate Debt Securities (Maturity ≥ 1 year)"]
["Table 16: Distribution of Turnover on Cash Segments of Exchanges (` crore)"]
["Table 17: Trends in Cash Segment of BSE "]
["Table 18: Trends in Cash Segment of NSE "]
["Table 19: City-wise Distribution of Turnover on Cash Segments of BSE and NSE"]
["Table 20: Category-wise Share of Turnover in Cash Segment of BSE"]
["Table 21: Category-wise Share of Turnover in Cash Segment of NSE"]
["Table 22: Component Stocks: S&P BSE Sensex during October-2016"]
["Table 23: Component Stocks: Nifty 50 Index during October-2016"]
["Table 24: Advances/Declines in Cash Segment of BSE and NSE"]
["Table 25: Trading Frequency in Cash Segment of BSE and NSE"]
["Table 26: Daily Volatility of Major Indices  (percent)"]
["Table 27: Percentage Share of Top ‘N’ Securities/Members in Turnover of Cash Segment  (percent)"]
["Table 28: Settlement Statistics for Cash Segment of BSE "]
["Table 29: Settlement Statistics for Cash Segment of NSE "]
["Table 30: Trends in Equity Derivatives Segment at BSE (Turnover in Notional Value) "]
["Table 31: Trends in Equity Derivatives Segment at NSE "]
["Table 32: Settlement Statistics in Equity Derivatives Segment at BSE and NSE (` crore)"]
["Table 33: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of BSE"]
["Table 34: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of NSE"]
["Table 35: Instrument-wise Turnover in Index Derivatives at BSE"]
["Table 36: Instrument-wise Turnover in Index Derivatives at NSE"]
["Table 37: Trends in Currency Derivatives Segment at NSE"]
["Table 38: Trends in Currency Derivatives Segment at MSEI"]
["Table 39: Trends in Currency Derivatives Segment at BSE"]
["Table 40: Settlement Statistics of Currency Derivatives Segment (` crore)"]
["Table 41: Instrument-wise Turnover in Currency Derivatives of NSE"]
["Table 42: Instrument-wise Turnover in Currency Derivative Segment of MSEI"]
["Table 43: Instrument-wise Turnover in Currency Derivative Segment of BSE"]
["Table 44: Maturity-wise Turnover in Currency Derivative Segment of NSE  (` crore)"]
["Table 45: Maturity-wise Turnover in Currency Derivative Segment of MSEI (` crore)"]
["Table 46: Maturity-wise Turnover in Currency Derivative Segment of BSE (` crore)"]
["Table 47: Trading Statistics of Interest Rate Futures at BSE, NSE and MSEI"]
["Table 48: Settlement Statistics in Interest Rate Futures at BSE, NSE and MSEI (` crore)"]
["Table 49: Trends in Foreign Portfolio Investment"]
["Table 50: Notional Value of Offshore Derivative Instruments (ODIs) Vs Assets Under Custody (AUC) of FPIs/Deemed FPIs (` crore)"]
["Table 51: Assets under the Custody of Custodians"]
["Table 52: Trends in Resource Mobilization by Mutual Funds (` crore)"]
["Table 53: Type-wise Resource Mobilisation by Mutual Funds: Open-ended and Close-ended (` crore)"]
["Table 54: Scheme-wise Resource Mobilisation and Assets under Management by Mutual Funds (` crore)"]
["Table 55: Number of Schemes and Folios by Investment Objective           "]
["Table 56: Trends in Transactions on Stock Exchanges by Mutual Funds (` crore)"]
["Table 57: Asset Under Management by Portfolio Manager"]
["Table 58: Progress Report of NSDL & CDSl as on end of October-2016 (Listed Companies)"]
["Table 59: Progress of Dematerialisation at NSDL and CDSL (Listed and Unlisted Companies)"]
["Table 60: Depository Statistics for October-2016"]
["Table 61: Commoditiy Exchanges - Number of Permitted Commodities for trading"]
["Table 62: Trends in MCXCOMDEX of MCX and Dhaanya of NCDEX"]
["Table 63: Trends in Commodity Futures at MCX "]
["Table 64: Trends in Commodity Futures at NCDEX "]
["Table 65: Trends in Commodity Futures at NMCE "]
["Table 66: Category-wise Share in Turnover at MCX and NCDEX (percent) "]
["Table 67: Category-wise Percentage Share of Turnover & Open Interest at MCX"]
["Table 68: Category-wise  Percentage Share of Turnover & Open Interest at NCDEX"]
["Table 69: Category-wise Percentage Share of Turnover & Open Interest at NMCE"]
["Table 70: Macro Economic Indicators"]
[]
["N.B.: "]
["1. Na = Not Applicable"]
["2. NA: Not Available"]
["3. 1 crore = 10 million = 100 lakh."]
["4. The total provided in the Annexure and Statistical Tables June not always match with the sum total of the break-ups due to decimal differences. "]
["5. The data for the current month is provisional."]

{"sheet":"1","index":1,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Table 1: SEBI Registered Market Intermediaries/Institutions"]
["Market Intermediaries ","2015-16","2016-17$"]
["Stock Exchanges (Cash Market)",5,5]
["Stock Exchanges (Equity Derivatives Market)",3,3]
["Stock Exchanges (Currency Derivatives Market)",3,3]
["Stock Exchanges (Commodity Derivatives Market)",12,12]
["Brokers (Cash Segment)*",3199,3192]
["Corporate Brokers (Cash Segment)*",2780,2777]
["Brokers (Equity Derivatives Market) ",2760,2697]
["Brokers (Currency Derivatives Market)",1985,1985]
["Brokers (Debt Segment)",6,6]
["Brokers (Commodity Derivatives Market)",295,1083]
["Sub-brokers (Cash Segment)*",34942,31863]
["Foreign Portfolio Investors (FPIs)",4311,6079]
["Deemed FPIs",4406,2680]
["Custodians",19,19]
["Depositories",2,2]
["Depository Participants-NSDL                                 ",274,276]
["Depository Participants-CDSL",584,583]
["Merchant Bankers",189,188]
["Bankers to an Issue",62,63]
["Underwriters",2,2]
["Debenture Trustees",31,32]
["Credit Rating Agencies",7,7]
["KYC Registration Agency (KRA)",5,5]
["Registrars to an Issue & Share Transfer Agents",71,73]
["Venture Capital Funds",200,199]
["Foreign Venture Capital Investors",215,214]
["Alternative Investment Funds",209,258]
["Portfolio Managers",204,214]
["Mutual Funds",48,46]
["Investment Advisors",427,529]
["Research Analysts",261,312]
["Infrastructure Investment Trusts (InVIT)",0,3]
["Collective Investment Management Company",1,1]
["Approved Intermediaries (Stock Lending Schemes) ",2,2]
["STP (Centralised Hub)",1,1]
["STP Service Providers",2,2]
["Notes: "]
["1. *Stock brokers/sub-brokers pertaining to active stock exchanges."]
["$ indicates as on October 31, 2016.  "]
["Source: SEBI, NSDL."]

{"sheet":"2","index":2,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Table 2: Company-Wise Capital Raised through Public and Rights Issues (Equity) during October-2016"]
["S.No.","Name of the Issuer/\nCompany","Date of\n Opening","Type of \nIssue","Type of \nInstrument","No. of Shares\nIssued ","Face Value\n (`)","Premium Value    \n (`)","Issue Price (`)","Size of Issue \n (`crore)"]
[1,"Endurance Technologies Limited","October 05, 2016","IPO +OFS","Equity",24613024,10,462,472,1161.73]
[2,"PNB Housing Finance Limited","October 25, 2016","IPO","Equity",38719309,10,765,775,3000]
[3,"Varun Beverages Limited","October 26, 2016","IPO +OFS","Equity",25000000,10,435,445,1112.5]
[4,"Agro Phos India Limited","October 27, 2016","IPO (SME)","Equity",5880000,10,12,22,12.94]
[]
["Note: 1. All the issues are compiled from the Prospectus’ of Issuer Companies filed with SEBI."]
["Source: SEBI."]

{"sheet":"3","index":3,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,0,6,7],[0,0,0,7],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,6],[1,7,2,7]]}
["Table 3: Open Offers under SEBI Takeover Code closed during October-2016"]
["S.No.","Target Company","Acquirer","Offer Opening \nDate","Offer \nClosing Date","Offer Size ",null,"Offer\n Price \n(`) per share"]
[null,null,null,null,null,"No. of \nShares","Percent of Equity \nCapital"]
[1,"MAX VENTURES AND INDUSTRIES LTD.","SIVA ENTERPRISES PVT. LTD. AND P V T VENTURES PVT. LTD.","2016-09-28","2016-10-13",18473049,34.6,31.5]
[2,"SAHYOG CREDITS LTD.","ATHENA MULTITRADE PVT. LTD.","2016-09-30","2016-10-17",918000,30,25]
[]
["Source: SEBI."]

{"sheet":"4","index":4,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,0,15,5],[16,0,16,8],[0,0,0,8],[1,0,4,0],[1,1,1,8],[2,1,2,6],[2,7,2,8],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,4,7],[3,8,4,8]]}
["Table 4: Substantial Acquisition of Shares and Takeovers"]
["Year/Month","Open Offers"]
[null,"Objectives",null,null,null,null,null,"Total"]
[null,"Change in Control \nof Management",null,"Consolidation of\n Holdings",null,"Substantial \nAcquisition",null,"No. of offers","Amount (` crore)"]
[null,"No. of offers","Amount (` crore)","No. of offers","Amount (` crore)","No. of offers","Amount (` crore)"]
["2015-16",61,6868.4162999999999,6,2847.3417000000004,6,2050.2707,73,11766.028699999999]
["2016-17$",25,4827.3969000000006,3,75.6297,2,359.19040000000001,30,5262.2170000000015]
["2016-04-01",5,81.083799999999997,0,0,0,0,5,81.083799999999997]
["2016-05-01",5,46.285499999999999,0,0,0,0,5,46.285499999999999]
["2016-06-01",3,31.936299999999999,0,0,0,0,3,31.936299999999999]
["2016-07-01",5,2553.5500000000002,0,0,1,14.56,6,2568.11]
["2016-08-01",4,2111.9506000000001,1,13.0123,1,344.63040000000001,6,2469.5933]
["2016-09-01",2,1.8748,1,58.190100000000001,0,0,3,60.064900000000002]
["2016-10-01",1,0.71589999999999998,1,4.4272999999999998,0,0,2,5.1432000000000002]
[]
["$ indicates as on October 31, 2016.  "]
["Source: SEBI."]

{"sheet":"5","index":5,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,17],[1,0,4,0],[1,1,3,2],[1,3,1,6],[1,7,1,10],[1,11,1,18],[2,3,3,4],[2,5,3,6],[2,7,3,8],[2,9,3,10],[16,0,16,14],[17,0,17,5],[2,11,2,14],[2,15,3,16],[2,17,3,18],[3,11,3,12],[3,13,3,14],[15,0,15,18]]}
["Table 5: Capital Raised from the Primary Market through though Public and Rights Issues "]
["Year/ Month","Total",null," Category-wise",null,null,null,"Issue-type",null,null,null,"Instrument-wise"]
[null,null,null,"Public ",null,"Rights",null,"      Listed",null,"IPOs",null,"Equities",null,null,null,"   CCPS/FCDs*",null,"Debt"]
[null,null,null,null,null,null,null,null,null,null,null,"At Par",null,"At Premium"]
[null,"No. of issues","Amount (` crore)","No. of issues","Amount (` crore)","No. of issues","Amount (` crore)","No. of issues","Amount (` crore)","No. of issues","Amount (` crore)","No. of issues","Amount (` crore)","No. of issues","Amount (` crore)","No. of issues","Amount (` crore)","No. of issues","Amount (` crore)"]
["2015-16",108,58166.740000000005,95,48927.960000000006,13,9238.7800000000007,34,43351.179999999993,74,14815.079999999998,13,671.99999999999989,74,23381.859999999997,0,0,21,34111.919999999998]
["2016-17$",74,47115.22,71,46496.79,3,618.42999999999995,13,24511.090000000004,61,22604.260000000002,1,2.6,63,23220.089999999997,0,0,10,23892.53]
["2016-04-01",5,3571.9,5,3571.9,0,0,0,0,5,3571.9,1,2.6,4,3569.3,0,0,0,0]
["2016-05-01",8,1746.1100000000001,7,1671.1100000000001,1,75,4,974.51,4,771.73,0,0,5,846.73,0,0,3,899.38]
["2016-06-01",11,2518.44,11,2518.44,0,0,1,1000,10,1518.44,0,0,10,1518.44,0,0,1,1000]
["2016-07-01",4,2159.0799999999995,4,2159.0799999999995,0,0,1,500,3,1659.08,0,0,3,1659.08,0,0,1,500]
["2016-08-01",10,16636.38,9,16136.380000000001,1,500,3,14500,7,2136.38,0,0,8,2636.38,0,0,2,14000]
["2016-09-01",32,15196.14,31,15152.71,1,43.43,4,7536.58,28,7659.56,0,0,29,7702.99,0,0,3,7493.15]
["2016-10-01",4,5287.17,4,5287.17,0,0,0,0,4,5287.17,0,0,4,5287.17,0,0,0,0]
[]
["Notes: 1. The total provides category-wise total of any of the three sub-categories viz. public plus rights or issuer-type(listed plus IPOs) or instrument-wise(equities plus CCPS/FCDs plus debt). 2. Amount for public debt issue for last two months is provisional and may get updated 3. All the Issues are compiled from the Prospectus’ of Issuer Companies filed with SEBI. 4. * CCPS: Compulsory Convertible Preference Shares, FCDs: Fully Convertible Debentures."]
["5. Equity public issues also includes issues listed on SME platform. "]
["$ indicates as on October 31, 2016.  "]
["Source: SEBI."]
[]
[null,null,null,10,1518.44,null,null,null,null,null,null,null,null,null,null,null,null,2,664.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,164.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,234.51]

{"sheet":"6","index":6,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[16,0,16,3],[1,0,3,0],[1,1,2,2],[15,0,15,2]]}
["Table 6: Issues Listed on SME Platform"]
["Year/ Month","Total"]
[]
[null,"No. of issue","Amount               (` crore)"]
["2015-16",50,379.48999999999995]
["2016-17$",41,631.48000000000013]
["2016-04-18",2,33.5]
["2016-05-18",3,21.19]
["2016-06-18",8,79.56]
["2016-07-01",1,11.22]
["2016-08-01",5,269.43000000000006]
["2016-09-01",21,203.64000000000001]
["2016-10-01",1,12.94]
[]
["$ indicates as on October 31, 2016.  "]
["Source: SEBI"]

{"sheet":"7","index":7,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,3,1,4],[1,1,1,2],[0,0,0,4]]}
["Table 7: Industry-wise Classification of Capital Raised through Public and Rights Issues "]
["Industry","2016-17$",null,"2016-10-01"]
[null,"No. of issues","Amount (`crore)","No. of issues","Amount (`crore)"]
["Airlines",2,3059.19,0,0,null,null,null,"Airlines, Automobile, Banking and Finance, Cement & Construction, Chemical, Consumer Services, Electrical Equipment/ Production, Engineering, Electronics, Entertainment, Financial Services, Food Processing, Healthcare and pharma, Hotels, Information Technology , Misc., Roads & Highways, Telecommunication, Textile, Power, Oil & Natural Gas"]
["Automobile",1,1161.73,1,1161.73]
["Banking and Finance",10,26803.3,1,3000]
["Cement & Construction",8,540.92999999999995,0,0]
["Chemical",5,462.07,1,12.94]
["Consumer Services",2,406,0,0]
["Electrical Equipment/ Production",0,0,0,0]
["Engineering",4,901.56000000000006,0,0]
["Electronics",2,510.11,0,0]
["Entertainment",1,2.52,0,0]
["Financial Services",1,1000,0,0]
["Food Processing",2,1863.04,1,1112.5]
["Healthcare and pharma",3,25.240000000000002,0,0]
["Hotels",0,0,0,0]
["Information Technology ",1,1236.3699999999999,0,0]
["Misc.",17,1087.9699999999998,0,0]
["Roads & Highways",2,659.15,0,0]
["Telecommunication",1,11.22,0,0]
["Textile",9,285.57,0,0]
["Power",1,3.58,0,0]
["Oil & Natural Gas",1,1038.8800000000001,0,0]
["Insurance",1,6056.79,0,0]
["Total",74,47115.22,4,5287.1699999999992]
[]
["$ indicates as on October 31, 2016.  "]
["Source: SEBI."]

{"sheet":"8","index":8,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,13,2,14],[0,0,0,14],[1,0,3,0],[1,1,2,2],[1,3,1,6],[1,7,1,14],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12]]}
["Table 8: Sector-wise and Region-wise Distribution of Capital Mobilised through Public and Rights Issues "]
["Year/\nMonth"," Total",null,"Sector-wise",null,null,null,"Region-wise"]
[null,null,null," Private",null," Public",null," Northern",null," Eastern",null,"Western",null,"Southern"]
[null,"No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)"]
["2015-16",108,58166.240000000005,87,24053.860000000004,21,34112.380000000005,22,32379.82,4,583.89,60,18779.75,22,6425.35]
["2016-17$",74,47115.22,64,23222.689999999995,10,23892.53,11,4647.33,3,309.69999999999982,48,37259.5,12,4898.6900000000005]
["2016-04-14",5,3571.9,5,3571.9,0,0,0,0,0,0,3,512.71,2,3059.19]
["2016-05-14",8,1746.1100000000001,5,846.73,3,899.38,0,0,0,0,4,771.73,4,974.38]
["2016-06-14",11,2518.44,10,1518.44,1,1000,2,13.87,0,0,7,2100.9899999999998,2,403.58]
["2016-07-01",4,2159.08,3,1659.08,1,500,0,0,0,0,4,2159.0799999999995,0,0]
["2016-08-01",10,16636.38,8,2636.38,2,14000,0,0,0,0,9,16397.260000000002,1,239.12]
["2016-09-01",32,15196.14,29,7702.99,3,7493.15,7,520.96,3,309.69999999999982,19,14143.060000000001,3,222.42]
["2016-10-01",4,5287.17,4,5287.17,0,0,2,4112.5,0,0,2,1174.67,0,0]
[]
["$ indicates as on October 31, 2016.  "]
["Source: SEBI."]

{"sheet":"9","index":9,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,5],[14,0,14,4],[0,0,0,12],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12]]}
["Table 9: Size-wise Classification of Capital Raised through Public and Rights Issues "]
["Year/\nMonth ","Total",null,"  < 5 crore",null,"≥ 5crore - < 10crore",null,"  ≥ 10 crore - < 50 crore",null,"  ≥ 50 crore - < 100 crore",null,"   ≥ 100 crore"]
[null,"No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)","No. of issue","Amount (`crore)"]
["2015-16",108,58166.420000000006,29,80.279999999999987,13,82.45,9,166.23,7,487.07,50,57350.389999999992]
["2016-17$",74,47115.22,16,52.03,14,94.27,14,302.81,1,75,29,46591.11]
["2016-04-14",5,3571.9,1,2.6,0,0,1,30.9,0,0,3,3538.4]
["2016-05-14",8,1746.1100000000001,0,0,3,21.19,0,0,1,75,4,1649.92]
["2016-06-14",11,2518.44,4,11.33,2,13.87,2,54.36,0,0,3,2438.88]
["2016-07-01",4,2159.0799999999995,0,0,0,0,1,11.22,0,0,3,2147.8599999999997]
["2016-08-01",10,16636.38,1,1.86,2,14.55,1,13.9,0,0,6,16606.07]
["2016-09-01",32,15196.14,10,36.24,7,44.66,8,179.49,0,0,7,14935.75]
["2016-10-01",4,5287.1699999999992,0,0,0,0,1,12.94,0,0,3,5274.23]
[]
["$ indicates as on October 31, 2016.  "]
["Source: SEBI."]

{"sheet":"10","index":10,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,5],[15,0,15,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[13,0,13,8]]}
["Table 10: Capital Raised by Listed Companies from the Primary Market through QIPs"]
["Year/           Month","NSE",null,"BSE",null,"Common",null,"Total"]
[null,"No. of issues","Amount (`crore)","No. of issues","Amount (`crore)","No. of issues","Amount (`crore)","No. of issues","Amount (`crore)"]
["2015-16",0,0,7,1494.335,17,13093.4787984,24,14587.813798399999]
["2016-17$",0,0,0,0,12,4318.2492404999994,12,4318.2492404999994]
["2016-04-14",0,0,0,0,0,0,0,0]
["2016-05-14",0,0,0,0,1,261.94,1,261.94]
["2016-06-14",0,0,0,0,1,60.91,1,60.91]
["2016-07-01",0,0,0,0,1,55.68,1,55.68]
["2016-08-01",0,0,0,0,2,229.99924049999998,2,229.99924049999998]
["2016-09-01",0,0,0,0,4,2209.7199999999998,4,2209.7199999999998]
["2016-10-16",null,null,null,null,3,1500,3,1500]
[]
["Notes: 1. The above data includes both \"no. of issues\" and \"Amount\" raised on conversion of convertible securities issued on QIP basis. "]
["$ indicates as on October 31, 2016.  "]
["Source: BSE and NSE."]

{"sheet":"11","index":11,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,8],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[13,0,13,5]]}
["Table 11: Preferential Allotments Listed at BSE and NSE"]
["Year/ Month","NSE",null,"BSE",null,"Common",null,"Total"]
[null,"No. of  issues","Amount (`crore)","No. of  issues","Amount (`crore)","No. of  issues","Amount (`crore)","No. of  issues","Amount (`crore)"]
["2015-16",144,1956.7326999999998,22,983.09149850000006,189,47573.450295359005,355,50512.874493859003]
["2016-17$",132,5688.8955327839994,50,8837.2916999999998,127,22332.873211244001,256,24433.226545565998]
["2016-04-14",43,3868,31,3733.2,26,3671.67,47,3829.0361015379999]
["2016-05-14",33,343.44,2,39.231699999999996,29,4835.8162300000004,64,5218.4879300000002]
["2016-06-14",15,134.87,1,77.06,16,1797.41,32,2009.3400000000001]
["2016-07-01",10,427.75819338399998,1,5.8,16,1036.0088109899998,27,1469.5670043739997]
["2016-08-01",4,16.673000000000002,0,0,13,333.07625077899996,17,349.74925077899996]
["2016-09-01",12,41.154339399999991,0,0,12,5676.8919194750006,24,5718.0462588750006]
["2016-10-16",15,857,15,4982,15,4982,45,5839]
[]
["$ indicates as on October 31, 2016.  "]
["Source: BSE and NSE."]

{"sheet":"12","index":12,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,8],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[13,0,13,5]]}
["Table 12: Private Placement of Corporate Debt Reported to BSE and NSE"]
["Year/ Month","NSE",null,"BSE",null,"Both NSE and BSE",null,"Total"]
[null,"No. of Issues","Amount (`crore)","No. of Issues","Amount (`crore)","No. of Issues","Amount (`crore)","No. of Issues","Amount (`crore)"]
["2015-16",1198,206676.33000000002,1619,152281.16,158,99116,2975,458073.48000000004]
["2016-17$",664,143244.70000000001,1370,149384.14000000001,110,88114.2,2144,380743.04]
["2016-04-14",112,15601.8,189,20166.96,13,5310,314,41078.76]
["2016-05-14",89,24470.45,167,21548.68,16,13782,272,59801.13]
["2016-06-14",102,13101.95,180,9521.42,25,10952.5,307,33575.870000000003]
["2016-07-01",98,20213.5,189,8491.0499999999993,16,8069.7,303,36774.25]
["2016-08-01",85,23284.9,268,31265.4,22,16615,375,71165.3]
["2016-09-01",97,18688.95,191,33333.22,10,15930,298,67952.17]
["2016-10-01",81,27883.15,186,25057.41,8,17455,275,70395.56]
[]
["$ indicates as on October 31, 2016.  "]
["Source: SEBI"]

{"sheet":"13","index":13,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,4],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6]]}
["Table 13: Trading in the Corporate Debt Market"]
["Year/ Month","BSE",null,"NSE",null,"MSEI"]
[null,"No. of Trades","Traded Value \n(` crore)","No. of Trades","Traded Value \n(` crore)","No. of Trades","Traded Value \n(` crore)"]
["2015-16",16900,207652.31000000003,53223,814755.59999999986,0,0]
["2016-17$",13274,136125.84999999998,36218,621670.06000000006,0,0]
["2016-04-14",1541,14841.5,4617,66679.350000000006,0,0]
["2016-05-14",1839,17334.830000000002,4620,65225.29,0,0]
["2016-06-14",2040,18540.810000000001,5280,78407.83,0,0]
["2016-07-01",1857,16186.82,5453,92598.97,0,0]
["2016-08-01",2029,19400,5402,90212.79,0,0]
["2016-09-01",2282,25687.23,6079,117780.65,0,0]
["2016-10-01",1686,24134.66,4767,110765.18,0,0]
[]
["$ indicates as on October 31, 2016.  "]
["Source: SEBI",null,null,null," "]

{"sheet":"14","index":14,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,5],[1,0,3,0],[1,1,1,8],[1,9,2,10],[1,11,2,12],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8]]}
["Table 14: Ratings Assigned for Long-term Corporate Debt Securities (Maturity ≥ 1 year)"]
["      Grade\nPeriod","Investment Grade",null,null,null,null,null,null,null,"Non-Investment Grade",null,"Total"]
[null,"Highest Safety (AAA)",null,"High Safety (AA)",null,"Adequate Safety (A)",null,"Moderate Safety (BBB)"]
[null,"No. of issue","Amount              (` crore)","No. of issue","Amount (` crore)","No. of issue","Amount (` crore)","No. of issue","Amount (` crore)","No. of issue","Amount (` crore)","No. of issue","Amount (` crore)"]
["2015-16",178,1031139.63,309,193073.61,214,40889.379999999997,151,6179.6000000000013,100,8886.18,896,1282233.28]
["2016-17$",147,887940.76,200,147567.59,138,28621.129999999997,107,6254.6600000000008,74,6834.17,666,1075354.07]
["2016-04-14",20,299239.48,18,18407.3,10,1264.6199999999999,7,979.40000000000009,2,31.06,57,319921.86]
["2016-05-14",17,116440,25,9290,25,2750.64,12,377.49,14,2346.31,93,131204.44]
["2016-06-14",10,115571.3,26,10452.5,11,5360.99,10,748.75,4,540,61,132674.29999999999]
["2016-07-01",13,108974.32999999999,40,29746.7,14,2412.77,15,1041.31,11,352.19,93,140662.29999999999]
["2016-08-01",20,95710,27,26583.4,21,6528.91,15,1337.67,10,1389.05,93,131549.03000000003]
["2016-09-01",45,52887.41,42,31060.97,34,5931.5300000000007,36,1379.08,24,1272.56,181,92531.549999999988]
["2016-10-01",22,99118.24,22,22026.720000000001,23,4371.67,12,390.96,9,903,88,126810.59000000001]
[]
["$ indicates as on October 31, 2016.  "]
["Source: Credit Rating Agencies."]

{"sheet":"15","index":15,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,12],[0,0,0,12],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[13,0,13,5]]}
["Table 15: Review of Accepted Ratings of Corporate Debt Securities (Maturity ≥ 1 year)"]
["   Grade \n\nPeriod","Upgraded",null,"Downgraded",null,"Reaffirmed",null,"Rating Watch",null,"Withdrawn/ Suspended",null,"Total"]
[null,"No. of issue","Amount (` crore)","No. of issue","Amount (` crore)","No. of issue","Amount (` crore)","No. of issue","Amount (` crore)","No. of issue","Amount (` crore)","No. of issue","Amount (` crore)"]
["2015-16",347,97274.925999999978,352,411977.06,1747,6634397.8280000007,54,53392.5,450,118351.66,2895,7315574.2240000004]
["2016-17$",247,43285.020000000004,109,72959.17,1779,5525643.4100000001,26,24431.260000000002,341,109950.17,2495,5774794.3200000003]
["2016-04-14",11,5665.4800000000005,6,3304.5,52,818450.29,1,2568,43,4218.92,113,834207.74]
["2016-05-14",18,1770.75,9,10645.3,113,863301.7,0,0,55,18364.55,195,894082.88]
["2016-06-14",23,3224.12,25,24730.07,446,1391433.04,3,4635,30,2101.0500000000002,527,1426122.44]
["2016-07-14",51,13928.04,11,11011.67,201,587632.68000000005,4,300,59,21964.75,326,634837.14,null,"figures should be in indian system"]
["2016-08-01",29,9494.07,9,1541.72,215,191465.22999999998,4,2415,35,1677.75,292,206593.77]
["2016-09-01",103,8643.2000000000007,21,12853.429999999998,695,1648533.66,4,8527.76,67,59075.119999999995,887,1737333.1700000002]
["2016-10-01",12,559.36,28,8872.48,57,24826.81,10,5985.5,52,2548.0299999999997,155,41617.18]
[]
["$ indicates as on October 31, 2016.  "]
["Source: Credit Rating Agencies."]

{"sheet":"16","index":16,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4],[8,0,8,2],[9,0,9,3]]}
["Table 16: Distribution of Turnover on Cash Segments of Exchanges (` crore)"]
["Stock Exchanges","2015-16","2016-17$","2016-10-01"]
["Ahmedabad",0,0,0]
["BSE",740089.20000000007,387466.45999999996,64509.91]
["Calcutta",0,0,0]
["MSEI",205.55162765999995,162.42270519499999,18.324549915000002]
["NSE",4236982.8614564808,2417489.1587980282,385163.04234032892]
[]
["$ indicates as on October 31, 2016.  "]
["Source:  Exchanges."]

{"sheet":"17","index":17,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,5],[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,1,15]]}
["Table 17: Trends in Cash Segment of BSE "]
["Year/      Month","No. of Companies Listed ","No. of Companies Permitted* ","No. of companies traded ","No. of Trading Days","No. of Trades (Lakh)","Traded Quantity (Lakh)","Turnover (` crore)","Average Daily Turnover (` crore)","Average Trade Size (`)","Demat Securities Traded (Lakh)","Demat Turnover (` crore) ","Market  Capitalisation (` crore) ","S&P BSE Sensex "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Low","Close"]
["2015-16",5911,53,2721,247,4116.88,762545.07,740089.20000000007,2996.3125506072879,17976.943704941608,762545.64999999991,740089.02999999991,9475328.3399999999,29094.61,22494.61,25341.86]
["2016-17$",5867,53,2646,143,2359.1000000000004,391331.53999999992,451976.37,3160.6739160839161,19158.847441821028,391331.53999999992,451976.30999999994,11406693.23,29077.279999999999,24523.200000000001,27930.21]
["2016-04-04",5928,53,2637,18,268.33999999999997,41779.019999999997,49174.079999999994,2731.893333333333,18325.288812700306,41779.019999999997,49174.079999999994,9710538.6300000008,26100.54,24523.200000000001,25606.62]
["2016-05-04",5948,53,2714,22,342.82,48319.559999999983,59520.689999999995,2705.485909090909,17362.082142232073,48319.559999999983,59520.689999999995,9928678.1699999999,26837.200000000001,25057.93,26667.96]
["2016-06-04",5962,53,2804,22,359.19,59725.319999999992,60739.950000000012,2760.9068181818188,16910.256410256414,59725.319999999992,60739.94000000001,10285548.67,27105.41,25911.33,26999.72]
["2016-07-04",5985,53,2869,20,348.38,64483.09,68032.53,3401.6264999999999,19528.253631092484,64483.09,68032.509999999995,10863580.76,28240.2,27034.14,28051.86]
["2016-08-04",5816,53,2877,22,367.15000000000009,55895.660000000011,74083.92,3367.4509090909091,20178.107040719045,55895.660000000011,74083.92,11099422.93,28532.25,27627.97,28452.17]
["2016-09-04",5843,53,2853,20,353.86,61292.089999999982,75915.289999999994,3795.7644999999998,21453.481602893797,61292.089999999982,75915.28,11073648.1,29077.279999999999,27716.78,27865.96]
["2016-10-04",5867,53,2646,19,319.36000000000007,59836.799999999996,64509.91,3395.2584210526315,20199.746367735468,59836.799999999996,64509.890000000014,11406693.23,28477.65,27488.3,27930.21]
[]
["Notes: 1. * Excludes Mutual Fund Schemes from Feb 2013. 2. Market capitalisation pertains to the number of companies traded."]
["$ indicates as on October 31, 2016.  "]
["Source: BSE ."]

{"sheet":"18","index":18,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,13,1,15],[2,13,3,13],[2,14,3,14],[2,15,3,15],[0,0,0,15],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8],[15,0,15,5],[1,9,3,9],[1,10,3,10],[1,11,3,11],[1,12,3,12]]}
["Table 18: Trends in Cash Segment of NSE "]
["Year/         Month","No. of Companies Listed ","No. of Companies Permitted ","No. of Companies Traded","No. of Trading Days","No. of Trades (Lakh)","Traded Quantity (Lakh)","Turnover (`crore)","Average Daily Turnover (` crore)","Average Trade Size (`)","Demat Securities Traded (Lakh)","Demat Turnover (` crore) ","Market  Capitalisation (` crore) ","Nifty 50 Index "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High","Low","Close"]
[]
["2015-16",1808,4,1563,247,18517.667959999999,2201771.0470500002,4236982.8614564808,17153.776767030286,22880.758368757797,2201771.0470500002,4236982.8614564808,9310471.2698509991,8844.7999999999993,6825.8,7738.4]
["2016-17$",1836,4,1621,143,11186.93338,1499445.68295,2802652.2011383572,19598.966441526973,25052.90865635205,1499445.68295,2802652.2011383572,11161048.803785,8968.7000000000007,7516.85,8625.7000000000007]
["2016-04-15",1806,4,1561,18,1328.63663,162828.00829999999,309479.53884001204,17193.307713334001,23293.015701366901,162828.00829999999,309479.53884001204,9522589.1532186605,7992,7516.85,7849.8]
["2016-05-16",1811,4,1566,22,1624.97109,193799.89322,387647.62806465605,17620.346730211637,23855.663060729039,193799.89322,387647.62806465605,9740551.1538223401,8213.6,7678.35,8160.1]
["2016-06-16",1822,4,1575,22,1653.03341,233470.38595,383484.39608997398,17431.108913180637,23198.829120457642,233470.38595,383484.39608997398,10100336.483002899,8308.15,7927.05,8287.75]
["2016-07-17",1839,4,1592,20,1582.30738,250653.99541999999,407331.74766616494,20366.587383308248,25742.8962801251,250653.99541999999,407331.74766616494,10675211.06521,8674.7000000000007,8287.5499999999993,8638.5]
["2016-08-17",1831,4,1598,22,1797.8992000000001,227672.46950000001,470625.84592784697,21392.083905811225,26176.431132949332,227672.46950000001,470625.84592784697,10910696.318185899,8819.2000000000007,8544.85,8786.2000000000007]
["2016-09-17",1822,4,1608,20,1699.6908900000001,232057.06427999999,458920.00220937404,22946.000110468703,27000.203678762675,232057.06427999999,458920.00220937404,10866063.126100799,8968.7000000000007,8555.2000000000007,8611.15]
["2016-10-17",1836,4,1621,19,1500.3947800000001,198963.86628000002,385163.04234032892,20271.739070543626,25670.779949016411,198963.86628000002,385163.04234032892,11161048.803785,8806.9500000000007,8506.15,8625.7000000000007]
[]
["Notes: 1. Demat turnover includes turnover of all securities which are available for trading in Demat mode. 2. Market capitalisation pertains to the number of companies traded."]
["$ indicates as on October 31, 2016.  "]
["Source: NSE"]

{"sheet":"19","index":19,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[27,0,27,4],[28,0,29,6],[0,0,0,5],[1,0,1,5],[2,0,3,0],[2,1,3,1],[2,2,2,3],[2,4,2,5]]}
["Table 19: City-wise Distribution of Turnover on Cash Segments of BSE and NSE"]
["          (Percentage share in Turnover)"]
["S.No.","City","BSE",null,"NSE"]
[null,"Stock Exchange/City","2015-16","2016-10-01","2015-16","2016-10-01"]
[1,"Ahmedabad",3.8587013915644426,4.0114065603685036,3.5118161910523376,3.0802571808781698]
[2,"Bengaluru",0.31031166638203433,0.41394681145122991,1.7098824447011833,6.5819251186007843]
[3,"Vadodra",1.175933275866768,1.1796891826507325,0.43247394532861355,0.32421080923342072]
[4,"Bhubneshwar",2.0778127292272752E-2,2.9582745438036979E-2,0,1.8039413267989673E-4]
[5,"Chennai",0.85047722519369184,0.61440012203012218,1.4197463090918696,0.98673291270017938]
[6,"Ernakulum",0.1890069865600604,0.15187438512863416,1.3963053246722501,1.1325637044072114]
[7,"Coimbatore",4.2247887658712298E-2,5.5385065720168027E-2,0.21200466545295174,9.3971037192516746E-2]
[8,"New Delhi",3.326044116288966,3.2784393650542163,9.3892689004115937,7.0126857257808473]
[9,"Guwahati",7.1258351268480694E-2,7.5157086373896759E-2,5.6838621996213512E-3,1.8877202813168317E-3]
[10,"Hyderabad",0.37648355674171502,0.46417331244197524,4.5,3.6264871357617334]
[11,"Indore",0.40324814681796772,0.51522128892812957,0.535589773943696,0.48014384340147409]
[12,"Jaipur",0.73322591212601029,0.82023212673089996,0.49599488102022393,0.50109186731499167]
[13,"Kanpur",0.45988444404262463,0.49616047067104468,0.12888919227160922,0.12148981403992945]
[14,"Kolkata",7.48892400275321,3.6831644650620139,6.6420948476694983,4.7950009254069332]
[15,"Ludhiana",0.1323985683922756,0.13728178390128637,7.7554802103614429E-2,0.15559063980377597]
[16,"Mangalore",2.8069458370201028E-2,2.7196214904483561E-2,2.5117620675294402E-3,3.3000962138543169E-4]
[17,"Mumbai",52.512348297247435,50.162989980817855,59.196100801698861,57.991532672935683]
[18,"Patna",6.8543016758392014E-2,6.0408177733439622E-2,1.3894734850876476E-2,6.2043457005594039E-3]
[19,"Pune",0.41708135925509515,0.45751996693397179,0.18820917863864692,0.15749986828445492]
[20,"Rajkot",2.6092688460931139,2.3428040974623645,1.0059291127892176,1.2494820418598773]
[21,"Others",24.925765363326533,31.02296679019701,9.1800000000000068,11.700732232662077]
[null,"Total",100.00000000000001,100,100.04395072996419,100]
[]
["Notes: "]
["1. The city-wise distribution of turnover is based on the cities uploaded in the UCC database of the Exchange for clientele trades and member's registered office city for proprietary trades."]
[]
["Source: BSE and NSE."]

{"sheet":"20","index":20,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5]]}
["Table 20: Category-wise Share of Turnover in Cash Segment of BSE"]
["Year/Month","Percentage Share in Turnover"]
[null,"Proprietary","FPI","Mutual Funds","Banks","Others"]
["2015-16",18.867020969688966,17.373851032646318,3.2630822945729299,0.17506993372757684,60.32097576936421]
["2016-17$",17.26548029790851,15.08014196495818,4.9799486332069067,0.1068439105499399,62.567585193376459]
["2016-04-01",16.934299882225332,21.813799619724762,3.6557451823426943,2.2939358209162024E-2,57.57321595749805]
["2016-05-01",16.473720265176656,16.753071623970694,5.094725702910333,2.610638014879765E-2,61.652376027793508]
["2016-06-01",17.427860892981368,13.799072879482432,3.9398818091543406,0.16402406792937707,64.669160350452472]
["2016-07-01",16.935392908913585,14.197518621673874,5.1826122368663929,0.16883383879788932,63.515642393748251]
["2016-08-04",18.194253275389322,12.810143238892868,5.7572019727484296,9.1067398592607693E-2,63.147334114376768]
["2016-09-04",17.360294265824407,13.437980371763025,5.6397487074596331,0.13858691338105142,63.423389741571881]
["2016-10-04",18.326340816290369,11.795881593179461,5.0213235370148279,4.4325465857786184E-2,64.812128587657568]
[]
["$ indicates as on October 31, 2016.  "]
["Source: BSE. "]

{"sheet":"21","index":21,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5]]}
["Table 21: Category-wise Share of Turnover in Cash Segment of NSE"]
["Year/Month","Percentage Share in Turnover"]
[null,"Proprietary","FPI","Mutual Funds","Banks","Others"]
["2015-16",20.79,22.21,5.46,0.43,51.12]
["2016-17$",18.095576163285983,20.67644509275177,5.3559772845006179,0.39240777314676667,55.479593686314843]
["2016-04-01",19.051785786465398,22.2426640251999,5.3407586445564901,0.29468448537270198,53.070107058405512]
["2016-05-01",18.6553042331341,23.367207658894099,5.2264514355551004,0.38887111663303398,52.751036672416703]
["2016-06-01",17.8201233586745,20.529195440442301,5.2078717389821101,0.40342114363423198,56.442809461901092]
["2016-07-01",17.846918567578101,18.851795461741801,5.3330985396568602,0.45127511542520699,54.267366106249597]
["2016-08-16",18.068336800179001,20.363324532470799,5.3094362438240799,0.40190206729330602,52.712573770358098]
["2016-09-16",17.4567566808248,19.411056477321601,5.6674456584661703,0.39010689557898498,57.07463428780845]
["2016-10-16",17.725939007044602,17.379156875155299,6.0579098524389803,0.36110100807804602,58.475893257283062]
[]
["$ indicates as on October 31, 2016.  "]
["Source: NSE. "]

{"sheet":"22","index":22,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,1],[0,0,0,9],[33,0,33,9],[34,0,34,9],[35,0,35,9],[36,0,36,9],[37,0,37,9]]}
["Table 22: Component Stocks: S&P BSE Sensex during October-2016"]
["S.No.","Name of Security","Issued Capital     (` crore)","Free Float Market Capitalisation (` crore)","Weightage (Percent)   ","Beta","R2","Daily Volatility (Percent)","Monthly Return (Percent)","Impact Cost (Percent) "]
[1,"HDFC BANK   ",509.13,251414.02547699999,9.850165425204807,0.76,0.54116799999999998,0.95,-1.4154281670205,0.04]
[2,"HDFC        ",316.8,218456.82191,8.5589331382582774,1.06,0.45031199999999999,1.45,-0.87577617458089996,0.05]
[3,"ITC LTD.    ",1211.51,204727.26812299999,8.021022113765456,0.85,7.3197999999999999E-2,2.87,0.1448975367418,0.05]
[4,"INFOSYS LTD ",1148.47,200333.71332000001,7.8488867623977496,0.81,0.251027,1.48,-3.4293420672382,0.04]
[5,"RELIANCE    ",3243.25,173858.44104000001,6.8116104563501514,0.92,0.35330600000000001,1.42,-2.8555586359855001,0.03]
[6,"ICICI BANK  ",1163.8399999999999,161140.62270000001,6.3133382765899819,1.67,0.47578500000000001,2.2200000000000002,9.7899326198969003,0.03]
[7,"TCS LTD.    ",197.04,127396.445998,4.9912731212295487,0.7,0.24055199999999999,1.31,-1.343111404087,0.08]
[8,"LARSEN & TOU",186.47,118376.007553,4.6378608136920132,1.39,0.469754,1.86,3.1432263472217001,0.04]
[9,"TATA MOTORS ",574.91,102979.20431,4.0346285211612445,1.73,0.417402,2.4500000000000002,-0.44880785413739999,0.04]
[10,"AXIS BANK   ",478.1,81542.457737999997,3.1947569208725439,1.25,0.35192000000000001,1.93,-9.9750853557256995,0.03]
[11,"SUN PHARMA. ",240.67,81036.395348000005,3.1749298716555518,0.78,0.19614100000000001,1.62,0.74727346169380005,0.05]
[12,"STATE BANK  ",776.28,80065.281977999999,3.1368825617531724,1.64,0.44386500000000001,2.25,2.8520143597924998,0.02]
[13,"MARUTISUZUK ",151.04,78405.347328000003,3.071847880945259,1.0900000000000001,0.352242,1.68,7.6598773543582999,0.03]
[14,"MAH & MAH   ",310.55,61397.273294999999,2.4054875119430665,0.87,0.274283,1.52,-6.2520004267577001,7.0000000000000007E-2]
[15,"HIND UNI LT ",216.43,60010.754150000001,2.3511649938673478,0.6,0.184809,1.28,-3.1746946300991001,0.08]
[16,"ONGC CORPN  ",4277.75,52093.950836000004,2.0409920743822192,1.04,0.25581399999999999,1.87,12.9528632645111,0.06]
[17,"ASIAN PAINTS",95.92,48479.257756999999,1.8993717939625405,0.6,0.16175600000000001,1.37,-7.4649341708975001,0.06]
[18,"HEROMOTOCO  ",39.94,42872.324736000002,1.6796974234491666,0.94,0.33513199999999999,1.48,-1.7499670508295,0.05]
[19,"BHARTI ARTL ",1998.7,42014.672700000003,1.6460954220658486,0.68,0.14279,1.65,1.4169718197739001,0.1]
[20,"COAL INDIA  ",6316.36,41182.69328,1.6134992496692706,0.66,0.144091,1.59,1.0696016121531,7.0000000000000007E-2]
[21,"DR.REDDY'S  ",82.82,40733.703104,1.5959082362025363,0.73,0.10480399999999999,2.06,6.9562839772252003,0.05]
[22,"BAJAJ AUTO  ",289.37,38535.758700999999,1.5097948384957975,0.87,0.306477,1.44,4.5901523577400002E-2,0.09]
[23,"POWER GRID  ",5231.59,38441.200161000001,1.5060901236947886,0.7,0.21782099999999999,1.36,-0.79387581514030003,0.14000000000000001]
[24,"NTPC LTD    ",8245.4599999999991,37413.797438000001,1.4658374498009781,0.8,0.24373300000000001,1.49,1.8518518518517999,0.08]
[25,"LUPIN LTD.  ",90.25,36280.835175,1.4214490522567633,0.75,0.127441,1.93,2.1845232084553001,0.06]
[26,"WIPRO LTD.  ",486.16,29388.14229,1.1513998176781886,0.56000000000000005,0.179506,1.21,-2.6483827070029999,7.0000000000000007E-2]
[27,"CIPLA LTD.  ",160.84,29229.746711,1.1451940276360024,0.6,0.147698,1.42,-0.4997845756139,7.0000000000000007E-2]
[28,"ADANI PORTS ",414.19,27182.798213999999,1.0649965077320505,1.41,0.25572699999999998,2.5499999999999998,18.8899707887049,7.0000000000000007E-2]
[29,"TATA STEEL  ",971.22,27117.148333000001,1.0624244070436817,1.53,0.32556600000000002,2.4500000000000002,8.0795940170939993,0.03]
[30,"GAIL (I) LTD",1268.48,20277.699036000002,0.79446120624399563,0.98,0.21276700000000001,1.94,15.5059484026199,0.08]
[]
["Notes: 1. Beta & R2 are calculated for the trailing 12 months. Beta measures the  degree to which any portfolio of stocks is affected as compared to the effect on the market as a whole."]
["2. The coefficient of determination (R2) measures the strength of relationship between two variables the return on  a security versus that of the market."]
["3. Volatility is the standard deviation of the daily returns for the trailing 12 months."]
["4. Impact cost is calculated as the difference between actual buy price and ideal buy price, divided by ideal buy price, multiplied by 100. Hence ideal price is calculated as (best buy + best sell)/2."]
["5. The above is calculated for a month for the portfolio size of ` 5 lakh.  It is calculated for the current month."]
["Source: BSE."]

{"sheet":"23","index":23,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,0,60,1],[0,0,0,9],[54,0,54,9],[55,0,55,9],[56,0,56,9],[57,0,57,9],[58,0,58,9],[59,0,59,9]]}
["Table 23: Component Stocks: Nifty 50 Index during October-2016"]
["S.No.","Name of Security","Issued Capital     (` crore)","Free Float Market Capitalisation (` crore)","Weightage (Percent)   ","Beta","R2","Daily Volatility (Percent)","Monthly Return (Percent)","Impact Cost (Percent) "]
[1,"HDFC BANK LTD.",507.6901034,251333.76000000001,7.93,0.78,0.55000000000000004,0.91,-1.54,0.03]
[2,"HOUSING DEVELOPMENT FINANCE CORPORATION LTD.",316.49523599999998,217986.09,6.88,1.07,0.43,1.82,-1.1399999999999999,0.02]
[3,"I T C LTD.",1209.0430722000001,204515.68,6.45,0.94,0.28000000000000003,1.03,0.12,0.03]
[4,"INFOSYS LTD.",1148.4723320000001,200253.84,6.32,0.84,0.26,1.1599999999999999,-3.28,0.02]
[5,"RELIANCE INDUSTRIES LTD.",3242.950378,173858.46,5.48,0.94,0.36,1.35,-3,0.02]
[6,"ICICI BANK LTD.",1163.513312,161175.67999999999,5.08,1.66,0.46,2.76,9.8800000000000008,0.03]
[7,"TATA CONSULTANCY SERVICES LTD.",197.04279410000001,127207.58,4.01,0.73,0.25,0.93,-1.64,0.02]
[8,"LARSEN & TOUBRO LTD.",186.394543,120990.56,3.82,1.41,0.45,1.26,2.94,0.04]
[9,"TATA MOTORS LTD.",577.44072040000003,102901.81,3.25,1.73,0.41,1.97,-0.54,0.03]
[10,"KOTAK MAHINDRA BANK LTD.",917.99888899999996,94807.16,2.99,0.91,0.41,1.1100000000000001,5.49,0.03]
[11,"AXIS BANK LTD.",477.61066260000001,81525.75,2.57,1.26,0.35,2.16,-9.91,0.03]
[12,"SUN PHARMACEUTICAL INDUSTRIES LTD.",240.67539590000001,81022.17,2.56,0.8,0.2,1.02,0.73,0.02]
[13,"STATE BANK OF INDIA",776.27770420000002,79987.649999999994,2.52,1.67,0.44,1.28,2.5299999999999998,0.02]
[14,"MARUTI SUZUKI INDIA LTD.",151.04003,78368.81,2.4700000000000002,1.08,0.35,1.04,7.65,0.01]
[15,"MAHINDRA & MAHINDRA LTD.",310.54619200000002,61348.4,1.94,0.91,0.28000000000000003,1.41,-6.31,0.02]
[16,"HINDUSTAN UNILEVER LTD.",216.42456759999999,59932.18,1.89,0.59,0.17,1.1000000000000001,-3.31,0.02]
[17,"INDUSIND BANK LTD.",596.47165399999994,59161.04,1.87,0.96,0.42,1.07,-0.08,0.03]
[18,"OIL & NATURAL GAS CORPORATION LTD.",4277.7450600000002,51959.199999999997,1.64,1.03,0.25,1.81,12.68,0.02]
[19,"ASIAN PAINTS LTD.",95.919779000000005,48497.279999999999,1.53,0.64,0.17,1.54,-7.32,0.02]
[20,"HCL TECHNOLOGIES LTD.",282.16807879999999,43326.91,1.37,0.7,0.19,1.52,-4.0199999999999996,0.02]
[21,"HERO MOTOCORP LTD.",39.938017600000002,42840.39,1.35,0.95,0.33,1.34,-1.8,0.02]
[22,"BHARTI AIRTEL LTD.",1998.700051,42041.06,1.33,0.69,0.14000000000000001,1.33,1.5,0.03]
[23,"DR. REDDY'S LABORATORIES LTD.",85.348971500000005,41997.7,1.32,0.74,0.11,1.31,7,0.02]
[24,"YES BANK LTD.",421.21654699999999,41605.79,1.31,1.35,0.4,1.31,0.93,0.03]
[25,"COAL INDIA LTD.",6316.3644000000004,41106.9,1.3,0.69,0.15,1.1499999999999999,0.96,0.03]
[26,"ULTRATECH CEMENT LTD.",274.442408,41342.42,1.3,0.94,0.34,1.0900000000000001,2.93,0.02]
[27,"BAJAJ AUTO LTD.",289.36702000000002,38494.15,1.21,0.89,0.31,1.38,0.1,0.03]
[28,"POWER GRID CORPORATION OF INDIA LTD.",5231.5896480000001,38463.17,1.21,0.73,0.23,1.1399999999999999,-0.85,0.03]
[29,"NTPC LTD.",8245.4644000000008,37364.32,1.18,0.84,0.26,0.99,2.06,0.03]
[30,"LUPIN LTD.",90.196214999999995,36288.01,1.1399999999999999,0.77,0.13,1.38,2.15,0.03]
[31,"BHARAT PETROLEUM CORPORATION LTD.",1446.168496,34842.54,1.1000000000000001,0.71,0.13,1.37,9.25,0.02]
[32,"EICHER MOTORS LTD.",27.198083,32007.53,1.01,0.87,0.19,1.48,-3.27,0.03]
[33,"GRASIM INDUSTRIES LTD.",93.348202000000001,31255.08,0.99,0.74,0.25,1.17,0.33,0.04]
[34,"WIPRO LTD.",494.15625720000003,29833.200000000001,0.94,0.56999999999999995,0.19,1.29,-3.04,0.02]
[35,"CIPLA LTD.",160.72209419999999,29300.639999999999,0.92,0.61,0.15,1.27,-0.22,0.03]
[36,"ZEE ENTERTAINMENT ENTERPRISES LTD.",96.044871999999998,28382.84,0.9,1.06,0.27,2.7,-5.18,0.03]
[37,"ADANI PORTS AND SPECIAL ECONOMIC ZONE LTD.",414.19035220000001,27187.25,0.86,1.46,0.26,3.18,18.91,0.04]
[38,"TATA STEEL LTD.",971.21543899999995,27120.51,0.86,1.56,0.33,1.98,8.14,0.03]
[39,"TECH MAHINDRA LTD.",485.82012099999997,27342.73,0.86,0.96,0.26,1.97,4.7300000000000004,0.02]
[40,"AUROBINDO PHARMA LTD.",58.516958600000002,22020.11,0.69,1.18,0.26,1.48,-4.37,0.02]
[41,"GAIL (INDIA) LTD.",1268.4774,20270.650000000001,0.64,1.02,0.23,1.75,15.28,0.03]
[42,"BOSCH LTD.",31.398900000000001,19919.77,0.63,0.86,0.24,1.08,-4.04,0.03]
[43,"HINDALCO INDUSTRIES LTD.",206.5007832,19172.57,0.6,1.96,0.42,1.53,-1.93,0.03]
[44,"AMBUJA CEMENTS LTD.",397.12904579999997,18601.13,0.59,0.95,0.33,1.41,-4.59,0.03]
[45,"BHARTI INFRATEL LTD.",1896.6670690000001,18454.57,0.57999999999999996,0.61,7.0000000000000007E-2,2.0299999999999998,-4.87,0.03]
[46,"TATA MOTORS LTD DVR",101.6953408,17409.810000000001,0.55000000000000004,1.42,0.31,2.2000000000000002,1.57,0.04]
[47,"BANK OF BARODA",460.83191959999999,14704.34,0.46,1.66,0.3,1.75,-7.02,0.04]
[48,"ACC LTD.",187.787173,14250.7,0.45,0.88,0.34,1.27,-5.13,0.02]
[49,"TATA POWER CO. LTD.",270.46293980000002,14152.51,0.45,1.01,0.3,1.7,3.58,0.04]
[50,"BHARAT HEAVY ELECTRICALS LTD.",489.52,12588.01,0.4,1.52,0.28000000000000003,1.39,3.19,0.03]
[51,"IDEA CELLULAR LTD.",3600.9152399999998,9679.26,0.31,0.74,0.08,2.58,-2.91,0.04]
[]
["Notes: 1. Beta & R2 are calculated for the the trailing 12 months. Beta measures the  degree to which any portfolio of stocks is affected as compared to the effect on the market as a whole."]
["2. The coefficient of determination (R2) measures the strength of relationship between two variables the return on  a security versus that of the market."]
["3. Volatility is the standard deviation of the daily returns for the the trailing 12 months."]
["4. Impact cost is calculated as the difference between actual buy price and ideal buy price, divided by ideal buy price, multiplied by 100. Hence ideal price is calculated as (best buy + best sell)/2."]
["5. The above is calculated for a month for the portfolio size of `5 lakh.  It is calculated for the current month."]
["6. As per NSE circular dated February 22, 2016, the equity securities with Differential Voting Rights (DVRs) would be eligible for inclusion in an index subject to fulfilment of the eligibility criteria laid down by NSE."]
["Source: NSE."]

{"sheet":"24","index":24,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,6],[0,0,0,7],[1,0,2,0],[1,1,1,3],[1,4,1,6]]}
["Table 24: Advances/Declines in Cash Segment of BSE and NSE"]
["Year/ Month","BSE",null,null,"NSE"]
[null,"Advances","Declines","Advance / Decline Ratio","Advances","Declines","Advance / Decline Ratio"]
["2015-16",1896,1876,1.0106609808102345,858,698,1.2292263610315186]
["2016-17$",1945,1799,1.0811561978877153,881,649,1.3574730354391371]
["2016-04-01",2290,1074,2.13,1248,336,3.7142857142857144]
["2016-05-01",1682,1688,1,802,777,1.0321750321750323]
["2016-06-01",1714,1712,1,943,644,1.4642857142857142]
["2016-07-01",2524,929,2.72,1341,253,5.3003952569169961]
["2016-08-04",1608,1883,0.85395645246946394,726,883,0.822197055492639]
["2016-09-04",1901,1604,1.1851620947630923,907,709,1.2792665726375176]
["2016-09-04",2370,1198,1.978297161936561,1093,532,2.0545112781954886]
[]
["Note: Advance/Decline is calculated based on the average price methodology.                                                                           ",null,null,null,null,null,null,null,null,null,null,"`"]
["Source: BSE and NSE"]

{"sheet":"25","index":25,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,4,3,4],[2,5,3,5],[2,6,3,6],[13,0,14,6],[0,0,0,6],[1,0,3,0],[1,1,1,3],[1,4,1,6],[2,1,3,1],[2,2,3,2],[2,3,3,3]]}
["Table 25: Trading Frequency in Cash Segment of BSE and NSE"]
["Month"," BSE",null,null,"NSE"]
[null,"No. of Companies Listed ","No. of companies Traded ","Percent of Traded to Listed","No. of Companies Listed","No. of companies Traded ","Percent of Traded to Listed"]
[]
["2015-16",5911,2721,46.032820165792593,1808,1563,86.44911504424779]
["2016-17$",5867,2646,45.099710243736155,1836,1621,88.29]
["2016-04-04",5928,2637,44.483805668016196,1806,1561,86.434108527131784]
["2016-05-04",5948,2714,45.628782784129115,1811,1566,86.471562672556601]
["2016-06-04",5962,2804,47.031197584703122,1822,1575,86.443468715697037]
["2016-07-04",5985,2869,47.936507936507937,1839,1592,86.6]
["2016-08-04",5816,2877,49.466987620357635,1831,1598,87.3]
["2016-09-04",5843,2853,48.827657025500599,1822,1608,88.254665203073543]
["2016-10-04",5867,2646,45.099710243736155,1836,1621,88.29]
["Note: At NSE, number of companies traded also includes the number of companies not available for trading but permitted to trade only in the first week of every month."]
[]
["$ indicates as on October 31, 2016"]
["Source: BSE and NSE"]

{"sheet":"26","index":26,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,2],[13,3,13,5],[0,0,0,6],[11,0,12,6]]}
["Table 26: Daily Volatility of Major Indices  (percent)"]
["Year/        Month","BSE Sensex","BSE 100 ","BSE 500","Nifty 50","Nifty Next 50","Nifty 500"]
["2015-16",1.0799585822738673,1.1001515401944375,1.0986197444749684,1.0803871314325892,1.239095371856884,1.0947107921046826]
["2016-17$",0.79420210518238232,0.78775053637639891,0.75495241227640009,0.78343061963055804,0.86895225927842989,0.76036836299724109]
["2016-04-04",0.99673231660047634,0.94768491172735991,0.8829403645325643,0.96286687233441837,0.69635514578627911,0.87627635165434814]
["2016-05-04",0.95304820089620146,0.88683869830846873,0.80430317513477745,0.87698362598355961,0.77437234842432257,0.78913644721775933]
["2016-06-04",0.81069763039664333,0.75689224503085795,0.69877435996488935,0.76427355408467001,0.62473980095398574,0.69513689327625061]
["2016-07-04",0.61595790938068595,0.58147240192196392,0.55672572479345317,0.57160953160245187,0.56081148182757934,0.54375342788887304]
["2016-08-04",0.66732814131893414,0.68495460384243312,0.65935941536671971,0.66774210619825514,0.84919491451285645,0.65636651151804848]
["2016-09-04",0.792093203236929,0.91023773982861267,0.94809528099602713,0.80396002084736506,1.2565110647632811,0.918619331812211]
["2016-10-04",0.74764880003493572,0.78058458306686085,0.77290707121809521,0.64496727414053301,0.76683675620413128,0.63653136583823866]
["Note: Volatility is calculated as the standard deviation of the natural log of daily returns in indices for the respective period. "]
[]
["$ indicates as on October 31, 2016."]
["Source: BSE and NSE."]

{"sheet":"27","index":27,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,0,23,11],[0,0,0,11],[1,1,1,5],[1,6,1,10],[3,0,3,10],[13,0,13,10]]}
["Table 27: Percentage Share of Top ‘N’ Securities/Members in Turnover of Cash Segment  (percent)"]
["Year/Month","BSE",null,null,null,null,"NSE"]
["Top",5,10,25,50,100,5,10,25,50,100]
["Securities"]
["2015-16",11.1654,17.712700000000002,31.628900000000002,44.091799999999999,58.5321,11.804384377427105,21.011204120149905,37.310379240676866,53.422165177351822,71.738633101457822]
["2016-17$",10.42,16.41,29.67,41.83,55.97,11.256423454613468,19.784405652880196,33.664615085179634,48.823385658921602,67.46830500744349]
["2016-04-14",16.889399999999998,24.8719,39.2804,52.357999999999997,66.100800000000007,13.89261824964346,24.334909079958418,40.599696565046187,57.243974197238721,74.511379225617617]
["2016-05-14",15.6495,22.441800000000001,36.364400000000003,50.4681,65.432100000000005,13.127687380067979,22.065848262225835,38.442884573254169,55.51674371924252,74.635488552742061]
["2016-06-14",12.3444,18.249700000000001,30.746700000000001,44.147199999999998,59.698399999999999,12.949429477745007,21.134666596896491,36.749885923859686,52.237621324128888,69.508033181707873]
["2016-07-14",9.3950999999999993,14.964499999999999,26.944400000000002,40.981900000000003,58.021099999999997,9.8201366582642464,17.542671125940938,33.328188786656668,49.299560985865597,67.745969392965861]
["2016-08-14",9.5266000000000002,14.8348,26.551200000000001,40.553800000000003,58.064799999999998,11.791254443582007,19.386453488915294,34.108904552343269,49.424210097108137,68.96075162659541]
["2016-09-14",11.7949,18.193100000000001,31.179099999999998,43.6905,58.937199999999997,12.19261001727166,19.857143137880517,33.694860196260379,48.879104023170363,67.879963593221063]
["2016-10-14",10.5442,16.082999999999998,27.289100000000001,39.107599999999998,53.6813,10.186384356409887,17.40336183535512,30.303856252489357,44.916007000310223,64.306701717233878]
["Members"]
["2015-16",20.81,31.01,50.08,65.58,79.11,17.693992839783132,29.050916606073518,50.495018023160533,67.827546847261402,81.524361095883179]
["2016-17$",20.09,29.77,49.84,66.599999999999994,80.61,18.024504804185341,28.220685971213005,49.685541708167754,67.305140424287487,81.204745607602078]
["2016-04-14",25.11,34.94,53.67,68.48,81.45,18.093423609092689,29.434330983046586,51.403704736997661,69.180092046794257,82.78272068117694]
["2016-05-14",21.11,31.52,52.55,67.739999999999995,80.930000000000007,17.585772394326309,28.980340305946093,52.220974803144415,69.254703398853934,82.811182985365676]
["2016-06-14",19.5,29.54,50.7,66.42,80,17.639317360536282,28.050558957493227,49.364793198810503,67.047673142382195,81.00885241569803]
["2016-07-14",20.45,30.43,51.13,67.05,80.400000000000006,17.484835148933321,28.193956906955925,48.38175161725934,66.121741129476106,80.392123142872222]
["2016-08-14",23.58,34.130000000000003,53.86,68.239999999999995,81.010000000000005,18.453361511111645,28.751165110585251,50.535272047948141,68.023766458847206,81.722211263089577]
["2016-09-14",21.35,32.56,53.02,67.87,80.98,19.041749503879682,29.671215681348933,50.554462978969447,67.571632750406522,81.172232142381503]
["2016-10-14",26.11,37.61,57.8,71.52,83.16,18.255086820273,28.622404854816658,49.40479400636066,66.901044051598262,80.65124989937857]
["Notes: 1. Data for Top N scrips has been compiled for all markets except Auction market & Retail Debt Market and includes series EQ, BE,BT, BL and IL."]
["$ indicates as on October 31, 2016."]
["Source: BSE and NSE"]

{"sheet":"28","index":28,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,16]]}
["Table 28: Settlement Statistics for Cash Segment of BSE "]
["Year/     Month\n","No. of Trades(Lakh)","Quantity Settled (Lakh)","Delivered Quantity   (Lakh)","Percent of Delivered Quantity to Traded Quantity","Value Settled (` crore)","Delivered Value      (` crore)","Percent  of Delivered Value to Total Turnover","Delivered Quantity in Demat Mode (Lakh)","Percent of Demat Delivered Quantity to Total Delivered Quantity","Delivered Value in Demat Mode     (` crore)","Percent of Demat Delivered Value to Total Delivered Value","Short Delivery (Auctioned quantity) (Lakh)","Percent of Short Delivery to Delivery Quantity","Funds Pay-in (` crore)","Securities Pay-in (` crore)","SettlementGuarantee Fund (`crore)"]
["2015-16",4116.9000800000003,762549,357015.02633999998,46.909585083432255,740089.32000000007,246882.68651468903,33.292621042016435,356843.47964000003,99.945151472161754,246845.14610785298,99.979040614230783,723.51832999999999,0.18911656269156848,100701.55014480001,246882.68651468903,111.11]
["2016-17$",2359.0542,391328,152362.40862,38.956811955365801,451976.37,150730.61724288197,33.311400432405676,152361.57996,99.99,150730.23426751199,99.99,351.52085999999997,0.23183400165576723,57319.057673199997,150730.61724288197,143.46]
["2016-04-14",268.33163000000002,41779,15959.79017,38.200507838866415,49174.079999999994,16155.060022013,32.852795663920915,15959.78917,99.99,16155.059922012999,99.99,33.949950000000001,0.21272179499599245,7425.7024290999998,16155.060022013,111.82]
["2016-05-14",342.81906000000004,48317,19176.249749999999,39.68841142868969,59520.689999999995,20481.185979520997,34.410195815137556,19176.249680000001,99.99,20481.185979520997,99.99,55.417099999999998,0.28898820637383354,9371.4242581000017,20481.185979520997,138.47999999999999]
["2016-06-14",359.20233999999999,59725,21755.071169999999,36.42540170782754,60739.950000000012,19625.828927609,32.31123655453947,21755.069289999999,99.99,19625.809849628997,99.99,50.418900000000001,0.23175701868794188,6685.9112278999992,19625.828927609,139.28]
["2016-07-04",348.36347000000001,64482,23577.35066,36.564236003846034,68032.53,23075.216789691,33.917916605028509,23577.35066,99.99,23075.214084691001,99.99,62.314540000000001,0.26429831281136829,8592.9296122999986,23075.216789691,140.34]
["2016-08-24",367.14438000000013,55896,22263.479510000001,39.830183751967937,74083.92,24394.851863521995,32.928673136521383,22263.479510000001,99.99,24394.851863521995,99.99,46.018799999999999,0.20670084377120795,8229.911825000001,24394.851863521995,141.35]
["2016-09-24",353.84332000000006,61294,24046.377359999999,39.231209188501317,75915.289999999994,26173.843660525996,34.477696996910637,24045.541649999999,99.99,26173.752568136002,99.99,56.811570000000003,0.23626654299134911,10168.9117216,26173.843660525996,142.38]
["2016-10-24",319.35000000000002,59835,25584.09,42.757733767861623,64509.91,20824.63,32.281288254781323,25584.1,99.99,20824.36,99.99,46.59,0.18210529195867747,6844.2665991999993,20824.63,143.46]
["$ indicates as on October 31, 2016."]
["Source: BSE."]

{"sheet":"29","index":29,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,16]]}
["Table 29: Settlement Statistics for Cash Segment of NSE "]
["Year/     Month\n","No. of Trades      (Lakh)","Quantity Settled (Lakh)","Delivered Quantity   (Lakh)","Percent of Delivered Quantity to Traded Quantity","Value Settled (` crore)","Delivered Value      (` crore)","Percent  of Delivered Value to Total Turnover","Delivered Quantity in Demat Mode (Lakh)","Percent of Demat Delivered Quantity to Total Delivered Quantity","Delivered Value in Demat Mode     (` crore)","Percent of Demat Delivered Value to Total Delivered Value","Short Delivery (Auctioned quantity) (Lakh)","Percent of Short Delivery to Delivery Quantity","Funds Pay-in             (` crore)","Securities Pay-in      (` crore)","Settlement Guarantee Fund        (` crore)"]
["2015-16",18484.02751,2177860.8163200002,619359.51697,28.438893446668999,4202927.49713,1252658.4785498241,29.804427495007019,618222.8470200001,100,1251721.9095134821,100,1134.4527600000001,0.18350223798236617,388404.96999999991,1252658.4785498241,325]
["2016-17$",11169.99958,1489422.4274800001,408603.38201999996,27.43367996085091,2790821.8759999997,815326.10366999998,29.214551837990538,407878.80414999998,100,814699.14751599997,100,724.57963544255063,0.18205317111353622,220387.18,815326.10366999998,184]
["2016-04-14",1331.8240499999999,162415.31623999999,46024.10583,28.337294102232637,310677.9191,92505.049600000013,29.77522505235552,45939.742890000001,100,92440,100,84.362939999999995,0.18363825022269295,27707.670000000002,92505.049600000013,165]
["2016-05-14",1613.83707,191969.08036999998,53600.155280000006,27.921243971524689,378102.30930000008,108781.20330000001,28.770309152935919,53508.329429999998,100,108700.68133000001,100,91.826695462416367,0.17161196479240626,32203.53,108781.20330000001,175]
["2016-06-16",1666.0182199999999,228424.25824000002,60196.742939999996,26.353042975301111,391946.4792,115688.10291,29.516301089406493,60084.595979999998,100,115573.78460000001,100,112.14787998013428,0.1866499693489897,29793.919999999998,115688.10291,175]
["2016-07-16",1572.4571100000001,250082.18309999999,64061.93067999999,25.616351347342341,397532.36599999992,115830.89373999998,29.137474994929097,63941.729160000003,100,115739.85338,100,120.20152,0.18798603287568647,30744.560000000001,115830.89373999998,179]
["2016-08-16",1784.17669,229493.02380000008,64239.587200000002,27.991956416062518,463556.28680000006,132390.97871999998,28.559849685982076,64139.420950000014,100,132303.06995,100,100.16625000000001,0.2,31112.54,132390.97871999998,181]
["2016-09-16",1676.15138,222914.43997000001,62399.352719999988,27.992512610846447,448869.33920000005,133430.60428,29.725934170020942,62271.081450000005,100,133320.65844999999,100,128.27126999999999,0.20598850543971076,36697.609999999993,133430.60428,181]
["2016-10-16",1525.5350599999999,204124.12576,58081.507369999999,28.454014023942293,400137.17639999994,116699.27112000003,29.164815968846842,57993.904289999991,100,116620.84683600001,100,87.603080000000006,0.20598850543971076,32127.349999999995,116699.27112000003,184]
["$ indicates as on October 31, 2016."]
["Source: NSE."]

{"sheet":"30","index":30,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,16,2,17],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[1,6,1,9],[1,10,1,13],[14,0,14,5],[1,14,2,15],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,2,5]]}
["Table 30: Trends in Equity Derivatives Segment at BSE (Turnover in Notional Value) "]
["Year/     Month\n","No. of Trading Days","Index Futures",null,"Stock Futures",null,"Index Options",null,null,null,"Stock Options",null,null,null,"Total",null,"Open Interest at the end of month"]
[null,null,null,null,null,null,"Call",null,"Put",null,"Call",null,"Put"]
[null,null,"No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Value      (` crore)"]
["2015-16",247,306712,13097.13898475,51815,1349.6617938950001,58773325,2560540.6446201452,44654651,1825708.151585395,1009439,31904.119019270001,1413452,42408.54289500499,106209394,4475008.2588984603,68,3.47]
["2016-17$",143,28576,2005.5108759999998,2280,153.15051400000002,24429,1254.6041591000001,63916,3214.4509813,0,0,0,0,119201,6627.7165304000009,27,2.25]
["2016-04-14",18,433,22.118752000000001,147,8.3899190000000008,23677,1215.2568951000001,63916,3214.4509813,0,0,0,0,88173,4460.2165474000003,31,1]
["2016-05-14",22,18,0.9286890000000001,252,14.71261675,752,39.347263999999996,0,0,0,0,0,0,1022,54.988569749999996,16,0.83000000000000029]
["2016-06-14",22,0,0,452,26.27754375,0,0,0,0,0,0,0,0,452,26.27754375,24,1.53]
["2016-07-04",20,4220,294.83388124999999,340,23.149666,0,0,0,0,0,0,0,0,4560,317.98354725000002,93,6.5]
["2016-08-05",22,16884,1185.5911337499997,547,39.065507000000004,0,0,0,0,0,0,0,0,17431,1224.6566407500002,274,19.54]
["2016-09-06",20,6243,447.44186124999999,353,26.551077500000002,0,0,0,0,0,0,0,0,6596,473.99293875000001,65,4.7]
["2016-10-08",19,778,54.59655875,189,15.004184,0,0,0,0,0,0,0,0,967,69.600742749999995,27,2.25]
["Note: 1. Notional Turnover = (Strike Price + Premium) * Quantity."]
["$ indicates as on October 31, 2016."]
["Source: BSE."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"31","index":31,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,5],[1,14,2,15],[1,16,2,17],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[0,0,0,12],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,2,5],[1,6,1,9],[1,10,1,13]]}
["Table 31: Trends in Equity Derivatives Segment at NSE (Turnover in Notional Value) "]
["Year/     Month\n","No. of Trading Days","Index Futures",null,"Stock Futures",null,"Index Options",null,null,null,"Stock Options",null,null,null,"Total",null,"Open Interest at the end of month"]
[null,null,null,null,null,null,"Call",null,"Put",null,"Call",null,"Put"]
[null,null,"No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Value   (` crore)"]
["2015-16",247,140538768,4557123.859903275,234243967,7828605.9954773653,837683830,26063790.641186614,785844656,22888139.938789792,65322962,2325029.9772571698,34976212,1163143.86624609,2098610395,64825834.282080315,2908184,154411.44558025501]
["2016-17$",143,40311603,2534242.1391641498,101374559,6202834.6913419506,290539709,19318433.331108179,282487210,18165511.653583542,35291866,2262666.4980292749,17871992,1073433.0558406999,767876939,49557121.36906781,3292646,218378.05131346994]
["2016-04-14",18,6059350,333438.89236177498,13129520,647602.95520974998,35993137,2110570.1159714302,35052795,1981457.036232,4254268,219370.03745174999,2120664,102832.839436375,96609734,5395271.8766630804,3269898,177395.56010823502]
["2016-05-14",22,7166531,401893.29537494999,15783401,775821.50401192496,43517012,2579790.81273545,39031787,2225290.3021398,5217771,267630.71437090001,2643846,125701.505622875,113360348,6376128.1342559,3644283,203570.18538832004]
["2016-06-16",22,6831756,400891.80393227498,14803058,780911.61759955005,43300739,2600662.8965534698,43603082,2529191.77184567,5039649,272394.41226032499,2621949,132788.03780525,116200233,6716840.5399965504,2805348,174526.33999795499]
["2016-07-16",20,4701956,317459.96899405,13905533,927572.16377502505,36001320,2488335.5411453499,36310446,2425591.0373988999,5266066,366414.79765012499,2653491,172354.20316524999,98838812,6697727.7121286998,3137238,206124.87331212513]
["2016-08-16",22,5681464,389296.72032174998,15504379,1062475.6366644299,43106822,3049387.1467698999,41804522,2862904.61946045,5389929,385725.98752137501,2595808,173992.8556745,114082924,7923782.9664123999,4109871,250912.10317122494]
["2016-09-16",20,5343280,377094.923308175,15006450,1058271.13295992,44905456,3319603.45002313,46706356,3331599.35811587,5296722,391916.12479989999,2758762,192295.432240375,120017026,8670780.4214473795,3369385,222743.62593677492]
["2016-10-16",19,4527266,314166.53487117501,13242218,950179.68112135003,43715223,3170083.3679094501,39978222,2809477.5283908499,4827461,359214.42397489998,2477472,173468.181896075,108767862,7776589.7181638004,3292646,218378.05131346994]
["Note: 1. Notional Turnover = (Strike Price + Premium) * Quantity."]
["$ indicates as on October 31, 2016."]
["Source: NSE."]

{"sheet":"32","index":32,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,5],[2,11,3,11],[2,12,3,12],[0,0,0,12],[1,0,3,0],[1,1,1,6],[1,7,1,12],[2,1,2,2],[2,3,2,4],[2,5,3,5],[2,6,3,6],[2,7,2,8],[2,9,2,10]]}
["Table 32: Settlement Statistics in Equity Derivatives Segment at BSE and NSE (` crore)"]
["Year/     Month\n","BSE",null,null,null,null,null,"NSE"]
[null,"Index/Stock Futures",null,"Index/Stock Options",null," Total","Settlement Gurantee Fund","Index/Stock Futures",null,"Index/Stock Options",null," Total","Settlement Gurantee Fund"]
[null,"MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement",null,null,"MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement"]
["2015-16",451.34,11.12,6382.05,10.09,6854.7299999999987,15.31,85583.800000000017,1420.7300000000005,15922.300000000001,2802.22,105729.05,798]
["2016-17$",12.29,0.97,33.380000000000003,0.01,46.65,16.059999999999999,40516.03,1498.9799999999998,8643.24,1444.83,52103.08,972]
["2016-04-14",0.85,0.13,32.43,0.01,33.42,15.4,4522.37,175.84,1375.71,147.38999999999999,6221.31,806]
["2016-05-14",0.56000000000000005,7.0000000000000007E-2,0.95,0,1.58,15.52,5412.16,186.57,1283.3800000000001,145.77000000000001,7027.88,903]
["2016-06-14",0.63,0.02,0,0,0.65,15.620000000000001,5383.23,165.4,1329.38,373.16,7251.17,906]
["2016-07-14",0.83,0.04,0,0,0.87,15.73,4798.92,120.27,1144.99,208.73,6272.91,921]
["2016-08-14",3.58,0.3,0,0,3.88,15.83,5763.29,78.989999999999995,1227.8800000000001,134.26,7204.42,926]
["2016-09-14",4.21,0.35,0,0,4.5599999999999996,15.950000000000001,8723.9,587.05999999999995,1307.22,274.18,10892.36,964]
["2016-10-14",1.63,0.06,0,0,1.69,16.059999999999999,5912.16,184.85,974.68,161.34,7233.03,972]
["$ indicates as on October 31, 2016."]
["Source: BSE and NSE"]

{"sheet":"33","index":33,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5],[1,6,1,10],[12,0,12,5]]}
["Table 33: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of BSE"]
["Month","Percentage Share in Turnover",null,null,null,null,"Percentage Share in Open Interest"]
[null,"Pro","FII","Mutual Funds","Banks","Others","Pro","FII","Mutual Funds","Banks","Others"]
["2015-16",85.497778289246781,1.3651790558938095E-3,0,0,14.500856531697325,65.898099999999999,0,0,0,34.1]
["2016-17$",72.558168577628763,0,0,0,27.441831422371237,44.793999999999997,0,0,0,55.21]
["2016-04-22",91.377033873519039,0,0,0,8.6229661264809607,46.9664,0,0,0,53.03]
["2016-05-04",6.0217578217698602,0,0,0,93.978242178230147,34.25,0,0,0,65.75]
["2016-06-04",38.182435715666919,0,0,0,61.817564284333081,42.446043165467628,0,0,0,57.553956834532372]
["2016-07-05",78.613874180561083,0,0,0,21.386125819438917,44.456845238095241,0,0,0,55.543154761904759]
["2016-08-04",27.590664579507767,0,0,0,72.409335420492226,47.77,0,0,0,52.23]
["2016-09-03",22.372682893685823,0,0,0,77.62731710631418,25.989304812834231,0,0,0,74.010695187165766]
["2016-10-03",37.465740981621927,0,0,0,62.534259018378073,44.793999999999997,0,0,0,55.21]
["$ indicates as on October 31, 2016."]
["Source: BSE."]

{"sheet":"34","index":34,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5],[1,6,1,10],[12,0,12,5]]}
["Table 34: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of NSE"]
["Month","Percentage Share in Turnover",null,null,null,null,"Percentage Share in Open Interest"]
[null,"Pro","FII","Mutual Funds","Banks","Others","Pro","FII","Mutual Funds","Banks","Others"]
["2015-16",48.99,12,0.45,0,38.56,14.99,33.340000000000003,9.17,0,42.499999999999993]
["2016-17$",42.676820538796001,14.000000000000002,0.3913058268567573,0,42.931873634347248,15.246938896218525,27.808694968693732,8.7544468299813261,0,48.189919305106415]
["2016-04-01",45.697630165798003,14.987383074075399,0.44246600371304701,0,38.872520756413557,15.03,30.81,8.42,0,45.74]
["2016-05-02",44.230040957129802,14.890486541278401,0.37788272422730801,0,40.501589777364494,16.07,30.04,8,0,45.89]
["2016-06-03",44.990916779506797,12.0362699901253,0.36761741091091399,0,42.605195819456988,16.66,29.09,8.41,0,45.85]
["2016-07-04",43.454022546748099,13.0004380505246,0.39346032065103798,0,43.152079082076263,15.590000000000002,29.181882536891081,7.8936951488345466,0,47.336123998513699]
["2016-08-04",41.380813904166097,15.824746170452499,0.39026438030474803,0,42.404175545076697,16.739999999999998,28.11,7.01,0,48.140000000000008]
["2016-09-04",39.658652658975299,15.264495235586301,0.369015453805702,0,44.707836651632697,15.288951931579037,29.391223671024882,7.7934714081343026,0,47.526352989261781]
["2016-10-04",41.325151153227303,13.078024369205099,0.41133679043090798,0,45.1854876871367,15.246938896218525,27.808694968693732,8.7544468299813261,0,48.189919305106415]
["$ indicates as on October 31, 2016."]
["Source: NSE."]

{"sheet":"35","index":35,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,9],[12,0,12,5]]}
["Table 35: Instrument-wise Turnover in Index Derivatives at BSE"]
["Month","Turnover (in Percentage)"]
[null,"BSE 30 SENSEX                 ","BSE BANKEX                    ","BSE OIL & GAS INDEX           ","BSE TECK INDEX                ","BSE100","HANG SENG Index Futures","MICEX Index Futures","FTSE/JSE Top 40 Futures","IBOVESPA Futures"]
["2015-16",100,0,0,0,0,0,0,0,0]
["2016-17$",99.994137058776772,0,0,0,5.8629412232278355E-3,0,0,0,0]
["2016-04-04",100,0,0,0,0,0,0,0,0]
["2016-05-05",100,0,0,0,0,0,0,0,0]
["2016-06-06",100,0,0,0,0,0,0,0,0]
["2016-07-07",100,0,0,0,0,0,0,0,0]
["2016-08-07",100,0,0,0,0,0,0,0,0]
["2016-09-07",100,0,0,0,0,0,0,0,0]
["2016-10-07",99.3,0,0,0,0.7,0,0,0,0]
["$ indicates as on October 31, 2016."]
["Source: BSE."]

{"sheet":"36","index":36,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,10],[12,0,12,5]]}
["Table 36: Instrument-wise Turnover in Index Derivatives at NSE"]
["Month","Turnover (in Percentage)"]
[null,"NIFTY","CNXIT","BANKNIFTY","NFTYMCAP50","CNXPSE","CNXINFRA","FTSE100","S&P500","DJIA","India VIX"]
["2015-16",85.496961833331,6.1454637173678607E-3,14.47967800393473,3.2970523393007308E-4,2.8278204796393859E-6,4.6270855947161742E-6,1.380245376578285E-5,8.1620364917005354E-3,8.6825428534729882E-3,1.9157077912717019E-5]
["2016-17$",63.799743036424047,0,36.185308047937461,0,0,0,0,6.6411622527390579E-3,0,0]
["2016-04-16",85.575284014614596,5.1991216277110942E-3,14.400293364154882,3.6032049031259036E-6,0,5.2376383580436231E-6,2.7732582453731572E-6,1.1766421767928401E-2,7.449671326817087E-3,2.7732582453731572E-6]
["2016-05-16",86.634413299473863,5.2376383580436231E-6,13.34958127912231,3.6032049031259036E-6,5.2376383580436231E-6,5.2376383580436231E-6,2.7732582453731572E-6,1.1766421767928409E-2,5.7525376331858556E-3,2.7732582453731572E-6]
["2016-06-01",72.285708433026201,5.2376383580436231E-6,27.698295903261389,3.6032049031259036E-6,5.2376383580436231E-6,5.2376383580436231E-6,2.7732582453731572E-6,1.1766421767928409E-2,4.8177743064703703E-3,2.7732582453731572E-6]
["2016-07-02",61.649099188194491,3.6032049031259036E-6,38.335373880859592,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,4.8177743064703703E-3,6.0107689116944939E-3,4.8177743064703703E-3,2.7732582453731572E-6]
["2016-08-02",56.912116862958193,3.6032049031259036E-6,43.075550545776785,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6]
["2016-09-02",48.710549672370036,3.6032049031259036E-6,51.277153644382288,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,5.5242918852564616E-3,3.6032049031259036E-6,3.6032049031259036E-6]
["2016-10-02",47.673368540824882,3.6032049031259036E-6,52.315037026615244,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6,3.6032049031259036E-6]
["$ indicates as on October 30, 2016."]
["Source: NSE."]

{"sheet":"37","index":37,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,5],[0,0,0,11],[1,0,3,0],[1,2,1,3],[1,4,1,7],[1,8,1,9],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,2,5],[2,6,2,7],[2,8,3,8],[2,9,3,9],[2,10,2,11],[13,0,13,11]]}
["Table 37: Trends in Currency Derivatives Segment at NSE"]
["Year/     Month\n",null,"Currency Futures",null,"Currency Options",null,null,null,"Total"]
[null,"No. of Trading  Days","No. of Contracts ","Turnover (` crore)","Call",null,"Put",null,"No. of Contracts ","Turnover (` crore)","Open Interest at the end of"]
[null,null,null,"Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)",null,null,"No. of Contracts "," Value\n(` crore)"]
["2015-16",242,409759364,2749332.9606198999,156142461,1041794.0449942998,107681339,710758.57068200002,673583164,4501885.5762961004,4464441,29814.094660000002]
["2016-17$",140,209411073,1444695.198352,110678678,750725.77793574997,75384384,505542.45262925001,395474135,2700963.4289170001,4289463,28855.705320000001]
["2016-04-14",16,29162057,198407.92984549998,13976664,94180.649334750007,8360189,55742.221703500007,51498910,348330.80088375002,4111903,27563.369409999999]
["2016-05-14",22,33368426,230308.74157675001,16833646,114168.66284125,12241448,82119.13892225,62443520,426596.54334024998,4058007,27555.97092]
["2016-06-16",22,45774934,320800.39587975002,18936894,129292.9032475,14504063,97574.452069999999,79215891,547667.75119724998,3922579,26709.311719999998]
["2016-07-16",20,23757025,165256.01961849999,14168548,96619.162553500006,7926039,53363.462824249997,45851612,315238.64499624999,3981914,26890.606370000001]
["2016-08-16",21,24649243,169809.17376275,14378312,97635.572318249993,10219690,68560.711646249998,49247245,336005.45772725,4912897,33133.024279999998]
["2016-09-16",20,29838524,203859.67027100001,19509342,131876.854682,13077460,87559.085652249996,62425326,423295.61060525,5216098,35044.205062170004]
["2016-10-16",19,22860864,156253.26739774999,12875272,86951.972958500002,9055495,60623.379810749997,44791631,303828.62016699999,4289463,28855.705320000001]
["Notes: 1. Trading Value :- For Futures, Value of contract = Traded Qty*Traded Price. 2. For Options, Value of contract = Traded Qty*(Strike Price+Traded Premium)"]
["$ indicates as on October 31, 2016."]
["Source: NSE."]

{"sheet":"38","index":38,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,3],[0,0,0,11],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,1,7],[1,8,2,9],[1,10,2,11],[2,4,2,5],[2,6,2,7]]}
["Table 38: Trends in Currency Derivatives Segment at MSEI"]
["Year/     Month\n","No. of Trading Days","Currency Futures",null,"Currency Options",null,null,null,"Total",null,"Open Interest at the end of "]
[null,null,null,null,"Call",null,"Put"]
[null,null,"No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Value \n(` crore)"]
["2015-16",242,45626511,303353.12203750003,1687097,11123.777447500001,1544673,10098.647645999999,48858281,324575.54714474926,322811,2161.574834500002]
["2016-17$",140,29263473,197666.35570474999,329574,2229.8139192499998,321129,2164.4970947499996,29914176,202060.66671875003,256063,1721.2589572500003]
["2016-04-14",16,2584072,17440.425272999997,32475,221.94626099999999,21169,143.05452100000002,2637716,17805.426054999996,278878,1872.9130064999972]
["2016-05-14",22,3734333,25340.504979999998,18184,122.05923199999999,17620,118.08918849999999,3770137,25580.653400499999,228158,1550.5253839999968]
["2016-06-01",22,6350841,43189.435203499997,15631,106.69838200000001,21263,143.72849099999999,6387735,43439.862076499994,205088,1395.3440937500027]
["2016-07-01",20,4316582,29202.537123500006,36016,244.902952,46789,315.99956200000003,4399387,29763.439637500007,270068,1822.2597544999931]
["2016-08-01",21,3832873,25838.986870999997,80855,548.15058424999995,117267,790.14098324999998,4030995,27177.278438499998,297991,2009.4579052499998]
["2016-09-01",20,4813187,32295.982985250001,144713,974.39360799999986,97021,653.48434899999995,5054921,33923.860942250001,300348,2013.7401867500005]
["2016-10-01",19,3631585,24358.4832685,1700,11.6629,0,0,3633285,24370.146168499999,256063,1721.2589572500003]
["$ indicates as on October 31, 2016."]
["Source: MSEI"]

{"sheet":"39","index":39,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,5],[13,0,13,5],[0,0,0,11],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,1,7],[1,8,2,9],[1,10,2,11],[2,4,2,5],[2,6,2,7]]}
["Table 39: Trends in Currency Derivatives Segment at BSE"]
["Year/     Month\n","No. of Trading Days","Currency Futures",null,"Currency  Options",null,null,null,"Total",null,"Open Interest at the end of "]
[null,null,null,null,"Call",null,"Put"]
[null,null,"No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Turnover (` crore)","No. of Contracts ","Value \n(` crore)"]
["2015-16",242,280635711,1850359.2716000001,66736708,444137.21,72854123,469429.65279999998,420226542,2763926.1344000003,1287841,8553.9315399999996]
["2016-17$",140,160480879,1079471.8921000001,65435485,444107.03130000003,53403781,356258.9278,279320145,1879837.8511999999,1448711,9690.5628899999992]
["2016-04-14",16,23133265,154366.58889999997,9492234,63910.60590000001,7850678,52114.085899999998,40476177,270391.2807,1185981,7894.7761099999998]
["2016-05-04",22,28835159,193916.3615,9997617,67781.611099999995,8954576,59722.538999999997,47787352,321420.51159999997,1032381,6951.7983100000001]
["2016-06-04",22,33712616,228206.63440000001,8915140,60796.950100000009,9647051,64594.068100000004,52274807,353597.65260000003,1025657,6943.6217500000002]
["2016-07-04",20,17612158,118967.87910000001,10100898,69039.865999999995,5863364,39269.3462,33576420,227277.0913,1234262,8279.4252400000005]
["2016-08-04",21,18850183,126847.0128,9406727,63959.257299999997,6892053,46026.869299999998,35148963,236833.13939999999,1381830,9260.0649236800018]
["2016-09-04",20,21394660,143510.24960000001,9813210,66454.8413,7716415,51392.25069999999,38924285,261357.34160000001,1473371,9841.4280699999999]
["2016-10-04",19,16942838,113657.16580000002,7709659,52163.899600000004,6479644,43139.768600000003,31132141,208960.83400000003,1448711,9690.5628899999992]
["$ indicates as on October 31, 2016."]
["Source: BSE"]

{"sheet":"40","index":40,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,5],[1,15,4,15],[2,1,2,2],[2,3,2,4],[2,6,2,7],[2,8,2,9],[2,11,2,12],[2,13,2,14],[3,1,4,1],[3,2,4,2],[3,3,4,3],[1,0,4,0],[1,1,1,4],[1,5,4,5],[1,6,1,9],[3,4,4,4],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[1,10,4,10],[1,11,1,14]]}
["Table 40: Settlement Statistics of Currency Derivatives Segment (` crore)"]
["Year/     Month\n","NSE",null,null,null,"Total","MSEI",null,null,null,"Total","BSE",null,null,null,"Total"]
[null,"Currency Futures",null,"Currency Options",null,"Total","Currency Futures",null,"Currency options",null,"Total","Currency Futures",null,"Currency Options",null,"Total"]
[null,"MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement",null,"MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement",null,"MTM Settlement","Final Settlement","Premium Settlement","Exercise Settlement"]
[null,null,null,null,"Exercise Settlement",null,null,null,null,"Exercise Settlement",null,null,null,null,"Exercise Settlement"]
["2015-16",6540.5758972499989,184.36146269,948.74610499999994,393.60350175000002,8067.2869666900006,935.14946255000007,18.557625479999999,37.156563999999989,17.446905010000002,1008.3105570399999,3338.43,65.210000000000008,2920.3699999999994,152.67000000000002,6476.6799999999994]
["2016-17$",2612.2017154999999,42.75852545,547.60591624999995,151.81157228999999,3354.3777294900001,285.52096175000003,5.6448080000000003,6.8167555000000002,4.171729,302.15425425000001,1762.77,23.840000000000003,1346.4499999999998,51.41,3184.47]
["2016-04-14",407.28751649999998,0.96178456000000001,71.100254000000007,18.477194799999999,497.82674986000001,38.232419999999998,0.13225000000000001,0.32683374999999998,0.01,38.701503749999993,249.12,0.94,248.03,6.65,504.74]
["2016-05-14",386.16085175000001,11.462539829999999,106.04062725,17.01427739,520.67829621999999,34.28049575,1.7825580000000001,1.1417677500000001,0.84172899999999995,38.046550500000002,255.76,5.94,263.86,8.1300000000000008,533.69000000000005]
["2016-06-14",671.66463150000004,16.723986610000001,124.51139499999999,33.442103439999997,846.34211655000001,58.488045999999997,1.4,0.55385399999999996,0.16,60.601899999999993,408.49,6.42,322.94,10.16,748.01]
["2016-07-14",292.42183275000002,1.8414798300000004,70.431186749999995,19.40376298,384.09826231000005,33.65,0.4,0.41,0.24,34.699999999999996,237.38,2.5099999999999998,162.52000000000001,6.38,408.79]
["2016-08-14",361.40665000000001,8.503106380000002,94.203075749999996,29.6121558,493.72498793,53.33,1.59,1.4742999999999999,0.09,56.484300000000005,269.47000000000003,5.1100000000000003,158.96,8.5399999999999991,442.08]
["2016-09-14",493.26023300000003,3.2656282400000007,81.319377500000002,33.862077879999994,611.70731662000003,67.540000000000006,0.34,2.91,2.83,73.62,342.55,2.92,190.14,11.55,547.16]
["2016-10-14",259.9792625,5.6803685999999987,57.931280999999998,13.274739760000001,336.86565186000001,37.74,1.37,0.09,0,39.200000000000003,218.34,3.75,142.26,5.38,369.73]
["$ indicates as on October 31, 2016."]
["Source: Respective stock exchanges"]

{"sheet":"41","index":41,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 41: Instrument-wise Turnover in Currency Derivatives of NSE"]
["Month","Turnover (in `crore)",null,null,null,"Open Interest as on last day of the month\n(in lots)"]
[null,"USDINR","EURINR","GBPINR","JPYINR","USDINR","EURINR","GBPINR","JPYINR"]
["2015-16",4205400.4206652502,135414.50916125,130497.33005899999,30573.321623250002,4364508,68311,21529,10093]
["2016-17$",2471436.5627542501,60046.901259000006,125774.32513049999,43705.639773249997,4154928,42026,65188,27321]
["2016-04-15",326259.11796,7675.2817359999999,11096.311078999999,3300.0901087500001,3989664,54510,39005,28724]
["2016-05-15",395697.12394324999,9030.9780527500006,17213.334349500001,4655.10699475,3927621,66540,46688,17158]
["2016-06-15",491865.01715725003,11720.984163499999,36062.002260250003,8019.7476162499997,3786186,46891,43633,45869]
["2016-07-15",280468.21312500001,8189.7981817500004,19297.455616250001,7283.1780732500001,3828445,65918,45698,41853]
["2016-08-15",306304.19468875002,8326.7336039999991,14271.32878,7103.2006545000004,4754700,78627,36726,42844]
["2016-09-16",391965.03544324997,8780.3969247500008,13672.036705500001,8878.1415317499996,5029827,59364,73407,53500]
["2016-10-16",278877.86043674999,6322.72859625,14161.85634,4466.1747939999996,4154928,42026,65188,27321]
["$ indicates as on October 31, 2016."]
["Source: NSE."]

{"sheet":"42","index":42,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 42: Instrument-wise Turnover in Currency Derivative Segment of MSEI"]
["Month","Turnover\n(`crore)",null,null,null,"Open Interest as on last day of the month\n(in lots)"]
[null,"USDINR","EURINR","GBPINR","JPYINR","USDINR","EURINR","GBPINR","JPYINR"]
["2015-16",296770.88,13422.71,12541.38,1840.58,315831,3213,3183,584]
["2016-17$",195585.99697474999,1719.404583999999,3383.6197174999998,1371.6339157500001,250250,409,2606,2798]
["2016-04-01",16770.95,288.61,621.83000000000004,124.03,270016,3513,2757,2592]
["2016-05-01",24444.59,347.18,659.81,129.07,221255,4370,1513,1020]
["2016-06-01",41994.64,391.63,832.59,221,199160,1436,1681,2811]
["2016-07-01",28868.686846000001,209.309594,433.07553024999999,252.3676725,264814,1573,1701,1980]
["2016-08-01",26393.915069750037,245.45678424999934,315.97807974999995,221.92850474999986,291594,2396,1360,2641]
["2016-09-02",33210.478491499969,152.88538824999952,294.88632524999963,265.61073725000034,294889,680,1983,2796]
["2016-10-02",23902.7365675,84.332817500000004,225.44978225,157.62700125000001,250250,409,2606,2798]
["$ indicates as on October 31, 2016."]
["Source: MSEI"]

{"sheet":"43","index":43,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 43: Instrument-wise Turnover in Currency Derivative Segment of BSE"]
["Month","Turnover\n(`crore)",null,null,null,"Open Interest as on last day of the month\n(in lots)"]
[null,"USDINR","EURINR","GBPINR","JPYINR","USDINR","EURINR","GBPINR","JPYINR"]
["2015-2016",2751844.7056999998,7785.7367000000004,3136.0607,1159.6313000000002,1275750,11087,645,359]
["2016-17$",1864338.4007999999,6167.1049999999996,6553.7550999999994,2778.5902999999994,1443559,1158,837,3157]
["2016-04-13",269026.14480000001,947.03800000000012,305.01339999999999,113.08450000000001,1180469,2321,1476,1715]
["2016-05-14",319290.24219999998,1271.1285000000003,648.92129999999997,210.21960000000004,1023765,5247,3189,180]
["2016-06-14",350572.14130000002,1250.4431999999999,1331.9439000000002,443.12419999999997,1018682,3600,2598,777]
["2016-07-14",224992.95939999999,743.18639999999982,1100.1222999999998,440.82319999999993,1229286,2331,1951,694]
["2016-08-14",234594.75999999998,763.8071000000001,947.49710000000005,527.0752,1375420,2836,2272,1302]
["2016-09-15",258923.40350000001,729.50800000000004,1029.3467000000001,675.08339999999976,1455816,4012,8626,4917]
["2016-10-15",206938.74960000004,461.99380000000008,1190.9104,369.18019999999996,1443559,1158,837,3157]
["$ indicates as on October 31, 2016."]
["Source: BSE"]

{"sheet":"44","index":44,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 44: Maturity-wise Turnover in Currency Derivative Segment of NSE  (` crore)"]
["Month","Currency Futures",null,null,null,"Currency Options"]
[null,"1 Month","2 Month","3 Month","> 3 months","1 Month","2 Month","3 Month","> 3 months"]
["2015-16",2283299.8202707497,409291.93820475007,36271.92062574999,20469.2815305,1523244.9870230001,223336.98205225001,5802.7294812999999,167.91711375]
["2016-17$",1169932.04968225,242424.90282925,21963.525329249998,10374.720511250001,1041495.036813,207477.99764324998,7256.3188632500005,38.877245500000001]
["2016-04-16",162001.59202524999,33654.464288249997,1623.1239115000001,1128.7496204999998,124157.94673999998,25651.084841250002,113.55352574999999,0.28593125000000003]
["2016-05-16",190942.34246850002,35203.926935750002,2543.0905140000004,1619.3816584999997,165390.04293850003,30141.682581000005,755.48391375000006,0.59233025000000006]
["2016-06-01",268012.44104450004,46375.66576625,4135.1651700000002,2277.1238990000015,196313.03722774997,30386.656474500003,167.3211475,0.34046775000000001]
["2016-07-01",134402.79619800003,27451.014831500001,2446.4039222499996,955.80466674999991,121353.912962,27420.057135499999,1205.5956692499999,3.0596109999999999]
["2016-08-01",133072.51367724998,32831.856215499996,2837.9881512500001,1066.8157187500003,134060.49148950004,30587.679039249997,1544.5158007500002,3.5976349999999999]
["2016-09-01",159067.32340475,37584.745381249995,5769.4145207499996,1438.1869642500001,181900.01759225002,35449.703452499991,2066.8739895000003,19.345299999999998]
["2016-10-01",122433.040864,29323.229410750006,2608.3391395000003,1888.6579835000002,118319.58786299999,27841.134119250004,1402.9748167499997,11.655970250000001]
["$ indicates as on October 31, 2016."]
["Source: NSE."]

{"sheet":"45","index":45,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 45: Maturity-wise Turnover in Currency Derivative Segment of MSEI (` crore)"]
["Month","Currency Futures",null,null,null,"Currency Options"]
[null,"1 Month","2 Month","3 Month","> 3 months","1 Month","2 Month","3 Month","> 3 months"]
["2015-16",243824.51,50734.23,5470.94,3323.45,19299.830000000002,1665.05,102.44,155.11000000000001]
["2016-17$",159930.01104249997,36512.480928999998,1197.3560445000001,26.512152,4332.9282534999993,49.723779500000006,11.6629,0]
["2016-04-01",13839.65,3549.53,49.18,2.06,358.02,6.98,0,0]
["2016-05-01",22116.15,3136.85,79.66,7.85,219.22,20.93,0,0]
["2016-06-01",37258.050000000003,5688.45,236.18,6.76,245.96,4.47,0,0]
["2016-07-01",23692.039669999998,5447.7051929999998,61.190595999999999,1.601647,556.81426399999998,4.0882500000000004,0,0]
["2016-08-01",20671.492644999998,5029.9411300000002,136.01516950000001,1.5379049999999999,1325.0360349999999,13.2555295,0,0]
["2016-09-02",25405.633904500002,6676.9459865000008,213.19269199999999,0.21037999999999998,1627.8779544999998,0," ",0]
["2016-10-02",16946.994823000001,6983.0586194999996,421.93758700000001,6.4922199999999997,"-","-",11.6629,"-"]
["$ indicates as on October 31, 2016."]
["Source: MSEI"]

{"sheet":"46","index":46,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 46: Maturity-wise Turnover in Currency Derivative Segment of BSE (` crore)"]
["Month","Currency Futures",null,null,null,"Currency Options"]
[null,"1 Month","2 Month","3 Month","> 3 months","1 Month","2 Month","3 Month","> 3 months"]
["2015-2016",1662039.3200000003,179409.97,8750.93,151.48000000000002,741661.73,70974.680000000008,63234.23,37692.720000000008]
["2016-17$",945168.26437025017,126293.0486735,7799.9838760000002,206.48467899999997,720295.16033350001,77282.455518250004,2630.84516575,157.37625]
["2016-04-04",135921.16,17732.099999999999,705.67,7.02,96784.36,19192.829999999998,45.919999999999995,1.36]
["2016-05-04",174925.45437024999,17546.278673500001,1389.963876,54.664679,118323.72033349999,8683.3755182500008,462.04516575000002,35.006250000000001]
["2016-06-04",203675.22000000003,22782.07,1669.07,79.400000000000006,117288.11,7932.93,138.77000000000001,30.92]
["2016-07-04",103979.11000000002,14006.989999999998,968.56000000000006,12.44,96195.08,11724.91,384.84,4.1500000000000004]
["2016-08-04",109834.54000000001,16342.25,658.15,11.219999999999999,100484.18,9065.99,418.14,18.579999999999998]
["2016-09-05",121760.91,20286.27,1448.76,14.13,108232.74,8774.25,774.98,65.23]
["2016-10-05",95071.87,17597.09,959.81,27.61,82986.969999999987,11908.17,406.14999999999992,2.13]
["$ indicates as on October 31, 2016."]
["Source: BSE"]

{"sheet":"47","index":47,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,0,15,5],[2,12,3,13],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[2,2,3,3],[2,4,3,5],[2,6,3,7],[1,0,5,0],[1,1,5,1],[1,2,1,5],[1,6,1,9],[1,10,1,13],[4,11,5,11],[4,12,5,12],[4,13,5,13],[2,8,3,9],[2,10,3,11],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10]]}
["Table 47: Trading Statistics of Interest Rate Futures at BSE, NSE and MSEI"]
["Year/ Month\n","No. of Trading Days","BSE",null,null,null,"NSE",null,null,null,"MSEI"]
[null,null,"Interest RateFutures",null,"Open Interest at the end of ",null,"Interest RateFutures",null,"Open Interest at the end of ",null,"Interest RateFutures",null,"Open Interest at the end of                        "]
[]
[null,null,"No. of Contracts ","Traded Value \n(` crore)","No. of Contracts "," Value \n(` crore)","No. of Contracts ","Traded Value \n(` crore)","No. of Contracts "," Value \n(` crore)","No. of Contracts ","Traded Value \n(` crore)","No. of Contracts "," Value \n(` crore)"]
[]
["2015-16",242,5687653,114120.55650000002,5566,111.7657,26056481,526424.57620000001,154627,3104.741145,1123415,22816.970387500001,25291,507.19377648]
["2016-17$",140,3418889,69740.816899999991,598,12.5258,7301669,149282.87030399998,86947,1834.109987,125149,2548.8549539999999,"-","-"]
["2016-04-01",16,693420,13949,5629,113.3,1504083,30288.87,157229,3172,19299,389.04,5000,101.01]
["2016-05-01",22,522015,10514.864300000001,6107,122.91549999999999,1148618,23130.762554000001,155964,3139.2787880000001,56,1.1264535,0,0]
["2016-06-01",22,550934,11075.2266,1648,33.270000000000003,1003943,20213.696008999999,137103,2774.9349160000002,25055,503.97,7018,141.61000000000001]
["2016-07-01",20,395854,8080.2785999999996,1166,24.0291,942851,19301.758964500001,148705,3081.5456119999999,46462,948.05677100000003,6349,130.62807050000001]
["2016-08-01",21,404478,8339.6966000000011,2918,60.575899999999997,1088283,22532.137615,150564,3143.2158260000001,32516,670.11926949999997,1122,23.158640999999999]
["2016-09-01",20,448167,9300.4696999999978,4357,90.81,817622,17057.482233999999,95582,2010.9925685000001,1761,36.542459999999998,0,0]
["2016-10-01",19,404021,8481.2810999999983,598,12.5258,796269,16758.162927500001,86947,1834.109987,"-","-","-","-"]
["$ indicates as on October 31, 2016."]
["Source: BSE, NSE and MSEI"]

{"sheet":"48","index":48,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,0,12,4],[0,0,0,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6]]}
["Table 48: Settlement Statistics in Interest Rate Futures at BSE, NSE and MSEI (` crore)"]
["Year/ Month","BSE",null,"NSE",null,"MSEI"]
[null,"MTM Settlement","Physical Delivery Settlement","MTM Settlement","Physical Delivery Settlement","MTM Settlement","Physical Delivery Settlement"]
["2015-16",290.7,11.4,1124.3,22.1,188.7,0]
["2016-17$",26.563860000000002,3.0774319999999999,351.20909499999999,18.728112640000003,10.027483,0]
["2016-04-01",4.87,0.34,62.9,2.95,1.7589999999999999,0]
["2016-05-01",4.4826589999999999,0.147559,26.210110499999999,0.36206664,0.86928300000000003,0]
["2016-06-01",5.4626089999999996,0.13509199999999999,30.587928999999999,0.48510441999999993,0.11940000000000001,0]
["2016-07-01",3.637432,1.1214,58.338213500000002,4.9575052799999995,3.5,0]
["2016-08-01",2.2442350000000002,0.104268,74.153575500000002,1.2189533799999999,3.52,0]
["2016-09-01",2.6576650000000002,1.0489569999999999,58.221464500000003,8.1647734400000012,0.25979999999999998,0]
["2016-10-01",3.20926,0.18015600000000001,40.797801999999997,0.58970948000000012,0,0]
["$ indicates as on October 31, 2016."]
["Source: NSE, BSE and MSEI"]

{"sheet":"49","index":49,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,5],[12,0,12,5],[11,0,11,5]]}
["Table 49: Trends in Foreign Portfolio Investment"]
["Year/Month","Gross Purchase (` crore)","Gross Sales (` crore)","Net Investment\n (` crore)","Net Investment \n(US $ mn.)","Cumulative Net\n Investment       (US $ mn.)"]
["2015-16",1324417.5300000003,1342592.67,-18175.139999999996,-2522.8199999999997,223587.7]
["2016-17 $",835890.22999999986,789599.2,46291.03,6947.5999999999995,230535.28999999998]
["2016-04-14",118609.29,103775.12,14834.17,2233.61,225821.31]
["2016-05-14",107126.34,108992.22,-1865.88,-275.58,225545.73]
["2016-06-14",117711.31,120218.67,-2507.36,-366.99,225178.74000000002]
["2016-07-14",120284.37,100827.11,19457.259999999998,2897.19,228075.93]
["2016-08-14",127521.77,121075.32,6446.45,964.08,229040]
["2016-09-14",146049.82,125817.21,20232.61,3038.58,232078.58,null,229040]
["2016-10-14",98587.33,108893.55,-10306.219999999999,-1543.29,230535.28999999998,null,229040]
["$ indicates as on October 31, 2016."]
["Source: NSDL, CDSL"]

{"sheet":"50","index":50,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,1],[12,0,12,5],[11,0,11,8],[0,0,0,7]]}
["Table 50: Notional Value of Offshore Derivative Instruments (ODIs) Vs Assets Under Custody (AUC) of FPIs/Deemed FPIs (` crore)"]
["Year/ Month","Notional value of ODIs on Equity, Debt & Derivatives ","Notional value of ODIs on Equity & Debt  excluding Derivatives ","Assets Under Custody of FPIs/Deemed FPIs","Notional value of ODIs on Equity, Debt & Derivatives as % of  Assets Under Custody of FPIs/Deemed FPIs","Notional value of ODIs on Equity & Debt  excluding Derivatives as % of  Assets Under Custody of FPIs/Deemed FPIs"]
["2015-16",223077,169470,2224537,10,7.6]
["2016-17$",199987,143235,2577073,7.8,5.6]
["2016-04-01",212132,161280,2281346,9.3000000000000007,7.1]
["2016-05-01",215338,160867,2348618,9.1999999999999993,6.8]
["2016-06-01",210731,161379,2387685,8.8000000000000007,6.8]
["2016-07-01",212179,162921,2514038,8.4,6.5]
["2016-08-01",216232,158848,2565304,8.4,6.2]
["2016-09-01",212509,152624,2556244,8.3000000000000007,6]
["2016-10-01",199987,143235,2577073,7.8,5.6]
["Notes: 1. Figures are compiled based on reports submitted by FPIs/deemed FPIs issuing ODIs. 2. Column 4 Figures are compiled on the basis of reports submitted by custodians & does not includes positions taken by FPIs/deemed FPIs in derivatives. 3. The total value of ODIs excludes the unhedged positions & portfolio hedging positions taken by the FPIs/deemed FPIs issuing ODIs.\n"]
["$ indicates as on October 31, 2016."]
["Source: SEBI."]

{"sheet":"51","index":51,"n_rows":16,"n_cols":29,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,25,1,26],[1,27,1,28],[1,11,1,12],[1,13,1,14],[1,17,1,18],[1,19,1,20],[1,21,1,22],[1,23,1,24],[1,15,1,16],[15,0,15,9],[1,5,1,6],[1,3,1,4],[1,7,1,8],[1,0,2,0],[1,1,1,2],[1,9,1,10],[14,0,14,5],[12,0,12,24],[13,0,13,14]]}
["Table 51: Assets under the Custody of Custodians"]
["       Client\n\nPeriod","FPIs ",null,"Foreign Depositories",null,"FDI Investments",null,"Foreign Venture Capital Investments",null,"OCBs",null,"NRIs",null,"Mutual Funds",null,"Corporates",null,"Banks",null,"Insurance Companies",null,"Local Pension Funds",null,"Financial Institutions ",null,"Others",null,"Total"]
[null,"No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)","No.","Amount (` crore)"]
["2015-16",8855,2224537.33,63,235913.9,1411,468497.71,189,57928.06,23,1657.94,378,2379.34,1815,1105914.56,456,57849.16,114,192945.8,489,1227301.44,104,175627.34,31,69999.350000000006,11280,430775,25208,6251326]
["2016-17$",8916,2577075.9277744503,63,262252.32152702205,1455,543869.89139080606,185,36134.461626400996,23,2099.0349999999999,480,2676.23,1804,1540381.1427832481,453,77687.864425098989,191,310400.53507529298,526,2292756.9565648967,143,343838.31594019395,40,140912.62,74924,500546.28389520326,89203,8630631.5860026125]
["2016-04-14",8882,2281346,63,240524,1421,475704,187,58148,23,1769,339,2384,1845,1219736,405,61116,114,220411,490,1244593,100,179060,31,69490,11033,441023,24933,6495304]
["2016-05-14",8918,2348618,63,250983,1425,481069,188,58486,23,1862,340,2429,1827,1238739,408,63128,115,227780,490,1269412,100,182909,31,74007,11167,452433,25095,6651855]
["2016-06-14",8914,2387685,63,250224,1434,492992,188,38951,23,1918,339,2524,1826,1207098,412,65743,114,210359,493,1293289,92,128362,31,76045,11451,453606,25380,6608796]
["2016-07-14",8941,2514038.42,63,258376.26,1428,525872.12,191,38314.550000000003,23,2015.08,407,2675.22,1835,1301558.73,420,65654,114,237759.81,493,1327394.1299999999,92,132302.70000000001,31,77717.64,42231,466684.79,56269,6950363.4499999993]
["2016-08-14",8936,2565304,63,263085,1442,519620,187,38531,23,2150,409,2716,1858,1309953,427,72182,114,245518,502,1342329,92,197345,31,81054,42435,479948,56519,7119735]
["2016-09-14",8915,2556450,63,260543,1447,524931,186,37718,23,2137,413,2679,1821,1335175,430,71519,114,237272,502,1325421,92,201405,29,76613,42780,488874,56815,7120737]
["2016-10-14",8916,2577075.9277744503,63,262252.32152702205,1455,543869.89139080606,185,36134.461626400996,23,2099.0349999999999,480,2676.23,1804,1540381.1427832481,453,77687.864425098989,191,310400.53507529298,526,2292756.9565648967,143,343838.31594019395,40,140912.62,74924,500546.28389520326,89203,8630631.5860026125]
["Notes: 1. With the commencement of FPI Regime from June 1, 2014, the erstwhile FIIs, Sub Accounts and QFIs are merged into a new investor class termed as “Foreign Portfolio Investors (FPIs)”. "]
["2. \"Others\" include Portfolio manager, partnership firm, trusts, depository receipts, AIFs, FCCB, HUFs, Brokers etc."]
["$ indicates as on October 31, 2016."]
["Source: Custodians."]

{"sheet":"52","index":52,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[12,0,12,4],[1,0,2,0],[0,0,0,10],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,2,10]]}
["Table 52: Trends in Resource Mobilization by Mutual Funds (` crore)"]
["Year/ Month","Gross Mobilisation",null,null,"Redemption",null,null,"Net Inflow/Outflow",null,null,"Assets at the\n End of Period"]
[null,"Pvt. \nSector","Public\n Sector","Total ","Pvt.\n Sector","Public\n Sector","Total ","Pvt. \nSector","Public\n Sector","Total"]
["2015-16",11126276.537488604,2639278.6617867127,13765555.199275315,11034883.021488674,2596491.9012937243,13631374.527694194,91393.522210038471,42786.752442223515,134180.53207055948,1232824]
["2016-17$",7927617.9830052117,1895060.4855785435,9822678.4685837552,7702723.0607806034,1853056.9480005796,9555780.0087811816,224894.92222461078,42003.537577963543,266898.45980257436,1628975.8238163556]
["2016-04-14",886910.84398874501,240381.96,1127292.803988745,750882.907380883,206249.24,957132.14738088299,136027.936607863,34132.720000000001,170160.656607863,1421952.0639961101]
["2016-05-14",1172437.2049852535,282745.83142298867,1455183.0364082423,1212990.3443535352,300377.21651562862,1513367.5608691638,-40553.139368281511,-17631.385092640026,-58184.524460921537,1381625.0507452644]
["2016-06-14",1215968.3751269835,307585.51918752491,1523553.8943145084,1240462.3418728006,304626.61862439103,1545088.9604971916,-24493.966745816957,2958.9005631339678,-21535.066182682989,1380746.695586914]
["2016-07-01",1243398.3037550854,288912.45709891606,1532310.7608540016,1166307.4130169856,263284.38314731442,1429591.7961643001,77090.890738100323,25628.073951601586,102718.96468970191,1518097.3414216391]
["2016-08-01",1176870.8203414558,253846.7209092612,1430717.5412507169,1148707.4404201051,256677.42758017225,1405384.8680002773,28163.379921349377,-2830.7066709109422,25332.673250438434,1563176.8639662517]
["2016-09-01",1137488.8573996834,255136.98686751176,1392625.8442671951,1128679.7996705649,247874.61284484155,1376554.4125154065,8809.0577291209775,7262.3740226700465,16071.431751791024,1580076.2150741166]
["2016-10-01",1094543.5774080046,266451.01009234076,1360994.5875003454,1054692.8140657283,273967.4492882319,1328660.2633539601,39850.763342275575,-7516.4391958910874,32334.32414638449,1628975.8238163556]
["$ indicates as on October 31, 2016."]
["Source: SEBI."]
[]
[]
[]
[]
[null,null,null,null,null,"`"]

{"sheet":"53","index":53,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,2,0],[1,1,1,3],[1,10,2,10],[1,4,1,6],[1,7,1,9]]}
["Table 53: Type-wise Resource Mobilisation by Mutual Funds: Open-ended and Close-ended (` crore)"]
["Scheme","2015-16",null,null,"2016-17$",null,null,"2016-10-02",null,null,"Assets at the end of period\n"]
[null,"Sale","Purchase","Net","Sale","Purchase","Net","Sale","Purchase","Net",null,null,null,"Sale","Purchase","Net"]
["Open-ended",13586789.68,13721397.17,134607.48000000001,9529504.8548837062,9810886.5990841202,281381.7442004123,1325226.3984089559,1360252.0504315365,35025.652022579161,1452929.3243448299,null,null,8204278.4564747503,8450634.5486525837,246356.09217783314]
["Close-ended",42455.24,43132.39,677.15,24235.327621042808,11648.18381452,-12587.143806522809,3130.1082212342772,742.31694742500076,-2387.7912738092764,169810.46254094219,null,null,21105.219399808531,10905.866867094999,-10199.352532713532]
["Interval",2129.61,1025.51,-1104.0999999999999,2039.8229887645525,143.68559609751171,-1896.1373926670408,303.75672377451929,0.22012139399998887,-303.5366023805193,6236.0369305836412,null,null,1736.0662649900332,143.46547470351172,-1592.6007902865215]
["Total",13631374.529999999,13765555.07,134180.53,9555780.0054935142,9822678.4684947375,266898.46300122241,1328660.2633539643,1360994.5875003543,32334.324146389321,1628975.8238163558,null,null,8227119.7421395499,8461683.8809943832,234564.13885483309]
["$ indicates as on October 31, 2016."]
["Source: SEBI."]

{"sheet":"54","index":54,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,14,1,16],[18,0,18,1],[1,0,2,0],[0,0,0,11],[1,1,1,4],[1,9,1,11],[1,5,1,7]]}
["Table 54: Scheme-wise Resource Mobilisation and Assets under Management by Mutual Funds (` crore)"]
["Type ","2015-16",null,null,null,"2016-17$",null,null,null,"2016-10-01",null,null,null,null,"Upto Sept 16"]
[null,"Sale","Purchase","Net","Assets at the end of Period","Sale","Purchase","Net","Assets at the end of Period","Sale","Purchase","Net",null,null,"Sale","Purchase","Net"]
["A. Income/Debt Oriented Schemes \n     (i+ii+iii+iv)",13518544.74,13551552.760000002,33008.03,782899.57000000007,9460987.3195493594,9676254.184394177,215266.86484481601,1051299.6400254765,1318021.4235269455,1336687.2109425128,18665.787415567582,null,null,{"$f":"SUM(O5:O9)","v":8142965.8960224139},{"$f":"SUM(P5:P9)","v":8339566.9734516628},{"$f":"SUM(Q5:Q9)","v":196601.07742924843}]
["    i. Liquid/Money Market",12992930.449999999,13010038.91,17108.46,199403.71,9120427.8601326514,9184340.5854332205,63912.725300569087,277980.93078898673,1264864.1510368828,1230051.4505011439,-34812.700535738841,null,null,7855563.7090957686,7954289.1349320766,98725.425836307928]
["   ii. Gilt",12399.33,13158.46,759.13,16306.16,6940.2587660015688,5989.7260521362941,-950.53271386527467,16831.680701062942,492.00081070503438,1844.4763870044544,1352.47557629942,null,null,6448.2579552965344,4145.2496651318397,-2303.0082901646947]
["  iii. Debt (other than assured return)",513214.96,527952.89,14737.94,565459.56000000006,333619.20065070648,485923.87290881865,152304.6722581122,754661.4477842045,52665.271679357742,104791.28405436466,52126.012375007005,null,null,280953.92897134874,381132.58885445399,100178.6598831052]
["   iv. Debt (assured return)",0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0]
["   v. Infrastructure Development",0,402.5,402.5,1730.14,0,0,0,1825.5807512223473,0,0,0,null,null,0,0,0]
["B. Growth/Equity Oriented \n     Schemes (i+ii)",91249.38,165275.72,74026.34,386403.01,78748.235989378722,110373.2632262304,31625.027236851682,484802.26832667174,8869.4901676422414,18262.089950263391,9392.5997826211642,null,null,{"$f":"SUM(O11:O12)","v":69878.745821736477},{"$f":"SUM(P11:P12)","v":92111.173275966998},{"$f":"SUM(Q11:Q12)","v":22232.427454230517}]
["    i. ELSS",3566.16,9980.7099999999991,6414.55,41695.93,2536.1981126317214,5645.3936335392727,3109.1955209075513,52390.879360172512,297.67590861477629,1003.4344329597443,705.75852434496801,null,null,2238.5222040169451,4641.9592005795284,2403.4369965625833]
["   ii. Others",87683.22,155295.01,67611.789999999994,344707.08,76212.037876746996,104727.86959269112,28515.831715944129,432411.38896649925,8571.8142590274656,17258.655517303647,8686.8412582761957,null,null,67640.22361771953,87469.21407538747,19828.990457667933]
["C. Balanced Schemes",8744.35,28486.74,19742.39,39145.79,6989.8716495085446,22202.706012513921,15212.834363005377,61107.496975455033,806.84604863813638,4192.2068776202614,3385.3608289821259,null,null,6183.0256008704082,18010.49913489366,11827.473534023251]
["D. Exchange Traded Fund (i+ii)",12144.96,19966.310000000001,7821.34,22408.18,8587.1713131069282,13667.36610636958,5080.1947932626517,29990.315886858156,872.64680483572192,1832.8497685213704,960.20296368564857,null,null,{"$f":"SUM(O15:O16)","v":7714.5245082712063},{"$f":"SUM(P15:P16)","v":11834.516337848208},{"$f":"SUM(Q15:Q16)","v":4119.991829577003}]
["    i. Gold ETF",930.91,28.25,-902.67,6345.57,593.93228006451284,75.707385399000017,-518.22489466551281,6047.0326503379356,22.341432681291735,42.472300192000013,20.130867510708299,null,null,571.5908473832211,33.235085207000004,-538.35576217622111]
["    ii. Other ETFs",11214.05,19938.060000000001,8724.01,16062.61,7993.239033042415,13591.658720970579,5598.4196879281644,23943.283236520219,850.30537215443019,1790.3774683293705,940.07209617494027,null,null,7142.9336608879848,11801.281252641209,4658.3475917532242]
["E. Fund of Funds Investing Overseas",691.1,273.54000000000002,-417.56,1966.97,467.4069921592677,180.94875544600001,-286.45823671326769,1776.1026018941061,89.856805901032033,20.229961433848132,-69.626844467183901,null,null,377.55018625823567,160.71879401215187,-216.83139224608379]
["Total (A+B+C+D+E)",13631374.529999999,13765555.070000002,134180.53999999998,1232823.52,9555780.0054935124,9822678.4684947375,266898.46300122247,1628975.8238163556,1328660.2633539627,1360994.5875003517,32334.324146389336,null,null,{"$f":"O17+O14+O13+O10+O4","v":8227119.7421395499},{"$f":"P17+P14+P13+P10+P4","v":8461683.8809943832},{"$f":"Q17+Q14+Q13+Q10+Q4","v":234564.13885483312}]
["$ indicates as on October 31, 2016."]
["Source: SEBI.",null,null,null,null,null,"`",null,null,null,"`"]

{"sheet":"55","index":55,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,0,20,5],[0,0,0,16],[1,0,3,0],[1,1,1,8],[1,9,1,16],[2,1,2,4],[2,5,2,8],[2,9,2,12],[2,13,2,16]]}
["Table 55: Number of Schemes and Folios by Investment Objective           "]
["Type ","2015-16",null,null,null,null,null,null,null,"2016-17$"]
[null,"No. of Schemes",null,null,null,"No. of Folios",null,null,null,"No. of Schemes",null,null,null,"No. of Folios"]
[null,"Open","Closed","Interval","Total","Open","Closed","Interval","Total","Open","Closed","Interval","Total","Open","Closed","Interval","Total"]
["A. Income/Debt Oriented Schemes (i+ii+iii+iv)",355,1398,78,1831,7222545,1089531,11798,8323874,349,1295,71,1715,8395901,1123707,9773,9529381]
["    i. Liquid/Money Market",53,0,0,53,367194,0,0,367194,52,0,0,52,687558,0,0,687558]
["   ii. Gilt",41,0,0,41,65164,0,0,65164,41,0,0,41,74805,0,0,74805]
["  iii. Debt (other than assured return)",261,1391,78,1730,6790187,1089483,11798,7891468,256,1288,71,1615,7633538,1123659,9773,8766970]
["   iv. Debt (assured return)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["   v. Infrastructure Development",0,7,0,7,0,48,0,48,0,7,0,7,0,48,0,48]
["B. Growth/Equity Oriented \n     Schemes (i+ii)",358,115,0,473,34522147,1502915,0,36025062,359,117,0,476,36531799,1465245,0,37997044]
["    i. ELSS",42,18,0,60,6661986,616485,0,7278471,43,18,0,61,7021773,593839,0,7615612]
["   ii. Others",316,97,0,413,27860161,886430,0,28746591,316,99,0,415,29510026,871406,0,30381432]
["C. Balanced Schemes",28,0,0,28,2490458,0,0,2490458,29,0,0,29,2965961,0,0,2965961]
["D. Exchange Traded Fund (i+ii)",58,0,0,58,697614,0,0,697614,66,0,0,66,682183,0,0,682183]
["    i. Gold ETF",13,0,0,13,425914,0,0,425914,13,0,0,13,397280,0,0,397280]
["    ii. Other ETFs",45,0,0,45,271700,0,0,271700,53,0,0,53,284903,0,0,284903]
["E. Fund of Funds  Investing Overseas",30,0,0,30,126016,0,0,126016,29,0,0,29,113365,0,0,113365]
["Total (A+B+C+D+E)",829,1513,78,2420,45058780,2592446,11798,47663024,832,1412,71,2315,48689209,2588952,9773,51287934]
["Note: Data for No. of Schemes also includes serial plans."]
["$ indicates as on October 31, 2016."]
["Source: SEBI."]

{"sheet":"56","index":56,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,0,13,9],[1,0,2,0],[1,1,1,3],[1,4,1,6],[1,7,1,9],[12,0,12,5]]}
["Table 56: Trends in Transactions on Stock Exchanges by Mutual Funds (` crore)"]
["Year/  Month","Equity",null,null,"Debt",null,null,"Total"]
[null,"Gross Purchase","Gross \nSales","Net \nPurchase/Sales","Gross \nPurchase","Gross \nSales","Net Purchase/Sales","Gross\n Purchase","Gross\n Sales","Net Purchase/Sales"]
["2015-16","2,81,334","2,15,191",66144,"14,97,676","11,21,386","3,76,292","17,79,010","13,36,577","4,42,436"]
["2016-17$",179084.2,156944.4,22139.8,941868.39999999991,762879.4,178989,1120952.5999999999,919823.8,201128.8]
["2016-04-14",16445.599999999999,17021.3,-575.70000000000073,131311,95788.1,35522.899999999994,147756.6,112809.40000000001,34947.199999999997]
["2016-05-14",25928.3,18779.900000000001,7148.3999999999978,131681.1,133998.1,-2317,157609.4,152778,4831.3999999999978]
["2016-06-14",21006.3,21092.6,-86.299999999999272,148113.4,104059.7,44053.7,169119.69999999998,125152.29999999999,43967.399999999994]
["2016-07-14",24126.400000000001,24159.9,-33.5,111661.7,92008.8,19652.899999999994,135788.1,116168.70000000001,19619.399999999994]
["2016-08-14",29722.9,27006,2716.9000000000015,127544.9,123452,4092.8999999999942,157267.79999999999,150458,6809.7999999999956]
["2016-09-14",31271.1,27429.599999999999,3841.5,168344.3,114997.9,53346.399999999994,199615.4,142427.5,57187.899999999994]
["2016-10-14",30583.599999999999,21455.1,9128.5,123212,98574.8,24637.199999999997,153795.6,120029.9,33765.699999999997]
["$ indicates as on October 31, 2016."]
["Source: SEBI"]

{"sheet":"57","index":57,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,4,1,6],[5,6,12,6],[13,4,13,6],[0,0,0,3],[14,0,14,3],[1,1,1,3],[4,0,4,3],[5,3,12,3],[13,1,13,3]]}
["Table 57: Asset Under Management by Portfolio Manager"]
["Year/Month","2015-16",null,null,"$ 2016-17"]
["Particulars","Discretionary","Non-Discretionary","Advisory","Discretionary","Non-Discretionary","Advisory"]
["No. of Clients",46088,3915,2285,58695,4585,2133]
["AUM (` in crore)"]
["Listed  Equity",47320.73,10715.59,"1,74,272.34",65057.16,12520.17,"193210.5725*"]
["Unlisted  Equity",896.68,48.8,null,640.20000000000005,30.24]
["Plain Debt",738243.62,42418.65,null,807642.77,49617.15]
["Structured Debt",119.98,429.38,null,217.06,545.30999999999995]
["Equity Derivative",183.9,-2.34,null,182.79,-3.24]
["Mutual Fund",7284.27,6265.28,null,8076.44,7282.9]
["Others",16984.86,246.65,null,16904.43,319.47000000000003]
["Total",811034.04,60122.02,null,"898720.85#",70312]
["Total of all Services",1045428,null,null,1162243]
["Notes: 1. *Value of Assets for which Advisory Services are being given. \n2. #Of the above AUM ` 794683.47 crore is contributed by funds from EPFO/PFs. \n3. The above data is based on the monthly reports received from portfolio managers\n"]
["$ indicates as on October 31, 2016."]
["Source: SEBI."]

{"sheet":"58","index":58,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,2],[0,0,0,11],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11],[17,0,17,12]]}
["Table 58: Progress Report of NSDL & CDSl as on end of October 2016 (Listed Companies)"]
["Parameter","Unit","NSDL",null,null,null,null,"CDSL"]
[null,null,"2016-10-01","2016-09-01","2015-10-01","%\nChange during the year","%\nChange during the month","2016-10-01","2016-09-01","2015-10-01","%\nChange during the year","%\nChange during the month"]
["Number of companies signed up to make their shares available for dematerialization","Number",6259,6232,6086,2.8425895497863953,0.43324775353016687,6476,6450,6312,2.5982256020278833,0.40310077519379844]
["Number of Depository Participants (registered)","Number",268,267,269,-0.37174721189591076,0.37453183520599254,584,583,578,1.0380622837370241,0.17152658662092624]
["Number of Stock Exchanges (connected) ","Number",4,4,4,0,0,3,3,8,-62.5,0]
["Number of Investors Accounts","Lakh",151.06129999999999,150.26604,141.78809000000001,6.5401896590891209,0.52923468270008622,115.87045999999999,114.70441,102.16,13.420575567736881,1.016569458837719]
["Quantity of Shares dematerialized","crore",43811.0394046,43300.927601500007,40109.583032900002,9.2283591396696085,1.1780620678489166,13090.44,12844.06,12129.38,7.9234058129929261,1.9182408054774038]
["Value of Shares dematerialized","`crore",9775487.3638749458,9488482.4503398668,8461918.9615025446,15.523292155697469,3.0247715062675673,1424598.65,1354896.94,1226000.24,16.198888346057739,5.1444289187043228]
["Quantity of Securities dematerialized #","crore",46065.0086335327,45540.314356855204,43625.471165128198,5.5920025692571409,1.1521533921921929,13637.07,13376.03,12680.56,7.5431211239882163,1.9515506469408264]
["Value of Securities dematerialized #","`crore",11811845.766644884,11487436.043008538,10197803.101821836,15.827356624827354,2.8240394324875271,1490894.4790890822,1421636.9002324883,1277086.2782019502,16.741875982581163,4.8716784746701389]
["Quantity of shares settled during the month","crore",966.68532760000005,896.18584190000001,679.14703919999999,42.338149443853169,7.8666145350538415,622.48682369999995,609.01310409999996,491.64622629999997,26.61275331749658,2.2123858270523513]
["Average Quantity of shares settled daily (quantity of shares settled during the month (divided by 30))","crore",32.222844253333335,29.872861396666664,22.63823464,42.338149443853162,7.8666145350538503,20.749560789999997,20.300436803333334,16.388207543333333,26.612753317496562,2.2123858270523371]
["Value of shares settled during the month in dematerialized form","`crore",260976.91523804134,206005.85229282553,158252.39566210075,64.911825913382799,26.684223935093648,58253.593407646993,56832.87653853801,39954.255602779995,45.800722673440923,2.4998151697382478]
["Average Value of shares settled daily (value of shares settled during the month (divided by 30))","`crore",8699.2305079347116,6866.861743094184,5275.0798554033581,64.911825913382813,26.684223935093655,1941.7864469215665,1894.429217951267,1331.8085200926664,45.800722673440937,2.4998151697382518]
["Training Programmes conducted for representatives of Corporates, DPs and Brokers","Number",9,13,12,-25,-30.76923076923077,439,200,112,291.96428571428572,119.5]
["The ratio of dematerialized equity shares to the total outstanding shares (market value)","percent",85.092141553561873,85.30653925357457,85.152714990026595,-7.1135061837801064E-2,-0.25132621940669431,13.294773122583299,13.009009832003199,13.05,1.8756561117494142,2.1966567346048067]
["Notes: 1. Shares includes only equity shares. 2. Securities include common equity shares, preference shares, debenture, MF units, etc. 3. No. of days taken for calculating Daily Average is 30 days instead of Actual settlement days. 4. Quantity and value of shares mentioned are single sided. 5. #Source for listed securities information: Issuer/ NSE/BSE."]
["Source: NSDL and CDSL."]

{"sheet":"59","index":59,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,0,14,5],[0,0,0,10],[1,0,2,0],[1,1,1,5],[1,6,1,10],[12,0,13,10]]}
["Table 59: Progress of Dematerialisation at NSDL and CDSL (Listed and Unlisted Companies)"]
["Year/ Month","NSDL",null,null,null,null,"CDSL"]
[null,"Companies Live \n","DPs Live\n","DPs\nLocations ","Demat \nQuantity \n(million securities)","Demat Value (` crore)","Companies Live\n","DPs Live","DPs\nLocations\n","Demat \nQuantity \n(million securities)","Demat Value (` crore)"]
["2015-16",15638,270,26765,1100209,11715700,10021,583,16764,227549,1326797]
["2016-17$",16798,268,27289,1208883.8899999999,13585190.799999999,9663,584,17277,248719.3,1616084.25]
["2016-04-14",15752,270,26885,1091707.3600000001,11927604.034,9413,583,16773,227467.59999999998,1347615.2399999998]
["2016-05-14",15997,269,26955,1112579.8400000001,12176276.959000001,9444,581,16825,230135.4,1353991]
["2016-06-14",16135,268,26994,1140453.46,12482994.959000001,9480,580,16778,231682.4,1412513.78]
["2016-07-14",16292,267,27020,1154810,13008086,9525,582,16937,232550.2,1473746.47]
["2016-08-14",16432,268,27298,1166200,13259257.519000001,9578,583,17088,235332.5,1526825.25]
["2016-09-14",16600,267,27317,1184940,13313310,9621,583,17257,243268.7,1543363.7099999997]
["2016-10-14",16798,268,27289,1208883.8899999999,13585190.799999999,9663,584,17277,248719.3,1616084.25]
["Notes : 1. For CDSL, the current and historical data of Companies Live has been revised to exclude MF schemes count. 2. The Companies Live figure  includes only the number of mutual fund companies and not the mutual fund schemes. 3. DPs Locations' represents the total live (main DPs and branch DPs as well as non-live (back office connected collection centres)."]
[]
["$ indicates as on October 31, 2016."]
["Source: NSDL and CDSL."]
[]
[null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"60","index":60,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,2],[17,0,17,8],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,0,2,0],[1,1,2,1]]}
["Table 60: Depository Statistics for October 2016"]
["Particulars","Unit","Debt",null,"Equity",null,"Others",null,"Total"]
[null,null,"Listed","Unlisted","Listed","Unlisted","Listed","Unlisted","Listed","Unlisted"]
["NSDL"]
["Issuers(debt)/ Companies(equity), who have issued the active instument ","Number",738,980,6232,7988,61,3165,7031,12133]
["Active Instruments ","Number",11566,4081,12488,8484,7249,27685,31303,40250]
["Dematerialised Quantity ","Lakh",103773.44839999999,195626.67777000001,4330092.7601500005,5556379.1649500001,120165.22713551992,1543394.8041727301,4554031.4356855201,7295400.6468927301]
["Dematerialised Value ","`crore",1953284.3676956836,258775.96767961959,9488482.4503398668,570556.57046845707,45669.224972986704,996541.62836280628,11487436.043008538,1825874.1665108828]
["Quantity settled during the month ","Lakh",9713.2901199999997,2659.6310600000002,89618.584189999994,11.5967,391.43171528000005,621.60480383000117,99723.306025280006,3292.8325638300012]
["Value Settled during the month","`crore",336045.24142909999,23316.5609325,206005.85229282553,4.01339427,1778.7646071719998,146.51760304999985,543829.85832909751,23467.091929820002]
["CDSL"]
["Issuers(debt)/ Companies(equity), who have issued the active instument ","Number",540,266,6450,2322,2715,364,9705,2952]
["Active Instruments ","Number",22219,4739,8823,2828,39056,6187,70098,13754]
["Dematerialised Quantity ","Lakh",2274,20642,1284406,943686,50923,130756,1337603,1095084,null,null," "]
["Dematerialised Value ","`crore",48337.64,24340.1,1354896.94,77139.570000000007,18402.320232488481,20247.139767511522,1421636.9002324883,121726.80976751153]
["Quantity settled during the month ","Lakh",169.44900000000001,0,60901.310411799997,0,6597.4346193000001,0,67668.194029300008,0]
["Value Settled during the month","`crore",2556.3595592759998,0,56832.87653853801,0,2926.2445131478771,0,62315.48061096188,0]
["Note: The categories included in Others are Preference Shares, Mutual Fund Units, Warrants, PTCs, Treasury Bills, CPs, CDs and Government Securities. \n"]
["Source: NSDL and CDSL."]

{"sheet":"61 ","index":61,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4],[14,0,14,4]]}
["Table 61: Commodity Exchanges - Number of Permitted Commodities for trading"]
["Exchanges","Agriculture","Metals other than bullion","Bullion","Energy "]
["NCDEX"]
["No. of Permitted Commodities",17,2,2,1]
["No. of Commodities in which contracts have been floated ",16,0,0,0]
["MCX"]
["No. of Permitted Commodities",5,5,2,2]
["No. of Commodities in which contracts have been floated ",5,5,2,2]
["NMCE"]
["No. of Permitted Commodities",12,0,0,0]
["No. of Commodities in which contracts have been floated ",7,0,0,0]
["Regional Exchanges"]
["No. of Permitted Commodities",3,0,0,0]
["No. of Commodities in which contracts have been floated ",3,0,0,0]
["Note: 1. In Regional Exchanges, data pertaining to Rajkot Commodity Exchange, The Chamber of Commerce, Hapur and IPSTA, Kochi are considered."]
["Source: NCDEX, MCX, NMCE, RCE Rajkot, COC Hapur, IPSTA Kochi "]

{"sheet":"62 ","index":62,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,0,3,0],[2,1,2,4],[2,5,2,8]]}
["Table 62: Trends in MCXCOMDEX of MCX and Dhaanya of NCDEX"]
[]
["Year/  Month","MCXCOMDEX",null,null,null,"Dhaanya"]
[null,"Open","High","Low","Close","Open","High","Low","Close"]
["2015-16",2914.81,3289.94,2447,2730.93,2480.5394000000001,3042.61,2479.2485999999999,2857.18]
[" 2016-17$",2730.58,3203.42,2673.76,3144.78,2869.73,3411.86,2896.54,3193.98]
["2016-04-01",2730.58,3005.59,2673.76,2989.68,2869.73,3040.98,2896.54,2963.26]
["2016-05-01",2990.4,3005.91,2873.46,2956.18,2968.62,3027.34,2909.53,3020.86]
["2016-06-01",2955.46,3145.2,2932.38,3133.35,3027.78,3223.61,2999.01,3205.81]
["2016-07-01",3134.44,3201.96,3060.04,3090.79,3244.99,3411.86,3231.36,3311]
["2016-08-02",3091.42,3183.63,3063.41,3087.15,3314.7,3370.24,3136.19,3174.46]
["2016-09-03",3088.38,3203.42,3064.79,3187.24,3171.52,3232.78,3128.86,3153.19]
["2016-10-04",3186.54,3196.17,3134.63,3144.78,3152.97,3197.06,3089.9,3193.98]
["$ indicates as on October 31, 2016",null,null,null,null,null,null,null," "]
["Source: MCX and NCDEX"]
[]
[null,null,null,null,null,null,null,null," ",null," "]
[null,null,null,null," ",null," "]
[]
[]
[null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[null,null,null," "]

{"sheet":"63 ","index":63,"n_rows":21,"n_cols":20,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,19],[1,0,3,0],[1,1,3,1],[1,2,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,13],[1,14,1,16],[1,17,1,19],[2,2,3,2],[2,17,3,17],[2,18,3,18],[2,19,3,19],[2,13,3,13],[2,14,3,14],[15,0,15,3],[19,8,20,8],[21,8,22,8],[2,15,3,15],[2,16,3,16],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[13,0,13,11],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12]]}
["Table 63: Trends in Commodity Futures at MCX "]
["Year/  Month","No.of Trading days","Agriculture",null,null,"Metals",null,null,"Bullion",null,null,"Energy",null,null,"Total",null,null,"Open interest at the end of the period"]
[null,null,"Volume ('000 tonnes)","No of contracts","Turnover (` crore)","Volume ('000 tonnes)","No of contracts","Turnover (` crore)","Volume ('000 tonnes)","No of contracts","Turnover (` crore)","Volume ('000 tonnes)*","No of contracts","Turnover (` crore)","Volume ('000 tonnes)","No of contracts","Turnover (` crore)","Volume ('000 tonnes)","No of contracts","Value                (` crore)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Rs.crore)"]
["2015-16",257,13961.250669999998,3410594,121698.62040659999,89331.270549999987,63895652,1505003.5072135001,234.15931225899996,42602824,2070147.3709215997,807702.39506775548,124325369,1937344.7237064999,911229.07560001442,234234439,5634194.2222481994,604.91600015400002,303973,9080.0927888499991]
["2016-17$",152,10152.343769999998,1947253,85631.337514600018,55019.692500000005,37316537,949078.5573504999,142.84188694000002,24954809,1441883.8744990001,452328.68732274952,75354208,1211369.3720754997,517643.56547968951,139572807,3687963.1414395999,670.24587379450008,359834,12752.790932899999]
["2016-04-01",21,1459.4689900000005,267012,11370.337697200001,7707.452150000001,5030080,122098.02679375005,21.603740319,3864683,197366.20286279998,69850.992827300492,11401200,161826.80312000003,79039.517707619496,20562975,492661.37047375005,623.75407053350011,290246,10622.259107100001]
["2016-05-01",22,1434.9628999999989,260138,11074.817710800004,7484.2949999999983,5131198,120690.30555400004,19.261477336000006,3718692,210568.64563079999,68841.876850867498,11442218,178748.41132749993,77780.396228203492,20552246,521082.18022309989,692.91484626700003,348950,10260.503315399999]
["2016-06-01",22,1322.6939199999999,262629,11331.169823600001,9367.9550500000041,6320210,156899.52488500008,20.854397287000001,3947321,238497.79191440009,60924.305112597489,10341958,177930.37880599999,71635.808479884494,20872118,584658.86542900023,565.40385334550012,318214,12383.5748824]
["2016-07-01",21,1532.1267799999994,342677,15343.992475800005,8209.0193000000017,6093392,153069.70782399995,24.917249027000004,4046884,254030.70530980005,56469.722510489017,9505359,153865.36340499998,66235.785839516015,19988312,576309.76901459997,889.7751963505001,333822,12792.1236383]
["2016-08-01",22,1581.4127299999996,316558,13884.223708800002,7215.8751500000035,5090990,132997.91689849997,20.808250816000005,3467175,207573.10361419999,70692.975104175013,11469920,182349.072116,79511.071234991017,20344643,536804.3163375,693.46003181100014,364902,12939.972066550001]
["2016-09-01",22,1372.8760799999995,246691,11319.575940400002,7910.3077999999941,5148976,138440.41824299996,18.386698661000004,3027326,179256.59713180005,73905.34622851701,12047866,193609.62112599998,83206.916807178,20470859,522626.21244120004,725.99469260399985,327924,11831.010579350001]
["2016-10-01",22,1448.8023700000001,251548,11307.220158000002,7124.7880499999992,4501691,124882.65715224997,17.010073494000004,2882728,154590.82803519999,51643.468688803012,9145687,163039.72217499997,60234.069182297011,16781654,453820.42752044997,670.24587379450008,359834,12752.790932899999]
["Notes: 1. The following commodities are considered in each category: Agriculture: Cardamom, Cotton, Crude Palm Oil, Guarseed, Guargum, Kapas, Kapas Khalli, Mentha Oil, Potato; Metals: Aluminium, Copper, Lead, Nickel, Zinc and their variants; Bullion: Gold, Silver and their variants; Energy: Brent Crude Oil, Crude Oil, Crude Oil Mini, Natural Gas. 2. *Natural Gas volumes are in mm BTU and is not included for computing the Total Volume and Total Open Interest in '000 tonnes",null,null,null,null,null,null,null,null,null,null,null," ",null,null," "]
["$ indicates as on October 31, 2016"]
["Source: MCX"]
[]
[]
[]
[]
[null,null,null," "]

{"sheet":"64 ","index":64,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,3,0],[1,1,3,1],[1,2,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,13],[2,2,3,2],[2,3,3,3],[2,4,3,4],[14,0,14,13],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[13,0,13,13]]}
["Table 64: Trends in Commodity Futures at NCDEX "]
["Year/  Month","No.of Trading days","Agriculture",null,null,"Bullion",null,null,"Total",null,null,"Open interest at the end of the period"]
[null,null,"Volume\n('000 tonnes)","No of contracts","Turnover (` crore)","Volume \n('000 tonnes)","No of contracts","Turnover (` crore)","Volume ('000 tonnes)","No of contracts","Turnover (` crore)","Volume ('000 tonnes)","No. of Contracts","Value                  (` crore)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(Rs.crore)"]
["2015-16",257,217736.37825000001,29660148,998810.74024449976,0.64833600000000002,94494,20777.520091999999,217737.02658600002,29754642,1019588.2603364999,1021.8846,157469,4702.71]
["2016-17$",152,88214.729500000016,12993439,419871.33985399996,1.1819999999999999E-3,1182,322.25477000000001,88214.730682000023,12994621,420193.59462399996,835.87400000000002,107149,3713.35]
["2016-04-01",21,14855.088250000001,2068256,70598.387896999979,9.2499999999999993E-4,925,249.65218999999999,14855.089175000001,2069181,70848.040086999972,1087.6844000000001,166867,5392.1]
["2016-05-01",22,12577.441000000003,1832503,59416.250724000041,2.5700000000000001E-4,257,72.602579999999989,12577.441257000002,1832760,59488.85330400004,1017.5549999999999,163017,4962.6899999999996]
["2016-06-01",22,13428.188749999992,2017774,63960.07306399996,"-","-","-",13428.188749999999,2017774,63960.07306399996,1089.9459999999999,174010,5413.33]
["2016-07-01",21,14696.031250000011,2373342,72507.596498999977,"-","-","-",14696.031250000011,2373342,72507.596498999977,990.077,162322,5015.95]
["2016-08-01",22,13245.605500000007,1967593,64268.038164999984,"-","-","-",13245.605500000007,1967593,64268.038164999984,882.90899999999999,146400,4203.17]
["2016-09-01",22,10565.922250000011,1621875,49414.885409999995,"-","-","-",10565.922250000011,1621875,49414.885409999995,826.81799999999998,119885,3911.16]
["2016-10-01",22,8846.4524999999921,1112096,39706.108095000018,"-","-","-",8846.4524999999921,1112096,39706.108095000018,835.87400000000002,107149,3713.35,null,-9708.7773149999775,-19.647475116951764]
["Notes: 1. The following commodities are considered in each category: \nAgriculture: Bajra, Barley, CastorSeed, Chana, Cotton Cake, Cottonseed, Chilli, Coriander, Cotton, Crude palm oil, Guargum, Guarseed, Gur, Jeera, Kapas, Rapeseed Mustardseed, Shankar kapas, Sugar,  Soyabean, Refined Soyaoil Turmeric, Wheat, Maize."]
["2. Total for the year 2014-15 includes turnover in Metals of Copper, Steel, Bullion, Gold and Silver (Volume : 1622000 tonnes, No. of Contracts : 200 and Turnover : `7 crore) and Energy which include Brent Crude Oil and Curde Oil (Volume : 1,07,000 tonnes, Contract : 7,868 and Turnover `485 crore) "]
["$ indicates as on October 31, 2016"]
["Source: NCDEX"]

{"sheet":"65 ","index":65,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,6,3,6],[2,7,3,7],[0,0,0,7],[1,0,3,0],[1,1,3,1],[1,2,1,4],[1,5,1,7],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5]]}
["Table 65: Trends in Commodity Futures at NMCE "]
["Year/  Month","No.of Trading days","Agriculture",null,null,"Open interest at the end of the period"]
[null,null,"Volume ('000 tonnes)","No of contracts","Turnover (` crore)","Volume\n('000 tonnes)","No of contracts","Value                  (` crore)"]
[null,null,null,null,null,null,null,"(Rs.crore)"]
["2015-16",244,6027.6160750000008,825402,29367.632527099995,6.3766249999999998,4447,60.728803999999997]
["2016-17$",143,2783.1123500000003,468271,14653.877745500002,4.3065249999999997,2262,32.075479999999999]
["2016-04-01",18,359.07162499999998,69099,1979.7210480000001,5.1989999999999998,3530,56.242210999999998]
["2016-05-01",22,459.61487499999998,79134,2511.3697670000001,3.8029999999999999,2531,38.351548999999999]
["2016-06-01",22,439.79262499999999,72147,2405.1395229999998,4.3873749999999996,3007,48.252679000000001]
["2016-07-01",20,404.416,59181,2218.523549,3.7016249999999999,2339,38.577010000000001]
["2016-08-01",22,416.49599999999998,61628,2155.3945229999999,3.7138749999999998,2154,31.276779999999999]
["2016-09-01",20,331.21687500000002,51633,1619.3189319999999,3.653,2708,32.922797000000003]
["2016-10-01",19,372.50434999999999,75449,1764.4104035,4.3065249999999997,2262,32.075479999999999]
["$ indicates as on October 31, 2016"]
["Source: NMCE",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,39706.108095000018]
[null,null," ",null,null,null,null,null,null,1764.4104035]
[null,null,null,null,null,null,null,null,null,11307.220158000002]
[null,null,null,null,null,null,null,null,null,52777.73865650002]
[]
[]
[null,null,null,null,"`"," "]

{"sheet":"66 ","index":66,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,2,0],[1,1,1,4],[1,5,1,6]]}
["Table 66: Category-wise Share in Turnover at MCX and NCDEX (percent) "]
["Year/ Month","Percentage Share in Turnover at MCX",null,null,null,"Percentage Share in Turnover at NCDEX"]
[null,"Agriculture","Metals","Bullion","Energy","Agriculture","Bullion"]
["2015-16",2.1600004473761079,26.711956454581742,36.742563164525663,34.385479933516471,97.962165621135838,2.0378343788641393]
["2016-17$",2.2981087704238532,25.484215543459598,39.803223306242174,32.414452379874383,99.902663413127271,9.7336586872729322E-2]
["2016-04-01",2.3079417991035354,24.783357111262628,40.061229617619482,32.847471472014362,99.647623011598597,0.35237698840141818]
["2016-05-01",2.1253495381589045,23.161472438440864,40.409872688535543,34.303305334864703,99.877955993488428,0.12204400651158319]
["2016-06-01",1.9380822721786022,26.83608068952709,40.79264097695664,30.433196061337664,100,0]
["2016-07-02",2.6624557314091422,26.560318088260992,44.078847690566313,26.698378489763552,100,0]
["2016-08-03",2.5864590291540619,24.775865776548908,38.668300029781143,33.969375164515881,100,0]
["2016-09-04",2.165902832834576,26.489375187735288,34.29919756502224,37.045524414407886,100,0]
["2016-10-05",2.4915626252832079,27.518077543264081,34.064316778299677,35.926043053153023,100,0]
["$ indicates as on October 31, 2016",null,null,null,null,null,null," "]
["Source: MCX and NCDEX"]

{"sheet":"67 ","index":67,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,3,0],[1,1,1,4],[1,5,1,8],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8]]}
["Table 67: Category-wise Percentage Share of Turnover & Open Interest at MCX"]
["Year/ Month","Turnover",null,null,null," Open Interest at the end of period"]
[null,"Agriculture Commodities",null,"Non-Agriculture Commodities",null,"Agriculture Commodities",null,"Non-Agriculture Commodities"]
[null,"Pro","Client ","Pro","Client ","Pro","Client ","Pro","Client "]
["2015-16",44.858224741748472,55.141775258251528,23.442745365796817,76.55725463420319,13.204762538185649,86.795237461814352,27.917362161813553,72.082637838186443]
["2016-17$",35.660813783381023,64.339186216618984,19.609168078317083,80.390831921682917,13.755577538826715,86.244422461173286,17.489302656099561,82.510697343900446]
["2016-04-01",39.437017014932074,60.562982985067926,25.624842354669159,74.375157645330845,12.844698924040138,87.155301075959869,29.307520346504862,70.692479653495127]
["2016-05-01",39.758041719333512,60.241958280666495,23.299400876837179,76.700599123162817,13.769415824599241,86.230584175400764,28.758780129031713,71.24121987096828]
["2016-06-01",38.807555945736659,61.192444054263341,19.86661946381772,80.133380536182287,15.807788047673277,84.19221195232673,28.292447481001819,71.707552518998185]
["2016-07-01",33.075617914987248,66.924382085012752,21.229555889139508,78.770444110860495,14.702094462873424,85.297905537126567,20.205327272547233,79.794672727452763]
["2016-08-01",34.546479727634392,65.453520272365608,16.450806458135439,83.549193541864568,18.3025883443987,81.697411655601286,19.645927951839898,80.354072048160106]
["2016-09-01",32.43105175343058,67.56894824656942,13.763663484683693,86.23633651531631,13.550901678940605,86.449098321059395,15.727401276203043,84.27259872379696]
["2016-10-01",32.806831813347628,67.193168186652372,16.912059755095001,83.087940244904999,13.755577538826715,86.244422461173286,17.489302656099561,82.510697343900446]
["1. All trades executed under client codes other than *OWN* (proprietary account) is treated as client trades and is computed at client Level.  "]
["2. All Commodities falling under the category Energy, Bullion and Metals are treated as Non-Agri wheresas all other commodities are treated as Agri.  "]
["3. Profile of participants as hedgers or otherwise is not available with the Exchange"]
["$ indicates as on October 31, 2016"]
["Source: MCX"]
[null,null,null,null,null," ",null,null," "]

{"sheet":"68 ","index":68,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,1,5],[1,6,1,10],[2,4,2,5],[2,6,2,8],[2,9,2,10]]}
["Table 68: Category-wise  Percentage Share of Turnover & Open Interest at NCDEX"]
["Year/ Month","Turnover (Percent)",null,null,null,null," Open Interest at the end of period (Percent)"]
[null,"Agriculture Commodities",null,null,"Non-Agriculture Commodities",null,"Agriculture Commodities",null,null,"Non-Agriculture Commodities"]
[null,"Pro","Client ","Hedgers","Pro","Client ","Pro","Client ","Hedgers","Pro","Client "]
["2015-16",49.151891974707191,50.518260231711459,0.32984779358134658,79.275588489706465,20.724411510293542,25.502831243585049,70.2485642142004,4.2486045422145473,56.337924016431984,43.662075983568023]
["2016-17$",39.913907133846472,59.770338787283947,0.31575407886959,73.638115581656095,26.361884418343905,22.4006742747241,75.828268021592137,1.7710577036837387,0,0]
["2016-04-01",44.469180578603783,55.20268208441059,0.32813733698562936,74.16895882227189,25.831041177728096,24.883572601189499,70.709476077149546,4.4069513216609444,36.860487048586712,63.139512951413288]
["2016-05-01",42.801674139319132,56.834719221415966,0.36360663926489661,71.812751006920152,28.187248993079862,24.034213609537034,71.308028257108788,4.657758133354176,0,0]
["2016-06-01",41.209181680618251,58.266832176237962,0.52398614314378267,0,0,23.072844055454901,72.731130399463396,4.1960255450817101,0,0]
["2016-07-01",36.648404347352127,63.135168664198225,0.21642698844963731,0,0,22.801009823652635,73.832775651790399,3.3662145245569652,0,0]
["2016-08-01",37.404656402895561,62.209342052506024,0.38600154459841729,0,0,21.908367126445448,75.138893373933456,2.9527394996210985,0,0]
["2016-09-01",38.060288851128185,61.846171809224472,9.3539339647332423E-2,0,0,19.236648314113083,77.629804035003417,3.1335476508835067,0,0]
["2016-10-01",37.73825823384314,62.030810426120674,0.23093134003618598,0,0,22.400674274724121,75.828268021592137,1.7710577036837385,0,0]
["$ indicates as on October 31, 2016"]
["Source: NCDEX"]

{"sheet":"69 ","index":69,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,2],[1,3,1,4],[13,0,13,4]]}
["Table 69: Category-wise Percentage Share of Turnover & Open Interest at NMCE"]
["Year/    Month","Turnover",null," Open Interest at the end of Period"]
[null,"Pro","Client ","Pro","Client "]
["2015-16",3.8906086004571363,96.109391399542858,1.4449764599121797,98.555023540087817]
["2016-17$",5.0923331302470771,94.907666869752916,0.71672080100931468,99.283279198990684]
["2016-04-01",6.7860434749492038,93.213956525050804,1.3431997811721685,98.65680021882784]
["2016-05-01",5.3092318682834572,94.690768131716538,0.72825739610138418,99.271742603898616]
["2016-06-01",5.4440870372741372,94.55591296272587,1.064265977359836,98.935734022640162]
["2016-07-01",5.1525770844995433,94.847422915500459,2.1894841494000947,97.810515850599913]
["2016-08-01",5.4837630530621881,94.516236946937809,1.9962083193933313,98.003791680606668]
["2016-09-01",4.6047545376317505,95.395245462368251,1.5420251489080079,98.45797485109199]
["2016-10-01",2.2972932328892837,97.702706767110712,0.71672080100931468,99.283279198990684]
["$ indicates as on October 31, 2016"]
["Notes: Profile of participants as hedgers or otherwise is not available with the Exchange"]
["Source: NMCE"]
[null,null,null,null,null,null,null,null," "]

{"sheet":"70","index":70,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[40,0,40,4],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,5,0],[26,0,26,5],[30,0,30,5],[35,0,35,5],[0,4,0,5],[11,0,11,5],[16,0,16,5],[21,0,21,5],[39,0,39,3]]}
["Table 70: Macro Economic Indicators"]
["I. GDP at constant prices (2011-12 prices) for 2015-16 (`crore)*                         ",null,null,null,null,11350249]
["II. Gross Saving as a percent of Gross national Disposable Income at current market prices in 2014-15  @             ",null,null,null,null,32.299999999999997]
["III. Gross Capital Formation as a percent of GDP at current market prices in 2014-15@",null,null,null,null,34.200000000000003]
["IV.  Monetary and Banking Indicators                  ","June","July","August","September","October"]
[null,2016,2016,2016,2016,2016]
["Cash Reserve Ratio (percent)",4,4,4,4,4]
["Repo Rate (percent)",6.5,6.5,6.5,6.5,6.25,null,null,null,null,null,null,null,null,null,null,null,"`"]
["Money Supply (M3)  (` crore)",11936600,12043490,12110260,12530540,12415090]
["Aggregate Deposit (` crore)",9595530,9674050,9726260,10143080,9983920]
["Bank Credit (` crore)",7255950,7267670,7275600,7520539.9999999991,7412380]
["V. Interest Rate                        "]
["Call Money Rate (Weighted Average)",6.33,6.39,6.4,6.43,6.18]
["91-Day-Treasury Bill (Primary Yield)",6.77,6.56,6.56,6.52,6.36]
["Base rate (percent)","9.3-9.7","9.3-9.7","9.3-9.7","9.3-9.65","9.30-9.65"]
["Term Deposit Rate > 1 year (Maximum) ","7.00-7.60","7.00-7.50","7.00-7.50","7.00-7.30","6.50-7.30"]
["VI. Capital Market Indicators (`crore)"]
["Turnover (BSE+NSE) ",444224.34608997399,475364.28,544710,534835,449672.45]
["Market Cap-BSE ",10285548.67,10863580.76,11099423,11073648.1,11406693.23]
["Market Cap-NSE ",10100336.483002899,10675211.06521,10910696.318185899,10866063.126100799,11161048.803785]
["Net FPI Investment in Equity ",3712.8799999999997,12611.820000000002,9071.32,10443,-4306.26]
["VII. Exchange Rate and Reserves"]
["Forex Reserves (USD million)","3,60,797.6",365495.7,366776.6,371990.3,"3,67,157.1"]
["Re/ Dollar",63.6,67.03,67.03,66.66,66.86]
["Re/Euro",71.23,74.27,75.739999999999995,74.75,72.91]
["Forward Premia of USD  6-month",6.12,6.03,5.85,5.85,5.35]
["VIII.  Public Borrowing and Inflation"]
["Govt. Market Borrowing-Gross (` crore) 2016-17",150000,225000,285000,234160,276150]
["Wholesale Price Index (2004-05=100)",182,183.9,183.1,182.8,182.9,"http://mospi.nic.in/"]
["Consumer Price Index (2012 =100)",130.1,131.1,131.1,130.80000000000001,131.4]
["IX.  Index of Industrial Production (y-o-y) percent (Base year 2004-05 = 100)"]
["General",183,176.1,175.3,179.5,"NA","http://mospi.nic.in/"]
["Mining",127.3,118.7,113.5,115.6,"NA","http://mospi.nic.in/"]
["Manufacturing",191.3,184.5,184.3,188.6,"NA","http://mospi.nic.in/"]
["Electricity",198.9,193.3,194.6,200.4,"NA","http://mospi.nic.in/"]
["X. External Sector Indicators (USD million)"]
["Exports ",22572.3,21689.57,21518.6,22880.560000000001,23512.7,"commerce.nic.in"]
["Imports",30688.54,29450.97,29192.74,31220.13,31033.4,"commerce.nic.in"]
["Trade Balance",-8116.24,-7761.4000000000015,-7674.1400000000031,-8339.57,-7520.7000000000007,{"$error":"#VALUE!"},0,0,0]
["Notes: 1. * : Provisional  estimates; Data as per the new series released by MOSPI"]
["2. CPI Data ia being released on Base 2012=100 from January 2015 by MOSPI "]
["3. @ First Revised Estimates"]
["Source :  RBI, MOSPI,  Ministry of Commerce & Industry."]