post https://api.sandbox.co.in/calculators/income-tax/securities/domestic/tax-pnl/tradebook
API to take tradebook and calculate Tax P&L
Important Links
Request Body Example
{
"@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
],
]
}
]
}
]
}