{"text_format":"1","workbook":"xlsx","n_sheets":81,"sheets":["Tables","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","20","19","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","71","72","73","74","75","76","77","78","79","80"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":3,"defined_names":83,"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":88,"n_cols":2,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["Tables","Link"]
["Table 1: SEBI Registered Market Intermediaries/Institutions","Click Here for Table 1"]
["Table 2: Company-Wise Capital Raised through Public and Rights Issues (Equity) during December-2017","Click Here for Table 2"]
["Table 3: Open Offers under SEBI Takeover Code closed during December-2017","Click Here for Table 3"]
["Table 4: Substantial Acquisition of Shares and Takeovers","Click Here for Table 4"]
["Table 5: Capital Raised from the Primary Market through though Public and Rights Issues ","Click Here for Table 5"]
["Table 6: Issues Listed on SME Platform","Click Here for Table 6"]
["Table 7: Industry-wise Classification of Capital Raised through Public and Rights Issues ","Click Here for Table 7"]
["Table 8: Sector-wise and Region-wise Distribution of Capital Mobilised through Public and Rights Issues ","Click Here for Table 8"]
["Table 9: Size-wise Classification of Capital Raised through Public and Rights Issues ","Click Here for Table 9"]
["Table 10: Capital Raised by Listed Companies from the Primary Market through QIPs","Click Here for Table 10"]
["Table 11: Preferential Allotments Listed at BSE and NSE","Click Here for Table 11"]
["Table 12: Private Placement of Corporate Debt Reported to BSE and NSE","Click Here for Table 12"]
["Table 13: Trading in the Corporate Debt Market","Click Here for Table 13"]
["Table 14: Ratings Assigned for Long-term Corporate Debt Securities (Maturity ≥ 1 year)","Click Here for Table 14"]
["Table 15: Review of Accepted Ratings of Corporate Debt Securities (Maturity ≥ 1 year)","Click Here for Table 15"]
["Table 16: Distribution of Turnover on Cash Segments of Exchanges (₹ crore)","Click Here for Table 16"]
["Table 17: Trends in Cash Segment of BSE ","Click Here for Table 17"]
["Table 18: Trends in Cash Segment of NSE ","Click Here for Table 18"]
["Table 19: Trends in Cash Segment of MSEI","Click Here for Table 19"]
["Table 20: City-wise Distribution of Turnover on Cash Segments of BSE and NSE","Click Here for Table 20"]
["Table 21: Category-wise Share of Turnover in Cash Segment of BSE","Click Here for Table 21"]
["Table 22: Category-wise Share of Turnover in Cash Segment of NSE","Click Here for Table 22"]
["Table23: Category wise Share of Turnover in Cash Segment of MSEI","Click Here for Table 23"]
["Table 24: Component Stocks: S&P BSE Sensex during December-2017","Click Here for Table 24"]
["Table 25: Component Stocks: Nifty 50 Index during December-2017","Click Here for Table 25"]
["Table :26: Component Stock: SX 40 Index","Click Here for Table 26"]
["Table 27: Advances/Declines in Cash Segment of BSE and NSE","Click Here for Table 27"]
["Table 28: Trading Frequency in Cash Segment of BSE and NSE","Click Here for Table 28"]
["Table 29: Daily Volatility of Major Indices  (percent)","Click Here for Table 29"]
["Table 30: Percentage Share of Top ‘N’ Securities/Members in Turnover of Cash Segment  (percent)","Click Here for Table 30"]
["Table 31: Settlement Statistics for Cash Segment of BSE ","Click Here for Table 31"]
["Table 32: Settlement Stastics for Cash Segment of NSE","Click Here for Table 32"]
["Table 33: Settlement Statistics for Cash Segment of MSEI","Click Here for Table 33"]
["Table 34: Trends in Equity Derivatives Segment at BSE (Turnover in Notional Value) ","Click Here for Table 34"]
["Table 35: Trends in Equity Derivatives Segment at NSE ","Click Here for Table 35"]
["Table 36: Settlement Statistics in Equity Derivatives Segment at BSE and NSE (₹ crore)","Click Here for Table 36"]
["Table 37: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of BSE","Click Here for Table 37"]
["Table 38: Category-wise Share of Turnover & Open Interest in Equity Derivative Segment of NSE","Click Here for Table 38"]
["Table 39: Instrument-wise Turnover in Index Derivatives at BSE","Click Here for Table 39"]
["Table 40: Instrument-wise Turnover in Index Derivatives at NSE","Click Here for Table 40"]
["Table 41: Trends in Currency Derivatives Segment at NSE","Click Here for Table 41"]
["Table 42: Trends in Currency Derivatives Segment at MSEI","Click Here for Table 42"]
["Table 43: Trends in Currency Derivatives Segment at BSE","Click Here for Table 43"]
["Table 44: Settlement Statistics of Currency Derivatives Segment (₹ crore)","Click Here for Table 44"]
["Table 45: Instrument-wise Turnover in Currency Derivatives of NSE","Click Here for Table 45"]
["Table 46: Instrument-wise Turnover in Currency Derivative Segment of MSEI","Click Here for Table 46"]
["Table 47: Instrument-wise Turnover in Currency Derivative Segment of BSE","Click Here for Table 47"]
["Table 48: Maturity-wise Turnover in Currency Derivative Segment of NSE  (₹ crore)","Click Here for Table 48"]
["Table 49: Maturity-wise Turnover in Currency Derivative Segment of MSEI (₹ crore)","Click Here for Table 49"]
["Table 50: Maturity-wise Turnover in Currency Derivative Segment of BSE (₹ crore)","Click Here for Table 50"]
["Table 51: Trading Statistics of Interest Rate Futures at BSE, NSE and MSEI","Click Here for Table 51"]
["Table 52: Settlement Statistics in Interest Rate Futures at BSE, NSE and MSEI (₹ crore)","Click Here for Table 52"]
["Table 53: Trends in Foreign Portfolio Investment","Click Here for Table 53"]
["Table 54: Notional Value of Offshore Derivative Instruments (ODIs) Vs Assets Under Custody (AUC) of FPIs/Deemed FPIs (₹ crore)","Click Here for Table 54"]
["Table 55: Assets under the Custody of Custodians","Click Here for Table 55"]
["Table 56: Trends in Resource Mobilization by Mutual Funds (₹ crore)","Click Here for Table 56"]
["Table 57: Type-wise Resource Mobilisation by Mutual Funds: Open-ended and Close-ended (₹ crore)","Click Here for Table 57"]
["Table 58: Scheme-wise Resource Mobilisation and Assets under Management by Mutual Funds (₹ crore)","Click Here for Table 58"]
["Table 59: Number of Schemes and Folios by Investment Objective           ","Click Here for Table 59"]
["Table 60: Trends in Transactions on Stock Exchanges by Mutual Funds (₹ crore)","Click Here for Table 60"]
["Table 61: Asset Under Management by Portfolio Manager","Click Here for Table 61 "]
["Table 62: Progress Report of NSDL & CDSl as on end of December-2017 (Listed Companies)","Click Here for Table 62"]
["Table 63: Progress of Dematerialisation at NSDL and CDSL (Listed and Unlisted Companies)","Click Here for Table 63"]
["Table 64: Depository Statistics for December-2017","Click Here for Table 64"]
["Table 65 : Number of Commodities Permitted and traded at Exchanges","Click Here for Table 65"]
["Table 66: Trends in Commodity Indices","Click Here for Table 66"]
["Table 67: Trends in Commodity Futures at MCX ","Click Here for Table 67"]
["Table 68: Trends in Commodity Futures at NCDEX ","Click Here for Table 68"]
["Table 69: Trends in Commodity Futures at NMCE ","Click Here for Table 69"]
["Table 70:Trends in Commodity Options at MCX","Click Here for Table 70"]
["Table 71: Trends in Commodity Futures at ICEX","Click Here for Table 71"]
["Table 72: Category-wise Share in Turnover at MCX and NCDEX (percent) ","Click Here for Table 72"]
["Table 73: Participant-wise Percentage Share of Turnover & Open Interest at MCX","Click Here for Table 73"]
["Table 74: Partcipant-wise  Percentage Share of Turnover & Open Interest at NCDEX","Click Here for Table 74"]
["Table 75: Participant-wise Percentage Share of Turnover & Open Interest at NMCE","Click Here for Table 75"]
["Table 76: Participants -wise Percentage Share of Turnover & Open Interest at ICEX","Click Here for Table 76"]
["Table 77: Commodity-wise monthly turnover and trading volume at MCX","Click Here for Table 77"]
["Table 78: Commodity-wise monthly turnover and trading volume at NCDEX ","Click Here for Table 78"]
["Table 79: Commodity-wise monthly turnover and trading volume at NMCE ","Click Here for Table 79"]
["Table 80: Macro Economic Indicators","Click Here for Table 80"]
[]
["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 may 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":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,2],[41,0,41,2],[42,0,42,2]]}
["Table 1: SEBI Registered Market Intermediaries/Institutions"]
["Market Intermediaries ","2016-17","2017-18$"]
["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)",10,9]
["Brokers (Cash Segment)*",3192,3202]
["Corporate Brokers (Cash Segment)*",2775,2788]
["Brokers (Equity Derivatives Market) ",2651,2668]
["Brokers (Currency Derivatives Market)",1985,2310]
["Brokers (Debt Segment)",6,142]
["Brokers (Commodity Derivatives Market)",1162,"**"]
["Sub-brokers (Cash Segment)*",30610,25642]
["Foreign Portfolio Investors (FPIs)",7807,9042]
["Deemed FPIs",974,0]
["Custodians",19,19]
["Depositories",2,2]
["Depository Participants-NSDL                                 ",276,"***"]
["Depository Participants-CDSL",588,"***"]
["Merchant Bankers",189,188]
["Bankers to an Issue",64,65]
["Underwriters",2,1]
["Debenture Trustees",32,32]
["Credit Rating Agencies",7,7]
["KYC Registration Agency (KRA)",5,5]
["Registrars to an Issue & Share Transfer Agents",73,73]
["Venture Capital Funds",198," 196"]
["Foreign Venture Capital Investors",218," 220"]
["Alternative Investment Funds",303,364]
["Portfolio Managers",218," 261"]
["Mutual Funds",45,45]
["Investment Advisors",577," 817"]
["Research Analysts",351," 456"]
["Infrastructure Investment Trusts (InVIT)",6,1]
["Real Estate Investment Trusts (REITs)",0,6]
["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"]
["2. ** The data regarding registered Brokers in comodity derivatives as on December 31, 2017 could not be obtained as their systems are not functioning after migration in share portal."]
["3. *** The division has informed that they are in discussion with Depositories to iron out discrepancies in the figures and hence, will not be able to provide the data as on December 31, 2017"]
["$ indicates as on December 31, 2017"]
["Source: SEBI, NSDL."]
["NA - Data not available"]

{"sheet":"2","index":2,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Table 2: Company-Wise Capital Raised through Public and Rights Issues (Equity)"]
["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,"Ratnabhumi Developers Ltd","2017-12-04","SME IPO","Equity",3700000,10,53,63,23.31]
[2,"Dynamic Cables Ltd","2017-12-04","SME IPO","Equity",5844000,10,30,40,23.38]
[3,"Shalby Ltd","2017-12-05","IPO","Equity",20354839,10,238,248,504.8]
[4,"MRC Exim Ltd","2017-12-06","SME IPO","Equity",3000000,10,5,15,4.5]
[5,"Future Supply Chain Solutions Ltd","2017-12-06","IPO","Equity",9784570,10,654,664,649.70000000000005]
[6,"Touchwood Entertainment Ltd","2017-12-11","SME IPO","Equity",1053000,10,30,40,4.21]
[7,"Kids Medical Systems Ltd","2017-12-11","SME IPO","Equity",2000000,10,20,30,6]
[8,"Diggi Multitrade Ltd","2017-12-11","SME IPO","Equity",2600000,10,3,13,3.38]
[9,"Lakshmi Vilas Bank Ltd","2017-12-12","Rights","Equity",64497155,10,112,122,786.87]
[10,"SMVD Poly Pack Ltd","2017-12-13","SME IPO","Equity",1640000,10,45,55,9.02]
[11,"One Point One Solutions Ltd","2017-12-13","SME IPO","Equity",6624000,10,57,67,44.38]
[12,"Astron Paper & Board Mill Ltd","2017-12-15","IPO","Equity",14000000,10,40,50,69.83]
[13,"Ajooni Biotech Ltd","2017-12-20","SME IPO","Equity",2196000,10,20,30,6.59]
[14,"Moksh Ornaments Ltd","2017-12-21","SME IPO","Equity",2982000,10,27,37,11.03]
[15,"Sumeet Industries Ltd","2017-12-27","Rights","Equity",24874173,10,14,24,59.7]
[16,"Jhandewalas Foods Ltd","2017-12-29","SME IPO","Equity",2910000,10,45,55,16.010000000000002]
[17,"Rithwik Facility Management Services Ltd","2017-12-29","SME IPO","Equity",810000,10,40,50,4.05]
[18,"Brand Concepts Ltd","2017-12-29","SME IPO","Equity",2805000,10,35,45,12.62]
[]
["Note: 1. All the issues are compiled from the Prospectus’ of Issuer Companies filed with SEBI."]
["Source: SEBI."]

{"sheet":"3","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,8,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"]
["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,"UNION QUALITY PLASTICS LTD","JAVVARI KAPISH RAJESH SINGH AND OTHERS","2017-12-04","2017-12-15",1230800,26,40.4]
[2,"TRC FINANCIAL SERVICES LTD.","JUPITER CAPITAL PVT LTD","2017-12-06","2017-12-19",1300234,26,18]
[3,"Confidence Futuristic Energetech Ltd( Formerly Globe Industrial Resources Ltd.)","Confidence Petroleum India Ltd.","2017-12-07","2017-12-20",993200,49.66,30]
[4,"OTCO INTERNATIIONAL LTD","Mr. PRADEEP KUMAR PANDA","2017-12-13","2017-12-27",674343,26,37]
[]
["Source: SEBI."]

{"sheet":"4","index":4,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,0,17,5],[18,0,18,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)"]
["2016-17",42,5338.1431000000002,4,78.297700000000006,3,365.63040000000001,49,5782.0712000000012]
["2017-18$",35,1487.39,3,38.17,4,220.93,42,1746.4899999999998]
["2017-04-01",9,586.92999999999995,0,0,0,0,9,586.92999999999995]
["2017-05-01",4,438.1,1,2.9,0,0,5,441]
["2017-06-01",5,72.62,0,0,1,2.2400000000000002,6,74.86]
["2017-07-01",3,13.18,0,0,0,0,3,13.18]
["2017-08-01",1,1.25,0,0,1,123.77,2,125.02]
["2017-09-01",3,0.75,0,0,0,0,3,0.75]
["2017-10-01",2,6.33,1,32.770000000000003,2,94.92,5,134.02000000000001]
["2017-11-01",5,357.94,0,0,0,0,5,357.94]
["2017-12-01",3,10.29,1,2.5,0,0,4,12.79]
[]
["$ indicates as on December 31, 2017"]
["Source: SEBI."]

{"sheet":"5","index":5,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[18,0,18,14],[20,0,20,5],[2,11,2,14],[2,15,3,16],[2,17,3,18],[3,11,3,12],[3,13,3,14],[17,0,17,18],[19,0,19,14],[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]]}
["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)"]
["2016-17",133,61848.23,121,58432.850000000006,12,3415.38,28,32753.130000000005,105,29095.230000000003,1,2.6,117,32517.989999999998,0,0,15,29327.64]
["2017-18$",153,72786.710000000006,139,68265.570000000007,14,4521.1399999999994,20,8658.39,133,64128.32,1,2.0099999999999998,147,68632.37000000001,0,0,5,4124.6499999999996]
["2017-04-30",12,3200.37,10,2832.5299999999997,2,367.84,3,2336.56,9,863.81,0,0,11,1231.6500000000001,0,0,1,1968.72]
["2017-05-31",7,1480.08,7,1480.08,0,0,0,0,7,1480.08,0,0,7,1480.08,0,0,0,0]
["2017-06-30",15,5631.56,14,5511.85,1,119.71,1,119.71,14,5511.85,0,0,15,5631.56,0,0,0,0]
["2017-07-31",15,2820.3999999999996,14,2621.4299999999994,1,198.97,3,1911.4899999999998,12,908.91,0,0,13,1107.8800000000001,0,0,2,1712.52]
["2017-08-31",12,1919.6799999999998,12,1919.6799999999998,0,0,1,214.62,11,1705.06,1,2.0099999999999998,10,1703.05,0,0,1,214.62]
["2017-09-30",42,17162.96,40,17141.73,2,21.23,2,21.23,40,17141.73,0,0,42,17162.96,0,0,0,0]
["2017-10-31",11,18607.52,9,16204.78,2,2402.7399999999998,2,2402.7399999999998,9,16204.78,0,0,11,18607.52,0,0,0,0]
["2017-11-30",20,19495.97,16,18931.89,4,564.08000000000004,5,576.67999999999995,15,18919.29,0,0,20,19485.97,0,0,0,0]
["2017-12-31",19,2468.17,17,1621.6,2,846.57,3,1075.3600000000001,16,1392.81,0,0,18,2239.38,0,0,1,228.79]
[]
["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."]
["6. The figures of public debt issue have been taken as per the closing dates of the issues."]
["$ indicates as on December 31, 2017"]
["Source: SEBI."]

{"sheet":"6","index":6,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[18,0,18,3],[1,0,3,0],[1,1,2,2],[17,0,17,2]]}
["Table 6: Issues Listed on SME Platform"]
["Year/ Month","Total"]
[]
[null,"No. of issue","Amount               (₹ crore)"]
["2016-17",79,1105.2845000000002]
["2017-18$",104,1389.0208]
["2017-04-30",8,135.26060000000001]
["2017-05-31",5,44.048000000000002]
["2017-06-30",9,72.689800000000005]
["2017-07-31",10,98.575199999999995]
["2017-08-31",9,110.79119999999999]
["2017-09-30",33,475.32999999999993]
["2017-10-31",3,46.996000000000002]
["2017-11-30",14,236.85]
["2017-12-31",13,168.48000000000002]
[]
["$ indicates as on December 31, 2017"]
["Source: SEBI"]

{"sheet":"7","index":7,"n_rows":31,"n_cols":8,"rows_kept":31,"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","2017-18$",null,"2017-12-01"]
[null,"No. of issues","Amount (₹ crore)","No. of issues","Amount (₹ crore)"]
["Airlines",0,0,0,0]
["Automobile",0,0,0,0]
["Banking and Finance",7,5814.2599999999993,2,1015.66]
["Cement & Construction",13,1656.7900000000002,2,26.69]
["Chemical",2,19.580000000000002,0,0]
["Consumer Services",2,791.47,0,0]
["Electrical Equipment/ Production",3,21.560000000000002,0,0]
["Engineering",13,1633.8500000000001,0,0]
["Electronics",1,599.28,0,0]
["Entertainment",2,498.97,0,0]
["Financial Services",8,15076.630000000001,0,0]
["Food Processing",8,1862.3999999999999,1,16.010000000000002]
["Healthcare and pharma",11,2510.6799999999998,2,510.8]
["Hotels",0,0,0,0]
["Information Technology ",13,914.8,1,44.38]
["Misc.",57,21535.25,9,785.91,null,null,"72,"]
["Roads & Highways",0,0,0,0]
["Telecommunication",1,776.69,0,0]
["Textile",5,141.13,1,59.7]
["Plastic",3,24.54,1,9.02]
["Power",0,0,0,0]
["Printing",1,18.28,0,0]
["Oil & Natural Gas",1,728.56,0,0]
["Insurance",2,18161.98,0,0]
["Total",153,72786.7,19,2468.1699999999996]
[]
["$ indicates as on December 31, 2017"]
["Source: SEBI."]

{"sheet":"8","index":8,"n_rows":18,"n_cols":15,"rows_kept":18,"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)"]
["2016-17",133,61848.23,117,31396.599999999995,16,30451.63,21,5480.04,8,1215.3400000000001,80,44374.51,24,10778.34]
["2017-18$",153,72786.710000000006,143,36966.479999999996,10,35820.230000000003,38,7706.4100000000008,5,1759.81,93,55960.229999999996,17,7360.2499999999991]
["2017-04-30",12,3200.37,11,1231.6500000000001,1,1968.72,3,833.19,0,0,8,398.46,1,1968.72]
["2017-05-31",7,1480.08,6,255.73,1,1224.3499999999999,3,1247.1300000000001,0,0,4,232.94,0,0]
["2017-06-30",15,5631.56,15,5631.56,0,0,3,1918.24,0,0,10,2816.92,2,896.4]
["2017-07-31",15,2820.3999999999996,13,1107.8800000000001,2,1712.5199999999998,4,823.82,1,561.9899999999999,9,1235.6199999999999,1,198.97]
["2017-08-31",12,1919.68,10,263.05,2,1656.63,2,27.14,0,0,6,72.67,4,1819.87]
["2017-09-30",42,17162.96,41,8776.56,1,8386.4,13,1299.8800000000001,1,600.65,23,14708.59,5,553.84]
["2017-10-31",11,18607.52,10,7431.68,1,11175.84,2,1017.34,0,0,8,16687.439999999999,1,902.74]
["2017-11-30",20,19495.97,19,10028.99,1,9466.98,4,530.65,2,546.98,14,18418.34,0,0]
["2017-12-31",19,2468.17,18,2239.38,1,228.79,4,9.02,1,50.19,11,1389.25,3,1019.7099999999999]
[]
["$ indicates as on December 31, 2017"]
["Source: SEBI."]

{"sheet":"9","index":9,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,0,15,5],[16,0,16,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)"]
["2016-17",133,61848.23,26,89.740000000000009,25,175.16,33,701.9799999999999,4,264.09000000000003,45,60617.26]
["2017-18$",153,72786.706000000006,20,73.849999999999994,28,182.40600000000001,60,1187.1600000000001,4,255.88,41,71087.41]
["2017-04-30",12,3200.38,2,6.59,3,18.809999999999999,2,51.36,2,126.35,3,2997.27]
["2017-05-31",7,1480.07,2,6.8,1,5.07,2,32.17,0,0,2,1436.03]
["2017-06-30",15,5631.5599999999995,2,5.56,4,26.52,3,40.61,0,0,6,5558.87]
["2017-07-31",15,2820.3999999999996,2,7.53,4,22.4,5,104.52,0,0,4,2685.95]
["2017-08-31",12,1919.68,2,6.07,1,5.57,6,99.16,0,0,3,1808.88]
["2017-09-30",42,17162.960000000003,4,16.45,9,58.34,22,422.57,0,0,7,16665.600000000002]
["2017-10-31",11,18607.516,0,0,1,6.3959999999999999,2,40.6,0,0,8,18560.52]
["2017-11-30",20,19495.97,2,8.7100000000000009,2,17.690000000000001,12,265.44,0,0,4,19204.13]
["2017-12-31",19,2468.17,4,16.14,3,21.61,6,130.72999999999999,2,129.53,4,2170.16]
[]
["$ indicates as on December 31, 2017"]
["Source: SEBI."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"10","index":10,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[16,0,16,5],[17,0,17,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[15,0,15,8]]}
["Table 10: Capital Raised by Listed Companies from the Primary Market through QIPs"]
["Year/           Month","Only NSE",null,"Only 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)"]
["2016-17",0,0,0,0,20,8464.3492404999997,20,8464.3492404999997]
["2017-18$",0,0,0,0,37,57711.219713614992,37,57711.219713614992]
["2017-04-01",0,0,0,0,2,5206.6468875,2,5206.6468875]
["2017-05-01",0,0,0,0,5,7298.04,5,7298.04]
["2017-06-01",0,0,0,0,1,15000,1,15000]
["2017-07-01",0,0,0,0,4,2774.66,4,2774.66]
["2017-08-01",0,0,0,0,1,873.92232000000001,1,873.92232000000001]
["2017-09-01",0,0,0,0,3,5500.1516910850005,3,5500.1516910850005]
["2017-10-01",0,0,0,0,6,7280.38,6,7280.38]
["2017-11-01",0,0,0,0,7,2740.8988150299997,7,2740.8988150299997]
["2017-12-01",0,0,0,0,8,11036.52,8,11036.52]
[]
["Notes: 1. The above data includes both \"no. of issues\" and \"Amount\" raised on conversion of convertible securities issued on QIP basis. \n2. Aug-17, Includes one issue of Institutional Placement Programme (Issue Size of Rs. 873.92 crore)."]
["$ indicates as on December 31, 2017"]
["Source: BSE and NSE."]
[]
[]
[]
[]
[]
[null,null," "]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"11","index":11,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,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],[15,0,15,5]]}
["Table 11: Preferential Allotments Listed at BSE and NSE"]
["Year/ Month","Only BSE",null,"Only NSE",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)"]
["2016-17",188,2957,17,1219,205,40073,410,44250]
["2017-18$",143,2088.3599999999997,13,600.76700000000005,151,37978.024969999999,307,40667.151970000006]
["2017-04-01",18,426.95,0,0,23,1407.68,41,1834.63]
["2017-05-01",24,196.66,3,315.89699999999999,21,1864.3117999999999,48,2376.8688000000002]
["2017-06-01",19,108.84,0,0,21,4716.4335700000001,40,4825.2735700000003]
["2017-07-01",14,95.4,1,7.5,13,457.84,28,560.74]
["2017-08-17",13,276.36,2,32.11,15,5184.1256000000003,30,5492.5956000000006]
["2017-09-17",12,62.08,0,0,13,8081.73,25,8143.8099999999995]
["2017-10-01",9,142.81,1,2.8,13,2981.89,23,3127.5]
["2017-11-01",18,475.54,0,0,11,1037.424,29,1512.9639999999999]
["2017-12-01",16,303.72000000000003,6,242.46,21,12246.59,43,12792.77]
[]
["$ indicates as on December 31, 2017"]
["Source: BSE and NSE."]

