Indian Portfolio Tracker - Template

I built this because I had ₹28L across 3 brokers and zero way to see my actual returns. After 6 months of building and iterating, this is what I use every day.

WHAT THIS TRACKS:

✦ Direct equity (NSE + BSE) with live prices via GOOGLEFINANCE

✦ Mutual funds with live NAVs from AMFI

✦ ETFs and SGBs

✦ Multiple accounts: Zerodha, Groww, IIFL, HDFC Sec, Angel, any broker

✦ Multiple people: Your demat, your spouse's, your parents', all in one view

The Features No Apps give you:

🔷 LTCG Grandfathering (Section 112A); Automatic

The tracker looks up the Jan 31, 2018 FMV for every pre-2018 holding and shows your actual taxable gain separately from your notional P&L. This is the calculation most Indians do manually in March every year. This sheet does it every day, per holding.

🔷 Multi-person dashboard with dual-filter

One dashboard. Comma-separate account holders (Person1, Person2) or brokers (Zerodha, Groww) to see combined or individual views instantly. No consumer app does this.

🔷 XIRR — Not fake CAGR

Returns calculated from actual purchase dates and amounts, not average cost. If you've SIP-invested for 3 years, the XIRR is the only honest return figure.

🔷 Unified CMP from the right source; Automatically

Equity and ETFs pull price from GOOGLEFINANCE. Mutual funds pull NAV from AMFI. The sheet picks the right source per holding. One column. Always correct.

🔷 Scales to any portfolio

Add a broker or person by duplicating one sheet and updating one config row. Consolidation, LTCG, and dashboard all update automatically.

What do you get?

→ The Google Sheet (Investment Tracker); make a copy, it's yours permanently

→ Setup PDF guide: every tab, every column explained

→ Sample data pre-loaded so you see it working from the first minute

Your data NEVER Leaves your Google Account.

The sheet lives in your Drive. I never see your holdings. GOOGLEFINANCE and AMFI fetch public prices; not your data. This is the most private portfolio tracker you can use.