# Historical Sensex Option Chain Data: How to Find an Expired Contract
Author: AlgoTest
Author URL: https://algotest.in/blog/author/algotest/
Published: 2026-11-15
Category: option chain
Category URL: https://algotest.in/blog/category/option-chain/
Meta Title: Historical Sensex Option Chain Data: Excel and Intraday Replay
Meta Description: Find an expired Sensex option by date, strike and expiry. Use a real 85,400 call to check the closing price in Excel or look up an intraday premium on AlgoTest.
Tags: algo trading india, options trading
Tag URLs: algo trading india (https://algotest.in/blog/tag/algo-trading-india/), options trading (https://algotest.in/blog/tag/options-trading/)
URL: https://algotest.in/blog/sensex-historical-option-chain-data/

The Sensex 85,400 call expiring on 30 October 2025 closed at **₹126 on 28 October**. What was it trading at **10:15 am** that day? Those two questions refer to the same option, but you need different records to answer them.

For a closing price, use the **BSE equity derivatives bhavcopy**, the exchange’s end-of-day file. You can open it in Excel and filter by trading date, expiry, strike and option type. For a price at a particular minute, use a **historical option chain replay**. For contracts trading now, use the [**live Sensex option chain**](https://algotest.in/sensex-option-chain).

## **Which date do you need to find an expired Sensex option?**

Start with the **trading date**. It tells you which day’s file to open. The [**Sensex expiry date**](https://algotest.in/blog/sensex-expiry-day/) tells you which contract to find inside it. If you download the 30 October file to answer a question about 28 October, you’ll find a different session’s prices even if you pick the correct strike.

Here’s the contract we’ll look up in Excel and in replay.

**Field**

**Value**

Exchange and underlying

BSE · SENSEX

Trading date to look up

28 October 2025

Contract expiry

30 October 2025

Strike price

85,400

Option type

CE (call)

MoneyTicks reports the following prices per unit for the 85,400 call:

**Trading date**

**Open**

**High**

**Low**

**Close**

28 October 2025

₹220.00

₹290.00

₹79.70

**₹126.00**

29 October 2025

₹129.85

₹180.00

₹77.35

**₹150.80**

If your lookup returns ₹150.80 instead of ₹126, check the trading date first. Both values are closing prices for the same 85,400 call.

## **How to get historical Sensex option chain data in Excel**

![sensex historical option chain](https://prod.superblogcdn.com/site_cuid_cmbhlz3q0002sxzc513a62pj5/images/sensex-historical-option-chain-excel-steps-1794759940919-compressed.png)

1. **Find the daily derivatives file.** Open [**BSE’s Bhav Copy page**](https://www.bseindia.com/markets/MarketInfo/BhavCopy.aspx). Look for **Equity Derivatives (FO)** and the trading date **28 October 2025**. The cash-market file, labelled **CM**, covers a different segment.

2. **Import the CSV.** Extract the file first if it comes as a ZIP. In Excel, choose **Data → From Text/CSV**, select the file and check that the dates and prices appear in separate columns. Load the data, then turn on **Data → Filter**.

3. **Build the chain for one expiry.** Filter the underlying to **SENSEX**, the expiry to **30 October 2025**, and the option type to **CE and PE**. Sort by strike price. You can now [**compare calls and puts across strikes**](https://algotest.in/blog/how-to-read-and-analyse-sensex-option-chain/) for that session.

4. **Find the example contract.** Narrow the strike to **85400** and the option type to **CE**. Read the **closing price** column. If the file also has a last traded price or settlement price, keep those fields separate. Save the filtered view as an Excel workbook if you want to keep the filters.


**Want calls and puts side by side?** Insert a PivotTable from the original data. In the PivotTable’s own Filters area, select **SENSEX**, one trading date and one expiry. Put **strike price** in Rows, **option type** in Columns (keep CE and PE) and **closing price** in Values. Check that each strike and option type has just one source row, then use **Max** to display that single price. Leave missing observations blank. A blank cell and a recorded price of zero mean different things.

## **How to replay the Sensex option chain at 10:15 am**

[![sensex historical option chain](https://prod.superblogcdn.com/site_cuid_cmbhlz3q0002sxzc513a62pj5/images/sensex-option-data-which-source-1794760351369-compressed.png)](https://algotest.in/register?utm_source=blogs&utm_medium=organics&utm_campaign=seo)

On 28 October, the 85,400 call traded as high as ₹290 and as low as ₹79.70. The daily file gives you both extremes. It doesn’t tell you which came first or what premium was visible at 10:15 am.

1. Open the [**AlgoTest Sensex Option Simulator**](https://algotest.in/feature/simulator) and set the replay date to **28 October 2025** and the time to **10:15 am IST**.

2. Check that the underlying is **SENSEX**. Select the **30 October 2025** expiry and find **85,400** in the strike column.

3. Read the call’s [**last traded price (LTP)**](https://docs.algotest.in/clicktrade/simulator/introduction/) at the selected time. Advance the replay by a minute to see whether the displayed premium changes. LTP is the last recorded trade, so a change of minute needn’t mean a change of price.


Record the replay time beside the premium. That keeps the intraday observation separate from the ₹126 daily close. The [**Simulator setup guide**](https://docs.algotest.in/clicktrade/simulator/setup/) shows where to change the underlying and expiry.

## **Frequently asked questions**

### **Can I download an expired Sensex option chain in Excel?**

For end-of-day data, use the BSE equity derivatives CSV for the trading date you need. Import it into Excel, select SENSEX and the expiry, and keep all strikes and both option types. For a spreadsheet with one row per minute, you need a source that explicitly offers intraday export.

### **How do I get the same Sensex option’s prices for several days?**

Keep the expiry, strike and option type fixed. Look up that contract across the trading dates you need, or use a contract-level price history. For a **chain on one day**, do the reverse: keep the trading date and expiry fixed and retain all available strikes.

### **Why can’t I find the expired contract?**

Check the exchange, trading date, expiry and CE/PE filter. Sensex index options trade on BSE. A file dated after expiry won’t give you that contract’s trading prices, and a live chain is for current expiries. For a Nifty contract on NSE, follow the [**Nifty historical option data guide**](https://algotest.in/blog/nifty-option-historical-data/).


---
This blog is powered by Superblog. Visit https://superblog.ai to know more.
---

