Sensex Historical Data Download (Google Sheet & Excel)

In this complex world of finance and investment, one name that excites every investor and financial analyst and makes the market buzz with excitement is Sensex. Often called the barometer of India’s economic pulse, the Sensex holds a prominent place in the country’s financial landscape. In this post, you can check the Historical Data of Sensex from its listing to date.

If you want an automated Google Sheet of Sensex historical data (daily, weekly, month-wise performance, year-wise performance, compounded performance) then you can check the Google Sheet and download it as an Excel sheet. You will find the link to the Google Sheet at the end of the post. You can make your own copy of that sheet, approve it, and use it in your Google Drive.

Last Updated on October 19, 2023 at 9:00 AM

Sensex Historical Data Download

Sensex Historical Data Yearwise

YearOpen PriceClose PriceGain/ Fall
1986₹549.43₹524.45-4.55%
1987₹542.06₹442.17-18.43%
1988₹439.17₹666.2651.71%
1989₹659.11₹778.6418.14%
1990₹780.01₹1,048.2934.39%
1991₹999.26₹1,946.2894.77%
1992₹1,957.33₹2,615.3733.62%
1993₹2,539.67₹3,346.0631.75%
1994₹3,465.86₹3,926.9013.30%
1995₹3,932.09₹3,110.49-20.89%
1996₹3,127.94₹3,085.20-1.37%
1997₹3,260.56₹3,658.9812.22%
1998₹3,694.62₹3,055.41-17.30%
1999₹3,060.34₹5,005.8263.57%
2000₹5,375.11₹3,972.12-26.10%
2001₹3,955.08₹3,262.33-17.52%
2002₹3,246.15₹3,377.284.04%
2003₹3,390.12₹5,838.9672.23%
2004₹5,915.47₹6,602.6911.62%
2005₹6,679.20₹9,397.9340.70%
2006₹9,390.14₹13,786.9046.82%
2007₹13,942.20₹20,286.9945.51%
2008₹20,300.71₹9,647.31-52.48%
2009₹9,903.46₹17,464.8176.35%
2010₹17,558.73₹20,509.0916.80%
2011₹20,561.05₹15,454.92-24.83%
2012₹15,517.92₹19,426.7125.19%
2013₹19,580.81₹21,170.688.12%
2014₹21,140.48₹27,499.4230.08%
2015₹27,507.54₹26,117.54-5.05%
2016₹26,160.90₹26,626.461.78%
2017₹26,595.45₹34,056.8328.06%
2018₹33,812.75₹36,068.336.67%
2019₹36,254.57₹41,253.7413.79%
2020₹41,306.02₹47,751.3315.60%
2021₹47,868.98₹58,253.8221.69%
2022₹59,183.22₹60,840.742.80%
2023₹61,167.79₹72,271.9418.15%

Sensex Historical Data Monthwise

You can see the monthly historical data of Sensex in the table below. The prices displayed are the prices on the first working day of the month.

For detailed monthly, yearly, and compounded performance or historical data, you can refer to the Google Sheet link given at the end which is an automated sheet.

