Projects using MySQL in NoidaProjects using MySQL in Noida
Projects
People
Cover image for In this technical deep-dive, I
In this technical deep-dive, I engineered a robust SQL script to extract high-level financial insights from 20+ years of Nifty 50 data. I moved beyond basic queries to implement complex analytical functions that simulate real-world market tracking. Market Sentiment Logic: Developed a CASE-based classifier to identify Bullish/Bearish trends using 50-day Moving Averages. Volatility & Risk: Calculated day-on-day price fluctuations and ranked high-risk trading days. Momentum Tracking: Integrated window functions (LAG/LEAD) to compute RSI-base logic and 30-day price momentum. Efficiency Metrics: Analyzed Turnover Efficiency to understand market liquidity during peak trading hours. This project demonstrates my ability to handle large-scale financial datasets and translate raw numbers into strategic market indicators.
1
37