v1.6.2 — Sturdy
This release makes the file harder to break and the tax view fairer. No
new tabs, no new switches — just more care.
It watches your back now. The updater used to trust quietly; now it
speaks up before anything can go wrong:
- Nothing gets lost silently. Type more rows than a sheet can keep and
the update refuses to run — it stops before touching anything,
naming the sheet and the limit — and the limits themselves grew (Equity
now holds 250 rows, the fund ledger 1,000). Type10 gmor a formula
where a number belongs, or a date from 1899, and it tells you what it
saw and where, instead of quietly dropping the holding. - A backup before every rewrite — including
--lock, which used to
skip it. And after you view masked numbers, one readable backup now
survives until the next update, so a mistake made while viewing is never
unrecoverable. - Names that Excel can't take as tab names (too long, a
/, a
duplicate) no longer crash the update — the tab is adjusted, your
figures untouched, and it says so. Same for a share bought with an
apostrophe in the family name. - Typos stop lying.
Yunder Privacy mask now means Yes (it used to
silently mean No). Owner typed asAMITcounts everywhereAmitdoes,
goldgets the day's gold rate, and a far-future or ancient date can no
longer blank out the whole update. - Bad feed days can't eat your data. If AMFI (where fund prices come
from) answers with a near-empty page, or an exchange's reply doesn't
look the way it should, the file keeps what it has and says so.
And the tax view: losses now count across your investments. A
debt-fund loss reduces the tax on your share gains, the way the law
(Sec 70) actually works — short-term losses first against short-term
gains, leftovers against long-term gains, debt-fund long-term losses
against long-term gains — all before the ₹1.25 lakh allowance. The
"Losses used vs LTCG ₹" column shows exactly what was counted; it stays
blank in a normal year. Still indicative — for planning, not for filing.
One small answer many of you asked for, now written where you'll see it
(the Guide and the user guide's Equity chapter): bought the same share
on different dates? Just add another row per purchase — every total sums
correctly, and each purchase keeps its own "turns long-term" date in the
tax view.
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.1...v1.6.2