Tradewise P&L
Tradewise trading activity provides you with an absolute value of profits made. Brokers can use tradewise trading activity to calculate Tax P&L for investors and traders.
Overview
This API calculates Tax P&L by taking in the tradewise trading activity
Problem
- Brokers have to provide accurate Realized & Unrealized P&L.
- Brokers must apply tax rules to accurately calculate Pre-Tax & Post-Tax returns on investments.
- The tax landscape is ever-changing with announcements from regulators, tax departments & finance ministry.
- Investors & Traders have to furnish accurate P&L, Holdings, and Turnover in their tax returns as per the tax law.
- Brokers are unable to provide accurate tax computations.
Solution
- API to calculate Tax P&L in real-time.
- API covers tax calculation for corporate actions such as dividends, buybacks, etc.
- Allows Brokers to visualize Tax P&L for their users.
- Tax P&L report can be generated using tradewise or scripwise method.
Endpoint
| HTTP Method | Endpoint |
|---|---|
| POST | /calculators/income-tax/tax-pnl/tradewise |
Request
Follow the below guidelines to pass tradewise trading activty to calculate Tradewise Tax P&L.
Query Parameters
| Param | Type | Description | Example |
|---|---|---|---|
| report | string | Possible values: tradewise, scripwise | tradewise |
Body
Equity Trade
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of equity share |
| quantity | number | Yes | Trading quantity |
| buy_date | string | Yes | Date of purchase |
| buy_average | number | Yes | Average buy price across all trades |
| sell_date | string | Yes | Date of Sell |
| sell_average | number | Yes | Average sell price across all trades |
| fmv | number | No | High stock price on 31/01/2018 |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax |
| stamp_duty | number | No | Stamp duty paid on transfer of shares |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of shares |
| corporate_action | string | No | Corporate Action. Possible values: BUY_BACK, DIVIDEND |
Mutual Fund Trade
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| scheme_type | string | Yes | Scheme type, possible valuesEquity, Debt, Other |
| symbol | string | Yes | Symbol or description of equity share |
| quantity | number | Yes | Trading quantity |
| buy_date | string | Yes | Date of purchase |
| buy_average | number | Yes | Average buy price across all trades |
| sell_date | string | Yes | Date of Sell |
| sell_average | number | Yes | Average sell price across all trades |
| fmv | number | No | High stock price on 31/01/2018 |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax |
| stamp_duty | number | No | Stamp duty paid on transfer of shares |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of shares |
| corporate_action | string | No | Corporate Action. Possible values: BUY_BACK, DIVIDEND |
Futures and Options Trade
| Param | Type | Required | Description |
|---|---|---|---|
| symbol | string | Yes | Symbol or description of equity share |
| type | string | Yes | Type, possible valuesFutures, Options |
| quantity | number | Yes | Trading quantity |
| buy_average | number | Yes | Average buy price across all trades |
| sell_average | number | Yes | Average sell price across all trades |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax |
| stamp_duty | number | No | Stamp duty paid on transfer of shares |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of shares |
Corporate Actions
The enumeration is explained below:
| Corporate Action | ENUM |
|---|---|
| Amalgamation | AMALGAMATION |
| Bonus Issue | BONUS_ISSUE |
| Buy Back of Shares | BUY_BACK |
| Consolidation of Shares | CONSOLIDATION |
| Dividend | DIVIDEND |
| Dividend on Preference Shares | DIVIDEND |
| Income Distribution (InvIT) | INCOME_DISTRIBUTION_INVIT |
| Income Distribution RITES | RITES |
| InvIT - Return of Capital | RETURN_OF_CAPITAL_INVIT |
| Preferential Issue of shares | PREFERENTIAL_ISSUE |
| Reduction of Capital | REDUCTION_OF_CAPITAL |
| Right Issue of Equity Shares | RIGHT_ISSUE |
| Scheme of Arrangement | SCHEME_OF_ARRANGEMENT |
| Spin Off | SPIN_OFF |
| Stock Split | STOCK_SPLIT |
| Voluntary Delisting of Shares | DELISTING |
Sample CURL Request
curl --request POST \
--url https://api.sandbox.co.in/calculators/income-tax/securities/tax-pnl/tradewise?report=tradewise \
--header 'Authorization: xxxxxxxxxxxxxxxxxxxxxxx' \
--header 'accept: application/json' \
--header 'content-type: application/json' \
--header 'x-api-key: xxxxxxxxxxxxxxxxxxxxx' \
--header 'x-api-version: 1.0' \
--data '
{
"sheets": [
{
"name": "Equity",
"blocks": [
{
"name": "Tradewise P&L",
"header": [
"isin",
"symbol",
"quantity",
"buy_date",
"buy_average",
"sell_date",
"sell_average",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"corporate_action"
],
"rows": [
[
"INE079A01024",
"AMBUJACEM",
5,
1651326845000,
372.2,
1653918845000,
369.4,
null,
0,
0,
0.78,
0.53,
3.72,
0,
0,
0,
0,
0,
null
]
]
}
]
},
{
"name": "Mutual Funds",
"blocks": [
{
"name": "Tradewise P&L",
"header": [
"isin",
"scheme_type",
"symbol",
"quantity",
"buy_date",
"buy_average",
"sell_date",
"sell_average",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_charges",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"corporate_actions"
],
"rows": []
}
]
},
{
"name": "Futures & Options",
"blocks": [
{
"name": "Tradewise P&L",
"header": [
"symbol",
"type",
"quantity",
"buy_average",
"sell_average",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": []
}
]
}
]
}
'
Test Environment Not Available
Response
The API responds back in a sheet structure. An example response is shown below.
{
"transaction_id": "6ed33ff8-fee0-4bec-87fd-d07f373763c1",
"code": 200,
"data": {
"sheets": [
{
"blocks": [
{
"name": "Tradewise P&L",
"header": [
"isin",
"symbol",
"quantity",
"buy_date",
"buy_average",
"sell_date",
"sell_average",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_charges",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"corporate_actions",
"holding_period",
"turnover",
"realized_pnl"
],
"rows": [
[
"INE079A01024",
"AMBUJACEM",
5,
1651326845000,
372.2,
1653918845000,
369.4,
null,
0,
0,
0.78,
0.53,
3.72,
0,
0,
0,
0,
0,
null,
"Short Term",
1847,
-14
]
]
},
{
"name": "Capital Gains Summary",
"items": [
[
"ltcg",
0
],
[
"gross_ltcg",
0
],
[
"transfer_expenses_ltcg",
0
],
[
"stcg",
-15.31
],
[
"transfer_expenses_stcg",
1.31
],
[
"gross_stcg",
-14
]
]
},
{
"name": "Business Income Summary",
"items": [
[
"turnover",
0
],
[
"net_pnl",
0
],
[
"gross_pnl",
0
],
[
"transfer_expenses",
0
],
[
"brokerage",
0
],
[
"clearing_charges",
0
],
[
"exchange_transaction_tax",
0
],
[
"sebi_turnover_fees",
0
],
[
"stt",
0
],
[
"stamp_duty",
0
],
[
"sgst",
0
],
[
"cgst",
0
],
[
"igst",
0
],
[
"other_transfer_expenses",
0
]
]
},
{
"name": "P&L Summary",
"items": [
[
"ltcg",
0
],
[
"stcg",
-15.31
],
[
"net_pnl",
0
],
[
"turnover",
0
]
]
}
],
"name": "Equity"
},
{
"blocks": [
{
"name": "Tradewise P&L",
"header": [
"isin",
"scheme_type",
"symbol",
"quantity",
"buy_date",
"buy_average",
"sell_date",
"sell_average",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_charges",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"corporate_actions",
"holding_period",
"realized_pnl"
],
"rows": []
},
{
"name": "Capital Gains Summary",
"items": [
[
"equity_ltcg",
0
],
[
"transfer_expenses_equity_ltcg",
0
],
[
"gross_equity_ltcg",
0
],
[
"debt_ltcg",
0
],
[
"transfer_expenses_debt_ltcg",
0
],
[
"gross_debt_ltcg",
0
],
[
"other_ltcg",
0
],
[
"transfer_expenses_other_ltcg",
0
],
[
"gross_other_ltcg",
0
],
[
"ltcg",
0
],
[
"transfer_expenses_ltcg",
0
],
[
"gross_ltcg",
0
],
[
"equity_stcg",
0
],
[
"transfer_expenses_equity_stcg",
0
],
[
"gross_equity_stcg",
0
],
[
"debt_stcg",
0
],
[
"transfer_expenses_debt_stcg",
0
],
[
"gross_debt_stcg",
0
],
[
"other_stcg",
0
],
[
"transfer_expenses_other_stcg",
0
],
[
"gross_other_stcg",
0
],
[
"stcg",
0
],
[
"transfer_expenses_stcg",
0
],
[
"gross_stcg",
0
]
]
},
{
"name": "P&L Summary",
"items": [
[
"ltcg",
0
],
[
"stcg",
0
]
]
}
],
"name": "Mutual Funds"
},
{
"blocks": [
{
"name": "Tradewise P&L",
"header": [
"symbol",
"type",
"quantity",
"buy_average",
"sell_average",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_charges",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"turnover",
"realized_pnl"
],
"rows": []
},
{
"name": "Business Income Summary",
"items": [
[
"turnover",
0
],
[
"net_pnl",
0
],
[
"gross_pnl",
0
],
[
"transfer_expenses",
0
],
[
"brokerage",
0
],
[
"clearing_charges",
0
],
[
"exchange_transaction_tax",
0
],
[
"sebi_turnover_fees",
0
],
[
"stt",
0
],
[
"stamp_duty",
0
],
[
"sgst",
0
],
[
"cgst",
0
],
[
"igst",
0
],
[
"other_transfer_expenses",
0
]
]
},
{
"name": "P&L Summary",
"items": [
[
"net_pnl",
0
],
[
"turnover",
0
]
]
}
],
"name": "Futures & Options"
}
],
"name": "Tradewise Tax P&L"
},
"timestamp": 1672062905441
}
Response Caching
Response caching is not available for this API. Learn more about our response caching mechanism here
Wallet Charge
Since the Tax P&L Calculator from Tradewise API is not a Paid API, no wallet charge will take place.
Versioning
This API is currently in major version 1.0. Refer to our versioning policies here
Updated 3 months ago