{"sheet":"12","index":12,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,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],[15,0,15,5]]}
["Table 12: Private Placement of Corporate Debt Reported to BSE and NSE"]
["Year/ Month","Only NSE",null,"Only 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)"]
["2016-17",1023,219720.6,2177,254212.71000000002,177,166782.20000000001,3377,640715.51]
["2017-18$",581,129844.93,1238,182278.16,124,147937.70000000001,1943,460060.79000000004]
["2017-04-01",88,20353.77,194,24969.46,19,18495.5,301,63818.73]
["2017-05-01",156,12433.26,133,8226.41,12,12729.2,301,33388.870000000003]
["2017-06-01",95,20830.7,249,29706.62,26,24800,370,75337.320000000007]
["2017-07-01",60,13995.2,96,20890.95,6,14147,162,49033.15]
["2017-08-01",50,14841,94,19796.13,11,16915,155,51552.13]
["2017-09-01",33,12049.75,127,20926.37,10,17845,170,50821.120000000003]
["2017-10-01",26,11283.25,177,24988.02,10,7875,213,44146.27]
["2017-11-01",30,10840,99,20694,16,19321,145,50855]
["2017-12-01",43,13218,69,12080.2,14,15810,126,41108.199999999997]
[]
["$ indicates as on December 31, 2017"]
["Source: SEBI"]

{"sheet":"13","index":13,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,0,15,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 (₹ crore)","No. of Trades","Traded Value (₹ crore)","No. of Trades","Traded Value (₹ crore)"]
["2016-17",24372,292153.95,64123,1178508.53,0,0]
["2017-18$",21694,350236.38,45823,987927.94000000006,1,0.22]
["2017-04-01",2287,37605.480000000003,4718,101728.74,0,0]
["2017-05-01",2933,49041.36,4132,76901.320000000007,0,0]
["2017-06-01",2290,35324.660000000003,5984,134048.72,0,0]
["2017-07-01",2450,37248.730000000003,5777,124342.88,0,0]
["2017-08-01",2347,32928.93,5072,109894.88,0,0]
["2017-09-01",2227,36603.46,5247,114711.97,0,0]
["2017-10-01",2098,38274.01,4657,104884.8,0,0]
["2017-11-01",2463,40696.370000000003,5265,117574.91,1,0.22]
["2017-12-01",2599,42513.38,4971,103839.72,0,0]
[]
["$ indicates as on December 31, 2017"]
["Source: SEBI",null,null,null," "]

{"sheet":"14","index":14,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,16,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)"]
["2016-17",244,1308971.3499999999,418,309641.03999999998,252,61125.48,173,10267.570000000002,117,12714.49,1204,1700855.69]
["2017-18$",216,1045375.6399999999,413,300067.33999999997,165,52701.34,154,12337.27,63,6697.0599999999995,1011,1417178.6500000001]
["2017-04-01",26,331327.81999999995,44,37500.82,18,3446.0199999999995,8,437.71,9,788.32,105,373500.69]
["2017-05-01",15,133934.04999999999,29,45167.65,6,1365,5,363.65999999999997,9,1482.48,64,182312.84]
["2017-06-01",28,150054.09999999998,48,27365,11,1532.25,13,1346.97,7,537.77,107,180836.09000000003]
["2017-07-01",23,123721.62999999999,56,37135.920000000006,19,2671.67,28,2049.1800000000003,6,175.34,132,165753.74]
["2017-08-01",26,89618.06,29,28699,16,3847,14,351.68999999999994,7,936.31999999999994,92,123452.07]
["2017-09-01",25,65474.329999999994,72,36089.9,12,1370.17,27,2364.9300000000003,8,436.32,144,105735.65]
["2017-10-01",24,43216.25,54,38664.67,18,2386.17,12,1590.4099999999999,7,990.24,115,86847.739999999991]
["2017-11-01",22,39439.5,41,27406.03,30,15227.41,11,1164.5900000000001,3,600,107,83837.529999999984]
["2017-12-01",27,68589.899999999994,40,22038.35,35,20855.650000000001,36,2668.13,7,750.27,145,114902.29999999999]
[]
["$ indicates as on December 31, 2017"]
["Source: Credit Rating Agencies."]

{"sheet":"15","index":15,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,0,16,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],[15,0,15,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)"]
["2016-17",368,79324.570000000007,189,177619.89,2647,9057498.6415999997,59,50382.75,600,261346.32,3850,9889175.1516000014]
["2017-18$",277,121558.46999999999,253,268207.26,2792,7930289.2420000006,72,95997.260000000009,676,210689.2,4070,8626741.432]
["2017-04-01",11,19557.169999999998,14,9678.7999999999993,181,807639.49600000004,2,1591.26,64,24349.25,272,862815.97600000002]
["2017-05-01",24,8266.27,27,117005.36,137,545575.64999999979,9,55832.14,87,19714.71,284,746394.12999999966]
["2017-06-01",40,18343.990000000002,30,19734.28,434,931612.74300000002,3,384.87,70,14682.289999999999,577,984758.17300000018]
["2017-07-01",56,6917.24,73,33747.600000000006,369,968893.20999999985,13,4045,82,25023.95,593,1038626.9999999999]
["2017-08-01",29,7757.42,27,37924.339999999997,223,704136.56000000017,5,2059.5,76,11812.149999999998,360,763689.9700000002]
["2017-09-01",29,10649.7,24,27855.620000000003,625,2125609.7530000005,14,9095.89,98,59432.800000000003,790,2232643.7629999998]
["2017-10-01",13,2634.82,9,4099,285,823420.34999999986,8,3261.16,60,16107.68,375,849523.00999999989]
["2017-11-01",38,41178.35,29,7297.2400000000007,175,286338.7900000001,5,4843.4400000000005,66,12821.039999999999,313,352478.8600000001]
["2017-12-01",37,6253.5099999999993,20,10865.02,363,737062.69000000006,13,14884,73,26745.33,506,795810.55]
[]
["$ indicates as on December 31, 2017"]
["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","2016-17","2017-18$","2017-12-01"]
["Ahmedabad",0,0,0]
["BSE",998260.58000000007,800313.96,95689.37000000001]
["Calcutta",0,0,0]
["MSEI",248.08361863000002,175.03037223999996,1.2780745499999999]
["NSE",5055913.2878522538,5185452.1915975027,598031.80621008796]
[]
["$ indicates as on December 31, 2017"]
["Source:  Exchanges."]

{"sheet":"17","index":17,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,16,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"]
["2016-17",5834,70,2948,248,3918.55,707231.15999999992,998260.58000000007,4025.2442741935488,25475.254367049034,707231.15999999992,998260.41999999993,12154525.460000001,29824.62,24523.200000000001,29620.5]
["2017-18$",5616,52,2937,186,2716.4900000000002,560032.89,800313.96,4302.7632258064514,29461.325460428714,560032.89,800313.79999999993,15173866.880000001,34137.97,29241.48,34056.83]
["2017-04-04",5828,56,2978,18,287.36,57778.279999999992,75070.400000000009,4170.5777777777785,26124.164810690425,57778.279999999992,75070.38,12484962.9,30184.22,29241.48,29918.400000000001]
["2017-05-04",5783,56,2829,22,314.87,63338.030000000006,91105.619999999966,4141.1645454545442,28934.360212151034,63338.030000000006,91105.609999999957,12580118.73,31255.279999999999,29804.12,31145.8]
["2017-06-04",5794,56,2725,21,260.69000000000005,54576.55999999999,85934.520000000019,4092.1200000000008,32964.256396486249,54576.55999999999,85934.500000000015,12596811.99,31522.87,30680.66,30921.61]
["2017-07-04",5811,56,2845,21,321.31,71393.390000000014,88395.239999999991,4209.2971428571427,27510.889794902119,71393.390000000014,88395.229999999981,13262245.529999999,32672.66,31017.11,32514.94]
["2017-08-04",5627,57,2682,21,275.93,58309.55999999999,79064.470000000016,3764.9747619047625,28653.814373210604,58309.55999999999,79064.430000000022,13189762.82,32686.48,31128.02,31730.49]
["2017-09-04",5650,57,2669,21,295.25,57815.080000000009,84349.14,4016.6257142857144,28568.718035563081,57815.080000000009,84349.13,13181353.140000001,32524.11,31081.83,31283.72]
["2017-10-04",5680,57,2853,20,287.3,52683.180000000008,77996.599999999991,3899.8299999999995,27148.137835015659,52683.180000000008,77996.59,14391545.9,33340.17,31440.48,33213.129999999997]
["2017-11-04",5696,52,2801,22,371.98,74832.710000000021,122708.6,5577.6636363636362,32987.956341738798,74832.710000000021,122708.57,14596655.539999999,33865.949999999997,32683.59,33149.35]
["2017-12-04",5616,52,2937,20,301.8,69306.100000000006,95689.37000000001,4784.4685000000009,31706.219350563293,69306.100000000006,95689.36,15173866.880000001,34137.97,29241.48,34056.83]
[]
["Notes: 1. * Excludes Mutual Fund Schemes from Feb 2013. 2. Market capitalisation pertains to the number of companies traded."]
["$ indicates as on December 31, 2017"]
["Source: BSE ."]

{"sheet":"18","index":18,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,16,5],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,1,15],[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]]}
["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"]
["2016-17",1817,4,1665,248,19759.718280000001,2624533.6883799997,5055913.2878522538,20386.747128436506,25586.970503368197,2624533.6883799997,5055913.2878522538,11978420.9020945,9218.4,7516.85,9173.75]
["2017-18$",1897,4,1750,186,18003.950519999999,2696124.6689899997,5185452.1915975027,27878.775223642486,28801.746515783601,2696124.6689899997,5185452.1915975027,14982295.7502803,10552.4,9075.15,10530.7]
["2017-04-19",1831,4,1668,18,1673.04198,249260.34360999995,472110.19459065993,26228.344143925551,28218.669957741284,249260.34360999995,472110.19459065993,12303874.7516181,9367.15,9075.15,9304.0499999999993]
["2017-05-17",1814,4,1669,22,2093,295182,588502,26750.082811158591,28118.696320624746,295182,588502,12416788.8648584,9649.6,9269,9621.25]
["2017-06-17",1820,4,1666,21,1801.7032300000001,254139.32968999998,486304.73794642993,23157.368473639519,26991.389583423785,254139.32968999998,486304.73794642993,12430129.1713464,9709.2999999999993,9448.75,9520.9]
["2017-07-17",1837,4,1685,21,1838.4821199999999,317988.07377999998,543944.47364161198,25902.117792457713,29586.606675381321,317988.07377999998,543944.47364161198,13121441.338540301,10114.85,9543.85,10077.1]
["2017-08-17",1848,4,1692,21,1914.09602,280389.99945,553828.56522048579,26372.788820023132,28934.2101667651,280389.99945,553828.56522048579,13055208.0310525,10137.85,9685.5499999999993,9917.9]
["2017-09-17",1851,4,1690,21,2068.2649299999998,296602.87492999993,600091.55009768205,28575.788099889622,29014.249644395513,296602.87492999993,600091.55009768205,13045716.3446829,10178.950000000001,9687.5499999999993,9788.6]
["2017-10-17",1873,4,1712,20,2006.6769099999999,290190.30074999999,607451.92168198188,30372.596084099096,30271.535923637144,290190.30074999999,607451.92168198188,14208617.458814999,10384.5,9831.0499999999993,9788.6]
["2017-11-17",1885,4,1731,22,2504.4449300000001,363845.65891,735186.94220856298,33417.588282207405,29355.284813891394,363845.65891,735186.94220856298,14392501.046961701,10490.45,10094,10226.549999999999]
["2017-12-01",1897,4,1750,20,2104.2404000000001,348526.08786999999,598031.80621008796,29901.590310504398,28420.317669506203,348526.08786999999,598031.80621008796,14982295.7502803,10552.4,10033.35,10530.7]
[]
["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 December 31, 2017"]
["Source: NSE"]

{"sheet":"20","index":19,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,1,7],[27,0,27,4],[28,0,29,6],[2,0,3,0],[2,1,3,1],[2,2,2,3],[2,4,2,5],[2,6,2,7]]}
["Table 20: City-wise Distribution of Turnover on Cash Segments of BSE and NSE"]
["          (Percentage share in Turnover)"]
["S.No.","City","BSE",null,"NSE",null,"MSEI"]
[null,"Stock Exchange/City","2016-17","2017-12-01","2016-17","2017-12-01","2016-17","2017-12-01"]
[1,"Ahmedabad",3.1720252866837217,2.6397062517064418,2.9890138466302947,3.0616664257112109,1.3595454039350809,0]
[2,"Bengaluru",0.34610185961177031,0.29674478255681197,6.3042184739477785,3.0319130935037673,0,0]
[3,"Vadodra",0.87030258284593931,0.8078760491437782,0.33666970244081923,0.36089851311973692,0,0]
[4,"Bhubneshwar",1.7430937996629273E-2,1.5252777603330514E-2,2.9313204315614683E-4,4.0222125146654976E-4,0,0]
[5,"Chennai",0.69166281680534702,0.99156933114687673,1.0372280159209051,0.87865134256523358,2.2166165304938894,0]
[6,"Ernakulum",0.113061823364839,0.11354151491261126,1.0785203489947173,0.88960590423279118,0,0]
[7,"Coimbatore",3.75825163110802E-2,5.7547902457642741E-2,8.6247767511040421E-2,7.3178504307777129E-2,0.12574288529112787,0]
[8,"New Delhi",3.0965432691214123,3.0161200126875731,6.7074603316296697,6.9234956380034198,23.913611299736978,13.160316039467338]
[9,"Guwahati",5.4350372750387524E-2,5.4665744032313543E-2,1.3543654816490045E-3,2.6545483464844649E-3,2.720856797105644E-2,0]
[10,"Hyderabad",0.35471520198509449,0.28410113155916555,3.5840748303494041,3.6376741471035414,1.7756806311222093,0]
[11,"Indore",0.32935707905544903,0.46098983503658131,0.45214203499069167,0.61489913621259251,0.21025380590644271,7.9915134840921445]
[12,"Jaipur",0.59684821799753973,0.65629438211167201,0.47678180964731948,0.51927047631747802,0.20671921138205462,4.5314258076729566]
[13,"Kanpur",0.33258017078442514,0.30611800136883976,0.11508452135719188,9.1393012010155747E-2,0.48689087440372086,0]
[14,"Kolkata",3.4846407502288228,2.6243293031251218,4.7899774342137507,5.0818246815230106,23.707937398204162,0]
[15,"Ludhiana",9.4769868795682999E-2,9.8030839134402609E-2,0.10241025593190738,0.11253913546753576,6.6429315611438416E-2,0]
[16,"Mangalore",1.9182141141532872E-2,1.5149260787349433E-2,4.512396345860445E-4,5.0570354331139623E-4,0,0]
[17,"Mumbai",55.942020611588163,61.825416074912731,59.972635127767873,62.836251862260298,8.8442836113753316,12.873593719552586]
[18,"Patna",4.9710910691100181E-2,5.4059481371123159E-2,4.983533178613297E-3,4.2449347363312309E-3,0,0]
[19,"Pune",0.32183505927623784,0.2915379146601153,0.14834695597098868,0.12694416999232846,0.17552763657057591,0]
[20,"Rajkot",1.7529716288304824,1.5418997755440551,1.2407315386510989,1.4018856400799937,0,0]
[21,"Others",28.322306894134343,23.849049634141455,10.571374733706534,10.350100909711529,36.883552827995928,61.443150949214974]
[null,"Total",100,100,100,100,100,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, MSEI and NSE."]

{"sheet":"19","index":20,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,16,5],[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,11,2,11],[1,12,2,12],[1,13,1,15],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10]]}
["Table 19: Trends in Cash Segment of MSEI"]
["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"]
["2016-17",80,1311,22,248,0.20202000000000001,144.71557999999999,248.08361863000002,1.0003371718951615,122801.51402336403,0,0,11831270.931585776,17870.96,14957.95,17858.310000000001]
["2017-18$",3,1321,3,186,1.6810000000000002E-2,140.65924999999996,175.03037223999996,0.94102350666666645,1041227.6754312905,0,0,14718085.677106444,20459.59,17684.5,20459.59]
["2017-04-14",1,1310,4,18,5.1000000000000004E-4,0.69740000000000002,2.6864989499999998,0.14924994166666666,526764.49999999988,0,0,12137246.800000001,18115.490000000002,17684.5,18005.14]
["2017-05-14",4,1310,6,22,4.8999999999999998E-4,3.5792600000000001,2.88272555,0.13103297954545454,588311.33673469396,0,0,12274447.915715137,18616.3,17925.91,18605.22]
["2017-06-15",0,1309,3,21,3.2000000000000003E-4,1.2495000000000001,0.90657775000000007,4.3170369047619048E-2,283305.546875,0,0,12254721.67,18725.900000000001,18318.73,18402.150000000001]
["2017-07-31",0,1304,5,21,1.0500000000000002E-3,125.52889999999998,149.74561839999998,7.1307437333333326,14261487.466666663,0,0,12918713.053843748,19322.13,18402.150000000001,19322.13]
["2017-08-31",4,1302,5,21,1.3800000000000002E-3,3.1325899999999995,3.4689474149999997,0.16518797214285713,251373.00108695647,0,0,12835738.974019604,19396.43,18601.32,19040.830000000002]
["2017-09-30",1,1308,3,21,2.2700000000000003E-3,2.0019999999999998,4.1667301999999999,0.1984157238095238,183556.39647577089,0,0,12780674.596753974,19477.48,18717.240000000002,18771.034160128362]
["2017-10-31",4,1304,2,20,3.7099999999999998E-3,2.7920000000000003,6.3244781750000003,0.31622390875,170471.10983827495,0,0,13766435.507154517,20037.23,18771.034160128362,19977.28]
["2017-11-30",3,1305,3,22,5.170000000000001E-3,1.2770000000000001,3.5707212500000001,0.16230551136363636,69066.175048355886,0,0,13796404.101509847,20148.87,19549.82,19761.04]
["2017-12-30",3,1321,3,20,1.9099999999999998E-3,0.40060000000000007,1.2780745499999999,6.3903727499999993E-2,66914.897905759164,0,0,14718085.677106444,20459.59,19440.22,20459.59]
[]
["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 December 31, 2017"]
["Source: MSEI"]

{"sheet":"21","index":21,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5]]}
["Table 21: Category-wise Share of Turnover in Cash Segment of BSE"]
["Year/Month","Percentage Share in Turnover"]
[null,"Proprietary","FPI","Mutual Funds","Banks","Others"]
["2016-17",13.487552802180911,12.858440464135123,4.6291595194783861,8.6556316029854294E-2,68.938290898175708]
["2017-18$",16.275633351819703,15.982321209534057,7.9282241513306708,0.17379788206097704,59.640023405254581]
["2017-04-04",18.060795844293921,15.557794942928602,5.6656043721427496,7.7179977903151772E-2,60.638624862731575]
["2017-05-04",17.34624581445911,15.395740161861815,8.2370237109195532,6.9574058394495902E-2,58.951416254365029]
["2017-06-04",13.03106545450968,18.591955720525004,8.1230793589013714,0.81512439926432689,59.438775066799629]
["2017-07-04",15.596469003995516,15.442036647511761,7.7414442076383319,0.13986361211880807,61.080186528735588]
["2017-08-04",16.881734626060275,15.023322199589767,7.6866875397252388,0.23272651379164297,60.175529120833062]
["2017-09-04",17.545495825934488,12.976699413500532,6.7484017318887242,0.1116716842838297,62.617731344392432]
["2017-10-04",17.072836937510534,12.913463640818831,6.5830798079767039,7.6488293119477815E-2,63.354131320574453]
["2017-11-04",15.861601777215487,20.151274782163231,6.8319493751572171,6.7720975537905806E-2,57.087453089926157]
["2017-12-04",15.657975872857882,15.626477733616134,13.148668957530866,2.5647296709091254E-2,55.541230139286036]
[]
["$ indicates as on December 31, 2017"]
["Source: BSE. "]

{"sheet":"22","index":22,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5]]}
["Table 22: Category-wise Share of Turnover in Cash Segment of NSE"]
["Year/Month","Percentage Share in Turnover"]
[null,"Proprietary","FPI","Mutual Funds","Banks","Others"]
["2016-17",16.917932653270125,20.271183814089273,6.2137977386162628,0.42218466828211887,56.597085794024338]
["2017-18$",17.62,16.29,7.1,0.54130171725408605,58.448698282745916]
["2017-04-18",16.6152857013893,15.498526184541999,7.2181070516476797,0.59950798906228397,60.668081062421024]
["2017-05-17",17.431307168043599,18.4424365122522,6.8825704680528297,0.597030048999318,57.243685851651364]
["2017-06-17",16.8295507501463,18.985251854645,6.8537180004421501,0.62384268928296804,56.71]
["2017-07-17",17.008942327948898,16.355453818620642,7.96648842982564,0.42221318722012802,58.246902236384692]
["2017-08-17",18.528569839172633,16.581896226055846,6.6381342445537905,0.48437302830750989,57.767026661910222]
["2017-09-17",17.77,15.98,7.17,0.52,58.559999999999995]
["2017-10-17",17.487017507072501,15.9678445044537,7.3322452752375797,0.552469427851765,58.660423285384454]
["2017-11-17",17.728364516364501,15.4377701354518,7.24833903503119,0.49367969145708301,59.091846621695431]
["2017-12-01",18.825676714169202,13.906872443678701,7.3259997252311697,0.47785298878812299,59.463598128132809]
[]
["$ indicates as on December 31, 2017"]
["Source: NSE. "]

{"sheet":"23","index":23,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5]]}
["Table 23: Category-wise Share of Turnover in Cash Segment of MSEI"]
["Year/Month","Percentage Share in Turnover"]
[null,"Proprietary","FPI","Mutual Funds","Banks","Others"]
["2016-17",5.366745927653109E-2,0,0,0,99.946332540723475]
["2017-18$",0,0,0,0,100]
["2017-04-18",0,0,0,0,100]
["2017-05-17",0,0,0,0,100]
["2017-06-17",0,0,0,0,100]
["2017-07-17",0,0,0,0,100]
["2017-08-17",0,0,0,0,100]
["2017-09-17",0,0,0,0,100]
["2017-10-17",0,0,0,0,100]
["2017-11-17",0,0,0,0,100]
["2017-12-01",0,0,0,0,100]
[]
["$ indicates as on December 31, 2017"]
["Source: MSEI. "]

