Mutual Funds Data Dictionary

mutualFundsAnalysis
├── overallAnalysis                  Portfolio-level summary
├── errorFlags                       Data processing issues
├── mutualFundWiseAnalysis           Per-fund scheme analysis
├── accountWiseFundAnalysis          Per-folio/account breakdown
├── marketCapBasedAnalysis           Portfolio distribution by market cap
├── equityOnlyMarketCapBasedAnalysis Equity-only market cap distribution
├── sectorBasedAnalysis              Portfolio distribution by sector
├── groupedFundsWorthData            Historical portfolio worth
├── benchmarkComparisons             Benchmark index comparisons
├── topSectors                       Top 5 sectors by contribution
└── topHoldings                      Top holdings (ISIN level)

overallAnalysis
├── totalPortfolioValue          Current NAV-based value of entire MF portfolio (INR)
├── totalInvestedAmount          Total invested amount across all funds (INR)
├── profitAmount                 Total unrealised P&L (INR)
├── absolutePercentageReturn     Overall return percentage
├── xirr                         Extended Internal Rate of Return for the portfolio
├── oneDayReturn                 Portfolio NAV change % in the last trading day
├── costBasisIncomplete          True if purchase cost data is missing for any fund
│
├── portfolioConsolidatedAnalysis[]  Aggregated stock-level holdings across all funds
│   ├── name                     Company name
│   ├── isin                     Company ISIN
│   ├── percentageContribution   % share of total portfolio
│   ├── totalPortfolioAmount     Value of this company's stocks across all funds (INR)
│   ├── assetClass               Asset class (Equity, Debt, Others)
│   └── assetSubClass            Sub-class (Domestic Equities, International Equities, etc.)
│
├── accountDetails[]             Folio / account holder profiles
│   ├── name, dob, mobile, nominee, landline, address, email, pan
│   ├── dematId                  Demat account identifier
│   ├── folioNo                  Folio number with the AMC
│   ├── kycCompliance            KYC status
│   ├── ckycCompliance           CKYC status
│   ├── linkReferenceNumber      Reference linking account to data provider
│   └── dataFetchTimeStamp       When this account's data was fetched (ISO-8601)
│
├── folioDetails[]               Summary per folio number
│   ├── folioNo                  Folio number
│   ├── linkedAccRef             Internal account reference
│   ├── totalFolioValue          Current value of this folio (INR)
│   ├── totalInvestedAmount      Amount invested under this folio (INR)
│   └── dematId                  Demat account identifier (empty if non-demat folio)
│
├── dematDetails[]               Summary per demat account (same structure as folioDetails)
│
├── monthlyPortfolioReturn       Map of YYYY-MM → monthly return % for the portfolio
│   └── "YYYY-MM": number
│
├── riskDistribution             Portfolio allocation by risk level (%)
│   ├── HIGH                     % in high-risk funds
│   ├── MEDIUM                   % in medium-risk funds
│   └── LOW                      % in low-risk funds
│
├── overallMutualFundAnalysis    Aggregate risk-adjusted metrics
│   ├── avgExpenseRatio          Weighted-average annual expense ratio (%)
│   ├── creditQuality            Weighted debt credit quality score (0–100)
│   ├── sharpeRatio              Portfolio Sharpe ratio
│   ├── beta                     Portfolio beta relative to benchmark
│   └── sortinoRatio             Portfolio Sortino ratio
│
└── amcLevelAumAnalysis[]        AUM breakdown by AMC
    ├── amc                      AMC name
    └── aum                      Assets under management in this AMC (INR)

errorFlags   [ ]   List of data processing issues or validation errors for the portfolio

