PUT Request on Presigned URL
Once the job is successfully created, upload the payload using HTTP PUT method on generated presigned url. Read More
JSON Payload
This API accepts payload in following three formats:
Tradebook
Click here to learn more about this JSON Payload
{
"@entity": "workbook",
"name": "workbook",
"sheets": [
{
"@entity": "sheet",
"name": "stock_tradebook_sheet",
"blocks": [
{
"@entity": "table",
"name": "stock_tradebook_table",
"header": ["trade_id", "isin", "symbol", "is_listed", "is_stt_paid", "quantity", "date", "price", "transaction_type", "fmv", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label", "product_type"],
"rows": [["1a", "INE002A01019", "AJANTA PHARMA LIMITED", true, false, 33, 1483488000000, 200, "buy ", 645, 94, 0, 0, 0, 0, 4, 0, 0, 0, 0, "gift", "delivery"]]
}
]
},
{
"@entity": "sheet",
"name": "future_tradebook_sheet",
"blocks": [
{
"@entity": "table",
"name": "future_tradebook_table",
"header": ["trade_id", "isin", "contract_name", "asset_class", "quantity", "date", "price", "transaction_type", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label"],
"rows": [
["12345a", "CRUDE21APR14700CE"],
["Commodity", 75, 1577836800000, 363.1, "buy", 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 43831]
]
}
]
},
{
"@entity": "sheet",
"name": "option_tradebook_sheet",
"blocks": []
},
{
"@entity": "sheet",
"name": "mutual_fund_tradebook_sheet",
"blocks": [
{
"@entity": "table",
"name": "mutual_fund_tradebook_table",
"header": ["trade_id", "isin", "scheme_name", "Asset Class", "quantity", "date", "price", "transaction_type", "fmv", "transfer_expenses", "label"],
"rows": [["15648a", "INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", 32.31, 1528243200000, 50, "buy", 400, 10, "transfer"]]
}
]
},
{
"@entity": "sheet",
"name": "etf_tradebook_sheet",
"blocks": [
{
"@entity": "table",
"name": "etf_tradebook_table",
"header": ["trade_id", "isin", "scheme_name", "Asset Class", "quantity", "date", "price", "transaction_type", "fmv", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label", "product_type"],
"rows": [["15648a", "INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", 250, 1118016000000, 50, "buy", 400, 0, 0, 0, 0, 5, 0, 18, 18, 0, 0, "gift", "delivery"]]
}
]
},
{
"@entity": "sheet",
"name": "bond_tradebook_sheet",
"blocks": [
{
"@entity": "table",
"name": "bond_tradebook_table",
"header": ["trade_id", "isin", "security_name", "is_listed", "quantity", "date", "price", "transaction_type", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label"],
"rows": [["1a", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1577836800000, 10, "buy", 1, 0, 6, 0, 0, 0, 0, 0, 0, "gift"]]
}
]
},
{
"@entity": "sheet",
"name": "debenture_tradebook_sheet",
"blocks": [
{
"@entity": "table",
"name": "debenture_tradebook_table",
"header": ["trade_id", "isin", "security_name", "is_listed", "quantity", "date", "price", "transaction_type", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "label"],
"rows": [["1a", "INE261F07032", "07.64% NABARD TFB 2031", true, 1000, 1292889600000, 10, "buy", 1, 0, 6, 0, 0, 0, 0, 0, 0, "gift"]]
}
]
}
]
}
Tradewise PnL
Click here to learn more about this JSON Payload
{
"name": "tradewise_settlement_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "stock_tradewise_settlement_sheet",
"@entity": "sheet",
"blocks": [
{
"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_tradewise_transfer_table", "@entity": "table", "header": ["isin", "symbol", "quantity", "transfer_date", "price", "transfer_type", "nature_of_transfer", "transfer_value", "transfer_expense"], "rows": [] },
{
"name": "stock_tradewise_settlement_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", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fee", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "nature_of_settlement", "product_type", "realized_pnl", "total_transfer_expenses", "net_realized_pnl"],
"rows": [
["INE002A01018", "AJANTAPHARMA", true, true, 645.0, "CJ1CLC4YCBFEZ4CVDNMH", 1463356800000, 136.0, "CYX9TQSTWUYK8C9Z7BCE", 1650412800000, 580.0, 438, 64.0981, 64.0981, 64.0981, 64.0981, 64.0981, 64.0981, 64.0981, 64.0981, 64.0981, 64.0981, "trade", "delivery", 286380.0, 640.981, 285739.019],
["INE002A01018", "AJANTAPHARMA", true, true, 900.0, "CJ1CLC4YCBFEZ4CVDNMH", 1463356800000, 136.0, "3S1E2CVMTK3I115OG5IT", 1672876800000, 618.0, 438, 71.4113, 71.4113, 71.4113, 71.4113, 71.4113, 71.4113, 71.4113, 71.4113, 71.4113, 71.4113, "trade", "delivery", 433800.0, 714.113, 433085.887],
["INE002A01018", "AJANTAPHARMA", true, true, 45.0, "CJ1CLC4YCBFEZ4CVDNMH", 1463356800000, 136.0, "HJWC2DJPNJV7KBYAVLMP", 1692921600000, 689.0, 438, 12.0906, 12.0906, 12.0906, 12.0906, 12.0906, 12.0906, 12.0906, 12.0906, 12.0906, 12.0906, "trade", "delivery", 24885.0, 120.906, 24764.094],
["INE002A01018", "AJANTAPHARMA", true, true, 145.0, "J9SYLEPLST8YFGPUOFCG", 1686182400000, 578.0, "HJWC2DJPNJV7KBYAVLMP", 1692921600000, 689.0, 438, 80.4, 80.4, 80.4, 80.4, 80.4, 80.4, 80.4, 80.4, 80.4, 80.4, "trade", "delivery", 16095.0, 804.0, 15291.0],
["INE462A01022", "BAYERCROP", true, true, 25.0, "SUNMAQYIBRDSM4Y2TVW9", 1436313600000, 4203.45, "8LWK9OAGZ64HKNYHYX6H", 1681862400000, 4217.67, 4199.55, 82.3742, 82.3742, 82.3742, 82.3742, 82.3742, 82.3742, 82.3742, 82.3742, 82.3742, 82.3742, "trade", "delivery", 355.5, 823.742, -468.242],
["INE462A01022", "BAYERCROP", true, true, 6.0, "PEB6U5ERJBDTNFSLPOI2", 1482451200000, 4089.0, "8LWK9OAGZ64HKNYHYX6H", 1681862400000, 4217.67, 4199.55, 16.2204, 16.2204, 16.2204, 16.2204, 16.2204, 16.2204, 16.2204, 16.2204, 16.2204, 16.2204, "trade", "delivery", 772.02, 162.204, 609.816],
["INE462A01022", "BAYERCROP", true, true, 19.0, "PEB6U5ERJBDTNFSLPOI2", 1482451200000, 4089.0, "ROJM9PXLTVRGADTWZXMX", 1684454400000, 4237.9474, 4199.55, 114.6162, 114.6162, 114.6162, 114.6162, 114.6162, 114.6162, 114.6162, 114.6162, 114.6162, 114.6162, "trade", "delivery", 2830.0006, 1146.162, 1683.8386],
["INE462A01022", "BAYERCROP", true, true, 12.0, "PEB6U5ERJBDTNFSLPOI2", 1482451200000, 4089.0, "1JQ2PDASHYXZCVH6IFTC", 1693440000000, 4278.08, 4199.55, 22.6063, 22.6063, 22.6063, 22.6063, 22.6063, 22.6063, 22.6063, 22.6063, 22.6063, 22.6063, "trade", "delivery", 2268.96, 226.063, 2042.897],
["INE462A01022", "BAYERCROP", true, true, 29.0, "ZR0GPABQCZJDEBAVL85E", 1682726400000, 4198.05, "1JQ2PDASHYXZCVH6IFTC", 1693440000000, 4278.08, 4199.55, 64.4914, 64.4914, 64.4914, 64.4914, 64.4914, 64.4914, 64.4914, 64.4914, 64.4914, 64.4914, "trade", "delivery", 2320.87, 644.914, 1675.956],
["INE462A01022", "BAYERCROP", true, true, 29.0, "G3NSSV7XHVFUJ8BTPBIR", 1689120000000, 4221.0, "1JQ2PDASHYXZCVH6IFTC", 1693440000000, 4278.08, 4199.55, 64.4915, 64.4915, 64.4915, 64.4915, 64.4915, 64.4915, 64.4915, 64.4915, 64.4915, 64.4915, "trade", "delivery", 1655.32, 644.915, 1010.405],
["INE01C001018", "ADANIPORTS", true, true, 256.0, "KQN4SO7YRL1T1YKS8XSO", 1631145600000, 270.0, "K0TMWRLU5HDBSNDITGWA", 1682640000000, 409.0, 137, 79.1448, 79.1448, 79.1448, 79.1448, 79.1448, 79.1448, 79.1448, 79.1448, 79.1448, 79.1448, "trade", "delivery", 35584.0, 791.448, 34792.552],
["INE01C001018", "ADANIPORTS", true, true, 44.0, "KQN4SO7YRL1T1YKS8XSO", 1631145600000, 270.0, "USTNCKBL23ZGYFBS1FWW", 1682899200000, 418.0, 137, 51.3655, 51.3655, 51.3655, 51.3655, 51.3655, 51.3655, 51.3655, 51.3655, 51.3655, 51.3655, "trade", "delivery", 6512.0, 513.655, 5998.345],
["INE00E101023", "BIKAJI", true, true, 110.0, "VTHPFZ7KXVG5LMNZNBHT", 1592611200000, 189.0, "YHEZMWYMV85DIO52CY1B", 1676332800000, 257.0, 0, 48.8571, 48.8571, 48.8571, 48.8571, 48.8571, 48.8571, 48.8571, 48.8571, 48.8571, 48.8571, "trade", "delivery", 7480.0, 488.571, 6991.429],
["INE00E101023", "BIKAJI", true, true, 640.0, "VTHPFZ7KXVG5LMNZNBHT", 1592611200000, 189.0, "IAVLRAW3OKLIHPD0DLKQ", 1677283200000, 265.0, 0, 64.5507, 64.5507, 64.5507, 64.5507, 64.5507, 64.5507, 64.5507, 64.5507, 64.5507, 64.5507, "trade", "delivery", 48640.0, 645.507, 47994.493],
["INE00E101023", "BIKAJI", true, true, 250.0, "VTHPFZ7KXVG5LMNZNBHT", 1592611200000, 189.0, "7UBKDTDSUWJEWXI71MB5", 1682640000000, 317.0, 0, 53.0026, 53.0026, 53.0026, 53.0026, 53.0026, 53.0026, 53.0026, 53.0026, 53.0026, 53.0026, "trade", "delivery", 32000.0, 530.026, 31469.974],
["INE00E101023", "BIKAJI", true, true, 260.0, "VTHPFZ7KXVG5LMNZNBHT", 1592611200000, 189.0, "SVYLOESSMFAWL2P1V4YN", 1684454400000, 334.0, 0, 53.2987, 53.2987, 53.2987, 53.2987, 53.2987, 53.2987, 53.2987, 53.2987, 53.2987, 53.2987, "trade", "delivery", 37700.0, 532.987, 37167.013],
["INE00E101023", "BIKAJI", true, true, 280.0, "VTHPFZ7KXVG5LMNZNBHT", 1592611200000, 189.0, "T2D14C472FNCQD8A9SEL", 1689897600000, 339.0, 0, 25.7813, 25.7813, 25.7813, 25.7813, 25.7813, 25.7813, 25.7813, 25.7813, 25.7813, 25.7813, "trade", "delivery", 42000.0, 257.813, 41742.187],
["INE00E101023", "BIKAJI", true, true, 435.0, "YKSLVQ6HJEUROPF8Z7TL", 1602547200000, 209.0, "T2D14C472FNCQD8A9SEL", 1689897600000, 339.0, 0, 72.7726, 72.7726, 72.7726, 72.7726, 72.7726, 72.7726, 72.7726, 72.7726, 72.7726, 72.7726, "trade", "delivery", 56550.0, 727.726, 55822.274],
["INE00E101023", "BIKAJI", true, true, 15.0, "XEPL8VAO3PWPBVZRBSCE", 1631923200000, 221.0, "T2D14C472FNCQD8A9SEL", 1689897600000, 339.0, 0, 4.357, 4.357, 4.357, 4.357, 4.357, 4.357, 4.357, 4.357, 4.357, 4.357, "trade", "delivery", 1770.0, 43.57, 1726.43],
["INE00E101023", "BIKAJI", true, true, 185.0, "XEPL8VAO3PWPBVZRBSCE", 1631923200000, 221.0, "IHQR3WDABXX5LWECAVD4", 1690675200000, 345.0, 0, 66.3519, 66.3519, 66.3519, 66.3519, 66.3519, 66.3519, 66.3519, 66.3519, 66.3519, 66.3519, "trade", "delivery", 22940.0, 663.519, 22276.481],
["INE00E101023", "BIKAJI", true, true, 85.0, "XEPL8VAO3PWPBVZRBSCE", 1632009600000, 225.0, "IHQR3WDABXX5LWECAVD4", 1690675200000, 345.0, 0, 56.706, 56.706, 56.706, 56.706, 56.706, 56.706, 56.706, 56.706, 56.706, 56.706, "trade", "delivery", 10200.0, 567.06, 9632.94],
["INE00E101023", "BIKAJI", true, true, 79.0, "KZ4XUMQL7O4OL1T0NWLW", 1686787200000, 327.0, "IHQR3WDABXX5LWECAVD4", 1690675200000, 345.0, 0, 36.0535, 36.0535, 36.0535, 36.0535, 36.0535, 36.0535, 36.0535, 36.0535, 36.0535, 36.0535, "trade", "delivery", 1422.0, 360.535, 1061.465],
["INE00E101023", "BIKAJI", true, true, 61.0, "KZ4XUMQL7O4OL1T0NWLW", 1686787200000, 327.0, "ZJZZOQLJZWYQRMSHK2E3", 1693440000000, 370.0, 0, 28.534, 28.534, 28.534, 28.534, 28.534, 28.534, 28.534, 28.534, 28.534, 28.534, "trade", "delivery", 2623.0, 285.34, 2337.66],
["INE364U01010", "ADANIGREEN", true, true, 40.0, "ZDUUQFIZKFI1LPZJIGC1", 1683763200000, 310.0, "OCFAGNA9WLZOS2GPVEWY", 1685059200000, 365.0, 127, 84.4085, 84.4085, 84.4085, 84.4085, 84.4085, 84.4085, 84.4085, 84.4085, 84.4085, 84.4085, "trade", "delivery", 2200.0, 844.085, 1355.915],
["INE010B01019", "CADILAHC", true, true, 254.0, "VQLDME6IOJZR95BDEKQ9", 1692316800000, 1290.98, "VXFUFI5Q9HH7FEJPLV3B", 1692403200000, 1301.78, 120, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, "trade", "intraday", 2743.2, 912.0, 1831.2],
["INE01C001018", "ADANIPORTS", true, true, 20.0, "RZ4TQQXBXGQZ4CIGW89W", 1689638400000, 410.0, "AMLDHHSPBR225CYDH1G3", 1689552000000, 436.0, 137, 76.0, 76.0, 76.0, 76.0, 76.0, 76.0, 76.0, 76.0, 76.0, 76.0, "trade", "intraday", 520.0, 760.0, -240.0],
["INE462A01022", "BAYERCROP", true, true, 25.0, "RP9WLFA5LS29NBTKARXN", 1686960000000, 4254.0, "UCB2JO0JMYBFRYRHILMZ", 1686960000000, 4239.0, 4199.55, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, "trade", "intraday", -375.0, 912.0, -1287.0],
["INE00E101023", "BIKAJI", true, true, 85.0, "90VSCSRGLVSHW6FYHQDE", 1678665600000, 269.0, "DLQMNK7WJJEH6SZOCZO6", 1678665600000, 273.0, 0, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, "trade", "intraday", 340.0, 912.0, -572.0],
["INE00E101023", "BIKAJI", true, true, 267.0, "KZ4XUMQL7O4OL1T0NWLW", 1686873600000, 329.0, "UZB55NEDOEZEB81QTBOI", 1686960000000, 321.0, 0, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, "trade", "intraday", -2136.0, 912.0, -3048.0],
["INE364U01010", "ADANIGREEN", true, true, 15.0, "OUYO53NES6HVEGSBXALX", 1680652800000, 281.0, "JOVR7LN5HKWR3H7LR3LK", 1680652800000, 250.0, 127, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, 91.2, "trade", "intraday", -465.0, 912.0, -1377.0]
]
}
]
},
{
"name": "mutual_fund_tradewise_settlement_sheet",
"@entity": "sheet",
"blocks": [
{
"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_settlement_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", "transfer_expenses", "nature_of_settlement", "realized_pnl", "net_realized_pnl"],
"rows": [
["INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 355.9, "GGFCHMYLKDQY9RRINTGH", 1491436800000, 124.2586, "JHF78MYGKDQY9RRINTGH", 1662940800000, 212.7, 20, 68.1534, "trade", 31476.2943, 31408.1409],
["INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 250.0, "GGFCHMYLKDQY9RRINTGH", 1491436800000, 124.2586, "JTR59NOGKDQY9YTINTGH", 1670630400000, 209.0, 20, 103.2055, "trade", 21185.35, 21082.1445],
["INF200K01190", "KOTAK SEC FUND", "equity", true, true, 40.0, "GHN78NOGKDQY9YTINFGHY", 1633564800000, 980.0, "VBN59NOGKDQY9YTINFGRN", 1634169600000, 1200.0, 800, 346.0, "trade", 8800.0, 8454.0],
["INF200K01190", "KOTAK SEC FUND", "equity", true, true, 10.0, "GHN78NOGKDQY9YTINFGHY", 1633564800000, 980.0, "67859NOGKDQY9YTINFGRN", 1634342400000, 1300.0, 800, 78.0, "trade", 3200.0, 3122.0],
["INF200K01190", "KOTAK SEC FUND", "equity", true, true, 40.0, "XCT59NOGKDQY9YTINFGRN", 1639872000000, 1000.0, "67859NOGKDQY9YTINFGRN", 1634342400000, 1300.0, 800, 394.0, "trade", 12000.0, 11606.0],
["INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 17.823, "BVNCH72LKDQY9RRINTGH", 1589414400000, 10.0, "KHF78MYGKDQY9RRINTGH", 1650672000000, 5.0, 0, 66.9329, "trade", -89.115, -156.0479],
["INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 19.574, "BNG57MYGKDQY9RRINTGH", 1515456000000, 120.0, "GHN78MYGKDQY9RRINTGH", 1682640000000, 160.0, 5, 95.7233, "trade", 782.96, 687.2367],
["INF200K01189", "SBI Gold Fund", "other", true, true, 35.0, "HJM98MYGKDQY9RRINGFB", 1374624000000, 200.0, "RTV678MYGKDQY9RRINTGH", 1649289600000, 210.0, 180, 624.6364, "trade", 350.0, -274.6364],
["INF200K01189", "SBI Gold Fund", "other", true, true, 20.0, "BLKMN98HJNMDQY9RRINTGH", 1563667200000, 60.0, "RTV678MYGKDQY9RRINTGH", 1649289600000, 210.0, 180, 48.0936, "trade", 3000.0, 2951.9064],
["INF760K01FR2", "Canara Robeco Bluechip Equity Growth Direct Plan", "equity", true, true, 155.0, "KNT59NOGKDQY897TINFTR", 1576022400000, 23.78, "HYT59NOGKDQY9YTINFGRN", 1633996800000, 56.9, 45, 4.0, "trade", 5133.6, 5129.6],
["INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 25.68, "GMFCH72LKDQY9RRINTGH", 1556409600000, 459.0, "GMFCH72LKDQY9RRINTGH", 1556409600000, 500.0, 220, 50.25, "trade", 1052.88, 1002.63],
["INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 125.0, "GHNR59NOHJDQ901TINTLK", 1481500800000, 150.0, "HNT59NOGKDQY897TINF4R", 1670889600000, 400.0, 160, 107.1985, "trade", 31250.0, 31142.8015],
["INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 36.023, "GJK45MYGKDQY9RRINTGH", 1493769600000, 30.0, "BHM88MYGKDQY9RRINTGH", 1626480000000, 60.0, 10, 168.0, "trade", 1080.69, 912.69],
["INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 19.88, "GHL909MYGKDQY9RRINTGH", 1437177600000, 15.0, "BHM88MTYH6QY9RRINTGH", 1626652800000, 60.0, 17, 48.0408, "trade", 894.6, 846.5592],
["INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 32.531, "MJK88MYGKDQY9RRINTGH", 1626912000000, 400.784, "CVH78MYGKDQY9RRINTGH", 1690070400000, 200.0, 200, 108.5685, "trade", -6531.7043, -6640.2728],
["INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 32.31, "TGFCH72LKDQY9RRINTGH", 1525824000000, 50.0, "KGFCH72LKDQY9RRINTGH", 1577664000000, 900.0, 1000, 99.658, "trade", 27463.5, 27363.842]
]
},
{ "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": "etf_tradewise_settlement_sheet",
"@entity": "sheet",
"blocks": [
{
"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_tradewise_settlement_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", "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", "product_type"],
"rows": [
["INF179KB1QR6", "ICICI LIQUID FUND - DIRECT PLAN", "equity", true, true, 75.0, "HNM88JKGKDQY9RRINGFB", 1666828800000, 125.0, "GJK48MYGKDQY9RRINGFB", 1666828800000, 45.0, 300, 58.0, 223.0, 275.0, 87.0, 82.0, 192.0, 279.0, 110.0, 211.0, 97.0, "trade", -6000.0, 1614.0, -6000.0, "intraday"],
["INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 20.0, "GHL909MYGKDQY9RRINTGH", 1668038400000, 15.0, "BHM88MTYH6QY9RRINTGH", 1668038400000, 60.0, 17, 80.0, 57.0, 95.0, 39.0, 16.0, 100.0, 34.0, 142.0, 145.0, 23.0, "trade", 900.0, 731.0, 900.0, "intraday"],
["INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 250.0, "TGFCH72LKDQY9RRINTGH", 1651363200000, 650.0, "KGFCH72LKDQY9RRINTGH", 1651363200000, 600.0, 400, 134.0, 83.0, 241.0, 199.0, 265.0, 158.0, 193.0, 206.0, 113.0, 100.0, "trade", -12500.0, 1692.0, -12500.0, "intraday"],
["INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 100.0, "GMFCH72LKDQY9RRINTGH", 1683590400000, 550.0, "FGN89H72LKDQY9RRINTKL", 1683590400000, 500.0, 220, 154.0, 215.0, 271.0, 48.0, 238.0, 142.0, 90.0, 62.0, 219.0, 105.0, "trade", -5000.0, 1544.0, -5000.0, "intraday"],
["INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 100.0, "BHM88MYGKDQY9RRINTGH", 1682380800000, 60.0, "GJK45MYGKDQY9RRINTGH", 1681948800000, 30.0, 10, 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, -3000.0, "delivery"],
["INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 78.0, "JNV5CHMYLKDQY9RRINTG", 1589414400000, 23.0, "GGFCHMYLKDQY9RRINTGH", 1650672000000, 88.0, 20, 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, 5070.0, "delivery"],
["INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 31.536, "BVNCH72LKDQY9RRINTGH", 1660089600000, 10.0, "KHF78MYGKDQY9RRINTGH", 1677628800000, 5.0, 340, 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, -157.68, "delivery"],
["INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 60.0, "BNG57MYGKDQY9RRINTGH", 1568160000000, 120.0, "GHN78MYGKDQY9RRINTGH", 1694044800000, 160.0, 250, 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, 2400.0, "delivery"],
["INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 100.0, "MJK88MYGKDQY9RRINTGH", 1627862400000, 400.784, "CVH78MYGKDQY9RRINTGH", 1685059200000, 200.0, 200, 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, -20078.4, "delivery"],
["INF200K01189", "SBI Gold Fund", "other", true, true, 50.0, "BLKMN98HJNMDQY9RRINTGH", 1641427200000, 120.5877, "BHMGP79GKDQY9RRINTGH", 1640822400000, 60.0, 65, 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, -3029.385, "delivery"],
["INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 30.0, "DFGR59NOHJDQ751TINTJK", 1493769600000, 236.2069, "GHNR59NOHJDQ901TINTLK", 1563321600000, 450.0, 160, 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, 6413.793, "delivery"],
["INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 80.0, "DFGR59NOHJDQ751TINTJK", 1493769600000, 236.2069, "HNT59NOGKDQY897TINF4R", 1599696000000, 500.0, 160, 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, 21103.448, "delivery"],
["INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 10.0, "DFGR59NOHJDQ751TINTJK", 1493769600000, 236.2069, "KNT59NOGKDQY897TINFTR", 1627603200000, 10.0, 160, 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, -2262.069, "delivery"],
["INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 10.0, "DFGR59NOHJDQ751TINTJK", 1493769600000, 236.2069, "HYT59NOGKDQY9YTINFGRN", 1658361600000, 50.0, 160, 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, -1862.069, "delivery"],
["INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 90.0, "PKF88MYGKDQY9RRINTGH", 1515456000000, 150.0, "PKF88MYGKDQY9RRINTGH", 1515369600000, 250.0, 100, 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, 9000.0, "delivery"]
]
},
{ "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": "future_tradewise_settlement_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_settlement_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"],
"rows": [
[null, "NIFTY 15 JAN 2023 FUT", "equity", 25.0, "Z0FCJBWODSL8GF3KKVPY", 1673481600000, 168.0, "VLNYY0FTJTUGELL1TK8D", 1672185600000, 146.0, 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],
[null, "NIFTY 15 JAN 2023 FUT", "equity", 75.0, "Z0FCJBWODSL8GF3KKVPY", 1673481600000, 168.0, "VLNYY0FTJTUGELL1TK8D", 1672531200000, 158.0, 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],
[null, "NIFTY 15 JAN 2023 FUT", "equity", 150.0, "Z0FCJBWODSL8GF3KKVPY", 1673481600000, 168.0, "VY3TYTSPMWLYJQAEMGTZ", 1674259200000, 255.0, 154.2, 75.8, 46.8, 348.4, 214.4, 196.6, 171.2, 109.6, 55.0, 45.2, "trade", 13050.0, 1417.2, 11632.8],
[null, "BANKNIFTY 20 MAR 2023 FUT", "equity", 125.0, "8LEGU2BN0HXVHXYBIIRZ", 1676505600000, 1500.0, "BYSC5G1EPZIWIJJ6BAUB", 1679097600000, 615.89, 163.0, 136.0, 43.0, 365.0, 210.0, 795.0, 289.0, 231.0, 294.0, 28.0, "trade", -110513.75, 2554.0, -113067.75],
[null, "FINNIFTY 15 FEB 2023 FUT", "equity", 155.0, "NKN2PS2TJZWDA9CDP1RA", 1674086400000, 194.9, "9ZLDZGRMJBSSAIJTBTHN", 1675814400000, 174.55, 169.0, 118.0, 141.0, 341.0, 338.0, 281.0, 40.0, 181.0, 75.0, 66.0, "trade", -3154.25, 1750.0, -4904.25],
[null, "NIFTY 23 FEB 2023 FUT", "equity", 55.0, "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],
[null, "NIFTY 23 FEB 2023 FUT", "equity", 120.0, "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],
[null, "NIFTY 23 JAN 2023 FUT", "equity", 25.0, "5NGIOMFGDRBG5Q8XTNBP", 1670457600000, 147.89, "CJLNLY40ORWJXUKGVC8E", 1671408000000, 135.67, 116.6667, 115.6667, 38.0, 94.3333, 133.3333, 372.0, 162.0, 51.0, 108.6667, 15.3333, "trade", -305.5, 1207.0, -1512.5],
[null, "NIFTY 23 JAN 2023 FUT", "equity", 45.0, "5NGIOMFGDRBG5Q8XTNBP", 1670457600000, 147.89, "GFHNW8Q8GH4F408UZQ0M", 1672358400000, 129.89, 217.8, 114.4, 60.4, 60.6, 357.0, 341.6, 209.2, 97.0, 210.8, 48.2, "trade", -810.0, 1717.0, -2527.0],
[null, "NIFTY 23 JAN 2023 FUT", "equity", 5.0, "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],
[null, "NIFTY 23 JAN 2023 FUT", "equity", 45.0, "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],
[null, "NIFTY 23 JAN 2023 FUT", "equity", 80.0, "ANH3LZISNL7R8DPFNHJ0", 1671840000000, 153.89, "WI62KWVR0MYO0WXLDQ4J", 1674172800000, 150.0, 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],
[null, "FUTCUR EURINR 13 MAY 2023", "currency", 50.0, "V7L7EV2WB1F06YIJSHQS", 1680134400000, 260.7, "UVSIUTXLTZHDRHICW9C0", 1680134400000, 245.78, 224.0, 390.0, 338.0, 444.0, 277.0, 191.0, 141.0, 329.0, 324.0, 243.0, "trade", -746.0, 2901.0, -3647.0],
[null, "FUTCUR EURINR 13 MAY 2023", "currency", 145.0, "XNAQJZ3OTJFDZ2FEGVVQ", 1680739200000, 289.0, "8GTJ7JADP09KTKDPFWQJ", 1680307200000, 278.0, 45.0, 249.0, 311.0, 181.0, 243.0, 184.0, 81.0, 340.0, 347.0, 191.0, "trade", -1595.0, 2172.0, -3767.0],
[null, "NIFTY 17 APR 2023 FUT", "equity", 135.0, "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],
[null, "FINNIFTY 20 MAY 2023 FUT", "equity", 120.0, "GUEQKVCN1OGWGMPXO1WQ", 1682726400000, 698.03, "B67GMDMHCZAHJBXKDGL0", 1684368000000, 745.32, 228.4615, 114.5385, 117.1538, 269.6154, 244.6923, 755.2308, 157.5385, 179.0, 103.3077, 67.6154, "trade", 5674.8, 2237.1539, 3437.6461],
[null, "FINNIFTY 25 JAN 2023 FUT", "equity", 35.0, "S4LOWQJP4P6SFB42C460", 1672617600000, 3450.67, "IJPDDNJO9BNNH0TB9NPJ", 1674518400000, 2568.98, 155.0, 183.0, 79.0, 296.0, 369.0, 171.0, 270.0, 191.0, 55.0, 32.0, "trade", -30859.15, 1801.0, -32660.15],
[null, "NIFTY 25 JAN 2023 FUT", "equity", 100.0, "CIKTMLOWJQLROEGJXMFF", 1672444800000, 175.55, "YQT2WZWDNZPPCRDSQFR9", 1674432000000, 126.78, 83.0, 99.0, 135.0, 431.0, 165.0, 257.0, 307.0, 114.0, 154.0, 70.0, "trade", -4877.0, 1815.0, -6692.0],
[null, "BANKNIFTY 15 Jun 2023 FUT", "equity", 25.0, "AUGUWEK01EI4YOIMH7RK", 1683158400000, 363.15, "2C7BGL8DLAEX6DMFGRTF", 1684886400000, 425.3, 25.5, 135.0, 89.5, 299.5, 371.5, 323.0, 170.0, 154.0, 72.5, 22.5, "trade", 1553.75, 1663.0, -109.25],
[null, "BANKNIFTY 15 Jun 2023 FUT", "equity", 25.0, "AUGUWEK01EI4YOIMH7RK", 1683158400000, 363.15, "Y9V66LWUBLF8P2I8FDAR", 1685577600000, 469.22, 81.5, 119.0, 107.5, 152.5, 245.5, 456.0, 136.0, 223.0, 166.5, 15.5, "trade", 2651.75, 1703.0, 948.75],
[null, "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 25.0, "55MCNYCUWJO7C3ZAXWIX", 1662940800000, 415.0, "52VUZC1SJ5MW4IKAJPIA", 1663632000000, 423.0, 132.75, 109.0, 106.5, 72.75, 101.5, 110.75, 23.0, 70.0, 99.75, 90.25, "trade", 200.0, 916.25, -716.25],
[null, "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 75.0, "55MCNYCUWJO7C3ZAXWIX", 1662940800000, 415.0, "XPDDDCPTROUOHFWCQH7O", 1665619200000, 449.0, 82.65, 49.8, 132.3, 133.65, 135.3, 74.85, 27.6, 81.0, 160.05, 26.55, "trade", 2550.0, 903.75, 1646.25],
[null, "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 50.0, "2FPD4QFGHO2ICG3SK0KG", 1664496000000, 456.0, "XPDDDCPTROUOHFWCQH7O", 1665619200000, 449.0, 81.6, 118.2, 64.2, 99.6, 106.2, 99.4, 116.4, 150.0, 102.2, 40.2, "trade", -350.0, 978.0, -1328.0],
[null, "FUTCUR USDINR 27 JAN 2023 ", "currency", 165.0, "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],
[null, "FUTCUR USDINR 27 JAN 2023 ", "currency", 100.0, "JDNI9UJFKN2PGFJZ5U9O", 1670630400000, 89.0121, "D1VHUJNJ1WGO9JVCK2AZ", 1672358400000, 45.98, 220.5714, 356.5, 307.2857, 66.8571, 195.1429, 266.0, 325.5, 79.2143, 270.7143, 271.0, "trade", -4303.21, 2358.7857, -6661.9957],
[null, "FUTCUR USDINR 27 JAN 2023 ", "currency", 15.0, "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],
[null, "FUTCUR JPYINR 24 AUG 2023", "currency", 110.0, "EUCWBOWYUQF5LLS2MG9P", 1691452800000, 324.0636, "BZAB3NIFLVXCEWLNXF0C", 1690848000000, 345.89, 139.4167, 478.0833, 191.3333, 340.5, 286.0, 402.6667, 451.75, 231.4167, 271.4167, 429.6667, "trade", 2400.904, 3222.2501, -821.3461],
[null, "FUTCUR GBPINR 27 OCT 2023", "currency", 75.0, "NU9Y7DKWYXX1B8HUGX0G", 1694649600000, 4500.0, "NU9Y7DKWYXX1B8HUGX0G", 1694649600000, 4509.0, 36.0, 272.0, 216.0, 140.0, 125.0, 195.0, 179.0, 416.0, 306.0, 109.0, "trade", 675.0, 1994.0, -1319.0],
[null, "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 70.0, "KMY2EC1UMISH0BUMIEGT", 1665446400000, 139.3077, "JAWOZXSLWYKHKUWGWS6L", 1666137600000, 148.0, 305.8462, 115.6923, 88.0, 140.6154, 114.6923, 140.6154, 185.9231, 186.3846, 139.1538, 165.5385, "trade", 608.461, 1582.4616, -974.0006],
[null, "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 30.0, "KMY2EC1UMISH0BUMIEGT", 1665446400000, 139.3077, "JAWOZXSLWYKHKUWGWS6L", 1666224000000, 150.0, 285.0769, 137.1538, 83.0, 91.6923, 124.1538, 43.6923, 116.5384, 54.3077, 87.9231, 74.2307, "trade", 320.769, 1097.769, -777.0],
[null, "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 30.0, "KMY2EC1UMISH0BUMIEGT", 1665446400000, 139.3077, "XOUZUWMHBDCRPKRGDD1Q", 1668470400000, 154.0, 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],
[null, "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 50.0, "1AW8BG2NTK1BPSLMR0TV", 1666828800000, 137.0, "XOUZUWMHBDCRPKRGDD1Q", 1668470400000, 154.0, 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],
[null, "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 90.0, "1AW8BG2NTK1BPSLMR0TV", 1666828800000, 137.0, "LAGBHUZEYUH1K2OMGP49", 1668902400000, 156.0, 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],
[null, "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 20.0, "XOUZUWMHBDCRPKRGDD1Q", 1668470400000, 153.0, "LAGBHUZEYUH1K2OMGP49", 1668902400000, 156.0, 227.9231, 37.3077, 50.1538, 14.7692, 25.2307, 114.8461, 113.6923, 46.2307, 74.0769, 56.0, "trade", 60.0, 760.2305, -700.2305],
[null, "BANKNIFTY 01 Jun 2023 FUT", "equity", 45.0, "GGFCHMYLKDQYZRRINTEE", 1680739200000, 363.1, "DROFW5LAACDWOCFKDQET", 1685318400000, 450.09, 162.0, 153.0, 89.0, 139.0, 323.0, 655.0, 157.0, 166.0, 223.0, 75.0, "trade", 3914.55, 2142.0, 1772.55]
]
}
]
},
{
"name": "option_tradewise_settlement_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_settlement_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"],
"rows": [
[null, "NIFTY 23 JAN 2023 CE 15000", "equity", 25.0, "ULDR4PE639LOMU4A4VCE", 1670457600000, 1570.0, "0B3PIU4WMIPKUQEG34BO", 1671408000000, 1460.0, 1206.3333, 2859.6667, 2816.6667, 1138.0, 442.6667, 2843.3333, 1416.6667, 3065.3333, 1862.6667, 728.6667, "trade", -2750.0, 18380.0001, -21130.0001],
[null, "NIFTY 23 JAN 2023 CE 15000", "equity", 45.0, "ULDR4PE639LOMU4A4VCE", 1670457600000, 1570.0, "S7XOLPIQ2V4R5L89ZEE1", 1672358400000, 1508.0, 3057.2, 1900.8, 3179.0, 1633.8, 1002.0, 1606.6, 2519.0, 2059.6, 176.2, 3529.6, "trade", -2790.0, 20663.8, -23453.8],
[null, "NIFTY 23 JAN 2023 CE 15000", "equity", 5.0, "ULDR4PE639LOMU4A4VCE", 1670457600000, 1570.0, "HSZA8B3XH3JC2POXMSXJ", 1673568000000, 1585.0, 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],
[null, "NIFTY 23 JAN 2023 CE 15000", "equity", 45.0, "VIHCPUEYSZUMQUVPSJ1P", 1671840000000, 1490.0, "HSZA8B3XH3JC2POXMSXJ", 1673568000000, 1585.0, 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],
[null, "NIFTY 23 JAN 2023 CE 15000", "equity", 80.0, "VIHCPUEYSZUMQUVPSJ1P", 1671840000000, 1490.0, "ILKEYGKTOHFQI5UXMBOO", 1674172800000, 1635.0, 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],
[null, "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 70.0, "Q5CUBQ2P6B7VKNHCKWD6", 1665446400000, 139.3077, "DTXGC9I0ZVOI2FFSHIOL", 1666137600000, 148.0, 305.8462, 115.6923, 88.0, 140.6154, 114.6923, 140.6154, 185.9231, 186.3846, 139.1538, 165.5385, "trade", 608.461, 1582.4616, -974.0006],
[null, "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 30.0, "Q5CUBQ2P6B7VKNHCKWD6", 1665446400000, 139.3077, "DTXGC9I0ZVOI2FFSHIOL", 1666224000000, 150.0, 285.0769, 137.1538, 83.0, 91.6923, 124.1538, 43.6923, 116.5384, 54.3077, 87.9231, 74.2307, "trade", 320.769, 1097.769, -777.0],
[null, "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 30.0, "Q5CUBQ2P6B7VKNHCKWD6", 1665446400000, 139.3077, "TAODZZPWWR9R5CO1QX0R", 1668470400000, 154.0, 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],
[null, "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 50.0, "IU0HYP6ZN9EOERPBEWYA", 1666828800000, 137.0, "TAODZZPWWR9R5CO1QX0R", 1668470400000, 154.0, 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],
[null, "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 90.0, "IU0HYP6ZN9EOERPBEWYA", 1666828800000, 137.0, "HVG5B4A45J9CL4CZ35TF", 1668902400000, 156.0, 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],
[null, "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 20.0, "TAODZZPWWR9R5CO1QX0R", 1668470400000, 153.0, "HVG5B4A45J9CL4CZ35TF", 1668902400000, 156.0, 227.9231, 37.3077, 50.1538, 14.7692, 25.2307, 114.8461, 113.6923, 46.2307, 74.0769, 56.0, "trade", 60.0, 760.2305, -700.2305],
[null, "FINNIFTY 25 JAN 2023 CE 12500", "equity", 50.0, "QOO5OYJLQBIRUMIGKCIQ", 1672617600000, 3450.67, "A9HFP9X49AROF21K9KRY", 1674518400000, 2568.98, 1150.0, 1886.0, 1142.0, 4223.0, 3569.0, 922.0, 2014.0, 2594.0, 2594.0, 4292.0, "trade", -44084.5, 24386.0, -68470.5],
[null, "NIFTY 23 JAN 2023 CE 15650", "equity", 100.0, "PZUTEFRTRX9LFW9DPHAW", 1672444800000, 175.55, "BEZ31FONIR1EQQI68F0Y", 1674432000000, 126.78, 413.0, 889.0, 4927.0, 3468.0, 4048.0, 2500.0, 3454.0, 2211.0, 2302.0, 4240.0, "trade", -4877.0, 28452.0, -33329.0],
[null, "BANKNIFTY 01 Jun 2023 CE 44100", "equity", 25.0, "RJFWB5JYYDORFUEPK5DQ", 1680739200000, 363.1, "KLPAV9GOUCMPFH1WNKLV", 1685318400000, 450.09, 2042.0, 1503.0, 2560.0, 2913.0, 3807.0, 806.0, 2343.0, 2686.0, 3601.0, 3712.0, "trade", 2174.75, 25973.0, -23798.25],
[null, "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 50.0, "Y6W9FLHOVJ8TCHHNBYGF", 1683158400000, 363.15, "QS2KFCND5DJXRNDLLVHD", 1684886400000, 425.3, 1972.6667, 577.6667, 1186.6667, 3114.3333, 2433.0, 734.6667, 2508.3333, 1818.6667, 1295.3333, 867.3333, "trade", 3107.5, 16508.6667, -13401.1667],
[null, "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 25.0, "Y6W9FLHOVJ8TCHHNBYGF", 1683158400000, 363.15, "0WNSDPGK4LTXO38HPTLU", 1685577600000, 469.22, 2537.3333, 2049.3333, 2600.3333, 1460.6667, 2750.0, 177.3333, 2850.6667, 886.3333, 2607.6667, 1104.6667, "trade", 2651.75, 19024.3333, -16372.5833],
[null, "NIFTY 17 APR 2023 PE 17800", "equity", 55.0, "DUYJ4ZV7OKJA8CV8U1MT", 1679616000000, 457.89, "71ZRU28BNR9F5FMOZS8V", 1681084800000, 489.67, 3285.0, 2479.0, 3549.0, 2207.0, 887.0, 4521.0, 2418.0, 2583.0, 3198.0, 3116.0, "trade", 1747.9, 28243.0, -26495.1],
[null, "FINNIFTY 25 MAY 2023 CE 14900", "equity", 120.0, "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],
[null, "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 25.0, "DML3WXXE53PJOTGTEYKJ", 1662940800000, 415.0, "TTGYOR1EOA3SUTMNCJ58", 1663632000000, 423.0, 132.75, 109.0, 106.5, 72.75, 101.5, 110.75, 23.0, 70.0, 99.75, 90.25, "trade", 200.0, 916.25, -716.25],
[null, "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 75.0, "DML3WXXE53PJOTGTEYKJ", 1662940800000, 415.0, "VIX3TEN3GZKPVY2WZCEX", 1665619200000, 449.0, 82.65, 49.8, 132.3, 133.65, 135.3, 74.85, 27.6, 81.0, 160.05, 26.55, "trade", 2550.0, 903.75, 1646.25],
[null, "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 50.0, "MYOFOBCC5W0PCWHVBFPU", 1664496000000, 456.0, "VIX3TEN3GZKPVY2WZCEX", 1665619200000, 449.0, 81.6, 118.2, 64.2, 99.6, 106.2, 99.4, 116.4, 150.0, 102.2, 40.2, "trade", -350.0, 978.0, -1328.0],
[null, "NIFTY 23 JAN 2023 CE 15600", "equity", 25.0, "2BOMU4R5WMEONKEI5YT6", 1673481600000, 168.0, "GHQTIWHDAFE90NOAU6ZY", 1672185600000, 146.0, 1653.0, 743.7, 878.1, 492.9, 340.6, 2030.7, 2367.5, 661.1, 1265.6, 489.0, "trade", -550.0, 10922.2, -11472.2],
[null, "NIFTY 23 JAN 2023 CE 15600", "equity", 75.0, "2BOMU4R5WMEONKEI5YT6", 1673481600000, 168.0, "GHQTIWHDAFE90NOAU6ZY", 1672531200000, 158.0, 2145.0, 2546.1, 1469.3, 2522.7, 1244.8, 2115.1, 1094.5, 1568.3, 2410.8, 2277.0, "trade", -750.0, 19393.6, -20143.6],
[null, "NIFTY 23 JAN 2023 CE 15600", "equity", 150.0, "2BOMU4R5WMEONKEI5YT6", 1673481600000, 168.0, "IXMBK9LENH6CSGULION2", 1674259200000, 255.0, 3137.0, 1269.2, 2976.6, 3171.4, 1955.6, 1842.2, 1009.0, 1475.6, 3607.6, 2368.0, "trade", 13050.0, 22812.2, -9762.2],
[null, "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 165.0, "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],
[null, "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 100.0, "GYHVDLIIXVTLROOCLVYG", 1670630400000, 89.0121, "ZXORPEEJE7TVFBPXQ8LI", 1672358400000, 45.98, 220.5714, 356.5, 307.2857, 66.8571, 195.1429, 266.0, 325.5, 79.2143, 270.7143, 271.0, "trade", -4303.21, 2358.7857, -6661.9957],
[null, "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 15.0, "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],
[null, "NIFTY 23 FEB 2023 PE 17100", "equity", 55.0, "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],
[null, "NIFTY 23 FEB 2023 PE 17100", "equity", 50.0, "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],
[null, "OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 80.0, "OFAILEZLEAPD9SU5ZOMT", 1691452800000, 325.67, "T6B8078DHAC9MGWPKR6B", 1690848000000, 345.89, 48.6667, 222.3333, 91.3333, 191.0, 177.0, 220.6667, 203.0, 126.6667, 212.6667, 268.6667, "trade", 1617.6, 1762.0001, -144.4001],
[null, "OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 30.0, "OFAILEZLHKPD8SU7ZOMT", 1691452800000, 319.78, "T6B8078DHAC9MGWPKR6B", 1690848000000, 345.89, 90.75, 255.75, 100.0, 149.5, 109.0, 182.0, 248.75, 104.75, 58.75, 161.0, "trade", 783.3, 1460.25, -676.95],
[null, "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 50.0, "CPYBETZOWLDVTAYF3PRA", 1680134400000, 260.7, "6MDVYEYUKHJXIQSGEOPU", 1680134400000, 245.78, 224.0, 390.0, 338.0, 444.0, 277.0, 191.0, 141.0, 329.0, 324.0, 243.0, "trade", -746.0, 2901.0, -3647.0],
[null, "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 145.0, "UQCTRKWJRKXVR7LSIBCN", 1680739200000, 289.0, "MEHVXLLGPB5SODCHL5PT", 1680307200000, 278.0, 45.0, 249.0, 311.0, 181.0, 243.0, 184.0, 81.0, 340.0, 347.0, 191.0, "trade", -1595.0, 2172.0, -3767.0],
[null, "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 75.0, "PIN8G2M1QKXY1FQZPRIF", 1694649600000, 4500.0, "PIN8G2M1QKXY1FQZPRIF", 1694649600000, 4509.0, 36.0, 272.0, 216.0, 140.0, 125.0, 195.0, 179.0, 416.0, 306.0, 109.0, "trade", 675.0, 1994.0, -1319.0],
[null, "FINNIFTY 15 FEB 2023 CE 13400", "equity", 50.0, "DIQDEZH7K04QBDCJY0NV", 1674086400000, 194.9, "HMC8SXGWGNGWUTFBYRHX", 1675814400000, 174.55, 2524.0, 4142.0, 3167.0, 4280.0, 1285.0, 2547.0, 898.0, 2368.0, 1478.0, 3531.0, "trade", -1017.5, 26220.0, -27237.5],
[null, "BANKNIFTY 20 MAR 2023 PE 18900", "equity", 155.0, "TFCXQ3TKQRMOHU86MXO1", 1676505600000, 1500.0, "LMQI22RLLZHQ5CWBGFYP", 1679097600000, 615.89, 1946.0, 1071.0, 3214.0, 3408.0, 2371.0, 3297.0, 4858.0, 3054.0, 3132.0, 4441.0, "trade", -137037.05, 30792.0, -167829.05]
]
}
]
},
{
"name": "bond_tradewise_settlement_sheet",
"@entity": "sheet",
"blocks": [
{
"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_settlement_table",
"@entity": "table",
"header": ["isin", "security_name", "is_listed", "quantity", "buy_trade_id", "buy_date", "buy_price", "sell_trade_id", "sell_date", "sell_price", "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"],
"rows": [
["INE272F07011", "Blue Dart Express", true, 20.0, "BVNCH72LKDQY9RRINTGH", 1662940800000, 20.0, "KHF78MYGKDQY9RRINTGH", 1670630400000, 200.0, 122.0, 48.8, 124.0, 60.6, 16.2, 121.4, 46.0, 70.8, 88.0, "trade", 3600.0, 697.8, 3600.0],
["INE112J07020", "IFCI", true, 170.0, "BNG57MYGKDQY9RRINTGH", 1670457600000, 16.55, "GHN78MYGKDQY9RRINTGH", 1671840000000, 500.0, 137.3, 131.1, 121.95, 43.6, 62.0, 164.25, 175.95, 118.3, 95.4, "trade", 82186.5, 1049.85, 82186.5],
["INE130K08019", "APPL", false, 180.0, "MJK88MYGKDQY9RRINTGH", 1633564800000, 350.0, "CVH78MYGKDQY9RRINTGH", 1639872000000, 310.0, 214.6, 119.8, 135.0, 134.6, 94.9, 66.5, 80.3, 163.6, 208.2, "trade", -7200.0, 1217.5, -7200.0],
["INE261F07032", "07.64% NABARD TFB 2031", true, 500.0, "TGFCH72LKDQY9RRINTGH", 1680739200000, 10.0, "GMFCH72LKDQY9RRINTGH", 1634169600000, 125.0, 46.0, 76.0, 99.0, 67.0, 171.0, 126.0, 139.0, 77.0, 133.0, "trade", 57500.0, 934.0, 57500.0],
["INE261F07032", "07.64% NABARD TFB 2031", true, 500.0, "KGFCH72LKDQY9RRINTGH", 1683158400000, 10.0, "GMFCH72LKDQY9RRINTGH", 1634342400000, 125.0, 197.0, 213.0, 125.0, 126.0, 160.0, 134.0, 130.0, 186.0, 131.0, "trade", 57500.0, 1402.0, 57500.0],
["INE130K08001", "QCK", false, 200.0, "GHL909MYGKDQY9RRINTGH", 1633996800000, 16.55, "BHM88MTYH6QY9RRINTGH", 1374624000000, 500.0, 91.0, 255.0, 38.0, 172.0, 198.0, 136.0, 125.0, 233.0, 158.0, "trade", 96690.0, 1406.0, 96690.0],
["INE130K08015", "GGL", true, 200.0, "BHMGP79GKDQY9RRINTGH", 1585008000000, 550.0, "BLKMN98HJNMDQY9RRINTGH", 1649289600000, 600.0, 124.0, 106.0, 103.0, 118.0, 173.0, 79.0, 70.0, 112.0, 121.0, "trade", 10000.0, 1006.0, 10000.0],
["INE130K08000", "SBOX", false, 170.0, "GJK45MYGKDQY9RRINTGH", 1672617600000, 16.55, "BHM88MYGKDQY9RRINTGH", 1576022400000, 500.0, 129.0, 112.6, 100.65, 84.85, 77.0, 198.9, 116.55, 201.15, 102.4, "trade", 82186.5, 1123.1, 82186.5],
["INE261F07055", "SGB", true, 500.0, "GGFCHMYLKDQY9RRINTGH", 1437177600000, 488.0, "JTR59NOGKDQY9YTINTGH", 1563667200000, 350.0, 192.2727, 157.1818, 142.4545, 148.5455, 121.5455, 49.1818, 139.8182, 90.7273, 218.2727, "trade", -69000.0, 1260.0, -69000.0],
["INE261F07055", "SGB", true, 50.0, "GGFCHMYLKDQY9RRINTGH", 1626652800000, 322.0, "JTR59NOGKDQY9YTINTGH", 1563667200000, 350.0, 11.9273, 13.9182, 12.3455, 12.0545, 14.5545, 9.5182, 15.4818, 13.9727, 12.1273, "trade", 1400.0, 115.9, 1400.0],
["INE261F07055", "SGB", true, 50.0, "GGFCHMYLKDQY9RRINTGH", 1626652800000, 322.0, "DFGR59NOHJDQ751TINTJK", 1570579200000, 400.0, 82.2, 15.1, 133.8, 65.6, 15.1, 54.7, 113.3, 47.7, 106.4, "trade", 3900.0, 633.9, 3900.0]
]
},
{ "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": "debenture_tradewise_settlement_sheet",
"@entity": "sheet",
"blocks": [
{
"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_settlement_table",
"@entity": "table",
"header": ["isin", "security_name", "is_listed", "quantity", "buy_trade_id", "buy_date", "buy_price", "sell_trade_id", "sell_date", "sell_price", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fee", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses", "nature_of_settlement", "realized_pnl", "total_transafer_expenses", "net_realized_pnl"],
"rows": [
["INE272F07011", "Blue Dart Express", true, 20.0, "DML3WXXE53PJOTGTEYKJ", 1589414400000, 20.0, "GYHVDLIIXVTLROOCLVYG", 1650672000000, 200.0, 175.4, 207.2, 112.6, 140.8, 139.4, 104.0, 150.8, 316.0, 48.4, "trade", 3600.0, 1394.6, 3600.0],
["INE112J07020", "IFCI", true, 170.0, "ULDR4PE639LOMU4A4VCE", 1515456000000, 16.55, "VIHCPUEYSZUMQUVPSJ1P", 1682640000000, 500.0, 191.9, 231.6, 317.2, 337.45, 305.5, 219.05, 249.5, 253.5, 148.25, "trade", 82186.5, 2253.95, 82186.5],
["INE130K08019", "APPL", false, 180.0, "DUYJ4ZV7OKJA8CV8U1MT", 1626912000000, 350.0, "2GFSS7XTAHUWHFZH0NBR", 1690070400000, 310.0, 205.5, 409.2, 100.2, 221.2, 170.1, 245.6, 231.5, 58.0, 305.6, "trade", -7200.0, 1946.9, -7200.0],
["INE261F07032", "07.64% NABARD TFB 2031", true, 1000.0, "RJFWB5JYYDORFUEPK5DQ", 1525824000000, 10.0, "Y6W9FLHOVJ8TCHHNBYGF", 1577664000000, 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, 0.0],
["INE130K08001", "QCK", false, 200.0, "PZUTEFRTRX9LFW9DPHAW", 1437177600000, 16.55, "DIQDEZH7K04QBDCJY0NV", 1626652800000, 500.0, 211.0, 354.0, 419.0, 175.0, 173.0, 346.0, 281.0, 132.0, 417.0, "trade", 96690.0, 2508.0, 96690.0],
["INE130K08015", "GGL", true, 200.0, "PGR2RDEZFVC2S3YBX1JF", 1626739200000, 550.0, "TFCXQ3TKQRMOHU86MXO1", 1563667200000, 600.0, 260.0, 142.0, 368.0, 282.0, 420.0, 265.0, 397.0, 109.0, 233.0, "trade", 10000.0, 2476.0, 10000.0],
["INE130K08000", "SBOX", false, 170.0, "QOO5OYJLQBIRUMIGKCIQ", 1493769600000, 16.55, "2BOMU4R5WMEONKEI5YT6", 1626480000000, 500.0, 188.8, 192.8, 153.7, 23.45, 261.5, 187.9, 94.1, 227.95, 192.15, "trade", 82186.5, 1522.35, 82186.5],
["INE261F07055", "SGB", true, 100.0, "Q2DZQ1ITYAOXILWQLHDN", 1491436800000, 890.0, "FQQ96BPTGAPAQPLMABNU", 1576022400000, 789.0, 198.4545, 119.4545, 198.5455, 111.6364, 203.0, 199.1818, 80.7273, 161.2727, 78.1818, "trade", -10100.0, 1350.4545, -10100.0],
["INE261F07055", "SGB", true, 450.0, "4AGDXGEEJOUHI6G8ATOU", 1556409600000, 600.0, "FQQ96BPTGAPAQPLMABNU", 1576022400000, 789.0, 240.5455, 221.6455, 132.0545, 259.3636, 241.2, 118.7182, 345.2727, 210.0273, 313.1182, "trade", 85050.0, 2081.9455, 85050.0],
["INE261F07055", "SGB", true, 50.0, "4AGDXGEEJOUHI6G8ATOU", 1556409600000, 600.0, "RKW88OVAQVWZMCD9VLJL", 1633996800000, 890.0, 161.0, 219.9, 116.4, 114.0, 212.8, 115.1, 84.0, 240.7, 25.7, "trade", 14500.0, 1289.6, 14500.0]
]
},
{ "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": [] }
]
}
]
}
Scripwise PnL
Click here to learn more about this JSON Payload
{
"@entity": "workbook",
"name": "scripwise_settlement_workbook",
"sheets": [
{
"@entity": "sheet",
"name": "stock_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "stock_scripwise_settlement_table",
"header": ["isin", "symbol", "is_listed", "is_stt_paid", "quantity", "buy_average", "sell_average", "holding_period", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses"],
"rows": [["null", "INFY", true, true, 55, 203.5, 300, "long_term", 3, 2, 0, 0, 0, 0, 0, 0, 0, 0]]
}
]
},
{
"@entity": "sheet",
"name": "mutual_fund_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "mutual_fund_scripwise_settlement_table",
"header": ["isin", "scheme_name", "asset_class", "quantity", "buy_average", "sell_average", "holding_period", "transfer_expenses"],
"rows": [["ISIN_GROWW", "GROWW TAX SAVING FUND", "debt", 50, 200, 300, "long_term", 3]]
}
]
},
{
"@entity": "sheet",
"name": "future_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "future_scripwise_settlement_table",
"header": ["isin", "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"],
"rows": [[null, "NIFTY", "equity", 12, 4000, 5000, 12, 23, 0, 0, 0, 0, 0, 0, 0, 0]]
}
]
},
{
"@entity": "sheet",
"name": "option_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "option_scripwise_settlement_table",
"header": ["isin", "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"],
"rows": [[null, "NIFTY", "equity", 12, 4000, 5000, 12, 23, 0, 0, 0, 0, 0, 0, 0, 0]]
}
]
},
{
"@entity": "sheet",
"name": "etf_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "etf_scripwise_settlement_table",
"header": ["isin", "scheme_name", "asset_class", "quantity", "buy_average", "sell_average", "holding_period", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses"],
"rows": [
[null, "GOLDBEES", "debt", 50, 200, 300, "long_term", 5, 0, 0, 0, 0, 0, 0, 0, 0, 0],
[null, "GOLDBEES", "equity", 50, 200, 300, "intraday", 5, 0, 0, 0, 0, 0, 0, 0, 0, 0]
]
}
]
},
{
"@entity": "sheet",
"name": "bond_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "bond_scripwise_settlement_table",
"header": ["isin", "security_name", "is_listed", "quantity", "buy_average", "sell_average", "holding_period", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stt", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses"],
"rows": [["ISIN_BOND_SVG", "BOND_SVG", true, 10, 100, 200, "short_term", 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]]
}
]
},
{
"@entity": "sheet",
"name": "debenture_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "debenture_scripwise_settlement_table",
"header": ["isin", "security_name", "is_listed", "quantity", "buy_average", "sell_average", "holding_period", "brokerage", "clearing_charges", "exchange_transaction_charges", "sebi_turnover_fees", "stamp_duty", "sgst", "cgst", "igst", "other_transfer_expenses"],
"rows": [["ISIN_DEBENTURES_HINDALCO", "DEBENTURE_HINDALCO", false, 30, 200, 100, "short_term", 20, 0, 0, 0, 0, 0, 0, 0, 0]]
}
]
}
]
}