{"sheet":"24","index":24,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,1],[34,0,34,9],[35,0,35,9],[36,0,36,9],[37,0,37,9],[38,0,38,9]]}
["Table 24: Component Stocks: S&P BSE Sensex"]
["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   ",518.02,381148.07424400002,11.41718316247052,0.67,0.21305499999999999,0.82,1.1608750000000001,0.03]
[2,"RELIANCE    ",6333.5,297486.54543100001,8.9111256413748023,1.1200000000000001,1.8121999999999999E-2,4.7,-0.16800300000000001,0.02]
[3,"HDFC        ",319.52,272512.38767999999,8.1630317832668773,0.98,0.21581500000000001,1.18,1.9399820000000001,0.03]
[4,"ITC LTD.    ",1219.05,224245.74192299999,6.7172180103945225,1.28,0.197268,1.62,2.9141400000000002,0.04]
[5,"INFOSYS LTD ",1091.97,207689.68887000001,6.2212861064262164,0.73,8.2127000000000006E-2,1.43,6.6003379999999998,0.03]
[6,"ICICI BANK  ",1284.4100000000001,201417.027,6.0333902876474275,1.71,0.282503,1.82,2.014294,0.03]
[7,"LARSEN & TOU",280.20999999999998,153156.21763900001,4.5877513423726501,0.98,3.9454000000000003E-2,2.79,3.2953929999999998,0.04]
[8,"TCS LTD.    ",191.43,134402.92619500001,4.0260017815490201,0.28999999999999998,1.7236999999999999E-2,1.26,2.5111509999999999,0.04]
[9,"MARUTISUZUK ",151.04,129344.433152,3.8744760478494147,1.01,0.26293499999999997,1.1100000000000001,13.124978,0.02]
[10,"KOTAK MAH.BK",952.21,119095.27163,3.567465302509774,0.66,0.108738,1.1399999999999999,0.889822,0.06]
[11,"STATE BANK  ",863.21,114879.63742499999,3.4411871677981476,1.87,0.243446,2.14,-3.4170690000000001,0.03]
[12,"HIND UNI LT ",216.45,97719.750694999995,2.9271675961861012,0.77,0.151259,1.1200000000000001,7.4072620000000002,0.05]
[13,"AXIS BANK   ",512.78,95728.222561000002,2.86751193211331,1.23,0.16801099999999999,1.7,4.9253729999999996,0.03]
[14,"INDUSIND BNK",599.74,83978.153034999996,2.5155419104460237,0.8,0.143231,1.19,-0.680087,0.04]
[15,"TATA MOTORS ",577.47,80926.589743999997,2.4241331919464661,1.63,0.259108,1.8,6.5612250000000003,0.04]
[16,"MAH & MAH   ",621.6,69970.671990000003,2.0959517628300111,1.05,1.5223E-2,4.8,6.4941509999999996,0.06]
[17,"SUN PHARMA. ",239.92,61627.032756000001,1.8460204006813201,1.01,8.8678000000000007E-2,1.92,5.7134910000000003,0.04]
[18,"BHARTI ARTL ",1998.7,59254.259680000003,1.774944651799724,1.03,0.102103,1.82,6.5512730000000001,0.05]
[19,"YES BANK    ",459.74,57677.4637,1.7277121725350315,1.37,5.5770000000000004E-3,10.34,2.6890480000000001,0.05]
[20,"ONGC CORPN  ",6416.62,54955.762240999997,1.6461843722631786,0.67,8.5621000000000003E-2,1.29,7.8094710000000003,0.05]
[21,"NTPC LTD    ",8245.4599999999991,54060.566725999997,1.6193690428633132,0.68,9.5976000000000006E-2,1.25,-2.045328,0.05]
[22,"ASIAN PAINTS",95.92,52200.802116999999,1.5636603180530169,0.72,0.12231499999999999,1.1599999999999999,0.88433799999999996,0.06]
[23,"HEROMOTOCO  ",39.94,49147.328822000003,1.472194385921848,0.86,0.161084,1.21,3.9535450000000001,0.05]
[24,"TATA STEEL  ",971.22,49084.283446000001,1.4703058794489594,1.47,0.26560499999999998,1.61,5.365748,0.03]
[25,"BAJAJ AUTO  ",289.37,45196.503666999997,1.3538485316839632,0.78,0.15940699999999999,1.1000000000000001,0.34725299999999998,0.05]
[26,"POWER GRID  ",5231.59,44022.260372999997,1.3186744046954106,0.56999999999999995,7.7454999999999996E-2,1.1499999999999999,-2.719106,0.08]
[27,"WIPRO LTD.  ",904.59,39653.895257999997,1.1878212586118928,0.46,3.1619999999999999E-3,4.6399999999999997,7.4023300000000001,7.0000000000000007E-2]
[28,"COAL INDIA  ",6207.41,34283.519907000002,1.0269531782596566,0.65,7.1885000000000004E-2,1.37,-4.7791449999999998,0.06]
[29,"ADANI PORTS ",414.19,31844.407618000001,0.95389025694598784,1.5,0.245619,1.71,1.45418,0.06]
[30,"DR.REDDY'S  ",82.91,29214.693907000001,0.87511792374478004,0.57999999999999996,3.6051E-2,1.73,5.6006289999999996,0.04]
[31,"TATAMTRTDVR ",101.7,12448.12896,0.37,1.63,0.24426300000000001,1.86,5.3800000000000001E-2,0.1]
[]
["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":"25","index":25,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,0,59,1],[53,0,53,9],[54,0,54,9],[55,0,55,9],[56,0,56,9],[57,0,57,9],[58,0,58,9]]}
["Table 25: Component Stocks: Nifty 50 Index"]
["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.",5176128234,382825.41,9.41,0.73,0.24,0.88,1.01,0.03]
[2,"RELIANCE INDUSTRIES LTD.",65050705050,317549.24,7.8,0.95,0.12,0.75,-0.05,0.02]
[3,"HOUSING DEVELOPMENT FINANCE CORPORATION LTD.",3194124080,273161.49,6.71,1,0.22,0.89,2.0699999999999998,0.02]
[4,"I T C LTD.",12188208322,224598.21,5.52,1.1599999999999999,0.17,1.1599999999999999,2.81,0.02]
[5,"INFOSYS LTD.",11484966335,208241.62,5.12,0.69,0.08,0.9,6.76,0.02]
[6,"ICICI BANK LTD.",12843505078,201643.03,4.96,1.56,0.25,1.1499999999999999,2.1,0.03]
[7,"LARSEN & TOUBRO LTD.",2802063242,155130.63,3.81,1.33,0.36,1.06,3.43,0.03]
[8,"KOTAK MAHINDRA BANK LTD.",9522077710,134668.84,3.31,0.78,0.15,0.64,0.99,0.02]
[9,"TATA CONSULTANCY SERVICES LTD.",1914287591,134442.71,3.3,0.3,0.02,1.3,2.4300000000000002,0.02]
[10,"MARUTI SUZUKI INDIA LTD.",1510400300,129320.53,3.18,1.07,0.28999999999999998,1.51,13.15,0.02]
[11,"STATE BANK OF INDIA",8632053793,115028.16,2.83,1.74,0.18,1.21,-3.26,0.02]
[12,"HINDUSTAN UNILEVER LTD.",2164478571,97702.51,2.4,0.81,0.17,0.89,7.5,0.02]
[13,"AXIS BANK LTD.",4797101600,96039.05,2.36,1.19,0.16,1.04,5.33,0.02]
[14,"INDUSIND BANK LTD.",5993676140,84005.27,2.06,0.94,0.19,0.69,-0.79,0.03]
[15,"TATA MOTORS LTD.",5774697388,79801.7,1.96,1.67,0.28000000000000003,1.33,6.85,0.03]
[16,"BHARTI AIRTEL LTD.",19987000510,69868.36,1.72,1.02,0.1,1.95,6.69,0.03]
[17,"MAHINDRA & MAHINDRA LTD.",6215962720,70032.14,1.72,0.94,0.19,1.62,6.8,0.02]
[18,"SUN PHARMACEUTICAL INDUSTRIES LTD.",2399309346,63036.81,1.55,1.01,0.09,1.88,5.78,0.03]
[19,"VEDANTA LTD.",3717194239,61315.12,1.51,1.94,0.28999999999999998,1.83,11.66,0.02]
[20,"YES BANK LTD.",4595212580,57927.25,1.42,1.2,0.16,1.34,2.69,0.02]
[21,"OIL & NATURAL GAS CORPORATION LTD.",64166175900,55111.05,1.35,0.68,0.08,1.2,8.0500000000000007,0.03]
[22,"NTPC LTD.",82454644000,53999.55,1.33,0.73,0.11,1.01,-2.29,0.03]
[23,"ASIAN PAINTS LTD.",959197790,52227.839999999997,1.28,0.77,0.14000000000000001,1.1100000000000001,1.02,0.02]
[24,"HCL TECHNOLOGIES LTD.",2784248928,49587.47,1.22,0.23,0.01,1.1100000000000001,5.01,0.03]
[25,"HERO MOTOCORP LTD.",399414042,49134.87,1.21,0.96,0.19,1.6,4.17,0.02]
[26,"TATA STEEL LTD.",9712158890,49080.98,1.21,1.57,0.28999999999999998,1.3,5.51,0.02]
[27,"BAJAJ AUTO LTD.",2893670200,45337.79,1.1100000000000001,0.88,0.2,1.29,0.85,0.02]
[28,"ULTRATECH CEMENT LTD.",2745519210,45076.7,1.1100000000000001,1.1200000000000001,0.22,1.1299999999999999,2.78,0.03]
[29,"POWER GRID CORPORATION OF INDIA LTD.",52315896480,44022.26,1.08,0.55000000000000004,7.0000000000000007E-2,0.7,-2.77,0.03]
[30,"BAJAJ FINANCE LTD.",1153034616,41523.49,1.02,1.45,0.19,1.36,1.72,0.02]
[31,"EICHER MOTORS LTD.",272367080,40492.86,1,1.06,0.17,1.58,1.33,0.02]
[32,"BHARAT PETROLEUM CORPORATION LTD.",21692527440,40428.800000000003,0.99,1.1599999999999999,0.15,1.47,2.75,0.03]
[33,"HINDALCO INDUSTRIES LTD.",2244889146,39915.81,0.98,1.98,0.33,1.68,13.77,0.02]
[34,"WIPRO LTD.",9733381542,39763.300000000003,0.98,0.41,0.04,1.1200000000000001,7.66,0.03]
[35,"INDIAN OIL CORPORATION LTD.",48559049640,39622,0.97,1.03,0.12,1.4,-1.26,0.03]
[36,"INDIABULLS HOUSING FINANCE LTD.",851865488,38735.01,0.95,1.18,0.14000000000000001,1,-0.77,0.03]
[37,"COAL INDIA LTD.",62074091770,34277,0.84,0.74,0.09,1.23,-4.66,0.03]
[38,"GAIL (INDIA) LTD.",16913032000,32112.27,0.79,0.97,0.11,2.13,6.67,0.02]
[39,"ZEE ENTERTAINMENT ENTERPRISES LTD.",960453620,31851.14,0.78,0.96,0.14000000000000001,0.79,2.4,0.02]
[40,"HINDUSTAN PETROLEUM CORPORATION LTD.",15238226250,31255.74,0.77,1.38,0.12,1.8,0.46,0.03]
[41,"TECH MAHINDRA LTD.",4885459220,31520.2,0.77,0.55000000000000004,0.03,1.67,3.03,0.03]
[42,"ADANI PORTS AND SPECIAL ECONOMIC ZONE LTD.",4141903522,31083.02,0.76,1.54,0.25,1.0900000000000001,1.92,0.04]
[43,"CIPLA LTD.",1609889380,30857.96,0.76,0.69,7.0000000000000007E-2,1.42,1.26,0.03]
[44,"BHARTI INFRATEL LTD.",18496082460,29422.639999999999,0.72,0.91,0.06,1.72,-1.29,0.03]
[45,"DR. REDDY'S LABORATORIES LTD.",829436320,29235.41,0.72,0.55000000000000004,0.03,1.28,5.7,0.02]
[46,"UPL LTD.",1016713494,27916.11,0.69,1.04,0.15,2.04,4.29,0.03]
[47,"LUPIN LTD.",903920698,21201.599999999999,0.52,0.7,0.05,0.64,8.24,0.03]
[48,"AMBUJA CEMENTS LTD.",3971290458,19987.21,0.49,1.05,0.21,1.01,3.64,0.03]
[49,"AUROBINDO PHARMA LTD.",585882409,19346.77,0.48,1.17,0.11,1.35,-0.71,0.02]
[50,"BOSCH LTD.",305207400,18464.03,0.45,0.95,0.15,1.36,-0.83,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":"26","index":26,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[48,0,48,9],[49,0,49,1],[43,0,43,9],[44,0,44,9],[45,0,45,9],[46,0,46,9],[47,0,47,9]]}
["Table 26: Component Stocks: SX40 Index"]
["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,"Reliance Industries Limited",6333.5035189999999,374805.68036040996,9.9350726064883682E-2,1.1100000000000001,0.03,0.35119999999999996,-5.4285869388198259E-4,0]
[2,"ITC Limited",1218.4849220000001,283499.65447830001,7.5147997982524362E-2,1.29,0.2,0.21589999999999998,2.7350427350427309E-2,0]
[3,"Infosys Limited",1148.4966334999999,261295.07027575499,6.9262170530895603E-2,0.86,0.11,0.28730000000000006,6.3288709754810171E-2,0]
[4,"HDFC Bank Limited",518.02472339999997,210149.75600444002,5.5704947751385861E-2,0.64,0.18,0.19850000000000001,9.9871822260201044E-3,0]
[5,"Larsen & Toubro Limited",280.15136360000002,194461.25244927499,5.1546354910481325E-2,1.33,0.35,0.32690000000000002,3.314126763361816E-2,0]
[6,"Tata Consultancy Services Limited",197.04279410000001,190986.17315471999,5.0625206515091233E-2,0.42,0.03,0.21699999999999997,2.3767214571301577E-2,0]
[7,"Maruti Suzuki India Limited",151.04003,161911.01092641498,4.2918176901616076E-2,1.03,0.26,0.19210000000000005,0.11618728512623903,0]
[8,"Housing Development Finance Corporation Limited",319.51830899999999,149967.71395904,3.9752335807168873E-2,0.84,0.15,0.25049999999999994,2.0287652011225468E-2,0]
[9,"Hindustan Unilever Limited",216.44785709999999,122176.67811013499,3.2385692945649504E-2,0.84,0.18,0.25380000000000003,6.9744489527360357E-2,0]
[10,"ICICI Bank Limited",1284.3979482,110743.51361740001,2.9355074006042713E-2,1.48,0.22,0.58730000000000004,2.0541401273885315E-2,0]
[11,"Tata Motors Limited",577.46968560000005,99796.275533895008,2.645326085594444E-2,1.71,0.28000000000000003,0.41099999999999992,6.4142642121106971E-2,0]
[12,"Mahindra & Mahindra Limited",621.596272,87869.887193480012,2.3291901775653535E-2,0.99,0.03,0.26329999999999998,-0.87265344161895875,0]
[13,"Sun Pharmaceuticals Industries Limited",240.67495160000001,79166.310343019999,2.098482180124327E-2,1.1200000000000001,0.11,0.40190000000000003,5.4626630482360036E-2,0]
[14,"Bharti Airtel Limited",1998.700051,74130.613983360003,1.9649996541675627E-2,1.02,0.1,0.60060000000000002,6.2682903804399115E-2,0]
[15,"Oil & Natural Gas Corporation Limited",6416.6175899999998,68809.026673920001,1.823938941719945E-2,0.69,0.09,0.379,7.4538934426229428E-2,0]
[16,"Vedanta Limited",371.71942389999998,68708.426469479993,1.821272305679696E-2,1.9,0.27,0.42509999999999998,0.10442558351015456,0]
[17,"Kotak Mahindra Bank Limited",952.20777099999998,68142.88977306,1.8062814759378328E-2,0.7,0.12,0.28129999999999999,9.8000395961196692E-3,0]
[18,"NTPC Limited",8245.4644000000008,67938.054148800002,1.800851844248522E-2,0.77,0.11,0.25139999999999996,-2.3446327683615851E-2,0]
[19,"HCL Technologies Limited",285.42489280000001,66217.290231299994,1.755239103154127E-2,0.32,0.02,0.32320000000000004,4.7725996631106118E-2,0]
[20,"Asian Paints Limited",95.919779000000005,65988.235534199994,1.7491674901402649E-2,0.75,0.13,0.29519999999999996,1.0142425550280535E-2,0]
[21,"State Bank of India",863.2053793,63037.601494139992,1.6709542586999533E-2,1.67,0.17,0.97779999999999989,-3.3720555017747809E-2,0]
[22,"Hero MotoCorp Limited",39.941404200000001,62155.722933575002,1.647578072082681E-2,0.98,0.2,0.19879999999999995,4.0024833890334593E-2,0]
[23,"Tata Steel Limited",971.21588899999995,61424.115582519997,1.6281851638824032E-2,1.54,0.28000000000000003,0.29069999999999996,5.2225559803386126E-2,0]
[24,"Ultratech Cement Limited",274.55192099999999,56509.982446740003,1.4979249462278108E-2,1.1100000000000001,0.21,0.34870000000000007,2.7033282414479512E-2,0]
[25,"Power Grid Corporation of India Limited",5231.5896480000001,55514.53800524,1.4715384389781934E-2,0.59,0.08,0.26530000000000004,-2.8450212128774729E-2,0]
[26,"Bajaj Auto Limited",289.36702000000002,53162.474324399998,1.4091916692553884E-2,0.87,0.19,0.22690000000000005,8.4293256539476578E-3,0]
[27,"Axis Bank Limited",512.77593839999997,53063.991540350005,1.4065811602335269E-2,1.0900000000000001,0.13,0.55190000000000006,5.0625055412714011E-2,0]
[28,"Eicher Motors Limited",27.236708,51373.112049575,1.3617605734870348E-2,1.04,0.16,0.28029999999999999,1.3078077904870802E-2,0]
[29,"Indian Oil Corporation Limited",4855.9049640000003,50746.401749144999,1.3451481989573346E-2,1.07,0.12,0.35470000000000002,-1.2739673143739515E-2,0]
[30,"Wipro Limited",973.33815419999996,50619.030215175,1.3417719282541402E-2,0.66,0.01,0.20419999999999996,7.1121718377088375E-2,0]
[31,"Hindalco Industries Limited",224.48891459999999,50460.26556159,1.3375635118843716E-2,1.91,0.3,0.39129999999999998,0.12100164503747038,0]
[32,"Bharat Petroleum Corporation Limited",2169.2140439999998,49269.847213410001,1.3060087800833713E-2,1.1599999999999999,0.15,0.3695,2.6752945721460347E-2,0]
[33,"Coal India Limited",6316.3644000000004,47015.240831174997,1.2462453365704087E-2,0.77,0.1,0.27789999999999998,-4.886860619889722E-2,0]
[34,"IndusInd Bank Limited",599.73534400000005,46173.15999824,1.22392407877171E-2,0.84,0.15,0.31139999999999995,-7.9143671538601211E-3,0]
[35,"Zee Entertainment Enterprises Limited",96.045361999999997,40016.614227179998,1.0607309030924257E-2,0.97,0.14000000000000001,0.36640000000000017,2.3461670677208626E-2,0]
[36,"Tech Mahindra Limited",488.54592200000002,39523.887210004999,1.047670058640696E-2,0.66,0.05,0.35770000000000002,2.9362166451740921E-2,0]
[37,"Adani Ports And Special Economic Zone Limited",414.19035220000001,38739.022869784996,1.0268654534414601E-2,1.55,0.25,0.34909999999999997,1.8858621964747881E-2,0]
[38,"Dr. Reddy's Laboratories Limited",85.449920500000005,38416.566361239995,1.01831801408102E-2,0.61,0.04,0.37860000000000005,5.3910197995194947E-2,0]
[39,"Yes Bank Limited",459.74414300000001,31805.188670309999,8.4306848924685669E-3,1.26,0.02,0.47839999999999994,2.6178010471204192E-2,0]
[40,"Lupin Limited",90.395492200000007,26760.71739224,7.0935336422319551E-3,0.72,0.05,0.71910000000000007,7.6149587617218364E-2,0]
[]
["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: MSEI."]

{"sheet":"27","index":27,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,0,15,6],[1,0,2,0],[1,1,1,3],[1,4,1,6],[1,7,1,9]]}
["Table 27: Advances/Declines in Cash Segment of BSE, MSEI and NSE"]
["Year/ Month","BSE",null,null,"NSE",null,null,"MSEI"]
[null,"Advances","Declines","Advance / Decline Ratio","Advances","Declines","Advance / Decline Ratio","Advances","Declines","Advance / Decline Ratio"]
["2016-17",2137,1650,1.2951515151515152,993,627,1.5837320574162679,8,8,1]
["2017-18$",2030,1330,1.5263157894736843,1161,506,2.2944664031620552,3,4,0.75]
["2017-04-04",2511,1077,2.331476323119777,1327,351,3.7806267806267808,4,0,0]
["2017-05-01",1616,1941,0.83256053580628542,766,931,0.82,2,2,1]
["2017-06-04",1310,2171,0.60340856748042382,668,1022,0.6536203522504892,1,1,1]
["2017-07-04",2005,1411,1.4209780297661234,1060,634,1.65,1,3,0.33333333333333331]
["2017-08-04",995,2401,0.4144106622240733,484,1237,0.39,3,2,1.5]
["2017-09-04",1835,1500,1.2233333333333334,1060,660,1.606060606060606,2,1,2]
["2017-10-04",1871,1508,1.2407161803713529,986,741,1.330634278002699,2,0,0]
["2017-11-04",2120,1337,1.5856394913986538,1179,576,2.046875,1,2,0.5]
["2017-12-04",2058,1371,1.5010940919037199,1089,685,1.5897810218978101,1,1,1]
[]
["Note: Advance/Decline is calculated based on the average price methodology.                                                                           ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]
["Source: BSE, MSEI and NSE"]

{"sheet":"28","index":28,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,0,17,9],[1,0,3,0],[1,1,1,3],[1,4,1,6],[1,7,1,9],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[15,0,16,6]]}
["Table 28: Trading Frequency in Cash Segment of BSE and NSE"]
["Month"," BSE",null,null,"NSE",null,null,"MSEI"]
[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","No. of Companies Listed","No. of companies Traded ","Percent of Traded to Listed"]
[]
["2016-17",5834,2948,50.531367843675014,1817,1665,91.634562465602642,80,22,{"$f":"I5/H5*100","v":27.500000000000004}]
["2017-18$",5616,2937,52.297008547008552,1897,1750,92.250922509225092,3,3,100]
["2017-04-04",5828,2978,51.098146877144821,1831,1668,91.097760786455481,1,4,{"$f":"I7/H7*100","v":400}]
["2017-05-05",5783,2829,48.919246066055685,1814,1669,92.006615214994497,4,6,{"$f":"I8/H8*100","v":150}]
["2017-06-05",5794,2725,47.031411805315841,1820,1666,91.538461538461533,0,3,"NA"]
["2017-07-05",5811,2845,48.95887110652211,1837,1685,91.72563962983125,0,5,"NA"]
["2017-08-05",5627,2682,47.663053136662519,1848,1692,91.558441558441558,4,5,125]
["2017-09-04",5650,2669,47.238938053097343,1851,1690,91.301998919502964,1,3,300]
["2017-10-04",5680,2853,50.228873239436624,1873,1712,91.404164442071547,4,2,50]
["2017-11-04",5696,2801,{"$f":"C14/B14*100","v":49.174859550561798},1885,1731,{"$f":"F14/E14*100","v":91.830238726790441},3,3,100]
["2017-12-04",5616,2937,{"$f":"C15/B15*100","v":52.297008547008552},1897,1750,{"$f":"F15/E15*100","v":92.250922509225092},3,3,100]
["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."]
[]
["##  Two companies got delisted in the month of April-2017 and June-2017, one in each of the months, respectively."]
["$ indicates as on December 31, 2017"]
["Source: BSE and NSE"]

{"sheet":"29","index":29,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[13,0,14,6],[15,0,15,2],[15,3,15,5]]}
["Table 29: Daily Volatility of Major Indices  (percent)"]
["Year/        Month","BSE Sensex","BSE 100 ","BSE 500","Nifty 50","Nifty Next 50","Nifty 500","SX40"]
["2016-17",0.76807487248051698,0.80218025330334042,0.79644016852872535,0.78266424176355576,0.96894228239080127,0.80209967984939878,0.76281902299372961]
["2017-18$",0.56391321349655676,0.58533374370494085,0.60771211857204377,0.5619611700939966,0.81862130649192055,0.60690578602695955,0.56063072086834176]
["2017-04-04",0.57641998710815456,0.51385813202658237,0.48730611827302289,0.48400798196830025,0.58023748168739364,0.45367459233534146,0.53190380494670064]
["2017-05-04",0.58043233858866461,0.64030642922381897,0.70983496954537129,0.5675048528617026,1.0185463151440759,0.68839166564612142,0.5486064041898806]
["2017-06-04",0.3384528305976503,0.35441280983265783,0.38670928645025415,0.34,0.53,0.38,0.32639725609774095]
["2017-07-04",0.49897841903764373,0.46425703853319517,0.4381585284773889,0.42,0.54,0.39,0.53818411124197252]
["2017-08-04",0.68834028984875506,0.77368372944007013,0.84679575831893716,0.7,1.22,0.83,0.71307909398669456]
["2017-09-04",0.5994807973595625,0.68676492549234769,0.75687259165548648,0.6,0.91,0.71,0.62136636445760285]
["2017-10-04",0.48307927878031631,0.46480847730821001,0.43311250482271635,0.46,0.5,0.43,0.47619007608286046]
["2017-11-04",0.61064263846399669,0.57999756483374509,0.56729288012359513,0.52179956450280696,0.68516629411183783,0.53339596773845399,0.54920357903716743]
["2017-12-04",0.58039000590566392,0.63770074989727343,0.64165477805311244,0.54524066915192171,0.72526486156304804,0.56488746140570478,0.54920357903716743]
["Note: Volatility is calculated as the standard deviation of the natural log of daily returns in indices for the respective period. "]
[]
["$ indicates as on December 31, 2017"]
["Source: BSE and NSE."]

