JSON Payload
This API gives response in following two formats:
Tradewise Tax PnL
Click here to learn more about this JSON Payload
{
"code": 200,
"data": {
"metadata": {},
"@entity": "workbook",
"sheets": [
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@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_acquisition",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fee",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate",
"section"
],
"rows": [
[
null,
"12.50% 112",
false,
false,
1,
"493704f1-b90f-464e-84e0-f8f78979b8df-#-f63c78b2-0b7f-460e-a8d5-eb3d9ad77400",
1594233000000,
0,
null,
1741285800000,
8000,
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"trade",
8000,
0,
8000,
8000,
"long_term",
8000,
"capital_gains",
"securities",
"12.5",
"112"
],
[
null,
"12.50%",
true,
true,
1,
"246b473a-a466-4572-bd80-cc8e8c28ee56-#-f63c78b2-0b7f-460e-a8d5-eb3d9ad77400",
1469212200000,
0,
null,
1741199400000,
5000,
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"trade",
5000,
0,
5000,
5000,
"long_term",
5000,
"capital_gains",
"securities",
"12.5",
"112A"
],
[
null,
"20%",
false,
false,
1,
"7ea983a8-bbb4-40f5-a871-2d20f6c85021-#-f63c78b2-0b7f-460e-a8d5-eb3d9ad77400",
1457029800000,
0,
null,
1714156200000,
1400,
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"trade",
1400,
0,
1400,
1400,
"long_term",
1400,
"capital_gains",
"securities",
"20",
"112"
],
[
null,
"10%_112A",
true,
true,
1,
"5899e165-720b-4b3f-ac46-ec7d2d010d40-#-f63c78b2-0b7f-460e-a8d5-eb3d9ad77400",
1510252200000,
0,
null,
1712860200000,
3200,
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"trade",
3200,
0,
3200,
3200,
"long_term",
3200,
"capital_gains",
"securities",
"10",
"112A"
],
[
null,
"10%",
false,
false,
1,
"8d1bb5dc-d235-4688-844f-0966f07a42b9-#-f63c78b2-0b7f-460e-a8d5-eb3d9ad77400",
1499365800000,
0,
null,
1712687400000,
54000,
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"trade",
54000,
0,
54000,
54000,
"long_term",
54000,
"capital_gains",
"securities",
"20",
"112"
]
],
"name": "stock_delivery_tradewise_tax_pnl_table"
},
{
"metadata": {},
"@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_acquisition",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fee",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate",
"section"
],
"rows": [],
"name": "stock_delivery_tradewise_tax_pnl_table"
},
{
"metadata": {},
"@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_fee",
"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": [],
"name": "stock_intraday_tradewise_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [],
"name": "stock_tradewise_holding_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"sell_date",
"sell_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [],
"name": "stock_tradewise_open_sell_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": [],
"name": "stock_tradewise_transfer_table"
}
],
"name": "stock_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"quarter",
"asset_class",
"asset_type",
"income_head",
"income_sub_head",
"tax_rate",
"section",
"holding_period",
"turnover",
"buy_value",
"cost_of_acquisition",
"sell_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"10",
"112A",
"long_term",
3200,
0,
0,
3200,
3200,
0,
3200,
3200
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"10",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"10",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"10",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"20",
"112",
"long_term",
55400,
0,
0,
55400,
55400,
0,
55400,
55400
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
8000,
0,
0,
8000,
8000,
0,
8000,
8000
],
[
1,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
5000,
0,
0,
5000,
5000,
0,
5000,
5000
],
[
1,
"equity",
"stock",
"other",
"other_exempt_income",
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"other",
"other_exempt_income",
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"other",
"other_exempt_income",
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"other",
"other_exempt_income",
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"20",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"20",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"20",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"20",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"other",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"other",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"other",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"other",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"etf",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"etf",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"etf",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"etf",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"etf",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"etf",
"capital_gains",
"securities",
"20",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"etf",
"capital_gains",
"securities",
"20",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"etf",
"capital_gains",
"securities",
"20",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"etf",
"capital_gains",
"securities",
"20",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"etf",
"capital_gains",
"securities",
"12.5",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"etf",
"capital_gains",
"securities",
"12.5",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"etf",
"capital_gains",
"securities",
"12.5",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"etf",
"capital_gains",
"securities",
"12.5",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"commodity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"commodity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"commodity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"commodity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"currency",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"currency",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"currency",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"currency",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"equity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"equity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"equity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"equity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"commodity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"commodity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"commodity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"commodity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"currency",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"currency",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"currency",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"currency",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"bond",
"capital_gains",
"securities",
"12.5",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"bond",
"capital_gains",
"securities",
"12.5",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"bond",
"capital_gains",
"securities",
"12.5",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"bond",
"capital_gains",
"securities",
"12.5",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"bond",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"bond",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"bond",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"bond",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"bond",
"capital_gains",
"securities",
"20",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"bond",
"capital_gains",
"securities",
"20",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"bond",
"capital_gains",
"securities",
"20",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"bond",
"capital_gains",
"securities",
"20",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"debenture",
"capital_gains",
"securities",
"12.5",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"debenture",
"capital_gains",
"securities",
"12.5",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"debenture",
"capital_gains",
"securities",
"12.5",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"debenture",
"capital_gains",
"securities",
"12.5",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"debenture",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"debenture",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"debenture",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"debenture",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
1,
"debt",
"debenture",
"capital_gains",
"securities",
"20",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
2,
"debt",
"debenture",
"capital_gains",
"securities",
"20",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
"debt",
"debenture",
"capital_gains",
"securities",
"20",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
"debt",
"debenture",
"capital_gains",
"securities",
"20",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
]
],
"name": "quarter_wise_asset_wise_tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"asset_class",
"asset_type",
"income_head",
"income_sub_head",
"tax_rate",
"section",
"holding_period",
"turnover",
"buy_value",
"cost_of_acquisition",
"sell_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
"equity",
"stock",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"currency",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"other",
"other_exempt_income",
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"currency",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
5000,
0,
0,
5000,
5000,
0,
5000,
5000
],
[
"commodity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"12.5",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"20",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"bond",
"capital_gains",
"securities",
"12.5",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"bond",
"capital_gains",
"securities",
"20",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"20",
"112",
"long_term",
55400,
0,
0,
55400,
55400,
0,
55400,
55400
],
[
"debt",
"etf",
"capital_gains",
"securities",
"20",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
8000,
0,
0,
8000,
8000,
0,
8000,
8000
],
[
"other",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"mutual_fund",
"capital_gains",
"securities",
"20",
"112",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"etf",
"capital_gains",
"securities",
"12.5",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
"112A",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"20",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"etf",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"12.5",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"bond",
"capital_gains",
"securities",
"10",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"stock",
"capital_gains",
"securities",
"10",
"112A",
"long_term",
3200,
0,
0,
3200,
3200,
0,
3200,
3200
],
[
"equity",
"etf",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"commodity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"debt",
"mutual_fund",
"capital_gains",
"securities",
"12.5",
null,
"short_term",
0,
0,
0,
0,
0,
0,
0,
0
]
],
"name": "asset_wise_tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"quarter",
"income_head",
"income_sub_head",
"holding_period",
"tax_rate",
"section",
"turnover",
"buy_value",
"cost_of_acquisition",
"sell_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
1,
"capital_gains",
"securities",
"long_term",
"10",
"112A",
3200,
0,
0,
3200,
3200,
0,
3200,
3200
],
[
1,
"capital_gains",
"securities",
"long_term",
"20",
"112",
55400,
0,
0,
55400,
55400,
0,
55400,
55400
],
[
4,
"capital_gains",
"securities",
"long_term",
"12.5",
"112A",
5000,
0,
0,
5000,
5000,
0,
5000,
5000
],
[
4,
"capital_gains",
"securities",
"long_term",
"12.5",
"112",
8000,
0,
0,
8000,
8000,
0,
8000,
8000
]
],
"name": "quarter_wise_tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"holding_period",
"tax_rate",
"section",
"turnover",
"buy_value",
"cost_of_acquisition",
"sell_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
"capital_gains",
"securities",
"long_term",
"20",
"112",
55400,
0,
0,
55400,
55400,
0,
55400,
55400
],
[
"capital_gains",
"securities",
"long_term",
"12.5",
"112",
8000,
0,
0,
8000,
8000,
0,
8000,
8000
],
[
"capital_gains",
"securities",
"long_term",
"12.5",
"112A",
5000,
0,
0,
5000,
5000,
0,
5000,
5000
],
[
"capital_gains",
"securities",
"long_term",
"10",
"112A",
3200,
0,
0,
3200,
3200,
0,
3200,
3200
]
],
"name": "tax_pnl_summary_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"tax_rate",
"holding_period",
"section",
"taxable_income",
"income_setoff_against_non_speculative_business_loss",
"income_setoff_against_loss_from_other_sources",
"income_setoff_against_stcl_15_percent",
"income_setoff_against_stcl_20_percent",
"income_setoff_against_stcl_30_percent",
"income_setoff_against_stcl_slab_rate",
"income_setoff_against_ltcl_10_percent",
"income_setoff_against_ltcl_10_percent_112a",
"income_setoff_against_ltcl_12_5_percent",
"income_setoff_against_ltcl_12_5_percent_112a",
"income_setoff_against_ltcl_20_percent",
"net_taxable_income"
],
"rows": [
[
"business_and_profession",
"non_speculative",
null,
null,
null,
0,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
0
],
[
"business_and_profession",
"speculative",
null,
null,
null,
0,
0,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
0
],
[
"capital_gains",
"securities",
"15",
"short_term",
"111A",
0,
0,
0,
null,
0,
0,
0,
null,
null,
null,
null,
null,
0
],
[
"capital_gains",
"securities",
"20",
"short_term",
"111A",
0,
0,
0,
0,
null,
0,
0,
null,
null,
null,
null,
null,
0
],
[
"capital_gains",
"securities",
"slab_rate",
"short_term",
null,
0,
0,
0,
0,
0,
0,
null,
null,
null,
null,
null,
null,
0
],
[
"capital_gains",
"securities",
"10",
"long_term",
"112",
0,
0,
0,
0,
0,
0,
0,
null,
null,
0,
0,
0,
0
],
[
"capital_gains",
"securities",
"10",
"long_term",
"112A",
3200,
0,
0,
0,
0,
0,
0,
null,
null,
0,
0,
3200,
0
],
[
"capital_gains",
"securities",
"12.5",
"long_term",
"112",
8000,
0,
0,
0,
0,
0,
0,
0,
null,
0,
0,
null,
8000
],
[
"capital_gains",
"securities",
"12.5",
"long_term",
"112A",
5000,
0,
0,
0,
0,
0,
0,
0,
null,
0,
null,
null,
5000
],
[
"capital_gains",
"securities",
"20",
"long_term",
"112",
55400,
0,
0,
0,
0,
0,
0,
0,
null,
0,
0,
null,
55400
]
],
"name": "current_year_income_adjustment_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"tax_rate",
"holding_period",
"section",
"taxable_loss",
"loss_setoff_against_non_speculative_business_income",
"loss_setoff_against_speculative_business_income",
"loss_setoff_against_stcg_15_percent",
"loss_setoff_against_stcg_20_percent",
"loss_setoff_against_stcg_30_percent",
"loss_setoff_against_stcg_slab_rate",
"loss_setoff_against_ltcg_10_percent",
"loss_setoff_against_ltcg_10_percent_112a",
"loss_setoff_against_ltcg_12_5_percent",
"loss_setoff_against_ltcg_12_5_percent_112a",
"loss_setoff_against_ltcg_20_percent",
"loss_setoff_against_other_income",
"total_losses_setoff",
"losses_remaining"
],
"rows": [
[
"business_and_profession",
"non_speculative",
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"business_and_profession",
"speculative",
null,
null,
null,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
0
],
[
"capital_gains",
"securities",
"15",
"short_term",
"111A",
0,
null,
null,
null,
null,
0,
0,
0,
0,
0,
null,
0,
null,
0,
0
],
[
"capital_gains",
"securities",
"20",
"short_term",
"111A",
0,
null,
null,
0,
null,
0,
0,
0,
0,
0,
null,
0,
null,
0,
0
],
[
"capital_gains",
"securities",
"slab_rate",
"short_term",
"111A",
0,
null,
null,
0,
0,
0,
null,
0,
0,
0,
null,
0,
null,
0,
0
],
[
"capital_gains",
"securities",
"10",
"long_term",
"112",
0,
null,
null,
null,
null,
null,
null,
null,
0,
0,
0,
0,
null,
0,
0
],
[
"capital_gains",
"securities",
"10",
"long_term",
"112A",
0,
null,
null,
null,
null,
null,
null,
0,
null,
0,
0,
0,
null,
0,
0
],
[
"capital_gains",
"securities",
"12.5",
"long_term",
"112",
0,
null,
null,
null,
null,
null,
null,
0,
0,
null,
0,
0,
null,
0,
0
],
[
"capital_gains",
"securities",
"12.5",
"long_term",
"112A",
0,
null,
null,
null,
null,
null,
null,
0,
0,
0,
null,
0,
null,
0,
0
],
[
"capital_gains",
"securities",
"20",
"long_term",
"112",
0,
null,
null,
null,
null,
null,
null,
0,
3200,
0,
0,
null,
null,
0,
0
]
],
"name": "current_year_loss_adjustment_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"quarter",
"net_taxable_stcg",
"net_taxable_ltcg",
"net_taxable_stcg_15",
"net_taxable_stcg_20",
"net_taxable_stcg_30",
"net_taxable_stcg_slab_rate",
"net_taxable_ltcg_10",
"net_taxable_ltcg_10_112a",
"net_taxable_ltcg_12_5",
"net_taxable_ltcg_12_5_112a",
"net_taxable_ltcg_20"
],
"rows": [
[
1,
0,
55400,
0,
0,
0,
0,
0,
0,
0,
0,
55400
],
[
2,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
3,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
4,
0,
5000,
0,
0,
0,
0,
0,
0,
0,
5000,
0
]
],
"name": "accrued_capital_gains_table"
}
],
"name": "tax_pnl_summary_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"is_listed",
"is_stt_paid",
"quantity",
"buy_date",
"buy_trade_id",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"cost_of_acquisition",
"nature_of_settlement",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate",
"section"
],
"rows": [],
"name": "mutual_fund_tradewise_tax_pnl_table"
}
],
"name": "mutual_fund_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"is_listed",
"is_stt_paid",
"quantity",
"buy_date",
"buy_trade_id",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"cost_of_acquisition",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fee",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate",
"section"
],
"rows": [],
"name": "etf_delivery_tradewise_tax_pnl_table"
},
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_date",
"buy_trade_id",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"cost_of_acquisition",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fee",
"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": [],
"name": "etf_intraday_tradewise_tax_pnl_table"
}
],
"name": "etf_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"contract_name",
"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_fee",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate",
"section"
],
"rows": [],
"name": "future_tradewise_tax_pnl_table"
}
],
"name": "future_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"contract_name",
"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_fee",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate",
"section"
],
"rows": [],
"name": "option_tradewise_tax_pnl_table"
}
],
"name": "option_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"security_name",
"is_listed",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"cost_of_acquisition",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fee",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate",
"section"
],
"rows": [],
"name": "bond_tradewise_tax_pnl_table"
}
],
"name": "bond_sheet"
},
{
"metadata": {},
"@entity": "sheet",
"blocks": [
{
"metadata": {},
"@entity": "table",
"header": [
"isin",
"security_name",
"is_listed",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"cost_of_acquisition",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fee",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate",
"section"
],
"rows": [],
"name": "debenture_tradewise_tax_pnl_table"
}
],
"name": "debenture_sheet"
}
],
"name": "domestic_securities_tradewise_tax_pnl_workbook"
}
}
Scripwise Tax PnL
Click here to learn more about this JSON Payload
{
"transaction_id": "f29d70ba-fa11-4fff-9b53-cdfe488d81a4",
"code": 200,
"data": {
"name": "scripwise_tax_pnl_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "stock_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "stock_delivery_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"is_listed",
"quantity",
"buy_average",
"sell_average",
"cost_of_acquisition",
"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",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INE00E101023",
"BIKAJI",
true,
140,
327,
355.8929,
327,
64.5875,
64.5875,
64.5875,
64.5875,
64.5875,
64.5875,
64.5875,
64.5875,
64.5875,
64.5875,
4045.006,
645.875,
3399.131,
3463.7185,
"short_term",
49825.006,
"capital_gains",
"securities",
"15"
],
[
"INE00E101023",
"BIKAJI",
true,
2260,
197.0355,
311.761,
197.0355,
445.6779,
445.6779,
445.6779,
445.6779,
445.6779,
445.6779,
445.6779,
445.6779,
445.6779,
445.6779,
259279.63,
4456.779,
254822.851,
255268.5289,
"long_term",
704579.86,
"capital_gains",
"securities",
"10"
],
[
"INE462A01022",
"BAYERCROP",
true,
58,
4209.525,
4278.08,
4209.525,
128.9829,
128.9829,
128.9829,
128.9829,
128.9829,
128.9829,
128.9829,
128.9829,
128.9829,
128.9829,
3976.19,
1289.829,
2686.361,
2815.3439,
"short_term",
248128.64,
"capital_gains",
"securities",
"15"
],
[
"INE462A01022",
"BAYERCROP",
true,
62,
4135.1492,
4235.5763,
4135.1492,
235.8171,
235.8171,
235.8171,
235.8171,
235.8171,
235.8171,
235.8171,
235.8171,
235.8171,
235.8171,
6226.4802,
2358.171,
3868.3092,
4104.1263,
"long_term",
262605.7306,
"capital_gains",
"securities",
"10"
],
[
"INE01C001018",
"ADANIPORTS",
true,
300,
270,
410.32,
270,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
42096,
1305.103,
40790.897,
40921.4073,
"long_term",
123096,
"capital_gains",
"securities",
"10"
],
[
"INE364U01010",
"ADANIGREEN",
true,
40,
310,
365,
310,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
2200,
844.085,
1355.915,
1440.3235,
"short_term",
14600,
"capital_gains",
"securities",
"15"
],
[
"INE002A01018",
"AJANTAPHARMA",
true,
145,
578,
689,
578,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
16095,
804,
15291,
15371.4,
"short_term",
99905,
"capital_gains",
"securities",
"15"
],
[
"INE002A01018",
"AJANTAPHARMA",
true,
1590,
136,
604.5943,
136,
147.6,
147.6,
147.6,
147.6,
147.6,
147.6,
147.6,
147.6,
147.6,
147.6,
745064.937,
1476,
743588.937,
743736.537,
"long_term",
961304.937,
"capital_gains",
"securities",
"10"
]
]
},
{
"name": "stock_intraday_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_average",
"sell_average",
"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": [
[
"INE01C001018",
"ADANIPORTS",
20,
410,
436,
76,
76,
76,
76,
76,
76,
76,
76,
76,
76,
520,
760,
-240,
-240,
520,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE364U01010",
"ADANIGREEN",
15,
281,
250,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
-465,
912,
-1377,
-1377,
465,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE462A01022",
"BAYERCROP",
25,
4254,
4239,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
-375,
912,
-1287,
-1287,
375,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE010B01019",
"CADILAHC",
254,
1290.98,
1301.78,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
2743.2,
912,
1831.2,
1831.2,
2743.2,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE00E101023",
"BIKAJI",
352,
314.5114,
309.4091,
182.4,
182.4,
182.4,
182.4,
182.4,
182.4,
182.4,
182.4,
182.4,
182.4,
-1796.0096,
1824,
-3620.0096,
-3620.0096,
1796.0096,
"business_and_profession",
"speculative",
"slab_rate"
]
]
},
{
"name": "stock_scripwise_holding_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE03Q201024",
"GLS",
50,
5000,
null,
null
],
[
"INE01C001018",
"ADANIPORTS",
78,
328.7179,
null,
null
],
[
"INE364U01010",
"ADANIGREEN",
27,
295.1852,
null,
null
],
[
"INE767A01016",
"ADANIENT",
80,
1968.975,
null,
null
]
]
},
{
"name": "stock_scripwise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"sell_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE03Q201024",
"GLS",
50,
5000,
null,
null
],
[
"INE00E101023",
"BIKAJI",
260,
370,
null,
null
]
]
}
]
},
{
"name": "mutual_fund_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "mutual_fund_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"cost_of_acquisition",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_subhead",
"tax_rate"
],
"rows": [
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
17.823,
10,
5,
10,
-89.115,
66.9329,
-156.0479,
-156.0479,
"short_term",
89.115,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
125,
150,
400,
160,
31250,
107.1985,
31142.8015,
29892.8015,
"long_term",
50000,
"capital_gains",
"securities",
"10"
],
[
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
36.023,
30,
60,
34.96,
1080.69,
168,
912.69,
734.01592,
"long_term",
2161.38,
"capital_gains",
"other_capital_gains",
"20"
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
20,
60,
210,
60,
3000,
48.0936,
2951.9064,
2951.9064,
"short_term",
4200,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
35,
200,
210,
300.91,
350,
624.6364,
-274.6364,
-3806.4864,
"long_term",
7350,
"capital_gains",
"other_capital_gains",
"20"
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
32.531,
400.784,
200,
400.784,
-6531.704304,
108.5685,
-6640.272804,
-6640.272804,
"short_term",
6506.2,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
19.574,
120,
160,
153.53,
782.96,
95.7233,
687.2367,
30.92048,
"long_term",
3131.84,
"capital_gains",
"other_capital_gains",
"20"
],
[
"INF200K01190",
"KOTAK SEC FUND",
"equity",
90,
988.8889,
1255.5556,
988.8889,
24000.003,
818,
23182.003,
23182.003,
"short_term",
113000.004,
"capital_gains",
"securities",
"15"
],
[
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
32.31,
50,
900,
50,
27463.5,
99.658,
27363.842,
27363.842,
"short_term",
29079,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
605.9,
124.2586,
211.1733,
124.2586,
52661.61673,
171.3589,
52490.25783,
52490.25783,
"long_term",
127949.90247,
"capital_gains",
"securities",
"10"
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
19.88,
15,
60,
18.72,
894.6,
48.0408,
846.5592,
772.6056,
"long_term",
1192.8,
"capital_gains",
"other_capital_gains",
"20"
],
[
"INF760K01FR2",
"Canara Robeco Bluechip Equity Growth Direct Plan",
"equity",
155,
23.78,
56.9,
23.78,
5133.6,
4,
5129.6,
5129.6,
"long_term",
8819.5,
"capital_gains",
"securities",
"10"
],
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
25.68,
459,
500,
459,
1052.88,
50.25,
1002.63,
1002.63,
"short_term",
12840,
"capital_gains",
"securities",
"15"
]
]
},
{
"name": "mutual_fund_scripwise_holding_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
19.393,
10,
null,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
31.78,
150,
null,
null
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
86.768,
128.5737,
null,
null
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
2.508,
400.784,
null,
null
],
[
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
229,
193.6681,
null,
null
],
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
50,
124.2586,
null,
null
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
15.134,
15,
null,
null
]
]
},
{
"name": "mutual_fund_scripwise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"sell_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
17.137,
160,
null,
null
]
]
}
]
},
{
"name": "etf_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "etf_delivery_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"cost_of_acquisation",
"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",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INF200K01189",
"SBI Gold Fund",
"other",
50,
120.5877,
60,
120.5877,
71,
76,
107,
74,
58,
90,
23,
57,
79,
50,
-3029.385,
685,
-3714.385,
-3656.385,
"short_term",
3000,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
100,
400.784,
200,
400.784,
123.3333,
63.3333,
73.3333,
26,
60.3333,
15.3333,
21.6667,
60.6667,
35.3333,
70,
-20078.4,
549.3332,
-20627.7332,
-20567.3999,
"short_term",
20000,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
78,
23,
88,
23,
185,
52,
188,
160,
151,
251,
139,
207,
116,
155,
5070,
1604,
3466,
3617,
"long_term",
6864,
"capital_gains",
"securities",
"10"
],
[
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
100,
60,
30,
60,
211,
100,
140,
144,
222,
134,
107,
202,
104,
14,
-3000,
1378,
-4378,
-4156,
"short_term",
3000,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
90,
150,
250,
150,
187,
148,
84,
194,
103,
144,
89,
77,
154,
259,
9000,
1439,
7561,
7664,
"short_term",
22500,
"capital_gains",
"securities",
"15"
],
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
31.536,
10,
5,
10,
226,
145,
95,
235,
46,
39,
196,
165,
142,
210,
-157.68,
1499,
-1656.68,
-1610.68,
"short_term",
157.68,
"capital_gains",
"other_capital_gains",
"slab_rate"
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
130,
236.2069,
416.1538,
236.2069,
285,
438.6552,
582.4827,
374.069,
414.4138,
218.138,
301.5517,
378.6897,
626.862,
593.7241,
23393.097,
4213.5862,
19179.5108,
19593.9246,
"long_term",
54099.994,
"capital_gains",
"securities",
"10"
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
60,
120,
160,
120,
155.25,
152.75,
96,
119.75,
158.5,
69.25,
42.75,
200.5,
94.75,
100,
2400,
1189.5,
1210.5,
1369,
"long_term",
9600,
"capital_gains",
"other_capital_gains",
"slab_rate"
]
]
},
{
"name": "etf_intraday_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"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": [
[
"INF179KB1QR6",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
75,
125,
45,
58,
223,
275,
87,
82,
192,
279,
110,
211,
97,
-6000,
1614,
-7614,
-7614,
6000,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
20,
15,
60,
80,
57,
95,
39,
16,
100,
34,
142,
145,
23,
900,
731,
169,
169,
900,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
100,
550,
500,
154,
215,
271,
48,
238,
142,
90,
62,
219,
105,
-5000,
1544,
-6544,
-6544,
5000,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
250,
650,
600,
134,
83,
241,
199,
265,
158,
193,
206,
113,
100,
-12500,
1692,
-14192,
-14192,
12500,
"business_and_profession",
"speculative",
"slab_rate"
]
]
},
{
"name": "etf_scripwise_holding_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"last_traded_price",
"unrelaized_pnl"
],
"rows": [
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
20,
120,
null,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
15,
236.2069,
null,
null
],
[
"INF179KB1QR8",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
75,
150,
null,
null
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
50,
400.784,
null,
null
]
]
},
{
"name": "etf_scripwise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"sell_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": []
}
]
},
{
"name": "future_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "future_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"contract_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"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": [
[
"NIFTY 15 JAN 2023 FUT",
"equity",
250,
168,
215,
324,
263,
81,
654,
532,
780,
237,
304,
258,
98,
11750,
3531,
8219,
8219,
11750,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"BANKNIFTY 20 MAR 2023 FUT",
"equity",
125,
1500,
615.89,
163,
136,
43,
365,
210,
795,
289,
231,
294,
28,
-110513.75,
2554,
-113067.75,
-113067.75,
110513.75,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FINNIFTY 15 FEB 2023 FUT",
"equity",
155,
194.9,
174.55,
169,
118,
141,
341,
338,
281,
40,
181,
75,
66,
-3154.25,
1750,
-4904.25,
-4904.25,
3154.25,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY 23 FEB 2023 FUT",
"equity",
175,
194.9,
199.5474,
276,
235,
185,
412,
909,
897,
338,
209,
162,
94,
813.295,
3717,
-2903.705,
-2903.705,
813.295,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY 23 JAN 2023 FUT",
"equity",
200,
151.64,
143.1565,
491,
410,
180,
579,
843,
1174,
499,
291,
616,
99,
-1696.7,
5182,
-6878.7,
-6878.7,
1696.7,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FUTCUR EURINR 13 MAY 2023",
"currency",
195,
281.7436,
269.7385,
269,
639,
649,
625,
520,
375,
222,
669,
671,
434,
-2340.9945,
5073,
-7413.9945,
-7413.9945,
2340.9945,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY 17 APR 2023 FUT",
"equity",
135,
457.89,
489.67,
253.9655,
165.6897,
148.4828,
229.6207,
339.8966,
520.2759,
45.8276,
193.0345,
132.6897,
62.8966,
4290.3,
2092.3796,
2197.9204,
2197.9204,
4290.3,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FINNIFTY 20 MAY 2023 FUT",
"equity",
120,
698.03,
745.32,
228.4615,
114.5385,
117.1538,
269.6154,
244.6923,
755.2308,
157.5385,
179,
103.3077,
67.6154,
5674.8,
2237.1539,
3437.6461,
3437.6461,
5674.8,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FINNIFTY 25 JAN 2023 FUT",
"equity",
35,
3450.67,
2568.98,
155,
183,
79,
296,
369,
171,
270,
191,
55,
32,
-30859.15,
1801,
-32660.15,
-32660.15,
30859.15,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY 25 JAN 2023 FUT",
"equity",
100,
175.55,
126.78,
83,
99,
135,
431,
165,
257,
307,
114,
154,
70,
-4877,
1815,
-6692,
-6692,
4877,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"BANKNIFTY 15 Jun 2023 FUT",
"equity",
50,
363.15,
447.26,
107,
254,
197,
452,
617,
779,
306,
377,
239,
38,
4205.5,
3366,
839.5,
839.5,
4205.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FUTCOM CRUDEOIL 16 OCT 2022",
"commodity",
150,
428.6667,
444.6667,
297,
277,
303,
306,
343,
285,
167,
301,
362,
157,
2400,
2798,
-398,
-398,
2400,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FUTCUR USDINR 27 JAN 2023 ",
"currency",
280,
89.0121,
76.4686,
714,
745,
946,
353,
589,
743,
809,
457,
708,
566,
-3512.18,
6630,
-10142.18,
-10142.18,
3512.18,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FUTCUR JPYINR 24 AUG 2023",
"currency",
110,
324.0636,
345.89,
139.4167,
478.0833,
191.3333,
340.5,
286,
402.6667,
451.75,
231.4167,
271.4167,
429.6667,
2400.904,
3222.2501,
-821.3461,
-821.3461,
2400.904,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FUTCUR GBPINR 27 OCT 2023",
"currency",
75,
4500,
4509,
36,
272,
216,
140,
125,
195,
179,
416,
306,
109,
675,
1994,
-1319,
-1319,
675,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
290,
139.1379,
152.8966,
1363.0769,
516.6923,
363.8461,
460.2307,
464.7692,
496.1538,
616.3077,
462.7692,
491.9231,
509,
3990.023,
5744.769,
-1754.746,
-1754.746,
3990.023,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"BANKNIFTY 01 Jun 2023 FUT",
"equity",
45,
363.1,
450.09,
162,
153,
89,
139,
323,
655,
157,
166,
223,
75,
3914.55,
2142,
1772.55,
1772.55,
3914.55,
"business_and_profession",
"non_speculative",
"slab_rate"
]
]
},
{
"name": "future_scripwise_open_position_table",
"@entity": "table",
"header": [
"contract_name",
"asset_class",
"quantity",
"trade_price_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"FUTCUR JPYINR 24 AUG 2023",
"currency",
50,
332.8476,
null,
null
],
[
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
20,
156,
null,
null
],
[
"FUTCOM GOLD 29 OCT 2023",
"commodity",
55,
124.56,
null,
null
],
[
"NIFTY 17 APR 2023 FUT",
"equity",
10,
457.89,
null,
null
],
[
"FINNIFTY 20 MAY 2023 FUT",
"equity",
10,
698.03,
null,
null
]
]
}
]
},
{
"name": "option_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "option_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"contract_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"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": [
[
"NIFTY 23 JAN 2023 CE 15000",
"equity",
200,
1520,
1572.05,
5062,
7923,
8172,
4952,
5649,
7322,
8969,
7257,
6000,
9275,
10410,
70581,
-60171,
-60171,
10410,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
290,
139.1379,
152.8966,
1363.0769,
516.6923,
363.8461,
460.2307,
464.7692,
496.1538,
616.3077,
462.7692,
491.9231,
509,
3990.023,
5744.769,
-1754.746,
-1754.746,
3990.023,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FINNIFTY 25 JAN 2023 CE 12500",
"equity",
50,
3450.67,
2568.98,
1150,
1886,
1142,
4223,
3569,
922,
2014,
2594,
2594,
4292,
-44084.5,
24386,
-68470.5,
-68470.5,
44084.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY 23 JAN 2023 CE 15650",
"equity",
100,
175.55,
126.78,
413,
889,
4927,
3468,
4048,
2500,
3454,
2211,
2302,
4240,
-4877,
28452,
-33329,
-33329,
4877,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"BANKNIFTY 01 Jun 2023 CE 44100",
"equity",
25,
363.1,
450.09,
2042,
1503,
2560,
2913,
3807,
806,
2343,
2686,
3601,
3712,
2174.75,
25973,
-23798.25,
-23798.25,
2174.75,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"BANKNIFTY 01 Jun 2023 CE 44200",
"equity",
75,
363.15,
439.94,
4510,
2627,
3787,
4575,
5183,
912,
5359,
2705,
3903,
1972,
5759.25,
35533,
-29773.75,
-29773.75,
5759.25,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY 17 APR 2023 PE 17800",
"equity",
55,
457.89,
489.67,
3285,
2479,
3549,
2207,
887,
4521,
2418,
2583,
3198,
3116,
1747.9,
28243,
-26495.1,
-26495.1,
1747.9,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FINNIFTY 25 MAY 2023 CE 14900",
"equity",
120,
698.03,
745.32,
1449.5385,
3136.4615,
2506.2308,
2420.1538,
3149.4615,
2487.5385,
1381.2308,
1990.5385,
2904.3077,
1452.5385,
5674.8,
22878.0001,
-17203.2001,
-17203.2001,
5674.8,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
"commodity",
150,
428.6667,
444.6667,
297,
277,
303,
306,
343,
285,
167,
301,
362,
157,
2400,
2798,
-398,
-398,
2400,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY 23 JAN 2023 CE 15600",
"equity",
250,
168,
215,
6935,
4559,
5324,
6187,
3541,
5988,
4471,
3705,
7284,
5134,
11750,
53128,
-41378,
-41378,
11750,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"OPTCUR USDINR 27 JAN 2023 83 PE",
"currency",
280,
89.0121,
76.4686,
714,
745,
946,
353,
589,
743,
809,
457,
708,
566,
-3512.18,
6630,
-10142.18,
-10142.18,
3512.18,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"NIFTY 23 FEB 2023 PE 17100",
"equity",
105,
194.9,
191.9857,
2018,
3117,
5055,
3692,
5314,
3776,
2768,
5950,
2079,
4551,
-306.0015,
38320,
-38626.0015,
-38626.0015,
306.0015,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
110,
324.0636,
345.89,
139.4167,
478.0833,
191.3333,
340.5,
286,
402.6667,
451.75,
231.4167,
271.4167,
429.6667,
2400.904,
3222.2501,
-821.3461,
-821.3461,
2400.904,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"OPTCUR EURINR 13 MAY 2023 94 CE",
"currency",
195,
281.7436,
269.7385,
269,
639,
649,
625,
520,
375,
222,
669,
671,
434,
-2340.9945,
5073,
-7413.9945,
-7413.9945,
2340.9945,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"OPTCUR GBPINR 27 OCT 2023 115 PE",
"currency",
75,
4500,
4509,
36,
272,
216,
140,
125,
195,
179,
416,
306,
109,
675,
1994,
-1319,
-1319,
675,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"FINNIFTY 15 FEB 2023 CE 13400",
"equity",
50,
194.9,
174.55,
2524,
4142,
3167,
4280,
1285,
2547,
898,
2368,
1478,
3531,
-1017.5,
26220,
-27237.5,
-27237.5,
1017.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
"BANKNIFTY 20 MAR 2023 PE 18900",
"equity",
155,
1500,
615.89,
1946,
1071,
3214,
3408,
2371,
3297,
4858,
3054,
3132,
4441,
-137037.05,
30792,
-167829.05,
-167829.05,
137037.05,
"business_and_profession",
"non_speculative",
"slab_rate"
]
]
},
{
"name": "option_scripwise_open_position_table",
"@entity": "table",
"header": [
"contract_name",
"asset_class",
"quantity",
"trade_price_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
20,
156,
null,
null
],
[
"OPTFUT GOLD 29 OCT 2023 60000 PE",
"commodity",
55,
124.56,
null,
null
],
[
"FINNIFTY 25 MAY 2023 CE 14900",
"equity",
10,
698.03,
null,
null
],
[
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
50,
332.8476,
null,
null
]
]
}
]
},
{
"name": "bond_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "bond_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_average",
"sell_average",
"cost_of_acquisition",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fee",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INE112J07020",
"IFCI",
170,
16.55,
500,
16.55,
137.3,
131.1,
121.95,
43.6,
62,
164.25,
175.95,
118.3,
95.4,
82186.5,
1049.85,
81136.65,
81136.65,
"short_term",
85000,
"capital_gains",
"securities",
"slab_rate"
],
[
"INE261F07055",
"SGB",
600,
460.3333,
354.1667,
460.3333,
286.4,
186.2,
288.6,
226.2,
151.2,
113.4,
268.6,
152.4,
336.8,
-63699.96,
2009.8,
-65709.76,
-65709.76,
"long_term",
212500.02,
"capital_gains",
"securities",
"10"
],
[
"INE272F07011",
"Blue Dart Express",
20,
20,
200,
20,
122,
48.8,
124,
60.6,
16.2,
121.4,
46,
70.8,
88,
3600,
697.8,
2902.2,
2902.2,
"short_term",
4000,
"capital_gains",
"securities",
"slab_rate"
],
[
"INE130K08000",
"SBOX",
170,
16.55,
500,
16.55,
129,
112.6,
100.65,
84.85,
77,
198.9,
116.55,
201.15,
102.4,
82186.5,
1123.1,
81063.4,
81063.4,
"long_term",
85000,
"capital_gains",
"securities",
"20"
],
[
"INE261F07032",
"07.64% NABARD TFB 2031",
1000,
10,
125,
10,
243,
289,
224,
193,
331,
260,
269,
263,
264,
115000,
2336,
112664,
112664,
"long_term",
125000,
"capital_gains",
"securities",
"10"
],
[
"INE130K08001",
"QCK",
200,
16.55,
500,
16.55,
91,
255,
38,
172,
198,
136,
125,
233,
158,
96690,
1406,
95284,
95284,
"long_term",
100000,
"capital_gains",
"securities",
"20"
],
[
"INE130K08015",
"GGL",
200,
550,
600,
550,
124,
106,
103,
118,
173,
79,
70,
112,
121,
10000,
1006,
8994,
8994,
"long_term",
120000,
"capital_gains",
"securities",
"10"
],
[
"INE130K08019",
"APPL",
180,
350,
310,
350,
214.6,
119.8,
135,
134.6,
94.9,
66.5,
80.3,
163.6,
208.2,
-7200,
1217.5,
-8417.5,
-8417.5,
"short_term",
55800,
"capital_gains",
"securities",
"slab_rate"
]
]
},
{
"name": "bond_scripwise_holding_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE272F07011",
"Blue Dart Express",
30,
20,
null,
null
],
[
"INE112J07020",
"IFCI",
30,
16.55,
null,
null
],
[
"INE130K08000",
"SBOX",
30,
16.55,
null,
null
],
[
"INE130K08019",
"APPL",
20,
350,
null,
null
],
[
"INE261F07055",
"SGB",
500,
327.6,
null,
null
]
]
},
{
"name": "bond_scripwise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"sell_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": []
}
]
},
{
"name": "debenture_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "debenture_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_average",
"sell_average",
"cost_of_acquisation",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
"INE112J07020",
"IFCI",
170,
16.55,
500,
16.55,
191.9,
231.6,
317.2,
337.45,
305.5,
219.05,
249.5,
253.5,
148.25,
82186.5,
2253.95,
79932.55,
79932.55,
"long_term",
85000,
"capital_gains",
"securities",
"10"
],
[
"INE261F07055",
"SGB",
450,
600,
789,
600,
240.5455,
221.6455,
132.0545,
259.3636,
241.2,
118.7182,
345.2727,
210.0273,
313.1182,
85050,
2081.9455,
82968.0545,
82968.0545,
"short_term",
355050,
"capital_gains",
"securities",
"slab_rate"
],
[
"INE261F07055",
"SGB",
150,
793.3333,
822.6667,
793.3333,
359.4545,
339.3545,
314.9455,
225.6364,
415.8,
314.2818,
164.7273,
401.9727,
103.8818,
4400.01,
2640.0545,
1759.9555,
1759.9555,
"long_term",
123400.005,
"capital_gains",
"securities",
"10"
],
[
"INE272F07011",
"Blue Dart Express",
20,
20,
200,
20,
175.4,
207.2,
112.6,
140.8,
139.4,
104,
150.8,
316,
48.4,
3600,
1394.6,
2205.4,
2205.4,
"long_term",
4000,
"capital_gains",
"securities",
"10"
],
[
"INE130K08000",
"SBOX",
170,
16.55,
500,
16.55,
188.8,
192.8,
153.7,
23.45,
261.5,
187.9,
94.1,
227.95,
192.15,
82186.5,
1522.35,
80664.15,
80664.15,
"long_term",
85000,
"capital_gains",
"securities",
"20"
],
[
"INE261F07032",
"07.64% NABARD TFB 2031",
1000,
10,
10,
10,
401,
228,
457,
315,
294,
335,
328,
253,
324,
0,
2935,
-2935,
-2935,
"long_term",
10000,
"capital_gains",
"securities",
"10"
],
[
"INE130K08001",
"QCK",
200,
16.55,
500,
16.55,
211,
354,
419,
175,
173,
346,
281,
132,
417,
96690,
2508,
94182,
94182,
"long_term",
100000,
"capital_gains",
"securities",
"20"
],
[
"INE130K08015",
"GGL",
200,
550,
600,
550,
260,
142,
368,
282,
420,
265,
397,
109,
233,
10000,
2476,
7524,
7524,
"long_term",
120000,
"capital_gains",
"securities",
"10"
],
[
"INE130K08019",
"APPL",
180,
350,
310,
350,
205.5,
409.2,
100.2,
221.2,
170.1,
245.6,
231.5,
58,
305.6,
-7200,
1946.9,
-9146.9,
-9146.9,
"short_term",
55800,
"capital_gains",
"securities",
"slab_rate"
]
]
},
{
"name": "debenture_scripwise_holding_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE272F07011",
"Blue Dart Express",
30,
20,
null,
null
],
[
"INE112J07020",
"IFCI",
30,
16.55,
null,
null
],
[
"INE130K08000",
"SBOX",
30,
16.55,
null,
null
],
[
"INE130K08019",
"APPL",
20,
350,
null,
null
],
[
"INE261F07055",
"SGB",
500,
764,
null,
null
]
]
},
{
"name": "debenture_scripwise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"sell_average",
"last_traded_price",
"unrealized_pnl"
],
"rows": []
}
]
},
{
"name": "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",
"buy_value",
"cost_of_acquisition",
"sell_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
"equity",
"share",
"capital_gains",
"securities",
"short_term",
412458.646,
386142.45,
386142.45,
412458.646,
26316.196,
3583.789,
22732.407,
23090.7859
],
[
"equity",
"share",
"capital_gains",
"securities",
"long_term",
2051586.5276,
998919.4804,
998919.4804,
2051586.5276,
1052667.0472,
9596.053,
1043070.9942,
1044030.5995
],
[
"equity",
"share",
"business_and_profession",
"speculative",
"intraday",
5899.2096,
557381.9328,
557381.9328,
558009.1232,
627.1904,
5320,
-4692.8096,
-4692.8096
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"short_term",
125840.004,
100787.121,
100787.121,
125840.004,
25052.883,
868.25,
24184.633,
24184.633
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"long_term",
186769.40247,
97724.18574,
98974.18574,
186769.40247,
89045.21673,
282.5574,
88762.65933,
87512.65933
],
[
"debt",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"short_term",
29168.115,
1793.73,
1793.73,
29168.115,
27374.385,
166.5909,
27207.7941,
27207.7941
],
[
"debt",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"long_term",
5293.22,
3429.57,
4264.5603,
5293.22,
1863.65,
263.7233,
1599.9267,
764.9364
],
[
"other",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"short_term",
10706.2,
14237.904304,
14237.904304,
10706.2,
-3531.704304,
156.6621,
-3688.366404,
-3688.366404
],
[
"other",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"long_term",
8542.8,
7298.2,
10904.0036,
8542.8,
1244.6,
672.6772,
571.9228,
-3033.8808
],
[
"equity",
"etf",
"capital_gains",
"securities",
"short_term",
22500,
13500,
13500,
22500,
9000,
1439,
7561,
7664
],
[
"equity",
"etf",
"capital_gains",
"securities",
"long_term",
60963.994,
32500.897,
32500.897,
60963.994,
28463.097,
5817.5862,
22645.5108,
23210.9246
],
[
"debt",
"etf",
"capital_gains",
"other_capital_gains",
"short_term",
3157.68,
6315.36,
6315.36,
3157.68,
-3157.68,
2877,
-6034.68,
-5766.68
],
[
"debt",
"etf",
"capital_gains",
"other_capital_gains",
"long_term",
9600,
7200,
7200,
9600,
2400,
1189.5,
1210.5,
1369
],
[
"other",
"etf",
"capital_gains",
"other_capital_gains",
"short_term",
23000,
46107.785,
46107.785,
23000,
-23107.785,
1234.3332,
-24342.1182,
-24223.7849
],
[
"other",
"etf",
"capital_gains",
"other_capital_gains",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"business_and_profession",
"speculative",
"intraday",
11000,
64375,
64375,
53375,
-11000,
3158,
-14158,
-14158
],
[
"debt",
"etf",
"business_and_profession",
"speculative",
"intraday",
12500,
162500,
162500,
150000,
-12500,
1692,
-14192,
-14192
],
[
"other",
"etf",
"business_and_profession",
"speculative",
"intraday",
900,
300,
300,
1200,
900,
731,
169,
169
],
[
"equity",
"future",
"business_and_profession",
"non_speculative",
null,
181749.295,
642549.2,
642549.2,
522096.795,
-120452.405,
30187.5335,
-150639.9385,
-150639.9385
],
[
"commodity",
"future",
"business_and_profession",
"non_speculative",
null,
6390.023,
104649.996,
104649.996,
111040.019,
6390.023,
8542.769,
-2152.746,
-2152.746
],
[
"currency",
"future",
"business_and_profession",
"non_speculative",
null,
17858.157,
453010.386,
453010.386,
450233.1155,
-2777.2705,
16919.2501,
-19696.5206,
-19696.5206
],
[
"equity",
"option",
"business_and_profession",
"non_speculative",
null,
224838.7515,
944059.3,
944059.3,
794253.9485,
-149805.3515,
384506.0001,
-534311.3516,
-534311.3516
],
[
"commodity",
"option",
"business_and_profession",
"non_speculative",
null,
6390.023,
104649.996,
104649.996,
111040.019,
6390.023,
8542.769,
-2152.746,
-2152.746
],
[
"currency",
"option",
"business_and_profession",
"non_speculative",
null,
17858.157,
453010.386,
453010.386,
450233.1155,
-2777.2705,
16919.2501,
-19696.5206,
-19696.5206
],
[
"debt",
"bond",
"capital_gains",
"securities",
"short_term",
144800,
66213.5,
66213.5,
144800,
78586.5,
2965.15,
75621.35,
75621.35
],
[
"debt",
"bond",
"capital_gains",
"securities",
"long_term",
642500.02,
402323.48,
402323.48,
642500.02,
240176.54,
7880.9,
232295.64,
232295.64
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"short_term",
410850,
333000,
333000,
410850,
77850,
4028.8455,
73821.1545,
73821.1545
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"long_term",
527400.005,
248336.995,
248336.995,
527400.005,
279063.01,
15729.9545,
263333.0555,
263333.0555
]
]
},
{
"name": "tax_pnl_summary_table",
"@entity": "table",
"header": [
"income_head",
"income_sub_head",
"holding_period",
"tax_rate",
"turnover",
"buy_value",
"cost_of_acquisition",
"sell_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl"
],
"rows": [
[
"capital_gains",
"securities",
"short_term",
"slab_rate",
555650,
399213.5,
399213.5,
555650,
156436.5,
6993.9955,
149442.5045,
149442.5045
],
[
"capital_gains",
"securities",
"short_term",
"15",
560798.65,
500429.571,
387740.3389,
560798.65,
60369.079,
5891.039,
54478.04,
54939.4189
],
[
"capital_gains",
"securities",
"long_term",
"10",
3099219.94907,
1767558.03814,
1637900.2009,
3099219.94907,
1331661.91093,
32747.6011,
1298914.30983,
1299189.32893
],
[
"capital_gains",
"securities",
"long_term",
"20",
370000,
12247,
12247,
370000,
357753,
6559.45,
351193.55,
351193.55
],
[
"business_and_profession",
"speculative",
"intraday",
"slab_rate",
30299.2096,
784556.9328,
784556.9328,
762584.1232,
-21972.8096,
10901,
-32873.8096,
-32873.8096
],
[
"capital_gains",
"other_capital_gains",
"short_term",
"slab_rate",
66031.995,
68454.779304,
1112.1557,
66031.995,
-2422.784304,
4434.5862,
-6857.370504,
-6471.037204
],
[
"capital_gains",
"other_capital_gains",
"long_term",
"20",
13836.02,
10727.77,
508.12,
13836.02,
3108.25,
936.4005,
2171.8495,
-2268.9444
],
[
"capital_gains",
"other_capital_gains",
"long_term",
"slab_rate",
9600,
7200,
120,
9600,
2400,
1189.5,
1210.5,
1369
],
[
"business_and_profession",
"non_speculative",
null,
"slab_rate",
437226.2495,
2701929.264,
2701929.264,
2438897.0125,
-263032.2515,
465617.5718,
-728649.8233,
-728649.8233
],
[
"other",
"other_exempt_income",
null,
"exempt",
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
}
]
},
"timestamp": "1701860045000"
}