Business Analytics
Live Options OI Tracker
Excel-based tool for tracking and analysis of OI changes in options that trade on NSE
Web ScrapingDashboardDescriptive AnalysisOption ChainOI AnalysisNSEPythonExcelCapital Markets
Problem Statement
An Indian retail derivatives trader wanted a system that could help detect high options activity in real-time to identify trading opportunities. An excel based tool that tracks price and OI changes across the option chain in multiple underlyings was required.
Challenges
- Real-time options data is expensive and a way to retrieve free options data was required
- A simplified user interface and one-click launch was required for a non-technical user
Solution
Summary
I developed a web scraper that retrieved data from the official NSE website every 2 mins. I designed an excel dashboard that helped track intraday OI changes and other key indicators such as PCR and price changes.
Key Features
- A python based web scraper that automatically extracts latest available options data from NSE
- Python modules for data processing, transformation and computation of key indicators
- Dashboard design in excel with conditional formatting and charts for easy identification of market opportunities
- One-click launch using a combination of VBA and Python
Excel Dashboard for Live Tracking
Detailed EOD and Historical Data for Analysis
Have a similar challenge?
Let's discuss how we can develop solutions for your specific use case.