OI Data Fetching & Option Analysis

Job ID: 39301627

Budget: ₹2,000 – ₹15,000 INR

I'm seeking a professional who can assist me in collecting Open Interest (OI) data for all 150+ Futures and Options (FnO) stocks every 15 minutes. This data should be fetched from an API service to either Excel or Google Sheets. The analysis will involve the entire option chain, including calculations of max pain, open interest changes and implied volatility analysis.

Skills and Experience Required:
- Proficiency in using various API services, particularly Zerodha, Angel One, or Upstox.
- Strong skills in Excel or Google Sheets.
- Experience in performing option chain analysis.
- Familiarity with financial concepts such as IV,PCR, max pain and implied volatility.
Related categories: Excel Web Scraping Scripting API Automation