List of NSE Derivative contract expiry dates

General
1

Any one know some source from where we can get correct information of all the past Nifty expiry dates ?

If someone has saved it for personal use, can you post the list please ?

I know the method for finding the expiry date, by going to NSE site and choosing F&O -> select Historical Data from DropDown List -> Contract-wise Price Volume Data and look at the drop down in the Expiry Date Section.
But the above methods show a lot of values in the drop down column, when we select it for any year like 2018. Whereas I am looking for just the 12 dates for the monthly expiry of Nifty for year 2018, and so on for other years as well.

Thanks and regards

Can some experienced users please comment @nithin, @Sensibull @VelmuruganSengottai, @Newbie420, @RSOptions, @MohammedFaisal, @Umar, @iSTFF,

1 Like
2

@4autotrading

We have 2018 and 2019. Can you please drop a mail to help @sensibull.com? We will send it

2 Likes
3

you can get this info from historical data in nseindia site …
select nifty futures and select the year and i can see only 12 expiry dates for that year :wink:

if we select bank nifty , then we will get so many values …

image
image1600Ă—900 130 KB

4

Thanks sensibull. I have sent the email. Is there any chance to get this information for the previous years as well ?

Best Regards

5

Thanks for replying @VelmuruganSengottai

Please select the year 2018 in that link and then you will see that it is throwing up so many dates there and not just the required 12 dates for that respective year.

You have selected the year 2000 in that snap, please select 2018 year once.

Thanks a lot again. Best Regards.

1 Like
6

yeah … for 2018 it shows almsot all weekly strikes

i tried by selecting stock futures as “Reliance” , it shows proper expiry from 2001 to 2017 … lists everything for 2018 though

edit:-
for stock options it shows properly even for 2018

1 Like
7

Thanks again for the reply.
Ya, trying the stock future is a better idea. If there is no better method, then I will manually note down the date from that drop down list.

Thank you so much and Best Regards

1 Like
8

@Sensibull, when I was manually confirming all the expiry dates for the year 2018, I realized that you guys have made a mistake in the calculation for March 2018 Expiry.

You have written the expiry date as 22 March 2018, but the correct expiry date was 28 March 2018, Wednesday.

I thought that maybe I should remind you about this error.
Once again, thanks a lot for helping with your excel sheet.

Best Regards

9

@4autotrading

Hey yes, you are right.

We went live in April - May, so I didn’t double check that part. My bad

1 Like
10

Hello friends, I am sharing the List of MONTHLY EXPIRY DATES for “NSE BANKNIFTY Options Contracts”, that I manually preprepared by using the information from NSE Website.

The data range for this list is from 1 Jan 2016 to 31 Dec 2023, covering a period of 8 years.

Here is the list -

28-Jan-2016
25-Feb-2016
31-Mar-2016
28-Apr-2016
26-May-2016
30-Jun-2016
28-Jul-2016
25-Aug-2016
29-Sep-2016
27-Oct-2016
24-Nov-2016
29-Dec-2016
25-Jan-2017
23-Feb-2017
30-Mar-2017
27-Apr-2017
25-May-2017
29-Jun-2017
27-Jul-2017
31-Aug-2017
28-Sep-2017
26-Oct-2017
30-Nov-2017
28-Dec-2017
25-Jan-2018
22-Feb-2018
28-Mar-2018
26-Apr-2018
31-May-2018
28-Jun-2018
26-Jul-2018
30-Aug-2018
27-Sep-2018
25-Oct-2018
29-Nov-2018
27-Dec-2018
31-Jan-2019
28-Feb-2019
28-Mar-2019
25-Apr-2019
30-May-2019
27-Jun-2019
25-Jul-2019
29-Aug-2019
26-Sep-2019
31-Oct-2019
28-Nov-2019
26-Dec-2019
30-Jan-2020
27-Feb-2020
26-Mar-2020
30-Apr-2020
28-May-2020
25-Jun-2020
30-Jul-2020
27-Aug-2020
24-Sep-2020
29-Oct-2020
26-Nov-2020
31-Dec-2020
28-Jan-2021
25-Feb-2021
25-Mar-2021
29-Apr-2021
27-May-2021
24-Jun-2021
29-Jul-2021
26-Aug-2021
30-Sep-2021
28-Oct-2021
25-Nov-2021
30-Dec-2021
27-Jan-2022
24-Feb-2022
31-Mar-2022
28-Apr-2022
26-May-2022
30-Jun-2022
28-Jul-2022
25-Aug-2022
29-Sep-2022
27-Oct-2022
24-Nov-2022
29-Dec-2022
25-Jan-2023
23-Feb-2023
29-Mar-2023
27-Apr-2023
25-May-2023
29-Jun-2023
27-Jul-2023
31-Aug-2023
28-Sep-2023
26-Oct-2023
30-Nov-2023
28-Dec-2023

