Live Nifty Options Excel Dashboard

I want an Excel workbook that connects to the https://www.nseindia.com/option-chain (public access) and continuously pulls the Nifty 50 option-chain data I specify: the at-the-money strike, plus five strikes out-of-the-money and five strikes in-the-money. For each of those eleven strikes the sheet must capture three fields—Open Interest, Change in Open Interest, and Volume Strike Price—and refresh them automatically every three minutes.

Inside the file I need a time-stamped line graph that updates in real time, plotting the same three metrics so I can watch how they evolve through the session without touching the sheet. A single click to start or stop the refresh loop is fine; otherwise the process should run silently in the background.

Please build with whichever approach inside Excel you prefer—VBA, Power Query, Office Scripts, or a lightweight add-in—so long as it:

• Calls Alpha Vantage cleanly (I’ll paste my own API key).
• Stores the raw JSON/CSV response in a hidden sheet for audit.
• Transforms that data into a tidy table the chart can read.
• Handles connection errors gracefully and resumes on the next cycle.

Deliverable is the finished .xlsx (or .xlsm) file with clear in-sheet notes showing where to insert the key and how to modify strike lists later. No external dependencies other than the API.