{"sheet":"30","index":30,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,0,27,11],[1,1,1,5],[1,6,1,10],[3,0,3,10],[15,0,15,10]]}
["Table 30: 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"]
["2016-17",10.0146,15.5944,28.3171,40.993499999999997,55.793500000000002,10.741703436208812,19.203194493761831,33.795316234396168,48.859419684662356,67.722091628948988]
["2017-18$",11.405200000000001,16.502700000000001,27.1541,38.186999999999998,53.055999999999997,9.1558470141440385,15.647619900548055,29.054293724053981,43.107296810234175,61.224588839762383]
["2017-04-04",12.8415,18.719799999999999,30.6358,42.706000000000003,56.6357,13.89261824964346,24.334909079958418,40.599696565046187,57.243974197238721,74.511379225617617]
["2017-05-04",11.9795,18.3444,30.544,43.490699999999997,59.6738,10.110440524450469,17.166786660785988,32.206219299359688,47.999426619665932,67.258441549629197]
["2017-06-04",23.319400000000002,29.771699999999999,39.977200000000003,50.427799999999998,63.522199999999998,10.202479368029129,17.414184504146871,32.7478717775519,48.060537544593259,66.844713822379802]
["2017-07-04",14.0266,20.471299999999999,32.015900000000002,44.255000000000003,59.559699999999999,11.242020037617122,18.528363944082415,33.272310435618465,48.091593191788128,66.471895499693744]
["2017-08-04",13.8162,19.398399999999999,31.619800000000001,44.804000000000002,60.700800000000001,11.845448608500305,18.361413852618398,33.48360726196497,48.585826587529944,67.646830950659151]
["2017-09-04",10.8606,17.346800000000002,27.750399999999999,40.281300000000002,55.851599999999998,9.3548906538124115,15.552179828392504,30.516502950994862,45.348760415516992,62.998358337433515]
["2017-10-04",10.2834,15.0543,25.3704,36.836300000000001,51.455500000000001,11.537247477288158,18.853837732728703,31.717107485617934,46.10427208217677,62.986327988530952]
["2017-11-04",25.4693,29.690799999999999,38.189500000000002,47.643099999999997,59.414200000000001,8.7480876368464511,15.45710772218451,29.008080197508125,43.558465158308465,60.879601017086671]
["2017-12-04",13.6196,19.619900000000001,31.196200000000001,42.56,55.644399999999997,8.5886814113836145,14.699142325679853,28.499799576218699,42.338533108427875,60.041806530130501]
["Members"]
["2016-17",19.38,29.36,49.27,66.13,80.400000000000006,18.498956237186583,28.897726520260065,50.722319273866958,67.895106592033784,81.704425693069851]
["2017-18$",21.42,34.42,55.95,71.09,83.04,19.273362963103143,30.328000098564971,50.818559182727832,68.082518839875277,81.681553807582745]
["2017-04-04",20.440000000000001,31.98,53.6,69.22,81.63,18.093423609092689,29.434330983046586,51.403704736997661,69.180092046794257,82.78272068117694]
["2017-05-04",22.77,35.020000000000003,54.74,70.41,83.03,19.276072417880233,30.540272901689253,52.247491538912868,69.122000187580554,82.178600936110456]
["2017-06-04",32.630000000000003,43.36,63.64,76.61,86.61,19.239602255361969,31.745430657465949,52.809883843457875,69.272237370827909,82.03347318442286]
["2017-07-04",20.6,32.57,53.4,69.040000000000006,81.790000000000006,18.826948746323868,30.132180427942263,50.042873932016342,67.32684066389497,81.104625665643923]
["2017-08-04",23.6,35.28,57.46,72.290000000000006,83.22,20.149602697542502,31.888477268535592,52.997571457258488,69.481960318489328,82.782678199885225]
["2017-09-04",23.84,35.369999999999997,55.62,69.97,82.19,18.912468277069941,30.158091864481939,50.684238153508176,68.189807908110438,81.878628084490984]
["2017-10-04",23.71,35.229999999999997,54.99,69.38,81.99,19.620711553518685,30.601206377642466,50.815353007833977,68.03635341310364,82.101550300424492]
["2017-11-04",31.21,42.77,61.2,74.680000000000007,84.75,19.260943844561364,30.665917043743224,51.220669431529373,67.83106666899765,81.576751620721723]
["2017-12-04",31.73,43.24,63.54,76.75,86.32,19.73529725096547,31.731253675142352,51.862261114423312,68.160595326256072,82.005085983482715]
["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 December 31, 2017"]
["Source: BSE and NSE"]

{"sheet":"31","index":31,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Table 31: 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)"]
["2016-17",3918.5088299999998,707223,303781.60625000001,41.942237721663382,998260.58000000007,464996.29739866097,37.438058851733331,303449.16791000002,99.94442952609478,464969.74684493802,99.99,714.67051000000004,0.2445689483924621,117489.5380093,298363.24004866101,148.66]
["2017-18$",2716.4256100000007,559993,220500.94792999999,39.389612102621605,800313.94,295378.31167242501,36.592146141557265,220381.92161000002,99.943549122984649,295368.89945889998,99.990755208283389,439.91831234200004,0.20139689371682537,113751.3630595,220500.94792999999,188.74]
["2017-04-04",287.35000000000002,57778,23452.3835,40.590507632662955,75070.400000000009,26771.100151385999,35.661326103745274,23452.25747,99.99,26770.975589385995,99.99,41.57,0.17725372516132454,10589.514006700001,23452.3835,149.62]
["2017-05-04",314.87893000000003,63339,25591.070489999998,40.403338369724814,91105.619999999966,32596.855593134002,35.779192977484833,25591.070489999998,99.99,32596.855593134002,99.99,47.612380000000002,0.18605075555008566,13409.2344619,25591.070489999998,180.7]
["2017-06-04",260.68967000000004,54577,22232.708900000001,40.736407094563646,85934.520000000019,36881.549494159,42.918200385780928,22232.708900000001,100,36881.549494159,100,38.675629999999998,0.17395824401766893,13886.130302699999,22232.708900000001,181.73]
["2017-07-04",321.29397000000006,71354,26689.9496,37.404980239369898,88395.239999999991,29549.896761557997,33.429285062813335,26689.914970000002,99.99,29549.887389157997,99.99,55.33,0.20730676760189001,10495.169576200002,26689.9496,182.86]
["2017-08-04",275.92770000000007,58309,23428.614379999999,40.180099778764856,79064.470000000016,28024.819248092997,35.445528501099155,23428.320059999998,99.99,28024.766270493001,99.99,40.35116,0.17223240888232941,12214.780428399999,23428.614379999999,184.01]
["2017-09-04",295.22190000000001,57815,22473.00099,38.870537040560407,84349.14,29393.715384943003,34.847676437415963,22473.00099,99.99,29393.715384943003,99.99,38.078662341999994,0.16944182202877212,10835.568705800002,22473.00099,185.23]
["2017-10-04",287.27836000000002,52682,19750.435700000002,37.489912493830914,77996.599999999991,25440.306347345002,32.617199143738326,19738.84302,99.941304180950283,25436.797979605002,99.98620941237067,61.178829999999998,0.30994131691513899,8237.2729934999988,19750.435700000002,186.43]
["2017-11-04",371.98507999999998,74832,30441.697029999999,40.680052691361986,122708.58,52130.642539825996,42.48329052444906,30431.17353,99.96543063946261,52125.735723381003,99.990587462179775,55.299250000000001,0.18171908469282091,20034.582630899993,30441.697029999999,187.55]
["2017-12-04",301.8,69307,26441.087339999998,38.150673582754983,95689.37000000001,34589.42615198101,36.147616137488427,26344.632180000001,99.635207286448917,34588.616034641011,99.99,61.822400000000002,0.23466791860139763,14049.109953399997,26441.087339999998,188.74]
["$ indicates as on December 31, 2017"]
["Source: BSE."]

{"sheet":"32","index":32,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Table 32: 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)"]
["2016-17",19728.340499999998,2584979.49389,725682.13911999995,28.099646049323507,4998105.6923700003,1479963.1264537419,29.567869905478531,724494.50391999993,100,1478866.6969071468,100,1187.6369654425505,0.17419827885274486,409421.97000000003,1479963.1264537419,197.17]
["2017-18$",17932.23933,2634744.3861100003,701201.34949999989,26.613638620757072,5155960.6300799996,1470710.9870400003,28.524480548975429,699997.43629999983,100,1469533.15674,100,1203.9131999999997,0.17198822989460713,362374.57999999996,1470710.9870400003,218.31]
["2017-04-14",1678.94715,249467.13589999996,72463.982239999998,29.047506389397725,474912.10229999991,143865.50703000001,30.293080831854819,72373.597860000009,100,143748.49127999999,100,90.384379999999993,0.12488584604407835,31734.769999999997,143865.50703000001,197.84]
["2017-05-17",2051.2986999999998,289353.48480000003,78718.365609999993,27.204913624734743,581636.72600000002,166371.44521000001,28.604013084620796,78619.324139999982,100,166252.20267999999,100,99.041470000000004,0.12597598756208289,39228.170000000006,166371.44521000001,202.73]
["2017-06-19",1847.1066599999999,252857.19321000003,66111.920890000009,26.145952207534588,495032.07860000001,144966.73461000001,29.284311234936606,66014.00774999999,100,144866.97991999998,100,97.913139999999999,0.14832176281555942,37937.429999999993,144966.73461000001,200]
["2017-07-22",1829.51367,316019.11154000001,85405.236879999997,27.025339215660015,537173.44082000002,155963.52738000001,29.03410994071492,85211.894870000018,100,155842.55683000002,100,193.34200999999999,0.22638191411102612,39435.669999999991,155963.52738000001,204.54]
["2017-08-17",1908.2544499999999,280299.57260000001,72132.68776999999,25.734141190766834,553001.38189999992,148406.26843000003,26.836509507463862,71884.88142000002,100,148252.91116000002,100,247.80635000000001,0.34472665893701343,39754.029999999992,148406.26843000003,209.96]
["2017-09-17",2034.6867299999999,292471.57060000004,77362.032729999992,26.451129103349501,589711.52799999982,164302.54167999999,27.861510904701198,77253.891919999995,100,164174.00591999994,100,108.14081,0.13998105119672788,40163.599999999999,164302.54167999999,209.21]
["2017-10-17",1991.0092999999999,282106.96415999997,76300.115529999995,27.046519662210667,602655.25196000002,175442.73063000001,29.111623944106046,76157.150999999983,100,175295.78194000002,100,142.96453,0.1877230543983979,43090.29,175442.73063000001,211.38]
["2017-11-17",2475.8324200000002,355488.26150000014,92837.162960000001,26.115394800455306,722943.46679999994,201297.84971999997,27.844203449408639,92737.254050000003,100,201169.44530000005,100,99.908910000000006,0.10773330634324513,48046.499999999993,201297.84971999997,217.05]
["2017-12-01",2115.5902500000002,316681.09179999999,79869.844889999993,25.220907391730798,598894.65369999991,170094.38235,28.401386003222562,79745.433290000001,100,169930.78171000004,100,124.41160000000001,0.15601093989616718,42984.119999999988,170094.38235,218.31]
["$ indicates as on December 31, 2017"]
["Source: NSE."]

{"sheet":"33","index":33,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Table 33: Settlement Statistics for Cash Segment of MSEI"]
["Month/\nYear","No. of Trades(Lakh)","Traded Quantity (Lakh)","Delivered Quantity   (Lakh)","Percent of Delivered Quantity to Traded Quantity","Turnover (` 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)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,17,18,19]
["2016-17",0.20196000000000003,144.71549999999996,141.11568,97.51248484094657,248.08345292999996,237.11666553166665,95.579395856995049,141.11568,100,237.11666553166665,100,3.5200000000000002E-2,2.4944074251706118E-2,210.80143877999998,237.11666553166665,0.29859652400000003]
["2017-18",{"$f":"SUM(B6:B14)","v":1.6809999999999999E-2},{"$f":"SUM(C6:C14)","v":140.65924999999999},{"$f":"SUM(D6:D14)","v":16.992149999999999},{"$f":"D5/C5*100","v":12.080364426797384},{"$f":"SUM(F6:F14)","v":175.02764669000001},{"$f":"SUM(G6:G14)","v":25.883467240000002},{"$f":"G5/F5*100","v":14.788216450080869},{"$f":"SUM(I6:I14)","v":16.992149999999999},100,{"$f":"SUM(K6:K14)","v":25.883467240000002},100,0,0,{"$f":"SUM(O6:O14)","v":25.887646689999997},{"$f":"SUM(P6:P14)","v":25.883467240000002},0.31]
["2017-04-01",5.1000000000000004E-4,0.69740000000000002,0.69740000000000002,100,2.6864989499999998,2.6864989499999998,100,0.69740000000000002,100,2.6864989499999998,100,0,0,2.6864989499999998,2.6864989499999998,0.29859652400000003]
["2017-05-01",4.8999999999999998E-4,3.5792600000000001,1.9121600000000001,{"$f":"D7/C7*100","v":53.423333314707513},2.88,1.9658205500000001,{"$f":"G7/F7*100","v":68.257657986111127},1.9121600000000001,100,1.9658205500000001,100,0,0,1.97,1.9658205500000001,0.31]
["2017-06-01",3.2000000000000003E-4,1.2495000000000001,1.2495000000000001,{"$f":"D8/C8*100","v":100},0.90657774999999996,0.90657774999999996,{"$f":"G8/F8*100","v":100},1.2495000000000001,100,0.90657774999999996,100,0,0,0.90657774999999996,0.90657774999999996,0.31]
["2017-07-01",1.0499999999999999E-3,125.52889999999999,3.5289000000000001,{"$f":"D9/C9*100","v":2.8112251441699883},149.74561840000001,1.5156183999999999,{"$f":"G9/F9*100","v":1.0121287128091354},3.5289000000000001,100,1.5156183999999999,100,0,0,1.5156183999999999,1.5156183999999999,0.31]
["2017-08-01",1.3799999999999999E-3,3.13259,3.13259,{"$f":"D10/C10*100","v":100},3.4689474149999997,3.4689474149999997,{"$f":"G10/F10*100","v":100},3.13259,100,3.4689474149999997,100,0,0,3.4689474149999997,3.4689474149999997,0.31]
["2017-09-01",2.2699999999999999E-3,2.0019999999999998,2.0019999999999998,{"$f":"D11/C11*100","v":100},4.1667301999999999,4.1667301999999999,{"$f":"G11/F11*100","v":100},2.0019999999999998,100,4.1667301999999999,100,0,0,4.1667301999999999,4.1667301999999999,0.31]
["2017-10-01",3.7100000000000002E-3,2.7919999999999998,2.7919999999999998,100,6.3244781750000003,6.3244781750000003,100,2.7919999999999998,100,6.3244781750000003,100,0,0,6.3244781750000003,6.3244781750000003,0.31]
["2017-11-01",5.1700000000000001E-3,1.2769999999999999,1.2769999999999999,{"$f":"D13/C13*100","v":100},3.5707212500000001,3.5707212500000001,{"$f":"G13/F13*100","v":100},1.2769999999999999,100,3.5707212500000001,100,0,0,3.5707212500000001,3.5707212500000001,0.31]
["2017-12-01",1.91E-3,0.40060000000000001,0.40060000000000001,100,1.2780745499999999,1.2780745499999999,100,0.40060000000000001,100,1.2780745499999999,100,0,0,1.2780745499999999,1.2780745499999999,0.31]
["$ indicates as on December 31, 2017"]
["Source: MSEI"]

{"sheet":"34","index":34,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,0,16,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],[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 34: 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)"]
["2016-17",248,32288,2266.9588757499996,2901,203.0703815,24433,1254.8940116000001,63916,3214.4509813,0,0,0,0,123538,6939.374250150001,107,7.71]
["2017-18$",186,44101,3216.2074121250002,335,27.858551250000001,82,5.9207460000000003,32,2.284462875,3,0.17921999999999999,0,0,44553,3252.4503922500003,7,0.49]
["2017-04-04",18,18597,1330.182556875,51,4.3414582500000005,82,5.9207460000000003,32,2.284462875,0,0,0,0,18762,1342.7292239999999,91,6.52]
["2017-05-04",22,14812,1080.579984,69,5.4005650000000003,0,0,0,0,0,0,0,0,14881,1085.9805490000001,281,21.06]
["2017-06-04",21,6267,468.00826725000002,43,3.4235345000000006,0,0,0,0,0,0,0,0,6310,471.43180175000003,66,5]
["2017-07-04",21,4165,317.32067249999994,59,4.3507950000000006,0,0,0,0,1,6.3854999999999995E-2,0,0,4225,321.7353225,117,9.18]
["2017-08-04",21,248,19.174711500000001,28,2.311677,0,0,0,0,2,0.115365,0,0,278,21.601753500000001,1,0.08]
["2017-09-04",21,11,0.86437200000000003,21,2.2662867499999999,0,0,0,0,0,0,0,0,32,3.1306587499999998,6,0.6]
["2017-10-04",20,1,7.6848E-2,21,2.6530050000000003,0,0,0,0,0,0,0,0,22,2.7298530000000003,11,0.73]
["2017-11-04",22,0,0,24,1.7525647499999999,0,0,0,0,0,0,0,0,24,1.7525647499999999,4,0.28999999999999998]
["2017-12-04",20,0,0,19,1.358665,0,0,0,0,0,0,0,0,19,1.358665,7,0.49]
["Note: 1. Notional Turnover = (Strike Price + Premium) * Quantity."]
["$ indicates as on December 31, 2017"]
["Source: BSE."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"35","index":35,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[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],[2,12,2,13],[16,0,16,5],[1,14,2,15],[1,16,2,17],[2,6,2,7],[2,8,2,9],[2,10,2,11]]}
["Table 35: 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)"]
["2016-17",248,66535071,4335940.8669368746,173860130,11129587.189949306,548735127,38097964.384784557,518509789,34699323.311763808,61205774,4147487.9247215153,30900238,1959997.9397227899,1399746129,94370301.617878839,3542404,249497.47536044996]
["2017-18$",186,39910085,3271423.8679253999,156143708,11347701.479494654,547278540,48805976.179908119,523596151,45060110.385787733,62543398,4863379.4279912049,29194925,2143045.45161227,1358666807,115491636.7973194,4074351,317935.02675782505]
["2017-04-14",18,4174077,314579.89140094997,15323013,1160682.4806404901,46181751,3729736.0531744501,45548822,3554410.9430585499,6024771,487146.94306098,2823557,213125.24269360999,120075991,9459681.5540290307,3718137,263898.84912227001]
["2017-05-17",22,4816269,375948.83030067501,19724492,1402147.8829111154,55223511,4617328.2359923245,57343652,4630977.84000865,7598657,580166.66911648994,3814715,274832.924256475,148521296,11881402.382585727,4312372,312587.69447087502]
["2017-06-17",21,4052219,322143.5969,15718759,1110361.737,56299371,4863586.1370000001,53752489,4520106.9460000005,5627829,425458.79,2655447,190610.08910000001,138106114,11432267.300000001,3687855,263318.85699867504]
["2017-07-17",21,4224510,346731.66438680002,16974717,1234362.9768243101,54692544,4820709.9279488241,58510108,4995039.0779453497,7194451,550014.79445507994,3389270,245582.5571797,144985600,12192440.998740062,3997987,303766.95518520998]
["2017-08-17",21,4789537,399317.45222832501,17470818,1257968.4341696252,71981496,6527897.1584024513,65275950,5712285.5397554748,7430204,568668.52011559997,3739525,269013.25078991998,170687530,14735150.355461398,3371674,246903.95236297001]
["Sepr-17",21,4467175,369891.06969999999,17314055,1280396.017,64918248,5776218.301,61418880,5298926.2769999998,7078836,569008.28520000004,3284450,255920.7395,158481644,13550360.689999999,4023390,295655.18921854999]
["2017-10-17",20,4238220,358296.27442157501,16836256,1261299.5541961051,61461946,5619655.9805629253,57594920,5062586.0533398511,6748271,545499.14793152502,3070077,234377.52079433997,149949690,13081714.531246325,4642195,351390.94265059999]
["2017-11-17",22,4378831,377959.25971050002,19600435,1396413.44719005,72949308,6887013.9413904203,64619921,5931258.1052674996,7877171,606165.19211731502,3518583,252658.712048805,172944249,15451468.6577246,3963228,293504.61610605998]
["2017-12-01",20,4769247,406555.82887657499,17181163,1244068.9495629601,63570365,5963830.4444367262,59531409,5354519.6034123497,6963208,531251.0859942151,2899301,206924.41524941998,154914693,13707150.327532247,4074351,317935.02675782505]
["Note: 1. Notional Turnover = (Strike Price + Premium) * Quantity."]
["$ indicates as on December 31, 2017"]
["Source: NSE."]

{"sheet":"36","index":36,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,11,3,11],[2,12,3,12],[15,0,15,5],[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 36: 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"]
["2016-17",15.099999999999998,1.1100000000000001,33.380000000000003,0.01,49.599999999999994,192.09000000000003,70441.81,2049.23,15021.649999999998,2579.88,90092.569999999992,1051.99]
["2017-18$",10.220000000000001,0.32000000000000006,6.0000000000000005E-2,0,10.6,17.59,76395.529999999984,1631.1299999999999,13685.71,2581.5499999999997,94293.92,1567.82]
["2017-04-04",2.08,0.04,0.05,0.01,2.17,16.73,5356.92,79.83,1278.31,244.02,6959.08,1100.3499999999999]
["2017-05-04",2.41,7.0000000000000007E-2,0.05,0,2.48,16.84,10259.5,394.85,1239.48,192.7,12086.53,1132.6300000000001]
["2017-06-04",2.71,0.12,0.05,0,2.83,16.95,5229.8,144.04,1329.6,407.73,7111.17,1146.3800000000001]
["2017-07-04",1.32,0.04,0.05,0,1.36,17.059999999999999,6552.16,162.87,1649.59,143.75,8508.3700000000008,1196.51]
["2017-08-04",1.0900000000000001,0.03,0.01,0,1.1299999999999999,17.18,11556.76,90.31,1583.68,169.63,13400.38,1218]
["2017-09-04",0.13,0.03,0.01,0,0.13,17.29,9253.98,145.16999999999999,1443.76,153.22,10996.13,1421.87]
["2017-10-04",0.18,0.03,0.01,0,0.18,17.41,8666.89,166.7,1708.13,226.84,10768.56,1432.32]
["2017-11-04",0.23,0.02,0.01,0,0.25,17.5,9469.0400000000009,362.52,1347.12,155.08000000000001,11333.76,1465.19]
["2017-12-04",7.0000000000000007E-2,0.02,0.01,0,7.0000000000000007E-2,17.59,10050.48,84.84,2106.04,888.58,13129.94,1567.82]
["$ indicates as on December 31, 2017"]
["Source: BSE and NSE"]

{"sheet":"37","index":37,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5],[1,6,1,10],[14,0,14,5]]}
["Table 37: 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"]
["2016-17",72.461825779561678,0,0,0,27.538174220438322,65.887850467289724,0,0,0,34.112149532710276]
["2017-18$",90.844625979245023,1.55096880363495,0,0,7.6044052171200267,0,0,0,0,100]
["2017-04-04",94.939047414745176,0.17647414181848475,0,0,4.8844784434363397,91.03,0,0,0,8.9700000000000006]
["2017-05-04",95.742584969171503,0,0,0,4.257415030828497,94.330799999999996,0,0,0,5.6692]
["2017-06-04",81.419763953694712,8.1563199692435688,0,0,10.423916077061719,45.55,0,0,0,54.45]
["2017-07-04",76.048838133089987,2.9668620314451175,0,0,20.984299835464896,25.0931,0,0,0,74.906899999999993]
["2017-08-04",37.985105873465322,0.36104360694607501,0,0,61.653850519588602,0,0,0,0,100]
["2017-09-04",47.434166211823623,0,0,0,52.565833788176377,50,0,0,0,50]
["2017-10-04",44.700813560290612,0,0,0,55.299186439709388,50,0,0,0,50]
["2017-11-04",41.702161075646423,0,0,0,58.297838924353577,0,0,0,0,100]
["2017-12-04",0,0,0,0,100,0,0,0,0,100]
["$ indicates as on December 31, 2017"]
["Source: BSE."]

