Sync - Tax P&L

POST {{sandbox_host}}/it/calculator/securities/domestic/tax-pnl/sync?input=tradebook&from=0&output=tradewise_pnl&to=1695024009000

Request Params

| Key | Datatype | Required | Description | | input | string | | (Required) | | from | number | | | | output | string | | (Required) | | to | number | | |

Request Body

{"@entity"=>"workbook", "name"=>"tradebook_workbook", "sheets"=>[{"name"=>"stock_tradebook_sheet", "@entity"=>"sheet", "blocks"=>[{"name"=>"stock_tradebook_table", "@entity"=>"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"=>[["KZUG2ZMGMH4WFE2C9RMG", nil, "GLS", true, true, 50, 1499644800000, 5000, "buy", 5500, 21.5, 22.6, 23.5, 58, 67, 21.5, 21.5, 21.5, 21.5, 21.5, nil, "delivery "], ["ZVQAT2PZ1RSLYWWYZTXP", "INE767A01016", "ADANIENT", true, true, 57, 1658016000000, 1950, "buy", 1260, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["VTHPFZ7KXVG5LMNZNBHT", "INE00E101023", "BIKAJI", true, true, 1540, 1592611200000, 189, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["SUNMAQYIBRDSM4Y2TVW9", "INE462A01022", "BAYERCROP", true, true, 25, 1436313600000, 4203.45, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["CJ1CLC4YCBFEZ4CVDNMH", "INE002A01018", "AJANTAPHARMA", true, true, 1590, 1463356800000, 136, "buy", 438, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["PEB6U5ERJBDTNFSLPOI2", "INE462A01022", "BAYERCROP", true, true, 37, 1482451200000, 4089, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["8BARHLFV3FZVGYTSJ012", "INE03Q201024", "GLS", true, true, 50, 1689811200000, 5000, "sell", 5500, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["CYX9TQSTWUYK8C9Z7BCE", "INE002A01018", "AJANTAPHARMA", true, true, 645, 1650412800000, 580, "sell", 438, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["VQLDME6IOJZR95BDEKQ9", "INE010B01019", "CADILAHC", true, false, 254, 1692316800000, 1290.98, "buy", 120, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["YKSLVQ6HJEUROPF8Z7TL", "INE00E101023", "BIKAJI", true, true, 435, 1602547200000, 209, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["VXFUFI5Q9HH7FEJPLV3B", "INE010B01019", "CADILAHC", true, true, 254, 1692403200000, 1301.78, "sell", 120, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["JOVR7LN5HKWR3H7LR3LK", "INE364U01010", "ADANIGREEN", true, true, 15, 1680652800000, 250, "sell", 127, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["KQN4SO7YRL1T1YKS8XSO", "INE01C001018", "ADANIPORTS", true, true, 348, 1631145600000, 270, "buy", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["OUYO53NES6HVEGSBXALX", "INE364U01010", "ADANIGREEN", true, false, 15, 1680652800000, 281, "buy", 127, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["K0TMWRLU5HDBSNDITGWA", "INE01C001018", "ADANIPORTS", true, true, 256, 1682640000000, 409, "sell", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["NJK6VY186PT29EQOL5ZS", "INE767A01016", "ADANIENT", true, true, 60, 1695340800000, 2300, "sell", 1260, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["YYUFIXODHUCNJPZL0TB1", "INE767A01016", "ADANIENT", true, true, 23, 1681948800000, 2016, "buy", 1260, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["DPB5UCBWCTWCCZQZAECT", "INE767A01016", "ADANIENT", true, true, 20, 1695772800000, 2456, "sell", 1260, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["ZDUUQFIZKFI1LPZJIGC1", "INE364U01010", "ADANIGREEN", true, true, 47, 1683763200000, 310, "buy", 127, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["OCFAGNA9WLZOS2GPVEWY", "INE364U01010", "ADANIGREEN", true, true, 40, 1685059200000, 365, "sell", 127, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["JOQYLFGNAJXEBBANLTJ9", "INE364U01010", "ADANIGREEN", true, true, 20, 1689206400000, 290, "buy", 127, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["USTNCKBL23ZGYFBS1FWW", "INE01C001018", "ADANIPORTS", true, true, 44, 1682899200000, 418, "sell", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["AMLDHHSPBR225CYDH1G3", "INE01C001018", "ADANIPORTS", true, true, 20, 1689552000000, 436, "sell", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["RZ4TQQXBXGQZ4CIGW89W", "INE01C001018", "ADANIPORTS", true, false, 30, 1689638400000, 410, "buy", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["ABHV4GJO8FEWYZYYZXJ9", "INE01C001018", "ADANIPORTS", true, true, 20, 1692144000000, 429, "buy", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["G4FILRR9JSAWETX5BFEG", "INE01C001018", "ADANIPORTS", true, true, 58, 1695945600000, 447, "sell", 137, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["3S1E2CVMTK3I115OG5IT", "INE002A01018", "AJANTAPHARMA", true, true, 900, 1672876800000, 618, "sell", 438, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["J9SYLEPLST8YFGPUOFCG", "INE002A01018", "AJANTAPHARMA", true, true, 145, 1686182400000, 578, "buy", 438, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["HJWC2DJPNJV7KBYAVLMP", "INE002A01018", "AJANTAPHARMA", true, true, 190, 1692921600000, 689, "sell", 438, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["8LWK9OAGZ64HKNYHYX6H", "INE462A01022", "BAYERCROP", true, true, 31, 1681862400000, 4217.67, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["ZR0GPABQCZJDEBAVL85E", "INE462A01022", "BAYERCROP", true, true, 29, 1682726400000, 4198.05, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["ROJM9PXLTVRGADTWZXMX", "INE462A01022", "BAYERCROP", true, true, 10, 1684454400000, 4228, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["ROJM9PXLTVRGADTWZXMX", "INE462A01022", "BAYERCROP", true, true, 9, 1684454400000, 4249, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["RP9WLFA5LS29NBTKARXN", "INE462A01022", "BAYERCROP", true, false, 25, 1686960000000, 4254, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["UCB2JO0JMYBFRYRHILMZ", "INE462A01022", "BAYERCROP", true, true, 25, 1686960000000, 4239, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["G3NSSV7XHVFUJ8BTPBIR", "INE462A01022", "BAYERCROP", true, true, 29, 1689120000000, 4221, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["1JQ2PDASHYXZCVH6IFTC", "INE462A01022", "BAYERCROP", true, true, 70, 1693440000000, 4278.08, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["XAOZHKSKJV0S5IENATLG", "INE462A01022", "BAYERCROP", true, false, 28, 1695859200000, 4289, "buy", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["AU2VBOKJGOGV82FMOSZL", "INE462A01022", "BAYERCROP", true, true, 28, 1695945600000, 4298, "sell", 4199.55, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["XEPL8VAO3PWPBVZRBSCE", "INE00E101023", "BIKAJI", true, true, 200, 1631923200000, 221, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["XEPL8VAO3PWPBVZRBSCE", "INE00E101023", "BIKAJI", true, true, 85, 1632009600000, 225, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["IAVLRAW3OKLIHPD0DLKQ", "INE00E101023", "BIKAJI", true, true, 640, 1677283200000, 265, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["YHEZMWYMV85DIO52CY1B", "INE00E101023", "BIKAJI", true, true, 110, 1676332800000, 257, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["90VSCSRGLVSHW6FYHQDE", "INE00E101023", "BIKAJI", true, false, 85, 1678665600000, 269, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["DLQMNK7WJJEH6SZOCZO6", "INE00E101023", "BIKAJI", true, true, 85, 1678665600000, 273, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["7UBKDTDSUWJEWXI71MB5", "INE00E101023", "BIKAJI", true, true, 250, 1682640000000, 317, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["SVYLOESSMFAWL2P1V4YN", "INE00E101023", "BIKAJI", true, true, 260, 1684454400000, 334, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["KZ4XUMQL7O4OL1T0NWLW", "INE00E101023", "BIKAJI", true, true, 140, 1686787200000, 327, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["KZ4XUMQL7O4OL1T0NWLW", "INE00E101023", "BIKAJI", true, false, 267, 1686873600000, 329, "buy", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["UZB55NEDOEZEB81QTBOI", "INE00E101023", "BIKAJI", true, true, 267, 1686960000000, 321, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "intraday"], ["T2D14C472FNCQD8A9SEL", "INE00E101023", "BIKAJI", true, true, 730, 1689897600000, 339, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["IHQR3WDABXX5LWECAVD4", "INE00E101023", "BIKAJI", true, true, 349, 1690675200000, 345, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"], ["ZJZZOQLJZWYQRMSHK2E3", "INE00E101023", "BIKAJI", true, true, 321, 1693440000000, 370, "sell", 0, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, 45.6, nil, "delivery"]]}]}, {"name"=>"option_tradebook_sheet", "@entity"=>"sheet", "blocks"=>[{"name"=>"option_tradebook_table", "@entity"=>"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"=>[["RJFWB5JYYDORFUEPK5DQ", nil, "BANKNIFTY 01 Jun 2023 CE 44100", "equity", 25, 1680739200000, 363.1, "buy", 385, 201, 2235, 795, 1757, 202, 195, 2060, 2112, 1622, nil], ["Y6W9FLHOVJ8TCHHNBYGF", "INE545C01013", "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 75, 1683158400000, 363.15, "buy", 2479, 304, 1657, 2282, 1170, 172, 1307, 1660, 1130, 1106, nil], ["DML3WXXE53PJOTGTEYKJ", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 100, 1662940800000, 415, "buy", 107, 8, 114, 111, 90, 43, 36, 48, 119, 21, nil], ["GYHVDLIIXVTLROOCLVYG", "INE579I01014", "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 135, 1670630400000, 90.69, "buy", 134, 183, 209, 9, 100, 50, 202, 60, 140, 214, nil], ["ULDR4PE639LOMU4A4VCE", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 75, 1670457600000, 1570, "buy", 2122, 1793, 1820, 1893, 560, 1651, 875, 2161, 32, 1916, nil], ["VIHCPUEYSZUMQUVPSJ1P", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 125, 1671840000000, 1490, "buy", 114, 1074, 1522, 44, 1158, 535, 2252, 1115, 1171, 2449, nil], ["QOO5OYJLQBIRUMIGKCIQ", "INE769A01020", "FINNIFTY 25 JAN 2023 CE 12500", "equity", 50, 1672617600000, 3450.67, "buy", 831, 1827, 1117, 1814, 1230, 499, 1882, 2344, 457, 1850, nil], ["2BOMU4R5WMEONKEI5YT6", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 250, 1673481600000, 168, "buy", 1280, 657, 1291, 1139, 636, 2397, 795, 1161, 2236, 1620, nil], ["PZUTEFRTRX9LFW9DPHAW", "INE118D01016", "NIFTY 23 JAN 2023 CE 15650", "equity", 100, 1672444800000, 175.55, "buy", 125, 882, 2432, 2077, 2189, 2472, 2156, 1856, 1068, 2285, nil], ["DIQDEZH7K04QBDCJY0NV", "INE002A01018", "FINNIFTY 15 FEB 2023 CE 13400", "equity", 50, 1674086400000, 194.9, "buy", 1645, 1807, 1262, 2482, 829, 782, 540, 1000, 354, 2491, nil], ["PGR2RDEZFVC2S3YBX1JF", "INE0C5901014", "NIFTY 23 FEB 2023 PE 17100", "equity", 105, 1675296000000, 194.9, "buy", 1760, 1640, 2143, 905, 1374, 1714, 842, 1776, 847, 299, nil], ["TFCXQ3TKQRMOHU86MXO1", "INE082B0101", "BANKNIFTY 20 MAR 2023 PE 18900", "equity", 155, 1676505600000, 1500, "buy", 104, 552, 1064, 2411, 1835, 2056, 2421, 2289, 651, 2315, nil], ["DUYJ4ZV7OKJA8CV8U1MT", "INE0C5901014", "NIFTY 17 APR 2023 PE 17800", "equity", 55, 1679616000000, 457.89, "buy", 1766, 2139, 1170, 2017, 723, 2101, 1756, 2357, 1517, 2394, nil], ["2GFSS7XTAHUWHFZH0NBR", "INE322R01014", "FINNIFTY 25 MAY 2023 CE 14900", "equity", 130, 1682726400000, 698.03, "buy", 682, 2191, 400, 1922, 813, 188, 1323, 188, 880, 1267, nil], ["4AGDXGEEJOUHI6G8ATOU", "INE694N01015", "RELIANCE OCT 1940 CE", "equity", 50, 1695945600000, 559.39, "buy", 1244, 2104, 102, 1018, 319, 1497, 1669, 2059, 1901, 485, nil], ["AHVDFMGBCECY1IR0QDH9", "INE197R01010", "RELIANCE OCT 1960 CE", "equity", 175, 1696982400000, 1000, "buy", 2181, 2407, 104, 398, 1577, 1341, 55, 1215, 1616, 879, nil], ["Q2DZQ1ITYAOXILWQLHDN", "INE576G01015", "INFOSYS OCT 2550 CE", "equity", 150, 1697500800000, 175, "buy", 444, 1610, 769, 2289, 1456, 437, 1601, 620, 810, 1319, nil], ["FQQ96BPTGAPAQPLMABNU", "INE197R01010", "RELIANCE OCT 1920 CE", "equity", 250, 1697846400000, 186, "buy", 1158, 1954, 1513, 2091, 1622, 1175, 383, 2049, 191, 1624, nil], ["RKW88OVAQVWZMCD9VLJL", "INE512R01010", "INFOSYS OCT 2590 CE", "equity", 225, 1698105600000, 180, "buy", 874, 1430, 2384, 1648, 1398, 596, 367, 396, 1897, 1511, nil], ["TTGYOR1EOA3SUTMNCJ58", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 25, 1663632000000, 423, "sell", 106, 107, 78, 45, 79, 100, 14, 58, 70, 85, nil], ["MYOFOBCC5W0PCWHVBFPU", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 50, 1664496000000, 456, "buy", 80, 89, 33, 66, 61, 71, 116, 120, 55, 33, nil], ["VIX3TEN3GZKPVY2WZCEX", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 125, 1665619200000, 449, "sell", 4, 73, 78, 84, 113, 71, 1, 75, 118, 18, nil], ["Q5CUBQ2P6B7VKNHCKWD6", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 50, 1665446400000, 135, "buy", 237, 56, 15, 18, 104, 15, 22, 76, 89, 112, nil], ["Q5CUBQ2P6B7VKNHCKWD6", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 80, 1665446400000, 142, "buy", 188, 53, 11, 89, 31, 92, 119, 77, 58, 6, nil], ["DTXGC9I0ZVOI2FFSHIOL", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 70, 1666137600000, 148, "sell", 77, 57, 74, 83, 42, 83, 110, 104, 60, 102, nil], ["DTXGC9I0ZVOI2FFSHIOL", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 30, 1666224000000, 150, "sell", 187, 112, 77, 67, 93, 19, 84, 19, 54, 47, nil], ["IU0HYP6ZN9EOERPBEWYA", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 140, 1666828800000, 137, "buy", 234, 97, 29, 100, 39, 72, 49, 115, 110, 93, nil], ["TAODZZPWWR9R5CO1QX0R", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 80, 1668470400000, 154, "sell", 136, 76, 35, 49, 98, 56, 75, 2, 15, 75, nil], ["TAODZZPWWR9R5CO1QX0R", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 20, 1668470400000, 153, "buy", 211, 31, 34, 6, 18, 105, 104, 41, 67, 52, nil], ["HVG5B4A45J9CL4CZ35TF", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 130, 1668902400000, 156, "sell", 110, 41, 105, 57, 47, 64, 63, 34, 46, 26, nil], ["CJ7UKXJFK6WDVAUWGXGW", "INE113J07012", "OPTFUT GOLD 29 OCT 2023 60000 PE", "commodity", 55, 1694995200000, 124.56, "sell", 103, 48, 70, 111, 21, 40, 84, 69, 15, 16, nil], ["EAU3BEIXICIMKLVWWU56", "INE113J07012", "OPTFUT GOLD 29 OCT 2023 60000 PE", "commodity", 55, 1695254400000, 121, "buy", 125, 52, 36, 22, 92, 17, 67, 79, 46, 109, nil], ["OJDZI0SB29R3RMHWOG8P", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 85, 1697587200000, 135, "buy", 212, 24, 78, 32, 52, 54, 7, 83, 8, 119, nil], ["DOHDNKFFITQRMFUYKQLE", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 35, 1698019200000, 138, "buy", 25, 89, 59, 114, 63, 56, 108, 2, 64, 35, nil], ["CVWO1J0HIG9QEY5UVUDQ", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 90, 1700352000000, 142, "sell", 108, 57, 19, 77, 25, 94, 115, 78, 71, 117, nil], ["R2K5E791EH5VAQZVOETW", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 10, 1700524800000, 149, "sell", 130, 3, 116, 15, 41, 119, 118, 26, 76, 77, nil], ["GYHVDLIIXVTLROOCLVYG", "INE579I01014", "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 145, 1670630400000, 87.45, "buy", 212, 202, 223, 125, 116, 48, 71, 75, 100, 24, nil], ["8VMAOKSBFKXAX1Z75UK5", "INE579I01014", "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 165, 1671494400000, 94.78, "sell", 177, 48, 234, 38, 176, 182, 159, 80, 200, 136, nil], ["ZXORPEEJE7TVFBPXQ8LI", "INE579I01014", "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 100, 1672358400000, 45.98, "sell", 97, 219, 153, 19, 118, 231, 228, 31, 185, 186, nil], ["ZXORPEEJE7TVFBPXQ8LI", "INE579I01014", "OPTCUR USDINR 27 JAN 2023 83 PE", "currency", 15, 1672617600000, 78.3, "sell", 94, 93, 127, 162, 79, 232, 149, 211, 83, 6, nil], ["6MDVYEYUKHJXIQSGEOPU", "INE645F01015", "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 50, 1680134400000, 245.78, "sell", 46, 228, 186, 237, 75, 6, 46, 97, 203, 34, nil], ["CPYBETZOWLDVTAYF3PRA", "INE645F01015", "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 50, 1680134400000, 260.7, "buy", 178, 162, 152, 207, 202, 185, 95, 232, 121, 209, nil], ["MEHVXLLGPB5SODCHL5PT", "INE645F01015", "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 145, 1680307200000, 278, "sell", 20, 164, 152, 121, 98, 148, 35, 194, 110, 34, nil], ["UQCTRKWJRKXVR7LSIBCN", "INE645F01015", "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 145, 1680739200000, 289, "buy", 25, 85, 159, 60, 145, 36, 46, 146, 237, 157, nil], ["PIN8G2M1QKXY1FQZPRIF", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 75, 1694649600000, 4500, "buy", 21, 179, 65, 29, 21, 92, 124, 178, 153, 12, nil], ["PIN8G2M1QKXY1FQZPRIF", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 75, 1694649600000, 4509, "sell", 15, 93, 151, 111, 104, 103, 55, 238, 153, 97, nil], ["69WJ3BI70HPVKNLEK5TR", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 113, 1695168000000, 4492.367, "buy", 57, 230, 240, 67, 116, 76, 6, 3, 169, 150, nil], ["P534DDQESQ6XNTI4NURV", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 60, 1695859200000, 4499.876, "sell", 145, 184, 130, 50, 35, 17, 90, 146, 149, 199, nil], ["OXGR4W3D3MYYBURZOEJ5", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 43, 1697673600000, 5008.596, "sell", 47, 22, 47, 31, 24, 32, 128, 195, 47, 87, nil], ["T6B8078DHAC9MGWPKR6B", "INE632P01025", "OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 120, 1690848000000, 345.89, "sell", 7, 203, 116, 18, 12, 64, 159, 151, 211, 148, nil], ["OFAILEZLEAPD9SU5ZOMT", "INE632P01025", "OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 80, 1691452800000, 325.67, "buy", 44, 87, 14, 179, 169, 178, 97, 26, 72, 170, nil], ["OFAILEZLHKPD8SU7ZOMT", "INE632P01025", "OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 30, 1691452800000, 319.78, "buy", 89, 205, 71, 145, 106, 166, 209, 67, 6, 124, nil], ["FDIT8EQR2XJFQJU2JLIG", "INE632P01025", "OPTCUR JPYINR 24 AUG 2023 45.6 CE", "currency", 40, 1692230400000, 329.587, "sell", 59, 42, 140, 65, 52, 47, 80, 128, 39, 105, nil], ["KLPAV9GOUCMPFH1WNKLV", "INE619I01012", "BANKNIFTY 01 Jun 2023 CE 44100", "equity", 25, 1685318400000, 450.09, "sell", 1657, 1302, 325, 2118, 2050, 604, 2148, 626, 1489, 2090, nil], ["0WNSDPGK4LTXO38HPTLU", "INE545C01013", "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 25, 1685577600000, 469.22, "sell", 1711, 1948, 2048, 700, 2360, 120, 2415, 333, 2231, 736, nil], ["QS2KFCND5DJXRNDLLVHD", "INE545C01013", "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 50, 1684886400000, 425.3, "sell", 320, 375, 82, 1593, 1653, 620, 1637, 712, 542, 130, nil], ["0B3PIU4WMIPKUQEG34BO", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 25, 1671408000000, 1460, "sell", 499, 2262, 2210, 507, 256, 2293, 1125, 2345, 1852, 90, nil], ["S7XOLPIQ2V4R5L89ZEE1", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 45, 1672358400000, 1508, "sell", 1784, 825, 2087, 498, 666, 616, 1994, 763, 157, 2380, nil], ["HSZA8B3XH3JC2POXMSXJ", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 50, 1673568000000, 1585, "sell", 335, 1434, 254, 1609, 999, 1979, 2229, 127, 389, 1244, nil], ["ILKEYGKTOHFQI5UXMBOO", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 80, 1674172800000, 1635, "sell", 208, 535, 279, 401, 2010, 248, 494, 746, 2399, 1196, nil], ["A9HFP9X49AROF21K9KRY", "INE769A01020", "FINNIFTY 25 JAN 2023 CE 12500", "equity", 50, 1674518400000, 2568.98, "sell", 319, 59, 25, 2409, 2339, 423, 132, 250, 2137, 2442, nil], ["GHQTIWHDAFE90NOAU6ZY", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 25, 1672185600000, 146, "sell", 1525, 678, 749, 379, 277, 1791, 2288, 545, 1042, 327, nil], ["GHQTIWHDAFE90NOAU6ZY", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 75, 1672531200000, 158, "sell", 1761, 2349, 1082, 2181, 1054, 1396, 856, 1220, 1740, 1791, nil], ["IXMBK9LENH6CSGULION2", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 150, 1674259200000, 255, "sell", 2369, 875, 2202, 2488, 1574, 404, 532, 779, 2266, 1396, nil], ["BEZ31FONIR1EQQI68F0Y", "INE118D01016", "NIFTY 23 JAN 2023 CE 15650", "equity", 100, 1674432000000, 126.78, "sell", 288, 7, 2495, 1391, 1859, 28, 1298, 355, 1234, 1955, nil], ["HMC8SXGWGNGWUTFBYRHX", "INE002A01018", "FINNIFTY 15 FEB 2023 CE 13400", "equity", 50, 1675814400000, 174.55, "sell", 879, 2335, 1905, 1798, 456, 1765, 358, 1368, 1124, 1040, nil], ["KQDQ54GEHLHTIUSPGAV6", "INE0C5901014", "NIFTY 23 FEB 2023 PE 17100", "equity", 55, 1675987200000, 174.8, "sell", 181, 764, 1349, 1121, 2195, 2042, 1398, 1674, 164, 2244, nil], ["SLB3JNRIBXSZWLRWP8ZZ", "INE0C5901014", "NIFTY 23 FEB 2023 PE 17100", "equity", 50, 1676764800000, 210.89, "sell", 77, 713, 1563, 1666, 1745, 20, 528, 2500, 1068, 2008, nil], ["LMQI22RLLZHQ5CWBGFYP", "INE082B0101", "BANKNIFTY 20 MAR 2023 PE 18900", "equity", 155, 1679097600000, 615.89, "sell", 1842, 519, 2150, 997, 536, 1241, 2437, 765, 2481, 2126, nil], ["71ZRU28BNR9F5FMOZS8V", "INE0C5901014", "NIFTY 17 APR 2023 PE 17800", "equity", 55, 1681084800000, 489.67, "sell", 1519, 340, 2379, 190, 164, 2420, 662, 226, 1681, 722, nil], ["PHGLBJWZZLIDKTTVLNQE", "INE322R01014", "FINNIFTY 25 MAY 2023 CE 14900", "equity", 120, 1684368000000, 745.32, "sell", 820, 1114, 2137, 646, 2399, 2314, 160, 1817, 2092, 283, nil], ["SEZD4CXXIXJ79ZS0GUQ2", "INE694N01015", "RELIANCE OCT 1940 CE", "equity", 50, 1697328000000, 615.35, "sell", 1797, 249, 1653, 2028, 897, 542, 1158, 2067, 964, 1393, nil], ["UESSXHU0UHWCRJ1Z7LJR", "INE576G01015", "INFOSYS OCT 2550 CE", "equity", 150, 1698192000000, 145, "sell", 1204, 722, 1103, 2190, 1165, 1168, 597, 1485, 1127, 1175, nil], ["TVSWJDGSX7VFVHA2AUXG", "INE197R01010", "RELIANCE OCT 1920 CE", "equity", 250, 1698624000000, 199, "sell", 267, 1371, 436, 2246, 1747, 765, 1306, 1279, 1236, 1962, nil]]}]}, {"name"=>"future_tradebook_sheet", "@entity"=>"sheet", "blocks"=>[{"name"=>"future_tradebook_table", "@entity"=>"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"=>[["GGFCHMYLKDQYZRRINTEE", nil, "BANKNIFTY 01 Jun 2023 FUT", "equity", 45, 1680739200000, 363.1, "buy", 51, 98, 75, 55, 32, 219, 11, 142, 55, 36, nil], ["AUGUWEK01EI4YOIMH7RK", "INE519I01013", "BANKNIFTY 15 Jun 2023 FUT", "equity", 50, 1683158400000, 363.15, "buy", 7, 56, 55, 223, 245, 330, 106, 144, 103, 9, nil], ["55MCNYCUWJO7C3ZAXWIX", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 100, 1662940800000, 415, "buy", 107, 8, 114, 111, 90, 43, 36, 48, 119, 21, nil], ["JDNI9UJFKN2PGFJZ5U9O", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 135, 1670630400000, 90.69, "buy", 134, 183, 209, 9, 100, 50, 202, 60, 140, 214, nil], ["5NGIOMFGDRBG5Q8XTNBP", "INE512R02109", "NIFTY 23 JAN 2023 FUT", "equity", 75, 1670457600000, 147.89, "buy", 143, 44, 39, 61, 130, 216, 102, 90, 158, 37, nil], ["ANH3LZISNL7R8DPFNHJ0", "INE512R02109", "NIFTY 23 JAN 2023 FUT", "equity", 125, 1671840000000, 153.89, "buy", 84, 60, 3, 129, 221, 239, 11, 42, 160, 8, nil], ["S4LOWQJP4P6SFB42C460", "INE769A01020", "FINNIFTY 25 JAN 2023 FUT", "equity", 35, 1672617600000, 3450.67, "buy", 23, 98, 64, 214, 268, 161, 118, 116, 9, 21, nil], ["Z0FCJBWODSL8GF3KKVPY", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 250, 1673481600000, 168, "buy", 27, 73, 8, 224, 284, 306, 42, 111, 5, 17, nil], ["CIKTMLOWJQLROEGJXMFF", "INE118D01016", "NIFTY 25 JAN 2023 FUT", "equity", 100, 1672444800000, 175.55, "buy", 65, 76, 54, 192, 58, 74, 149, 50, 17, 20, nil], ["NKN2PS2TJZWDA9CDP1RA", "INE002A01018", "FINNIFTY 15 FEB 2023 FUT", "equity", 155, 1674086400000, 194.9, "buy", 39, 85, 72, 144, 40, 15, 16, 39, 66, 47, nil], ["TWF45MCZTDWEWSJXU3EF", "INE0C5901014", "NIFTY 23 FEB 2023 FUT", "equity", 175, 1675296000000, 194.9, "buy", 50, 107, 81, 244, 314, 247, 91, 42, 72, 44, nil], ["8LEGU2BN0HXVHXYBIIRZ", "INE435D01014", "BANKNIFTY 20 MAR 2023 FUT", "equity", 125, 1676505600000, 1500, "buy", 62, 53, 28, 146, 85, 446, 149, 77, 165, 22, nil], ["GB8MD1GQRMB7M3KIPYBT", "INE0C5901014", "NIFTY 17 APR 2023 FUT", "equity", 145, 1679616000000, 457.89, "buy", 131, 77, 80, 49, 161, 373, 17, 130, 77, 16, nil], ["GUEQKVCN1OGWGMPXO1WQ", "INE322R01014", "FINNIFTY 20 MAY 2023 FUT", "equity", 130, 1682726400000, 698.03, "buy", 85, 110, 89, 148, 121, 426, 32, 65, 22, 31, nil], ["JG3ZELDXI8SYG4HLXSCG", "INE694N01015", "RIL 15 OCT 2023 FUT", "equity", 50, 1695945600000, 559.39, "buy", 111, 42, 44, 189, 145, 307, 57, 64, 43, 28, nil], ["1HLEP1MBFH5JINCYGEJB", "INE197R01010", "RIL 01 NOV 2023 FUT", "equity", 175, 1696982400000, 1000, "buy", 72, 52, 33, 117, 71, 327, 39, 67, 132, 3, nil], ["YFVS53SUIXO1FBXICSP8", "INE576G01015", "INFY 30 OCT 2023 FUT", "equity", 100, 1697500800000, 175, "buy", 40, 81, 12, 197, 124, 314, 159, 79, 166, 3, nil], ["EGTDOZWR9NJKLHJDXYSO", "INE197R01010", "RIL 31 OCT 2023 FUT", "equity", 250, 1697846400000, 186, "buy", 150, 2, 17, 244, 29, 366, 100, 41, 15, 36, nil], ["JBJYWGG6VA3VFF3J7OWZ", "INE512R01010", "INFY 25 OCT FUT", "equity", 225, 1698105600000, 180, "buy", 69, 65, 61, 243, 278, 69, 18, 109, 55, 17, nil], ["52VUZC1SJ5MW4IKAJPIA", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 25, 1663632000000, 423, "sell", 106, 107, 78, 45, 79, 100, 14, 58, 70, 85, nil], ["2FPD4QFGHO2ICG3SK0KG", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 50, 1664496000000, 456, "buy", 80, 89, 33, 66, 61, 71, 116, 120, 55, 33, nil], ["XPDDDCPTROUOHFWCQH7O", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 125, 1665619200000, 449, "sell", 4, 73, 78, 84, 113, 71, 1, 75, 118, 18, nil], ["KMY2EC1UMISH0BUMIEGT", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 50, 1665446400000, 135, "buy", 237, 56, 15, 18, 104, 15, 22, 76, 89, 112, nil], ["KMY2EC1UMISH0BUMIEGT", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 80, 1665446400000, 142, "buy", 188, 53, 11, 89, 31, 92, 119, 77, 58, 6, nil], ["JAWOZXSLWYKHKUWGWS6L", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 70, 1666137600000, 148, "sell", 77, 57, 74, 83, 42, 83, 110, 104, 60, 102, nil], ["JAWOZXSLWYKHKUWGWS6L", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 30, 1666224000000, 150, "sell", 187, 112, 77, 67, 93, 19, 84, 19, 54, 47, nil], ["1AW8BG2NTK1BPSLMR0TV", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 140, 1666828800000, 137, "buy", 234, 97, 29, 100, 39, 72, 49, 115, 110, 93, nil], ["XOUZUWMHBDCRPKRGDD1Q", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 80, 1668470400000, 154, "sell", 136, 76, 35, 49, 98, 56, 75, 2, 15, 75, nil], ["XOUZUWMHBDCRPKRGDD1Q", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 20, 1668470400000, 153, "buy", 211, 31, 34, 6, 18, 105, 104, 41, 67, 52, nil], ["LAGBHUZEYUH1K2OMGP49", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 130, 1668902400000, 156, "sell", 110, 41, 105, 57, 47, 64, 63, 34, 46, 26, nil], ["GR4XEL9XWBSYPARPT0EF", "INE113J07012", "FUTCOM GOLD 29 OCT 2023", "commodity", 55, 1694995200000, 124.56, "sell", 103, 48, 70, 111, 21, 40, 84, 69, 15, 16, nil], ["M5ZXEWJZFFR9DR1ECYIE", "INE113J07012", "FUTCOM GOLD 29 OCT 2023", "commodity", 55, 1695254400000, 121, "buy", 125, 52, 36, 22, 92, 17, 67, 79, 46, 109, nil], ["FUWODRFMJFABB1VZGX5D", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 85, 1697587200000, 135, "buy", 212, 24, 78, 32, 52, 54, 7, 83, 8, 119, nil], ["XVFHRXHI6QWNJUUKBJ0J", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 35, 1698019200000, 138, "buy", 25, 89, 59, 114, 63, 56, 108, 2, 64, 35, nil], ["OHNNDTMWFFACP6JQ82GM", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 90, 1700352000000, 142, "sell", 108, 57, 19, 77, 25, 94, 115, 78, 71, 117, nil], ["RRCAFBZWEKTPVLYJCRB4", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 10, 1700524800000, 149, "sell", 130, 3, 116, 15, 41, 119, 118, 26, 76, 77, nil], ["JDNI9UJFKN2PGFJZ5U9O", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 145, 1670630400000, 87.45, "buy", 212, 202, 223, 125, 116, 48, 71, 75, 100, 24, nil], ["4TXSMROXNCO4YKN01YBF", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 165, 1671494400000, 94.78, "sell", 177, 48, 234, 38, 176, 182, 159, 80, 200, 136, nil], ["D1VHUJNJ1WGO9JVCK2AZ", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 100, 1672358400000, 45.98, "sell", 97, 219, 153, 19, 118, 231, 228, 31, 185, 186, nil], ["D1VHUJNJ1WGO9JVCK2AZ", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 15, 1672617600000, 78.3, "sell", 94, 93, 127, 162, 79, 232, 149, 211, 83, 6, nil], ["UVSIUTXLTZHDRHICW9C0", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 50, 1680134400000, 245.78, "sell", 46, 228, 186, 237, 75, 6, 46, 97, 203, 34, nil], ["V7L7EV2WB1F06YIJSHQS", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 50, 1680134400000, 260.7, "buy", 178, 162, 152, 207, 202, 185, 95, 232, 121, 209, nil], ["8GTJ7JADP09KTKDPFWQJ", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 145, 1680307200000, 278, "sell", 20, 164, 152, 121, 98, 148, 35, 194, 110, 34, nil], ["XNAQJZ3OTJFDZ2FEGVVQ", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 145, 1680739200000, 289, "buy", 25, 85, 159, 60, 145, 36, 46, 146, 237, 157, nil], ["NU9Y7DKWYXX1B8HUGX0G", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 75, 1694649600000, 4500, "buy", 21, 179, 65, 29, 21, 92, 124, 178, 153, 12, nil], ["NU9Y7DKWYXX1B8HUGX0G", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 75, 1694649600000, 4509, "sell", 15, 93, 151, 111, 104, 103, 55, 238, 153, 97, nil], ["7BN92HT8TUYNDOW29YPQ", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 113, 1695168000000, 4492.367, "buy", 57, 230, 240, 67, 116, 76, 6, 3, 169, 150, nil], ["QRJDSFMYL79ULAWADZ4C", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 60, 1695859200000, 4499.876, "sell", 145, 184, 130, 50, 35, 17, 90, 146, 149, 199, nil], ["FZJQJNQWOJE78OSAKILB", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 43, 1697673600000, 5008.596, "sell", 47, 22, 47, 31, 24, 32, 128, 195, 47, 87, nil], ["BZAB3NIFLVXCEWLNXF0C", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 120, 1690848000000, 345.89, "sell", 7, 203, 116, 18, 12, 64, 159, 151, 211, 148, nil], ["EUCWBOWYUQF5LLS2MG9P", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 80, 1691452800000, 325.67, "buy", 44, 87, 14, 179, 169, 178, 97, 26, 72, 170, nil], ["EUCWBOWYUQF5LLS2MG9P", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 30, 1691452800000, 319.78, "buy", 89, 205, 71, 145, 106, 166, 209, 67, 6, 124, nil], ["MUYD0KEIED2TJLMOBKEM", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 40, 1692230400000, 329.587, "sell", 59, 42, 140, 65, 52, 47, 80, 128, 39, 105, nil], ["DROFW5LAACDWOCFKDQET", "INE914J01012", "BANKNIFTY 01 Jun 2023 FUT", "equity", 45, 1685318400000, 450.09, "sell", 111, 55, 14, 84, 291, 436, 146, 24, 168, 39, nil], ["Y9V66LWUBLF8P2I8FDAR", "INE519I01013", "BANKNIFTY 15 Jun 2023 FUT", "equity", 25, 1685577600000, 469.22, "sell", 78, 91, 80, 41, 123, 291, 83, 151, 115, 11, nil], ["2C7BGL8DLAEX6DMFGRTF", "INE519I01013", "BANKNIFTY 15 Jun 2023 FUT", "equity", 25, 1684886400000, 425.3, "sell", 22, 107, 62, 188, 249, 158, 117, 82, 21, 18, nil], ["CJLNLY40ORWJXUKGVC8E", "INE894N01016", "NIFTY 23 JAN 2023 FUT", "equity", 25, 1671408000000, 135.67, "sell", 69, 101, 25, 74, 90, 300, 128, 21, 56, 3, nil], ["GFHNW8Q8GH4F408UZQ0M", "INE894N01017", "NIFTY 23 JAN 2023 FUT", "equity", 45, 1672358400000, 129.89, "sell", 132, 88, 37, 24, 279, 212, 148, 43, 116, 26, nil], ["LL4ESNCPAINCWUTVOYKX", "INE894N01018", "NIFTY 23 JAN 2023 FUT", "equity", 50, 1673568000000, 147.89, "sell", 53, 67, 8, 87, 63, 171, 86, 89, 83, 9, nil], ["WI62KWVR0MYO0WXLDQ4J", "INE694C01015", "NIFTY 23 JAN 2023 FUT", "equity", 80, 1674172800000, 150, "sell", 10, 50, 68, 204, 60, 36, 24, 6, 43, 16, nil], ["IJPDDNJO9BNNH0TB9NPJ", "INE769A01020", "FINNIFTY 25 JAN 2023 FUT", "equity", 35, 1674518400000, 2568.98, "sell", 132, 85, 15, 82, 101, 10, 152, 75, 46, 11, nil], ["VLNYY0FTJTUGELL1TK8D", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 25, 1672185600000, 146, "sell", 105, 53, 3, 114, 193, 397, 8, 2, 58, 43, nil], ["VLNYY0FTJTUGELL1TK8D", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 75, 1672531200000, 158, "sell", 54, 105, 28, 102, 11, 64, 41, 148, 143, 3, nil], ["VY3TYTSPMWLYJQAEMGTZ", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 150, 1674259200000, 255, "sell", 138, 32, 42, 214, 44, 13, 146, 43, 52, 35, nil], ["YQT2WZWDNZPPCRDSQFR9", "INE118D01016", "NIFTY 25 JAN 2023 FUT", "equity", 100, 1674432000000, 126.78, "sell", 18, 23, 81, 239, 107, 183, 158, 64, 137, 50, nil], ["9ZLDZGRMJBSSAIJTBTHN", "INE002A01018", "FINNIFTY 15 FEB 2023 FUT", "equity", 155, 1675814400000, 174.55, "sell", 130, 33, 69, 197, 298, 266, 24, 142, 9, 19, nil], ["RHSYRUIXEC7M4HJBK46H", "INE0C5901014", "NIFTY 23 FEB 2023 FUT", "equity", 55, 1675987200000, 174.8, "sell", 111, 86, 26, 17, 303, 388, 149, 16, 53, 20, nil], ["I3RI1TXUYSFLFU4N8IWZ", "INE0C5901014", "NIFTY 23 FEB 2023 FUT", "equity", 120, 1676764800000, 210.89, "sell", 115, 42, 78, 151, 292, 262, 98, 151, 37, 30, nil], ["BYSC5G1EPZIWIJJ6BAUB", "INE435D01014", "BANKNIFTY 20 MAR 2023 FUT", "equity", 125, 1679097600000, 615.89, "sell", 101, 83, 15, 219, 125, 349, 140, 154, 129, 6, nil], ["MWLF0LTSOJNEXKVXSGWN", "INE0C5901014", "NIFTY 17 APR 2023 FUT", "equity", 135, 1681084800000, 489.67, "sell", 132, 94, 74, 184, 190, 173, 30, 72, 61, 48, nil], ["B67GMDMHCZAHJBXKDGL0", "INE322R01014", "FINNIFTY 20 MAY 2023 FUT", "equity", 120, 1684368000000, 745.32, "sell", 150, 13, 35, 133, 133, 362, 128, 119, 83, 39, nil], ["DEN7PSRIFMQ0VQXZF8O8", "INE694N01015", "RIL 15 OCT 2023 FUT", "equity", 50, 1697328000000, 615.35, "sell", 99, 59, 84, 104, 322, 159, 92, 122, 136, 15, nil], ["GAVL50RNZDGGQSMMLKOF", "INE576G01015", "INFY 30 OCT 2023 FUT", "equity", 100, 1698192000000, 145, "sell", 50, 96, 11, 84, 204, 220, 20, 125, 146, 23, nil], ["BWQRBJTC2V55AFBIZPYW", "INE197R01010", "RIL 31 OCT 2023 FUT", "equity", 250, 1698624000000, 199, "sell", 89, 57, 49, 235, 303, 147, 23, 114, 11, 24, nil]]}]}, {"name"=>"mutual_fund_tradebook_sheet", "@entity"=>"sheet", "blocks"=>[{"name"=>"mutual_fund_tradebook_table", "@entity"=>"table", "header"=>["trade_id", "isin", "scheme_name", "asset_class", "is_listed", "is_stt_paid", "quantity", "date", "price", "transaction_type", "fmv", "transfer_expenses", "label"], "rows"=>[["TGFCH72LKDQY9RRINTGH", nil, "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 32.31, 1525824000000, 50, "buy", 400, 10, nil], ["KGFCH72LKDQY9RRINTGH", "INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 32.31, 1577664000000, 900, "sell", 1000, 89.658, nil], ["BVNCH72LKDQY9RRINTGH", "INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 37.216, 1589414400000, 10, "buy", 0, 98, nil], ["KHF78MYGKDQY9RRINTGH", "INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 17.823, 1650672000000, 5, "sell", 0, 20, nil], ["BNG57MYGKDQY9RRINTGH", "INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 19.574, 1515456000000, 120, "buy", 5, 78, nil], ["GHN78MYGKDQY9RRINTGH", "INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 36.711, 1682640000000, 160, "sell", 5, 33.24, nil], ["GJK45MYGKDQY9RRINTGH", "INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 36.023, 1493769600000, 30, "buy", 10, 68, nil], ["BHM88MYGKDQY9RRINTGH", "INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 36.023, 1626480000000, 60, "sell", 10, 100, nil], ["GHL909MYGKDQY9RRINTGH", "INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 35.014, 1437177600000, 15, "buy", 17, 67, nil], ["BHM88MTYH6QY9RRINTGH", "INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 19.88, 1626652800000, 60, "sell", 17, 10, nil], ["BHMGP79GKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 35.706, 1626739200000, 60, "buy", 65, 30, nil], ["BLKMN98HJNMDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 36.062, 1563667200000, 60, "buy", 120, 50, nil], ["MJK88MYGKDQY9RRINTGH", "INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 35.039, 1626912000000, 400.784, "buy", 200, 20, nil], ["CVH78MYGKDQY9RRINTGH", "INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 32.531, 1690070400000, 200, "sell", 200, 90, nil], ["GMFCH72LKDQY9RRINTGH", "INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 25.68, 1556409600000, 459, "buy", 220, 0.25, nil], ["GMFCH72LKDQY9RRINTGH", "INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 25.68, 1556409600000, 500, "sell", 220, 50, nil], ["GGFCHMYLKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 105.56, 1491436800000, 123, "buy", 20, 25, nil], ["GGFCHMYLKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 550.34, 1491436800000, 124.5, "buy", 20, 49, nil], ["JHF78MYGKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 355.9, 1662940800000, 212.7, "sell", 20, 28, nil], ["JTR59NOGKDQY9YTINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 250, 1670630400000, 209, "sell", 20, 75, nil], ["DFGR59NOHJDQ751TINTJK", "INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 129, 1670716800000, 150, "buy", 100, 32, nil], ["DFGR59NOHJDQ751TINTJK", "INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 100, 1670716800000, 250, "buy", 100, 56, nil], ["GHNR59NOHJDQ901TINTLK", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 156.78, 1481500800000, 150, "buy", 160, 22, nil], ["HNT59NOGKDQY897TINF4R", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 125, 1670889600000, 400, "sell", 160, 89.658, nil], ["KNT59NOGKDQY897TINFTR", "INF760K01FR2", "Canara Robeco Bluechip Equity Growth Direct Plan", "equity", true, true, 155, 1576022400000, 23.78, "buy", 25, 2, nil], ["HYT59NOGKDQY9YTINFGRN", "INF760K01FR2", "Canara Robeco Bluechip Equity Growth Direct Plan", "equity", true, true, 155, 1633996800000, 56.9, "sell", 45, 2, nil], ["HJM98MYGKDQY9RRINGFB", "INF200K01189", "SBI Gold Fund", "other", true, true, 35, 1374624000000, 200, "buy", 180, 589, nil], ["JMCU8MYGKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 35, 1585008000000, 230, "buy", 180, 37, nil], ["RTV678MYGKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 55, 1649289600000, 210, "sell", 180, 56, nil], ["GHN78NOGKDQY9YTINFGHY", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 50, 1633564800000, 980, "buy", 800, 145, nil], ["XCT59NOGKDQY9YTINFGRN", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 40, 1639872000000, 1000, "buy", 800, 198, nil], ["VBN59NOGKDQY9YTINFGRN", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 40, 1634169600000, 1200, "sell", 800, 230, nil], ["67859NOGKDQY9YTINFGRN", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 50, 1634342400000, 1300, "sell", 800, 245, nil]]}]}, {"name"=>"etf_tradebook_sheet", "@entity"=>"sheet", "blocks"=>[{"name"=>"etf_tradebook_table", "@entity"=>"table", "header"=>["trade_id", "isin", "scheme_name", "asset_class", "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"=>[["TGFCH72LKDQY9RRINTGH", nil, "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 250, 1651363200000, 650, "buy", 400, 115, 74, 130, 137, 144, 113, 122, 132, 69, 76, nil, "intraday"], ["KGFCH72LKDQY9RRINTGH", "INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 250, 1651363200000, 600, "sell", 400, 19, 9, 111, 62, 121, 45, 71, 74, 44, 24, nil, "intraday"], ["BVNCH72LKDQY9RRINTGH", "INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 31.536, 1660089600000, 10, "buy", 340, 92, 34, 93, 139, 17, 3, 68, 61, 48, 109, nil, "delivery"], ["KHF78MYGKDQY9RRINTGH", "INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 31.536, 1677628800000, 5, "sell", 340, 134, 111, 2, 96, 29, 36, 128, 104, 94, 101, nil, "delivery"], ["BNG57MYGKDQY9RRINTGH", "INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 80, 1568160000000, 120, "buy", 250, 127, 17, 108, 1, 26, 75, 33, 126, 113, 56, nil, "delivery"], ["GHN78MYGKDQY9RRINTGH", "INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 60, 1694044800000, 160, "sell", 250, 60, 140, 15, 119, 139, 13, 18, 106, 10, 58, nil, "delivery"], ["GJK45MYGKDQY9RRINTGH", "INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 100, 1681948800000, 30, "sell", 10, 123, 38, 8, 101, 111, 99, 103, 89, 43, 11, nil, "delivery"], ["BHM88MYGKDQY9RRINTGH", "INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 100, 1682380800000, 60, "buy", 10, 88, 62, 132, 43, 111, 35, 4, 113, 61, 3, nil, "delivery"], ["GHL909MYGKDQY9RRINTGH", "INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 20, 1668038400000, 15, "buy", 17, 37, 7, 47, 38, 9, 43, 25, 78, 72, 16, nil, "intraday"], ["BHM88MTYH6QY9RRINTGH", "INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 20, 1668038400000, 60, "sell", 17, 43, 50, 48, 1, 7, 57, 9, 64, 73, 7, nil, "intraday"], ["BHMGP79GKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 50, 1640822400000, 60, "sell", 65, 43, 59, 55, 9, 45, 50, 10, 17, 39, 22, nil, "delivery"], ["BLKMN98HJNMDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 50, 1641427200000, 120.5877, "buy", 65, 28, 17, 52, 65, 13, 40, 13, 40, 40, 28, nil, "delivery"], ["MJK88MYGKDQY9RRINTGH", "INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 150, 1627862400000, 400.784, "buy", 200, 77, 59, 77, 12, 5, 2, 7, 10, 5, 30, nil, "delivery"], ["CVH78MYGKDQY9RRINTGH", "INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 100, 1685059200000, 200, "sell", 200, 72, 24, 22, 18, 57, 14, 17, 54, 32, 50, nil, "delivery"], ["GMFCH72LKDQY9RRINTGH", "INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 100, 1683590400000, 550, "buy", 220, 137, 98, 138, 39, 106, 59, 21, 61, 146, 78, nil, "intraday"], ["FGN89H72LKDQY9RRINTKL", "INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 100, 1683590400000, 500, "sell", 220, 17, 117, 133, 9, 132, 83, 69, 1, 73, 27, nil, "intraday"], ["JNV5CHMYLKDQY9RRINTG", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 78, 1589414400000, 23, "buy", 20, 106, 17, 123, 61, 31, 105, 24, 117, 16, 62, nil, "delivery"], ["GGFCHMYLKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 78, 1650672000000, 88, "sell", 20, 79, 35, 65, 99, 120, 146, 115, 90, 100, 93, nil, "delivery"], ["PKF88MYGKDQY9RRINTGH", "INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 90, 1515456000000, 150, "buy", 100, 92, 43, 29, 90, 64, 70, 66, 51, 112, 117, nil, "delivery"], ["PKF88MYGKDQY9RRINTGH", "INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 90, 1515369600000, 250, "sell", 100, 95, 105, 55, 104, 39, 74, 23, 26, 42, 142, nil, "delivery"], ["DFGR59NOHJDQ751TINTJK", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 95, 1493769600000, 150, "buy", 160, 107, 98, 49, 143, 53, 73, 107, 52, 75, 56, nil, "delivery"], ["DFGR59NOHJDQ751TINTJK", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 50, 1493769600000, 400, "buy", 160, 9, 60, 101, 40, 146, 3, 23, 125, 139, 82, nil, "delivery"], ["GHNR59NOHJDQ901TINTLK", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 30, 1563321600000, 450, "sell", 160, 4, 82, 120, 71, 34, 38, 45, 2, 67, 98, nil, "delivery"], ["HNT59NOGKDQY897TINF4R", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 80, 1599696000000, 500, "sell", 160, 36, 36, 69, 74, 139, 57, 75, 81, 118, 149, nil, "delivery"], ["KNT59NOGKDQY897TINFTR", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 10, 1627603200000, 10, "sell", 160, 57, 141, 136, 4, 44, 47, 7, 119, 105, 138, nil, "delivery"], ["HYT59NOGKDQY9YTINFGRN", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 10, 1658361600000, 50, "sell", 160, 84, 38, 123, 61, 19, 8, 58, 18, 145, 85, nil, "delivery"], ["GJK48MYGKDQY9RRINGFB", "INF179KB1QR6", "ICICI LIQUID FUND - DIRECT PLAN", "equity", true, true, 75, 1666828800000, 45, "sell", 300, 39, 95, 149, 59, 12, 133, 149, 109, 98, 66, nil, "intraday"], ["HNM88JKGKDQY9RRINGFB", "INF179KB1QR7", "ICICI LIQUID FUND - DIRECT PLAN", "equity", true, true, 75, 1666828800000, 125, "buy", 300, 19, 128, 126, 28, 70, 59, 130, 1, 113, 31, nil, "intraday"], ["HJM98MYGKDQY9RRINGFB", "INF179KB1QR8", "ICICI LIQUID FUND - DIRECT PLAN", "equity", true, true, 75, 1658620800000, 150, "buy", 300, 61, 16, 25, 121, 50, 103, 148, 33, 75, 7, nil, "delivery"]]}]}, {"name"=>"bond_tradebook_sheet", "@entity"=>"sheet", "blocks"=>[{"name"=>"bond_tradebook_table", "@entity"=>"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"=>[["TGFCH72LKDQY9RRINTGH", nil, "07.64% NABARD TFB 2031", true, 500, 1680739200000, 10, "buy", 31, 50, 13, 3, 115, 100, 109, 56, 8, nil], ["KGFCH72LKDQY9RRINTGH", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1683158400000, 10, "buy", 121, 112, 21, 98, 33, 113, 104, 98, 61, nil], ["BVNCH72LKDQY9RRINTGH", "INE272F07011", "Blue Dart Express", true, 50, 1662940800000, 20, "buy", 35, 112, 55, 9, 13, 41, 75, 37, 5, nil], ["KHF78MYGKDQY9RRINTGH", "INE272F07011", "Blue Dart Express", true, 20, 1670630400000, 200, "sell", 108, 4, 102, 57, 11, 105, 16, 56, 86, nil], ["BNG57MYGKDQY9RRINTGH", "INE112J07020", "IFCI", true, 200, 1670457600000, 16.55, "buy", 78, 26, 27, 16, 60, 45, 87, 118, 84, nil], ["GHN78MYGKDQY9RRINTGH", "INE112J07020", "IFCI", true, 170, 1671840000000, 500, "sell", 71, 109, 99, 30, 11, 126, 102, 18, 24, nil], ["GJK45MYGKDQY9RRINTGH", "INE130K08000", "SBOX", false, 200, 1672617600000, 16.55, "buy", 60, 16, 109, 81, 80, 114, 63, 119, 84, nil], ["BHM88MYGKDQY9RRINTGH", "INE130K08000", "SBOX", false, 170, 1576022400000, 500, "sell", 78, 99, 8, 16, 9, 102, 63, 100, 31, nil], ["GHL909MYGKDQY9RRINTGH", "INE130K08001", "QCK", false, 200, 1633996800000, 16.55, "buy", 43, 127, 37, 52, 86, 116, 46, 118, 84, nil], ["BHM88MTYH6QY9RRINTGH", "INE130K08001", "QCK", false, 200, 1374624000000, 500, "sell", 48, 128, 1, 120, 112, 20, 79, 115, 74, nil], ["BHMGP79GKDQY9RRINTGH", "INE130K08012", "GGL", true, 200, 1585008000000, 550, "buy", 87, 21, 50, 5, 71, 37, 22, 81, 106, nil], ["BLKMN98HJNMDQY9RRINTGH", "INE130K08015", "GGL", true, 200, 1649289600000, 600, "sell", 37, 85, 53, 113, 102, 42, 48, 31, 15, nil], ["MJK88MYGKDQY9RRINTGH", "INE130K08019", "APPL", false, 200, 1633564800000, 350, "buy", 114, 12, 100, 114, 51, 15, 37, 44, 108, nil], ["CVH78MYGKDQY9RRINTGH", "INE130K08019", "APPL", false, 180, 1639872000000, 310, "sell", 112, 109, 45, 32, 49, 53, 47, 124, 111, nil], ["GMFCH72LKDQY9RRINTGH", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1634169600000, 125, "sell", 15, 26, 86, 64, 56, 26, 30, 21, 125, nil], ["GMFCH72LKDQY9RRINTGH", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1634342400000, 125, "sell", 76, 101, 104, 28, 127, 21, 26, 88, 70, nil], ["GGFCHMYLKDQY9RRINTGH", "INE261F07055", "SGB", true, 500, 1437177600000, 488, "buy", 95, 69, 57, 104, 77, 41, 38, 28, 101, nil], ["GGFCHMYLKDQY9RRINTGH", "INE261F07055", "SGB", true, 500, 1626652800000, 322, "buy", 22, 51, 38, 76, 101, 87, 53, 77, 4, nil], ["JHF78MYGKDQY9RRINTGH", "INE261F07055", "SGB", true, 100, 1626739200000, 350, "buy", 11, 26, 86, 34, 107, 43, 1, 101, 6, nil], ["JTR59NOGKDQY9YTINTGH", "INE261F07055", "SGB", true, 550, 1563667200000, 350, "sell", 107, 97, 94, 49, 49, 9, 112, 69, 129, nil], ["DFGR59NOHJDQ751TINTJK", "INE261F07055", "SGB", true, 50, 1570579200000, 400, "sell", 80, 10, 130, 58, 5, 46, 108, 40, 106, nil]]}]}, {"name"=>"debenture_tradebook_sheet", "@entity"=>"sheet", "blocks"=>[{"name"=>"debenture_tradebook_table", "@entity"=>"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"=>[["RJFWB5JYYDORFUEPK5DQ", nil, "07.64% NABARD TFB 2031", true, 1000, 1525824000000, 10, "buy", 177, 180, 238, 105, 243, 101, 131, 187, 104, nil], ["Y6W9FLHOVJ8TCHHNBYGF", "INE261F07032", "07.64% NABARD TFB 2031", true, 1000, 1577664000000, 10, "sell", 224, 48, 219, 210, 51, 234, 197, 66, 220, nil], ["DML3WXXE53PJOTGTEYKJ", "INE272F07011", "Blue Dart Express", true, 50, 1589414400000, 20, "buy", 61, 48, 59, 117, 236, 125, 232, 240, 106, nil], ["GYHVDLIIXVTLROOCLVYG", "INE272F07011", "Blue Dart Express", true, 20, 1650672000000, 200, "sell", 151, 188, 89, 94, 45, 54, 58, 220, 6, nil], ["ULDR4PE639LOMU4A4VCE", "INE112J07020", "IFCI", true, 200, 1515456000000, 16.55, "buy", 74, 176, 232, 177, 230, 53, 210, 110, 125, nil], ["VIHCPUEYSZUMQUVPSJ1P", "INE112J07020", "IFCI", true, 170, 1682640000000, 500, "sell", 129, 82, 120, 187, 110, 174, 71, 160, 42, nil], ["QOO5OYJLQBIRUMIGKCIQ", "INE130K08000", "SBOX", false, 200, 1493769600000, 16.55, "buy", 108, 88, 142, 17, 130, 214, 66, 207, 179, nil], ["2BOMU4R5WMEONKEI5YT6", "INE130K08000", "SBOX", false, 170, 1626480000000, 500, "sell", 97, 118, 33, 9, 151, 6, 38, 52, 40, nil], ["PZUTEFRTRX9LFW9DPHAW", "INE130K08001", "QCK", false, 200, 1437177600000, 16.55, "buy", 133, 242, 225, 166, 45, 232, 127, 64, 210, nil], ["DIQDEZH7K04QBDCJY0NV", "INE130K08001", "QCK", false, 200, 1626652800000, 500, "sell", 78, 112, 194, 9, 128, 114, 154, 68, 207, nil], ["PGR2RDEZFVC2S3YBX1JF", "INE130K08012", "GGL", true, 200, 1626739200000, 550, "buy", 157, 86, 208, 79, 180, 94, 158, 38, 191, nil], ["TFCXQ3TKQRMOHU86MXO1", "INE130K08015", "GGL", true, 200, 1563667200000, 600, "sell", 103, 56, 160, 203, 240, 171, 239, 71, 42, nil], ["DUYJ4ZV7OKJA8CV8U1MT", "INE130K08019", "APPL", false, 200, 1626912000000, 350, "buy", 215, 228, 8, 98, 119, 44, 185, 50, 154, nil], ["2GFSS7XTAHUWHFZH0NBR", "INE130K08019", "APPL", false, 180, 1690070400000, 310, "sell", 12, 204, 93, 133, 63, 206, 65, 13, 167, nil], ["4AGDXGEEJOUHI6G8ATOU", "INE261F07055", "SGB", true, 500, 1556409600000, 600, "buy", 220, 239, 134, 180, 58, 131, 160, 117, 207, nil], ["AHVDFMGBCECY1IR0QDH9", "INE261F07055", "SGB", true, 500, 1556409600000, 764, "buy", 159, 38, 58, 8, 34, 12, 202, 103, 31, nil], ["Q2DZQ1ITYAOXILWQLHDN", "INE261F07055", "SGB", true, 100, 1491436800000, 890, "buy", 189, 118, 196, 90, 161, 199, 36, 138, 50, nil], ["FQQ96BPTGAPAQPLMABNU", "INE261F07055", "SGB", true, 550, 1576022400000, 789, "sell", 52, 8, 14, 119, 231, 1, 246, 128, 155, nil], ["RKW88OVAQVWZMCD9VLJL", "INE261F07055", "SGB", true, 50, 1633996800000, 890, "sell", 139, 196, 103, 96, 207, 102, 68, 229, 5, nil]]}]}]}

HEADERS

| Key | Datatype | Required | Description | | x-accept-type | string | | application/json or application/xlsx | | x-api-key | string | | | | x-api-version | string | | | | Authorization | string | | |

RESPONSES

status: ``