VBA Excel Dashboard for NSE Nifty Data

Job ID: 39604317

Budget: ₹12,500 – ₹37,500 INR

I want you to build a fully functional Excel dashboard using VBA that visualizes NSE Nifty Options Chain Data, modeled after the style of the charts and layout found at the following link:

Reference Dashboard:
https://www.barchart.com/etfs-funds/quotes/QQQ/gamma-exposure

Scope of Work:

Data Handling:

You will work with live or imported NSE Nifty Options Chain data.

Assume the raw options chain data is already downloaded (from NSE or a scraper) in Excel format.

You do not need to build a web scraper — just structure VBA around the data provided.

Charts to Include (based on the reference link):

Gamma Exposure (GEX) chart by strike price.

Delta Exposure chart.

Net Gamma vs Price chart.

Put/Call OI and Volume histogram.

Strike-wise Open Interest overlays.

Gamma flip zone markers (if feasible).

Highlight Max Pain, Spot Price, and High GEX levels.

Dashboard Features:

Interactive buttons or dropdowns to select expiry date or update chart.

Automatic chart refresh on data update (via VBA button).

Tooltips or legends for key chart elements.

Clearly marked Spot Price, Flip Zone, and Max Pain.

Design Requirements:

Clean, professional layout using VBA UserForms or formatted Excel sheets.

Each chart should be embedded directly within Excel (no external tools).

Charts and dashboard elements should resemble or improve upon the layout at the reference link.

Delivery Requirements:

Excel file with all VBA code and dashboard features included.

Well-commented code and modular design (easy to maintain).

A short README within the Excel file explaining how to use/update it.