Calculate Tax P&L from Tradebook
Tradebook provides you with all the trades that have been executed by an investor or trader. Brokers can use Tradebook to calculate Tax P&L using APIs.
Overview
This API calculates Tax P&L by taking in the tradebook data.
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 | it-calculator/securities/tax-pnl/tradebook |
Request
Follow the below guidelines to calculate Tradebook Tax P&L
Query Parameters
| Param | Type | Description | Example |
|---|---|---|---|
| report | string | Possible values: Tradewise, Scripwise | tradewise |
| from | number | From Date in Epoch milliseconds | 1667241000000 |
| to | number | To Date, in Epoch milliseconds | 1669746600000 |
Body
Equity Tradebook
The headers are explained below:
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of equity share |
| is_listed | boolean | Yes | is the equity share listed in public markets |
| is_stt_paid | boolean | Yes | was security transaction tax paid on this trade |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | The unit price of the equity share |
| transaction_type | string | Yes | Indicates whether the order is :buy Or sell, |
| fmv | number | No | Fare market value of the equity share as 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 | Refer to Corporate Action for possible values |
Mutual Fund Tradebook
The headers are explained below:
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | No | ISIN is the international security identification number |
| scheme_name | string | Yes | Symbol or name of mutual fund |
| scheme_type | string | Yes | Scheme type, possible valuesEquity, Debt, Other |
| is_listed | boolean | Yes | is the scheme listed in public markets |
| is_stt_paid | boolean | Yes | was security transaction tax paid on this trade |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | Transaction price |
| transaction_type | string | Yes | Indicates whether the order is :buy Or sell, |
| fmv | number | No | Fare market value of the mutual fund unit as 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 |
Futures and Options Trade
The headers are explained below:
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| contract_name | string | Yes | Name of contract |
| contract_type | string | Yes | Type of contract, possible valuesfuture Or option |
| asset_class | string | Yes | The asset class of the contract. Possible valuesequity, currency & commodity |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | Transaction price |
| transaction_type | string | Yes | Indicates whether the order is :buy Or sell, |
| 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 contract |
| 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 the contract |
Sample CURL Request
You can refer to the sample payload in workbook format
curl --request POST \
--url 'https: //api.sandbox.co.in/it-calculator/securities/tax-pnl/tradebook?report=Tradewise&from=1667241000000&to=1669746600000' \
--header 'Authorization: xxxxxxxxxxxxxx' \
--header 'accept: application/json' \
--header 'content-type: application/json' \
--header 'x-api-key: xxxxxxxxxxxxxx' \
--header 'x-api-version: 1.0' \
--data '
{
"@entity": "workbook",
"name": "tradebook_workbook",
"sheets": [
{
"name": "equity_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"name": "equity_tradebook_table",
"header": [
"trade_id",
"isin",
"symbol",
"is_listed",
"is_stt_paid",
"quantity",
"date",
"price",
"transaction_type",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"corporate_action"
],
"rows": [
[
"1",
"INE190B01019",
"INFY",
true,
false,
50,
1617135200000,
80,
"buy",
80,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"2",
"INE190B01019",
"INFY",
true,
false,
50,
1617195200000,
70,
"buy",
70,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"3",
"INE245A01021",
"TATAPOWER",
true,
false,
49.4698,
1617235200000,
75,
"buy",
75,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"4",
"INE423A01024",
"ADANIENT",
true,
false,
0.25,
1617321600000,
1000,
"buy",
1000,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"5",
"INE245A01021",
"TATAPOWER",
true,
false,
24.7349,
1620604800000,
90,
"sell",
90,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"7",
"INE190B01019",
"INFY",
true,
false,
40,
1617135209000,
100,
"sell",
100,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"8",
"INE245A01021",
"TATAPOWER",
true,
false,
24.7349,
1623369600000,
80,
"sell",
80,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"17",
"INE423A01024",
"ADANIENT",
true,
false,
0.2,
1637366400000,
1200,
"sell",
1200,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"18",
"INE190B01019",
"INFY",
true,
false,
15,
1638567500000,
250,
"sell",
250,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
]
]
}
]
},
{
"name": "futures_and_options_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"name": "futures_and_options_tradebook_table",
"header": [
"trade_id",
"contract_name",
"contract_type",
"asset_class",
"quantity",
"date",
"price",
"transaction_type",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": [
[
"12345a",
"CRUDE21APR14700CE",
"option",
"Commodity",
75,
1648771200,
363.1,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"54321a",
"USD21APR14700CE",
"option",
"Currency",
75,
1649548800,
363.15,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"54612a",
"FINNIFTY21MAYFUT",
"future",
"Equity",
40,
1649548800,
15700,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"15484a",
"NIFTY21JUN17500CE",
"option",
"Equity",
75,
1649548800,
4.55,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"456789a",
"NIFTY21JUN15800CE",
"option",
"Equity",
75,
1649548800,
168,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"678901a",
"NIFTY21JUN15800CE",
"option",
"Equity",
75,
1649548800,
175.55,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"789012a",
"CRUDE21APR14700CE",
"option",
"Commodity",
75,
1653436800,
194.9,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"890123a",
"USD21APR14700CE",
"option",
"Currency",
75,
1653436800,
194.9,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"123098a",
"FINNIFTY21MAYFUT",
"future",
"Equity",
40,
1653436800,
15685.9,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"345876a",
"NIFTY21JUN17500CE",
"option",
"Equity",
75,
1653436800,
4.7,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"333444a",
"NIFTY21JUN15800CE",
"option",
"Equity",
75,
1653436800,
168.65,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"888000a",
"NIFTY21JUN15800CE",
"option",
"Equity",
75,
1653436800,
174.25,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
},
{
"name": "mutual_fund_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"name": "mutual_fund_tradebook_table",
"header": [
"trade_id",
"isin",
"symbol",
"is_listed",
"is_stt_paid",
"quantity",
"date",
"price",
"transaction_type",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"corporate_action"
],
"rows": [
[
"15648a",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
true,
true,
250,
1622937600,
520,
"buy",
0,
0,
0,
0,
0,
75,
0,
0,
0,
0,
0
],
[
"15648a",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
true,
true,
150,
1628208000,
400,
"sell",
0,
0,
0,
0,
0,
42,
0,
0,
0,
0,
0
],
[
"65412a",
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
31.536,
1618876800,
99994.6642,
"buy",
0,
0,
0,
0,
0,
100,
0,
0,
0,
0,
0
],
[
"14712a",
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
30.739,
1618876800,
99996.0019,
"buy",
0,
0,
0,
0,
0,
98,
0,
0,
0,
0,
0
],
[
"15545a",
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
3.096,
1619740800,
9999.5181,
"buy",
0,
0,
0,
0,
0,
76,
0,
0,
0,
0,
0
],
[
"89741a",
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
0.247,
1619740800,
1001.7183,
"buy",
0,
0,
0,
0,
0,
88,
0,
0,
0,
0,
0
],
[
"24896a",
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
0.246,
1622505600,
1000.4106,
"sell",
0,
0,
0,
0,
0,
102,
0,
0,
0,
0,
0
],
[
"41564a",
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
30.603,
1623196800,
99994.1059,
"sell",
0,
0,
0,
0,
0,
114,
0,
0,
0,
0,
0
],
]
}
]
}
]
}
'
Test Environment Not Available
Response
Body
Equity Intraday Tradewise Tax P/L
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| symbol | string | Symbol or description of equity share |
| quantity | number | Trading quantity |
| buy_trade_id | string | Transaction ID of the buy transaction |
| buy_date | number | The date on which the equity share was bought |
| buy_price | number | Price at which a unit was bought |
| sell_trade_id | string | Transaction ID of the sell transaction |
| sell_date | number | The date on which the equity share was sold |
| sell_price | number | Price at which a unit was sold |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stt | number | Security Transaction Tax |
| stamp_duty | number | Stamp duty paid on transfer of shares |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of shares |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| holding_period | string | The holding period of the equity utual fund could be either long_term or short_term |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Equity Delivery Tradewise Tax P/L
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| symbol | string | Symbol or description of equity share |
| quantity | number | Trading quantity |
| buy_trade_id | string | Transaction ID of the buy transaction |
| buy_date | number | The date on which the equity share was bought |
| buy_price | number | Price at which a unit was bought |
| sell_trade_id | string | Transaction ID of the sell transaction |
| sell_date | number | The date on which the equity share was sold |
| sell_price | number | Price at which a unit was sold |
| fmv | number | Fare market value as on 31.01.2018 |
| cost_of_acquisition | number | cost of acquisition considered for calculating taxable pnl. |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stt | number | Security Transaction Tax |
| stamp_duty | number | Stamp duty paid on transfer of shares |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of shares |
| nature_of_transaction | string | The nature of the transaction of the equity share |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| holding_period | string | The holding period of the equity utual fund could be either long_term or short_term |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Mutual Fund Tradewise Tax P/L
| Param | Type | Description |
|---|---|---|
| isin | string | ISIN is the international security identification number |
| scheme_name | string | Symbol or description of equity share |
| scheme_type | string | |
| quantity | number | Trading quantity |
| buy_trade_id | string | Transaction ID of the buy transaction |
| buy_date | number | The date on which the equity share was bought |
| buy_price | number | Price at which a unit was bought |
| sell_trade_id | string | Transaction ID of the sell transaction |
| sell_date | number | The date on which the equity share was sold |
| sell_price | number | Price at which a unit was sold |
| fmv | number | Fare market value as on 31.01.2018 |
| cost_of_acquisition | number | cost of acquisition considered for calculating taxable pnl. |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stt | number | Security Transaction Tax |
| stamp_duty | number | Stamp duty paid on transfer of shares |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of shares |
| nature_of_transaction | string | The nature of the transaction of the equity share |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| holding_period | string | The holding period of the mutual fund could be either long_term or short_term |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Futures And Options Tradewise Tax P/L
| Param | Type | Description |
|---|---|---|
| contract_name | string | Name of contract |
| asset_type | string | The asset type of the contract. Possible valuesoption & future. |
| asset_class | string | The asset class of the contract. Possible valuesequity, currency & commodity |
| quantity | number | Trading quantity |
| buy_trade_id | string | Transaction ID of the buy transaction |
| buy_date | number | The date on which the equity share was bought |
| buy_price | number | Price at which a unit was bought |
| sell_trade_id | string | Transaction ID of the sell transaction |
| sell_date | number | The date on which the equity share was sold |
| sell_price | number | Price at which a unit was sold |
| brokerage | number | Brokerage expense |
| clearing_charges | number | Charges charged by clearing house |
| exchange_transaction_charges | number | Transaction charges by exchange |
| sebi_turnover_fees | number | Turnover fees by SEBI |
| stt | number | Security Transaction Tax |
| stamp_duty | number | Stamp duty paid on transfer of shares |
| sgst | number | State GST |
| cgst | number | Central GST |
| igst | number | Integrated GST |
| other_transfer_expenses | number | Any other expense relating to the transfer of shares |
| nature_of_transaction | string | The nature of the transaction of the equity share |
| realized_pnl | number | The realized profit or loss on the trade without considering transfer expenses |
| transfer_expenses | number | Any expense relating to the transfer of shares. |
| net_realized_pnl | number | The realized profit or loss on the trade after considering transfer expenses |
| taxable_pnl | string | The taxable amount of the trade |
| holding_period | string | The holding period of the mutual fund could be either long_term or short_term |
| turnover | number | Turnover of the transaction |
| income_head | string | The income head of ITR under which the income of a specific trade is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific trade is to be reported |
| tax_rate | string | The applicable tax rate for the trade. |
Asset Wise Summary
| Param | Type | Description |
|---|---|---|
| asset_class | string | Asset class |
| asset_type | string | Asset category |
| income_head | string | The income head of ITR under which the income of a specific income is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income of a specific income is to be reported |
| holding_period | string | The holding period of the asset could be either long_term or short_term |
| turnover | number | Turnover of the transactions |
| realized_pnl | number | The realized profit or loss on trades without considering transfer expenses |
| transfer_expenses | number | Any expense relating to the transfer of assets |
| net_realized_pnl | number | The realized profit or loss on trades after considering transfer expenses |
| taxable_pnl | number | The taxable amount |
Tax P/L Summary
This table gives a summary of your crypto trades grouped by income_head, income_sub_head, and holding_period.
| Param | Type | Description |
|---|---|---|
| income_head | string | The income head of ITR under which the income is to be reported |
| income_sub_head | string | The income subhead of ITR under which the income is to be reported |
| holding_period | string | The holding period of the crypto. |
| tax_rate | string | The applicable tax rate for all trades. |
| realized_pnl | number | Total realized profit or loss on the trades without considering expenses |
| transfer_expenses | number | Total expenses that occurred during the transafer of crypto, could be network fees, brokerage, or any other transaction fee. |
| net_realized_pnl | number | Total realized profit or loss on the trades after considering expenses |
| taxable_pnl | string | The total taxable amount of all trades |
Sample Response
You can refer to the sample response in workbook format
The API responds back in a sheet structure. An example response is shown below.
{
"code": 200,
"timestamp": "1681481686000",
"data": {
"name": "tradewise_tax_pnl_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "equity_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "equity_intraday_tradewise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INE190B01019",
"INFY",
40,
"1",
1617135200000,
80,
"7",
1617135209000,
100,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
800,
0,
800,
800,
800,
"business_and_profession",
"speculative",
"slab_rate"
]
]
},
{
"name": "equity_delivery_tradewise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"is_listed",
"is_stt_paid",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"cost_of_aquisition",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_transaction",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INE423A01024",
"ADANIENT",
true,
true,
0.2,
"4",
1617321600000,
1000,
"17",
1637366400000,
1200,
1200,
1000,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"trading",
40.0,
0,
40.0,
40.0,
"short_term",
240.0,
"capital_gains",
"securities",
"15"
],
[
"INE190B01019",
"INFY",
true,
true,
10,
"1",
1617135200000,
80,
"18",
1638567500000,
250,
250,
80,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"trading",
1700,
0,
1700,
1700,
"short_term",
2500,
"capital_gains",
"securities",
"15"
],
[
"INE190B01019",
"INFY",
true,
true,
5,
"2",
1617195200000,
70,
"18",
1638567500000,
250,
250,
70,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"trading",
900,
0,
900,
900,
"short_term",
1250,
"capital_gains",
"securities",
"15"
],
[
"INE245A01021",
"TATAPOWER",
true,
true,
24.7349,
"3",
1617235200000,
75,
"5",
1620604800000,
20,
20,
75,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"trading",
-1360.4195,
0,
-1360.4195,
0,
"short_term",
494.6980,
"capital_gains",
"securities",
"15"
],
[
"INE245A01021",
"TATAPOWER",
true,
true,
24.7349,
"3",
1617235200000,
75,
"8",
1623369600000,
80,
80,
75,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"trading",
123.6745,
0,
123.6745,
123.6745,
"short_term",
1978.7920,
"capital_gains",
"securities",
"15"
]
]
}
]
},
{
"name": "mutual_fund_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "mutual_fund_tradewise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"is_listed",
"is_stt_paid",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"cost_of_acquisation",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_transaction",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
0.246,
"89741a",
1619740800,
1001.7183,
"24896a",
1622505600,
1000.4106,
0,
1001.7183,
0,
0,
0,
0,
189.6437,
0,
0,
0,
0,
0,
null,
-0.3217,
189.6437,
-189.9654,
0.0000,
"short_term",
246.1010,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
30.603,
"14712a",
1618876800,
99996.0019,
"41564a",
1623196800,
99994.1059,
0,
99996.0019,
0,
0,
0,
0,
211.5664,
0,
0,
0,
0,
0,
null,
-58.0233,
211.5664,
-269.5897,
0.0000,
"short_term",
3060119.6229,
"capital_gains",
"securities",
"15"
],
[
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
true,
true,
150,
"15648a",
1622937600,
520,
"15648a",
1628208000,
400,
0,
520,
0,
0,
0,
0,
87,
0,
0,
0,
0,
0,
null,
-18000.0000,
87.0000,
-18087.0000,
0.0000,
"short_term",
60000.0000,
"capital_gains",
"other_capital_gains",
"slab_rate"
]
]
}
]
},
{
"name": "futures_and_options_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "futures_and_options_tradewise_tax_pnl_table",
"@entity": "table",
"header": [
"contract_name",
"asset_type",
"asset_class",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_transaction",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"NIFTY21JUN15800CE",
"option",
"Equity",
150,
"456789a",
1649548800,
171.775,
"333444a",
1653436800,
171.45,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
-48.7500,
0.0000,
-48.7500,
0.0000,
48.7500,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FINNIFTY21MAYFUT",
"future",
"Equity",
40,
"54612a",
1649548800,
15700,
"123098a",
1653436800,
15685.9,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
-564.0000,
0.0000,
-564.0000,
0.0000,
564.0000,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"USD21APR14700CE",
"option",
"Currency",
75,
"54321a",
1649548800,
363.15,
"890123a",
1653436800,
194.9,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
-12618.7500,
0.0000,
-12618.7500,
0.0000,
12618.7500,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"CRUDE21APR14700CE",
"option",
"Commodity",
75,
"12345a",
1648771200,
363.1,
"789012a",
1653436800,
194.9,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
-12615.0000,
0.0000,
-12615.0000,
0.0000,
12615.0000,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY21JUN17500CE",
"option",
"Equity",
75,
"15484a",
1649548800,
4.55,
"345876a",
1653436800,
4.7,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
11.2500,
0.0000,
11.2500,
11.2500,
11.2500,
"business_and_profession",
"non_speculative",
"slab_rate"
]
]
}
]
},
{
"name": "tradewise_tax_pnl_summary_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "asset_wise_summary_table",
"@entity": "table",
"header": [
"asset_class",
"asset_type",
"income_head",
"income_sub_head",
"holding_period",
"turnover",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
"equity",
"share",
"capital_gains",
"securities",
"short_term",
6463.490,
1403.2550,
0,
1403.2550,
1403.2550
],
[
"equity",
"share",
"capital_gains",
"securities",
"long_term",
0,
0,
0,
0,
0
],
[
"equity",
"share",
"business_and_profession",
"speculative",
"intraday",
800,
800,
0,
800,
800
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"short_term",
3060119.6229,
-58.0233,
211.5664,
-269.5897,
0
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"long_term",
0,
0,
0,
0
],
[
"debt",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"short_term",
60246.101,
-18000.3217,
276.6437,
-18276.9654,
0
],
[
"debt",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"long_term",
0,
0,
0,
0
],
[
"other",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"short_term",
0,
0,
0,
0
],
[
"other",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"long_term",
0,
0,
0,
0
],
[
"equity",
"future",
"business_and_profession",
"non_speculative",
null,
564,
-564,
0,
-564,
0
],
[
"commodity",
"future",
"business_and_profession",
"non_speculative",
null,
0,
0,
0,
0,
0
],
[
"currency",
"future",
"business_and_profession",
"non_speculative",
null,
0,
0,
0,
0,
0
],
[
"equity",
"option",
"business_and_profession",
"non_speculative",
null,
60.00,
-37.50,
0,
-37.50,
0
],
[
"commodity",
"option",
"business_and_profession",
"non_speculative",
null,
12615,
-12615,
0,
-12615,
0
],
[
"currency",
"option",
"business_and_profession",
"non_speculative",
null,
12618.75,
-12618.75,
0,
-12618.75,
0
]
]
},
{
"name": "tradewise_tax_pnl_summary_table",
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"holding_period",
"tax_rate",
"turnover",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
"capital_gains",
"securities",
"short_term",
"slab_rate",
0,
0,
0,
0,
0
],
[
"capital_gains",
"securities",
"short_term",
"15",
3066583.1129,
1345.2317,
211.5664,
1133.6653,
1133.6653
],
[
"capital_gains",
"securities",
"long_term",
"10",
0,
0,
0,
0,
0
],
[
"capital_gains",
"securities",
"long_term",
"20",
0,
0,
0,
0,
0
],
[
"business_and_profession",
"speculative",
"intraday",
"slab_rate",
800,
800,
0,
800,
800
],
[
"capital_gains",
"other_capital_gains",
"short_term",
"slab_rate",
60246.101,
-18000.3217,
276.6437,
-18276.9654,
0
],
[
"capital_gains",
"other_capital_gains",
"long_term",
"20",
0,
0,
0,
0,
0
],
[
"business_and_profession",
"non_speculative",
null,
"slab_rate",
25857.75,
-25835.25,
0,
-25835.25,
0
]
]
}
]
}
]
}
}
Response Caching
Response caching is not available for this API. Learn more about our response caching mechanism here
Annexure
Annexure-1 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 | income_distribution_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 | voluntary_delisting_of_share |
Wallet Charge
Since the Tax P&L Calculator from Tradebook 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 16 days ago