Methodology & Data Sources
Every number in the SIP/FD calculator comes from a free, public source. Here is what we fetch, how often, and how we compute derived values. If the data ever becomes stale you will see a coloured badge in the calculator UI.
India Market Mood Index (composite)
Score from 0 (Extreme Fear) to 100 (Extreme Greed), weighted as a simple linear combination of three signals:
- NIFTY 50 P/E (50%) — z-score of today's P/E vs the 10-year mean and standard deviation. High P/E → high score (greed / expensive). Source: NSE archives daily index summary CSV (
ind_close_all_DDMMYYYY.csv). - India VIX (30%) — piecewise linear: VIX < 12 maps to 80 (greed), VIX > 25 maps to 20 (fear), linear in between. Source: Yahoo Finance v8 chart endpoint.
- Advance/Decline ratio (20%) — count of NIFTY 50 stocks rising vs falling today. Source: NSE
equity-stockIndicesindicator endpoint.
We chose 50 / 30 / 20 because valuation moves slowest (anchors the score against speculative noise), volatility captures short-term sentiment, and breadth is the noisiest signal so it gets the smallest weight.
The 10-year P/E mean (24) and standard deviation (4) used for the z-score are stored as quarterly assumptions, not refetched daily. They change slowly enough that this is honest; we revise them when meaningful drift accumulates.
Tax assumptions
- Equity LTCG: 12.5% on gains above ₹1,25,000 per year of redemption (post Budget 2024). We model a single redemption at maturity — this is conservative because an actual SWP-style staggered redemption would distribute the exemption across multiple years, lowering effective tax further.
- FD interest: taxed at the user's slab annually. Modelled as a reduced effective compounding rate:
effective = nominal × (1 − slab). - Inflation: default 6.0% CPI. Real returns computed via the Fisher equation:
(1 + nominal) / (1 + inflation) − 1, not naive subtraction. Compounded over 20 years, the difference matters.
NIFTY CAGR
Trailing 1y / 3y / 5y / 10y / 15y CAGR computed from Yahoo Finance daily close prices for ^NSEI. We pick the close on (or just before) the date N years ago, then apply (end / start)^(1/N) − 1. Yahoo's ^NSEI history starts ~September 2007, so a 20-year bucket would be empty and is intentionally omitted.
FD rates
Scraped weekly (Mondays) from each bank's official rates page on the .bank.in domain (RBI mandate, October 2025). General + senior-citizen rates for 2–3 year tenure. If a bank's page changes layout, the parser logs a partial failure and we keep showing the previous rate with a stale badge until the parser is updated.
Today's coverage: SBI is the seed bank scraped end-to-end. The remaining 11 banks are being added incrementally; the orchestrator gracefully tolerates partial failures.
Mutual fund category returns
Categories sourced from the AMFI scheme master CSV. For each scheme we fetch daily NAV history from mfapi.in (a community wrapper around AMFI's own daily file), compute trailing 5y and 10y CAGR, then average per category. The “Top 5” list is the highest 10y CAGR within each category — shown so you can sanity-check the average against real funds, not as a recommendation. We deliberately do not run any kind of fund-screening or rating algorithm.
Small savings
PPF, NSC, KVP, SCSS, SSY, and Post Office TD rates are set quarterly by the Ministry of Finance via the Department of Economic Affairs press release. We seed these manually each quarter from the official notification PDF.
Update cadence
| Dataset | Cadence | Last successful update |
|---|---|---|
| nifty-cagr | daily | Sat, 16 May 2026 21:26:05 GMT |
| mmi | daily | Sat, 16 May 2026 21:26:10 GMT |
| fd-rates | weekly (Mondays) | Mon, 11 May 2026 21:50:47 GMT |
| category-returns | daily | Sat, 16 May 2026 21:27:11 GMT |
| small-savings | quarterly | Sat, 16 May 2026 21:27:12 GMT |
Known limitations
- LTCG modelled as single redemption — real returns may differ if you stagger withdrawals.
- Inflation is a single CPI estimate; lifestyle-specific inflation (healthcare, education) runs higher.
- FD scrapers are HTML-based and may briefly drift if a bank redesigns its rates page.
- Small-savings rates are seeded manually each quarter from the GoI press release.
- The Top 5 fund list currently includes IDCW / Growth / Bonus variants of the same scheme as separate rows; we plan to dedupe by base scheme name.
- Past performance does not predict future returns. Mutual funds are subject to market risk.