Options Market Data Automation
Automate the handoff into analysis.
A Python/Pandas tool that retrieved options-market data and prepared standardized Excel datasets for recurring analysis.
From repeated preparation to a reusable workflow.
The context
During my Religare Broking internship, brokers and analysts needed recurring options-data inputs for Excel-based analysis. Preparing consistent datasets was part of making those reporting workflows reliable.
The tool
I developed a Python tool that retrieved options-market data and used Pandas to standardize the records into Excel-ready datasets. It replaced repeated collection and formatting steps with a reusable preparation workflow.
The wider workflow
The internship also involved portfolio reporting, validation, reconciliation, and Excel workflows using PivotTables, VBA, and Goal Seek. The automation tool is part of that experience, not a separate client product.
Scope
Employer code and data are not published here. The project focused on preparing inputs for analysis and recurring reporting.