How to Calculate XIRR for Your Zerodha Portfolio
Stop guessing your returns. Learn how to download your tradebook and calculate your true XIRR in under 2 minutes.
Why Your Zerodha P&L Might Be Misleading
If you've ever checked your Zerodha Console and seen a P&L figure, you might think you know how well you're doing. But here's the truth: that number doesn't account for timing.
Making ₹50,000 profit over 5 years is very different from making ₹50,000 in 6 months. That's where XIRR (Extended Internal Rate of Return) comes in—it calculates your annualized return, accounting for when you invested and when you sold.
💡 What is XIRR?
XIRR is the annualized rate of return that makes the net present value of all cash flows equal to zero. In simple terms: it's your "true" yearly return, adjusted for the timing of your investments.
Step 1: Download Your Zerodha Tradebook
- Log in to Zerodha Console
- Go to Reports → Tradebook
- Select the date range (we recommend "All time" or at least 1 year)
- Click Download and choose CSV format
⚠️ Pro Tip
Download the complete tradebook, not just P&L. The tradebook contains individual trades with dates, which is required for accurate XIRR calculation.
Step 2: Upload to TrueXIRR
- Go to TrueXIRR.com
- Select Zerodha as your broker
- Upload the CSV file you just downloaded
- Your XIRR will be calculated instantly!
What You'll Learn
TrueXIRR doesn't just show you XIRR. You'll also see:
- Win Rate — What percentage of your trades are profitable?
- Profit Factor — Are your wins bigger than your losses?
- Best & Worst Stocks — Which holdings are helping or hurting you?
- Behavioral Insights — Are you holding losers too long?
Is My Data Safe?
Absolutely. TrueXIRR is a client-side application. Your tradebook data is processed entirely in your browser and never leaves your device. We don't store, upload, or have access to your financial data.
Ready to Know Your Real Returns?
Calculate your Zerodha portfolio XIRR in under 2 minutes. Free, private, instant.
Calculate My XIRR →