The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
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.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
The attendance management ui with the implementation of svg and html tag elements making use of live charts to enhance and display live updates.
How often do the charts refresh?
I am calling this the "Mistake post".
Wait. Did I post this by mistake?....
No, I promise. This is a bookkeeping post about the mistakes that quietly cost business owners money. There are many, so I will take one mistake at a time. This post is only about Mistake 1.
Mistake 1: Mixing personal and business spending One coffee here, one grocery bill there, and by the end of the month nobody knows whose money was spent. Yes, that coffee was a "business meeting". With yourself.
It looks small. It is not. Here is what it quietly does to your business:
Your profit becomes wrong. Personal costs sit inside business expenses, so the numbers do not show how the business is really performing.
Your bank reconciliation becomes slow. Every personal payment needs an explanation before your books can match the bank statement.
Your tax work becomes harder. When costs are mixed, it is difficult to prove which expenses truly belong to the business.
You lose clarity. You cannot tell how much the business earned and how much you took out for yourself.
Check your statement once a week. Small habit. Clean books. Much less stress at year end.
Mistake 2 is coming in the next post, so follow along so you do not miss it.
Built a portal for Vertex that gives students and teachers their own dashboard. Students see their semester, advisor and attendance for every subject. Teachers see the subjects they teach and how many students are in each.
The goal was to keep it clear and easy to scan, so nobody has to dig through menus to find what they need.
