Nifty option data

Mahadish

Is there any way we can pull live data (without delay) for nifty options (as in NSE - its with delay) into an excel?

HowUTrade

Yes.. You can use Excel Web-query and Auto-refresh for fetching any html pages.

Mahadish

From Where?
Zerodha provides the data?

Mahadish

aNY UPDATE?

rakeshr

@Mahadish
Yeah,you can fetch live data for specific instruments using Websocket streaming. You can refer documentation here.

Jigpylab

you can download option price at each second, and place order in multiple account using excel with target adn stoploss. If you want to trade from excel using zerodha API refer "tradepyxl" python package given in link. This package is to trade in NIFTY and BANKNIFTY weekly options in multiple account.
https://drive.google.com/drive/folders/15WrmN9owjNrYpmwlmsz9vVUJWZRuCH8X?usp=sharing