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
symbolby ISIN for equities and mutual funds, for exampleINE000A01020, and by trading symbol for derivatives, for exampleBSE:SENSEX2640976500CE. - Only positions that are fully closed are counted in
realized_pnl. For open positions use Get Positions. - Send
from_dateandto_dateasYYYY-MM-DD. Results are paged:page_sizedefaults to 100 andpage_noto 1. segment_typeis 0 all, 1 equity, 2 equity derivatives, 3 mutual funds, 4 currency derivatives and 5 commodity derivatives.exchange_typeis 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
| Attribute | Data Type | Description |
|---|---|---|
symbol | string |
|
page_size | string | Number of records to fetch on single response (default is 100) |
page_no | string | The page number to fetch (default is 1) |
from_date | string | The start date for fetching realised profit & loss history in “YYYY-MM-DD” format (default is the start of the current financial year) |
to_date | string | The end date for fetching realised profit & loss history in “YYYY-MM-DD” format (default is the current date) |
segment_type | string |
|
exchange_type | string |
|
Response data attributes - For each realised profit & loss
| Attribute | Data Type | Description |
|---|---|---|
exch_id | int | The exchange ID |
seg_id | int | The segment ID |
segment_name | string | Market category where the security was traded or invested in. |
exchange_name | string | The name of the exchange |
symbol_name | string | Name of the stock, mutual fund, or F&O contract traded. |
realized_pnl | float | Profit or loss from positions that are fully closed. |
buy_qty | int | Total quantity or units bought. |
buy_rate | float | Price per unit, share, or contract at which it was bought. |
sell_qty | int | Total quantity or units sold. |
sell_rate | float | Price per unit, share, or contract at which it was sold. |
is_symbol_active | boolean | Whether the symbol is active or not |
Response summary attributes - For the summary of the realised profit & loss
| Attribute | Data Type | Description |
|---|---|---|
gross_pnl | float | The gross profit & loss of the trade |
net_pnl | float | The net profit & loss of the trade |
charges | float | The charges of the trade |
Last updated on