Skip to main content
Purpose: Contains comprehensive equity portfolio analysis including overall performance, stock-wise breakdown, account-level analysis, and market distribution data for individual stocks and equity investments.

Data Structure

fiAnalysis
├── overallAnalysis
│   ├── totalPortfolioValue - Total current market value of entire equity portfolio
│   ├── totalInvestedAmount - Total money invested across all stocks
│   ├── absolutePercentageReturn - Overall return percentage across entire equity portfolio
│   ├── profitAmount - Total profit or loss amount in rupees from all stock investments
│   ├── xirr - Extended Internal Rate of Return for entire portfolio (time-weighted return)
│   └── accountDetails (Information about investment accounts holding the stocks)
│       ├── name - Account holder's name
│       ├── dob - Date of birth of account holder
│       ├── mobile - Mobile phone number
│       ├── nominee - Nominee registration status (REGISTERED, etc.)
│       ├── dematId - Dematerialized account identifier (unique trading account number)
│       ├── folioNo - Folio number (if applicable)
│       ├── landline - Landline phone number
│       ├── address - Complete postal address of account holder
│       ├── email - Email address
│       ├── pan - Permanent Account Number (tax identifier)
│       ├── kycCompliance - Know Your Customer compliance status
│       ├── ckycCompliance - Central Know Your Customer compliance status
│       ├── linkReferenceNumber - Unique reference number linking account to data provider
│       └── dataFetchTimestamp - When account data was last fetched

├── stockWiseAnalysis (Detailed analysis for each individual stock holding)
│   ├── companyName - Full name of the company whose stock is held
│   ├── isin - International Securities Identification Number (unique stock identifier)
│   ├── accountDetails (Account information for this specific stock holding)
│   │   └── dematId - Dematerialized account where this stock is held
│   ├── benchmarkIndex - Reference market index for performance comparison
│   ├── scripcode - Stock script code used in exchanges
│   ├── symbol - Stock trading symbol (ticker symbol)
│   ├── xirr - Extended Internal Rate of Return for this specific stock
│   ├── totalInvestedAmount - Total money invested in this stock
│   ├── totalPortfolioValue - Current market value of this stock holding
│   ├── avgPurchasingPrice - Average price at which stock was purchased
│   ├── last52WeeksHighPrice - Highest stock price in the last 52 weeks
│   ├── last52WeeksLowPrice - Lowest stock price in the last 52 weeks
│   ├── priceToBookValueRatio - Price to Book Value ratio (valuation metric)
│   ├── marketCap - Total market capitalization of the company
│   ├── lastDateOfStockPriceUpdate - Last date when stock price was updated
│   ├── percentageContribution - What percentage this stock represents in total portfolio
│   ├── absolutePercentageReturn - Return percentage for this specific stock
│   ├── profitAmount - Profit or loss from this stock investment
│   ├── sector - Industry sector the company belongs to (Banking, IT, Pharma, etc.)
│   ├── peRatio - Price to Earnings ratio (company valuation metric)
│   ├── marketCapitalizationType - Company size classification (LARGE_CAP, MID_CAP, SMALL_CAP)
│   ├── units - Number of stock shares/units owned
│   ├── currentStockPrice - Current market price per share
│   ├── divYield - Dividend yield percentage (annual dividend as % of stock price)
│   ├── bookValue - Book value per share of the company
│   ├── faceValue - Face value (par value) of each share
│   ├── errorFlags - Any data processing issues, warnings, or validation errors
│   ├── currentlyInvested - Whether currently holding this stock (true/false)
│   ├── monthlyWorth - Month-by-month stock value tracking showing investment performance over time
│   │   └── YYYY-MM - Monthly portfolio value for this stock (e.g., "2024-01": 150000.00)
│   ├── transactions (Complete history of buy/sell activities for this stock)
│   │   ├── isin - International Securities Identification Number of the stock
│   │   ├── isinDescription - Detailed description of the security
│   │   ├── companyName - Full company name for this transaction
│   │   ├── rate - Price per share at which transaction occurred
│   │   ├── units - Number of shares bought/sold in this transaction
│   │   ├── total - Total transaction amount (may be null)
│   │   ├── transactionType - Type of transaction (BUY, SELL)
│   │   ├── txnId - Unique transaction identifier
│   │   ├── narration - Transaction description including broker details
│   │   ├── equityCategory - Category of equity (EQUITY, etc.)
│   │   └── transactionDateTime - Date and time when transaction occurred (as array: [year, month, day, hour, minute])
│   ├── dataFetchTimeStamp - When stock data was last fetched from source
│   ├── analysisStartDate - Start date for analysis period (as array: [year, month, day])
│   └── analysisEndDate - End date for analysis period (as array: [year, month, day])

