: You can download pre-built .xlsm (Macro-enabled) files from communities like SourceForge or GitHub that already contain the necessary code to fetch LTP, OI, and IV.
: Click Close & Load to import the data into your sheet. You can set this to Refresh every 5 minutes by right-clicking the table and selecting Query Properties . Method 2: Using VBA Macros (Real-Time Customization) how to download nifty option chain in excel
: Use the MSXML2.XMLHTTP object within VBA to send a request to the NSE website, then use a JSON converter to map the values to your cells. Method 3: Advanced Automation with Python : You can download pre-built
Power Query is the most reliable built-in Excel feature for pulling data from the NSE India Website . how to download nifty option chain in excel