Equities Data Dictionary

equitiesAnalysis
├── overallAnalysis             Portfolio-level summary
├── errorFlags                  Data processing issues
├── stockWiseAnalysis           Per-stock analysis
├── accountWiseEquityAnalysis   Per-demat-account breakdown
├── marketCapBasedAnalysis      Portfolio distribution by market cap
├── sectorBasedAnalysis         Portfolio distribution by sector
└── groupedEquitiesWorthData    Historical portfolio worth

overallAnalysis
├── totalPortfolioValue        Current market value of the entire equity portfolio (INR)
├── totalInvestedAmount        Total amount invested across all stocks (cost basis, INR)
├── profitAmount               Total profit or loss (portfolio value − invested amount, INR)
├── absolutePercentageReturn   Overall return as a percentage
├── xirr                       Extended Internal Rate of Return for the portfolio
├── oneDayReturn               Portfolio change % in the last trading day
├── costBasisIncomplete        True if cost basis data is missing for one or more holdings
└── accountDetails             List of demat accounts contributing to the portfolio
    ├── name                   Account holder name
    ├── dob                    Date of birth (yyyy-MM-dd)
    ├── mobile                 Mobile number
    ├── nominee                Nominee registration status
    ├── dematId                Demat account identifier
    ├── address                Postal address
    ├── email                  Email address
    ├── pan                    PAN number
    ├── linkReferenceNumber    Reference number linking account to data provider
    └── dataFetchTimestamp     When this account's data was last fetched (ISO-8601)

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

stockWiseAnalysis[]
├── companyName                Full company name
├── isin                       International Securities Identification Number
├── sector                     Industry sector (Capital Goods, IT, Chemicals, etc.)
├── marketCapitalizationType   LARGE_CAP | MID_CAP | SMALL_CAP
├── currentlyInvested          Whether the stock is currently held (true / false)
├── units                      Number of shares held
├── currentStockPrice          Current market price per share (INR)
├── totalPortfolioValue        Current market value of this holding (INR)
├── totalInvestedAmount        Amount invested in this stock (INR; 0 if cost basis missing)
├── costBasisIncomplete        True if purchase cost data is unavailable
├── percentageContribution     This stock's share of the total portfolio value (%)
│
├── — Returns (present when currentlyInvested = true or cost basis available) —
├── absolutePercentageReturn   Return percentage for this stock
├── profitAmount               Profit or loss on this holding (INR)
├── xirr                       XIRR for this holding
│
├── — Market data —
├── oneDayReturn               Price change % in the last trading day
├── lastDateOfStockPriceUpdate Date of most recent price update (yyyy-MM-dd)
├── last52WeeksHighPrice       Highest price in the past 52 weeks (INR)
├── last52WeeksLowPrice        Lowest price in the past 52 weeks (INR)
├── marketCap                  Total market capitalisation of the company (INR)
│
├── — Valuation ratios —
├── peRatio                    Price-to-Earnings ratio
├── pbRatio                    Price-to-Book ratio (alias priceToBookValueRatio)
├── priceToBookValueRatio      Price divided by book value per share
├── trailing12MonthsPERatio    Trailing 12-month P/E ratio
├── trailing12MonthsEPS        Trailing 12-month Earnings Per Share (INR)
├── divYield                   Dividend yield (annual dividend / current price, %)
├── bookValue                  Book value per share (INR)
├── faceValue                  Face (par) value per share (INR)
├── roe                        Return on Equity (net income / shareholder equity)
├── debtToEquity               Debt-to-Equity ratio
├── industryPe                 Industry-average P/E ratio for this stock's sector
│
├── accountDetails[]           Demat accounts holding this stock
│   └── dematId                Demat account identifier
└── errorFlags[]               Data issues for this specific stock

accountWiseEquityAnalysis[]
├── stockWiseAnalysis[]        Same structure as main stockWiseAnalysis (account-scoped)
├── accountDetails
│   ├── linkReferenceNumber    Unique reference linking account to data provider
│   └── bank                   Depository / bank name (e.g., Central Depository Services Limited)
└── dataFetchTimeStamp         When data was fetched for this account (ISO-8601)

marketCapBasedAnalysis
├── LARGE_CAP
│   ├── percentageContribution   % of total portfolio in large-cap stocks
│   ├── portfolioValue           Current market value of large-cap holdings (INR)
│   ├── investedAmount           Amount invested in large-cap stocks (INR)
│   ├── profitAmount             P&L on large-cap holdings (INR)
│   └── absolutePercentageReturn Return % on large-cap holdings
├── MID_CAP                      Same fields as LARGE_CAP
└── SMALL_CAP                    Same fields as LARGE_CAP

sectorBasedAnalysis
└── [SECTOR_NAME]               One key per sector present in the portfolio
    ├── sector                  Sector name
    ├── percentageContribution  % of total portfolio in this sector
    ├── portfolioValue          Current market value of sector holdings (INR)
    ├── investedAmount          Amount invested in this sector (INR)
    ├── profitAmount            P&L on sector holdings (INR)
    ├── absolutePercentageReturn Return % on sector holdings
    └── peRatio                 Weighted-average P/E ratio for this sector

groupedEquitiesWorthData
├── equitiesWorth[]            Ordered array of monthly portfolio values (INR)
└── monthlyEquitiesWorth       Map of YYYY-MM → portfolio value (INR)
    └── "YYYY-MM": number