When you open the file, it asks you to enable two things:
1. Macro
2. Data Connection ( to fetch live NSE data of NIFTY )
Please ensure to enable both.
Then it will update every 60secs with live data of NIFTY.
I found the reason why #### are seen on "Options pricing" sheet.
2 Cells needs correct entry or formula & a 3rd cell needs manual entry once the current series expires for the next active series.
Things need fixing are: ( all on Options Pricing sheet - 2nd sheet )
1. D7 needs this =NETWORKDAYS(TODAY(),L5)
2. D9 needs a manual entry of CNX NIFTY Dividend Yeild(DY)
Get an average DY from
http://www.nseindia.com/products/content/equities/indices/historical_pepb.htm
3. After the current series expiry, please update L5 with the next series expiry date.
That's all.
Thanks to : Niladri Jana