stock exchange
stock exchange
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
To get live Nifty futures data in Excel, use MarketXLS India (marketxls.in) with your Zerodha account connected. Build the contract symbol with =FuturesSymbol("Underlying","Expiry Date"), then pull its price with =zerodhaLast(Futures Symbol). Once the market opens, the price streams into Excel through your Zerodha connection. MarketXLS India costs ₹3,500 a month (pricing).
What is Nifty Futures?
Nifty Futures is a financial instrument traded on the National Stock Exchange of India. It is a derivative contract based on the Nifty 50 index. This contract allows investors to buy or sell the index at a preset price for delivery on a future date. It is used for hedging and speculative trading. The price of Nifty Futures is driven by the Nifty 50 index value. Thus, any changes in the index directly impact the futures price. Traders use it to hedge or to take a view on the index.
What is the difference between NIFTY 50 and NIFTY 50 futures?
NIFTY 50 is India’s primary stock index that represents 50 of the largest and most liquid Indian companies traded in National Stock Exchange (NSE). It works on a weighted average market capitalization method. On the other hand, NIFTY 50 Futures are derivative contracts, reflecting the probable future value of NIFTY 50. These contracts allow investors to buy or sell the NIFTY 50 index at a predetermined price for a specified period. So, while NIFTY 50 represents the current market status, NIFTY 50 futures indicate the anticipated market performance.
How do you get live Nifty futures data in Excel?
The MarketXLS formula “=FuturesSymbol(“Underlying”,”Expiry Date”)” is a useful tool to generate a futures symbol. After creating the symbol, apply “=zerodhaLast(Futures Symbol)” to extract the price of the future in Excel. Remember, a connection between your MarketXLS and Zerodha is mandatory. As soon as the markets open, data will automatically stream into your Excel.
Summary
Nifty Futures is a financial instrument traded on the National Stock Exchange of India based on the Nifty 50 index. The price of Nifty Futures is directly impacted by any changes in the index. NIFTY 50 represents the current market condition, while NIFTY 50 futures reflect the anticipated market performance. Live Nifty futures data can be fetched in Excel using the MarketXLS formula after establishing a connection with Zerodha. The data lets you track and analyze the contract in your own spreadsheet.