{"sheet":"38","index":38,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,5],[1,6,1,10],[14,0,14,5]]}
["Table 38: 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"]
["2016-17",42.06696663713263,13.747339229662797,0.40370141801453302,0,43.783686257126277,13.240150824172201,31.2372138347895,8.679193191740179,0,46.843442149298099]
["2017-18$",42.62,10.93,0.46,0,45.99,13.071052674530579,21.209601383091613,12.232784096508144,0,53.486561845869673]
["2017-04-01",41.723667672142902,10.820978788187899,0.47758335216789599,0,46.977770187501299,14.317806018929916,26.239478598953887,9.2371419442430298,0,50.205573437873177]
["2017-05-17",41.392811719015597,11.8357790833298,0.39501575080018902,0,46.376393446854401,15.442071723180623,26.192490605227313,8.714404591533917,0,49.650383785348737]
["2017-06-17",41.711595789950003,10.7014193387795,0.40975063876624002,0,47.18,13.707375617364461,27.423265671580275,9.7203549815149941,0,49.148325828517073]
["2017-07-17",42.963472832685596,10.712053408217308,0.41708162598941384,0,45.907392133107685,15.060295358713113,24.235402525171423,10.226323954110894,0,50.477978162004568]
["2017-08-17",42.252806098236398,11.0513605501203,0.38100024812003103,0,46.31483310352327,12.068517310469119,24.331151874580975,12.956874383002981,0,50.643456431946923]
["2017-09-17",42.01,11.04,0.47,0,46.480000000000004,12.84,24.84,11.87,0,50.46]
["2017-10-17",43.487320819209899,9.7293737990782994,0.54340077909351803,0,46.239904602618282,14.096244146625496,23.59917530374646,11.667941925735978,0,50.636638623892061]
["2017-11-17",44.02,10.94,0.48,0,44.56,12.03366599995408,25.311343508711463,13.784385804799978,0,48.869368320310699]
["2017-12-01",43.233327756413097,11.567688896862199,0.51590369785474399,0,44.683079648869999,13.071052674530579,21.209601383091613,12.232784096508144,0,53.486561845869673]
["$ indicates as on December 31, 2017"]
["Source: NSE."]

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

{"sheet":"40","index":40,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,10],[14,0,14,5]]}
["Table 40: 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"]
["2016-17",54.466014224134859,5.0275883629818828E-3,45.518386628221926,1.5248629182323644E-6,6.9786006630976451E-7,1.419005168569006E-6,2.8102577065290374E-6,5.7007381392454939E-3,4.1124110666380673E-3,1.9157077912717019E-5]
["2017-18$",35.148329986031314,2.8480707181412139E-3,64.843549525411419,8.5697397151869657E-4,2.2919467361832286E-6,2.5698106878063219E-6,7.0069738966903212E-7,2.8057424280024949E-3,1.5168081371636783E-3,0]
["2017-04-16",38.237174446253988,5.056146400329844E-3,61.749785708921969,0,0,0,0,4.1603177206495853E-3,2.9467418136108507E-3,0]
["2017-05-17",38.762154819752283,4.3788485872715234E-3,61.226598585986281,0,9.5275946961837472E-6,0,0,4.4514284266253864E-3,2.2645140545612345E-3,0]
["2017-06-17",34.450000000000003,4.9894776819678858E-3,65.540000000000006,0,0,1.2354808137902924E-5,0,4.6337317670286328E-3,1.6803027433482439E-3,0]
["2017-07-17",36.704453927108865,3.8777804139144734E-3,63.284932132075433,1.3827332573525559E-5,0,0,0,5.0292933913730024E-3,1.6750135180851823E-3,0]
["2017-08-17",31.885933694814394,2.0055476639418653E-3,68.105040702261832,0,9.6981683248173457E-6,3.510681749439593E-6,0,4.5502517358839119E-3,2.4496956668855143E-3,0]
["2017-09-17",38.956604650000003,1.8374960000000001E-3,61.036927810000002,9.5936799999999996E-6,0,0,0,2.720835E-3,1.8996149999999999E-3,0]
["2017-10-17",32.967814014370958,1.6243503259690097E-3,67.027788018370188,0,0,7.7295144146782043E-6,6.1649167911206883E-6,1.2092460645631573E-3,1.5504764371039126E-3,0]
["2017-11-17",31.779657173633819,1.5891340120629534E-3,68.218739261529464,0,0,7.7295144146782043E-6,6.1649167911206883E-6,1.2092460645631573E-3,1.5504764371039126E-3,0]
["2017-12-01",35.056163859876641,1.9592939373271469E-3,64.934798409994514,7.078436191521674E-3,0,0,0,1.2092460645631573E-3,1.5504764371039126E-3,0]
["$ indicates as on December 31, 2017"]
["Source: NSE."]

{"sheet":"41","index":41,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,0,15,11],[16,0,16,5],[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]]}
["Table 41: 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)"]
["2016-17",242,362615931,2489778.9357585004,205484781,1396641.0541205001,144350727,970655.86492399999,712451439,4857075.8548030006,4734914,30871.429250000001]
["2017-18$",183,276525905,1832876.5827367501,157057134,1025253.9059085,124500130,805924.9803535,558083169,3664055.4689987497,3805136,24671.149599830002]
["2017-04-14",18,27621713,181185.62938574998,18853378,123279.42861924999,14430861,93539.269776749992,60905952,398004.32778175006,4675628,30260.306960000002]
["2017-05-17",21,27752227,182960.46474874998,17856365,116543.03489525002,14483328,93619.011668250008,60091920,393122.51131224993,4430643,28809.461889999999]
["2017-06-17",21,24883610,165606.92256275,14766432,96352.871808500015,9704177,62771.738161999987,49354219,324731.53253324999,3881086,25366.881690000002]
["2017-07-17",21,23904725,158914.59230624998,14807555,96590.081703499993,10344505,66973.585836500002,49056785,322478.25984624994,4636459,30103.986010000001]
["2017-08-17",20,25688528,169544.89924700002,18540246,120133.3289065,12930611,82973.743278499998,57159385,372651.97143199993,4818635,31171.934173580001]
["2017-09-17",21,41799966,277485.89957625,22173475,144782.04357399998,20923664,135356.27510149998,84897105,557624.21825174999,6013600,39665.58689975]
["2017-10-17",20,29918578,199645.60087900003,16293776,107111.31160525003,15094323,98431.519851999998,61306677,405188.43233624997,3715748,24327.747055200001]
["2017-11-17",22,40166428,267316.23559200001,18663086,122276.44930725,16404923,106584.4655835,75234437,496177.15048274997,3771733,24646.705617120002]
["2017-12-01",19,34790130,230216.33843899998,15102821,98185.35548899998,10183738,65675.371094499991,60076689,394077.0650225,3805136,24671.149599830002]
["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 December 31, 2017"]
["Source: NSE."]
[]
[null,null,null,null,null,null,null,null,null,348330.80088375002]
[null,null,null,null,null,null,null,null,null,426596.54334024998]
[null,null,null,null,null,null,null,null,null,547667.75119724998]
[null,null,null,null,null,null,null,null,null,315238.64499624999]
[null,null,null,null,null,null,null,null,null,336005.45772725]
[null,null,null,null,null,null,null,null,null,423295.61060525]
[null,null,null,null,null,null,null,null,null,2397134.8087499999]

{"sheet":"42","index":42,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,8,2,9],[1,10,2,11],[2,4,2,5],[2,6,2,7],[15,0,15,3],[1,0,3,0],[1,1,3,1],[1,2,2,3],[1,4,1,7]]}
["Table 42: 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)"]
["2016-17",242,42223837,285472.84277700004,954966,6432.813286749999,877609,6022.0180270000001,44056412,297927.67409075005,232589,1518.3514342500041]
["2017-18$",183,11785272,76331.734944250013,928680,6077.8621767499999,818935,5340.554427,13532887,87750.151548000009,128412,825.98346074999995]
["2017-04-01",18,1471757,9535.4690749999991,57763,377.98408524999996,39504,256.34527350000002,1569024,10169.798433749998,231735,1503.5669052499998]
["2017-05-01",21,1992752,12902.942646249998,51486,338.25196874999995,51822,341.15406075000004,2096060,13582.348675749998,292390,1906.2135549999998]
["2017-06-01",21,1981564,12832.310015249999,123257,801.96186050000017,87099,568.27043524999999,2191920,14202.542310999999,225653,1475.5876867499996]
["2017-07-01",21,1821292,11788.639137750002,64998,427.22788874999998,67821,440.65356624999998,1954111,12656.520592750003,321444,2083.1199144999996]
["2017-08-01",20,1166727,7500.1248065,88805,575.92539175000002,100211,645.80789825000011,1355743,8721.8580965000001,307427,1983.1671742500014]
["2017-09-01",21,884575,5777.2379187500001,170441,1120.34652575,152547,998.13993499999992,1207563,7895.7243794999995,235695,1557.6012149999992]
["2017-10-01",20,524618,3432.5193920000006,173420,1140.8200272500001,177921,1168.6677434999999,875959,5742.0071627500001,194392,1272.0747570000005]
["2017-11-01",22,674203,4389.3382822499998,112294,735.8777675,67014,439.57756524999996,853511,5564.7936149999996,120557,784.04762025000002]
["2017-12-01",19,1267784,8173.153670499999,86216,559.4666612499999,74996,481.93794925000003,1428996,9214.5582809999996,128412,825.98346074999995]
["$ indicates as on December 31, 2017"]
["Source: MSEI"]

{"sheet":"43","index":43,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,11],[15,0,15,5],[16,0,16,5],[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 43: 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)"]
["2016-17",242,268339687,1807828.5310000002,111541346,758231.27079999994,90544169,605588.13560000004,470425202,3171647.9373999992,1598346,10381.870000000001]
["2017-18$",183,206019443,1335394.9557000003,113225948,743758.97000000009,170857957,1081381.4512,490103348,3160535.2626,1258826,8087.7753910800011]
["2017-04-04",18,20518735,132905.016,17411265,114292.99850000002,14234398,91523.090500000006,52164398,338721.10500000004,1456658,9363.429339575001]
["2017-05-04",21,22099454,143176.72040000005,18403355,120531.74100000001,19125359,122579.47230000001,59628168,386287.93370000005,1396753,9023.0499999999993]
["2017-06-04",21,20163249,130748.04230000003,18063571,118403.2807,17900534,114706.87399999998,56127354,363858.19699999999,1038281,6741.29]
["2017-07-04",21,20009031,129619.05149999999,16488120,107779.81190000003,18259597,116903.872,54756748,354302.73540000001,1704163,10936.399102019999]
["2017-08-04",20,21796615,140054.30860000002,11728854,76715.197499999995,12913328,81281.632500000022,46438797,298051.13860000001,1666466,10686.43173857]
["2017-09-04",21,30341298,196980.63250000001,10375576,68219.126999999993,14815275,92794.252400000099,55532149,357993.89760000003,1610602,10315.156479130001]
["2017-10-04",20,21913065,143093.5007,7716174,51379.399700000024,23289847,146375.28719999985,52919086,340848.18759999989,933150,6046.1003249799996]
["2017-11-04",22,28566808,185853.766,9267404,61644.651900000019,24406399,153754.68700000015,62240611,401253.10490000021,1076949,6963.03775133]
["2017-12-04",19,20611188,132963.91769999999,3771629,24792.761799999993,25913220,161462.28329999975,50296037,319218.96279999975,1258826,8087.7753910800011]
["$ indicates as on December 31, 2017"]
["Source: BSE"]

{"sheet":"44","index":44,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,11,1,14],[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],[16,0,16,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],[1,10,4,10]]}
["Table 44: 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"]
["2016-17",5131.6970127500008,193.09517621999998,1098.3142855000001,451.13654268000005,6874.24301715,562.17096175000006,19.354808000000002,14.611617500000001,9.3295554500000009,605.4669427,3594.2999999999993,105.16,2896.64,223.14,6819.2399999999989]
["2017-18$",2635.5679467499999,95.819843270000007,781.78516275000004,341.45454781000007,3854.6275005799998,243.83254550000004,11.285399850000001,18.896324249999999,14.679423079999999,288.69369268000003,2333.42,91.78,2322.1799999999998,155.84,4903.2199999999993]
["2017-04-14",330.323578,16.768680029999999,122.5572205,73.557515039999998,543.20699357000001,39.937640000000002,2.83,1.54,0.53,44.83764,318.99,16.059999999999999,407.52,39.049999999999997,781.62]
["2017-05-01",417.36388075000002,3.2710264499999999,95.928764999999999,35.328426899999997,551.8920991,49.85,0.54,1.7,0.56999999999999995,52.660000000000004,353.53,4.6399999999999997,494.94,10.58,863.69]
["2017-06-17",149.78,1.43,68.010000000000005,17.91,237.13000000000002,17.02,5.3999999999999999E-2,0.67,0.21,17.954000000000001,147.71,0.83,344.92,8.74,502.2]
["2017-07-17",189.17006125,8.0647379699999995,77.013628249999996,29.332832680000003,303.58126015000005,20.079999999999998,1.91,1.83,1.39,25.21,149.65,9.58,312.13,15.53,486.89]
["2017-08-17",334.22494649999999,4.3115981099999994,81.682047749999995,22.878141399999997,443.09673375999995,31.3,1.08,3.27,2.42,38.070000000000007,277.93,7.41,166.83,16.88,469.05]
["2017-09-17",425.25933375,24.031904910000009,121.71713925,67.247680920000008,638.25605883000003,30.42445975,2.35,2.653343,4.58,40.007802749999996,351.59,23.02,179.43,22.96,577]
["2017-10-17",393.43458450000003,29.506796550000001,89.241746250000006,35.041233070000011,547.22436037,25,1.37,4.63,1.74,32.74,304.37,20.46,165.44,14.3,504.57]
["2017-11-17",246.646646,5.2595875399999992,63.097672500000002,37.790382340000008,352.79428838000001,22.6,0.99,2.04,2.83,28.46,274.70999999999998,5.0199999999999996,147.58000000000001,15.62,442.93]
["2017-12-01",149.36902599999999,3.1774903499999998,62.535349250000003,22.366243860000001,237.44810945999998,8.1904457500000021,0.16139985000000001,0.56298124999999999,0.40942307999999999,9.3242499300000024,154.94,4.76,103.39,12.18,275.27]
["$ indicates as on December 31, 2017"]
["Source: Respective stock exchanges"]

{"sheet":"45","index":45,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 45: 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"]
["2016-17",4507897.7881492507,99183.968137249991,183698.5956185,66295.502898000006,4606551,67631,43717,17015]
["2017-18$",3387399.0454787496,110047.42337725002,134623.44910125001,31985.551041500003,3577756,141027,59996,26357]
["2017-04-16",375224.38652725,8047.3024497500001,11271.904839500001,3460.73396525,4514665,94594,48928,17441]
["2017-05-17",366872.0968155,10063.13913675,12755.4962275,3431.7791324999998,4285462,82866,47918,14397]
["2017-06-17",292101.95274525002,10516.073324000001,18247.6955175,3865.8109464999998,3684399,117120,56481,23086]
["2017-07-17",292472.93539975001,12008.795379749999,14174.464419,3822.0646477499999,4399055,150348,65561,21495]
["2017-08-17",342196.62001800002,14549.516470250001,12336.692337500001,3569.14260625,4582455,161486,51059,23635]
["2017-09-17",522245.30146225,14490.99886175,16930.231313749999,3957.6866140000002,5787102,129707,70376,26415]
["2017-10-17",378394.70404400001,11034.057987,13104.164010250001,2655.5062950000001,3521235,113957,48987,31569]
["2017-11-17",458531.70433149999,16330.63578775,17438.878130749999,3875.9322327499999,3553278,129213,64954,24288]
["2017-12-17",359359.34413525002,13006.903980249999,18363.9223055,3346.8946015000001,3577756,141027,59996,26357]
["$ indicates as on December 31, 2017"]
["Source: NSE."]

{"sheet":"46","index":46,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 46: 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"]
["2016-17",289589.36888000008,2173.1384129999992,4391.6644955000002,1773.4907787500001,226074,1546,3268,1701]
["2017-18$",86542.339331499985,388.04952225000005,639.52661000000001,180.23610525000001,127201,498,689,24]
["2017-04-30",9917.6243712500145,106.76672000000003,118.25748374999996,27.149858749999996,228201,138,2794,602]
["2017-05-30",13432.294951999995,33.952947999999978,90.845741500000045,25.255034249999984,291263,128,900,99]
["2017-06-30",14084.053886000009,27.767697999999992,74.107005000000015,16.613742999999999,223861,607,970,215]
["2017-07-30",12440.144835749978,67.946026000000032,59.574944749999972,88.854786250000018,319547,952,745,200]
["2017-08-30",8606.5508354999965,34.210890249999984,73.378225499999985,7.7181452499999992,302583,736,3775,333]
["2017-09-30",7746.3264147500076,44.408787749999995,99.439778749999974,5.5493982499999985,231419,982,3241,53]
["2017-10-30",5675.3181062500007,24.336570750000003,38.656434499999996,3.6960512500000009,192965,156,1248,23]
["2017-11-30",5500.3834882499978,27.22997800000001,33.545635749999995,3.6345130000000001,119125,684,729,19]
["2017-12-30",9139.6424417500002,21.429903500000009,51.721360500000046,1.7645752499999998,127201,498,689,24]
["$ indicates as on December 31, 2017"]
["Source: MSEI"]

{"sheet":"47","index":47,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 47: 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"]
["2016-17",3148260.1672999999,9756.0034999999989,9401.1265999999996,4230.6399999999994,1575230,11810,9156,2150]
["2017-18$",2826208.7169000003,6075.3375999999998,7756.0427,1276.2026000000001,1062394,6555,7358,642]
["2017-04-13",336519.95020000002,667.48299999999995,1295.1177,238.55410000000001,1445427,6993,2533,1705]
["2017-05-14",384078.53600000008,887.19420000000014,1208.2427,113.96080000000002,1389505,4175,2603,470]
["2017-06-14",361085.91560000001,1051.2674999999999,1608.1129999999998,112.90089999999999,1022494,8718,6242,827]
["2017-07-15",352046.495,985.37,901.21039999999994,369.65999999999997,1690887,9274,3319,683]
["2017-08-15",296228.00349999999,848.94039999999995,880.44619999999998,93.748499999999993,1653022,7028,5627,789]
["2017-09-15",356558.48250000004,601.51689999999996,690.60509999999999,143.29310000000001,1602427,2469,4406,1300]
["2017-10-16",339898.49859999988,347.07849999999996,479.58810000000005,123.02239999999999,921864,2922,1706,6658]
["2017-11-16",399792.83550000016,686.48709999999994,692.71950000000004,81.062799999999996,1062394,6555,7358,642]
["2017-12-17",317627.86529999971,740.50279999999998,788.06660000000011,62.528099999999995,1229653,22646,5769,758]
["$ indicates as on December 31, 2017"]
["Source: BSE"]

{"sheet":"48","index":48,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 48: 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"]
["2016-17",1999419.57419375,429520.32765399996,40831.977613499999,20007.056297250001,1954971.52651975,398290.24093924992,13984.87507075,50.276514750000011]
["2017-18$",1425549.8737765001,352950.05108175002,37611.580236000002,16765.0776425,1495731.85299,315385.70730275003,16463.575661999999,3597.7503072499999]
["2017-04-16",135414.65723225003,39230.801059750003,4754.7426537499996,1785.4284399999995,178366.66516450001,38198.920673499997,252.0210635,1.0914945]
["2017-05-16",138347.51354499999,39046.828908750002,3944.5495917499998,1621.5727032499999,167617.77818875,41422.297188750003,1118.7855462499999,3.1856397500000004]
["2017-06-17",129961.27304799999,30622.693702750003,3417.8098107500005,1605.1460012500002,128496.79903724999,29700.864196749997,841.30365699999993,85.643079499999999]
["2017-07-17",122478.44919824999,31047.827538000001,3460.3599057499996,1927.9556642499995,129067.14491225001,30462.765281749998,3974.2139859999993,59.54336]
["2017-08-17",128125.30123149998,33510.578234750006,5121.8495672499994,2787.1702134999996,165493.85870924999,33149.510413749995,3378.0170882499997,1085.6859737499999]
["2017-09-17",197038.34041550005,70331.462800499998,6970.1567977500017,3145.9395625000002,214575.19527300002,61349.892828000004,1878.4281972499998,2334.8023772500001]
["2017-10-17",163775.10623600002,32137.879978499997,2533.5875814999999,1199.0270830000004,174389.22373150001,29666.101623500002,1482.98035725,4.5257450000000006]
["2017-11-17",216060.16261375003,45755.751268999993,4219.6994125000001,1280.62229675,194779.86066950002,32687.644457999999,1389.8620839999999,3.5476792500000003]
["2017-12-01",194349.07025625001,31266.227589750004,3188.8249149999997,1412.2156780000003,142945.32730399998,18747.710638749999,2147.9636824999998,19.724958250000004]
["$ indicates as on December 31, 2017"]
["Source: NSE."]

{"sheet":"49","index":49,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 49: 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"]
["2016-17",231099.26483950001,52784.177152999997,1532.0660904999997,57.339073499999998,12098.319521999998,344.85279349999996,11.6629,0]
["2017-18$",58760.559990749985,16051.513378,1502.6755035000001,16.986056250000001,8143.5728070000005,2391.2915492499997,582.82600000000002,300.72624999999994]
["2016-04-30",7054.8388064999999,2209.6342040000004,270.98950950000005,6.5399999999999998E-3,527.17367400000001,60.101684000000006,47.054000000000002,0]
["2017-05-30",9551.7125330000017,3207.0152425000001,144.01786300000001,0.19699,118.745901,124.43712699999999,436.22300000000001,0]
["2017-06-30",9278.5322809999998,2775.2827990000001,769.25469350000003,9.2402414999999998,1152.326589,191.21770649999999,26.687999999999999,0]
["2017-07-30",9127.7872780000034,2549.229945,111.29493200000002,0.32699999999999996,263.75837299999995,604.12308700000006,0,0]
["2017-08-30",5848.5322039999874,1612.2085667499991,36.787575750000002,2.59646,623.98145599999975,584.48183400000005,0,13.27]
["2017-09-30",4142.4032029999926,1495.1381995000002,138.46016100000006,1.2363552499999999,1734.4731157500007,96.557095000000018,0,287.45624999999995]
["2017-10-30",2697.4287910000012,723.29783974999998,11.786156750000002,6.6045000000000001E-3,1813.1441679999989,423.4826027499999,72.86099999999999,0]
["2017-11-30",3703.6213239999961,670.00878625000007,13.1261215,2.5820504999999998,1046.5068317499997,128.94850100000002,0,0]
["2017-12-30",7355.7035702499998,809.69779525000001,6.9584904999999999,0.79381449999999998,863.46269849999999,177.941912,0,0]
["$ indicates as on December 31, 2017"]
["Source: MSEI"]

{"sheet":"50","index":50,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 50: 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"]
["2016-17",1570858.1343702502,222641.9086735,13202.433876000003,1118.434679,1221761.1903335,137286.83551825001,4461.4851657500003,309.19624999999996]
["2017-18$",1202943.4100000001,191396.71000000002,11592.020000000002,2371.33,1551562.46,195785.66,4082.39,796.56]
["2017-04-04",180181.69,25587.919999999995,42.36,4.8699999999999992,110665.26999999999,19729.88,1995.4799999999998,513.61]
["2017-05-04",122794.77999999997,18298.559999999994,1764.56,317.93999999999994,199364.43999999997,43611.35,123.80000000000001,11.3]
["2017-06-04",111195.43,17370.46,1913.4800000000005,267.76,211236.96,21828.69,30.88,13.299999999999999]
["2017-07-04",107680.03999999998,19727.28,2007.1699999999998,204.67,206342.12999999995,18214.34,83.97,42.89]
["2017-08-04",118657.73,19162.480000000003,1821.06,412.09000000000003,143283.65000000002,14210.810000000001,492.65000000000003,9.3699999999999992]
["2017-09-04",158915.76999999999,35525.040000000001,2014.5000000000002,524.84,144685.94,15695.74,510.63,121.00999999999999]
["2017-10-04",125696.25,16709.100000000002,496.65999999999997,191.66,169265.77000000002,28153.69,334.91,0]
["2017-11-04",160737.1,24073.67,824.54,217.89999999999995,194538.03,20530.41,306.20999999999998,25.27]
["2017-12-04",117084.62,14942.199999999999,707.68999999999994,229.59999999999997,172180.27000000002,13810.75,203.86,59.810000000000009]
["$ indicates as on December 31, 2017"]
["Source: BSE"]

{"sheet":"51","index":51,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,6,5,6],[4,7,5,7],[4,8,5,8],[1,0,5,0],[1,1,5,1],[1,2,1,5],[2,2,3,3],[2,4,3,5],[2,6,3,7],[1,6,1,9],[17,0,17,5],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[1,10,1,13],[2,8,3,9],[2,10,3,11],[2,12,3,13],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13]]}
["Table 51: 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)"]
[]
["2016-17",242,6185341,127979.4124,18044,377.6807,14807039,307809.32010699995,120422,2482.4497529999999,125175.49764749999,2551.8521309999992,0,0]
["2017-18$",183,7676259,155052.99100000001,5901,112.5406,12009762,242431.88294050001,1324.7643876530055,183,10648,218.54813299999995,240,4.7115840000000011]
["2017-04-04",18,534693,11046.7248,13550,279.0231,1596049,32824.362904999994,88000,1803.5133559999999,0,0,0,0]
["2017-05-04",21,595544,12230.2824,4158,84.726600000000005,1082509,22208.391542499998,91173,1871.2867900000001,0,0,0,0]
["2017-06-04",21,902593,18656.991600000001,5410,111.79040000000001,1298346,26851.832140500006,87169,1797.4729609999999,0,0,0,0]
["2017-07-04",21,1067242,21989.516100000004,6406,132.02950000000001,1094905,22437.4836435,88671,1824.448533,10376,213.19508099999996,0,0]
["2017-08-04",20,838492,17102.266099999997,3,6.0999999999999999E-2,1057191,21572.845845,94787,1938.643519,12,0.24635199999999999,10,0.20338200000000003]
["2017-09-04",21,560262,11354.9076,12757,257.62020000000001,1195149,24201.007205999998,98710,1996.6730970000001,0,0,0,0]
["2017-10-04",20,947198,18967.921000000002,27623,551.58420000000001,1250840,25041.386688999999,96539,1926.8903945,0,0,0,0]
["2017-11-04",22,1336981,26430.3043,47,0.92259999999999998,1845819,36432.648518000002,71729,1413.2192239999999,260,5.1067,240,4.7115840000000011]
["2017-12-04",19,893254,17274.077100000002,5901,112.5406,1588954,30861.924450999995,83651,1612.10628,0,0,0,0]
["$ indicates as on December 31, 2017"]
["Source: BSE, NSE and MSEI"]

{"sheet":"52","index":52,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,4],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6]]}
["Table 52: 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"]
["2016-17",101.69984199999999,8.3763419999999993,1128.3717025000001,41.862663360000006,10.030167,0]
["2017-18$",196.87490300000002,10.424153,544.49995049999995,19.127670479999999,5.04E-2,0]
["2017-04-04",24.581016000000002,1.24733,75.886161999999999,1.7786042400000002,0,0]
["2017-05-04",22.984908999999998,0.93076099999999995,65.144258500000007,2.0008222,0,0]
["2017-06-04",11.013453999999999,0.14634900000000001,56.66,1.53,0,0]
["2017-07-04",11.300770999999999,0.37545600000000001,36.830773999999998,0.88781024000000008,2.81E-2,0]
["2017-08-04",13.358457,0.46288200000000002,38.933398500000003,0.30706518000000005,2.5999999999999999E-3,0]
["2017-09-04",16.005580999999999,0.80144899999999997,67.553060000000002,1.6432104999999999,2.5999999999999999E-3,0]
["2017-10-04",19.645913,0.61662799999999995,54.011732500000001,0.88853211999999993,2.5999999999999999E-3,0]
["2017-11-04",43.012360000000001,0.90570799999999996,88.787838500000007,2.21362426,1.9716000000000001E-2,0]
["2017-12-04",34.972442000000001,4.9375900000000001,60.693891999999998,7.8789587799999996,0,0]
["$ indicates as on December 31, 2017"]
["Source: NSE, BSE and MSEI"]

