JSON Payload
This API gives response in following two formats:
Tradewise Tax PnL
Click here to learn more about this JSON Payload
{
"name": "tradewise_tax_pnl_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "stock_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "stock_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
},
{
"name": "stock_transaction_summary_table",
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"realised_pnl",
"transafer_expense",
"net_realized_pnl"
],
"rows": [
[
"trade",
3022054.4906,
1079610.8706,
18499.842,
1061111.0286
],
[
"lost",
0.0,
0.0,
0.0,
0.0
],
[
"gift_send",
0.0,
0.0,
0.0,
0.0
],
[
"gift_receive",
0.0,
0.0,
0.0,
0.0
],
[
"transfer_in",
0.0,
0.0,
0.0,
0.0
],
[
"transfer_out",
0.0,
0.0,
0.0,
0.0
],
[
"buy_back",
0.0,
0.0,
0.0,
0.0
],
[
"other",
0.0,
0.0,
0.0,
0.0
]
]
},
{
"name": "stock_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE01C001018",
"ADANIPORTS",
48.0,
1631145600000,
270.0,
"buy",
null,
null,
null
],
[
"INE01C001018",
"ADANIPORTS",
20.0,
1692144000000,
429.0,
"buy",
null,
null,
null
],
[
"INE364U01010",
"ADANIGREEN",
7.0,
1683763200000,
310.0,
"buy",
null,
null,
null
],
[
"INE364U01010",
"ADANIGREEN",
20.0,
1689206400000,
290.0,
"buy",
null,
null,
null
],
[
"INE767A01016",
"ADANIENT",
57.0,
1658016000000,
1950.0,
"buy",
null,
null,
null
],
[
"INE767A01016",
"ADANIENT",
23.0,
1681948800000,
2016.0,
"buy",
null,
null,
null
],
[
"INE01C001018",
"ADANIPORTS",
10.0,
1689638400000,
410.0,
"buy",
null,
null,
null
],
[
"INE03Q201024",
"GLS",
50.0,
1499644800000,
5000.0,
"buy",
null,
null,
null
]
]
},
{
"name": "stock_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"sell_date",
"sell_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE00E101023",
"BIKAJI",
260.0,
1693440000000,
370.0,
"sell",
null,
null,
null
],
[
"INE03Q201024",
"GLS",
50.0,
1689811200000,
5000.0,
"sell",
null,
null,
null
]
]
},
{
"name": "stock_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_acquisition",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"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": [
[
"INE002A01018",
"AJANTAPHARMA",
true,
true,
645.0,
"CJ1CLC4YCBFEZ4CVDNMH",
1463356800000,
136.0,
"CYX9TQSTWUYK8C9Z7BCE",
1650412800000,
580.0,
null,
136.0,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
"trade",
286380.0,
640.981,
285739.019,
285803.1171,
"long_term",
374100.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE002A01018",
"AJANTAPHARMA",
true,
true,
900.0,
"CJ1CLC4YCBFEZ4CVDNMH",
1463356800000,
136.0,
"3S1E2CVMTK3I115OG5IT",
1672876800000,
618.0,
null,
136.0,
71.4113,
71.4113,
71.4113,
71.4113,
71.4113,
71.4113,
71.4113,
71.4113,
71.4113,
71.4113,
"trade",
433800.0,
714.113,
433085.887,
433157.2983,
"long_term",
556200.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE002A01018",
"AJANTAPHARMA",
true,
true,
45.0,
"CJ1CLC4YCBFEZ4CVDNMH",
1463356800000,
136.0,
"HJWC2DJPNJV7KBYAVLMP",
1692921600000,
689.0,
null,
136.0,
12.0906,
12.0906,
12.0906,
12.0906,
12.0906,
12.0906,
12.0906,
12.0906,
12.0906,
12.0906,
"trade",
24885.0,
120.906,
24764.094,
24776.1846,
"long_term",
31005.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE002A01018",
"AJANTAPHARMA",
true,
true,
145.0,
"J9SYLEPLST8YFGPUOFCG",
1686182400000,
578.0,
"HJWC2DJPNJV7KBYAVLMP",
1692921600000,
689.0,
null,
578.0,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
"trade",
16095.0,
804.0,
15291.0,
15371.4,
"short_term",
99905.0,
"capital_gains",
"securities",
"15",
"111A"
],
[
"INE462A01022",
"BAYERCROP",
true,
true,
25.0,
"SUNMAQYIBRDSM4Y2TVW9",
1436313600000,
4203.45,
"8LWK9OAGZ64HKNYHYX6H",
1681862400000,
4217.67,
null,
4203.45,
82.3742,
82.3742,
82.3742,
82.3742,
82.3742,
82.3742,
82.3742,
82.3742,
82.3742,
82.3742,
"trade",
355.5,
823.742,
-468.242,
-385.8678,
"long_term",
105441.75,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE462A01022",
"BAYERCROP",
true,
true,
6.0,
"PEB6U5ERJBDTNFSLPOI2",
1482451200000,
4089.0,
"8LWK9OAGZ64HKNYHYX6H",
1681862400000,
4217.67,
null,
4089.0,
16.2204,
16.2204,
16.2204,
16.2204,
16.2204,
16.2204,
16.2204,
16.2204,
16.2204,
16.2204,
"trade",
772.02,
162.204,
609.816,
626.0364,
"long_term",
25306.02,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE462A01022",
"BAYERCROP",
true,
true,
19.0,
"PEB6U5ERJBDTNFSLPOI2",
1482451200000,
4089.0,
"ROJM9PXLTVRGADTWZXMX",
1684454400000,
4237.9474,
null,
4089.0,
114.6162,
114.6162,
114.6162,
114.6162,
114.6162,
114.6162,
114.6162,
114.6162,
114.6162,
114.6162,
"trade",
2830.0006,
1146.162,
1683.8386,
1798.4548,
"long_term",
80521.0006,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE462A01022",
"BAYERCROP",
true,
true,
12.0,
"PEB6U5ERJBDTNFSLPOI2",
1482451200000,
4089.0,
"1JQ2PDASHYXZCVH6IFTC",
1693440000000,
4278.08,
null,
4089.0,
22.6063,
22.6063,
22.6063,
22.6063,
22.6063,
22.6063,
22.6063,
22.6063,
22.6063,
22.6063,
"trade",
2268.96,
226.063,
2042.897,
2065.5033,
"long_term",
51336.96,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE462A01022",
"BAYERCROP",
true,
true,
29.0,
"ZR0GPABQCZJDEBAVL85E",
1682726400000,
4198.05,
"1JQ2PDASHYXZCVH6IFTC",
1693440000000,
4278.08,
null,
4198.05,
64.4914,
64.4914,
64.4914,
64.4914,
64.4914,
64.4914,
64.4914,
64.4914,
64.4914,
64.4914,
"trade",
2320.87,
644.914,
1675.956,
1740.4474,
"short_term",
124064.32,
"capital_gains",
"securities",
"15",
"111A"
],
[
"INE462A01022",
"BAYERCROP",
true,
true,
29.0,
"G3NSSV7XHVFUJ8BTPBIR",
1689120000000,
4221.0,
"1JQ2PDASHYXZCVH6IFTC",
1693440000000,
4278.08,
null,
4221.0,
64.4915,
64.4915,
64.4915,
64.4915,
64.4915,
64.4915,
64.4915,
64.4915,
64.4915,
64.4915,
"trade",
1655.32,
644.915,
1010.405,
1074.8965,
"short_term",
124064.32,
"capital_gains",
"securities",
"15",
"111A"
],
[
"INE01C001018",
"ADANIPORTS",
true,
true,
256.0,
"KQN4SO7YRL1T1YKS8XSO",
1631145600000,
270.0,
"K0TMWRLU5HDBSNDITGWA",
1682640000000,
409.0,
null,
270.0,
79.1448,
79.1448,
79.1448,
79.1448,
79.1448,
79.1448,
79.1448,
79.1448,
79.1448,
79.1448,
"trade",
35584.0,
791.448,
34792.552,
34871.6968,
"long_term",
104704.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE01C001018",
"ADANIPORTS",
true,
true,
44.0,
"KQN4SO7YRL1T1YKS8XSO",
1631145600000,
270.0,
"USTNCKBL23ZGYFBS1FWW",
1682899200000,
418.0,
null,
270.0,
51.3655,
51.3655,
51.3655,
51.3655,
51.3655,
51.3655,
51.3655,
51.3655,
51.3655,
51.3655,
"trade",
6512.0,
513.655,
5998.345,
6049.7105,
"long_term",
18392.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
110.0,
"VTHPFZ7KXVG5LMNZNBHT",
1592611200000,
189.0,
"YHEZMWYMV85DIO52CY1B",
1676332800000,
257.0,
null,
189.0,
48.8571,
48.8571,
48.8571,
48.8571,
48.8571,
48.8571,
48.8571,
48.8571,
48.8571,
48.8571,
"trade",
7480.0,
488.571,
6991.429,
7040.2861,
"long_term",
28270.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
640.0,
"VTHPFZ7KXVG5LMNZNBHT",
1592611200000,
189.0,
"IAVLRAW3OKLIHPD0DLKQ",
1677283200000,
265.0,
null,
189.0,
64.5507,
64.5507,
64.5507,
64.5507,
64.5507,
64.5507,
64.5507,
64.5507,
64.5507,
64.5507,
"trade",
48640.0,
645.507,
47994.493,
48059.0437,
"long_term",
169600.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
250.0,
"VTHPFZ7KXVG5LMNZNBHT",
1592611200000,
189.0,
"7UBKDTDSUWJEWXI71MB5",
1682640000000,
317.0,
null,
189.0,
53.0026,
53.0026,
53.0026,
53.0026,
53.0026,
53.0026,
53.0026,
53.0026,
53.0026,
53.0026,
"trade",
32000.0,
530.026,
31469.974,
31522.9766,
"long_term",
79250.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
260.0,
"VTHPFZ7KXVG5LMNZNBHT",
1592611200000,
189.0,
"SVYLOESSMFAWL2P1V4YN",
1684454400000,
334.0,
null,
189.0,
53.2987,
53.2987,
53.2987,
53.2987,
53.2987,
53.2987,
53.2987,
53.2987,
53.2987,
53.2987,
"trade",
37700.0,
532.987,
37167.013,
37220.3117,
"long_term",
86840.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
280.0,
"VTHPFZ7KXVG5LMNZNBHT",
1592611200000,
189.0,
"T2D14C472FNCQD8A9SEL",
1689897600000,
339.0,
null,
189.0,
25.7813,
25.7813,
25.7813,
25.7813,
25.7813,
25.7813,
25.7813,
25.7813,
25.7813,
25.7813,
"trade",
42000.0,
257.813,
41742.187,
41767.9683,
"long_term",
94920.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
435.0,
"YKSLVQ6HJEUROPF8Z7TL",
1602547200000,
209.0,
"T2D14C472FNCQD8A9SEL",
1689897600000,
339.0,
null,
209.0,
72.7726,
72.7726,
72.7726,
72.7726,
72.7726,
72.7726,
72.7726,
72.7726,
72.7726,
72.7726,
"trade",
56550.0,
727.726,
55822.274,
55895.0466,
"long_term",
147465.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
15.0,
"XEPL8VAO3PWPBVZRBSCE",
1631923200000,
221.0,
"T2D14C472FNCQD8A9SEL",
1689897600000,
339.0,
null,
221.0,
4.357,
4.357,
4.357,
4.357,
4.357,
4.357,
4.357,
4.357,
4.357,
4.357,
"trade",
1770.0,
43.57,
1726.43,
1730.787,
"long_term",
5085.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
185.0,
"XEPL8VAO3PWPBVZRBSCE",
1631923200000,
221.0,
"IHQR3WDABXX5LWECAVD4",
1690675200000,
345.0,
null,
221.0,
66.3519,
66.3519,
66.3519,
66.3519,
66.3519,
66.3519,
66.3519,
66.3519,
66.3519,
66.3519,
"trade",
22940.0,
663.519,
22276.481,
22342.8329,
"long_term",
63825.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
85.0,
"XEPL8VAO3PWPBVZRBSCE",
1632009600000,
225.0,
"IHQR3WDABXX5LWECAVD4",
1690675200000,
345.0,
null,
225.0,
56.706,
56.706,
56.706,
56.706,
56.706,
56.706,
56.706,
56.706,
56.706,
56.706,
"trade",
10200.0,
567.06,
9632.94,
9689.646,
"long_term",
29325.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
79.0,
"KZ4XUMQL7O4OL1T0NWLW",
1686787200000,
327.0,
"IHQR3WDABXX5LWECAVD4",
1690675200000,
345.0,
null,
327.0,
36.0535,
36.0535,
36.0535,
36.0535,
36.0535,
36.0535,
36.0535,
36.0535,
36.0535,
36.0535,
"trade",
1422.0,
360.535,
1061.465,
1097.5185,
"short_term",
27255.0,
"capital_gains",
"securities",
"15",
"111A"
],
[
"INE00E101023",
"BIKAJI",
true,
true,
61.0,
"KZ4XUMQL7O4OL1T0NWLW",
1686787200000,
327.0,
"ZJZZOQLJZWYQRMSHK2E3",
1693440000000,
370.0,
null,
327.0,
28.534,
28.534,
28.534,
28.534,
28.534,
28.534,
28.534,
28.534,
28.534,
28.534,
"trade",
2623.0,
285.34,
2337.66,
2366.194,
"short_term",
22570.0,
"capital_gains",
"securities",
"15",
"111A"
],
[
"INE364U01010",
"ADANIGREEN",
true,
true,
40.0,
"ZDUUQFIZKFI1LPZJIGC1",
1683763200000,
310.0,
"OCFAGNA9WLZOS2GPVEWY",
1685059200000,
365.0,
null,
310.0,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
"trade",
2200.0,
844.085,
1355.915,
1440.3235,
"short_term",
14600.0,
"capital_gains",
"securities",
"15",
"111A"
]
]
},
{
"name": "stock_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": [
[
"INE010B01019",
"CADILAHC",
254.0,
"VQLDME6IOJZR95BDEKQ9",
1692316800000,
1290.98,
"VXFUFI5Q9HH7FEJPLV3B",
1692403200000,
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.0,
1831.2,
1831.2,
2743.2,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE01C001018",
"ADANIPORTS",
20.0,
"RZ4TQQXBXGQZ4CIGW89W",
1689638400000,
410.0,
"AMLDHHSPBR225CYDH1G3",
1689552000000,
436.0,
76.0,
76.0,
76.0,
76.0,
76.0,
76.0,
76.0,
76.0,
76.0,
76.0,
520.0,
760.0,
-240.0,
-240.0,
520.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE462A01022",
"BAYERCROP",
25.0,
"RP9WLFA5LS29NBTKARXN",
1686960000000,
4254.0,
"UCB2JO0JMYBFRYRHILMZ",
1686960000000,
4239.0,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
-375.0,
912.0,
-1287.0,
-1287.0,
375.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE00E101023",
"BIKAJI",
85.0,
"90VSCSRGLVSHW6FYHQDE",
1678665600000,
269.0,
"DLQMNK7WJJEH6SZOCZO6",
1678665600000,
273.0,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
340.0,
912.0,
-572.0,
-572.0,
340.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE00E101023",
"BIKAJI",
267.0,
"KZ4XUMQL7O4OL1T0NWLW",
1686873600000,
329.0,
"UZB55NEDOEZEB81QTBOI",
1686960000000,
321.0,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
-2136.0,
912.0,
-3048.0,
-3048.0,
2136.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE364U01010",
"ADANIGREEN",
15.0,
"OUYO53NES6HVEGSBXALX",
1680652800000,
281.0,
"JOVR7LN5HKWR3H7LR3LK",
1680652800000,
250.0,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
-465.0,
912.0,
-1377.0,
-1377.0,
465.0,
"business_and_profession",
"speculative",
"slab_rate"
]
]
}
]
},
{
"name": "mutual_fund_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "mutual_fund_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
},
{
"name": "mutual_fund_transaction_summary_table",
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"realised_pnl",
"transafer_expense",
"net_realized_pnl"
],
"rows": [
[
"trade",
366319.765,
141049.054956,
2410.4609,
138638.594056
],
[
"lost",
0.0,
0.0,
0.0,
0.0
],
[
"gift_send",
0.0,
0.0,
0.0,
0.0
],
[
"gift_receive",
0.0,
0.0,
0.0,
0.0
],
[
"transfer_in",
0.0,
0.0,
0.0,
0.0
],
[
"transfer_out",
0.0,
0.0,
0.0,
0.0
],
[
"buy_back",
0.0,
0.0,
0.0,
0.0
],
[
"other",
0.0,
0.0,
0.0,
0.0
]
]
},
{
"name": "mutual_fund_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"type",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
50.0,
1491436800000,
124.2586,
"buy",
null,
null
],
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
19.393,
1589414400000,
10.0,
"buy",
null,
null
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
16.062,
1563667200000,
60.0,
"buy",
null,
null
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
35.0,
1585008000000,
230.0,
"buy",
null,
null
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
35.706,
1626739200000,
60.0,
"buy",
null,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
31.78,
1481500800000,
150.0,
"buy",
null,
null
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
15.134,
1437177600000,
15.0,
"buy",
null,
null
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
2.508,
1626912000000,
400.784,
"buy",
null,
null
],
[
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
229.0,
1670716800000,
193.6681,
"buy",
null,
null
]
]
},
{
"name": "mutual_fund_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"sell_date",
"sell_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
17.137,
1682640000000,
160.0,
"sell",
null,
null
]
]
},
{
"name": "mutual_fund_tradewise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"is_listed",
"is_stt_paid",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"cost_of_acquisition",
"nature_of_settlement",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"holding_period",
"turnover",
"income_head",
"income_sub_head",
"tax_rate",
"section"
],
"rows": [
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
true,
true,
355.9,
"GGFCHMYLKDQY9RRINTGH",
1491436800000,
124.2586,
"JHF78MYGKDQY9RRINTGH",
1662940800000,
212.7,
20,
124.2586,
"trade",
31476.2943,
68.1534,
31408.1409,
31408.1409,
"long_term",
75699.93,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
true,
true,
250,
"GGFCHMYLKDQY9RRINTGH",
1491436800000,
124.2586,
"JTR59NOGKDQY9YTINTGH",
1670630400000,
209,
20,
124.2586,
"trade",
21185.35,
103.2055,
21082.1445,
21082.1445,
"long_term",
52250.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INF200K01190",
"KOTAK SEC FUND",
"equity",
true,
true,
40,
"GHN78NOGKDQY9YTINFGHY",
1633564800000,
980,
"VBN59NOGKDQY9YTINFGRN",
1634169600000,
1200,
800,
980.0,
"trade",
8800.0,
346.0,
8454.0,
8454.0,
"short_term",
48000.0,
"capital_gains",
"securities",
"15",
"111A"
],
[
"INF200K01190",
"KOTAK SEC FUND",
"equity",
true,
true,
10,
"GHN78NOGKDQY9YTINFGHY",
1633564800000,
980,
"67859NOGKDQY9YTINFGRN",
1634342400000,
1300,
800,
980.0,
"trade",
3200.0,
78.0,
3122.0,
3122.0,
"short_term",
13000.0,
"capital_gains",
"securities",
"15",
"111A"
],
[
"INF200K01190",
"KOTAK SEC FUND",
"equity",
true,
true,
40,
"XCT59NOGKDQY9YTINFGRN",
1639872000000,
1000,
"67859NOGKDQY9YTINFGRN",
1634342400000,
1300,
800,
1000.0,
"trade",
12000.0,
394.0,
11606.0,
11606.0,
"short_term",
52000.0,
"capital_gains",
"securities",
"15",
"111A"
],
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
17.823,
"BVNCH72LKDQY9RRINTGH",
1589414400000,
10,
"KHF78MYGKDQY9RRINTGH",
1650672000000,
5,
0,
10.0,
"trade",
-89.115,
66.9329,
-156.0479,
-156.0479,
"short_term",
89.115,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
19.574,
"BNG57MYGKDQY9RRINTGH",
1515456000000,
120,
"GHN78MYGKDQY9RRINTGH",
1682640000000,
160,
5,
153.53,
"trade",
782.96,
95.7233,
687.2367,
30.9205,
"long_term",
3131.84,
"capital_gains",
"other_capital_gains",
"20",
"112"
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
true,
true,
35,
"HJM98MYGKDQY9RRINGFB",
1374624000000,
200,
"RTV678MYGKDQY9RRINTGH",
1649289600000,
210,
180,
300.91,
"trade",
350.0,
624.6364,
-274.6364,
-3806.4864,
"long_term",
7350.0,
"capital_gains",
"other_capital_gains",
"20",
"112"
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
true,
true,
20,
"BLKMN98HJNMDQY9RRINTGH",
1563667200000,
60,
"RTV678MYGKDQY9RRINTGH",
1649289600000,
210,
180,
60.0,
"trade",
3000.0,
48.0936,
2951.9064,
2951.9064,
"short_term",
4200.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
"INF760K01FR2",
"Canara Robeco Bluechip Equity Growth Direct Plan",
"equity",
true,
true,
155,
"KNT59NOGKDQY897TINFTR",
1576022400000,
23.78,
"HYT59NOGKDQY9YTINFGRN",
1633996800000,
56.9,
45,
23.78,
"trade",
5133.6,
4.0,
5129.6,
5129.6,
"long_term",
8819.5,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
25.68,
"GMFCH72LKDQY9RRINTGH",
1556409600000,
459,
"GMFCH72LKDQY9RRINTGH",
1556409600000,
500,
220,
459.0,
"trade",
1052.88,
50.25,
1002.63,
1002.63,
"short_term",
12840.0,
"capital_gains",
"securities",
"15",
"111A"
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
125,
"GHNR59NOHJDQ901TINTLK",
1481500800000,
150,
"HNT59NOGKDQY897TINF4R",
1670889600000,
400,
160,
160.0,
"trade",
31250.0,
107.1985,
31142.8015,
29892.8015,
"long_term",
50000.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
true,
true,
36.023,
"GJK45MYGKDQY9RRINTGH",
1493769600000,
30,
"BHM88MYGKDQY9RRINTGH",
1626480000000,
60,
10,
34.96,
"trade",
1080.69,
168.0,
912.69,
734.0159,
"long_term",
2161.38,
"capital_gains",
"other_capital_gains",
"20",
"112"
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
true,
true,
19.88,
"GHL909MYGKDQY9RRINTGH",
1437177600000,
15,
"BHM88MTYH6QY9RRINTGH",
1626652800000,
60,
17,
18.72,
"trade",
894.6,
48.0408,
846.5592,
772.6056,
"long_term",
1192.8,
"capital_gains",
"other_capital_gains",
"20",
"112"
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
true,
true,
32.531,
"MJK88MYGKDQY9RRINTGH",
1626912000000,
400.784,
"CVH78MYGKDQY9RRINTGH",
1690070400000,
200,
200,
400.784,
"trade",
-6531.7043,
108.5685,
-6640.2728,
-6640.2728,
"short_term",
6506.2,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
true,
true,
32.31,
"TGFCH72LKDQY9RRINTGH",
1525824000000,
50,
"KGFCH72LKDQY9RRINTGH",
1577664000000,
900,
1000,
50.0,
"trade",
27463.5,
99.658,
27363.842,
27363.842,
"short_term",
29079.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
]
]
}
]
},
{
"name": "etf_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "etf_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
},
{
"name": "etf_transaction_summary_table",
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"realised_pnl",
"transafer_expense",
"net_realized_pnl"
],
"rows": [
[
"trade",
323796.68,
-9002.362,
18138.4194,
-27140.7814
],
[
"lost",
0.0,
0.0,
0.0,
0.0
],
[
"gift_send",
0.0,
0.0,
0.0,
0.0
],
[
"gift_receive",
0.0,
0.0,
0.0,
0.0
],
[
"transfer_in",
0.0,
0.0,
0.0,
0.0
],
[
"transfer_out",
0.0,
0.0,
0.0,
0.0
],
[
"other",
0.0,
0.0,
0.0,
0.0
]
]
},
{
"name": "etf_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INF179KB1QR8",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
75.0,
1658620800000,
150.0,
"buy",
null,
null
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
20.0,
1568160000000,
120.0,
"buy",
null,
null
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
50.0,
1627862400000,
400.784,
"buy",
null,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
15.0,
1493769600000,
236.2069,
"buy",
null,
null
]
]
},
{
"name": "etf_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"sell_date",
"sell_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": []
},
{
"name": "etf_delivery_tradewise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"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": [
[
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
true,
true,
100.0,
"BHM88MYGKDQY9RRINTGH",
1682380800000,
60.0,
"GJK45MYGKDQY9RRINTGH",
1681948800000,
30.0,
10,
60.0,
211.0,
100.0,
140.0,
144.0,
222.0,
134.0,
107.0,
202.0,
104.0,
14.0,
"trade",
-3000.0,
1378.0,
-4378.0,
-4156.0,
"short_term",
3000.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
true,
true,
78.0,
"JNV5CHMYLKDQY9RRINTG",
1589414400000,
23.0,
"GGFCHMYLKDQY9RRINTGH",
1650672000000,
88.0,
20,
23.0,
185.0,
52.0,
188.0,
160.0,
151.0,
251.0,
139.0,
207.0,
116.0,
155.0,
"trade",
5070.0,
1604.0,
3466.0,
3617.0,
"long_term",
6864.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
31.536,
"BVNCH72LKDQY9RRINTGH",
1660089600000,
10.0,
"KHF78MYGKDQY9RRINTGH",
1677628800000,
5.0,
340,
10.0,
226.0,
145.0,
95.0,
235.0,
46.0,
39.0,
196.0,
165.0,
142.0,
210.0,
"trade",
-157.68,
1499.0,
-1656.68,
-1610.68,
"short_term",
157.68,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
60.0,
"BNG57MYGKDQY9RRINTGH",
1568160000000,
120.0,
"GHN78MYGKDQY9RRINTGH",
1694044800000,
160.0,
250,
120.0,
155.25,
152.75,
96.0,
119.75,
158.5,
69.25,
42.75,
200.5,
94.75,
100.0,
"trade",
2400.0,
1189.5,
1210.5,
1369.0,
"long_term",
9600.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
true,
true,
100.0,
"MJK88MYGKDQY9RRINTGH",
1627862400000,
400.784,
"CVH78MYGKDQY9RRINTGH",
1685059200000,
200.0,
200,
400.784,
123.3333,
63.3333,
73.3333,
26.0,
60.3333,
15.3333,
21.6667,
60.6667,
35.3333,
70.0,
"trade",
-20078.4,
549.3332,
-20627.7332,
-20567.3999,
"short_term",
20000.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
true,
true,
50.0,
"BLKMN98HJNMDQY9RRINTGH",
1641427200000,
120.5877,
"BHMGP79GKDQY9RRINTGH",
1640822400000,
60.0,
65,
120.5877,
71.0,
76.0,
107.0,
74.0,
58.0,
90.0,
23.0,
57.0,
79.0,
50.0,
"trade",
-3029.385,
685.0,
-3714.385,
-3656.385,
"short_term",
3000.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
30.0,
"DFGR59NOHJDQ751TINTJK",
1493769600000,
236.2069,
"GHNR59NOHJDQ901TINTLK",
1563321600000,
450.0,
160,
236.2069,
28.0,
114.6897,
151.0345,
108.8621,
75.1724,
53.7241,
71.8966,
38.6207,
111.2759,
126.5517,
"trade",
6413.793,
879.8277,
5533.9653,
5609.1377,
"long_term",
13500.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
80.0,
"DFGR59NOHJDQ751TINTJK",
1493769600000,
236.2069,
"HNT59NOGKDQY897TINF4R",
1599696000000,
500.0,
160,
236.2069,
100.0,
123.1724,
151.7586,
174.9655,
248.7931,
98.9311,
146.7241,
178.6552,
236.0689,
225.1379,
"trade",
21103.448,
1684.2068,
19419.2412,
19668.0343,
"long_term",
40000.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
10.0,
"DFGR59NOHJDQ751TINTJK",
1493769600000,
236.2069,
"KNT59NOGKDQY897TINFTR",
1627603200000,
10.0,
160,
236.2069,
65.0,
151.8965,
146.3448,
16.6207,
57.7241,
52.2414,
15.9655,
131.2069,
119.7586,
147.5173,
"trade",
-2262.069,
904.2758,
-3166.3448,
-3108.6207,
"long_term",
100.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
10.0,
"DFGR59NOHJDQ751TINTJK",
1493769600000,
236.2069,
"HYT59NOGKDQY9YTINFGRN",
1658361600000,
50.0,
160,
236.2069,
92.0,
48.8966,
133.3448,
73.6207,
32.7242,
13.2414,
66.9655,
30.2069,
159.7586,
94.5172,
"trade",
-1862.069,
745.2759,
-2607.3449,
-2574.6207,
"long_term",
500.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
true,
true,
90.0,
"PKF88MYGKDQY9RRINTGH",
1515456000000,
150.0,
"PKF88MYGKDQY9RRINTGH",
1515369600000,
250.0,
100,
150.0,
187.0,
148.0,
84.0,
194.0,
103.0,
144.0,
89.0,
77.0,
154.0,
259.0,
"trade",
9000.0,
1439.0,
7561.0,
7664.0,
"short_term",
22500.0,
"capital_gains",
"securities",
"15",
"111A"
]
]
},
{
"name": "etf_intraday_tradewise_tax_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_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_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.0,
"HNM88JKGKDQY9RRINGFB",
1666828800000,
125.0,
"GJK48MYGKDQY9RRINGFB",
1666828800000,
45.0,
58.0,
223.0,
275.0,
87.0,
82.0,
192.0,
279.0,
110.0,
211.0,
97.0,
-6000.0,
1614.0,
-7614.0,
-7614.0,
6000.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
20.0,
"GHL909MYGKDQY9RRINTGH",
1668038400000,
15.0,
"BHM88MTYH6QY9RRINTGH",
1668038400000,
60.0,
80.0,
57.0,
95.0,
39.0,
16.0,
100.0,
34.0,
142.0,
145.0,
23.0,
900.0,
731.0,
169.0,
169.0,
900.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
250.0,
"TGFCH72LKDQY9RRINTGH",
1651363200000,
650.0,
"KGFCH72LKDQY9RRINTGH",
1651363200000,
600.0,
134.0,
83.0,
241.0,
199.0,
265.0,
158.0,
193.0,
206.0,
113.0,
100.0,
-12500.0,
1692.0,
-14192.0,
-14192.0,
12500.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
100.0,
"GMFCH72LKDQY9RRINTGH",
1683590400000,
550.0,
"FGN89H72LKDQY9RRINTKL",
1683590400000,
500.0,
154.0,
215.0,
271.0,
48.0,
238.0,
142.0,
90.0,
62.0,
219.0,
105.0,
-5000.0,
1544.0,
-6544.0,
-6544.0,
5000.0,
"business_and_profession",
"speculative",
"slab_rate"
]
]
}
]
},
{
"name": "future_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "future_tradewise_open_position_table",
"@entity": "table",
"header": [
"isin",
"contract_name",
"asset_class",
"quantity",
"trade_date",
"trade_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
null,
"FUTCOM GOLD 29 OCT 2023",
"commodity",
55.0,
1694995200000,
124.56,
"sell",
null,
null,
null
],
[
null,
"NIFTY 17 APR 2023 FUT",
"equity",
10.0,
1679616000000,
457.89,
"buy",
null,
null,
null
],
[
null,
"FINNIFTY 20 MAY 2023 FUT",
"equity",
10.0,
1682726400000,
698.03,
"buy",
null,
null,
null
],
[
null,
"FUTCUR JPYINR 24 AUG 2023",
"currency",
10.0,
1690848000000,
345.89,
"sell",
null,
null,
null
],
[
null,
"FUTCUR JPYINR 24 AUG 2023",
"currency",
40.0,
1692230400000,
329.587,
"sell",
null,
null,
null
],
[
null,
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
20.0,
1668902400000,
156.0,
"sell",
null,
null,
null
]
]
},
{
"name": "future_tradewise_tax_pnl_table",
"@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_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
null,
"NIFTY 15 JAN 2023 FUT",
"equity",
25,
"Z0FCJBWODSL8GF3KKVPY",
1673481600000,
168,
"VLNYY0FTJTUGELL1TK8D",
1672185600000,
146,
107.7,
60.3,
3.8,
136.4,
221.4,
427.6,
12.2,
13.1,
58.5,
44.7,
"trade",
-550.0,
1085.7,
-1635.7,
-1635.7,
550.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 15 JAN 2023 FUT",
"equity",
75,
"Z0FCJBWODSL8GF3KKVPY",
1673481600000,
168,
"VLNYY0FTJTUGELL1TK8D",
1672531200000,
158,
62.1,
126.9,
30.4,
169.2,
96.2,
155.8,
53.6,
181.3,
144.5,
8.1,
"trade",
-750.0,
1028.1,
-1778.1,
-1778.1,
750.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 15 JAN 2023 FUT",
"equity",
150,
"Z0FCJBWODSL8GF3KKVPY",
1673481600000,
168,
"VY3TYTSPMWLYJQAEMGTZ",
1674259200000,
255,
154.2,
75.8,
46.8,
348.4,
214.4,
196.6,
171.2,
109.6,
55,
45.2,
"trade",
13050.0,
1417.2,
11632.8,
11632.8,
13050.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"BANKNIFTY 20 MAR 2023 FUT",
"equity",
125,
"8LEGU2BN0HXVHXYBIIRZ",
1676505600000,
1500,
"BYSC5G1EPZIWIJJ6BAUB",
1679097600000,
615.89,
163,
136,
43,
365,
210,
795,
289,
231,
294,
28,
"trade",
-110513.75,
2554.0,
-113067.75,
-113067.75,
110513.75,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FINNIFTY 15 FEB 2023 FUT",
"equity",
155,
"NKN2PS2TJZWDA9CDP1RA",
1674086400000,
194.9,
"9ZLDZGRMJBSSAIJTBTHN",
1675814400000,
174.55,
169,
118,
141,
341,
338,
281,
40,
181,
75,
66,
"trade",
-3154.25,
1750.0,
-4904.25,
-4904.25,
3154.25,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 FEB 2023 FUT",
"equity",
55,
"TWF45MCZTDWEWSJXU3EF",
1675296000000,
194.9,
"RHSYRUIXEC7M4HJBK46H",
1675987200000,
174.8,
126.7143,
119.6286,
51.4571,
93.6857,
401.6857,
465.6286,
177.6,
29.2,
75.6286,
33.8286,
"trade",
-1105.5,
1575.0572,
-2680.5572,
-2680.5572,
1105.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 FEB 2023 FUT",
"equity",
120,
"TWF45MCZTDWEWSJXU3EF",
1675296000000,
194.9,
"I3RI1TXUYSFLFU4N8IWZ",
1676764800000,
210.89,
149.2857,
115.3714,
133.5429,
318.3143,
507.3143,
431.3714,
160.4,
179.8,
86.3714,
60.1714,
"trade",
1918.8,
2141.9428,
-223.1428,
-223.1428,
1918.8,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 FUT",
"equity",
25,
"5NGIOMFGDRBG5Q8XTNBP",
1670457600000,
147.89,
"CJLNLY40ORWJXUKGVC8E",
1671408000000,
135.67,
116.6667,
115.6667,
38,
94.3333,
133.3333,
372,
162,
51,
108.6667,
15.3333,
"trade",
-305.5,
1207.0,
-1512.5,
-1512.5,
305.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 FUT",
"equity",
45,
"5NGIOMFGDRBG5Q8XTNBP",
1670457600000,
147.89,
"GFHNW8Q8GH4F408UZQ0M",
1672358400000,
129.89,
217.8,
114.4,
60.4,
60.6,
357,
341.6,
209.2,
97,
210.8,
48.2,
"trade",
-810.0,
1717.0,
-2527.0,
-2527.0,
810.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 FUT",
"equity",
5,
"5NGIOMFGDRBG5Q8XTNBP",
1670457600000,
147.89,
"LL4ESNCPAINCWUTVOYKX",
1673568000000,
147.89,
14.8333,
9.6333,
3.4,
12.7667,
14.9667,
31.5,
15.4,
14.9,
18.8333,
3.3667,
"trade",
0.0,
139.6,
-139.6,
-139.6,
0.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 FUT",
"equity",
45,
"ANH3LZISNL7R8DPFNHJ0",
1671840000000,
153.89,
"LL4ESNCPAINCWUTVOYKX",
1673568000000,
147.89,
77.94,
81.9,
8.28,
124.74,
136.26,
239.94,
81.36,
95.22,
132.3,
10.98,
"trade",
-270.0,
988.92,
-1258.92,
-1258.92,
270.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 FUT",
"equity",
80,
"ANH3LZISNL7R8DPFNHJ0",
1671840000000,
153.89,
"WI62KWVR0MYO0WXLDQ4J",
1674172800000,
150,
63.76,
88.4,
69.92,
286.56,
201.44,
188.96,
31.04,
32.88,
145.4,
21.12,
"trade",
-311.2,
1129.48,
-1440.68,
-1440.68,
311.2,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCUR EURINR 13 MAY 2023",
"currency",
50,
"V7L7EV2WB1F06YIJSHQS",
1680134400000,
260.7,
"UVSIUTXLTZHDRHICW9C0",
1680134400000,
245.78,
224,
390,
338,
444,
277,
191,
141,
329,
324,
243,
"trade",
-746.0,
2901.0,
-3647.0,
-3647.0,
746.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCUR EURINR 13 MAY 2023",
"currency",
145,
"XNAQJZ3OTJFDZ2FEGVVQ",
1680739200000,
289,
"8GTJ7JADP09KTKDPFWQJ",
1680307200000,
278,
45,
249,
311,
181,
243,
184,
81,
340,
347,
191,
"trade",
-1595.0,
2172.0,
-3767.0,
-3767.0,
1595.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 17 APR 2023 FUT",
"equity",
135,
"GB8MD1GQRMB7M3KIPYBT",
1679616000000,
457.89,
"MWLF0LTSOJNEXKVXSGWN",
1681084800000,
489.67,
253.9655,
165.6897,
148.4828,
229.6207,
339.8966,
520.2759,
45.8276,
193.0345,
132.6897,
62.8966,
"trade",
4290.3,
2092.3796,
2197.9204,
2197.9204,
4290.3,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FINNIFTY 20 MAY 2023 FUT",
"equity",
120,
"GUEQKVCN1OGWGMPXO1WQ",
1682726400000,
698.03,
"B67GMDMHCZAHJBXKDGL0",
1684368000000,
745.32,
228.4615,
114.5385,
117.1538,
269.6154,
244.6923,
755.2308,
157.5385,
179,
103.3077,
67.6154,
"trade",
5674.8,
2237.1539,
3437.6461,
3437.6461,
5674.8,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FINNIFTY 25 JAN 2023 FUT",
"equity",
35,
"S4LOWQJP4P6SFB42C460",
1672617600000,
3450.67,
"IJPDDNJO9BNNH0TB9NPJ",
1674518400000,
2568.98,
155,
183,
79,
296,
369,
171,
270,
191,
55,
32,
"trade",
-30859.15,
1801.0,
-32660.15,
-32660.15,
30859.15,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 25 JAN 2023 FUT",
"equity",
100,
"CIKTMLOWJQLROEGJXMFF",
1672444800000,
175.55,
"YQT2WZWDNZPPCRDSQFR9",
1674432000000,
126.78,
83,
99,
135,
431,
165,
257,
307,
114,
154,
70,
"trade",
-4877.0,
1815.0,
-6692.0,
-6692.0,
4877.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"BANKNIFTY 15 Jun 2023 FUT",
"equity",
25,
"AUGUWEK01EI4YOIMH7RK",
1683158400000,
363.15,
"2C7BGL8DLAEX6DMFGRTF",
1684886400000,
425.3,
25.5,
135,
89.5,
299.5,
371.5,
323,
170,
154,
72.5,
22.5,
"trade",
1553.75,
1663.0,
-109.25,
-109.25,
1553.75,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"BANKNIFTY 15 Jun 2023 FUT",
"equity",
25,
"AUGUWEK01EI4YOIMH7RK",
1683158400000,
363.15,
"Y9V66LWUBLF8P2I8FDAR",
1685577600000,
469.22,
81.5,
119,
107.5,
152.5,
245.5,
456,
136,
223,
166.5,
15.5,
"trade",
2651.75,
1703.0,
948.75,
948.75,
2651.75,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCOM CRUDEOIL 16 OCT 2022",
"commodity",
25,
"55MCNYCUWJO7C3ZAXWIX",
1662940800000,
415,
"52VUZC1SJ5MW4IKAJPIA",
1663632000000,
423,
132.75,
109,
106.5,
72.75,
101.5,
110.75,
23,
70,
99.75,
90.25,
"trade",
200.0,
916.25,
-716.25,
-716.25,
200.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCOM CRUDEOIL 16 OCT 2022",
"commodity",
75,
"55MCNYCUWJO7C3ZAXWIX",
1662940800000,
415,
"XPDDDCPTROUOHFWCQH7O",
1665619200000,
449,
82.65,
49.8,
132.3,
133.65,
135.3,
74.85,
27.6,
81,
160.05,
26.55,
"trade",
2550.0,
903.75,
1646.25,
1646.25,
2550.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCOM CRUDEOIL 16 OCT 2022",
"commodity",
50,
"2FPD4QFGHO2ICG3SK0KG",
1664496000000,
456,
"XPDDDCPTROUOHFWCQH7O",
1665619200000,
449,
81.6,
118.2,
64.2,
99.6,
106.2,
99.4,
116.4,
150,
102.2,
40.2,
"trade",
-350.0,
978.0,
-1328.0,
-1328.0,
350.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCUR USDINR 27 JAN 2023 ",
"currency",
165,
"JDNI9UJFKN2PGFJZ5U9O",
1670630400000,
89.0121,
"4TXSMROXNCO4YKN01YBF",
1671494400000,
94.78,
380.8929,
274.875,
488.5714,
116.9643,
303.2857,
239.75,
319.875,
159.5536,
341.4286,
276.25,
"trade",
951.7035,
2901.4465,
-1949.743,
-1949.743,
951.7035,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCUR USDINR 27 JAN 2023 ",
"currency",
100,
"JDNI9UJFKN2PGFJZ5U9O",
1670630400000,
89.0121,
"D1VHUJNJ1WGO9JVCK2AZ",
1672358400000,
45.98,
220.5714,
356.5,
307.2857,
66.8571,
195.1429,
266,
325.5,
79.2143,
270.7143,
271,
"trade",
-4303.21,
2358.7857,
-6661.9957,
-6661.9957,
4303.21,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCUR USDINR 27 JAN 2023 ",
"currency",
15,
"JDNI9UJFKN2PGFJZ5U9O",
1670630400000,
89.0121,
"D1VHUJNJ1WGO9JVCK2AZ",
1672617600000,
78.3,
112.5357,
113.625,
150.1429,
169.1786,
90.5714,
237.25,
163.625,
218.2321,
95.8571,
18.75,
"trade",
-160.6815,
1369.7678,
-1530.4493,
-1530.4493,
160.6815,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCUR JPYINR 24 AUG 2023",
"currency",
110,
"EUCWBOWYUQF5LLS2MG9P",
1691452800000,
324.0636,
"BZAB3NIFLVXCEWLNXF0C",
1690848000000,
345.89,
139.4167,
478.0833,
191.3333,
340.5,
286,
402.6667,
451.75,
231.4167,
271.4167,
429.6667,
"trade",
2400.904,
3222.2501,
-821.3461,
-821.3461,
2400.904,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCUR GBPINR 27 OCT 2023",
"currency",
75,
"NU9Y7DKWYXX1B8HUGX0G",
1694649600000,
4500,
"NU9Y7DKWYXX1B8HUGX0G",
1694649600000,
4509,
36,
272,
216,
140,
125,
195,
179,
416,
306,
109,
"trade",
675.0,
1994.0,
-1319.0,
-1319.0,
675.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
70,
"KMY2EC1UMISH0BUMIEGT",
1665446400000,
139.3077,
"JAWOZXSLWYKHKUWGWS6L",
1666137600000,
148,
305.8462,
115.6923,
88,
140.6154,
114.6923,
140.6154,
185.9231,
186.3846,
139.1538,
165.5385,
"trade",
608.461,
1582.4616,
-974.0006,
-974.0006,
608.461,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
30,
"KMY2EC1UMISH0BUMIEGT",
1665446400000,
139.3077,
"JAWOZXSLWYKHKUWGWS6L",
1666224000000,
150,
285.0769,
137.1538,
83,
91.6923,
124.1538,
43.6923,
116.5384,
54.3077,
87.9231,
74.2307,
"trade",
320.769,
1097.769,
-777.0,
-777.0,
320.769,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
30,
"KMY2EC1UMISH0BUMIEGT",
1665446400000,
139.3077,
"XOUZUWMHBDCRPKRGDD1Q",
1668470400000,
154,
149.0769,
53.6539,
19.125,
43.0673,
67.9039,
45.6923,
60.6635,
36.0577,
39.5481,
55.3558,
"trade",
440.769,
570.1444,
-129.3754,
-129.3754,
440.769,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
50,
"1AW8BG2NTK1BPSLMR0TV",
1666828800000,
137,
"XOUZUWMHBDCRPKRGDD1Q",
1668470400000,
154,
168.5714,
82.1429,
32.2321,
66.3393,
75.1786,
60.7143,
64.375,
42.3214,
48.6607,
80.0893,
"trade",
850.0,
720.625,
129.375,
129.375,
850.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
90,
"1AW8BG2NTK1BPSLMR0TV",
1666828800000,
137,
"LAGBHUZEYUH1K2OMGP49",
1668902400000,
156,
226.5824,
90.7417,
91.3352,
103.7472,
57.6099,
90.5934,
75.1154,
97.4671,
102.5605,
77.7857,
"trade",
1710.0,
1013.5385,
696.4615,
696.4615,
1710.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
20,
"XOUZUWMHBDCRPKRGDD1Q",
1668470400000,
153,
"LAGBHUZEYUH1K2OMGP49",
1668902400000,
156,
227.9231,
37.3077,
50.1538,
14.7692,
25.2307,
114.8461,
113.6923,
46.2307,
74.0769,
56,
"trade",
60.0,
760.2305,
-700.2305,
-700.2305,
60.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"BANKNIFTY 01 Jun 2023 FUT",
"equity",
45,
"GGFCHMYLKDQYZRRINTEE",
1680739200000,
363.1,
"DROFW5LAACDWOCFKDQET",
1685318400000,
450.09,
162,
153,
89,
139,
323,
655,
157,
166,
223,
75,
"trade",
3914.55,
2142.0,
1772.55,
1772.55,
3914.55,
"business_and_profession",
"non_speculative",
"slab_rate"
]
]
}
]
},
{
"name": "option_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "option_tradewise_open_position_table",
"@entity": "table",
"header": [
"isin",
"contract_name",
"asset_class",
"quantity",
"trade_date",
"trade_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
null,
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
20.0,
1668902400000,
156.0,
"sell",
null,
null,
null
],
[
null,
"OPTFUT GOLD 29 OCT 2023 60000 PE",
"commodity",
55.0,
1694995200000,
124.56,
"sell",
null,
null,
null
],
[
null,
"FINNIFTY 25 MAY 2023 CE 14900",
"equity",
10.0,
1682726400000,
698.03,
"buy",
null,
null,
null
],
[
null,
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
10.0,
1690848000000,
345.89,
"sell",
null,
null,
null
],
[
null,
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
40.0,
1692230400000,
329.587,
"sell",
null,
null,
null
]
]
},
{
"name": "option_tradewise_tax_pnl_table",
"@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_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement",
"realized_pnl",
"total_transfer_expenses",
"net_realized_pnl",
"taxable_pnl",
"turnover",
"income_head",
"income_sub_head",
"tax_rate"
],
"rows": [
[
null,
"NIFTY 23 JAN 2023 CE 15000",
"equity",
25,
"ULDR4PE639LOMU4A4VCE",
1670457600000,
1570,
"0B3PIU4WMIPKUQEG34BO",
1671408000000,
1460,
1206.3333,
2859.6667,
2816.6667,
1138,
442.6667,
2843.3333,
1416.6667,
3065.3333,
1862.6667,
728.6667,
"trade",
-2750.0,
18380.0001,
-21130.0001,
-21130.0001,
2750.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 CE 15000",
"equity",
45,
"ULDR4PE639LOMU4A4VCE",
1670457600000,
1570,
"S7XOLPIQ2V4R5L89ZEE1",
1672358400000,
1508,
3057.2,
1900.8,
3179,
1633.8,
1002,
1606.6,
2519,
2059.6,
176.2,
3529.6,
"trade",
-2790.0,
20663.8,
-23453.8,
-23453.8,
2790.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 CE 15000",
"equity",
5,
"ULDR4PE639LOMU4A4VCE",
1670457600000,
1570,
"HSZA8B3XH3JC2POXMSXJ",
1673568000000,
1585,
174.9667,
262.9333,
146.7333,
287.1,
137.2333,
307.9667,
281.2333,
156.7667,
41.0333,
252.1333,
"trade",
75.0,
2048.0999,
-1973.0999,
-1973.0999,
75.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 CE 15000",
"equity",
45,
"VIHCPUEYSZUMQUVPSJ1P",
1671840000000,
1490,
"HSZA8B3XH3JC2POXMSXJ",
1673568000000,
1585,
342.54,
1677.24,
776.52,
1463.94,
1315.98,
1973.7,
2816.82,
515.7,
771.66,
2001.24,
"trade",
4275.0,
13655.34,
-9380.34,
-9380.34,
4275.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 CE 15000",
"equity",
80,
"VIHCPUEYSZUMQUVPSJ1P",
1671840000000,
1490,
"ILKEYGKTOHFQI5UXMBOO",
1674172800000,
1635,
280.96,
1222.36,
1253.08,
429.16,
2751.12,
590.4,
1935.28,
1459.6,
3148.44,
2763.36,
"trade",
11600.0,
15833.76,
-4233.76,
-4233.76,
11600.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
70,
"Q5CUBQ2P6B7VKNHCKWD6",
1665446400000,
139.3077,
"DTXGC9I0ZVOI2FFSHIOL",
1666137600000,
148,
305.8462,
115.6923,
88,
140.6154,
114.6923,
140.6154,
185.9231,
186.3846,
139.1538,
165.5385,
"trade",
608.461,
1582.4616,
-974.0006,
-974.0006,
608.461,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
30,
"Q5CUBQ2P6B7VKNHCKWD6",
1665446400000,
139.3077,
"DTXGC9I0ZVOI2FFSHIOL",
1666224000000,
150,
285.0769,
137.1538,
83,
91.6923,
124.1538,
43.6923,
116.5384,
54.3077,
87.9231,
74.2307,
"trade",
320.769,
1097.769,
-777.0,
-777.0,
320.769,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
30,
"Q5CUBQ2P6B7VKNHCKWD6",
1665446400000,
139.3077,
"TAODZZPWWR9R5CO1QX0R",
1668470400000,
154,
149.0769,
53.6539,
19.125,
43.0673,
67.9039,
45.6923,
60.6635,
36.0577,
39.5481,
55.3558,
"trade",
440.769,
570.1444,
-129.3754,
-129.3754,
440.769,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
50,
"IU0HYP6ZN9EOERPBEWYA",
1666828800000,
137,
"TAODZZPWWR9R5CO1QX0R",
1668470400000,
154,
168.5714,
82.1429,
32.2321,
66.3393,
75.1786,
60.7143,
64.375,
42.3214,
48.6607,
80.0893,
"trade",
850.0,
720.625,
129.375,
129.375,
850.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
90,
"IU0HYP6ZN9EOERPBEWYA",
1666828800000,
137,
"HVG5B4A45J9CL4CZ35TF",
1668902400000,
156,
226.5824,
90.7417,
91.3352,
103.7472,
57.6099,
90.5934,
75.1154,
97.4671,
102.5605,
77.7857,
"trade",
1710.0,
1013.5385,
696.4615,
696.4615,
1710.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
20,
"TAODZZPWWR9R5CO1QX0R",
1668470400000,
153,
"HVG5B4A45J9CL4CZ35TF",
1668902400000,
156,
227.9231,
37.3077,
50.1538,
14.7692,
25.2307,
114.8461,
113.6923,
46.2307,
74.0769,
56,
"trade",
60.0,
760.2305,
-700.2305,
-700.2305,
60.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FINNIFTY 25 JAN 2023 CE 12500",
"equity",
50,
"QOO5OYJLQBIRUMIGKCIQ",
1672617600000,
3450.67,
"A9HFP9X49AROF21K9KRY",
1674518400000,
2568.98,
1150,
1886,
1142,
4223,
3569,
922,
2014,
2594,
2594,
4292,
"trade",
-44084.5,
24386.0,
-68470.5,
-68470.5,
44084.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 CE 15650",
"equity",
100,
"PZUTEFRTRX9LFW9DPHAW",
1672444800000,
175.55,
"BEZ31FONIR1EQQI68F0Y",
1674432000000,
126.78,
413,
889,
4927,
3468,
4048,
2500,
3454,
2211,
2302,
4240,
"trade",
-4877.0,
28452.0,
-33329.0,
-33329.0,
4877.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"BANKNIFTY 01 Jun 2023 CE 44100",
"equity",
25,
"RJFWB5JYYDORFUEPK5DQ",
1680739200000,
363.1,
"KLPAV9GOUCMPFH1WNKLV",
1685318400000,
450.09,
2042,
1503,
2560,
2913,
3807,
806,
2343,
2686,
3601,
3712,
"trade",
2174.75,
25973.0,
-23798.25,
-23798.25,
2174.75,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"BANKNIFTY 01 Jun 2023 CE 44200",
"equity",
50,
"Y6W9FLHOVJ8TCHHNBYGF",
1683158400000,
363.15,
"QS2KFCND5DJXRNDLLVHD",
1684886400000,
425.3,
1972.6667,
577.6667,
1186.6667,
3114.3333,
2433,
734.6667,
2508.3333,
1818.6667,
1295.3333,
867.3333,
"trade",
3107.5,
16508.6667,
-13401.1667,
-13401.1667,
3107.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"BANKNIFTY 01 Jun 2023 CE 44200",
"equity",
25,
"Y6W9FLHOVJ8TCHHNBYGF",
1683158400000,
363.15,
"0WNSDPGK4LTXO38HPTLU",
1685577600000,
469.22,
2537.3333,
2049.3333,
2600.3333,
1460.6667,
2750,
177.3333,
2850.6667,
886.3333,
2607.6667,
1104.6667,
"trade",
2651.75,
19024.3333,
-16372.5833,
-16372.5833,
2651.75,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 17 APR 2023 PE 17800",
"equity",
55,
"DUYJ4ZV7OKJA8CV8U1MT",
1679616000000,
457.89,
"71ZRU28BNR9F5FMOZS8V",
1681084800000,
489.67,
3285,
2479,
3549,
2207,
887,
4521,
2418,
2583,
3198,
3116,
"trade",
1747.9,
28243.0,
-26495.1,
-26495.1,
1747.9,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FINNIFTY 25 MAY 2023 CE 14900",
"equity",
120,
"2GFSS7XTAHUWHFZH0NBR",
1682726400000,
698.03,
"PHGLBJWZZLIDKTTVLNQE",
1684368000000,
745.32,
1449.5385,
3136.4615,
2506.2308,
2420.1538,
3149.4615,
2487.5385,
1381.2308,
1990.5385,
2904.3077,
1452.5385,
"trade",
5674.8,
22878.0001,
-17203.2001,
-17203.2001,
5674.8,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
"commodity",
25,
"DML3WXXE53PJOTGTEYKJ",
1662940800000,
415,
"TTGYOR1EOA3SUTMNCJ58",
1663632000000,
423,
132.75,
109,
106.5,
72.75,
101.5,
110.75,
23,
70,
99.75,
90.25,
"trade",
200.0,
916.25,
-716.25,
-716.25,
200.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
"commodity",
75,
"DML3WXXE53PJOTGTEYKJ",
1662940800000,
415,
"VIX3TEN3GZKPVY2WZCEX",
1665619200000,
449,
82.65,
49.8,
132.3,
133.65,
135.3,
74.85,
27.6,
81,
160.05,
26.55,
"trade",
2550.0,
903.75,
1646.25,
1646.25,
2550.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
"commodity",
50,
"MYOFOBCC5W0PCWHVBFPU",
1664496000000,
456,
"VIX3TEN3GZKPVY2WZCEX",
1665619200000,
449,
81.6,
118.2,
64.2,
99.6,
106.2,
99.4,
116.4,
150,
102.2,
40.2,
"trade",
-350.0,
978.0,
-1328.0,
-1328.0,
350.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 CE 15600",
"equity",
25,
"2BOMU4R5WMEONKEI5YT6",
1673481600000,
168,
"GHQTIWHDAFE90NOAU6ZY",
1672185600000,
146,
1653,
743.7,
878.1,
492.9,
340.6,
2030.7,
2367.5,
661.1,
1265.6,
489,
"trade",
-550.0,
10922.2,
-11472.2,
-11472.2,
550.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 CE 15600",
"equity",
75,
"2BOMU4R5WMEONKEI5YT6",
1673481600000,
168,
"GHQTIWHDAFE90NOAU6ZY",
1672531200000,
158,
2145,
2546.1,
1469.3,
2522.7,
1244.8,
2115.1,
1094.5,
1568.3,
2410.8,
2277,
"trade",
-750.0,
19393.6,
-20143.6,
-20143.6,
750.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 CE 15600",
"equity",
150,
"2BOMU4R5WMEONKEI5YT6",
1673481600000,
168,
"IXMBK9LENH6CSGULION2",
1674259200000,
255,
3137,
1269.2,
2976.6,
3171.4,
1955.6,
1842.2,
1009,
1475.6,
3607.6,
2368,
"trade",
13050.0,
22812.2,
-9762.2,
-9762.2,
13050.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTCUR USDINR 27 JAN 2023 83 PE",
"currency",
165,
"GYHVDLIIXVTLROOCLVYG",
1670630400000,
89.0121,
"8VMAOKSBFKXAX1Z75UK5",
1671494400000,
94.78,
380.8929,
274.875,
488.5714,
116.9643,
303.2857,
239.75,
319.875,
159.5536,
341.4286,
276.25,
"trade",
951.7035,
2901.4465,
-1949.743,
-1949.743,
951.7035,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTCUR USDINR 27 JAN 2023 83 PE",
"currency",
100,
"GYHVDLIIXVTLROOCLVYG",
1670630400000,
89.0121,
"ZXORPEEJE7TVFBPXQ8LI",
1672358400000,
45.98,
220.5714,
356.5,
307.2857,
66.8571,
195.1429,
266,
325.5,
79.2143,
270.7143,
271,
"trade",
-4303.21,
2358.7857,
-6661.9957,
-6661.9957,
4303.21,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTCUR USDINR 27 JAN 2023 83 PE",
"currency",
15,
"GYHVDLIIXVTLROOCLVYG",
1670630400000,
89.0121,
"ZXORPEEJE7TVFBPXQ8LI",
1672617600000,
78.3,
112.5357,
113.625,
150.1429,
169.1786,
90.5714,
237.25,
163.625,
218.2321,
95.8571,
18.75,
"trade",
-160.6815,
1369.7678,
-1530.4493,
-1530.4493,
160.6815,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 FEB 2023 PE 17100",
"equity",
55,
"PGR2RDEZFVC2S3YBX1JF",
1675296000000,
194.9,
"KQDQ54GEHLHTIUSPGAV6",
1675987200000,
174.8,
1102.9048,
1623.0476,
2471.5238,
1595.0476,
2914.7143,
2939.8095,
1839.0476,
2604.2857,
607.6667,
2400.619,
"trade",
-1105.5,
20098.6666,
-21204.1666,
-21204.1666,
1105.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 FEB 2023 PE 17100",
"equity",
50,
"PGR2RDEZFVC2S3YBX1JF",
1675296000000,
194.9,
"SLB3JNRIBXSZWLRWP8ZZ",
1676764800000,
210.89,
915.0952,
1493.9524,
2583.4762,
2096.9524,
2399.2857,
836.1905,
928.9524,
3345.7143,
1471.3333,
2150.381,
"trade",
799.5,
18221.3334,
-17421.8334,
-17421.8334,
799.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
80,
"OFAILEZLEAPD9SU5ZOMT",
1691452800000,
325.67,
"T6B8078DHAC9MGWPKR6B",
1690848000000,
345.89,
48.6667,
222.3333,
91.3333,
191,
177,
220.6667,
203,
126.6667,
212.6667,
268.6667,
"trade",
1617.6,
1762.0001,
-144.4001,
-144.4001,
1617.6,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
30,
"OFAILEZLHKPD8SU7ZOMT",
1691452800000,
319.78,
"T6B8078DHAC9MGWPKR6B",
1690848000000,
345.89,
90.75,
255.75,
100,
149.5,
109,
182,
248.75,
104.75,
58.75,
161,
"trade",
783.3,
1460.25,
-676.95,
-676.95,
783.3,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTCUR EURINR 13 MAY 2023 94 CE",
"currency",
50,
"CPYBETZOWLDVTAYF3PRA",
1680134400000,
260.7,
"6MDVYEYUKHJXIQSGEOPU",
1680134400000,
245.78,
224,
390,
338,
444,
277,
191,
141,
329,
324,
243,
"trade",
-746.0,
2901.0,
-3647.0,
-3647.0,
746.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTCUR EURINR 13 MAY 2023 94 CE",
"currency",
145,
"UQCTRKWJRKXVR7LSIBCN",
1680739200000,
289,
"MEHVXLLGPB5SODCHL5PT",
1680307200000,
278,
45,
249,
311,
181,
243,
184,
81,
340,
347,
191,
"trade",
-1595.0,
2172.0,
-3767.0,
-3767.0,
1595.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTCUR GBPINR 27 OCT 2023 115 PE",
"currency",
75,
"PIN8G2M1QKXY1FQZPRIF",
1694649600000,
4500,
"PIN8G2M1QKXY1FQZPRIF",
1694649600000,
4509,
36,
272,
216,
140,
125,
195,
179,
416,
306,
109,
"trade",
675.0,
1994.0,
-1319.0,
-1319.0,
675.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FINNIFTY 15 FEB 2023 CE 13400",
"equity",
50,
"DIQDEZH7K04QBDCJY0NV",
1674086400000,
194.9,
"HMC8SXGWGNGWUTFBYRHX",
1675814400000,
174.55,
2524,
4142,
3167,
4280,
1285,
2547,
898,
2368,
1478,
3531,
"trade",
-1017.5,
26220.0,
-27237.5,
-27237.5,
1017.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"BANKNIFTY 20 MAR 2023 PE 18900",
"equity",
155,
"TFCXQ3TKQRMOHU86MXO1",
1676505600000,
1500,
"LMQI22RLLZHQ5CWBGFYP",
1679097600000,
615.89,
1946,
1071,
3214,
3408,
2371,
3297,
4858,
3054,
3132,
4441,
"trade",
-137037.05,
30792.0,
-167829.05,
-167829.05,
137037.05,
"business_and_profession",
"non_speculative",
"slab_rate"
]
]
}
]
},
{
"name": "bond_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "bond_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
},
{
"name": "bond_transaction_summary_table",
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"realized_pnl",
"transfer_expenses",
"net_realized_pnl"
],
"rows": [
[
"trade",
787300.0,
318763.0,
10846.05,
307916.95
],
[
"interest",
0.0,
0.0,
0.0,
0.0
],
[
"lost",
0.0,
0.0,
0.0,
0.0
],
[
"gift_send",
0.0,
0.0,
0.0,
0.0
],
[
"gift_receive",
0.0,
0.0,
0.0,
0.0
],
[
"transfer_in",
0.0,
0.0,
0.0,
0.0
],
[
"transfer_out",
0.0,
0.0,
0.0,
0.0
],
[
"donation",
0.0,
0.0,
0.0,
0.0
],
[
"other",
0.0,
0.0,
0.0,
0.0
]
]
},
{
"name": "bond_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"securityName",
"quantity",
"buyDate",
"buyPrice",
"transactionType",
"label",
"lastTradedPrice",
"unrealizedPnl"
],
"rows": [
[
"INE272F07011",
"Blue Dart Express",
30.0,
20.0,
null,
"buy",
null,
null,
null
],
[
"INE112J07020",
"IFCI",
30.0,
16.55,
null,
"buy",
null,
null,
null
],
[
"INE130K08019",
"APPL",
20.0,
350.0,
null,
"buy",
null,
null,
null
],
[
"INE130K08000",
"SBOX",
30.0,
16.55,
null,
"buy",
null,
null,
null
],
[
"INE261F07055",
"SGB",
400.0,
322.0,
null,
"buy",
null,
null,
null
],
[
"INE261F07055",
"SGB",
100.0,
350.0,
null,
"buy",
null,
null,
null
]
]
},
{
"name": "bond_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": []
},
{
"name": "bond_tradewise_tax_pnl_table",
"@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": [
[
"INE272F07011",
"Blue Dart Express",
true,
20,
"BVNCH72LKDQY9RRINTGH",
1662940800000,
20,
"KHF78MYGKDQY9RRINTGH",
1670630400000,
200,
20.0,
122.0,
48.8,
124.0,
60.6,
16.2,
121.4,
46.0,
70.8,
88.0,
"trade",
3600.0,
697.8,
2902.2,
2902.2,
"short_term",
4000.0,
"capital_gains",
"securities",
"slab_rate",
null
],
[
"INE112J07020",
"IFCI",
true,
170,
"BNG57MYGKDQY9RRINTGH",
1670457600000,
16.55,
"GHN78MYGKDQY9RRINTGH",
1671840000000,
500,
16.55,
137.3,
131.1,
121.95,
43.6,
62.0,
164.25,
175.95,
118.3,
95.4,
"trade",
82186.5,
1049.85,
81136.65,
81136.65,
"short_term",
85000.0,
"capital_gains",
"securities",
"slab_rate",
null
],
[
"INE130K08019",
"APPL",
false,
180,
"MJK88MYGKDQY9RRINTGH",
1633564800000,
350,
"CVH78MYGKDQY9RRINTGH",
1639872000000,
310,
350.0,
214.6,
119.8,
135.0,
134.6,
94.9,
66.5,
80.3,
163.6,
208.2,
"trade",
-7200.0,
1217.5,
-8417.5,
-8417.5,
"short_term",
55800.0,
"capital_gains",
"securities",
"slab_rate",
null
],
[
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
"TGFCH72LKDQY9RRINTGH",
1680739200000,
10,
"GMFCH72LKDQY9RRINTGH",
1634169600000,
125,
10.0,
46.0,
76.0,
99.0,
67.0,
171.0,
126.0,
139.0,
77.0,
133.0,
"trade",
57500.0,
934.0,
56566.0,
56566.0,
"long_term",
62500.0,
"capital_gains",
"securities",
"10",
"112"
],
[
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
"KGFCH72LKDQY9RRINTGH",
1683158400000,
10,
"GMFCH72LKDQY9RRINTGH",
1634342400000,
125,
10.0,
197.0,
213.0,
125.0,
126.0,
160.0,
134.0,
130.0,
186.0,
131.0,
"trade",
57500.0,
1402.0,
56098.0,
56098.0,
"long_term",
62500.0,
"capital_gains",
"securities",
"10",
"112"
],
[
"INE130K08001",
"QCK",
false,
200,
"GHL909MYGKDQY9RRINTGH",
1633996800000,
16.55,
"BHM88MTYH6QY9RRINTGH",
1374624000000,
500,
16.55,
91.0,
255.0,
38.0,
172.0,
198.0,
136.0,
125.0,
233.0,
158.0,
"trade",
96690.0,
1406.0,
95284.0,
95284.0,
"long_term",
100000.0,
"capital_gains",
"securities",
"20",
"112"
],
[
"INE130K08015",
"GGL",
true,
200,
"BHMGP79GKDQY9RRINTGH",
1585008000000,
550,
"BLKMN98HJNMDQY9RRINTGH",
1649289600000,
600,
550.0,
124.0,
106.0,
103.0,
118.0,
173.0,
79.0,
70.0,
112.0,
121.0,
"trade",
10000.0,
1006.0,
8994.0,
8994.0,
"long_term",
120000.0,
"capital_gains",
"securities",
"10",
"112"
],
[
"INE130K08000",
"SBOX",
false,
170,
"GJK45MYGKDQY9RRINTGH",
1672617600000,
16.55,
"BHM88MYGKDQY9RRINTGH",
1576022400000,
500,
16.55,
129.0,
112.6,
100.65,
84.85,
77.0,
198.9,
116.55,
201.15,
102.4,
"trade",
82186.5,
1123.1,
81063.4,
81063.4,
"long_term",
85000.0,
"capital_gains",
"securities",
"20",
"112"
],
[
"INE261F07055",
"SGB",
true,
500,
"GGFCHMYLKDQY9RRINTGH",
1437177600000,
488,
"JTR59NOGKDQY9YTINTGH",
1563667200000,
350,
488.0,
192.2727,
157.1818,
142.4545,
148.5455,
121.5455,
49.1818,
139.8182,
90.7273,
218.2727,
"trade",
-69000.0,
1260.0,
-70260.0,
-70260.0,
"long_term",
175000.0,
"capital_gains",
"securities",
"10",
"112"
],
[
"INE261F07055",
"SGB",
true,
50,
"GGFCHMYLKDQY9RRINTGH",
1626652800000,
322,
"JTR59NOGKDQY9YTINTGH",
1563667200000,
350,
322.0,
11.9273,
13.9182,
12.3455,
12.0545,
14.5545,
9.5182,
15.4818,
13.9727,
12.1273,
"trade",
1400.0,
115.9,
1284.1,
1284.1,
"long_term",
17500.0,
"capital_gains",
"securities",
"10",
"112"
],
[
"INE261F07055",
"SGB",
true,
50,
"GGFCHMYLKDQY9RRINTGH",
1626652800000,
322,
"DFGR59NOHJDQ751TINTJK",
1570579200000,
400,
322.0,
82.2,
15.1,
133.8,
65.6,
15.1,
54.7,
113.3,
47.7,
106.4,
"trade",
3900.0,
633.9,
3266.1,
3266.1,
"long_term",
20000.0,
"capital_gains",
"securities",
"10",
"112"
]
]
}
]
},
{
"name": "debenture_tradewise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "debenture_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
},
{
"name": "debenture_transaction_summary_table",
"@entity": "table",
"header": [
"nature_of_transaction",
"total_transaction_value",
"realised_pnl",
"transafer_expense",
"net_realized_pnl"
],
"rows": [
[
"trade",
938250.0,
356913.0,
19758.8,
337154.2
],
[
"interest",
0.0,
0.0,
0.0,
0.0
],
[
"lost",
0.0,
0.0,
0.0,
0.0
],
[
"gift_send",
0.0,
0.0,
0.0,
0.0
],
[
"gift_receive",
0.0,
0.0,
0.0,
0.0
],
[
"transfer_in",
0.0,
0.0,
0.0,
0.0
],
[
"transfer_out",
0.0,
0.0,
0.0,
0.0
],
[
"donation",
0.0,
0.0,
0.0,
0.0
],
[
"other",
0.0,
0.0,
0.0,
0.0
]
]
},
{
"name": "debenture_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": [
[
"INE272F07011",
"Blue Dart Express",
30.0,
1589414400000,
20.0,
"buy",
null,
null,
null
],
[
"INE112J07020",
"IFCI",
30.0,
1515456000000,
16.55,
"buy",
null,
null,
null
],
[
"INE130K08019",
"APPL",
20.0,
1626912000000,
350.0,
"buy",
null,
null,
null
],
[
"INE130K08000",
"SBOX",
30.0,
1493769600000,
16.55,
"buy",
null,
null,
null
],
[
"INE261F07055",
"SGB",
500.0,
1556409600000,
764.0,
"buy",
null,
null,
null
]
]
},
{
"name": "debenture_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"sell_date",
"sell_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"rows": []
},
{
"name": "debenture_tradewise_tax_pnl_table",
"@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_fees",
"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": [
[
"INE272F07011",
"Blue Dart Express",
true,
20,
"DML3WXXE53PJOTGTEYKJ",
1589414400000,
20,
"GYHVDLIIXVTLROOCLVYG",
1650672000000,
200,
20.0,
175.4,
207.2,
112.6,
140.8,
139.4,
104.0,
150.8,
316.0,
48.4,
"trade",
3600.0,
1394.6,
2205.4,
2205.4,
"long_term",
4000.0,
"capital_gains",
"securities",
"10",
"112"
],
[
"INE112J07020",
"IFCI",
true,
170,
"ULDR4PE639LOMU4A4VCE",
1515456000000,
16.55,
"VIHCPUEYSZUMQUVPSJ1P",
1682640000000,
500,
16.55,
191.9,
231.6,
317.2,
337.45,
305.5,
219.05,
249.5,
253.5,
148.25,
"trade",
82186.5,
2253.95,
79932.55,
79932.55,
"long_term",
85000.0,
"capital_gains",
"securities",
"10",
"112"
],
[
"INE130K08019",
"APPL",
false,
180,
"DUYJ4ZV7OKJA8CV8U1MT",
1626912000000,
350,
"2GFSS7XTAHUWHFZH0NBR",
1690070400000,
310,
350.0,
205.5,
409.2,
100.2,
221.2,
170.1,
245.6,
231.5,
58.0,
305.6,
"trade",
-7200.0,
1946.9,
-9146.9,
-9146.9,
"short_term",
55800.0,
"capital_gains",
"securities",
"slab_rate",
null
],
[
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
1000,
"RJFWB5JYYDORFUEPK5DQ",
1525824000000,
10,
"Y6W9FLHOVJ8TCHHNBYGF",
1577664000000,
10,
10.0,
401.0,
228.0,
457.0,
315.0,
294.0,
335.0,
328.0,
253.0,
324.0,
"trade",
0.0,
2935.0,
-2935.0,
-2935.0,
"long_term",
10000.0,
"capital_gains",
"securities",
"10",
"112"
],
[
"INE130K08001",
"QCK",
false,
200,
"PZUTEFRTRX9LFW9DPHAW",
1437177600000,
16.55,
"DIQDEZH7K04QBDCJY0NV",
1626652800000,
500,
16.55,
211.0,
354.0,
419.0,
175.0,
173.0,
346.0,
281.0,
132.0,
417.0,
"trade",
96690.0,
2508.0,
94182.0,
94182.0,
"long_term",
100000.0,
"capital_gains",
"securities",
"20",
"112"
],
[
"INE130K08015",
"GGL",
true,
200,
"PGR2RDEZFVC2S3YBX1JF",
1626739200000,
550,
"TFCXQ3TKQRMOHU86MXO1",
1563667200000,
600,
550.0,
260.0,
142.0,
368.0,
282.0,
420.0,
265.0,
397.0,
109.0,
233.0,
"trade",
10000.0,
2476.0,
7524.0,
7524.0,
"long_term",
120000.0,
"capital_gains",
"securities",
"10",
"112"
],
[
"INE130K08000",
"SBOX",
false,
170,
"QOO5OYJLQBIRUMIGKCIQ",
1493769600000,
16.55,
"2BOMU4R5WMEONKEI5YT6",
1626480000000,
500,
16.55,
188.8,
192.8,
153.7,
23.45,
261.5,
187.9,
94.1,
227.95,
192.15,
"trade",
82186.5,
1522.35,
80664.15,
80664.15,
"long_term",
85000.0,
"capital_gains",
"securities",
"20",
"112"
],
[
"INE261F07055",
"SGB",
true,
100,
"Q2DZQ1ITYAOXILWQLHDN",
1491436800000,
890,
"FQQ96BPTGAPAQPLMABNU",
1576022400000,
789,
890.0,
198.4545,
119.4545,
198.5455,
111.6364,
203.0,
199.1818,
80.7273,
161.2727,
78.1818,
"trade",
-10100.0,
1350.4545,
-11450.4545,
-11450.4545,
"long_term",
78900.0,
"capital_gains",
"securities",
"10",
"112"
],
[
"INE261F07055",
"SGB",
true,
450,
"4AGDXGEEJOUHI6G8ATOU",
1556409600000,
600,
"FQQ96BPTGAPAQPLMABNU",
1576022400000,
789,
600.0,
240.5455,
221.6455,
132.0545,
259.3636,
241.2,
118.7182,
345.2727,
210.0273,
313.1182,
"trade",
85050.0,
2081.9455,
82968.0545,
82968.0545,
"short_term",
355050.0,
"capital_gains",
"securities",
"slab_rate",
null
],
[
"INE261F07055",
"SGB",
true,
50,
"4AGDXGEEJOUHI6G8ATOU",
1556409600000,
600,
"RKW88OVAQVWZMCD9VLJL",
1633996800000,
890,
600.0,
161.0,
219.9,
116.4,
114.0,
212.8,
115.1,
84.0,
240.7,
25.7,
"trade",
14500.0,
1289.6,
13210.4,
13210.4,
"long_term",
44500.0,
"capital_gains",
"securities",
"10",
"112"
]
]
}
]
},
{
"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",
"tax_rate",
"section",
"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",
"15",
"111A",
"short_term",
412458.64,
386142.45,
386142.45,
412458.64,
26316.19,
3583.789,
22732.401,
23090.7799
],
[
"equity",
"share",
"capital_gains",
"securities",
"10",
"112A",
"long_term",
2051586.7306,
998919.25,
998919.25,
2051586.7306,
1052667.4806,
9596.053,
1043071.4276,
1044031.0329
],
[
"equity",
"share",
"other",
"other_exempt_income",
null,
null,
null,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"share",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
6579.2,
557381.92,
557381.92,
558009.12,
627.2,
5320.0,
-4692.8,
-4692.8
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"10",
"112A",
"short_term",
125840.0,
100787.12,
100787.12,
125840.0,
25052.88,
868.25,
24184.63,
24184.63
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"10",
"112A",
"long_term",
186769.43,
97724.18574,
98974.18574,
186769.43,
89045.2443,
282.5574,
88762.6869,
87512.6869
],
[
"debt",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"slab_rate",
null,
"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",
"slab_rate",
null,
"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",
"slab_rate",
null,
"short_term",
10706.2,
14237.904304,
14237.904304,
10706.2,
-3531.7043,
156.6621,
-3688.3664,
-3688.3664
],
[
"other",
"mutual_fund",
"capital_gains",
"other_capital_gains",
"20",
"112",
"long_term",
8542.8,
7298.2,
10904.0036,
8542.8,
1244.6,
672.6772,
571.9228,
-3033.8808
],
[
"equity",
"etf",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
22500.0,
13500.0,
13500.0,
22500.0,
9000.0,
1439.0,
7561.0,
7664.0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"10",
"112A",
"long_term",
60964.0,
32500.897,
32500.897,
60964.0,
28463.103,
5817.5862,
22645.5168,
23210.9306
],
[
"debt",
"etf",
"capital_gains",
"other_capital_gains",
"slab_rate",
null,
"short_term",
3157.68,
6315.36,
6315.36,
3157.68,
-3157.68,
2877.0,
-6034.68,
-5766.68
],
[
"debt",
"etf",
"capital_gains",
"other_capital_gains",
"20",
"112",
"long_term",
9600.0,
7200.0,
7200.0,
9600.0,
2400.0,
1189.5,
1210.5,
1369.0
],
[
"other",
"etf",
"capital_gains",
"other_capital_gains",
"slab_rate",
null,
"short_term",
23000.0,
46107.785,
46107.785,
23000.0,
-23107.785,
1234.3332,
-24342.1182,
-24223.7849
],
[
"other",
"etf",
"capital_gains",
"other_capital_gains",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
11000.0,
64375.0,
64375.0,
53375.0,
-11000.0,
3158.0,
-14158.0,
-14158.0
],
[
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
12500.0,
162500.0,
162500.0,
150000.0,
-12500.0,
1692.0,
-14192.0,
-14192.0
],
[
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
900.0,
300.0,
300.0,
1200.0,
900.0,
731.0,
169.0,
169.0
],
[
"equity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
186560.3,
642549.2,
642549.2,
522096.8,
-120452.4,
30187.5335,
-150639.9335,
-150639.9335
],
[
"commodity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
7089.999,
104650.001,
104650.001,
111040,
6389.999,
8542.769,
-2152.77,
-2152.77
],
[
"currency",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
21664.998,
453010.384,
453010.384,
450233.1,
-2777.284,
16919.2501,
-19696.5341,
-19696.5341
],
[
"equity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
240117.75,
944059.3,
944059.3,
794253.95,
-149805.35,
384506.0001,
-534311.3501,
-534311.3501
],
[
"commodity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
7089.999,
104650.001,
104650.001,
111040,
6389.999,
8542.769,
-2152.77,
-2152.77
],
[
"currency",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
21664.99,
453010.388,
453010.388,
450233.1,
-2777.288,
16919.2501,
-19696.5381,
-19696.5381
],
[
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
144800.0,
66213.5,
66213.5,
144800,
78586.5,
2965.15,
75621.35,
75621.35
],
[
"debt",
"bond",
"capital_gains",
"securities",
"20",
"112",
"long_term",
642500.0,
402323.5,
402323.5,
642500,
240176.5,
7880.9,
232295.6,
232295.6
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
410850.0,
333000,
333000.0,
410850,
77850.0,
4028.8455,
73821.1545,
73821.1545
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"20",
"112",
"long_term",
527400.0,
248337.0,
248337.0,
527400,
279063.0,
15729.9545,
263333.0455,
263333.0455
]
]
},
{
"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.0,
399213.5,
399213.5,
555650,
156436.5,
6993.9955,
149442.5045,
149442.5045
],
[
"capital_gains",
"securities",
"short_term",
"15",
560798.64,
500429.57,
389711.45,
560798.64,
60369.07,
5891.039,
54478.031,
54939.4099
],
[
"capital_gains",
"securities",
"long_term",
"10",
3099220.1606,
1767557.83274,
1638732.8748,
3099220.1606,
1331662.3279,
32747.6011,
1298914.7268,
1299189.7459
],
[
"capital_gains",
"securities",
"long_term",
"20",
370000.0,
12247.0,
12247.0,
370000,
357753.0,
6559.45,
351193.55,
351193.55
],
[
"business_and_profession",
"speculative",
"intraday",
"slab_rate",
30979.2,
784556.92,
784556.92,
762584.12,
-21972.8,
10901.0,
-32873.8,
-32873.8
],
[
"capital_gains",
"other_capital_gains",
"short_term",
"slab_rate",
66031.995,
68454.779304,
1112.1557,
66031.995,
-2422.7843,
4434.5862,
-6857.3705,
-6471.0372
],
[
"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.0,
7200.0,
120.0,
9600.0,
2400.0,
1189.5,
1210.5,
1369.0
],
[
"business_and_profession",
"non_speculative",
null,
"slab_rate",
462523.042,
2701929.274,
2701929.274,
2438896.95,
-263032.324,
465617.5718,
-728649.8958,
-728649.8958
],
[
"other",
"other_exempt_income",
null,
"exempt",
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
}
]
}
Scripwise Tax PnL
Click here to learn more about this JSON Payload
{
"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": [
"id",
"isin",
"symbol",
"is_listed",
"is_stt_paid",
"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",
"section"
],
"rows": [
[
null,
"INE00E101023",
"BIKAJI",
true,
true,
140.0,
327.0,
355.8929,
327.0,
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",
"111A"
],
[
null,
"INE00E101023",
"BIKAJI",
true,
true,
2260.0,
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",
"112A"
],
[
null,
"INE462A01022",
"BAYERCROP",
true,
true,
58.0,
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",
"111A"
],
[
null,
"INE462A01022",
"BAYERCROP",
true,
true,
62.0,
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",
"112A"
],
[
null,
"INE01C001018",
"ADANIPORTS",
true,
true,
300.0,
270.0,
410.32,
270.0,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
130.5103,
42096.0,
1305.103,
40790.897,
40921.4073,
"long_term",
123096.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
null,
"INE364U01010",
"ADANIGREEN",
true,
true,
40.0,
310.0,
365.0,
310.0,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
84.4085,
2200.0,
844.085,
1355.915,
1440.3235,
"short_term",
14600.0,
"capital_gains",
"securities",
"15",
"111A"
],
[
null,
"INE002A01018",
"AJANTAPHARMA",
true,
true,
145.0,
578.0,
689.0,
578.0,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
80.4,
16095.0,
804.0,
15291.0,
15371.4,
"short_term",
99905.0,
"capital_gains",
"securities",
"15",
"111A"
],
[
null,
"INE002A01018",
"AJANTAPHARMA",
true,
true,
1590.0,
136.0,
604.5943,
136.0,
147.6,
147.6,
147.6,
147.6,
147.6,
147.6,
147.6,
147.6,
147.6,
147.6,
745064.937,
1476.0,
743588.937,
743736.537,
"long_term",
961304.937,
"capital_gains",
"securities",
"10",
"112A"
]
]
},
{
"name": "stock_intraday_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"id",
"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": [
[
null,
"INE01C001018",
"ADANIPORTS",
20.0,
410.0,
436.0,
76.0,
76.0,
76.0,
76.0,
76.0,
76.0,
76.0,
76.0,
76.0,
76.0,
520.0,
760.0,
-240.0,
-240.0,
520.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
null,
"INE364U01010",
"ADANIGREEN",
15.0,
281.0,
250.0,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
-465.0,
912.0,
-1377.0,
-1377.0,
465.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
null,
"INE462A01022",
"BAYERCROP",
25.0,
4254.0,
4239.0,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
-375.0,
912.0,
-1287.0,
-1287.0,
375.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
null,
"INE010B01019",
"CADILAHC",
254.0,
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.0,
1831.2,
1831.2,
2743.2,
"business_and_profession",
"speculative",
"slab_rate"
],
[
null,
"INE00E101023",
"BIKAJI",
352.0,
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.0,
-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.0,
5000.0,
null,
null
],
[
"INE01C001018",
"ADANIPORTS",
78.0,
328.7179,
null,
null
],
[
"INE364U01010",
"ADANIGREEN",
27.0,
295.1852,
null,
null
],
[
"INE767A01016",
"ADANIENT",
80.0,
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.0,
5000.0,
null,
null
],
[
"INE00E101023",
"BIKAJI",
260.0,
370.0,
null,
null
]
]
}
]
},
{
"name": "mutual_fund_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "mutual_fund_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"id",
"isin",
"is_listed",
"is_stt_paid",
"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",
"section"
],
"rows": [
[
null,
"INF251K01NO3",
true,
true,
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
17.823,
10,
5,
10.0,
-89.115,
66.9329,
-156.0479,
-156.0479,
"short_term",
89.115,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
null,
"INF200K01OR6",
true,
true,
"SBI Magnum Multicap Fund",
"equity",
125,
150,
400,
160.0,
31250,
107.1985,
31142.8015,
29892.8015,
"long_term",
50000,
"capital_gains",
"securities",
"10",
"112A"
],
[
null,
"INF278A06YE8",
true,
true,
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
36.023,
30,
60,
34.96,
1080.69,
168.0,
912.69,
734.01592,
"long_term",
2161.38,
"capital_gains",
"other_capital_gains",
"20",
"112"
],
[
null,
"INF200K01189",
true,
true,
"SBI Gold Fund",
"other",
20,
60,
210,
60.0,
3000,
48.0936,
2951.9064,
2951.9064,
"short_term",
4200,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
null,
"INF200K01189",
true,
true,
"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",
"112"
],
[
null,
"INF109KB1GK2",
true,
true,
"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",
null
],
[
null,
"INF277K01YE6",
true,
true,
"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",
"112"
],
[
null,
"INF200K01190",
true,
true,
"KOTAK SEC FUND",
"equity",
90,
988.8889,
1255.5556,
988.8889,
24000.003,
818.0,
23182.003,
23182.003,
"short_term",
113000.004,
"capital_gains",
"securities",
"15",
"111A"
],
[
null,
"INE397D01024",
true,
true,
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
32.31,
50,
900,
50.0,
27463.5,
99.658,
27363.842,
27363.842,
"short_term",
29079.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
null,
"INF846K01DI2",
true,
true,
"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",
"112A"
],
[
null,
"INF200K01UT4",
true,
true,
"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",
"112"
],
[
null,
"INF760K01FR2",
true,
true,
"Canara Robeco Bluechip Equity Growth Direct Plan",
"equity",
155,
23.78,
56.9,
23.78,
5133.6,
4.0,
5129.6,
5129.6,
"long_term",
8819.5,
"capital_gains",
"securities",
"10",
"112A"
],
[
null,
"INF179KB1HP9",
true,
true,
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
25.68,
459,
500,
459.0,
1052.88,
50.25,
1002.63,
1002.63,
"short_term",
12840.0,
"capital_gains",
"securities",
"15",
"111A"
]
]
},
{
"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.0,
null,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
31.78,
150.0,
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.0,
193.6681,
null,
null
],
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
50.0,
124.2586,
null,
null
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
15.134,
15.0,
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.0,
null,
null
]
]
}
]
},
{
"name": "etf_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "etf_delivery_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"id",
"isin",
"is_listed",
"is_stt_paid",
"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",
"section"
],
"rows": [
[
null,
"INF200K01189",
true,
true,
"SBI Gold Fund",
"other",
50.0,
120.5877,
60.0,
120.5877,
71.0,
76.0,
107.0,
74.0,
58.0,
90.0,
23.0,
57.0,
79.0,
50.0,
-3029.385,
685.0,
-3714.385,
-3656.385,
"short_term",
3000.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
null,
"INF109KB1GK2",
true,
true,
"ICICI Prudential Commodity Fund",
"other",
100.0,
400.784,
200.0,
400.784,
123.3333,
63.3333,
73.3333,
26.0,
60.3333,
15.3333,
21.6667,
60.6667,
35.3333,
70.0,
-20078.4,
549.3332,
-20627.7332,
-20567.3999,
"short_term",
20000.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
null,
"INF846K01DI2",
true,
true,
"Axis Bluechip Fund",
"equity",
78.0,
23.0,
88.0,
23.0,
185.0,
52.0,
188.0,
160.0,
151.0,
251.0,
139.0,
207.0,
116.0,
155.0,
5070.0,
1604.0,
3466.0,
3617.0,
"long_term",
6864.0,
"capital_gains",
"securities",
"10",
"112A"
],
[
null,
"INF278A06YE8",
true,
true,
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
100.0,
60.0,
30.0,
60.0,
211.0,
100.0,
140.0,
144.0,
222.0,
134.0,
107.0,
202.0,
104.0,
14.0,
-3000.0,
1378.0,
-4378.0,
-4156.0,
"short_term",
3000.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
null,
"INF179K01PT5",
true,
true,
"HDFC Small Cap Fund",
"equity",
90.0,
150.0,
250.0,
150.0,
187.0,
148.0,
84.0,
194.0,
103.0,
144.0,
89.0,
77.0,
154.0,
259.0,
9000.0,
1439.0,
7561.0,
7664.0,
"short_term",
22500.0,
"capital_gains",
"securities",
"15",
"111A"
],
[
null,
"INF251K01NO3",
true,
true,
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
31.536,
10.0,
5.0,
10.0,
226.0,
145.0,
95.0,
235.0,
46.0,
39.0,
196.0,
165.0,
142.0,
210.0,
-157.68,
1499.0,
-1656.68,
-1610.68,
"short_term",
157.68,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
],
[
null,
"INF200K01OR6",
true,
true,
"SBI Magnum Multicap Fund",
"equity",
130.0,
236.2069,
416.1538,
236.2069,
285.0,
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",
"112A"
],
[
null,
"INF277K01YE6",
true,
true,
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
60.0,
120.0,
160.0,
120.0,
155.25,
152.75,
96.0,
119.75,
158.5,
69.25,
42.75,
200.5,
94.75,
100.0,
2400.0,
1189.5,
1210.5,
1369.0,
"long_term",
9600.0,
"capital_gains",
"other_capital_gains",
"slab_rate",
null
]
]
},
{
"name": "etf_intraday_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"id",
"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": [
[
null,
"INF179KB1QR6",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
75.0,
125.0,
45.0,
58.0,
223.0,
275.0,
87.0,
82.0,
192.0,
279.0,
110.0,
211.0,
97.0,
-6000.0,
1614.0,
-7614.0,
-7614.0,
6000.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
null,
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
20.0,
15.0,
60.0,
80.0,
57.0,
95.0,
39.0,
16.0,
100.0,
34.0,
142.0,
145.0,
23.0,
900.0,
731.0,
169.0,
169.0,
900.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
null,
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
100.0,
550.0,
500.0,
154.0,
215.0,
271.0,
48.0,
238.0,
142.0,
90.0,
62.0,
219.0,
105.0,
-5000.0,
1544.0,
-6544.0,
-6544.0,
5000.0,
"business_and_profession",
"speculative",
"slab_rate"
],
[
null,
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
250.0,
650.0,
600.0,
134.0,
83.0,
241.0,
199.0,
265.0,
158.0,
193.0,
206.0,
113.0,
100.0,
-12500.0,
1692.0,
-14192.0,
-14192.0,
12500.0,
"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.0,
120.0,
null,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
15.0,
236.2069,
null,
null
],
[
"INF179KB1QR8",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
75.0,
150.0,
null,
null
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
50.0,
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": [
"id",
"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": [
[
null,
"NIFTY 15 JAN 2023 FUT",
"equity",
250,
168.0,
215.0,
324.0,
263.0,
81.0,
654.0,
532.0,
780.0,
237.0,
304.0,
258.0,
98.0,
11750.0,
3531.0,
8219.0,
8219.0,
11750.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"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"
],
[
null,
"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"
],
[
null,
"NIFTY 23 FEB 2023 FUT",
"equity",
175,
194.9,
199.5474,
276.0,
235.0,
185.0,
412.0,
909.0,
897.0,
338.0,
209.0,
162.0,
94.0,
813.295,
3717.0,
-2903.705,
-2903.705,
813.295,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 FUT",
"equity",
200,
151.64,
143.1565,
491.0,
410.0,
180.0,
579.0,
843.0,
1174.0,
499.0,
291.0,
616.0,
99.0,
-1696.7,
5182.0,
-6878.7,
-6878.7,
1696.7,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"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"
],
[
null,
"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"
],
[
null,
"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"
],
[
null,
"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"
],
[
null,
"NIFTY 25 JAN 2023 FUT",
"equity",
100,
175.55,
126.78,
83,
99,
135,
431,
165,
257,
307,
114,
154,
70,
-4877.0,
1815,
-6692.0,
-6692.0,
4877.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"BANKNIFTY 15 Jun 2023 FUT",
"equity",
50,
363.15,
447.26,
107.0,
254,
197.0,
452.0,
617.0,
779,
306,
377,
239.0,
38.0,
4205.5,
3366.0,
839.5,
839.5,
4205.5,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCOM CRUDEOIL 16 OCT 2022",
"commodity",
150,
428.6667,
444.6667,
297.0,
277.0,
303.0,
306.0,
343.0,
285.0,
167.0,
301,
362.0,
157.0,
2400.0,
2798.0,
-398.0,
-398.0,
2400.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"FUTCUR USDINR 27 JAN 2023 ",
"currency",
280,
89.0121,
76.4686,
714.0,
745.0,
946.0,
353.0,
589.0,
743.0,
809.0,
457.0,
708.0,
566.0,
-3512.18,
6630.0,
-10142.18,
-10142.18,
3512.18,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"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"
],
[
null,
"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"
],
[
null,
"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.0,
3990.023,
5744.769,
-1754.746,
-1754.746,
3990.023,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"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.0,
332.8476,
null,
null
],
[
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
20.0,
156.0,
null,
null
],
[
"FUTCOM GOLD 29 OCT 2023",
"commodity",
55.0,
124.56,
null,
null
],
[
"NIFTY 17 APR 2023 FUT",
"equity",
10.0,
457.89,
null,
null
],
[
"FINNIFTY 20 MAY 2023 FUT",
"equity",
10.0,
698.03,
null,
null
]
]
}
]
},
{
"name": "option_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "option_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"id",
"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": [
[
null,
"NIFTY 23 JAN 2023 CE 15000",
"equity",
200,
1520.0,
1572.05,
5062.0,
7923.0,
8172.0,
4952.0,
5649.0,
7322.0,
8969.0,
7257.0,
6000.0,
9275.0,
10410.0,
70581.0,
-60171.0,
-60171.0,
10410.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"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.0,
3990.023,
5744.769,
-1754.746,
-1754.746,
3990.023,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"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"
],
[
null,
"NIFTY 23 JAN 2023 CE 15650",
"equity",
100,
175.55,
126.78,
413,
889,
4927,
3468,
4048,
2500,
3454,
2211,
2302,
4240,
-4877.0,
28452,
-33329.0,
-33329.0,
4877.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"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"
],
[
null,
"BANKNIFTY 01 Jun 2023 CE 44200",
"equity",
75,
363.15,
439.94,
4510.0,
2627.0,
3787.0,
4575.0,
5183,
912.0,
5359.0,
2705.0,
3903.0,
1972.0,
5759.25,
35533.0,
-29773.75,
-29773.75,
5759.25,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"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"
],
[
null,
"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"
],
[
null,
"OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
"commodity",
150,
428.6667,
444.6667,
297.0,
277.0,
303.0,
306.0,
343.0,
285.0,
167.0,
301,
362.0,
157.0,
2400.0,
2798.0,
-398.0,
-398.0,
2400.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 JAN 2023 CE 15600",
"equity",
250,
168.0,
215.0,
6935,
4559.0,
5324.0,
6187.0,
3541.0,
5988.0,
4471.0,
3705.0,
7284.0,
5134,
11750.0,
53128.0,
-41378.0,
-41378.0,
11750.0,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"OPTCUR USDINR 27 JAN 2023 83 PE",
"currency",
280,
89.0121,
76.4686,
714.0,
745.0,
946.0,
353.0,
589.0,
743.0,
809.0,
457.0,
708.0,
566.0,
-3512.18,
6630.0,
-10142.18,
-10142.18,
3512.18,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"NIFTY 23 FEB 2023 PE 17100",
"equity",
105,
194.9,
191.9857,
2018.0,
3117.0,
5055.0,
3692.0,
5314.0,
3776.0,
2768.0,
5950.0,
2079.0,
4551.0,
-306.0015,
38320.0,
-38626.0015,
-38626.0015,
306.0015,
"business_and_profession",
"non_speculative",
"slab_rate"
],
[
null,
"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"
],
[
null,
"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"
],
[
null,
"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"
],
[
null,
"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"
],
[
null,
"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.0,
156.0,
null,
null
],
[
"OPTFUT GOLD 29 OCT 2023 60000 PE",
"commodity",
55.0,
124.56,
null,
null
],
[
"FINNIFTY 25 MAY 2023 CE 14900",
"equity",
10.0,
698.03,
null,
null
],
[
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
50.0,
332.8476,
null,
null
]
]
}
]
},
{
"name": "bond_scripwise_tax_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "bond_scripwise_tax_pnl_table",
"@entity": "table",
"header": [
"id",
"isin",
"security_name",
"is_listed",
"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",
"section"
],
"rows": [
[
null,
"INE112J07020",
"IFCI",
true,
170,
16.55,
500,
16.55,
137.3,
131.1,
121.95,
43.6,
62.0,
164.25,
175.95,
118.3,
95.4,
82186.5,
1049.85,
81136.65,
81136.65,
"short_term",
85000,
"capital_gains",
"securities",
"slab_rate",
null
],
[
null,
"INE261F07055",
"SGB",
true,
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",
"112"
],
[
null,
"INE272F07011",
"Blue Dart Express",
true,
20,
20,
200,
20.0,
122.0,
48.8,
124.0,
60.6,
16.2,
121.4,
46.0,
70.8,
88.0,
3600,
697.8,
2902.2,
2902.2,
"short_term",
4000,
"capital_gains",
"securities",
"slab_rate",
null
],
[
null,
"INE130K08000",
"SBOX",
true,
170,
16.55,
500,
16.55,
129.0,
112.6,
100.65,
84.85,
77.0,
198.9,
116.55,
201.15,
102.4,
82186.5,
1123.1,
81063.4,
81063.4,
"long_term",
85000,
"capital_gains",
"securities",
"20",
"112"
],
[
null,
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
1000,
10.0,
125.0,
10.0,
243.0,
289.0,
224.0,
193.0,
331.0,
260.0,
269.0,
263.0,
264.0,
115000.0,
2336.0,
112664.0,
112664.0,
"long_term",
125000.0,
"capital_gains",
"securities",
"10",
"112"
],
[
null,
"INE130K08001",
"QCK",
true,
200,
16.55,
500,
16.55,
91.0,
255.0,
38.0,
172.0,
198.0,
136.0,
125.0,
233.0,
158.0,
96690.0,
1406.0,
95284.0,
95284.0,
"long_term",
100000,
"capital_gains",
"securities",
"20",
"112"
],
[
null,
"INE130K08015",
"GGL",
true,
200,
550,
600,
550.0,
124.0,
106.0,
103.0,
118.0,
173.0,
79.0,
70.0,
112.0,
121.0,
10000,
1006.0,
8994.0,
8994.0,
"long_term",
120000,
"capital_gains",
"securities",
"10",
"112"
],
[
null,
"INE130K08019",
"APPL",
true,
180,
350,
310,
350.0,
214.6,
119.8,
135.0,
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",
null
]
]
},
{
"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.0,
20.0,
null,
null
],
[
"INE112J07020",
"IFCI",
30.0,
16.55,
null,
null
],
[
"INE130K08000",
"SBOX",
30.0,
16.55,
null,
null
],
[
"INE130K08019",
"APPL",
20.0,
350.0,
null,
null
],
[
"INE261F07055",
"SGB",
500.0,
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": [
"id",
"isin",
"security_name",
"is_listed",
"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",
"section"
],
"rows": [
[
null,
"INE112J07020",
"IFCI",
true,
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",
"112"
],
[
null,
"INE261F07055",
"SGB",
true,
450,
600,
789,
600.0,
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",
null
],
[
null,
"INE261F07055",
"SGB",
true,
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",
"112"
],
[
null,
"INE272F07011",
"Blue Dart Express",
true,
20,
20,
200,
20.0,
175.4,
207.2,
112.6,
140.8,
139.4,
104.0,
150.8,
316.0,
48.4,
3600,
1394.6,
2205.4,
2205.4,
"long_term",
4000,
"capital_gains",
"securities",
"10",
"112"
],
[
null,
"INE130K08000",
"SBOX",
true,
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",
"112"
],
[
null,
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
1000,
10,
10,
10.0,
401.0,
228.0,
457.0,
315.0,
294.0,
335.0,
328.0,
253.0,
324.0,
0,
2935.0,
-2935.0,
-2935.0,
"long_term",
10000,
"capital_gains",
"securities",
"10",
"112"
],
[
null,
"INE130K08001",
"QCK",
true,
200,
16.55,
500,
16.55,
211.0,
354.0,
419.0,
175.0,
173.0,
346.0,
281.0,
132.0,
417.0,
96690.0,
2508.0,
94182.0,
94182.0,
"long_term",
100000,
"capital_gains",
"securities",
"20",
"112"
],
[
null,
"INE130K08015",
"GGL",
true,
200,
550,
600,
550.0,
260.0,
142.0,
368.0,
282.0,
420.0,
265.0,
397.0,
109.0,
233.0,
10000,
2476.0,
7524.0,
7524.0,
"long_term",
120000,
"capital_gains",
"securities",
"10",
"112"
],
[
null,
"INE130K08019",
"APPL",
true,
180,
350,
310,
350.0,
205.5,
409.2,
100.2,
221.2,
170.1,
245.6,
231.5,
58.0,
305.6,
-7200,
1946.9,
-9146.9,
-9146.9,
"short_term",
55800,
"capital_gains",
"securities",
"slab_rate",
null
]
]
},
{
"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.0,
20.0,
null,
null
],
[
"INE112J07020",
"IFCI",
30.0,
16.55,
null,
null
],
[
"INE130K08000",
"SBOX",
30.0,
16.55,
null,
null
],
[
"INE130K08019",
"APPL",
20.0,
350.0,
null,
null
],
[
"INE261F07055",
"SGB",
500.0,
764.0,
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",
"tax_rate",
"section",
"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",
"15",
"111A",
"short_term",
412458.646,
386142.45,
386142.45,
412458.646,
26316.196,
3583.789,
22732.407,
23090.7859
],
[
"equity",
"share",
"capital_gains",
"securities",
"10",
"112A",
"long_term",
2051586.5276,
998919.4804,
998919.4804,
2051586.5276,
1052667.0472,
9596.053,
1043070.9942,
1044030.5995
],
[
"equity",
"share",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
5899.2096,
557381.9328,
557381.9328,
558009.1232,
627.1904,
5320.0,
-4692.8096,
-4692.8096
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
125840.004,
100787.121,
100787.121,
125840.004,
25052.883,
868.25,
24184.633,
24184.633
],
[
"equity",
"mutual_fund",
"capital_gains",
"securities",
"10",
"112A",
"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",
"slab_rate",
null,
"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",
"20",
112,
"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",
"slab_rate",
null,
"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",
"20",
"112",
"long_term",
8542.8,
7298.2,
10904.0036,
8542.8,
1244.6,
672.6772,
571.9228,
-3033.8808
],
[
"equity",
"etf",
"capital_gains",
"securities",
"15",
"111A",
"short_term",
22500.0,
13500.0,
13500.0,
22500.0,
9000.0,
1439.0,
7561.0,
7664.0
],
[
"equity",
"etf",
"capital_gains",
"securities",
"10",
"112A",
"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",
"slab_rate",
null,
"short_term",
3157.68,
6315.36,
6315.36,
3157.68,
-3157.68,
2877.0,
-6034.68,
-5766.68
],
[
"debt",
"etf",
"capital_gains",
"other_capital_gains",
"20",
"112",
"long_term",
9600.0,
7200.0,
7200.0,
9600.0,
2400.0,
1189.5,
1210.5,
1369.0
],
[
"other",
"etf",
"capital_gains",
"other_capital_gains",
"slab_rate",
null,
"short_term",
23000.0,
46107.785,
46107.785,
23000.0,
-23107.785,
1234.3332,
-24342.1182,
-24223.7849
],
[
"other",
"etf",
"capital_gains",
"other_capital_gains",
"20",
"112",
"long_term",
0,
0,
0,
0,
0,
0,
0,
0
],
[
"equity",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
11000.0,
64375.0,
64375.0,
53375.0,
-11000.0,
3158.0,
-14158.0,
-14158.0
],
[
"debt",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
12500.0,
162500.0,
162500.0,
150000.0,
-12500.0,
1692.0,
-14192.0,
-14192.0
],
[
"other",
"etf",
"business_and_profession",
"speculative",
"slab_rate",
null,
"intraday",
900.0,
300.0,
300.0,
1200.0,
900.0,
731.0,
169.0,
169.0
],
[
"equity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
181749.295,
642549.2,
642549.2,
522096.795,
-120452.405,
30187.5335,
-150639.9385,
-150639.9385
],
[
"commodity",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
6390.023,
104649.996,
104649.996,
111040.019,
6390.023,
8542.769,
-2152.746,
-2152.746
],
[
"currency",
"future",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
17858.157,
453010.386,
453010.386,
450233.1155,
-2777.2705,
16919.2501,
-19696.5206,
-19696.5206
],
[
"equity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
224838.7515,
944059.3,
944059.3,
794253.9485,
-149805.3515,
384506.0001,
-534311.3516,
-534311.3516
],
[
"commodity",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
6390.023,
104649.996,
104649.996,
111040.019,
6390.023,
8542.769,
-2152.746,
-2152.746
],
[
"currency",
"option",
"business_and_profession",
"non_speculative",
"slab_rate",
null,
null,
17858.157,
453010.386,
453010.386,
450233.1155,
-2777.2705,
16919.2501,
-19696.5206,
-19696.5206
],
[
"debt",
"bond",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
144800,
66213.5,
66213.5,
144800,
78586.5,
2965.15,
75621.35,
75621.35
],
[
"debt",
"bond",
"capital_gains",
"securities",
"10",
"112",
"long_term",
642500.02,
402323.48,
402323.48,
642500.02,
240176.54,
7880.9,
232295.64,
232295.64
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"slab_rate",
null,
"short_term",
410850,
333000,
333000.0,
410850,
77850,
4028.8455,
73821.1545,
73821.1545
],
[
"debt",
"debenture",
"capital_gains",
"securities",
"10",
"112",
"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.0,
12247.0,
370000,
357753.0,
6559.45,
351193.55,
351193.55
],
[
"business_and_profession",
"speculative",
"intraday",
"slab_rate",
30299.2096,
784556.9328,
784556.9328,
762584.1232,
-21972.8096,
10901.0,
-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.0,
7200.0,
120.0,
9600.0,
2400.0,
1189.5,
1210.5,
1369.0
],
[
"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
]
]
}
]
}
]
}