Skip to Content
API ReferenceReportsRealised P&L Report

Realised P&L Report

This API allows you to fetch the realised profit and loss on your closed positions for a date range.

USE CASE

Check the profit or loss locked in on closed positions, symbol by symbol, with gross P&L, charges and net P&L.

Details

  • Fetches all realised profit & loss for a specified date range. If no date range is provided, it defaults to the current financial year.
  • Filter symbol by ISIN for equities and mutual funds, for example INE000A01020, and by trading symbol for derivatives, for example BSE:SENSEX2640976500CE.
  • Only positions that are fully closed are counted in realized_pnl. For open positions use Get Positions.
  • Send from_date and to_date as YYYY-MM-DD. Results are paged: page_size defaults to 100 and page_no to 1.
  • segment_type is 0 all, 1 equity, 2 equity derivatives, 3 mutual funds, 4 currency derivatives and 5 commodity derivatives. exchange_type is 0 all, 1 NSE, 2 BSE and 3 MCX.
  • Rate limits differ between the Standard and Prime plans. See Plans & rate limits.

Request Attributes - For each realised profit & loss

AttributeData TypeDescription
symbolstring
  • For equities and mutual funds, the ISIN is required.Example : INE000A01020
  • For derivatives, the trading symbol is required. Example : BSE:SENSEX2640976500CE
page_sizestringNumber of records to fetch on single response (default is 100)
page_nostringThe page number to fetch (default is 1)
from_datestringThe start date for fetching realised profit & loss history in “YYYY-MM-DD” format (default is the start of the current financial year)
to_datestringThe end date for fetching realised profit & loss history in “YYYY-MM-DD” format (default is the current date)
segment_typestring
  • 0 → Includes all Segments [default]
  • 1 → Includes only Equity
  • 2 → Includes only Equity Derivatives
  • 3 → Includes Mutal Funds
  • 4 → Includes only Currency Derivatives
  • 5 → Includes only Commodity Derivatives
exchange_typestring
  • 0 → Includes all Exchanges [default]
  • 1 → Includes only NSE
  • 2 → Includes only BSE
  • 3 → Includes only MCX

Response data attributes - For each realised profit & loss

AttributeData TypeDescription
exch_idintThe exchange ID
seg_idintThe segment ID
segment_namestringMarket category where the security was traded or invested in.
exchange_namestringThe name of the exchange
symbol_namestringName of the stock, mutual fund, or F&O contract traded.
realized_pnlfloatProfit or loss from positions that are fully closed.
buy_qtyintTotal quantity or units bought.
buy_ratefloatPrice per unit, share, or contract at which it was bought.
sell_qtyintTotal quantity or units sold.
sell_ratefloatPrice per unit, share, or contract at which it was sold.
is_symbol_activebooleanWhether the symbol is active or not

Response summary attributes - For the summary of the realised profit & loss

AttributeData TypeDescription
gross_pnlfloatThe gross profit & loss of the trade
net_pnlfloatThe net profit & loss of the trade
chargesfloatThe charges of the trade
Last updated on