Please note that the following the following Monthly expiries happened on WEDNESDAYS, all other above expiries happened on the normal THURSDAYS only.

25-Jan-2017
28-Mar-2018
25-Jan-2023
29-Mar-2023

And here is the list of Banknifty “WEEKLY” Expiry dates, since their INCEPTION date itself -

2-Jun-2016
9-Jun-2016
16-Jun-2016
23-Jun-2016
7-Jul-2016
14-Jul-2016
21-Jul-2016
4-Aug-2016
11-Aug-2016
18-Aug-2016
1-Sep-2016
8-Sep-2016
15-Sep-2016
22-Sep-2016
6-Oct-2016
13-Oct-2016
20-Oct-2016
3-Nov-2016
10-Nov-2016
17-Nov-2016
1-Dec-2016
8-Dec-2016
15-Dec-2016
22-Dec-2016
5-Jan-2017
12-Jan-2017
19-Jan-2017
2-Feb-2017
9-Feb-2017
16-Feb-2017
2-Mar-2017
9-Mar-2017
16-Mar-2017
23-Mar-2017
6-Apr-2017
13-Apr-2017
20-Apr-2017
4-May-2017
11-May-2017
18-May-2017
1-Jun-2017
8-Jun-2017
15-Jun-2017
22-Jun-2017
6-Jul-2017
13-Jul-2017
20-Jul-2017
3-Aug-2017
10-Aug-2017
17-Aug-2017
24-Aug-2017
7-Sep-2017
14-Sep-2017
21-Sep-2017
5-Oct-2017
12-Oct-2017
18-Oct-2017
2-Nov-2017
9-Nov-2017
16-Nov-2017
23-Nov-2017
7-Dec-2017
14-Dec-2017
21-Dec-2017
4-Jan-2018
11-Jan-2018
18-Jan-2018
1-Feb-2018
8-Feb-2018
15-Feb-2018
1-Mar-2018
8-Mar-2018
15-Mar-2018
22-Mar-2018
5-Apr-2018
12-Apr-2018
19-Apr-2018
3-May-2018
10-May-2018
17-May-2018
24-May-2018
7-Jun-2018
14-Jun-2018
21-Jun-2018
5-Jul-2018
12-Jul-2018
19-Jul-2018
2-Aug-2018
9-Aug-2018
16-Aug-2018
23-Aug-2018
6-Sep-2018
12-Sep-2018
19-Sep-2018
4-Oct-2018
11-Oct-2018
17-Oct-2018
1-Nov-2018
6-Nov-2018
15-Nov-2018
22-Nov-2018
6-Dec-2018
13-Dec-2018
20-Dec-2018
3-Jan-2019
10-Jan-2019
17-Jan-2019
24-Jan-2019
7-Feb-2019
14-Feb-2019
21-Feb-2019
7-Mar-2019
14-Mar-2019
20-Mar-2019
4-Apr-2019
11-Apr-2019
18-Apr-2019
2-May-2019
9-May-2019
16-May-2019
23-May-2019
6-Jun-2019
13-Jun-2019
20-Jun-2019
4-Jul-2019
11-Jul-2019
18-Jul-2019
1-Aug-2019
8-Aug-2019
14-Aug-2019
22-Aug-2019
5-Sep-2019
12-Sep-2019
19-Sep-2019
3-Oct-2019
10-Oct-2019
17-Oct-2019
24-Oct-2019
7-Nov-2019
14-Nov-2019
21-Nov-2019
5-Dec-2019
12-Dec-2019
19-Dec-2019
2-Jan-2020
9-Jan-2020
16-Jan-2020
23-Jan-2020
6-Feb-2020
13-Feb-2020
20-Feb-2020
5-Mar-2020
12-Mar-2020
19-Mar-2020
1-Apr-2020
9-Apr-2020
16-Apr-2020
23-Apr-2020
7-May-2020
14-May-2020
21-May-2020
4-Jun-2020
11-Jun-2020
18-Jun-2020
2-Jul-2020
9-Jul-2020
16-Jul-2020
23-Jul-2020
6-Aug-2020
13-Aug-2020
20-Aug-2020
3-Sep-2020
10-Sep-2020
17-Sep-2020
1-Oct-2020
8-Oct-2020
15-Oct-2020
22-Oct-2020
5-Nov-2020
12-Nov-2020
19-Nov-2020
3-Dec-2020
10-Dec-2020
17-Dec-2020
24-Dec-2020
7-Jan-2021
14-Jan-2021
21-Jan-2021
4-Feb-2021
11-Feb-2021
18-Feb-2021
4-Mar-2021
10-Mar-2021
18-Mar-2021
1-Apr-2021
8-Apr-2021
15-Apr-2021
22-Apr-2021
6-May-2021
12-May-2021
20-May-2021
3-Jun-2021
10-Jun-2021
17-Jun-2021
1-Jul-2021
8-Jul-2021
15-Jul-2021
22-Jul-2021
5-Aug-2021
12-Aug-2021
18-Aug-2021
2-Sep-2021
9-Sep-2021
16-Sep-2021
23-Sep-2021
7-Oct-2021
14-Oct-2021
21-Oct-2021
3-Nov-2021
11-Nov-2021
18-Nov-2021
2-Dec-2021
9-Dec-2021
16-Dec-2021
23-Dec-2021
6-Jan-2022
13-Jan-2022
20-Jan-2022
3-Feb-2022
10-Feb-2022
17-Feb-2022
3-Mar-2022
10-Mar-2022
17-Mar-2022
24-Mar-2022
7-Apr-2022
13-Apr-2022
21-Apr-2022
5-May-2022
12-May-2022
19-May-2022
2-Jun-2022
9-Jun-2022
16-Jun-2022
23-Jun-2022
7-Jul-2022
14-Jul-2022
21-Jul-2022
4-Aug-2022
11-Aug-2022
18-Aug-2022
1-Sep-2022
8-Sep-2022
15-Sep-2022
22-Sep-2022
6-Oct-2022
13-Oct-2022
20-Oct-2022
3-Nov-2022
10-Nov-2022
17-Nov-2022
1-Dec-2022
8-Dec-2022
15-Dec-2022
22-Dec-2022
5-Jan-2023
12-Jan-2023
19-Jan-2023
2-Feb-2023
9-Feb-2023
16-Feb-2023
2-Mar-2023
9-Mar-2023
16-Mar-2023
23-Mar-2023
6-Apr-2023
13-Apr-2023
20-Apr-2023
4-May-2023
11-May-2023
18-May-2023
1-Jun-2023
8-Jun-2023
15-Jun-2023
22-Jun-2023

Please note that the following WEEKLY expiries happened on WEDNESDAYS, all other above expiries happened on the normal THURSDAYS only.

18-Oct-2017
12-Sep-2018
19-Sep-2018
17-Oct-2018
20-Mar-2019
14-Aug-2019
1-Apr-2020
10-Mar-2021
12-May-2021
18-Aug-2021
3-Nov-2021
13-Apr-2022

The only exception to above is the -
6-Nov-2018 WEEKLY expiry, which happened on a TUESDAY

If you find any errors in the above lists, then please kindly let me know at my Telegram ID @NiftyTrader12, so that I can make the necessary corrections and share the updated list.

Please share these lists into any trading groups, where it could be useful for other friends.

Thanks and regards

3 Likes
11

@Sensibull

brother, it just reminds me of our old conversation at that time.

You were quite new then, and just LOOK AT YOU NOW! :grinning:

Great progress made by Sensibull Group in the past few years.

Keep it up, wish you the very best. :pray:

12

Thank you very much

You made my day :slight_smile:

1 Like