From Excel to Python: Why Indian Finance Needs to Catch Up (Fast)
How I left the formula factory and started automating finance workflows with code — plus a free Python notebook to get you started.
Welcome to QuantML — a weekly drop of code, tutorials, and practical tools for Indian finance professionals who are ready to level up.
I’m Krishna Singh, and I used to live in Excel and tons of ERP/ EPM tools
If you’ve ever spent hours fighting VLOOKUPs, dragging pivot tables across your screen like a caveman discovering fire, or manually forecasting revenue in 19 tabs, then you already know:
> Finance workflows are broken.
> Python can fix them.
> And almost no one is teaching this *with Indian data and use cases.*
---
🤯 Why Python?
In short: it scales, it automates, and it doesn't crash when you open a 40MB CSV file from NSE.
Here’s what I did this week using only Python:
- Pulled historical stock data from NSE
- Cleaned it in 5 lines of code
- Built a basic trend analysis chart
- Exported it into a pretty Excel report
All without formulas. No copy-paste. No Ctrl+Alt+Pray.
---
⚒️ Want to Try It?
I will be sharing the exact notebook I used right here:
👉 [Get the Python notebook] (Google Colab link or GitHub repo — If you dont know this, wants some hand holding. I will be sharing that too.
It includes:
- How to pull stock data from NSE
- Basic moving average logic
- Simple plotting with `matplotlib`
- Exporting results to Excel or PDF
If you’re new to Python, don’t panic — the code is beginner-friendly and annotated with “this line does what Excel would cry about” notes.
---
🧭 What This Newsletter Will Cover
Every week I’ll post something useful for finance nerds like you:
- Python workflows for forecasting, backtesting, dashboards
- ML models on Indian stock market data (that *actually* run)
- FP&A automation, from revenue modeling to scenario planning
- GPT-powered Excel and tools for lazy geniuses
Basically: everything I wish I had when I started moving from Excel to code.
---
If this sounds like your kind of thing — subscribe, share with your finance group chat, or forward to someone who still types every date manually.
Thanks for being here.
Let’s build smarter finance tools, one script at a time.
—
🔗 quantml.in
🐦 [@QuantML](https://twitter.com/QuantML)
💼 [LinkedIn](https://linkedin.com/company/quantml)