{"sheet":"53","index":53,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,0,13,5],[14,0,14,5]]}
["Table 53: 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.)"]
["2016-17",1507027.6999999997,1458616.67,48411.03,7599.6499999999978,231187.34999999998]
["2017-18$",1143761.9199999999,1008797,134964.91999999998,20908.980000000003,252096.32999999996]
["2017-04-01",121630.47,98872.23,22758.240000000002,3513.38,234700.72999999998]
["2017-05-01",148177.26,121311.1,26866.16,4169.96,238870.68999999997]
["2017-06-01",169484.3,140182.37,29301.93,4548.13,243418.81999999998]
["2017-07-01",143879.88999999998,119852.02999999998,24027.860000000004,3732.0199999999995,247150.83999999997]
["2017-08-01",124845.86,122169.03,2676.83,426.59,247577.42999999996]
["2017-09-01",127847.98,137891.35999999999,-10043.379999999999,-1532.75,246044.67999999996]
["2017-10-01",145518.96,126399.87,19119.09,2933.47,248978.14999999997]
["2017-11-01",162377.20000000001,142119.01,20258.189999999999,3118.18,252096.32999999996]
["2017-12-01",141460.51,145004.29,-3543.78,-551.65,251544.67999999996]
["$ indicates as on December 31, 2017"]
["Source: NSDL, CDSL"]

{"sheet":"54","index":54,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,0,14,5],[15,0,15,1]]}
["Table 54: 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"]
["2016-17",178437,124277,2705729,6.6,4.5999999999999996]
["2017-18$",152243,149243,3280283,4.5999999999999996,4.5]
["2017-04-01",168545,128380,2786083,6,4.5999999999999996]
["2017-05-01",180718,133045,2856637,6.3,4.7]
["2017-06-01",165241,132785,2883104,5.7,4.5999999999999996]
["2017-07-01",135297,127075,3055984,4.4000000000000004,4.2]
["2017-08-01",125037,116393,3035509,4.0999999999999996,3.8]
["2017-09-01",122684,113706,3003476,4.0999999999999996,3.8]
["2017-10-01",131006,120629,3170194,4.0999999999999996,3.8]
["2017-11-01",128639,123567,3188354,4,3.9]
["2017-12-01",152243,149243,3280283,4.5999999999999996,4.5]
["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 December 31, 2017"]
["Source: SEBI."]

{"sheet":"55","index":55,"n_rows":18,"n_cols":29,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,16,5],[1,23,1,24],[1,25,1,26],[1,27,1,28],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,1,18],[1,19,1,20],[1,21,1,22],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,7,1,8],[1,9,1,10]]}
["Table 55: 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)"]
["2016-17",8956,2705728.63,64,272829.5,1532,591977.26,188,31695.23,22,2174.73,330,2848.76,1663,1536949.49,434,73926.820000000007,115,303380.12,766,1440522.63,96,227369.36,29,74173.72,11320,543186.91,25515,7806763.1600000011]
["2017-18$",9171,3280283.284569161,64,307075.947359393,1621,754297.71032018401,188,32266.481117502,22,2400.6,380,3413.8599999999997,1486,1942726.2243509798,456,84269.585630350004,113,356059.70086700004,812,1620139.4305124814,116,309420.00217396498,29,104507.32,14326,657420.0512234855,28784,9454280.1981245]
["2017-04-30",8884,2786082.88,63,273675.52000000002,1541,587640.11,190,31661.56,22,2187.2600000000002,334,2943.76,1646,1664012.38,436,76733.59,110,307675.34999999998,774,1468849.19,115,228105.69,29,75704.039999999994,11603,551698.93999999994,25747,8056970.2699999996]
["2017-05-31",8750,2856637.1841731947,63,287842.98290442297,1547,599259.542611251,189,31595.513451170002,22,2226.6949999999997,331,2847.27,1634,1656901.779023227,444,78055.547747981793,111,308179.84508516855,779,1479654.6773251793,114,245604.47430989999,29,79189.47,11901,557451.03054821538,25914,8185446.01217971]
["2017-06-30",8914,2882134.3844740558,63,284149.147133825,1566,602120.93098626996,190,31645.947601938002,22,2156.9049999999997,332,2892.83,1553,1619245.8139020971,451,79201.014539536001,111,307084.2929582402,783,1482775.6327685358,114,277223.42033403,29,77531.260000000009,12401,569590.06645669253,26529,8217751.6461552205]
["2017-07-31",8904,3055983.6266043927,63,299895.26940164401,1576,633314.96314045496,190,31965.367037408996,22,2334.6499999999996,334,2775.98,1534,1736264.5866780186,454,79600.14340476699,112,319683.44504680135,796,1521446.891156604,117,281285.38115412998,29,72289.42,12726,582997.10304459301,26857,8619836.8266688157]
["2017-08-31",8911,3035509.1905458625,64,291845.25999999995,1586,645182.91784567304,189,31568.301602509,22,2239.2649999999994,340,2913.9200000000005,1484,1770949.5922542696,460,81218.764031391649,112,314547.67149109719,796,1511599.8922582576,116,285730.55007996003,29,71308.800000000003,13072,588967.26389046188,27181,8633581.3889994845]
["2017-09-30",8968,3003475.8857643763,64,291008.07647408603,1590,646487.21624246205,189,31506.356804659001,22,2251.7249999999995,347,2928.17,1491,1766677.2942135541,465,82485.869576758996,113,304365.70933917601,798,1494463.7954157274,116,290770.50818451599,29,69048.28,13421,599581.07731269032,27613,8585049.9643280078]
["2017-10-31",9017,3170194.0005119611,64,301266.68400485802,1594,676379.08708035899,189,32444.409437905,22,2305.2699999999995,353,3149.95,1438,1932655.3312868241,470,84055.178291540986,113,352178.90209868201,802,1578889.0629780879,116,296165.26662532002,29,71093.25,13622,619058.94233548013,27829,9119835.3346510176]
["2017-11-30",9094,3188354.3517163112,64,300233.022894166,1614,710208.73421816784,190,32474.410008325998,22,2351.2949999999996,371,3223.1200000000003,1445,1961697.401319307,470,84101.094363975993,113,350639.82874399819,806,1580669.8743371321,117,302793.65420678008,29,101186.59616585499,13906,634389.51554602652,28241,9252322.898520045]
["2017-12-31",9171,3280283.284569161,64,307075.947359393,1621,754297.71032018401,188,32266.481117502,22,2400.6,380,3413.8599999999997,1486,1942726.2243509798,456,84269.585630350004,113,356059.70086700004,812,1620139.4305124814,116,309420.00217396498,29,104507.32,14326,657420.0512234855,28784,9454280.1981245]
["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 December 31, 2017"]
["Source: Custodians."]

{"sheet":"56","index":56,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,10,2,10],[14,0,14,4],[1,0,2,0],[1,1,1,3],[1,4,1,6],[1,7,1,9]]}
["Table 56: 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"]
["2016-17",14247937.300589059,3367611.5593166081,17615548.859905668,13968549.079247728,3303950.8791615008,17272499.958409227,279388.22134133097,63660.680155106704,343048.90149643773,1754619.0824741903]
["2017-18$",12708533.162321046,2703980.7387146223,15412513.901035668,12542380.304496773,2654907.8508938299,15197288.155390603,166152.85782427361,49072.88782079229,215225.74564506591,2137613.1156108822]
["2017-04-30",1361008.4115072591,276212.03437680303,1637220.4458840622,1233420.2673160513,253097.02207348909,1486517.2893895404,127588.14419120742,23115.01230331395,150703.15649452136,1926302.2825962843]
["2017-05-31",1358637.8850530759,300816.66345464572,1659454.5485077214,1399131.860554893,301033.74546349788,1700165.606018391,-40493.975501817273,-217.08200885221595,-40711.057510669474,1903975.4048693876]
["2017-06-30",1267002.7668554774,285368.85849313706,1552371.6253486141,1281396.5944537027,287567.61277883197,1568964.2072325344,-14393.827598223492,-2198.7542856949185,-16592.581883918407,1896290.7199531868]
["2017-07-31",1469015.5380476285,331566.93891878054,1800582.4769664099,1420665.9826428993,316411.79451410554,1737077.7771570049,48349.5554047279,15155.144404675062,63504.69980940297,1996905.3352801392]
["2017-08-31",1342724.4899986852,282496.03198144957,1625220.5219801348,1286290.2626868794,277229.56688494678,1563519.8295718264,56434.227311805211,5266.4650965027249,61700.692408307921,2059288.8959472692]
["2017-09-30",1501515.7001345083,334143.26749795768,1835658.9676324651,1509765.3657332333,342498.20294626686,1852263.5686794994,-8249.665598721389,-8354.9354483087918,-16604.601047030184,2040301.3823913625]
["2017-10-31",1486632.010688873,286557.26519518206,1773189.2758840546,1449855.7771948343,272185.15627936553,1722040.9334741998,36776.233494037384,14372.108915816261,51148.342409853649,2141345.9347322858]
["2017-11-30",1587032.2098482437,324429.32026739093,1911461.5301156342,1474802.2243685145,310486.54949623113,1785288.7738647461,112229.98547973018,13942.770771160409,126172.75625089055,2279032.1397729358]
["2017-12-31",1334964.1501872949,282390.35852927575,1617354.5087165721,1487051.9695457648,294398.20045709517,1781450.1700028609,-152087.81935847233,-12007.841927820191,-164095.66128629248,2137613.1156108822]
["$ indicates as on December 31, 2017"]
["Source: SEBI."]
[]
[]
[]
[]
[null,null,null,null,null,"`"]

{"sheet":"57","index":57,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,2,10]]}
["Table 57: Type-wise Resource Mobilisation by Mutual Funds: Open-ended and Close-ended (₹ crore)"]
["Scheme","2016-17",null,null,"2017-18$",null,null,"Dec-17",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",17229415.456679244,17587220.525383148,357805.06870390155,15134786.218603086,15380736.89347773,245950.67487464374,1778257.2459736262,1607786.296977086,-170470.94899653911,1975839.1634142452,null,null,15184479.492485318,15601374.00589087,416894.51340555213]
["Close-ended",39079.684936704427,28028.804206286004,-11050.880730418427,61125.68886469226,31773.821510528498,-29351.867354163758,3155.2635065028226,9568.0205452389964,6412.7570387361739,158379.59479413228,null,null,36891.8274762047,21155.677579988002,-15736.149896216701]
["Interval",4004.81350561106,299.53022720868552,-3705.2832784023744,1376.2479228292905,3.1860474124319498,-1373.0618754168586,37.660522739999806,0.19119424799999951,-37.469328491999931,3394.3574025040334,null,null,3521.7123961043494,295.18843294674673,-3226.5239631576028]
["Total",17272499.955121562,17615548.859816644,343048.90469508077,15197288.155390607,15412513.901035672,215225.74564506311,1781450.1700028684,1617354.5087165739,-164095.66128629498,2137613.1156108812,null,null,15224893.032357628,15622824.871903805,397931.83954617783]
["$ indicates as on December 31, 2017"]
["Source: SEBI."]

{"sheet":"58","index":58,"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],[1,1,1,4],[1,5,1,7],[1,9,1,11]]}
["Table 58: Scheme-wise Resource Mobilisation and Assets under Management by Mutual Funds (₹ crore)"]
["Type ","2016-17",null,null,null,"2017-18$",null,null,null,"Dec-17",null,null,null,null,"Upto Jan 17"]
[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)",17090456.110409692,17303610.259073593,213154.14866389823,1074652.0310916372,15013936.858817244,15006881.087264419,-7055.771552827031,1122373.8453610637,1749524.2820569607,1561304.9685715993,-188219.31348536146,null,null,15070850.586571293,15356527.836868433,285677.25029714033]
["    i. Liquid/Money Market",16327426.646422146,16423252.865481094,95826.219058947638,314085.89059123897,14304893.861786686,14270089.443049721,-34804.418736964464,297252.87996082794,1638011.1680967603,1510413.055767823,-127598.11232893728,null,null,14453105.184089266,14564078.29329402,110973.10920475423]
["   ii. Gilt",15312.644548855975,12007.249168512795,-3305.3953803431796,14875.2386527074,6383.8871531786544,6394.995877287367,11.108724108712522,14592.799424226965,662.17093195570033,191.97903941504137,-470.19189254065896,null,null,13908.458142523898,11732.89148066017,-2175.5666618637279]
["  iii. Debt (other than assured return)",747716.81943869172,868350.14442398562,120633.32498529377,743782.95636839501,702659.10987737973,730196.64833740855,27537.538460028718,808252.34485779481,110850.94302824477,50699.933764361311,-60151.009263883534,null,null,603836.9443395033,780716.65209375322,176879.70775424986]
["   iv. Debt (assured return)",0,0,0,0,0,0,0,0,0,0,0,null,null,0,0,0]
["   v. Infrastructure Development",0,0,0,1907.94547929582,0,200,200,2275.8211182140071,0,0,0,null,null,0,0,0]
["B. Growth/Equity Oriented \n     Schemes (i+ii)",149182.6568389188,219549.96790657114,70367.311067652321,543541.26425261353,142185.61965564347,274940.8651616018,132755.24550595833,771134.46081671049,24103.91525431745,40192.182242201263,16088.266987883795,null,null,127702.88246307812,189854.02904776167,62151.14658468352]
["    i. ELSS",4526.6050153568913,14623.567844674282,10096.96282931739,61403.187304316598,5369.0629225286521,12411.798925547439,7042.7360030187865,80981.160605957048,763.09552859124233,1929.3041404297364,1166.2086118384941,null,null,3705.1963751145731,10895.435070946829,7190.2386958322568]
["   ii. Others",144656.05182356192,204926.40006189686,60270.348238334933,482138.07694829698,136816.55673311482,262529.06623605435,125712.50950293953,690153.30021075346,23340.819725726207,38262.878101771523,14922.058376045301,null,null,123997.68608796355,178958.59397681482,54960.907888851267]
["C. Balanced Schemes",14011.102322696965,50620.513363884493,36609.41104118753,84763.022289237895,17786.398272018865,88097.720021532776,70311.321749513911,167385.0160411768,1993.0644711786736,11748.437323068909,9755.3728518902353,null,null,11068.736144362258,41727.245063994735,30658.508919632477]
["D. Exchange Traded Fund (i+ii)",17281.5076970624,41335.301795494364,23278.461733979122,49915.468428861437,22869.913960156449,42458.431604538004,19588.517644381558,75207.93978066725,5752.34982252175,4090.8251117460095,-1661.5247107757407,null,null,13853.703307458398,34308.755131673366,19760.274611642129]
["    i. Gold ETF",861.51377544184231,86.181410989000014,-775.33236445284228,5479.8122647159398,595.07187071145245,26.16076442,-568.91110629145248,4855.3069585134053,58.316160924749283,0,-58.31616092474934,null,null,779.90593204184233,85.128719469000018,-694.77721257284236]
["    ii. Other ETFs",17281.5076970624,41335.301795494364,24053.794098431965,44435.656164145497,22274.842089444996,42432.270840118006,20157.428750673011,70352.632822153842,5694.0336615970009,4090.8251117460095,-1603.2085498509914,null,null,13853.703307458398,34308.755131673366,20455.05182421497]
["E. Fund of Funds Investing Overseas",707.06407774574541,346.63626610926673,-360.42781163647868,1747.29641184098,509.36468554477278,135.79698358111102,-373.56770196366176,1511.8536112634383,76.558397888786715,18.095467957049038,-58.462929931737676,null,null,637.21793939250961,321.87707247186296,-315.34086692064665]
["Total (A+B+C+D+E)",17271638.441346116,17615462.678405654,343048.90469508071,1754619.082474191,15197288.155390607,15412513.901035672,215225.74564506311,2137613.1156108817,1781450.1700028675,1617354.5087165725,-164095.66128629493,null,null,15224113.126425585,15622739.743184336,397931.83954617783]
["$ indicates as on December 31, 2017"]
["Source: SEBI.",null,null,null,null,null,"`",null,null,null,"`"]

{"sheet":"59","index":59,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,0,20,5],[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 59: Number of Schemes and Folios by Investment Objective           "]
["Type ","2016-17",null,null,null,null,null,null,null,"2017-18$"]
[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)",349,1262,64,1675,8870830,1119944,8881,9999655,343,896,33,1272,9491593,1171204,5187,10667984]
["    i. Liquid/Money Market",52,0,0,52,788860,0,0,788860,52,0,0,52,1009696,0,0,1009696]
["   ii. Gilt",41,0,0,41,86182,0,0,86182,39,0,0,39,83587,0,0,83587]
["  iii. Debt (other than assured return)",256,1255,64,1575,7995788,1119893,8881,9124562,252,888,33,1173,8398310,1171146,5187,9574643]
["   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,51,0,51,0,8,0,8,0,58,0,58]
["B. Growth/Equity Oriented \n     Schemes (i+ii)",358,126,0,484,39340247,1485964,0,40826211,367,140,0,507,47514801,1783660,0,49298461]
["    i. ELSS",43,21,0,64,7881090,570836,0,8451926,44,23,0,67,8891334,556025,0,9447359]
["   ii. Others",315,105,0,420,31459157,915128,0,32374285,323,117,0,440,38623467,1227635,0,39851102]
["C. Balanced Schemes",30,0,0,30,3548912,0,0,3548912,30,0,0,30,5317154,0,0,5317154]
["D. Exchange Traded Fund (i+ii)",63,0,0,63,915127,0,0,915127,67,0,0,67,1107000,0,0,1107000]
["    i. Gold ETF",12,0,0,12,364110,0,0,364110,12,0,0,12,345006,0,0,345006]
["    ii. Other ETFs",51,0,0,51,551017,0,0,551017,55,0,0,55,761994,0,0,761994]
["E. Fund of Funds  Investing Overseas",29,0,0,29,109726,0,0,109726,28,0,0,28,95774,0,0,95774]
["Total (A+B+C+D+E)",829,1388,64,2281,52784842,2605908,8881,55399631,835,1036,33,1904,63526322,2954864,5187,66486373]
["Note: Data for No. of Schemes also includes serial plans."]
["$ indicates as on December 31, 2017"]
["Source: SEBI."]

{"sheet":"60","index":60,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,0,15,9],[1,0,2,0],[1,1,1,3],[1,4,1,6],[1,7,1,9],[14,0,14,5]]}
["Table 60: 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"]
["2016-17",376874.41000000003,320315.76,56558.65,1605937.0999999999,1286083.6100000001,319853.49,1982811.51,1606399.37,376412.13999999996]
["2017-18$",466255.68,358945.95,107309.73000000001,1298384.6199999999,1021545.48,276839.13999999996,1764640.3000000003,1380491.43,384148.87]
["2017-04-04",42813.5,31569.25,11244.25,134337.1,78404.210000000006,55932.89,177150.6,109973.46,67177.14]
["2017-05-04",51059.27,41701.599999999999,9357.67,156917.4,147403.03,9514.3700000000008,207976.66999999998,189104.63,18872.04]
["2017-06-04",42822.77,33716.660000000003,9106.11,147545.01,134927.1,12617.91,190367.78,168643.76,21724.02]
["2017-07-04",50268.51,38468.660000000003,11799.85,142148.53,101761.03,40387.5,192417.04,140229.69,52187.35]
["2017-08-04",50272.800000000003,32331.69,17941.11,137926.76999999999,101459.95,36466.82,188199.57,133791.63999999998,54407.93]
["2017-09-04",52152.77,34695.93,17456.84,149222.98000000001,117367.74,31855.24,201375.75,152063.67000000001,49312.08]
["2017-10-01",50608.88,40618.379999999997,9990.5,119505.65,90417.16,29088.49,170114.53,131035.54000000001,39078.990000000005]
["2017-11-01",65075.86,52995.76,12080.1,150135.01999999999,108156.65,41978.37,215210.88,161152.41,54058.47]
["2017-12-01",61181.32,52848.02,8333.2999999999993,160646.16,141648.60999999999,18997.55,221827.48,194496.62999999998,27330.85]
["$ indicates as on December 31, 2017"]
["Source: SEBI"]

{"sheet":"61","index":61,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,0,13,3],[1,1,1,3],[1,4,1,6]]}
["Table 61: Asset Under Management by Portfolio Manager"]
["Year/Month","2016-17",null,null,"2017-18$"]
["Particulars","Discretionary","Non-Discretionary","Advisory","Discretionary#","Non-Discretionary","Advisory*"]
["No. of Clients",70994,4674,1482,102334,5278,1836]
["AUM (` in crore)"]
["Listed  Equity",73912.86,13623.49,null,107708.24,16205.34]
["Unlisted  Equity",683.15,42.78,null,609.35,46.64]
["Plain Debt",866612.64,52883.64,null,978938.09,60777.89]
["Structured Debt",281.60000000000002,544.17999999999995,188385,304.89999999999998,471.15,215635.18]
["Equity Derivative",188.19,-0.02,null,295.43,0]
["Mutual Fund",8687.9,7563.2,null,9307.9599999999991,9669.58]
["Others",16669.64,404.12,null,18589.7,687.88]
["Total",967036,75061.389999999985,null,"      1,115,753.68","           87,858.47"]
["\n1. *Value of Assets for which Advisory Services are being given.\n2. #Of the above AUM Rs. 954144.249 Crore is contributed by funds from EPFO/PFs.\n3. The above data is based on the monthly reports received from portfolio managers."]
["$ indicates as on December 31, 2017"]
["Source: SEBI."]