Month19861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023
Jan549.43542.06439.17659.11780.01999.261,957.332,539.673,465.863,932.093,127.943,260.563,694.623,060.345,375.113,955.083,246.153,390.125,915.476,679.209,390.1413,942.2020,300.719,903.4617,558.7320,561.0515,517.9219,580.8121,140.4827,507.5426,160.9026,595.4533,812.7536,254.5741,306.0247,868.9859,183.2261,167.79
Feb625.27560.08443.19662.59692.411,021.952,272.812,634.433,947.863,569.663,001.423,324.223,354.803,265.915,215.544,286.113,333.923,279.835,620.986,552.479,859.2614,267.2018,242.589,066.7016,356.0318,022.2217,300.5819,781.1920,209.2629,122.2724,824.8328,141.6435,906.6636,469.4339,735.5348,600.6158,862.5759,708.08
Mar627.10536.18406.03636.00692.581,225.443,333.252,571.184,147.723,459.813,417.813,871.053,772.613,523.985,642.124,271.653,678.753,277.275,823.176,651.0810,565.5013,159.5016,677.888,607.0816,772.5618,446.5017,583.9718,918.5220,946.6529,459.1423,779.3528,984.4934,046.9436,063.8138,144.0249,849.8455,468.9059,411.08
Apr560.74510.57397.16723.88782.971,193.614,387.862,311.443,780.853,316.643,409.693,427.013,969.573,686.295,052.943,566.263,500.183,080.955,740.856,605.0411,564.4012,455.4015,626.629,901.9917,692.6219,420.3917,478.1518,864.7522,446.4428,260.1425,269.6429,910.2233,255.3638,871.8728,265.3150,029.8359,276.6959,106.44
May597.10465.74482.42751.87786.211,272.093,560.722,084.423,720.723,015.073,845.483,801.714,135.813,378.404,372.223,538.423,372.562,966.635,584.996,195.1512,218.8014,078.2017,600.1212,134.7517,386.0818,998.0217,301.9119,735.7722,403.8927,490.5925,436.9729,921.1835,176.4238,981.4331,715.3548,718.5256,975.9961,354.71
Jun654.28454.32572.10699.02799.501,287.953,001.242,245.203,833.493,409.853,799.013,808.183,642.683,912.004,325.473,557.643,161.093,206.384,835.126,729.9010,071.4014,570.8016,063.1814,840.6316,572.0318,608.8115,965.1619,610.4824,684.8527,848.9926,713.9331,137.5935,227.2640,267.6233,303.5251,934.8855,381.1762,428.54
Jul605.24450.59577.53794.21862.881,275.232,912.922,233.864,118.983,182.403,754.384,300.863,230.604,144.524,844.983,426.033,288.713,604.434,874.057,210.7710,695.3014,664.3012,961.6814,645.4717,509.3318,762.8017,398.9819,577.3925,516.3528,020.8727,144.9131,221.6235,264.4139,686.5035,414.4552,318.6052,907.9365,205.05
Aug586.08488.71609.60729.231,061.661,649.012,722.652,336.624,276.483,390.733,538.604,347.323,112.954,494.184,253.693,284.172,975.813,815.315,202.537,669.4510,751.7014,935.8014,656.6915,924.2318,081.2118,314.3317,257.3819,317.1925,480.8428,187.0628,003.1232,575.1737,521.6237,018.3236,939.6052,950.6358,115.5066,459.31
Sep540.66478.70610.09729.251,260.771,764.363,070.492,630.494,542.783,356.093,562.983,943.672,862.554,824.444,602.433,227.123,187.264,324.765,210.857,876.1511,778.0015,422.0014,498.5115,551.1918,205.8716,821.4617,384.4018,886.1326,867.5525,696.4428,423.4831,892.2338,312.5236,562.9138,900.8057,338.2158,766.5965,387.16
Oct587.27457.67676.58740.721,426.901,858.453,315.722,662.844,339.463,531.493,226.803,905.512,878.074,702.314,135.552,795.302,959.664,455.085,675.548,697.6512,366.4017,328.6213,055.6717,134.5520,445.0416,151.4518,823.9119,517.1526,567.9926,220.9528,243.2931,497.3836,526.1438,305.4138,697.0558,765.5856,788.81₹72,271.94
Nov551.80450.23676.37740.301,323.021,909.802,928.892,621.284,303.653,488.503,148.573,790.822,811.444,270.743,788.533,049.802,950.585,063.035,704.107,944.1013,033.0019,724.3510,337.6815,404.9420,355.6317,480.8318,561.7021,196.8127,860.3826,559.1527,876.6133,600.2734,431.9740,165.0339,757.5860,138.4661,121.35
Dec482.41428.86709.65712.001,203.901,904.262,547.693,292.854,104.333,037.992,851.433,569.652,804.034,614.964,031.963,275.473,270.365,160.856,227.838,944.7813,844.8019,603.418,839.8717,198.2719,850.0016,483.4519,305.3220,898.0128,559.6226,169.4126,559.9232,832.9436,241.0040,802.1744,655.4457,684.7963,284.19

SENSEX Last 30 Years Performance

Time PeriodCAGRAbsolute Returns
1 Year20.65%21%
2 Years13.22%28%
3 Years14.02%48%
4 Years23.09%130%
5 Years13.57%89%
6 Years13.14%110%
7 Years13.75%146%
8 Years14.14%188%
9 Years11.63%169%
10 Years12.54%226%
11 Years12.91%280%
12 Years12.83%326%
13 Years10.86%282%
14 Years10.87%324%
15 Years13.52%570%
16 Years9.60%333%
17 Years10.33%431%
18 Years10.69%522%
19 Years13.84%1073%
20 Years13.64%1191%
21 Years16.59%2411%
22 Years15.16%2133%
23 Years14.14%1995%
24 Years12.20%1483%
25 Years13.27%2153%
26 Years11.89%1757%
27 Years11.58%1827%
28 Years11.14%1827%
29 Years11.51%2253%
30 Years10.09%1871%

SENSEX Daily, Weekly, Monthly, Yearly, Compounded Performance and Historical Data Sheet

SENSEX Historical Data Google Sheet

  • To copy this Google Sheet, go to “File” and click “Make a Copy.”
  • To download this sheet as an Excel file, go to “File” and click “Download as Microsoft Excel.”
5/5 - (1 vote)

Leave a Comment