Data & Methodology
How Valuezig sources data and calculates metrics
Last updated: 13 May 2026
1. Data Sources
NAV data: Sourced from the AMFI India public API (api.mfapi.in), which aggregates data reported daily by all SEBI-registered Asset Management Companies.
Update frequency: AMFI publishes NAV data by 11:00 PM on each business day. Values shown reflect the latest available NAV (previous business day's close).
Fund metadata: Category, AMC, scheme type and other details are sourced from AMFI's official fund database.
2. Return Calculations
CAGR (Compound Annual Growth Rate): Annualised point-to-point return for lumpsum investments. Formula: (End NAV / Start NAV)^(365 / Days) − 1.
XIRR (Extended Internal Rate of Return): Accounts for the exact timing and amount of every cash flow. Used for SIP return calculations. Solved via Newton-Raphson iteration. This is the most accurate measure of SIP returns and is the AMFI-recommended method for evaluating systematic investment returns.
Rolling returns: CAGR calculated over every overlapping period of a given length to show consistency of returns across market cycles.
3. Risk Metrics
Maximum Drawdown: Largest peak-to-trough decline in NAV history. Formula: (Trough − Peak) / Peak × 100. Lower (less negative) is better.
Standard Deviation: Annualised volatility of daily NAV returns over the selected period. Measures total fluctuation — both upside and downside.
Sharpe Ratio: Excess return per unit of total risk. Formula: (Fund Return − Risk-Free Rate) / Standard Deviation. Risk-free rate proxy: 6.5% p.a. Higher is better. Ratios above 1.0 are considered acceptable; above 1.5 is strong.
Sortino Ratio: Like Sharpe but penalises only downside deviation. Better measure for investors focused on loss protection.
Beta: Sensitivity to Nifty 50 movements. Calculated via least-squares regression. Beta of 1.0 means moves with market; below 0.8 is defensive; above 1.2 is aggressive.
Alpha (Jensen's): Excess return above what CAPM predicts given the fund's beta. Positive alpha indicates the fund manager generated value beyond market exposure.
4. Portfolio Health Score
A weighted composite score (0–5) across five dimensions:
- Returns (25%): XIRR relative to category benchmark
- Risk Quality (25%): Sharpe and Sortino ratios
- Alpha (20%): Jensen's alpha vs benchmark
- Cost (15%): Blended expense ratio vs category average
- Diversification (15%): Overlap analysis and fund count assessment
This is a proprietary Valuezig metric for comparative and educational use. It is not a SEBI-recognised rating or endorsement of any fund.
5. Expense Ratio
Annual expense ratio is sourced from AMFI data. It represents the percentage of AUM deducted annually for fund management and operational costs. All NAV-based returns shown on Valuezig are already net of the expense ratio — no additional adjustment is needed.
6. Fund Screener
The screener applies the calculations above across all AMFI-listed open-ended schemes. Closed-ended and interval schemes are excluded. Filters apply minimum thresholds to identify funds meeting all selected criteria simultaneously.
7. Limitations
- Metrics are dependent on the accuracy of underlying AMFI data
- Funds with less than 1 year of history may show N/A for some metrics
- All Growth option analysis assumes reinvestment of any interim distributions
- Past data patterns do not guarantee future results
8. Contact
For methodology queries: support@valuezig.com