historical OHLC option data for every strike price and expiry

Hi,
I want to download daily OHLC data for option data, I checked this forum and other sites too and found out
my options are :

  1. Historical Contract-wise Price Volume Data
  2. bhavopy e.g. fo08APR2020bhav.csv.zip

Did I miss something, is there some other links where, I can get info ?

Issues with historical contract wise data:

  1. there is no list of strike prices, one need to hit and try, I can easily write a script to do the same, I am just wondering, if there is any other way to get the list of strike prices for a particular expiry, so that I don’t miss any strike price for which data may be there

  2. response is in html and one need to write a parser (scrapper) around it, why nse not using json or any general format? or is there other way to get the response in easy way

  3. In the data (inserted a screenshot), what is meaning of following columns :

    1. No of contracts ( why this is separate field and not same as OI )
      i.e what is difference between no of contracts and OI)

    2. Turnover in ₹ Lacs and Premium Turnover in ₹ Lacs
      these two doesn’t factorised by 75 (lot size) in this case of nifty

  1. Lot size is not specified anywhere, does one has to follow https://www.nseindia.com/products-services/equity-derivatives-nifty50 to get this csv file on the page
    also this file is for the current year only, where can one get historical information about lot size ?

I can write my parser around zerodha or use there APIs to get data, but I want to use only NSE .

1 Like