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"],
"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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"]
]
},
{
"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"],
"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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"]
]
}
]
},
{
"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"],
"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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"]
]
},
{
"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"],
"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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"]
]
}
]
},
{
"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"],
"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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"],
["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"]
]
}
]
},
{
"name": "tax_pnl_summary_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "asset_wise_summary_table",
"@entity": "table",
"header": ["asset_class", "asset_type", "income_head", "income_sub_head", "holding_period", "turnover", "buy_value", "cost_of_acquisition", "sell_value", "realized_pnl", "transfer_expenses", "net_realized_pnl", "taxable_pnl"],
"rows": [
["equity", "share", "capital_gains", "securities", "short_term", 412458.64, 386142.45, 386142.45, 412458.64, 26316.19, 3583.789, 22732.401, 23090.7799],
["equity", "share", "capital_gains", "securities", "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, 0, 0, 0, 0, 0, 0, 0, 0],
["equity", "share", "business_and_profession", "speculative", "intraday", 6579.2, 557381.92, 557381.92, 558009.12, 627.2, 5320.0, -4692.8, -4692.8],
["equity", "mutual_fund", "capital_gains", "securities", "short_term", 125840.0, 100787.12, 100787.12, 125840.0, 25052.88, 868.25, 24184.63, 24184.63],
["equity", "mutual_fund", "capital_gains", "securities", "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", "short_term", 29168.115, 1793.73, 1793.73, 29168.115, 27374.385, 166.5909, 27207.7941, 27207.7941],
["debt", "mutual_fund", "capital_gains", "other_capital_gains", "long_term", 5293.22, 3429.57, 4264.5603, 5293.22, 1863.65, 263.7233, 1599.9267, 764.9364],
["other", "mutual_fund", "capital_gains", "other_capital_gains", "short_term", 10706.2, 14237.904304, 14237.904304, 10706.2, -3531.7043, 156.6621, -3688.3664, -3688.3664],
["other", "mutual_fund", "capital_gains", "other_capital_gains", "long_term", 8542.8, 7298.2, 10904.0036, 8542.8, 1244.6, 672.6772, 571.9228, -3033.8808],
["equity", "etf", "capital_gains", "securities", "short_term", 22500.0, 13500.0, 13500.0, 22500.0, 9000.0, 1439.0, 7561.0, 7664.0],
["equity", "etf", "capital_gains", "securities", "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", "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", "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", "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", "long_term", 0, 0, 0, 0, 0, 0, 0, 0],
["equity", "etf", "business_and_profession", "speculative", "intraday", 11000.0, 64375.0, 64375.0, 53375.0, -11000.0, 3158.0, -14158.0, -14158.0],
["debt", "etf", "business_and_profession", "speculative", "intraday", 12500.0, 162500.0, 162500.0, 150000.0, -12500.0, 1692.0, -14192.0, -14192.0],
["other", "etf", "business_and_profession", "speculative", "intraday", 900.0, 300.0, 300.0, 1200.0, 900.0, 731.0, 169.0, 169.0],
["equity", "future", "business_and_profession", "non_speculative", null, 186560.3, 642549.2, 642549.2, 522096.8, -120452.4, 30187.5335, -150639.9335, -150639.9335],
["commodity", "future", "business_and_profession", "non_speculative", null, 7089.999, 104650.001, 104650.001, 111040, 6389.999, 8542.769, -2152.77, -2152.77],
["currency", "future", "business_and_profession", "non_speculative", null, 21664.998, 453010.384, 453010.384, 450233.1, -2777.284, 16919.2501, -19696.5341, -19696.5341],
["equity", "option", "business_and_profession", "non_speculative", null, 240117.75, 944059.3, 944059.3, 794253.95, -149805.35, 384506.0001, -534311.3501, -534311.3501],
["commodity", "option", "business_and_profession", "non_speculative", null, 7089.999, 104650.001, 104650.001, 111040, 6389.999, 8542.769, -2152.77, -2152.77],
["currency", "option", "business_and_profession", "non_speculative", null, 21664.99, 453010.388, 453010.388, 450233.1, -2777.288, 16919.2501, -19696.5381, -19696.5381],
["debt", "bond", "capital_gains", "securities", "short_term", 144800.0, 66213.5, 66213.5, 144800, 78586.5, 2965.15, 75621.35, 75621.35],
["debt", "bond", "capital_gains", "securities", "long_term", 642500.0, 402323.5, 402323.5, 642500, 240176.5, 7880.9, 232295.6, 232295.6],
["debt", "debenture", "capital_gains", "securities", "short_term", 410850.0, 333000, 333000.0, 410850, 77850.0, 4028.8455, 73821.1545, 73821.1545],
["debt", "debenture", "capital_gains", "securities", "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": ["isin", "symbol", "is_listed", "quantity", "buy_average", "sell_average", "cost_of_acquisition", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "realized_pnl", "total_transfer_expenses", "net_realized_pnl", "taxable_pnl", "holding_period", "turnover", "income_head", "income_sub_head", "tax_rate"],
"rows": [
["INE00E101023", "BIKAJI", true, 140.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"],
["INE00E101023", "BIKAJI", 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"],
["INE462A01022", "BAYERCROP", 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"],
["INE462A01022", "BAYERCROP", 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"],
["INE01C001018", "ADANIPORTS", 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"],
["INE364U01010", "ADANIGREEN", 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"],
["INE002A01018", "AJANTAPHARMA", 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"],
["INE002A01018", "AJANTAPHARMA", 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"]
]
},
{
"name": "stock_intraday_scripwise_tax_pnl_table",
"@entity": "table",
"header": ["isin", "symbol", "quantity", "buy_average", "sell_average", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "realized_pnl", "total_transfer_expenses", "net_realized_pnl", "taxable_pnl", "turnover", "income_head", "income_sub_head", "tax_rate"],
"rows": [
["INE01C001018", "ADANIPORTS", 20.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"],
["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"],
["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"],
["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"],
["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": ["isin", "scheme_name", "asset_class", "quantity", "buy_average", "sell_average", "cost_of_acquisition", "realized_pnl", "transfer_expenses", "net_realized_pnl", "taxable_pnl", "holding_period", "turnover", "income_head", "income_subhead", "tax_rate"],
"rows": [
["INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", 17.823, 10, 5, 10.0, -89.115, 66.9329, -156.0479, -156.0479, "short_term", 89.115, "capital_gains", "other_capital_gains", "slab_rate"],
["INF200K01OR6", "SBI Magnum Multicap Fund", "equity", 125, 150, 400, 160.0, 31250, 107.1985, 31142.8015, 29892.8015, "long_term", 50000, "capital_gains", "securities", "10"],
["INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", 36.023, 30, 60, 34.96, 1080.69, 168.0, 912.69, 734.01592, "long_term", 2161.38, "capital_gains", "other_capital_gains", "20"],
["INF200K01189", "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"],
["INF200K01189", "SBI Gold Fund", "other", 35, 200, 210, 300.91, 350, 624.6364, -274.6364, -3806.4864, "long_term", 7350, "capital_gains", "other_capital_gains", "20"],
["INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", 32.531, 400.784, 200, 400.784, -6531.704304, 108.5685, -6640.272804, -6640.272804, "short_term", 6506.2, "capital_gains", "other_capital_gains", "slab_rate"],
["INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", 19.574, 120, 160, 153.53, 782.96, 95.7233, 687.2367, 30.92048, "long_term", 3131.84, "capital_gains", "other_capital_gains", "20"],
["INF200K01190", "KOTAK SEC FUND", "equity", 90, 988.8889, 1255.5556, 988.8889, 24000.003, 818.0, 23182.003, 23182.003, "short_term", 113000.004, "capital_gains", "securities", "15"],
["INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", 32.31, 50, 900, 50.0, 27463.5, 99.658, 27363.842, 27363.842, "short_term", 29079.0, "capital_gains", "other_capital_gains", "slab_rate"],
["INF846K01DI2", "Axis Bluechip Fund", "equity", 605.9, 124.2586, 211.1733, 124.2586, 52661.61673, 171.3589, 52490.25783, 52490.25783, "long_term", 127949.90247, "capital_gains", "securities", "10"],
["INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", 19.88, 15, 60, 18.72, 894.6, 48.0408, 846.5592, 772.6056, "long_term", 1192.8, "capital_gains", "other_capital_gains", "20"],
["INF760K01FR2", "Canara Robeco Bluechip Equity Growth Direct Plan", "equity", 155, 23.78, 56.9, 23.78, 5133.6, 4.0, 5129.6, 5129.6, "long_term", 8819.5, "capital_gains", "securities", "10"],
["INF179KB1HP9", "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"]
]
},
{
"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": ["isin", "scheme_name", "asset_class", "quantity", "buy_average", "sell_average", "cost_of_acquisation", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "realized_pnl", "total_transfer_expenses", "net_realized_pnl", "taxable_pnl", "holding_period", "turnover", "income_head", "income_sub_head", "tax_rate"],
"rows": [
["INF200K01189", "SBI Gold Fund", "other", 50.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"],
["INF109KB1GK2", "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"],
["INF846K01DI2", "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"],
["INF278A06YE8", "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"],
["INF179K01PT5", "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"],
["INF251K01NO3", "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"],
["INF200K01OR6", "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"],
["INF277K01YE6", "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"]
]
},
{
"name": "etf_intraday_scripwise_tax_pnl_table",
"@entity": "table",
"header": ["isin", "scheme_name", "asset_class", "quantity", "buy_average", "sell_average", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "realized_pnl", "total_transfer_expenses", "net_realized_pnl", "taxable_pnl", "turnover", "income_head", "income_sub_head", "tax_rate"],
"rows": [
["INF179KB1QR6", "ICICI LIQUID FUND - DIRECT PLAN", "equity", 75.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"],
["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"],
["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"],
["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": ["contract_name", "asset_class", "quantity", "buy_average", "sell_average", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "realized_pnl", "total_transfer_expenses", "net_realized_pnl", "taxable_pnl", "turnover", "income_head", "income_sub_head", "tax_rate"],
"rows": [
["NIFTY 15 JAN 2023 FUT", "equity", 250, 168.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"],
["BANKNIFTY 20 MAR 2023 FUT", "equity", 125, 1500, 615.89, 163, 136, 43, 365, 210, 795, 289, 231, 294, 28, -110513.75, 2554, -113067.75, -113067.75, 110513.75, "business_and_profession", "non_speculative", "slab_rate"],
["FINNIFTY 15 FEB 2023 FUT", "equity", 155, 194.9, 174.55, 169, 118, 141, 341, 338, 281, 40, 181, 75, 66, -3154.25, 1750, -4904.25, -4904.25, 3154.25, "business_and_profession", "non_speculative", "slab_rate"],
["NIFTY 23 FEB 2023 FUT", "equity", 175, 194.9, 199.5474, 276.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"],
["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"],
["FUTCUR EURINR 13 MAY 2023", "currency", 195, 281.7436, 269.7385, 269, 639, 649, 625, 520, 375, 222, 669, 671, 434, -2340.9945, 5073, -7413.9945, -7413.9945, 2340.9945, "business_and_profession", "non_speculative", "slab_rate"],
["NIFTY 17 APR 2023 FUT", "equity", 135, 457.89, 489.67, 253.9655, 165.6897, 148.4828, 229.6207, 339.8966, 520.2759, 45.8276, 193.0345, 132.6897, 62.8966, 4290.3, 2092.3796, 2197.9204, 2197.9204, 4290.3, "business_and_profession", "non_speculative", "slab_rate"],
["FINNIFTY 20 MAY 2023 FUT", "equity", 120, 698.03, 745.32, 228.4615, 114.5385, 117.1538, 269.6154, 244.6923, 755.2308, 157.5385, 179, 103.3077, 67.6154, 5674.8, 2237.1539, 3437.6461, 3437.6461, 5674.8, "business_and_profession", "non_speculative", "slab_rate"],
["FINNIFTY 25 JAN 2023 FUT", "equity", 35, 3450.67, 2568.98, 155, 183, 79, 296, 369, 171, 270, 191, 55, 32, -30859.15, 1801, -32660.15, -32660.15, 30859.15, "business_and_profession", "non_speculative", "slab_rate"],
["NIFTY 25 JAN 2023 FUT", "equity", 100, 175.55, 126.78, 83, 99, 135, 431, 165, 257, 307, 114, 154, 70, -4877.0, 1815, -6692.0, -6692.0, 4877.0, "business_and_profession", "non_speculative", "slab_rate"],
["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"],
["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"],
["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"],
["FUTCUR JPYINR 24 AUG 2023", "currency", 110, 324.0636, 345.89, 139.4167, 478.0833, 191.3333, 340.5, 286, 402.6667, 451.75, 231.4167, 271.4167, 429.6667, 2400.904, 3222.2501, -821.3461, -821.3461, 2400.904, "business_and_profession", "non_speculative", "slab_rate"],
["FUTCUR GBPINR 27 OCT 2023", "currency", 75, 4500, 4509, 36, 272, 216, 140, 125, 195, 179, 416, 306, 109, 675, 1994, -1319, -1319, 675, "business_and_profession", "non_speculative", "slab_rate"],
["FUTCOM SILVERM 21 Nov 2022 ", "commodity", 290, 139.1379, 152.8966, 1363.0769, 516.6923, 363.8461, 460.2307, 464.7692, 496.1538, 616.3077, 462.7692, 491.9231, 509.0, 3990.023, 5744.769, -1754.746, -1754.746, 3990.023, "business_and_profession", "non_speculative", "slab_rate"],
["BANKNIFTY 01 Jun 2023 FUT", "equity", 45, 363.1, 450.09, 162, 153, 89, 139, 323, 655, 157, 166, 223, 75, 3914.55, 2142, 1772.55, 1772.55, 3914.55, "business_and_profession", "non_speculative", "slab_rate"]
]
},
{
"name": "future_scripwise_open_position_table",
"@entity": "table",
"header": ["contract_name", "asset_class", "quantity", "trade_price_average", "last_traded_price", "unrealized_pnl"],
"rows": [
["FUTCUR JPYINR 24 AUG 2023", "currency", 50.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": ["contract_name", "asset_class", "quantity", "buy_average", "sell_average", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "realized_pnl", "total_transfer_expenses", "net_realized_pnl", "taxable_pnl", "turnover", "income_head", "income_sub_head", "tax_rate"],
"rows": [
["NIFTY 23 JAN 2023 CE 15000", "equity", 200, 1520.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"],
["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"],
["FINNIFTY 25 JAN 2023 CE 12500", "equity", 50, 3450.67, 2568.98, 1150, 1886, 1142, 4223, 3569, 922, 2014, 2594, 2594, 4292, -44084.5, 24386, -68470.5, -68470.5, 44084.5, "business_and_profession", "non_speculative", "slab_rate"],
["NIFTY 23 JAN 2023 CE 15650", "equity", 100, 175.55, 126.78, 413, 889, 4927, 3468, 4048, 2500, 3454, 2211, 2302, 4240, -4877.0, 28452, -33329.0, -33329.0, 4877.0, "business_and_profession", "non_speculative", "slab_rate"],
["BANKNIFTY 01 Jun 2023 CE 44100", "equity", 25, 363.1, 450.09, 2042, 1503, 2560, 2913, 3807, 806, 2343, 2686, 3601, 3712, 2174.75, 25973, -23798.25, -23798.25, 2174.75, "business_and_profession", "non_speculative", "slab_rate"],
["BANKNIFTY 01 Jun 2023 CE 44200", "equity", 75, 363.15, 439.94, 4510.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"],
["NIFTY 17 APR 2023 PE 17800", "equity", 55, 457.89, 489.67, 3285, 2479, 3549, 2207, 887, 4521, 2418, 2583, 3198, 3116, 1747.9, 28243, -26495.1, -26495.1, 1747.9, "business_and_profession", "non_speculative", "slab_rate"],
["FINNIFTY 25 MAY 2023 CE 14900", "equity", 120, 698.03, 745.32, 1449.5385, 3136.4615, 2506.2308, 2420.1538, 3149.4615, 2487.5385, 1381.2308, 1990.5385, 2904.3077, 1452.5385, 5674.8, 22878.0001, -17203.2001, -17203.2001, 5674.8, "business_and_profession", "non_speculative", "slab_rate"],
["OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 150, 428.6667, 444.6667, 297.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"],
["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"],
["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"],
["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"],
["OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 110, 324.0636, 345.89, 139.4167, 478.0833, 191.3333, 340.5, 286, 402.6667, 451.75, 231.4167, 271.4167, 429.6667, 2400.904, 3222.2501, -821.3461, -821.3461, 2400.904, "business_and_profession", "non_speculative", "slab_rate"],
["OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 195, 281.7436, 269.7385, 269, 639, 649, 625, 520, 375, 222, 669, 671, 434, -2340.9945, 5073, -7413.9945, -7413.9945, 2340.9945, "business_and_profession", "non_speculative", "slab_rate"],
["OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 75, 4500, 4509, 36, 272, 216, 140, 125, 195, 179, 416, 306, 109, 675, 1994, -1319, -1319, 675, "business_and_profession", "non_speculative", "slab_rate"],
["FINNIFTY 15 FEB 2023 CE 13400", "equity", 50, 194.9, 174.55, 2524, 4142, 3167, 4280, 1285, 2547, 898, 2368, 1478, 3531, -1017.5, 26220, -27237.5, -27237.5, 1017.5, "business_and_profession", "non_speculative", "slab_rate"],
["BANKNIFTY 20 MAR 2023 PE 18900", "equity", 155, 1500, 615.89, 1946, 1071, 3214, 3408, 2371, 3297, 4858, 3054, 3132, 4441, -137037.05, 30792, -167829.05, -167829.05, 137037.05, "business_and_profession", "non_speculative", "slab_rate"]
]
},
{
"name": "option_scripwise_open_position_table",
"@entity": "table",
"header": ["contract_name", "asset_class", "quantity", "trade_price_average", "last_traded_price", "unrealized_pnl"],
"rows": [
["OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 20.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": ["isin", "security_name", "quantity", "buy_average", "sell_average", "cost_of_acquisition", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fee", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "realized_pnl", "total_transfer_expenses", "net_realized_pnl", "taxable_pnl", "holding_period", "turnover", "income_head", "income_sub_head", "tax_rate"],
"rows": [
["INE112J07020", "IFCI", 170, 16.55, 500, 16.55, 137.3, 131.1, 121.95, 43.6, 62.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"],
["INE261F07055", "SGB", 600, 460.3333, 354.1667, 460.3333, 286.4, 186.2, 288.6, 226.2, 151.2, 113.4, 268.6, 152.4, 336.8, -63699.96, 2009.8, -65709.76, -65709.76, "long_term", 212500.02, "capital_gains", "securities", "10"],
["INE272F07011", "Blue Dart Express", 20, 20, 200, 20.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"],
["INE130K08000", "SBOX", 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"],
["INE261F07032", "07.64% NABARD TFB 2031", 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"],
["INE130K08001", "QCK", 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"],
["INE130K08015", "GGL", 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"],
["INE130K08019", "APPL", 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"]
]
},
{
"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": ["isin", "security_name", "quantity", "buy_average", "sell_average", "cost_of_acquisation", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "realized_pnl", "total_transfer_expenses", "net_realized_pnl", "taxable_pnl", "holding_period", "turnover", "income_head", "income_sub_head", "tax_rate"],
"rows": [
["INE112J07020", "IFCI", 170, 16.55, 500, 16.55, 191.9, 231.6, 317.2, 337.45, 305.5, 219.05, 249.5, 253.5, 148.25, 82186.5, 2253.95, 79932.55, 79932.55, "long_term", 85000, "capital_gains", "securities", "10"],
["INE261F07055", "SGB", 450, 600, 789, 600.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"],
["INE261F07055", "SGB", 150, 793.3333, 822.6667, 793.3333, 359.4545, 339.3545, 314.9455, 225.6364, 415.8, 314.2818, 164.7273, 401.9727, 103.8818, 4400.01, 2640.0545, 1759.9555, 1759.9555, "long_term", 123400.005, "capital_gains", "securities", "10"],
["INE272F07011", "Blue Dart Express", 20, 20, 200, 20.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"],
["INE130K08000", "SBOX", 170, 16.55, 500, 16.55, 188.8, 192.8, 153.7, 23.45, 261.5, 187.9, 94.1, 227.95, 192.15, 82186.5, 1522.35, 80664.15, 80664.15, "long_term", 85000, "capital_gains", "securities", "20"],
["INE261F07032", "07.64% NABARD TFB 2031", 1000, 10, 10, 10.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"],
["INE130K08001", "QCK", 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"],
["INE130K08015", "GGL", 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"],
["INE130K08019", "APPL", 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"]
]
},
{
"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", "holding_period", "turnover", "buy_value", "cost_of_acquisition", "sell_value", "realized_pnl", "transfer_expenses", "net_realized_pnl", "taxable_pnl"],
"rows": [
["equity", "share", "capital_gains", "securities", "short_term", 412458.646, 386142.45, 386142.45, 412458.646, 26316.196, 3583.789, 22732.407, 23090.7859],
["equity", "share", "capital_gains", "securities", "long_term", 2051586.5276, 998919.4804, 998919.4804, 2051586.5276, 1052667.0472, 9596.053, 1043070.9942, 1044030.5995],
["equity", "share", "business_and_profession", "speculative", "intraday", 5899.2096, 557381.9328, 557381.9328, 558009.1232, 627.1904, 5320.0, -4692.8096, -4692.8096],
["equity", "mutual_fund", "capital_gains", "securities", "short_term", 125840.004, 100787.121, 100787.121, 125840.004, 25052.883, 868.25, 24184.633, 24184.633],
["equity", "mutual_fund", "capital_gains", "securities", "long_term", 186769.40247, 97724.18574, 98974.18574, 186769.40247, 89045.21673, 282.5574, 88762.65933, 87512.65933],
["debt", "mutual_fund", "capital_gains", "other_capital_gains", "short_term", 29168.115, 1793.73, 1793.73, 29168.115, 27374.385, 166.5909, 27207.7941, 27207.7941],
["debt", "mutual_fund", "capital_gains", "other_capital_gains", "long_term", 5293.22, 3429.57, 4264.5603, 5293.22, 1863.65, 263.7233, 1599.9267, 764.9364],
["other", "mutual_fund", "capital_gains", "other_capital_gains", "short_term", 10706.2, 14237.904304, 14237.904304, 10706.2, -3531.704304, 156.6621, -3688.366404, -3688.366404],
["other", "mutual_fund", "capital_gains", "other_capital_gains", "long_term", 8542.8, 7298.2, 10904.0036, 8542.8, 1244.6, 672.6772, 571.9228, -3033.8808],
["equity", "etf", "capital_gains", "securities", "short_term", 22500.0, 13500.0, 13500.0, 22500.0, 9000.0, 1439.0, 7561.0, 7664.0],
["equity", "etf", "capital_gains", "securities", "long_term", 60963.994, 32500.897, 32500.897, 60963.994, 28463.097, 5817.5862, 22645.5108, 23210.9246],
["debt", "etf", "capital_gains", "other_capital_gains", "short_term", 3157.68, 6315.36, 6315.36, 3157.68, -3157.68, 2877.0, -6034.68, -5766.68],
["debt", "etf", "capital_gains", "other_capital_gains", "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", "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", "long_term", 0, 0, 0, 0, 0, 0, 0, 0],
["equity", "etf", "business_and_profession", "speculative", "intraday", 11000.0, 64375.0, 64375.0, 53375.0, -11000.0, 3158.0, -14158.0, -14158.0],
["debt", "etf", "business_and_profession", "speculative", "intraday", 12500.0, 162500.0, 162500.0, 150000.0, -12500.0, 1692.0, -14192.0, -14192.0],
["other", "etf", "business_and_profession", "speculative", "intraday", 900.0, 300.0, 300.0, 1200.0, 900.0, 731.0, 169.0, 169.0],
["equity", "future", "business_and_profession", "non_speculative", null, 181749.295, 642549.2, 642549.2, 522096.795, -120452.405, 30187.5335, -150639.9385, -150639.9385],
["commodity", "future", "business_and_profession", "non_speculative", null, 6390.023, 104649.996, 104649.996, 111040.019, 6390.023, 8542.769, -2152.746, -2152.746],
["currency", "future", "business_and_profession", "non_speculative", null, 17858.157, 453010.386, 453010.386, 450233.1155, -2777.2705, 16919.2501, -19696.5206, -19696.5206],
["equity", "option", "business_and_profession", "non_speculative", null, 224838.7515, 944059.3, 944059.3, 794253.9485, -149805.3515, 384506.0001, -534311.3516, -534311.3516],
["commodity", "option", "business_and_profession", "non_speculative", null, 6390.023, 104649.996, 104649.996, 111040.019, 6390.023, 8542.769, -2152.746, -2152.746],
["currency", "option", "business_and_profession", "non_speculative", null, 17858.157, 453010.386, 453010.386, 450233.1155, -2777.2705, 16919.2501, -19696.5206, -19696.5206],
["debt", "bond", "capital_gains", "securities", "short_term", 144800, 66213.5, 66213.5, 144800, 78586.5, 2965.15, 75621.35, 75621.35],
["debt", "bond", "capital_gains", "securities", "long_term", 642500.02, 402323.48, 402323.48, 642500.02, 240176.54, 7880.9, 232295.64, 232295.64],
["debt", "debenture", "capital_gains", "securities", "short_term", 410850, 333000, 333000.0, 410850, 77850, 4028.8455, 73821.1545, 73821.1545],
["debt", "debenture", "capital_gains", "securities", "long_term", 527400.005, 248336.995, 248336.995, 527400.005, 279063.01, 15729.9545, 263333.0555, 263333.0555]
]
},
{
"name": "tax_pnl_summary_table",
"@entity": "table",
"header": ["income_head", "income_sub_head", "holding_period", "tax_rate", "turnover", "buy_value", "cost_of_acquisition", "sell_value", "realized_pnl", "transfer_expenses", "net_realized_pnl", "taxable_pnl"],
"rows": [
["capital_gains", "securities", "short_term", "slab_rate", 555650, 399213.5, 399213.5, 555650, 156436.5, 6993.9955, 149442.5045, 149442.5045],
["capital_gains", "securities", "short_term", "15", 560798.65, 500429.571, 387740.3389, 560798.65, 60369.079, 5891.039, 54478.04, 54939.4189],
["capital_gains", "securities", "long_term", "10", 3099219.94907, 1767558.03814, 1637900.2009, 3099219.94907, 1331661.91093, 32747.6011, 1298914.30983, 1299189.32893],
["capital_gains", "securities", "long_term", "20", 370000, 12247.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]
]
}
]
}
]
}