Dear Soumanag,
In your excel utility how can change next month contract?means its showing current month data...how can see next month data in it?
1. Go to connections under Data tab (opens a new window – workbook connections)
2. Click properties in workbook connections (opens a new window – connection properties)
3. Click definition in connection properties
4. Click Edit query
5. A new small window will open where you see the NSE – NIFTY Option chain page (nse-india.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?segmentLink=17&instrument=OPTIDX&symbol=NIFTY&date=26MAR2015)
6. Change the date to 30th April in this page
7. Page will refresh automatically
8. Click import
9. Click Ok in connection properties
10. Close workbook connections window
11. Save the workbook after it is updated
You will see next month’s data