Option data importing from google finance (open interest & implied volatility)

F&O
86

After such a long time, I finally understood,

  1. Excel data is best way as Google sheets can’t fetch direct stock options or future data.
  2. You’ll have to use Google App Script, which will delay data feed.
  3. I’ve finally prepared an excel file which can fetch live data from Nse, all types, no cookies issue, live data as per requirements.
  4. Since .xlsm or macro enabled or VBA enabled files can’t be run on android, that’s the only regret I have but I am using software to view my system on phone.