{"sheet":"62","index":62,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,2],[1,0,2,0],[1,1,2,1],[1,2,1,6],[1,7,1,11]]}
["Table 62: Progress Report of NSDL & CDSl (Listed Companies)"]
["Parameter","Unit","NSDL",null,null,null,null,"CDSL"]
[null,null,"2017-12-01","2017-11-01","2016-12-01","%\nChange during the year","%\nChange during the month","2017-12-01","2017-11-01","2016-12-01","%\nChange during the year","%\nChange during the month"]
["Number of companies signed up to make their shares available for dematerialization","Number",5852,5835,6256,-6.4578005115089514,0.29134532990574119,6671,6652,6489,2.8047464940668827,0.28562838244137101]
["Number of Depository Participants (registered)","Number",276,268,267,3.3707865168539324,2.9850746268656714,590,589,584,1.0273972602739725,0.1697792869269949]
["Number of Stock Exchanges (connected) ","Number",3,3,3,0,0,3,3,3,0,0]
["Number of Investors Accounts","Lakh",167.07,165.68,152.52000000000001,9.5397324940991215,0.83896668276194253,141.28,138.79140000000001,118.03464,19.693676364836634,1.7930505780617465]
["Quantity of Shares dematerialized","crore",48324.183304999999,48047.165577800006,44374.0293485,8.9019501147319815,0.57655373395842457,14233.463544,14160.770566499999,13580.14,4.8108748805240653,0.51334054992720424]
["Value of Shares dematerialized","₹ crore",13040219.743322888,12521150.251711024,9127038.2891392261,42.87460324166905,4.1455415930412087,1912134.007,1842777.6566999999,1336388.04,43.082244809673689,3.7636852198545574]
["Quantity of Securities dematerialized #","crore",51578.927620176197,51432.673063659007,46701.352737452704,10.444183298381985,0.28436118094847601,15253.244314147601,15133.194158938599,14182.75,7.5478614101468429,0.79329025946643039]
["Value of Securities dematerialized #","₹ crore",15549730.50310122,15002735.595463654,11218527.388887154,38.607590498058315,3.6459677913870592,2002088.5874999999,1930811.1383999998,1406576.4204526034,42.337704399720756,3.6915805840578164]
["Quantity of shares settled during the month","crore",1234.2923462000001,1235.7327261999999,715.68402709999998,72.463307753483903,-0.11656080392311759,818.08456630000001,888.32705429999987,444.67744590000007,83.972579190349236,-7.907277804946605]
["Average Quantity of shares settled daily (quantity of shares settled during the month (divided by 30))","crore",41.143078206666665,41.191090873333337,23.856134236666666,72.463307753483889,-0.11656080392314862,26.389824719354838,29.610901809999994,14.822581530000003,78.037979861628287,-10.878010778980585]
["Value of shares settled during the month in dematerialized form","₹ crore",350656.79897786648,304223.17185007822,170448.46206829228,105.72599759648844,15.263014597280854,90018.824492220025,100369.07271209001,37720.082456042001,138.64959626513439,-10.312188745192264]
["Average Value of shares settled daily (value of shares settled during the month (divided by 30))","₹ crore",11688.559965928882,10140.772395002608,5681.6154022764094,105.72599759648841,15.263014597280836,2903.8330481361299,3345.6357570696669,1257.3360818680667,130.95122219206556,-13.205343946960246]
["Training Programmes conducted for representatives of Corporates, DPs and Brokers","Number",7,7,9,-22.222222222222221,0,932,56,58,1506.8965517241379,1564.2857142857142]
["The ratio of dematerialized equity shares to the total outstanding shares (market value)","percent",86.06,85.54,85.59,0.54912957121158879,0.60790273556230534,13.27,13.3162985448571,13.399363015304299,-0.96544152999322175,-0.34768328977560403]
["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":"63","index":63,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,0,16,5],[1,0,2,0],[1,1,1,5],[1,6,1,10],[14,0,15,10]]}
["Table 63: 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)"]
["2016-17",17835,264,27389,1317620,14648687,9887,588,17489,255227.4,1773585.34]
["2017-18$",19310,276,28005,1439316.25,17674693.158999998,10343,590,17328,269398.00971378805,2693980.0971378805]
["2017-04-01",18039,265,27380,1336753.74,12660053.331,9934,589,17481,253520.91100000002,1830695.08]
["2017-05-01",18233,268,27395,1349820.23,15139573.823000001,9968,589,17415,254730.043515075,1799049.7305000001]
["2017-06-01",18396,268,27417,1362664.81,15185478.458000001,10017,590,17387,256094.39194419494,1766361.5631000001]
["2017-07-01",18526,268,27529,1382175.59,15786686.361,10080,590,17265,256968.98061373801,1874673.4287]
["2017-08-04",18715,266,27539,1390210.64,15818656.560999999,10126,590,17322,259731.21580427402,1851407.074]
["2017-09-04",18870,267,27809,1409552.15,15844659.573999999,10182,590,17313,263733.76032370096,1846694.6227000002]
["2017-10-01",18996,268,27885,1431491.52,16877973.348999999,10217,589,17338,265065.26073912997,2079707.4827000001]
["2017-11-01",19715,268,27964,1437338.95,17132418.732999999,10221,589,17375,266866.89903194597,2079392.0386999999]
["2017-12-01",19310,276,28005,1439316.25,17674693.158999998,10343,590,17328,269398.00971378805,2693980.0971378805]
["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 December 31, 2017"]
["Source: NSDL and CDSL."]
[]
[null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"64","index":64,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,0,2,0],[1,1,2,1],[1,4,1,5],[1,6,1,7]]}
["Table 64: Depository Statistics"]
["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",799,1402,5852,10597,64,3744,6715,15743]
["Active Instruments ","Number",12023,5257,11763,11123,6933,29552,30719,45932]
["Dematerialised Quantity ","Lakh",109126.94723999999,333483.17226000002,4832418.3305000002,6539167.5636700001,216347.48427761998,2362619.0828039125,5157892.7620176198,9235269.818733912]
["Dematerialised Value ","₹ crore",2399884.9192774356,369558.74768923642,13040219.743322888,623724.25870495522,109625.84050089763,1131679.6499529744,15549730.50310122,2124962.6563471658]
["Quantity settled during the month ","Lakh",3094.2332200000001,1330.60058,123429.23462,36.020699999999998,3228.2660418599999,1412.5934058099988,129751.73388186,2779.2146858099986]
["Value Settled during the month","₹ crore",358268.84512349998,20029.787094200001,350656.79897786648,22.28697545,2382.0118138950006,318.32261889099999,711307.65591526148,20370.396688541001]
["CDSL"]
["Issuers(debt)/ Companies(equity), who have issued the active instument ","Number",567,310,6671,2708,2356,398,9594,3416]
["Active Instruments ","Number",9439,1570,6783,2868,17880,1460,34102,5898]
["Dematerialised Quantity ","Lakh",3006.08412,40791.847040000001,1423346.3544000001,996185.04220999999,98971.992894759998,131678.77647312,1525324.4314147602,1168655.6657231201,null,null," "]
["Dematerialised Value ","₹ crore",52892.480300000003,25079.430499999999,1912134.007,105735.7074,37062.100200000001,21771.927,2002088.5874999999,152587.0649]
["Quantity settled during the month ","Lakh",27.22523000000001,0,81808.456630000001,0,11968.012909200002,0,93803.694769199996,0]
["Value Settled during the month","₹ crore",1188.2739339,0,90018.824492220025,0,6062.1620305000006,0,97269.260456620017,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":"65","index":65,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,4,0],[5,0,7,0],[8,0,10,0],[14,0,16,0]]}
["Table 65 : Number of Commodities Permitted and traded at Exchanges"]
["Exchanges","Particulars","Agriculture","Metals other than bullion","Bullion Futures","Bullion Option","Energy ","Gems and Stones"]
["NCDEX","Permitted for trading",21,2,1,0,1,0]
[null,"Contracts floated ",21,1,1,0,0,0]
[null,"Traded",17,0,0,0,0,0]
["MCX","Permitted for trading",9,5,2,1,2,0]
[null,"Contracts floated ",7,5,2,1,2,0]
[null,"Traded",5,5,2,1,2,0]
["NMCE","Permitted for trading",11,0,0,0,0,0]
[null,"Contracts floated ",11,0,0,0,0,0]
[null,"Traded",7,0,0,0,0,0]
["ICEX","Permitted for trading*",0,0,0,0,0,1]
[null,"Contracts floated ",0,0,0,0,0,1," "]
[null,"Traded",0,0,0,0,0,1]
["HCE, Hapur (Regional Exchange)","Permitted for trading",1,0,0,0,0,0]
[null,"Contracts floated ",1,0,0,0,0,0]
[null,"Traded",1,0,0,0,0,0]
["Source: NCDEX, MCX, NMCE, ICEX and HCE, Hapur."]

{"sheet":"66","index":66,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,8]]}
["Table 66: Trends in Commodity Indices"]
["Year/  Month","MCX COMDEX",null,null,null,"NCDEX Dhaanya"]
[null,"Open","High","Low","Close","Open","High","Low","Close"]
[" 2016-17",2730.58,3435.43,2673.76,3242.79,2869.73,3411.86,2896.54,3080.79]
["2017-18$",{"$f":"B6","v":3244.07},{"$f":"MAX(C6:C14)","v":3571.14},{"$f":"MIN(D6:D14)","v":2966.02},{"$f":"E14","v":3568.2},{"$f":"F6","v":3107.24},{"$f":"MAX(G6:G14)","v":3185.09},{"$f":"MIN(H6:H14)","v":2794.83},{"$f":"I14","v":3013.9}]
["2017-04-01",3244.07,3291.16,3110.03,3148.19,3107.24,3185.09,3013.79,3019.45]
["2017-05-02",3147.24,3186.87,2995.12,3110.18,3033.29,3039.36,2795.32,2807.32]
["2017-06-03",3109.91,3116.85,2966.02,3056.81,2821.07,2907.61,2794.83,2875.74]
["2017-07-04",3061.59,3188.9,2976.32,3174.63,2896.51,3000.64,2850.97,2971.27]
["2017-08-05",3173.82,3301.53,3131.78,3299.37,2984.42,3115.83,2949.69,3024.85]
["2017-09-06",3299.3,3391.89,3285.27,3352.9,3030.77,3050.25,2953.14,2988.44]
["2017-10-07",3354.4,3428.29,3324.59,3416.33,3038.54,3038.54,2912.02,2941.89]
["2017-11-08",3417.59,3538.23,3417.59,3455.24,2948.34,3078.34,2930.34,3051.76]
["2017-12-09",3467.44,3571.14,3380.06,3568.2,3064.23,3079.85,2953.98,3013.9]
["$ indicates as on December 31, 2017"]
["Source: MCX and NCDEX"]
[]
[null,null,null,null," "]
[null,null,null,null,null,null," "]
[]
[]
[null,null,null," "]

{"sheet":"67","index":67,"n_rows":19,"n_cols":20,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,8],[0,9,0,17],[0,18,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,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,18,3,18],[2,19,3,19],[16,0,16,10],[17,0,17,3],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,16,3,16],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,17,3,17]]}
["Table 67: 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 \n(` 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)"]
["2016-17",260,15947.237979999996,3087740,139312.46434179999,93077.857749999996,64421776,1753887.3819669958,207.31740535900028,37151550,2040270.4695600041,674224.55275033519,117849477,1932190.901485,783456.96588569414,222510543,5865661.2173537994,539.56172677249992,284204,9229.7676900999995]
["2017-18$",{"$f":"SUM(B7:B15)","v":191},{"$f":"SUM(C7:C15)","v":8583.3106499999994},1709544,81989.089310399999,70321.129749999993,49812665,1507534.5763457497,125.92687444199998,21117820,1034884.6192172,430951.36309494247,78783140,1257649.9840769998,509981.73095843452,151423169,3882058.2689503501,632.81480322250002,324013,11806.88764415]
["2017-04-01",19,1079.1424100000002,195664,9267.3135478000004,6867.4791500000019,4866800,135571.88294200003,10.693067772000001,1908513,100564.99675579998,39029.269324451008,6962917,118855.93952850001,46986.583952223009,13933894,364260.1327741,553.37462682799992,323663,9003.3864713000003]
["2017-05-02",23,1099.9832000000001,203738,9589.1520511999988,6807.9145000000044,4826541,130356.90458325004,13.995771910999993,2435833,123722.6986478,56277.384172092985,9755773,157675.11595899993,64199.277644003989,17221885,421343.87124124996,514.27989861900005,329663,8848.4290891500004]
["2017-06-03",22,852.82057999999972,162233,7142.6217911999984,7512.0076000000017,5163533,145600.16825174991,15.063214527999992,2475978,121474.2380536,53456.700638696486,9454043,141609.31664000003,61836.592033224486,17255787,415826.34473654995,605.36959214299998,343340,10151.02374925]
["2017-07-04",21,873.12411999999972,179396,7696.8737025999999,7963.2001499999951,5108986,157997.7429532501,16.607293604000002,2733470,129695.69739910001,56695.329607894011,10039355,149330.52307600001,65548.261171498001,18061207,444720.83713095007,468.06101634650003,313150,10263.782770100001]
["2017-08-05",22,874.14773999999977,208398,9295.7321359999987,8648.3603000000021,5873954,185699.82467675002,19.432172186000003,3093896,146100.10761189999,56456.024010972513,9806338,147533.02439849998,65997.964223158517,18982586,488628.68882315001,580.93917427350004,291098,11187.9978723]
["2017-09-06",21,984.15925000000038,185263,8783.8690640000004,8955.0321500000009,6461517,199021.23051949989,14.292939881000001,2507637,130342.54458710001,48763.891566558013,8900295,134728.82942649996,58717.375906439011,18054712,472876.4735971,546.47560547899991,295141,11345.40022775]
["2017-10-07",21,718.49540999999988,150155,7163.9120304000025,8067.8312000000005,5923130,189804.13929425,10.652768600000002,1784143,88600.843879799984,40624.139154160985,7628871,121529.47778300001,49421.119121811003,15486299,407098.37298744998,621.79726994049997,325106,11444.6910878]
["2017-11-08",22,1083.2475099999997,210267,11401.246822000006,8312.0982999999978,6378793,198452.7445579998,14.252029277999998,2345664,111979.98703600002,43401.963794403498,8435823,148429.75442850002,52811.561633681493,17370547,470263.73284449987,477.46200056300006,306732,9959.1575142999991]
["2017-12-09",20,1018.1904299999998,214430,11648.368165199998,7187.2064000000018,5209411,165029.93856700003,10.937616682,1832686,82403.505246099987,36246.660825713006,7799725,137958.00283700004,44462.995272395012,15056252,397039.81481529999,632.81480322250002,324013,11806.88764415]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["* Natural Gas voulmes 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,null,null,null,null,null," "]
["Source: MCX"]
[null,null,null,null,{"$f":"E6/Q6","v":2.1120004809347854E-2}]

{"sheet":"68","index":68,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,9,0,13],[1,0,3,0],[1,1,3,1],[1,2,1,4],[1,5,1,7],[1,11,1,13],[2,2,3,2],[2,3,3,3],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,13,3,13],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[1,8,1,10]]}
["Table 68: 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)"]
["2016-17",260,128789.68800000002,17750779,596529.72767399997,1.1819999999999999E-3,1182,322.25477000000001,128789.689182,17751961,596851.98244399996,1065.356,127272,4467.8999999999996]
["2017-18$",{"$f":"SUM(B7:B15)","v":187},{"$f":"SUM(C7:C15)","v":94300.321000000025},10814900,419223.91046199994,0,0,0,94300.321000000025,10814900,419223.91046199994,1265.354,149703,5634.0099999999993]
["2017-04-01",19,9237.8509999999878,1084152,43954.75728199997,0,0,0,9237.8509999999878,1084152,43954.75728199997,1035.741,118879,4605.26]
["2017-05-02",22,10125.65800000001,1173570,43262.841514999993,0,0,0,10125.65800000001,1173570,43262.841514999993,1002.683,116185,3914.99]
["2017-06-03",21,10074.545999999998,1165261,39094.046824999998,0,0,0,10074.545999999998,1165261,39094.046824999998,880.56200000000001,105304,3582.22]
["2017-07-04",21,9125.3860000000095,1065325,39623.156965000002,0,0,0,9125.3860000000095,1065325,39623.156965000002,782.82399999999996,95341,3412.83]
["2017-08-05",21,11496.603999999999,1309097,54370.465420000008,0,0,0,11496.603999999999,1309097,54370.465420000008,824.07600000000002,100138,4033.6000000000008]
["2017-09-06",21,10473.033000000003,1194226,50573.88257999999,0,0,0,10473.033000000003,1194226,50573.88257999999,769,93632,3702.88]
["2017-10-07",20,9079.3459999999995,1026661,40810.803785000018,0,0,0,9079.3459999999995,1026661,40810.803785000018,949.44100000000003,112092,4153.7999999999993]
["2017-11-08",22,12801.67500000001,1432278,56073.365120000017,0,0,0,12801.67500000001,1432278,56073.365120000017,1171.184,136409,5351.7800000000025]
["2017-12-09",20,11886.222000000003,1364330,51460.59096999999,0,0,0,11886.222000000003,1364330,51460.59096999999,1265.354,149703,5634.0099999999993]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["Source: NCDEX",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"69","index":69,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,7,3,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],[2,6,3,6]]}
["Table 69: 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)"]
["2016-17",247,5564.19085,1230289,28441.538271599999,4.8156249999999998,3328,51.225070199999998]
["2017-18$",{"$f":"SUM(B7:B15)","v":186},{"$f":"SUM(C7:C15)","v":5491.2676999999994},1195552,25057.977873799999,6.8013500000000002,4570,66.596896999999998]
["2017-04-01",18,470.041675,135463,2366.8971594,3.8702749999999999,2710,40.949722800000004]
["2017-05-02",22,600.54984999999999,157039,2769.5055652000001,4.0885749999999996,2661,35.557564800000002]
["2017-06-03",21,699.01932499999998,171796,3013.3617129999998,4.5465249999999999,3025,41.060047599999997]
["2017-07-04",21,622.28,151437,2751.3635565999998,4.1239749999999997,2398,34.8031516]
["2017-08-05",21,613.65284999999994,142262,2711.2977692999998,4.0712250000000001,2431,35.761086200000001]
["2017-09-06",21,678.88802499999997,126478,3092.5516235999999,4.6314250000000001,2758,40.759063500000003]
["2017-10-07",20,573.00374999999997,98410,2664.654333,3.9657249999999999,2325,33.408028199999997]
["2017-11-08",22,626.540075,104055,2840.3662906999998,4.1510749999999996,2697,40.667895000000001]
["2017-12-09",20,607.29214999999999,108612,2847.979863,6.8013500000000002,4570,66.596896999999998]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["Source: NMCE"]
[null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null," "]
[]
[]
[]
[]
[null,null,null,null,"`"," "]

{"sheet":"70","index":70,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,8,2,8],[1,0,2,0],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,2,7]]}
["Table 70:Trends in  Gold Options at MCX"]
["Year / \nMonrh","Call option ",null,"Put option ",null,"Total",null,"Open interest at \nmonth end (No. of conrtracts)","Notional Value of OI"]
[null,"No. of contracts","Turnover","No. of contracts","Turnover","No. of Contracts","Turnover"]
["2017-18$",{"$f":"SUM(B5:B7)","v":17117},{"$f":"SUM(C5:C7)","v":5109.46},7919,2329.37,25036,7438.8300000000008,1341,396]
["2017-10-01",6923,2077.91,4129,1219.68,11052,3297.59,1800,536.82000000000005]
["2017-11-01",6563,1956.72,3095,909.05,9658,2865.77,367,109.06]
["2017-12-01",3631,1074.83,695,200.64,4326,1275.47,1341,396]
[{"$f":"'69'!A16","v":"$ indicates as on December 31, 2017"}]
[" Note: Option trading in gold contracts commenced at MCX on 17th October, 2017."]
["1. Values provided in ‘No. of contracts’ field is Volume in lots and Turnover values are notional value in ₹ crore."]
["2. Values provided for ‘Open interest’ are inclusive of both call and put."]

{"sheet":"71","index":71,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,7,3,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],[2,6,3,6]]}
["Table 71: Trends in Diamond Futures at ICEX"]
["Year/  Month","No.of Trading days"," Diamond",null,null,"Open interest at the end of the period"]
[null,null,"Volume (in Cents)","No. of contracts","Turnover \n(₹  crore)","Open Interest\n(Cents)","No. of contracts","Value \n(₹  crore)"]
[null,null,null,null,null,null,null,"(Rs.crore)"]
["2017-18$",{"$f":"SUM(B6:B10)","v":88},{"$f":"SUM(C6:C10)","v":2689669},23,840.65599999999995,57225,6,16.14]
["2017-08-05",4,25588,3,8.23,4541,3,1.4612360000000002]
["2017-09-06",21,439368,3,141.6703,12993,3,4.2053780999999999]
["2017-10-07",21,514590,3,165.3657,12825,3,4.0980169000000002]
["2017-11-08",22,815952,7,257.23,26417,6,7.8545864999999999]
["2017-12-09",20,894171,7,268.16000000000003,57225,6,16.14]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["Note: Volume & Turnover is for the month & OI details are for the last day of the month."]
["Source: ICEX"]

{"sheet":"72","index":72,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,1,1,4],[1,5,1,6]]}
["Table 72: 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"]
["2016-17",2.3750513229376145,29.90093217075081,34.783298829529741,32.940717676781844,99.94,0.06]
["2017-18$",{"$f":"('67'!E6/'67'!$Q6)*100","v":2.1120004809347854},{"$f":"('67'!H6/'67'!$Q6)*100","v":38.83338352758328},{"$f":"('67'!K6/'67'!$Q6)*100","v":26.658142344087409},{"$f":"('67'!N6/'67'!$Q6)*100","v":32.396473647394515},{"$f":"SUM(B5:E5)","v":99.999999999999986},0]
["2017-04-01",{"$f":"('67'!E7/'67'!$Q7)*100","v":2.5441470844538534},{"$f":"('67'!H7/'67'!$Q7)*100","v":37.218424621306681},{"$f":"('67'!K7/'67'!$Q7)*100","v":27.60801627944458},{"$f":"('67'!N7/'67'!$Q7)*100","v":32.629412014794887},{"$f":"SUM(B6:E6)","v":100},0]
["2017-05-02",{"$f":"('67'!E8/'67'!$Q8)*100","v":2.2758494203205135},{"$f":"('67'!H8/'67'!$Q8)*100","v":30.93836495099065},{"$f":"('67'!K8/'67'!$Q8)*100","v":29.363830137915969},{"$f":"('67'!N8/'67'!$Q8)*100","v":37.421955490772874},100,0]
["2017-06-03",{"$f":"('67'!E9/'67'!$Q9)*100","v":1.7176934269821846},{"$f":"('67'!H9/'67'!$Q9)*100","v":35.014656982350658},{"$f":"('67'!K9/'67'!$Q9)*100","v":29.212732572430195},{"$f":"('67'!N9/'67'!$Q9)*100","v":34.054917018236956},100,0]
["2017-07-04",{"$f":"('67'!E10/'67'!$Q10)*100","v":1.7307202766245964},{"$f":"('67'!H10/'67'!$Q10)*100","v":35.527398260119512},{"$f":"('67'!K10/'67'!$Q10)*100","v":29.163395678919024},{"$f":"('67'!N10/'67'!$Q10)*100","v":33.578485784336877},100.00000000000001,0]
["2017-08-05",{"$f":"('67'!E11/'67'!$Q11)*100","v":1.9024122710413376},{"$f":"('67'!H11/'67'!$Q11)*100","v":38.004281967971103},{"$f":"('67'!K11/'67'!$Q11)*100","v":29.900026534213218},{"$f":"('67'!N11/'67'!$Q11)*100","v":30.19327922677434},100,0]
["2017-09-06",{"$f":"('67'!E12/'67'!$Q12)*100","v":1.857539876573354},{"$f":"('67'!H12/'67'!$Q12)*100","v":42.087361421382504},{"$f":"('67'!K12/'67'!$Q12)*100","v":27.563761756977236},{"$f":"('67'!N12/'67'!$Q12)*100","v":28.491336945066877},99.999999999999972,0]
["2017-10-07",{"$f":"('67'!E13/'67'!$Q13)*100","v":1.7597496098617056},{"$f":"('67'!H13/'67'!$Q13)*100","v":46.623654597632417},{"$f":"('67'!K13/'67'!$Q13)*100","v":21.763988696297581},{"$f":"('67'!N13/'67'!$Q13)*100","v":29.852607096208295},100,0]
["2017-11-08",{"$f":"('67'!E14/'67'!$Q14)*100","v":2.4244367629706218},{"$f":"('67'!H14/'67'!$Q14)*100","v":42.200308188261104},{"$f":"('67'!K14/'67'!$Q14)*100","v":23.812167346748801},{"$f":"('67'!N14/'67'!$Q14)*100","v":31.563087702019466},100,0]
["2017-12-09",{"$f":"('67'!E15/'67'!$Q15)*100","v":2.9338035457775775},{"$f":"('67'!H15/'67'!$Q15)*100","v":41.565085517625164},{"$f":"('67'!K15/'67'!$Q15)*100","v":20.754468990580577},{"$f":"('67'!N15/'67'!$Q15)*100","v":34.746641946016695},100.00000000000001,0]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["Source: MCX and NCDEX"]
[]
[null,null," "]
[null,null,null,null,null,null," "]

