Portfolio Lab
Theme
Pause lights
Money LabMoney LabPortfolio Lab

Explore Money Lab

HomePortfolio LabCalculators ↗GuidesMethodologyContact us

Historical comparisons, clear assumptions.
Explore possibilities, not promises.

Home›Methodology
MONEY LAB · PORTFOLIO LAB

Understand the model before trusting the result.

How Portfolio Lab handles historical prices, NAVs, dividends, currency conversion, SIP, SWP, rebalancing, CAGR and XIRR.

Data sources and freshness

Portfolio Lab requests historical market prices and instrument search from Yahoo Finance, and Indian mutual fund scheme lookup and NAV history from MFapi. Data is retrieved when you verify or run a comparison; this is not a live trading feed and no update-time guarantee is made. Provider delays, missing values, revisions or outages can affect results.

Yahoo Finance · MFapi · AMFI NAV reference

Monthly observations and common history

The latest available daily observation in each calendar month is retained. Only continuous months shared by all holdings are used, so the requested range can shorten. Holdings may have different last trading dates within a month; the first holding’s observation dates label cash flows and charts. This is a monthly approximation, not synchronized daily execution.

Dividends and distributions

Yahoo adjusted close is used when available and generally incorporates applicable splits and dividends, effectively modeling reinvested distributions. If that series is unavailable, the code falls back to closing prices; dividend returns may then be missing. Separate cash dividends and dividend taxes are not modeled.

Indian mutual funds use the selected scheme’s NAV. Growth options reflect retained income in NAV. For IDCW/distribution options, this tool does not add cash distributions or reinvested units, so NAV-only returns can understate total returns. Do not interpret these as full total-return comparisons.

Yahoo’s adjusted-close definition

Cash flows and date boundaries

Lumpsum is invested at the first observation. SIP invests at each observation, including the first, after that month’s return. Contributions stop at observations after SIP end date; each 12 payments triggers the next annual step-up. SIP purchases follow target weights.

SWP begins at observations on or after SWP start date, never at the initial investment observation. Payments sell holdings proportionally to current balances. Annual increases follow every 12 scheduled payments. Actual payments are capped at the balance, with unfunded requests reported separately.

Rebalancing and currency

Rebalancing restores target weights after cash flows, every 1, 3, 6 or 12 months from the first observation. With rebalancing off, weights drift. USD/INR monthly history converts foreign-currency prices into the chosen base currency. Missing conversion data blocks the calculation.

Return calculations

Lumpsum CAGR is (ending value / initial value) raised to 1 / elapsed years, minus 1. For SIP and SWP, XIRR seeks an annual rate that discounts modeled dated investments, withdrawals and final value to zero. A numerical solver can fail or find one of multiple possible roots.

Rolling returns chain monthly portfolio returns before external cash flows. Windows below 12 months are cumulative; longer windows are annualised. Windows involving depletion are unavailable. Cash flows can affect holdings and therefore subsequent performance.

What is not included

Taxes, transaction fees, slippage, liquidity limits, whole-share constraints and investor-specific costs are not separately simulated. Fund expenses already reflected in supplied prices or NAVs are not added again. Coverage, survivorship bias, tracking differences, historical revisions and provider errors remain limitations. Past performance is not a forecast.

Ownership and corrections

Portfolio Lab is a Money Lab tool for educational exploration. No professional qualifications or independent performance audit are claimed here. To report a suspected issue, send the instrument codes, dates, currency, method and expected versus observed result via our contact page. Do not send account details or sensitive financial information.

Report a calculation or data issue
EXPLORE PORTFOLIO LAB

Choose the question you want to answer.

Portfolio Comparison & BacktestingSIP Backtesting with Step-up & End DateSWP Backtesting with Increasing WithdrawalsMonthly vs Annual Portfolio RebalancingRolling Returns for Portfolio Comparisons

Worked examples & guides · Methodology & data · Future projections at Money Lab ↗

Money Lab · Clarity for every financial journey.
GuidesMethodology & dataPrivacyPortfolio LabFinancial calculators ↗Contact us