ReturnsPlannerReturnsPlanner
Quarterly Results
IPO Analysis
CalculatorsGlossaryEditorial
CalculatorsXIRR Calculator — Know Your True Portfolio Returns

XIRR Calculator — Know Your True Portfolio Returns

Upload your Zerodha, Upstox, or Groww tradebook CSV and instantly calculate your real portfolio XIRR with stock-wise breakdown, yearly analysis charts, and P&L tracking. 100% free, no signup, fully private.

1Upload Tradebook CSV(s)

Drop your Tradebook CSV / Excel files here

Zerodha • Groww • IndMoney • Upstox • MF • .csv/.xlsx

or paste CSV

2Current Portfolio Value

Required if stocks are still in your portfolio (not yet sold)

Or upload Holdings CSV to auto-calculate value

How to use

  1. Go to your broker (Zerodha, Groww, IndMoney, etc.) and download Tradebook CSV/Excel
  2. For multiple brokers, download from each one separately
  3. Upload all files together — we auto-detect the broker format
  4. Enter your current portfolio value for unsold holdings
  5. Click Calculate — we merge everything and show your combined XIRR
💡 Tip: Zerodha Console limits tradebook exports to 1 year at a time. Upload multiple yearly CSVs and we'll merge them seamlessly.

Share Your custom XIRR Calculator — Know Your True Portfolio Returns Plan

All slider inputs, expected returns, interest rates, and custom goals are saved in this unique URL. Bookmark this page or share the link with others to show your plan.

Verified Accurate & Compliant
Updated: May 2026

What is XIRR?

XIRR (Extended Internal Rate of Return) is the gold standard for measuring investment returns when you have multiple cash flows at different times. Unlike simple percentage returns or CAGR, XIRR accounts for the exact timing of every buy and sell transaction — giving you the true annualized return on your portfolio.

Why simple returns are misleading

If you invested ₹1,00,000 in January and another ₹2,00,000 in November, your money didn't all work for 12 months. A simple "total return %" ignores this timing completely. XIRR solves this by treating each cash flow individually.

How to use this calculator

Step 1: Export your Tradebook

  1. Log in to Zerodha Console → Reports → Tradebook
  2. Select your date range (up to 1 year per export)
  3. Click Download CSV
  4. Repeat for each year you want to analyze

💡 Pro Tip: Zerodha limits exports to 1 year at a time. Upload multiple yearly CSVs — we merge them automatically with de-duplication.

Step 2: Upload your files

  • Drag and drop multiple CSV files into the upload area
  • Or click to browse and select multiple files at once (hold Ctrl/Cmd)
  • You can also add more files later using the "Add more files" button

Step 3: Enter your current portfolio value

If your stocks are still in your portfolio (not fully sold), this step is essential:

  • Enter the total current market value from your Zerodha Holdings page
  • Or upload your Holdings CSV for auto-calculation

Step 4: Calculate & Analyze

Click Calculate Portfolio XIRR to get:

  • ✅ Your true annualized return (XIRR %)
  • 📊 Year-over-year investment vs returns bar chart
  • 📈 Cumulative investment area chart over time
  • 🏆 Stock-wise XIRR for every stock you've traded
  • 💰 P&L breakdown with win/loss ratio

Supported Brokers & Platforms

PlatformAsset ClassFormatStatus
ZerodhaIndian Stocks, F&OConsole Tradebook CSV✅ Fully Supported
GrowwStocks & MFTrade Report CSV✅ Supported
IndMoneyIndian & US StocksTransaction CSV✅ Supported
UpstoxStocks, F&OTrade History CSV✅ Supported
MF PlatformsMutual FundsTransaction Statement CSV✅ Supported
GenericAnyDate, Amount CSV✅ Supported

🌍 Multi-Portfolio: Upload files from different brokers together! We auto-detect each file's format and merge all trades into a single unified XIRR calculation across your entire portfolio.

Your data is 100% private

Everything runs in your browser. Your tradebook data is never uploaded to any server. We don't see it, we don't store it, we don't transmit it. Close the tab and your data is gone.

Understanding your results

Portfolio XIRR

This is your annualized return — what your portfolio would earn per year if it grew at a constant rate. A 25% XIRR means your investments have compounded at 25% per year.

Peak Capital Deployed

The maximum money at risk at any point in time. Unlike gross turnover (which inflates when you reinvest), this shows your actual capital commitment.

Stock-wise XIRR

Individual XIRR for each stock helps you identify your best and worst performers. A stock with 100% XIRR doubled your money in annualized terms; -50% means it lost half.

XIRR vs CAGR vs Absolute Return

MetricBest ForHandles Multiple Cash Flows?
XIRRReal portfolio with buys/sells at different times✅ Yes
CAGRSingle lump-sum investment held for years❌ No
Absolute ReturnQuick snapshot of total gain/loss❌ No

Frequently Asked Questions

Is XIRR the same as CAGR?

No. CAGR assumes a single investment, while XIRR handles multiple cash flows at different dates. For SIP or active trading, XIRR is always more accurate.

What XIRR is considered good?

For Indian equity markets, an XIRR of 12–15% is in line with Nifty 50 long-term returns. Above 20% is excellent. If your XIRR beats the index, you're outperforming.

Why is my XIRR different from Zerodha's?

Zerodha shows XIRR for individual stocks, not your overall portfolio. Our calculator gives you the combined portfolio XIRR across all stocks and time periods.

Can I use this for mutual funds?

Yes! If your mutual fund platform exports a transaction CSV with dates and amounts, you can paste it directly. The calculator works with any date-amount pair.

Embed this Calculator on Your Website

Provide interactive financial planning directly for your blog or news audience.

✓ 100% Mobile Responsive✓ Zero Ads or Popups✓ Direct Backlink Authorized u/s Creative Commons

Other Calculators

Bitcoin SIP Calculator

Emergency Fund Calculator

FD Calculator