{"sheet":"73","index":73,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[17,0,17,8],[18,0,18,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 73: Participant-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 "]
["2016-17",35.275130739435923,64.724869260564077,19.636723386964807,80.363276613035197,10.716124948603825,89.28387505139618,18.225992863967242,81.774007136032751]
["2017-18$",35.52224967463529,64.47775032536471,21.214284400565361,78.785715599434639,11.785803787955706,88.2141962120443,23.901331044687208,76.098668955312803]
["2017-04-01",36.468973882968683,63.531026117031317,19.661532654272072,80.338467345727921,10.858876984754978,89.141123015245029,21.80548185615789,78.194518143842103]
["2017-05-02",36.431192583528031,63.568807416471969,20.030271244379467,79.969728755620537,13.864729475002457,86.135270524997537,20.541656813048952,79.458343186951041]
["2017-06-03",30.584824456076682,69.415175543923311,18.591797455378572,81.408202544621417,12.82,87.18,21.03,78.97]
["2017-07-04",34.260687360755604,65.739312639244389,20.295982745839076,79.704017254160917,15.563102246097356,84.436897753902642,22.358424086500754,77.641575913499238]
["2017-08-05",38.105297474978791,61.894702525021202,22.751375176353182,77.248624823646821,16.575600337719628,83.424399662280365,24.511811900814457,75.48818809918555]
["2017-09-06",36.240778533991133,63.759221466008867,23.075975035045371,76.924024964954626,16.068430106395297,83.931569893604703,26.357172868398088,73.642827131601905]
["2017-10-07",33.938428897266157,66.061571102733851,21.967271785585123,78.032728214414874,16.26296956916925,83.737030430830757,26.376359754024904,73.623640245975096]
["2017-11-08",35.022898388577659,64.977101611422341,22.115398865194884,77.884601134805123,16.320179873522829,83.679820126477182,26.303718366390761,73.696281633609246]
["2017-12-09",36.741601675898927,63.258398324101073,21.723942656396595,78.276057343603398,11.7858037879557,88.2141962120443,23.901331044687197,76.098668955312803]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["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 of Energy, Bullion and Metals are treated as Non-Agri., \nwheresas other commodities are treated as Agri.  "]
["3. Open Interest provided is at end of the respective FY or Month as applicable and computed at client level. \nThe OI value is considered before marking of delivery on the expiry date."]
["Source: MCX"]
[]
[null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," ",null,null," "]

{"sheet":"74","index":74,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,0,3,0],[1,1,1,5],[2,4,2,5],[2,6,2,8],[2,9,2,10],[1,6,1,10]]}
["Table 74: Partcipant-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 "]
["2016-17",41.560108200399654,58.165458243959058,0.27443355564129068,73.638115581656095,26.361884418343905,20.658970086661714,78.329096319362819,1.011933593975469,0,0]
["2017-18$",40.866526532313763,58.989241308669904,0.1442321590163276,0,0,{"$f":"G15","v":20.348528657412089},{"$f":"H15","v":79.140907743562707},{"$f":"I15","v":0.51056359902519888},0,0]
["2017-04-01",39.48011146590143,60.295726125766144,0.22416240833241799,0,0,21.215150089126865,77.731933230268965,1.0529166806041708,0,0]
["2017-05-02",41.62563878578375,58.16441205387617,0.2099491603400751,0,0,22.493386402480784,76.452901050856781,1.0537125466624304,0,0]
["2017-06-03",40.811894171306349,58.974967021721334,0.2131388069723065,0,0,19.86134322613934,79.206943469980089,0.93171330388057749,0,0]
["2017-07-04",41.611955313313779,58.356137423438192,3.1907263248023184E-2,0,0,21.274586691371507,77.776778890485701,0.94863441814280103,0,0]
["2017-08-05",40.790545572269323,59.170974657807093,3.8479769923588085E-2,0,0,18.579571986613455,80.826567580617123,0.59386043276942713,0,0]
["2017-09-06",42.130037348352253,57.761802257848672,0.10816039379908031,0,0,18.786159483481192,80.38907880361765,0.82476171290116373,0,0]
["2017-10-07",40.418666591082314,59.410808863832443,0.17052454508523676,0,0,19.952100485347419,79.22821736013131,0.81968215452127879,0,0]
["2017-11-08",41.356791259757429,58.453996233069248,0.18921250717331684,0,0,22.437779955486707,76.705527754433589,0.85669229007970493,0,0]
["2017-12-09",39.53963018492697,60.328200699622826,0.13216911545020329,0,0,20.348528657412089,79.140907743562707,0.51056359902519888,0,0]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["Source: NCDEX",null,null,null,null,null,null," "]
[null,null,null," ",null,null,null,null," ",null," "]

{"sheet":"75","index":75,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,4]]}
["Table 75: Participant-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 "]
["2016-17",4.8013516458200289,95.198648354179966,0.9642873794794149,99.035712620520584]
["2017-18$",1.9323831956380024,98.067616804362004,4.3692943675719125,95.630705632428089]
["2017-04-01",2.9217603234409459,97.078239676559051,0.94446267731466294,99.055537322685339]
["2017-05-02",1.6222573828536604,98.377742617146339,1.2987714810678388,98.701228518932155]
["2017-06-03",0.99281097323745027,99.007189026762561,0.85061227239805282,99.149387727601948]
["2017-07-04",1.8307338057586597,98.169266194241345,0.93653808369899805,99.063461916300994]
["2017-08-05",1.2831294442801797,98.716870555719822,1.4296967309964552,98.570303269003546]
["2017-09-06",2.9775424053490327,97.022457594650973,1.9967499112763136,98.003250088723675]
["2017-10-07",1.419848084288087,98.580151915711909,1.6307172557172556,98.369282744282742]
["2017-11-08",0.80526716131260423,99.194732838687401,1.1650373998048706,98.834962600195126]
["2017-12-09",3.5908743361785489,96.409125663821442,4.3692943675719125,95.630705632428089]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["Source: NMCE"]
[]
[null,null,null,null," "]

{"sheet":"76","index":76,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,4],[7,7,7,11]]}
["Table 76: Participant -wise Percentage Share of Turnover & Open Interest at ICEX"]
["Year/    Month","Turnover",null," Open Interest at the end of Period"]
[null,"Pro","Client ","Pro","Client "]
["2017-18$",63.04,36.96,65.706000000000003,34.29]
["2017-08-17",52.0631067961165,47.936893203883493,75.445937018277917,24.554062981722087]
["2017-09-17",62.653961531674604,37.346038468325389,64.323097052258902,35.676902947741091]
["2017-10-17",68.249024884346738,31.750975115653251,50.88109161793372,49.11890838206628]
["2017-11-18",62.957000000000001,37.04,53.85,46.15,null,null,{"$f":"'[3]Table Index'!H21","v":{"$error":"#REF!"}}]
["2017-12-19",69.260000000000005,30.74,65.706000000000003,34.29]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["Note: Turnover is for the month & OI details are for the last day of the month."]
["Source: ICEX"]

{"sheet":"77","index":77,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[30,0,30,9],[33,0,33,9],[34,0,34,8],[3,0,3,9],[4,1,4,9],[8,1,8,9],[15,1,15,9],[25,1,25,9],[29,0,29,1]]}
["Table 77: Commodity-wise monthly turnover and trading volume at MCX"]
["Sr.No","Name of the Commodity","2017-18$",null,"2016-12-01",null,"2017-11-01",null,"2017-12-01"]
[null,null,"Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)"]
["Futures"]
["A","Bullion"]
[1,"Gold",1.8917194419999981,548758.07691160007,0.17125502100000004,47095.298006800018,0.19216527800000002,56558.084689700008,0.14515868200000004,41669.563348400006]
[2,"Silver",124.03515499999993,486126.54230559978,12.740173999999998,51263.528485400006,14.059863999999997,55421.902346299983,10.792458,40733.941897700017]
[null,"Total for A",{"$f":"SUM(C6:C7)","v":125.92687444199993},1034884.6192171999,12.911429020999998,98358.826492200023,14.252029277999997,111979.98703599999,10.937616682,82403.505246100016]
["B","Metals other than Bullion"]
[1,"Aluminium",10115.495000000001,132490.00908499994,688.38000000000011,8063.4651050000011,1386.431,18954.639044999993,1191.0410000000002,16168.073715000002]
[2,"Copper",8129.1375000000016,333386.43479375006,926.40299999999991,35975.129682499995,966.84800000000007,43003.219202500026,815.11449999999968,36317.908789999994]
[3,"Lead",19329.768000000004,292025.18631499965,1871.633,28108.41821,2130.2549999999992,34099.861974999993,2063.5839999999998,33289.018389999997]
[4,"Nickel",2570.0442500000013,177498.71096699996,175.17240000000007,13059.778246499998,391.45430000000005,30617.792670499999,285.80689999999998,21182.787666999997,null," "]
[5,"Zinc",30176.685000000005,572134.23518500011,3009.1550000000007,54497.424720000017,3437.1100000000006,71777.231664999999,2831.6599999999989,58072.150005000003]
[null,"Total for  B",{"$f":"SUM(C10:C14)","v":70321.129750000007},{"$f":"SUM(D10:D14)","v":1507534.5763457497},{"$f":"SUM(E10:E14)","v":6670.7434000000012},139704.215964,8312.0983000000015,198452.74455800001,7187.2063999999982,165029.93856699998]
["C","Agricultural commodities",null,null,null,null,null,null,null,null,null," "]
[1,"Cardamom",4.3703999999999983,479.08403399999997,0.91499999999999981,124.554925,0.50029999999999997,49.457996000000001,0.31670000000000004,33.833148000000001]
[2,"Castorseed",0.05,0.2316,"Na","Na","Na","Na","Na","Na"]
[3,"Cotton",2205.6522499999992,25771.424550000014,247.70274999999998,2776.921875,180.90125,1959.6120249999999,398.94325000000003,4630.9386750000012]
[4,"CPO",6147.6000000000013,32006.230980000015,706.93,3989.1272399999998,874.74,4985.6495600000017,598.19999999999993,3368.0114699999999]
[5,"Kapas",8.0000000000000002E-3,4.1866E-2,3.2000000000000001E-2,0.146512,"Na","Na","Na","Na"]
[6,"Mentha Oil",189.22499999999994,23404.335980400003,19.314000000000004,1959.7190687999998,27.066960000000002,4404.9495959999995,20.724479999999996,3615.338977200001]
[7,"Pepper",3.1449999999999969,149.0710599999999,"Na","Na",3.9E-2,1.5776449999999997,6.0000000000000001E-3,0.24589499999999997]
[8,"RBD Palmolein",33.259999999999984,178.66924000000003,"Na","Na","Na","Na","Na","Na"]
[null,"Total for C",{"$f":"SUM(C17:C24)","v":8583.3106500000013},81989.089310400042,974.89374999999995,8850.4696208000005,1083.2475100000001,11401.246821999999,1018.1904299999999,11648.368165200001,null,null," "]
["D","Energy"]
[1,"Crude Oil",430951.36368399265,1021985.6442770002,35841.77132461701,92866.400017000022,43401.963794403498,117019.30474100003,36246.660825713006,98732.881462000019]
[2,"Natural Gas (trln. Btu)",12136.278749999999,235664.33979999996,1755.0675000000001,42689.301374999995,1575.8087499999999,31410.4496875,2186.6624999999999,39225.121374999995,null," "]
[null,"Total for D*",430951.36368399265,{"$f":"SUM(D27:D28)","v":1257649.9840770001},35841.77132461701,{"$f":"SUM(F27:F28)","v":135555.70139200002},43401.963794403498,{"$f":"SUM(H27:H28)","v":148429.75442850002},36246.660825713006,137958.00283700001]
["Grand Total (A+B+C+D)",null,{"$f":"SUM(C8+C15+C25+C29)","v":509981.73095843464},{"$f":"SUM(D8+D15+D25+D29)","v":3882058.2689503497},{"$f":"SUM(E8+E15+E25+E27)","v":43500.31990363801},{"$f":"SUM(F8+F15+F25+F29)","v":382469.21346900007},52811.5616336815,{"$f":"SUM(H8+H15+H25+H29)","v":470263.73284450005},{"$f":"SUM(I8+I15+I25+I29)","v":44462.995272395005},{"$f":"SUM(J8+J15+J25+J29)","v":397039.81481529999}," ",null," "]
["Options"]
["E","Gold#",2.5036000000000003E-2,7438.8300000000008,"Na","Na",9.6579999999999999E-3,2865.77,4.326E-3,1275.47]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["Note : *Natural Gas volumes are in Trillion BTU and is not included for computing the Total Volume in '000 tonnes"]
["Conversion factors: Cotton (1 Bale=170 kg), Crude Oil (1 Tonne = 7.33Barrels)"]
["# In respect of gold option, turnover values are  notional value in ₹  crores",null,null,null,null,null,null,null," "]
["Source : MCX"]

{"sheet":"78","index":78,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9]]}
["Table :78 Commodity- Wise Monthly Turnover & trading volume at NCDEX"]
["Sr.No","Name of Agri. Commodity ","2017-18$",null,"2016-12-01",null,"2017-11-01",null,"2017-12-01"]
[null,null,"Volume in 1000 tons","Value (` crore)","Volume in 1000 tons","Value (` crore)","Volume in 1000 tons","Value (` crore)","Volume in 1000 tons","Value (` crore)"]
[1,"Barley",189.38000000000002,278.97999999999996,4.51,8.1299999999999972,6.02,9.16,1.38,2.09,null,null," "]
[2,"Castorseed",7228.99,32981.54,"Na","Na",694.81,3093.37,585.66,2638.27]
[3,"Chana",8495.48,43460.86,"Na","Na",1540.97,7372.23,1769.42,7228.57]
[4,"Chilli","Na","Na",5.0000000000000001E-3,0.04,"Na","Na","Na","Na"]
[5,"Cotton seed oil cake",10029.65,17315.580000000002,702.13,1388.2700000000004,906.23,1429.1,1419.68,2479.46]
[6,"Cotton","Na","Na",8.8999999999999996E-2,4.26,"Na","Na","Na","Na"]
[7,"Coriander",2752.8299999999995,15043.110000000002,80.459999999999994,627.37000000000012,234.73,1212.04,267.35000000000002,1512.26]
[8,"Guar seed",23031.082000000002,86527.27,852.66,2800.9400000000005,3134.29,11727.37,2915.8,11561.38]
[9,"Guargum",5298.66,42844.37,245.02500000000001,1523.2199999999998,717.14,6003.11,681.57500000000005,5989.11]
[10,"Jeera",1499.0879999999997,28829.119999999999,73.494,1287.6499999999999,109.599,2189.2199999999998,106.866,2263.8200000000002]
[11,"Kapas",2530.3440000000001,11693.859999999999,45.63,847.53000000000009,302.16399999999999,1374.43,510.94,2567.7399999999998]
[12,"Maize",239.23999999999998,319.32000000000005,74.459999999999994,106.06,0.03,0.04,0.1,0.12]
[13,"Pepper",4.6770000000000005,221.07000000000002,"Na","Na",5.7000000000000002E-2,2.36,2.5999999999999999E-2,1.01]
[14,"Rape/Mustard Seed",8233.64,31213.59,595.98,2670.8999999999996,955.66,3829.34,823.8,3326.71]
[15,"Rape/Mustard oilcake",14.709999999999999,26.71,"Na","Na","Na","Na","Na","Na"]
[16,"Sugar",13.530000000000001,49.970000000000006,19.149999999999999,68.010000000000005,0.13,0.42,0.16,0.51]
[17,"Soybean",14418.91,42967.49,1291.6400000000001,3974.8299999999995,2843.39,8370.69,1988.55,6181.03]
[18,"Refined Soy oil",8478.380000000001,56152.939999999995,887.7,6416.7800000000007,1205.8800000000001,8679.4599999999991,712.95,5187.74]
[19,"Soymeal",0.77,1.8900000000000001,"Na","Na","Na","Na","Na","Na"]
[20,"Degummed Soy Oil",12.44,73.069999999999993,"Na","Na","Na","Na","Na","Na"]
[21,"Turmeric",1214.3700000000001,8208.8799999999992,49.344999999999999,347.81999999999982,94.474999999999994,684.51,59.505000000000003,450.1]
[22,"Wheat",614.15000000000009,1014.2099999999999,34.200000000000003,68.329999999999984,56.1,96.51,42.46,70.66]
[null,"Total",{"$f":"SUM(C4:C25)","v":94300.321000000011},419223.83000000007,4956.4780000000001,22140.140000000003,12801.674999999999,56073.360000000008,11886.221999999998,51460.58]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["Source: NCDEX"]
[]
[]
[]
[null,null,null,null,null,"T"]

{"sheet":"79","index":79,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[11,0,11,1],[12,0,12,1],[0,0,0,4],[0,5,0,9],[1,0,2,0],[1,1,2,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9]]}
["Table 79: Commodity- Wise monthly turnover & trading volume at NMCE"]
["Sr.No","Name of the Commodity","2017-18$",null,"2016-12-01",null,"2017-11-01",null,"2017-12-01"]
[null,null,"Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)","Volume\n('000 tonnes)","Value \n(` crore)"]
[1," Castorseed ",796.27,3622.0648299999998,53.44,203.58184399999999,98.23,437.09949999999998,95.18,428.66572000000008]
[2," Guarseed ",584.59900000000005,2160.1682340000002,87.656999999999996,288.21552600000001,35.006999999999998,126.86593999999999,37.529000000000003,149.26056499999999]
[3," Isabgulseed ",461.41649999999998,5189.00389,49.612499999999997,586.35242000000005,52.923375,583.75642700000003,52.346249999999998,582.07051499999989]
[4,"Pepper Mini",0.47320000000000001,23.064355800000001,0.1042,7.1746622000000002,2.9700000000000001E-2,1.2328566999999999,3.0899999999999997E-2,1.2942390000000001]
[5," Rape/Mustardseed ",1966.82,6341.0714049999997,167.67,574.15427,239.81,800.03052000000002,228.65,771.70354999999995]
[6," Raw Jute ",1552.61,6002.4209890000002,110.12,468.15589699999998,189.8,755.01670799999999,178.15,706.75481100000013]
[7," Rubber ",129.07900000000001,1720.18417,21.372,297.58409599999999,10.74,136.364339,15.406000000000001,208.23046299999996]
[null,"Total",{"$f":"SUM(C4:C10)","v":5491.2676999999994},25057.977873800002,489.97570000000002,2425.2187152000001,626.540075,2840.3662907000003,607.29214999999999,2847.979863]
[{"$f":"'66'!A15","v":"$ indicates as on December 31, 2017"}]
["Source : NMCE"]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null," "," "]
[]
[null,null,null,null,null,null," ",null,null," "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]

{"sheet":"80","index":80,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,0,5,0],[39,0,39,3],[40,0,40,4],[0,4,0,5],[1,0,1,3],[1,4,1,5],[2,0,2,3],[2,4,2,5],[3,0,3,3],[3,4,3,5]]}
["Table 80: Macro Economic Indicators"]
["I. GDP at constant prices (2011-12 prices) for 2016-17 (`crore)*                         ",null,null,null,12189854]
["II. Gross Saving as a percent of Gross national Disposable Income at current market prices in 2015-16              ",null,null,null,31.6]
["III. Gross Capital Formation as a percent of GDP at current market prices in 2016-17@",null,null,null,27.1]
["IV.  Monetary and Banking Indicators                  ","August","September","October","November","December"]
[null,2017,2017,2017,2017,2017]
["Cash Reserve Ratio (percent)",4,4,4,4,4]
["Repo Rate (percent)",6,6,6,6,6]
["Money Supply (M3)  (` crore)",12926420,13233779.999999998,131671.4,131986.4,132723.79999999999]
["Aggregate Deposit (` crore)",10672670,10967730,108497.7,108471.5,108851.2]
["Bank Credit (` crore)",7704220,8008830,7916930,79618.8,80967.3]
["V. Interest Rate                        "]
["Call Money Rate (Weighted Average)",5.93,5.88,5.85,5.89,5.99]
["91-Day-Treasury Bill (Primary Yield)",6.11,6.11,6.11,6.11,6.19]
["Base rate (percent)","9.00/9.55","9.00/9.55","8.95/9.45","8.95/9.45","8.85/9.45"]
["Term Deposit Rate > 1 year (Maximum) ","6.25/6.75","6.25/6.75","6.25/6.75","6.00/6.75","7.65/8.05"]
["VI. Capital Market Indicators (`crore)"]
["Turnover (BSE+NSE) ",632893.03522048576,684440.69009768206,685448.52168198186,857895.54220856295,693721.17621008796]
["Market Cap-BSE ",13189762.82,13181353.140000001,14391545.9,14596655.539999999,15173866.880000001]
["Market Cap-NSE ",13055208.0310525,13045716.3446829,14208617.458814999,14392501.046961701,14982295.7502803]
["Net FPI Investment in Equity ",-1991.65,-1752,3055.44,19727.650000000001,-5882.6799999999985]
["VII. Exchange Rate and Reserves"]
["Forex Reserves (USD million)",394550,399656.7,398761.3,400741.8,409366.6]
["Re/ Dollar",64.069999999999993,65.36,65.09,64.73,63.93]
["Re/Euro",75.58,77.06,75.680000000000007,76.72,76.39]
["Forward Premia of USD  6-month",4.4800000000000004,4.1900000000000004,4.3600000000000003,4.3899999999999997,4.32]
["VIII.  Public Borrowing and Inflation"]
["Govt. Market Borrowing-Gross (` crore) 2017-18",294000,357000,401000,461000,5210]
["Wholesale Price Index (2011-12=100)",114.8,114.3,115.5,116.3,115.7,"http://mospi.nic.in/"]
["Consumer Price Index (2012 =100)",135.5,135.19999999999999,136.1,137.6,139.80000000000001]
["IX.  Index of Industrial Production (y-o-y) percent (Base year 2011-12 = 100)"]
["General",121.5,123.1,122.7,125.6,"NA","http://mospi.nic.in/"]
["Mining",92.7,94.5,100.9,107.4,"NA","http://mospi.nic.in/"]
["Manufacturing",123.3,125.6,124,127.5,"NA","http://mospi.nic.in/"]
["Electricity",155.4,150.5,149.80000000000001,140.1,"NA","http://mospi.nic.in/"]
["X. External Sector Indicators (USD million)"]
["Exports ",23818.83,28613.41,23098.18,26195.759999999998,27030.27,"commerce.nic.in"]
["Imports",29303.200000000001,37597.699999999997,37117.01,40024.959999999999,41910.46,"commerce.nic.in"]
["Trade Balance",-5484.369999999999,-8984.2899999999972,-14018.83,-13829.2,-14880.19,{"$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"]
["4. ! Base year is 2004-05 (2004-05=100)"]
["Source :  RBI, MOSPI,  Ministry of Commerce & Industry."]