📘TraderTape Docs

Mutual funds & CAS

TraderTape can pull your mutual fund holdings from a Consolidated Account Statement (CAS) PDF — the monthly statement that CAMS or NSDL sends to every Indian investor by email. One upload gives you folio-level positions, NAV-priced valuations, and per-scheme XIRR alongside your equity holdings.

Supported formats

  • CAMS CAS — the most common format. Sent monthly to investors with holdings in CAMS-serviced AMCs (HDFC MF, Nippon, ICICI Prudential, Kotak, Axis, Franklin, etc.)
  • NSDL CAS — for investors holding demat-only securities (stocks + ETFs in demat form, plus some MF)

Both are password-protected. The password is usually your PAN in uppercase.

How to upload

  1. Open Settings → Data Sources → Consolidated Account Statement (CAS)
  2. Upload the PDF file
  3. Enter the password if prompted
  4. Click Import

The parser extracts every folio, every scheme, every transaction in the statement. Data is stored and shows up immediately in:

  • Wealth → Dashboard (consolidated net worth)
  • Wealth → Portfolio (detailed MF breakdown)
  • Journal → P&L Analysis (realised MF gains)
  • Journal → Benchmark (for MF equity curve comparisons)

What the parser handles

  • Folio-level dedup — if a folio has multiple schemes, each is tracked separately
  • Transaction types — purchases, SIPs, redemptions, switches, dividend reinvestment, rights issues
  • Corporate actions — scheme mergers, bonus units, stock splits on scheme holdings
  • Unit rounding — CAS reports to 3 decimals; the parser preserves full precision

Once a scheme is imported, TraderTape fetches daily NAVs from AMFI's public feed and caches them. The dashboard values your holdings at the latest available NAV. Per-scheme XIRR is computed from the transaction history using SciPy's NPV solver.

Privacy

CAS PDFs contain sensitive data (folio numbers, PAN, holdings). Two privacy options:

  • Direct upload — the PDF is parsed server-side and discarded. Only the extracted data is stored.
  • Agent-mediated upload — if you have the local agent configured with obfuscation enabled, uploads route through the agent which applies your fudge factor before sending. The cloud never sees your real holdings values.

Fresh CAS every month

Re-upload whenever you get a new CAS. Duplicate transactions are silently skipped (matched on folio + scheme + date + amount). Only new transactions flow through.

A convenient habit: forward your monthly CAS email to a dedicated inbox and re-upload on the 1st of every month. Takes 30 seconds.

Troubleshooting

"Password protected PDF" — Use your PAN in uppercase. If that fails, check if your CAS issuer (CAMS vs NSDL) uses a different password scheme.

Some schemes missing — CAMS only tracks AMCs they service. If you hold Quantum, Edelweiss, or PPFAS, you'll get CAMS data for some schemes and NSDL data for the rest. Upload both statements.

NAV shows as N/A — AMFI doesn't publish NAVs for all schemes (some close-ended funds, some direct-plan-only variants). The holdings still show; the valuation just can't be computed.

← Previous
Multi-broker setup
Next →
Family groups