v1.7.0 — Ten years of SIPs, typed in for you
The most boring job in this workbook just disappeared.
Your funds: one PDF does it all. Every fund investor in India can
email themselves one free, official statement that lists every purchase,
SIP and sale across every fund house — it's called a CAS. Go to
camsonline.com → Statements → CAS – CAMS+KFintech, pick Detailed
and Since inception, choose a password. Save the PDF that arrives
next to your tracker file and run the update. It asks for the PDF's
password (never stored), shows you every fund it read, and types the
whole history in — exact dates, amounts, NAVs and units.
Your shares: your broker's file works too. Save your broker's
tradebook or holdings export (CSV or Excel) in the same folder. Any broker's file
is read if its columns are named — buys become rows with their real dates
and prices, sales are netted off, and a holdings file double-checks the
result against what your broker says you own. Sold shares the file never
shows you buying — old paper certificates, transferred holdings? One
question ("bought before Feb 2018?") and the official 2018 value stands
in as their cost.
Built so you can trust it:
- Every number proves itself before it lands. Each statement line
must satisfy the statement's own arithmetic (amount = units × NAV,
the fund's unit price), and each fund must add up to the closing
balance printed on the statement itself. A fund that can't be read reliably is left out
whole, with a plain reason — never guessed, never half-imported. - Run it again anytime — nothing doubles. A newer statement just adds
the new months. Already-read files are remembered and not asked about
again. - If you'd already typed a fund by hand, the statement's exact history
replaces those rows — after you confirm, with your file backed up
first. Prefer to keep your rows? Choose "only add" at the prompt. - Who owns which folio is asked once and remembered.
Also in this release: more room — the shares sheet now holds 1,500
rows and the fund ledger 3,000, so full imported histories fit as-is.
Even longer? The updater asks whether it may roll the oldest years into
one opening line per fund — totals still match the statement, and saying
no just makes it wait.
And a one-line answer for old paper share certificates: type the
quantity, leave the cost blank, and put 31-01-2018 as the buy date —
the official 2018 value fills in and the tax maths is right.
Still true, always: everything stays on your computer. The update only
downloads public prices; nothing about your money is ever sent
anywhere.
Get it: download the zip for your computer below (Windows or Mac) and
unzip it. Updating? Keep your own Excel file; just replace the Update
Portfolio app with the new one.
Full changelog: v1.6.2...v1.7.0