mutualFundWiseAnalysis[]
├── isin                         Fund scheme ISIN
├── amcName                      Asset Management Company name
├── fundName                     Full scheme name
│
├── accountDetails[]             Folio / account details for this fund
│   ├── folioNo                  Folio number
│   ├── linkedAccRef             Internal account reference
│   └── dematId                  Demat account identifier
│
├── — Valuation —
├── totalInvestedAmount          Amount invested in this fund (INR)
├── totalPortfolioValue          Current NAV-based value (INR)
├── nav                          Current Net Asset Value per unit (INR)
├── units                        Units held
├── profitAmount                 Unrealised P&L (INR)
├── absolutePercentageReturn     Return percentage (present when cost basis available)
├── xirr                         XIRR for this fund
├── cagr                         Compound Annual Growth Rate (%)
├── oneDayReturn                 NAV change % in the last trading day
├── costBasisIncomplete          True if purchase cost data is unavailable
│
├── — Risk metrics —
├── color                        Risk label (Very High, High, Moderately High, Moderate, Low, Very Low)
├── beta                         Fund beta relative to benchmark
├── sharpeRatio                  Sharpe ratio
├── sortinoRatio                 Sortino ratio
├── creditQuality                Debt credit quality score (present for debt/hybrid funds)
├── expenseRatio                 Annual expense ratio (%)
├── investmentMode               How the fund was invested (LUMPSUM, SIP, etc.)
│
├── — Fund classification —
├── marketCapitalizationType     Fund's primary market-cap focus (MULTI_CAP, LARGE_CAP, etc.)
├── fundType                     Broad fund type (Equity, Debt, Hybrid, etc.)
├── schemeCategory               SEBI scheme category (Flexi Cap Fund, Index Funds, etc.)
├── schemeSubCategory            More specific classification within the category
│
├── portfolioDistributionAnalysis[]  Underlying stock/security holdings of this fund
│   ├── companyName              Company name
│   ├── isin                     Company ISIN
│   ├── finCode                  Internal financial code for the company
│   ├── marketCap                Company market capitalisation (INR)
│   ├── percentageContribution   % of fund NAV in this security
│   ├── sector                   Industry sector
│   ├── peRatio                  Price-to-Earnings ratio
│   ├── marketCapitalizationType Company size classification
│   ├── assetClass               Asset class (Equity, Others)
│   ├── assetSubClass            Sub-class (Domestic Equities, Certificate of Deposit, etc.)
│   ├── invDate                  Date this security was added to the fund's portfolio
│   └── invEndDate               Date this security was removed (same as invDate for snapshot)
│
├── marketCapBasedDistributionAnalysis    Fund allocation by company size (% of fund)
│   ├── largeCap                 % in large-cap securities
│   ├── midCap                   % in mid-cap securities
│   ├── smallCap                 % in small-cap securities
│   └── other                    % in other / unclassified securities
│
├── equityOnlyMarketCapBasedDistributionAnalysis  Same as above, equity holdings only
│   ├── largeCap, midCap, smallCap, other
│
├── transactions[]               Buy/sell/dividend history for this fund
│   ├── amount                   Transaction amount (INR)
│   ├── units                    Units transacted
│   ├── nav                      NAV at the time of transaction
│   ├── transactionDateTime[]    [year, month, day, hour, minute]
│   ├── transactionType          BUY | SELL | DIVIDEND | SWITCH_IN | SWITCH_OUT
│   ├── isin                     Fund ISIN
│   ├── amfiCode                 AMFI code for the scheme
│   ├── txnId                    Unique transaction identifier
│   ├── narration                Transaction description
│   ├── mode                     Purchase mode (ONETIME, SIP, etc.)
│   ├── schemeCode               Short internal scheme code
│   ├── schemePlan               Scheme plan description
│   ├── amc                      AMC name for this transaction
│   ├── registrar                R&T Agent (CAMS, KFintech, etc.)
│   └── isinDescription          ISIN description text
│
└── errorFlags[]                 Data issues for this specific fund

accountWiseFundAnalysis[]
├── fundWiseAnalysis[]           Funds held under this account
│   ├── isin                     Fund ISIN
│   ├── amcName                  AMC name
│   ├── mutualFundName           Full scheme name
│   ├── accountDetails[]
│   │   ├── folioNo              Folio number
│   │   └── linkedAccRef         Internal account reference
│   ├── totalPortfolioValue      Current value (INR)
│   ├── totalInvestedAmount      Invested amount (INR)
│   ├── nav                      Current NAV (INR)
│   ├── units                    Units held
│   ├── folioNo                  Folio number
│   ├── xirr                     XIRR for this fund in this account
│   ├── oneDayReturn             NAV change % in the last trading day
│   ├── schemeTypes              Scheme type label (Equity(G), Index Fund, etc.)
│   └── tradingSymbol            Exchange trading symbol (if applicable)
├── dataFetchTimeStamp           When this account's data was fetched (ISO-8601)
└── meta                         Account-level totals
    ├── totalInvestedAmount      Total invested across all funds in this account (INR)
    └── totalPortfolioValue      Total current value in this account (INR)

marketCapBasedAnalysis
├── LARGE_CAP
│   ├── percentageContribution   % of portfolio in large-cap funds
│   └── portfolioValue           Current value of large-cap holdings (INR)
├── MID_CAP                      Same fields as LARGE_CAP
├── SMALL_CAP                    Same fields as LARGE_CAP
└── OTHER                        Same fields — covers debt, gold, international, etc.

sectorBasedAnalysis
└── [SECTOR_NAME]
    └── percentageContribution   % of total portfolio in this sector

groupedFundsWorthData
├── fundsWorth[]                 Ordered array of monthly portfolio values (INR)
└── monthlyFundsWorth            Map of YYYY-MM → portfolio value (INR)
    └── "YYYY-MM": number

benchmarkComparisons[]
├── benchmarkName                Index name (NIFTY, NIFTY500, NIFTYMIDCAP, BANKNIFTY, etc.)
├── currentBenchmarkValue        Current index-equivalent portfolio value (INR)
├── monthlyBenchmarkWorth        Map of YYYY-MM → benchmark-equivalent value (INR)
│   └── "YYYY-MM": number
└── monthlyBenchmarkReturn       Map of YYYY-MM → benchmark monthly return %
    └── "YYYY-MM": number

topSectors[]
├── sector                       Sector name
└── percentageContribution       % of total portfolio in this sector

topHoldings[]
├── isin                         Security ISIN
├── totalPortfolioValue          Current value of this holding (INR)
├── totalInvestedAmount          Amount invested (INR)
├── profitAmount                 Unrealised P&L (INR)
├── absolutePercentageReturn     Return percentage
├── nav                          Current NAV (INR)
└── units                        Units held