NSE OI Data in Excel
Project detail
Need to import open interest of nifty and banknify into excel on real time basis for all strike prices. Excel should get updated while its open. Also need to store previous days oi data in another sheet of same excel and need to arrive at OI CHANGES = Current OI – Previous days OI