├── accountWiseEquityAnalysis (Equity analysis broken down by individual investment accounts)
│   ├── stockWiseAnalysis (Same structure as main stockWiseAnalysis but account-specific)
│   ├── overallAnalysisStartDate - Start date for this account's investment analysis period
│   └── overallAnalysisEndDate - End date for this account's investment analysis period

├── marketCapBasedAnalysis (Overall portfolio distribution by company sizes)
│   ├── OTHER - Total percentage in other category investments
│   ├── SMALL_CAP - Total percentage invested in small-cap company stocks
│   ├── LARGE_CAP - Total percentage invested in large-cap company stocks
│   └── MID_CAP - Total percentage invested in mid-cap company stocks

└── sectorBasedAnalysis (Overall portfolio distribution by industry sectors)
    └── [SECTOR_NAME] - Percentage allocated to each industry sector (Banking, IT, Healthcare, etc.)

Detailed Field Explanations

Financial Metrics

  • totalInvestedAmount: Original money put into stocks (cost basis)
  • totalPortfolioValue: Current market value (what stocks are worth today)
  • profitAmount: Difference between current value and invested amount
  • absolutePercentageReturn: (Current Value - Invested Amount) / Invested Amount * 100
  • xirr: Time-weighted return accounting for cash flows and dates
  • avgPurchasingPrice: Weighted average price paid for all shares of a stock
  • percentageContribution: This stock’s value as percentage of total portfolio

Stock Valuation Metrics

  • peRatio: Current stock price divided by earnings per share
  • priceToBookValueRatio: Current stock price divided by book value per share
  • marketCap: Total company value (stock price * total shares outstanding)
  • divYield: Annual dividend per share divided by current stock price
  • bookValue: Company’s net worth per share based on accounting records
  • faceValue: Original nominal value assigned to shares

Market Data

  • last52WeeksHighPrice: Peak stock price in the past year
  • last52WeeksLowPrice: Lowest stock price in the past year
  • currentStockPrice: Most recent trading price
  • lastDateOfStockPriceUpdate: When price data was last refreshed

Account Information

  • dematId: Unique identifier for dematerialized trading account
  • pan: Permanent Account Number (Indian tax identification)
  • kycCompliance: Know Your Customer verification status
  • linkReferenceNumber: Connection ID between account and data provider

Classification

marketCapitalizationType:
  • LARGE_CAP: Companies with market cap > ₹20,000 crores
  • MID_CAP: Companies with market cap ₹5,000-20,000 crores
  • SMALL_CAP: Companies with market cap < ₹5,000 crores
sector: Industry classification (Banking, IT, Pharmaceutical, FMCG, etc.)

Usage Notes

  • Each stock in stockWiseAnalysis represents a separate company stock holding
  • accountWiseEquityAnalysis provides account-level breakdowns for multi-account portfolios
  • marketCapBasedAnalysis helps understand portfolio risk distribution across company sizes
  • sectorBasedAnalysis shows diversification across different industries
  • monthlyWorth tracks historical performance month by month
  • All monetary values are in Indian Rupees (INR)
  • Percentage values are decimal numbers (e.g., 16.43 means 16.43%)
  • Dates are in YYYY-MM-DD format or specific timestamp formats
  • currentlyInvested flag indicates active vs. sold positions