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
{
"name": "tradebook_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "stock_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": [
[
"SUNMAQYIBRDSM4Y2TVW9",
"INE462A01022",
"BAYERCROP",
true,
true,
25,
1718582400000,
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,
null,
"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,
null,
"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,
null,
"delivery"
],
[
"KZUG2ZMGMH4WFE2C9RMG",
"INE03Q201024",
"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,
null,
"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,
null,
"delivery"
],
[
"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,
null,
"delivery"
],
[
"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,
null,
"delivery"
],
[
"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,
null,
"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,
null,
"delivery"
],
[
"ZVQAT2PZ1RSLYWWYZTXP",
"INE767A01016",
"ADANIENT",
true,
true,
57,
1710288000000,
1950,
"buy",
1260,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"90VSCSRGLVSHW6FYHQDE",
"INE00E101023",
"BIKAJI",
true,
false,
85,
1741824000000,
269,
"buy",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"OUYO53NES6HVEGSBXALX",
"INE364U01010",
"ADANIGREEN",
true,
false,
15,
1712275200000,
281,
"buy",
127,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"YYUFIXODHUCNJPZL0TB1",
"INE767A01016",
"ADANIENT",
true,
true,
23,
1745884800000,
2016,
"buy",
1260,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"ZR0GPABQCZJDEBAVL85E",
"INE462A01022",
"BAYERCROP",
true,
true,
29,
1746921600000,
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,
null,
"delivery"
],
[
"ZDUUQFIZKFI1LPZJIGC1",
"INE364U01010",
"ADANIGREEN",
true,
true,
47,
1749340800000,
310,
"buy",
127,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"J9SYLEPLST8YFGPUOFCG",
"INE002A01018",
"AJANTAPHARMA",
true,
true,
145,
1749945600000,
578,
"buy",
438,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"KZ4XUMQL7O4OL1T0NWLW",
"INE00E101023",
"BIKAJI",
true,
true,
140,
1750032000000,
327,
"buy",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"KZ4XUMQL7O4OL1T0NWLW",
"INE00E101023",
"BIKAJI",
true,
false,
267,
1718582400000,
329,
"buy",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"RP9WLFA5LS29NBTKARXN",
"INE462A01022",
"BAYERCROP",
true,
false,
25,
1752278400000,
4254,
"buy",
4199.55,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"G3NSSV7XHVFUJ8BTPBIR",
"INE462A01022",
"BAYERCROP",
true,
true,
29,
1752364800000,
4221,
"buy",
4199.55,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"JOQYLFGNAJXEBBANLTJ9",
"INE364U01010",
"ADANIGREEN",
true,
true,
20,
1752710400000,
290,
"buy",
127,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"RZ4TQQXBXGQZ4CIGW89W",
"INE01C001018",
"ADANIPORTS",
true,
false,
30,
1752796800000,
410,
"buy",
137,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"ABHV4GJO8FEWYZYYZXJ9",
"INE01C001018",
"ADANIPORTS",
true,
true,
20,
1721174400000,
429,
"buy",
137,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"VQLDME6IOJZR95BDEKQ9",
"INE010B01019",
"CADILAHC",
true,
false,
254,
1724025600000,
1290.98,
"buy",
120,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"XAOZHKSKJV0S5IENATLG",
"INE462A01022",
"BAYERCROP",
true,
false,
28,
1759017600000,
4289,
"buy",
4199.55,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"8BARHLFV3FZVGYTSJ012",
"INE03Q201024",
"GLS",
true,
true,
50,
1721433600000,
5000,
"sell",
5500,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"CYX9TQSTWUYK8C9Z7BCE",
"INE002A01018",
"AJANTAPHARMA",
true,
true,
645,
1713594550000,
580,
"sell",
438,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"VXFUFI5Q9HH7FEJPLV3B",
"INE010B01019",
"CADILAHC",
true,
true,
254,
1724025600000,
1301.78,
"sell",
120,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"JOVR7LN5HKWR3H7LR3LK",
"INE364U01010",
"ADANIGREEN",
true,
true,
15,
1712275200000,
250,
"sell",
127,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"K0TMWRLU5HDBSNDITGWA",
"INE01C001018",
"ADANIPORTS",
true,
true,
256,
1714262400000,
409,
"sell",
137,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"NJK6VY186PT29EQOL5ZS",
"INE767A01016",
"ADANIENT",
true,
true,
60,
1726963200000,
2300,
"sell",
1260,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"DPB5UCBWCTWCCZQZAECT",
"INE767A01016",
"ADANIENT",
true,
true,
20,
1727395200000,
2456,
"sell",
1260,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"OCFAGNA9WLZOS2GPVEWY",
"INE364U01010",
"ADANIGREEN",
true,
true,
40,
1716681600000,
365,
"sell",
127,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"USTNCKBL23ZGYFBS1FWW",
"INE01C001018",
"ADANIPORTS",
true,
true,
44,
1714521600000,
418,
"sell",
137,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"AMLDHHSPBR225CYDH1G3",
"INE01C001018",
"ADANIPORTS",
true,
true,
20,
1752796800000,
436,
"sell",
137,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"G4FILRR9JSAWETX5BFEG",
"INE01C001018",
"ADANIPORTS",
true,
true,
58,
1727568000000,
447,
"sell",
137,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"3S1E2CVMTK3I115OG5IT",
"INE002A01018",
"AJANTAPHARMA",
true,
true,
900,
1734412800000,
618,
"sell",
438,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"HJWC2DJPNJV7KBYAVLMP",
"INE002A01018",
"AJANTAPHARMA",
true,
true,
190,
1724544000000,
689,
"sell",
438,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"8LWK9OAGZ64HKNYHYX6H",
"INE462A01022",
"BAYERCROP",
true,
true,
31,
1713484800000,
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,
null,
"delivery"
],
[
"ROJM9PXLTVRGADTWZXMX",
"INE462A01022",
"BAYERCROP",
true,
true,
10,
1716076800000,
4228,
"sell",
4199.55,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"ROJM9PXLTVRGADTWZXMX",
"INE462A01022",
"BAYERCROP",
true,
true,
9,
1716076800000,
4249,
"sell",
4199.55,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"UCB2JO0JMYBFRYRHILMZ",
"INE462A01022",
"BAYERCROP",
true,
true,
25,
1752278400000,
4239,
"sell",
4199.55,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"1JQ2PDASHYXZCVH6IFTC",
"INE462A01022",
"BAYERCROP",
true,
true,
70,
1725062400000,
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,
null,
"delivery"
],
[
"AU2VBOKJGOGV82FMOSZL",
"INE462A01022",
"BAYERCROP",
true,
true,
28,
1727568000000,
4298,
"sell",
4199.55,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"IAVLRAW3OKLIHPD0DLKQ",
"INE00E101023",
"BIKAJI",
true,
true,
640,
1708819200000,
265,
"sell",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"YHEZMWYMV85DIO52CY1B",
"INE00E101023",
"BIKAJI",
true,
true,
110,
1707868800000,
257,
"sell",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"DLQMNK7WJJEH6SZOCZO6",
"INE00E101023",
"BIKAJI",
true,
true,
85,
1741824000000,
273,
"sell",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"7UBKDTDSUWJEWXI71MB5",
"INE00E101023",
"BIKAJI",
true,
true,
250,
1714262400000,
317,
"sell",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"SVYLOESSMFAWL2P1V4YN",
"INE00E101023",
"BIKAJI",
true,
true,
260,
1716076800000,
334,
"sell",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"UZB55NEDOEZEB81QTBOI",
"INE00E101023",
"BIKAJI",
true,
true,
267,
1718582400000,
321,
"sell",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"intraday"
],
[
"T2D14C472FNCQD8A9SEL",
"INE00E101023",
"BIKAJI",
true,
true,
730,
1721520000000,
339,
"sell",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"IHQR3WDABXX5LWECAVD4",
"INE00E101023",
"BIKAJI",
true,
true,
349,
1722297600000,
345,
"sell",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
],
[
"ZJZZOQLJZWYQRMSHK2E3",
"INE00E101023",
"BIKAJI",
true,
true,
321,
1725062400000,
370,
"sell",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
]
]
}
]
},
{
"name": "future_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",
"INE914J01012",
"BANKNIFTY 01 Jun 2023 FUT",
"equity",
45,
1711756800000,
363.1,
"buy",
51,
98,
75,
55,
32,
219,
11,
142,
55,
36,
null
],
[
"AUGUWEK01EI4YOIMH7RK",
"INE519I01013",
"BANKNIFTY 15 Jun 2023 FUT",
"equity",
50,
1714176000000,
363.15,
"buy",
7,
56,
55,
223,
245,
330,
106,
144,
103,
9,
null
],
[
"55MCNYCUWJO7C3ZAXWIX",
"INE512D09106",
"FUTCOM CRUDEOIL 16 OCT 2022",
"commodity",
100,
1727731200000,
415,
"buy",
107,
8,
114,
111,
90,
43,
36,
48,
119,
21,
null
],
[
"JDNI9UJFKN2PGFJZ5U9O",
"INE579I01014",
"FUTCUR USDINR 27 JAN 2023 ",
"currency",
135,
1728585600000,
90.69,
"buy",
134,
183,
209,
9,
100,
50,
202,
60,
140,
214,
null
],
[
"5NGIOMFGDRBG5Q8XTNBP",
"INE512R02109",
"NIFTY 23 JAN 2023 FUT",
"equity",
75,
1728412800000,
147.89,
"buy",
143,
44,
39,
61,
130,
216,
102,
90,
158,
37,
null
],
[
"ANH3LZISNL7R8DPFNHJ0",
"INE512R02109",
"NIFTY 23 JAN 2023 FUT",
"equity",
125,
1728979200000,
153.89,
"buy",
84,
60,
3,
129,
221,
239,
11,
42,
160,
8,
null
],
[
"S4LOWQJP4P6SFB42C460",
"INE769A01020",
"FINNIFTY 25 JAN 2023 FUT",
"equity",
35,
1729756800000,
3450.67,
"buy",
23,
98,
64,
214,
268,
161,
118,
116,
9,
21,
null
],
[
"Z0FCJBWODSL8GF3KKVPY",
"INE563D01013",
"NIFTY 15 JAN 2023 FUT",
"equity",
250,
1730620800000,
168,
"buy",
27,
73,
8,
224,
284,
306,
42,
111,
5,
17,
null
],
[
"CIKTMLOWJQLROEGJXMFF",
"INE118D01016",
"NIFTY 25 JAN 2023 FUT",
"equity",
100,
1729584000000,
175.55,
"buy",
65,
76,
54,
192,
58,
74,
149,
50,
17,
20,
null
],
[
"NKN2PS2TJZWDA9CDP1RA",
"INE002A01018",
"FINNIFTY 15 FEB 2023 FUT",
"equity",
155,
1730707200000,
194.9,
"buy",
39,
85,
72,
144,
40,
15,
16,
39,
66,
47,
null
],
[
"TWF45MCZTDWEWSJXU3EF",
"INE0C5901014",
"NIFTY 23 FEB 2023 FUT",
"equity",
175,
1730828800000,
194.9,
"buy",
50,
107,
81,
244,
314,
247,
91,
42,
72,
44,
null
],
[
"8LEGU2BN0HXVHXYBIIRZ",
"INE435D01014",
"BANKNIFTY 20 MAR 2023 FUT",
"equity",
125,
1730950400000,
1500,
"buy",
62,
53,
28,
146,
85,
446,
149,
77,
165,
22,
null
],
[
"GB8MD1GQRMB7M3KIPYBT",
"INE0C5901014",
"NIFTY 17 APR 2023 FUT",
"equity",
145,
1731260800000,
457.89,
"buy",
131,
77,
80,
49,
161,
373,
17,
130,
77,
16,
null
],
[
"GUEQKVCN1OGWGMPXO1WQ",
"INE322R01014",
"FINNIFTY 20 MAY 2023 FUT",
"equity",
130,
1731699200000,
698.03,
"buy",
85,
110,
89,
148,
121,
426,
32,
65,
22,
31,
null
],
[
"JG3ZELDXI8SYG4HLXSCG",
"INE694N01015",
"RIL 15 OCT 2023 FUT",
"equity",
50,
1726963200000,
559.39,
"buy",
111,
42,
44,
189,
145,
307,
57,
64,
43,
28,
null
],
[
"1HLEP1MBFH5JINCYGEJB",
"INE197R01010",
"RIL 01 NOV 2023 FUT",
"equity",
175,
1728000000000,
1000,
"buy",
72,
52,
33,
117,
71,
327,
39,
67,
132,
3,
null
],
[
"YFVS53SUIXO1FBXICSP8",
"INE576G01015",
"INFY 30 OCT 2023 FUT",
"equity",
100,
1728518400000,
175,
"buy",
40,
81,
12,
197,
124,
314,
159,
79,
166,
3,
null
],
[
"EGTDOZWR9NJKLHJDXYSO",
"INE197R01010",
"RIL 31 OCT 2023 FUT",
"equity",
250,
1728864000000,
186,
"buy",
150,
2,
17,
244,
29,
366,
100,
41,
15,
36,
null
],
[
"JBJYWGG6VA3VFF3J7OWZ",
"INE512R01010",
"INFY 25 OCT FUT",
"equity",
225,
1729123200000,
180,
"buy",
69,
65,
61,
243,
278,
69,
18,
109,
55,
17,
null
],
[
"52VUZC1SJ5MW4IKAJPIA",
"INE512D09106",
"FUTCOM CRUDEOIL 16 OCT 2022",
"commodity",
25,
1727817600000,
423,
"sell",
106,
107,
78,
45,
79,
100,
14,
58,
70,
85,
null
],
[
"2FPD4QFGHO2ICG3SK0KG",
"INE512D09106",
"FUTCOM CRUDEOIL 16 OCT 2022",
"commodity",
50,
1728681600000,
456,
"buy",
80,
89,
33,
66,
61,
71,
116,
120,
55,
33,
null
],
[
"XPDDDCPTROUOHFWCQH7O",
"INE512D09106",
"FUTCOM CRUDEOIL 16 OCT 2022",
"commodity",
125,
1729804800000,
449,
"sell",
4,
73,
78,
84,
113,
71,
1,
75,
118,
18,
null
],
[
"KMY2EC1UMISH0BUMIEGT",
"INE573G07017",
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
50,
1729632000000,
135,
"buy",
237,
56,
15,
18,
104,
15,
22,
76,
89,
112,
null
],
[
"KMY2EC1UMISH0BUMIEGT",
"INE573G07017",
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
80,
1729632000000,
142,
"buy",
188,
53,
11,
89,
31,
92,
119,
77,
58,
6,
null
],
[
"JAWOZXSLWYKHKUWGWS6L",
"INE573G07017",
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
70,
1729728000000,
148,
"sell",
77,
57,
74,
83,
42,
83,
110,
104,
60,
102,
null
],
[
"JAWOZXSLWYKHKUWGWS6L",
"INE573G07017",
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
30,
1729814400000,
150,
"sell",
187,
112,
77,
67,
93,
19,
84,
19,
54,
47,
null
],
[
"1AW8BG2NTK1BPSLMR0TV",
"INE573G07017",
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
140,
1730419200000,
137,
"buy",
234,
97,
29,
100,
39,
72,
49,
115,
110,
93,
null
],
[
"XOUZUWMHBDCRPKRGDD1Q",
"INE573G07017",
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
80,
1732060800000,
154,
"sell",
136,
76,
35,
49,
98,
56,
75,
2,
15,
75,
null
],
[
"XOUZUWMHBDCRPKRGDD1Q",
"INE573G07017",
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
20,
1732060800000,
153,
"buy",
211,
31,
34,
6,
18,
105,
104,
41,
67,
52,
null
],
[
"LAGBHUZEYUH1K2OMGP49",
"INE573G07017",
"FUTCOM SILVERM 21 Nov 2022 ",
"commodity",
130,
1732492800000,
156,
"sell",
110,
41,
105,
57,
47,
64,
63,
34,
46,
26,
null
],
[
"GR4XEL9XWBSYPARPT0EF",
"INE113J07012",
"FUTCOM GOLD 29 OCT 2023",
"commodity",
55,
1726012800000,
124.56,
"sell",
103,
48,
70,
111,
21,
40,
84,
69,
15,
16,
null
],
[
"M5ZXEWJZFFR9DR1ECYIE",
"INE113J07012",
"FUTCOM GOLD 29 OCT 2023",
"commodity",
55,
1726272000000,
121,
"buy",
125,
52,
36,
22,
92,
17,
67,
79,
46,
109,
null
],
[
"FUWODRFMJFABB1VZGX5D",
"INE113J07012",
"FUTCOM GOLD 29 NOV 2023",
"commodity",
85,
1728604800000,
135,
"buy",
212,
24,
78,
32,
52,
54,
7,
83,
8,
119,
null
],
[
"XVFHRXHI6QWNJUUKBJ0J",
"INE113J07012",
"FUTCOM GOLD 29 NOV 2023",
"commodity",
35,
1729036800000,
138,
"buy",
25,
89,
59,
114,
63,
56,
108,
2,
64,
35,
null
],
[
"OHNNDTMWFFACP6JQ82GM",
"INE113J07012",
"FUTCOM GOLD 29 NOV 2023",
"commodity",
90,
1731369600000,
142,
"sell",
108,
57,
19,
77,
25,
94,
115,
78,
71,
117,
null
],
[
"RRCAFBZWEKTPVLYJCRB4",
"INE113J07012",
"FUTCOM GOLD 29 NOV 2023",
"commodity",
10,
1731542400000,
149,
"sell",
130,
3,
116,
15,
41,
119,
118,
26,
76,
77,
null
],
[
"JDNI9UJFKN2PGFJZ5U9O",
"INE579I01014",
"FUTCUR USDINR 27 JAN 2023 ",
"currency",
145,
1728585600000,
87.45,
"buy",
212,
202,
223,
125,
116,
48,
71,
75,
100,
24,
null
],
[
"4TXSMROXNCO4YKN01YBF",
"INE579I01014",
"FUTCUR USDINR 27 JAN 2023 ",
"currency",
165,
1728240000000,
94.78,
"sell",
177,
48,
234,
38,
176,
182,
159,
80,
200,
136,
null
],
[
"D1VHUJNJ1WGO9JVCK2AZ",
"INE579I01014",
"FUTCUR USDINR 27 JAN 2023 ",
"currency",
100,
1729104000000,
45.98,
"sell",
97,
219,
153,
19,
118,
231,
228,
31,
185,
186,
null
],
[
"D1VHUJNJ1WGO9JVCK2AZ",
"INE579I01014",
"FUTCUR USDINR 27 JAN 2023 ",
"currency",
15,
1729756800000,
78.3,
"sell",
94,
93,
127,
162,
79,
232,
149,
211,
83,
6,
null
],
[
"UVSIUTXLTZHDRHICW9C0",
"INE645F01015",
"FUTCUR EURINR 13 MAY 2023",
"currency",
50,
1731174400000,
245.78,
"sell",
46,
228,
186,
237,
75,
6,
46,
97,
203,
34,
null
],
[
"V7L7EV2WB1F06YIJSHQS",
"INE645F01015",
"FUTCUR EURINR 13 MAY 2023",
"currency",
50,
1731174400000,
260.7,
"buy",
178,
162,
152,
207,
202,
185,
95,
232,
121,
209,
null
],
[
"8GTJ7JADP09KTKDPFWQJ",
"INE645F01015",
"FUTCUR EURINR 13 MAY 2023",
"currency",
145,
1731347200000,
278,
"sell",
20,
164,
152,
121,
98,
148,
35,
194,
110,
34,
null
],
[
"XNAQJZ3OTJFDZ2FEGVVQ",
"INE645F01015",
"FUTCUR EURINR 13 MAY 2023",
"currency",
145,
1711756800000,
289,
"buy",
25,
85,
159,
60,
145,
36,
46,
146,
237,
157,
null
],
[
"NU9Y7DKWYXX1B8HUGX0G",
"INE714H01019",
"FUTCUR GBPINR 27 OCT 2023",
"currency",
75,
1725667200000,
4500,
"buy",
21,
179,
65,
29,
21,
92,
124,
178,
153,
12,
null
],
[
"NU9Y7DKWYXX1B8HUGX0G",
"INE714H01019",
"FUTCUR GBPINR 27 OCT 2023",
"currency",
75,
1725667200000,
4509,
"sell",
15,
93,
151,
111,
104,
103,
55,
238,
153,
97,
null
],
[
"7BN92HT8TUYNDOW29YPQ",
"INE714H01019",
"FUTCUR GBPINR 27 OCT 2023",
"currency",
113,
1726185600000,
4492.367,
"buy",
57,
230,
240,
67,
116,
76,
6,
3,
169,
150,
null
],
[
"QRJDSFMYL79ULAWADZ4C",
"INE714H01019",
"FUTCUR GBPINR 27 OCT 2023",
"currency",
60,
1726876800000,
4499.876,
"sell",
145,
184,
130,
50,
35,
17,
90,
146,
149,
199,
null
],
[
"FZJQJNQWOJE78OSAKILB",
"INE714H01019",
"FUTCUR GBPINR 27 OCT 2023",
"currency",
43,
1728691200000,
5008.596,
"sell",
47,
22,
47,
31,
24,
32,
128,
195,
47,
87,
null
],
[
"BZAB3NIFLVXCEWLNXF0C",
"INE632P01025",
"FUTCUR JPYINR 24 AUG 2023",
"currency",
120,
1731184000000,
345.89,
"sell",
7,
203,
116,
18,
12,
64,
159,
151,
211,
148,
null
],
[
"EUCWBOWYUQF5LLS2MG9P",
"INE632P01025",
"FUTCUR JPYINR 24 AUG 2023",
"currency",
80,
1731788800000,
325.67,
"buy",
44,
87,
14,
179,
169,
178,
97,
26,
72,
170,
null
],
[
"EUCWBOWYUQF5LLS2MG9P",
"INE632P01025",
"FUTCUR JPYINR 24 AUG 2023",
"currency",
30,
1731788800000,
319.78,
"buy",
89,
205,
71,
145,
106,
166,
209,
67,
6,
124,
null
],
[
"MUYD0KEIED2TJLMOBKEM",
"INE632P01025",
"FUTCUR JPYINR 24 AUG 2023",
"currency",
40,
1731961600000,
329.587,
"sell",
59,
42,
140,
65,
52,
47,
80,
128,
39,
105,
null
],
[
"DROFW5LAACDWOCFKDQET",
"INE914J01012",
"BANKNIFTY 01 Jun 2023 FUT",
"equity",
45,
1730841600000,
450.09,
"sell",
111,
55,
14,
84,
291,
436,
146,
24,
168,
39,
null
],
[
"Y9V66LWUBLF8P2I8FDAR",
"INE519I01013",
"BANKNIFTY 15 Jun 2023 FUT",
"equity",
25,
1731100800000,
469.22,
"sell",
78,
91,
80,
41,
123,
291,
83,
151,
115,
11,
null
],
[
"2C7BGL8DLAEX6DMFGRTF",
"INE519I01013",
"BANKNIFTY 15 Jun 2023 FUT",
"equity",
25,
1730403200000,
425.3,
"sell",
22,
107,
62,
188,
249,
158,
117,
82,
21,
18,
null
],
[
"CJLNLY40ORWJXUKGVC8E",
"INE894N01016",
"NIFTY 23 JAN 2023 FUT",
"equity",
25,
1728153600000,
135.67,
"sell",
69,
101,
25,
74,
90,
300,
128,
21,
56,
3,
null
],
[
"GFHNW8Q8GH4F408UZQ0M",
"INE894N01017",
"NIFTY 23 JAN 2023 FUT",
"equity",
45,
1729104000000,
129.89,
"sell",
132,
88,
37,
24,
279,
212,
148,
43,
116,
26,
null
],
[
"LL4ESNCPAINCWUTVOYKX",
"INE894N01018",
"NIFTY 23 JAN 2023 FUT",
"equity",
50,
1730620800000,
147.89,
"sell",
53,
67,
8,
87,
63,
171,
86,
89,
83,
9,
null
],
[
"WI62KWVR0MYO0WXLDQ4J",
"INE694C01015",
"NIFTY 23 JAN 2023 FUT",
"equity",
80,
1730793600000,
150,
"sell",
10,
50,
68,
204,
60,
36,
24,
6,
43,
16,
null
],
[
"IJPDDNJO9BNNH0TB9NPJ",
"INE769A01020",
"FINNIFTY 25 JAN 2023 FUT",
"equity",
35,
1731139200000,
2568.98,
"sell",
132,
85,
15,
82,
101,
10,
152,
75,
46,
11,
null
],
[
"VLNYY0FTJTUGELL1TK8D",
"INE563D01013",
"NIFTY 15 JAN 2023 FUT",
"equity",
25,
1729411200000,
146,
"sell",
105,
53,
3,
114,
193,
397,
8,
2,
58,
43,
null
],
[
"VLNYY0FTJTUGELL1TK8D",
"INE563D01013",
"NIFTY 15 JAN 2023 FUT",
"equity",
75,
1729670400000,
158,
"sell",
54,
105,
28,
102,
11,
64,
41,
148,
143,
3,
null
],
[
"VY3TYTSPMWLYJQAEMGTZ",
"INE563D01013",
"NIFTY 15 JAN 2023 FUT",
"equity",
150,
1730707200000,
255,
"sell",
138,
32,
42,
214,
44,
13,
146,
43,
52,
35,
null
],
[
"YQT2WZWDNZPPCRDSQFR9",
"INE118D01016",
"NIFTY 25 JAN 2023 FUT",
"equity",
100,
1730880000000,
126.78,
"sell",
18,
23,
81,
239,
107,
183,
158,
64,
137,
50,
null
],
[
"9ZLDZGRMJBSSAIJTBTHN",
"INE002A01018",
"FINNIFTY 15 FEB 2023 FUT",
"equity",
155,
1731315200000,
174.55,
"sell",
130,
33,
69,
197,
298,
266,
24,
142,
9,
19,
null
],
[
"RHSYRUIXEC7M4HJBK46H",
"INE0C5901014",
"NIFTY 23 FEB 2023 FUT",
"equity",
55,
1731488000000,
174.8,
"sell",
111,
86,
26,
17,
303,
388,
149,
16,
53,
20,
null
],
[
"I3RI1TXUYSFLFU4N8IWZ",
"INE0C5901014",
"NIFTY 23 FEB 2023 FUT",
"equity",
120,
1732243200000,
210.89,
"sell",
115,
42,
78,
151,
292,
262,
98,
151,
37,
30,
null
],
[
"BYSC5G1EPZIWIJJ6BAUB",
"INE435D01014",
"BANKNIFTY 20 MAR 2023 FUT",
"equity",
125,
1732329600000,
615.89,
"sell",
101,
83,
15,
219,
125,
349,
140,
154,
129,
6,
null
],
[
"MWLF0LTSOJNEXKVXSGWN",
"INE0C5901014",
"NIFTY 17 APR 2023 FUT",
"equity",
135,
1732761600000,
489.67,
"sell",
132,
94,
74,
184,
190,
173,
30,
72,
61,
48,
null
],
[
"B67GMDMHCZAHJBXKDGL0",
"INE322R01014",
"FINNIFTY 20 MAY 2023 FUT",
"equity",
120,
1732761600000,
745.32,
"sell",
150,
13,
35,
133,
133,
362,
128,
119,
83,
39,
null
],
[
"DEN7PSRIFMQ0VQXZF8O8",
"INE694N01015",
"RIL 15 OCT 2023 FUT",
"equity",
50,
1732761600000,
615.35,
"sell",
99,
59,
84,
104,
322,
159,
92,
122,
136,
15,
null
],
[
"GAVL50RNZDGGQSMMLKOF",
"INE576G01015",
"INFY 30 OCT 2023 FUT",
"equity",
100,
1732761600000,
145,
"sell",
50,
96,
11,
84,
204,
220,
20,
125,
146,
23,
null
],
[
"BWQRBJTC2V55AFBIZPYW",
"INE197R01010",
"RIL 31 OCT 2023 FUT",
"equity",
250,
1732761600000,
199,
"sell",
89,
57,
49,
235,
303,
147,
23,
114,
11,
24,
null
]
]
}
]
},
{
"name": "option_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",
"INE619I01012",
"BANKNIFTY 01 Jun 2023 CE 44100",
"equity",
25,
1711756800000,
363.1,
"buy",
385,
201,
2235,
795,
1757,
202,
195,
2060,
2112,
1622,
null
],
[
"Y6W9FLHOVJ8TCHHNBYGF",
"INE545C01013",
"BANKNIFTY 01 Jun 2023 CE 44200",
"equity",
75,
1714176000000,
363.15,
"buy",
2479,
304,
1657,
2282,
1170,
172,
1307,
1660,
1130,
1106,
null
],
[
"DML3WXXE53PJOTGTEYKJ",
"INE512D09106",
"OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
"commodity",
100,
1727731200000,
415,
"buy",
107,
8,
114,
111,
90,
43,
36,
48,
119,
21,
null
],
[
"GYHVDLIIXVTLROOCLVYG",
"INE579I01014",
"OPTCUR USDINR 27 JAN 2023 83 PE",
"currency",
135,
1728585600000,
90.69,
"buy",
134,
183,
209,
9,
100,
50,
202,
60,
140,
214,
null
],
[
"ULDR4PE639LOMU4A4VCE",
"INE512R02109",
"NIFTY 23 JAN 2023 CE 15000",
"equity",
75,
1728412800000,
1570,
"buy",
2122,
1793,
1820,
1893,
560,
1651,
875,
2161,
32,
1916,
null
],
[
"VIHCPUEYSZUMQUVPSJ1P",
"INE512R02109",
"NIFTY 23 JAN 2023 CE 15000",
"equity",
125,
1728979200000,
1490,
"buy",
114,
1074,
1522,
44,
1158,
535,
2252,
1115,
1171,
2449,
null
],
[
"QOO5OYJLQBIRUMIGKCIQ",
"INE769A01020",
"FINNIFTY 25 JAN 2023 CE 12500",
"equity",
50,
1729756800000,
3450.67,
"buy",
831,
1827,
1117,
1814,
1230,
499,
1882,
2344,
457,
1850,
null
],
[
"2BOMU4R5WMEONKEI5YT6",
"INE563D01013",
"NIFTY 23 JAN 2023 CE 15600",
"equity",
250,
1730620800000,
168,
"buy",
1280,
657,
1291,
1139,
636,
2397,
795,
1161,
2236,
1620,
null
],
[
"PZUTEFRTRX9LFW9DPHAW",
"INE118D01016",
"NIFTY 23 JAN 2023 CE 15650",
"equity",
100,
1729584000000,
175.55,
"buy",
125,
882,
2432,
2077,
2189,
2472,
2156,
1856,
1068,
2285,
null
],
[
"DIQDEZH7K04QBDCJY0NV",
"INE002A01018",
"FINNIFTY 15 FEB 2023 CE 13400",
"equity",
50,
1730707200000,
194.9,
"buy",
1645,
1807,
1262,
2482,
829,
782,
540,
1000,
354,
2491,
null
],
[
"PGR2RDEZFVC2S3YBX1JF",
"INE0C5901014",
"NIFTY 23 FEB 2023 PE 17100",
"equity",
105,
1730828800000,
194.9,
"buy",
1760,
1640,
2143,
905,
1374,
1714,
842,
1776,
847,
299,
null
],
[
"TFCXQ3TKQRMOHU86MXO1",
"INE082B0101",
"BANKNIFTY 20 MAR 2023 PE 18900",
"equity",
155,
1730950400000,
1500,
"buy",
104,
552,
1064,
2411,
1835,
2056,
2421,
2289,
651,
2315,
null
],
[
"DUYJ4ZV7OKJA8CV8U1MT",
"INE0C5901014",
"NIFTY 17 APR 2023 PE 17800",
"equity",
55,
1731260800000,
457.89,
"buy",
1766,
2139,
1170,
2017,
723,
2101,
1756,
2357,
1517,
2394,
null
],
[
"2GFSS7XTAHUWHFZH0NBR",
"INE322R01014",
"FINNIFTY 25 MAY 2023 CE 14900",
"equity",
130,
1731699200000,
698.03,
"buy",
682,
2191,
400,
1922,
813,
188,
1323,
188,
880,
1267,
null
],
[
"4AGDXGEEJOUHI6G8ATOU",
"INE694N01015",
"RELIANCE OCT 1940 CE",
"equity",
50,
1726963200000,
559.39,
"buy",
1244,
2104,
102,
1018,
319,
1497,
1669,
2059,
1901,
485,
null
],
[
"AHVDFMGBCECY1IR0QDH9",
"INE197R01010",
"RELIANCE OCT 1960 CE",
"equity",
175,
1728000000000,
1000,
"buy",
2181,
2407,
104,
398,
1577,
1341,
55,
1215,
1616,
879,
null
],
[
"Q2DZQ1ITYAOXILWQLHDN",
"INE576G01015",
"INFOSYS OCT 2550 CE",
"equity",
150,
1728518400000,
175,
"buy",
444,
1610,
769,
2289,
1456,
437,
1601,
620,
810,
1319,
null
],
[
"FQQ96BPTGAPAQPLMABNU",
"INE197R01010",
"RELIANCE OCT 1920 CE",
"equity",
250,
1728864000000,
186,
"buy",
1158,
1954,
1513,
2091,
1622,
1175,
383,
2049,
191,
1624,
null
],
[
"RKW88OVAQVWZMCD9VLJL",
"INE512R01010",
"INFOSYS OCT 2590 CE",
"equity",
225,
1729123200000,
180,
"buy",
874,
1430,
2384,
1648,
1398,
596,
367,
396,
1897,
1511,
null
],
[
"TTGYOR1EOA3SUTMNCJ58",
"INE512D09106",
"OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
"commodity",
25,
1727817600000,
423,
"sell",
106,
107,
78,
45,
79,
100,
14,
58,
70,
85,
null
],
[
"MYOFOBCC5W0PCWHVBFPU",
"INE512D09106",
"OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
"commodity",
50,
1728681600000,
456,
"buy",
80,
89,
33,
66,
61,
71,
116,
120,
55,
33,
null
],
[
"VIX3TEN3GZKPVY2WZCEX",
"INE512D09106",
"OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
"commodity",
125,
1729804800000,
449,
"sell",
4,
73,
78,
84,
113,
71,
1,
75,
118,
18,
null
],
[
"Q5CUBQ2P6B7VKNHCKWD6",
"INE573G07017",
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
50,
1729632000000,
135,
"buy",
237,
56,
15,
18,
104,
15,
22,
76,
89,
112,
null
],
[
"Q5CUBQ2P6B7VKNHCKWD6",
"INE573G07017",
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
80,
1729632000000,
142,
"buy",
188,
53,
11,
89,
31,
92,
119,
77,
58,
6,
null
],
[
"DTXGC9I0ZVOI2FFSHIOL",
"INE573G07017",
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
70,
1729728000000,
148,
"sell",
77,
57,
74,
83,
42,
83,
110,
104,
60,
102,
null
],
[
"DTXGC9I0ZVOI2FFSHIOL",
"INE573G07017",
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
30,
1729814400000,
150,
"sell",
187,
112,
77,
67,
93,
19,
84,
19,
54,
47,
null
],
[
"IU0HYP6ZN9EOERPBEWYA",
"INE573G07017",
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
140,
1730419200000,
137,
"buy",
234,
97,
29,
100,
39,
72,
49,
115,
110,
93,
null
],
[
"TAODZZPWWR9R5CO1QX0R",
"INE573G07017",
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
80,
1732060800000,
154,
"sell",
136,
76,
35,
49,
98,
56,
75,
2,
15,
75,
null
],
[
"TAODZZPWWR9R5CO1QX0R",
"INE573G07017",
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
20,
1732060800000,
153,
"buy",
211,
31,
34,
6,
18,
105,
104,
41,
67,
52,
null
],
[
"HVG5B4A45J9CL4CZ35TF",
"INE573G07017",
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
130,
1732492800000,
156,
"sell",
110,
41,
105,
57,
47,
64,
63,
34,
46,
26,
null
],
[
"CJ7UKXJFK6WDVAUWGXGW",
"INE113J07012",
"OPTFUT GOLD 29 OCT 2023 60000 PE",
"commodity",
55,
1726012800000,
124.56,
"sell",
103,
48,
70,
111,
21,
40,
84,
69,
15,
16,
null
],
[
"EAU3BEIXICIMKLVWWU56",
"INE113J07012",
"OPTFUT GOLD 29 OCT 2023 60000 PE",
"commodity",
55,
1726272000000,
121,
"buy",
125,
52,
36,
22,
92,
17,
67,
79,
46,
109,
null
],
[
"OJDZI0SB29R3RMHWOG8P",
"INE113J07012",
"OPTFUT GOLD 29 NOV2023 61000 PE",
"commodity",
85,
1728604800000,
135,
"buy",
212,
24,
78,
32,
52,
54,
7,
83,
8,
119,
null
],
[
"DOHDNKFFITQRMFUYKQLE",
"INE113J07012",
"OPTFUT GOLD 29 NOV2023 61000 PE",
"commodity",
35,
1729036800000,
138,
"buy",
25,
89,
59,
114,
63,
56,
108,
2,
64,
35,
null
],
[
"CVWO1J0HIG9QEY5UVUDQ",
"INE113J07012",
"OPTFUT GOLD 29 NOV2023 61000 PE",
"commodity",
90,
1731369600000,
142,
"sell",
108,
57,
19,
77,
25,
94,
115,
78,
71,
117,
null
],
[
"R2K5E791EH5VAQZVOETW",
"INE113J07012",
"OPTFUT GOLD 29 NOV2023 61000 PE",
"commodity",
10,
1731542400000,
149,
"sell",
130,
3,
116,
15,
41,
119,
118,
26,
76,
77,
null
],
[
"GYHVDLIIXVTLROOCLVYG",
"INE579I01014",
"OPTCUR USDINR 27 JAN 2023 83 PE",
"currency",
145,
1728585600000,
87.45,
"buy",
212,
202,
223,
125,
116,
48,
71,
75,
100,
24,
null
],
[
"8VMAOKSBFKXAX1Z75UK5",
"INE579I01014",
"OPTCUR USDINR 27 JAN 2023 83 PE",
"currency",
165,
1728240000000,
94.78,
"sell",
177,
48,
234,
38,
176,
182,
159,
80,
200,
136,
null
],
[
"ZXORPEEJE7TVFBPXQ8LI",
"INE579I01014",
"OPTCUR USDINR 27 JAN 2023 83 PE",
"currency",
100,
1729104000000,
45.98,
"sell",
97,
219,
153,
19,
118,
231,
228,
31,
185,
186,
null
],
[
"ZXORPEEJE7TVFBPXQ8LI",
"INE579I01014",
"OPTCUR USDINR 27 JAN 2023 83 PE",
"currency",
15,
1729756800000,
78.3,
"sell",
94,
93,
127,
162,
79,
232,
149,
211,
83,
6,
null
],
[
"6MDVYEYUKHJXIQSGEOPU",
"INE645F01015",
"OPTCUR EURINR 13 MAY 2023 94 CE",
"currency",
50,
1731174400000,
245.78,
"sell",
46,
228,
186,
237,
75,
6,
46,
97,
203,
34,
null
],
[
"CPYBETZOWLDVTAYF3PRA",
"INE645F01015",
"OPTCUR EURINR 13 MAY 2023 94 CE",
"currency",
50,
1731174400000,
260.7,
"buy",
178,
162,
152,
207,
202,
185,
95,
232,
121,
209,
null
],
[
"MEHVXLLGPB5SODCHL5PT",
"INE645F01015",
"OPTCUR EURINR 13 MAY 2023 94 CE",
"currency",
145,
1731347200000,
278,
"sell",
20,
164,
152,
121,
98,
148,
35,
194,
110,
34,
null
],
[
"UQCTRKWJRKXVR7LSIBCN",
"INE645F01015",
"OPTCUR EURINR 13 MAY 2023 94 CE",
"currency",
145,
1711756800000,
289,
"buy",
25,
85,
159,
60,
145,
36,
46,
146,
237,
157,
null
],
[
"PIN8G2M1QKXY1FQZPRIF",
"INE714H01019",
"OPTCUR GBPINR 27 OCT 2023 115 PE",
"currency",
75,
1725667200000,
4500,
"buy",
21,
179,
65,
29,
21,
92,
124,
178,
153,
12,
null
],
[
"PIN8G2M1QKXY1FQZPRIF",
"INE714H01019",
"OPTCUR GBPINR 27 OCT 2023 115 PE",
"currency",
75,
1725667200000,
4509,
"sell",
15,
93,
151,
111,
104,
103,
55,
238,
153,
97,
null
],
[
"69WJ3BI70HPVKNLEK5TR",
"INE714H01019",
"OPTCUR GBPINR 27 OCT 2023 115 PE",
"currency",
113,
1726185600000,
4492.367,
"buy",
57,
230,
240,
67,
116,
76,
6,
3,
169,
150,
null
],
[
"P534DDQESQ6XNTI4NURV",
"INE714H01019",
"OPTCUR GBPINR 27 OCT 2023 115 PE",
"currency",
60,
1726876800000,
4499.876,
"sell",
145,
184,
130,
50,
35,
17,
90,
146,
149,
199,
null
],
[
"OXGR4W3D3MYYBURZOEJ5",
"INE714H01019",
"OPTCUR GBPINR 27 OCT 2023 115 PE",
"currency",
43,
1728691200000,
5008.596,
"sell",
47,
22,
47,
31,
24,
32,
128,
195,
47,
87,
null
],
[
"T6B8078DHAC9MGWPKR6B",
"INE632P01025",
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
120,
1731184000000,
345.89,
"sell",
7,
203,
116,
18,
12,
64,
159,
151,
211,
148,
null
],
[
"OFAILEZLEAPD9SU5ZOMT",
"INE632P01025",
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
80,
1731788800000,
325.67,
"buy",
44,
87,
14,
179,
169,
178,
97,
26,
72,
170,
null
],
[
"OFAILEZLHKPD8SU7ZOMT",
"INE632P01025",
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
30,
1731788800000,
319.78,
"buy",
89,
205,
71,
145,
106,
166,
209,
67,
6,
124,
null
],
[
"FDIT8EQR2XJFQJU2JLIG",
"INE632P01025",
"OPTCUR JPYINR 24 AUG 2023 45.6 CE",
"currency",
40,
1731961600000,
329.587,
"sell",
59,
42,
140,
65,
52,
47,
80,
128,
39,
105,
null
],
[
"KLPAV9GOUCMPFH1WNKLV",
"INE619I01012",
"BANKNIFTY 01 Jun 2023 CE 44100",
"equity",
25,
1730841600000,
450.09,
"sell",
1657,
1302,
325,
2118,
2050,
604,
2148,
626,
1489,
2090,
null
],
[
"0WNSDPGK4LTXO38HPTLU",
"INE545C01013",
"BANKNIFTY 01 Jun 2023 CE 44200",
"equity",
25,
1731100800000,
469.22,
"sell",
1711,
1948,
2048,
700,
2360,
120,
2415,
333,
2231,
736,
null
],
[
"QS2KFCND5DJXRNDLLVHD",
"INE545C01013",
"BANKNIFTY 01 Jun 2023 CE 44200",
"equity",
50,
1730403200000,
425.3,
"sell",
320,
375,
82,
1593,
1653,
620,
1637,
712,
542,
130,
null
],
[
"0B3PIU4WMIPKUQEG34BO",
"INE512R02109",
"NIFTY 23 JAN 2023 CE 15000",
"equity",
25,
1728153600000,
1460,
"sell",
499,
2262,
2210,
507,
256,
2293,
1125,
2345,
1852,
90,
null
],
[
"S7XOLPIQ2V4R5L89ZEE1",
"INE512R02109",
"NIFTY 23 JAN 2023 CE 15000",
"equity",
45,
1729104000000,
1508,
"sell",
1784,
825,
2087,
498,
666,
616,
1994,
763,
157,
2380,
null
],
[
"HSZA8B3XH3JC2POXMSXJ",
"INE512R02109",
"NIFTY 23 JAN 2023 CE 15000",
"equity",
50,
1730620800000,
1585,
"sell",
335,
1434,
254,
1609,
999,
1979,
2229,
127,
389,
1244,
null
],
[
"ILKEYGKTOHFQI5UXMBOO",
"INE512R02109",
"NIFTY 23 JAN 2023 CE 15000",
"equity",
80,
1730793600000,
1635,
"sell",
208,
535,
279,
401,
2010,
248,
494,
746,
2399,
1196,
null
],
[
"A9HFP9X49AROF21K9KRY",
"INE769A01020",
"FINNIFTY 25 JAN 2023 CE 12500",
"equity",
50,
1731139200000,
2568.98,
"sell",
319,
59,
25,
2409,
2339,
423,
132,
250,
2137,
2442,
null
],
[
"GHQTIWHDAFE90NOAU6ZY",
"INE563D01013",
"NIFTY 23 JAN 2023 CE 15600",
"equity",
25,
1729411200000,
146,
"sell",
1525,
678,
749,
379,
277,
1791,
2288,
545,
1042,
327,
null
],
[
"GHQTIWHDAFE90NOAU6ZY",
"INE563D01013",
"NIFTY 23 JAN 2023 CE 15600",
"equity",
75,
1729670400000,
158,
"sell",
1761,
2349,
1082,
2181,
1054,
1396,
856,
1220,
1740,
1791,
null
],
[
"IXMBK9LENH6CSGULION2",
"INE563D01013",
"NIFTY 23 JAN 2023 CE 15600",
"equity",
150,
1730707200000,
255,
"sell",
2369,
875,
2202,
2488,
1574,
404,
532,
779,
2266,
1396,
null
],
[
"BEZ31FONIR1EQQI68F0Y",
"INE118D01016",
"NIFTY 23 JAN 2023 CE 15650",
"equity",
100,
1730880000000,
126.78,
"sell",
288,
7,
2495,
1391,
1859,
28,
1298,
355,
1234,
1955,
null
],
[
"HMC8SXGWGNGWUTFBYRHX",
"INE002A01018",
"FINNIFTY 15 FEB 2023 CE 13400",
"equity",
50,
1731315200000,
174.55,
"sell",
879,
2335,
1905,
1798,
456,
1765,
358,
1368,
1124,
1040,
null
],
[
"KQDQ54GEHLHTIUSPGAV6",
"INE0C5901014",
"NIFTY 23 FEB 2023 PE 17100",
"equity",
55,
1731488000000,
174.8,
"sell",
181,
764,
1349,
1121,
2195,
2042,
1398,
1674,
164,
2244,
null
],
[
"SLB3JNRIBXSZWLRWP8ZZ",
"INE0C5901014",
"NIFTY 23 FEB 2023 PE 17100",
"equity",
50,
1732243200000,
210.89,
"sell",
77,
713,
1563,
1666,
1745,
20,
528,
2500,
1068,
2008,
null
],
[
"LMQI22RLLZHQ5CWBGFYP",
"INE082B0101",
"BANKNIFTY 20 MAR 2023 PE 18900",
"equity",
155,
1732329600000,
615.89,
"sell",
1842,
519,
2150,
997,
536,
1241,
2437,
765,
2481,
2126,
null
],
[
"71ZRU28BNR9F5FMOZS8V",
"INE0C5901014",
"NIFTY 17 APR 2023 PE 17800",
"equity",
55,
1732761600000,
489.67,
"sell",
1519,
340,
2379,
190,
164,
2420,
662,
226,
1681,
722,
null
],
[
"PHGLBJWZZLIDKTTVLNQE",
"INE322R01014",
"FINNIFTY 25 MAY 2023 CE 14900",
"equity",
120,
1732761600000,
745.32,
"sell",
820,
1114,
2137,
646,
2399,
2314,
160,
1817,
2092,
283,
null
],
[
"SEZD4CXXIXJ79ZS0GUQ2",
"INE694N01015",
"RELIANCE OCT 1940 CE",
"equity",
50,
1732761600000,
615.35,
"sell",
1797,
249,
1653,
2028,
897,
542,
1158,
2067,
964,
1393,
null
],
[
"UESSXHU0UHWCRJ1Z7LJR",
"INE576G01015",
"INFOSYS OCT 2550 CE",
"equity",
150,
1732761600000,
145,
"sell",
1204,
722,
1103,
2190,
1165,
1168,
597,
1485,
1127,
1175,
null
],
[
"TVSWJDGSX7VFVHA2AUXG",
"INE197R01010",
"RELIANCE OCT 1920 CE",
"equity",
250,
1732761600000,
199,
"sell",
267,
1371,
436,
2246,
1747,
765,
1306,
1279,
1236,
1962,
null
]
]
}
]
},
{
"name": "mutual_fund_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",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
true,
true,
32.31,
1525824000000,
50,
"buy",
400,
10,
null
],
[
"BVNCH72LKDQY9RRINTGH",
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
37.216,
1589414400000,
10,
"buy",
0,
98,
null
],
[
"BNG57MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
19.574,
1515456000000,
120,
"buy",
5,
78,
null
],
[
"GJK45MYGKDQY9RRINTGH",
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
true,
true,
36.023,
1493769600000,
30,
"buy",
10,
68,
null
],
[
"GHL909MYGKDQY9RRINTGH",
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
true,
true,
35.014,
1437177600000,
15,
"buy",
17,
67,
null
],
[
"BHMGP79GKDQY9RRINTGH",
"INF200K01189",
"SBI Gold Fund",
"other",
true,
true,
35.706,
1626739200000,
60,
"buy",
65,
30,
null
],
[
"BLKMN98HJNMDQY9RRINTGH",
"INF200K01189",
"SBI Gold Fund",
"other",
true,
true,
36.062,
1563667200000,
60,
"buy",
120,
50,
null
],
[
"MJK88MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
true,
true,
35.039,
1626912000000,
400.784,
"buy",
200,
20,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
25.68,
1556409600000,
459,
"buy",
220,
0.25,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
true,
true,
105.56,
1491436800000,
123,
"buy",
20,
25,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
true,
true,
550.34,
1491436800000,
124.5,
"buy",
20,
49,
null
],
[
"DFGR59NOHJDQ751TINTJK",
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
true,
true,
129,
1733760000000,
150,
"buy",
100,
32,
null
],
[
"DFGR59NOHJDQ751TINTJK",
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
true,
true,
100,
1733760000000,
250,
"buy",
100,
56,
null
],
[
"GHNR59NOHJDQ901TINTLK",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
156.78,
1481500800000,
150,
"buy",
160,
22,
null
],
[
"KNT59NOGKDQY897TINFTR",
"INF760K01FR2",
"Canara Robeco Bluechip Equity Growth Direct Plan",
"equity",
true,
true,
155,
1576022400000,
23.78,
"buy",
25,
2,
null
],
[
"HJM98MYGKDQY9RRINGFB",
"INF200K01189",
"SBI Gold Fund",
"other",
true,
true,
35,
1374624000000,
200,
"buy",
180,
589,
null
],
[
"JMCU8MYGKDQY9RRINTGH",
"INF200K01189",
"SBI Gold Fund",
"other",
true,
true,
35,
1585008000000,
230,
"buy",
180,
37,
null
],
[
"GHN78NOGKDQY9YTINFGHY",
"INF200K01190",
"KOTAK SEC FUND",
"equity",
true,
true,
50,
1633564800000,
980,
"buy",
800,
145,
null
],
[
"XCT59NOGKDQY9YTINFGRN",
"INF200K01190",
"KOTAK SEC FUND",
"equity",
true,
true,
40,
1639872000000,
1000,
"buy",
800,
198,
null
],
[
"KGFCH72LKDQY9RRINTGH",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
true,
true,
32.31,
1710921600000,
900,
"sell",
1000,
89.658,
null
],
[
"KHF78MYGKDQY9RRINTGH",
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
17.823,
1733625600000,
5,
"sell",
0,
20,
null
],
[
"GHN78MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
36.711,
1714358400000,
160,
"sell",
5,
33.24,
null
],
[
"BHM88MYGKDQY9RRINTGH",
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
true,
true,
36.023,
1729036800000,
60,
"sell",
10,
100,
null
],
[
"BHM88MTYH6QY9RRINTGH",
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
true,
true,
19.88,
1729209600000,
60,
"sell",
17,
10,
null
],
[
"CVH78MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
true,
true,
32.531,
1721788800000,
200,
"sell",
200,
90,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
25.68,
1731542400000,
500,
"sell",
220,
50,
null
],
[
"JHF78MYGKDQY9RRINTGH",
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
true,
true,
355.9,
1727731200000,
212.7,
"sell",
20,
28,
null
],
[
"JTR59NOGKDQY9YTINTGH",
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
true,
true,
250,
1728585600000,
209,
"sell",
20,
75,
null
],
[
"HNT59NOGKDQY897TINF4R",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
125,
1728844800000,
400,
"sell",
160,
89.658,
null
],
[
"HYT59NOGKDQY9YTINFGRN",
"INF760K01FR2",
"Canara Robeco Bluechip Equity Growth Direct Plan",
"equity",
true,
true,
155,
1729891200000,
56.9,
"sell",
45,
2,
null
],
[
"RTV678MYGKDQY9RRINTGH",
"INF200K01189",
"SBI Gold Fund",
"other",
true,
true,
55,
1732147200000,
210,
"sell",
180,
56,
null
],
[
"VBN59NOGKDQY9YTINFGRN",
"INF200K01190",
"KOTAK SEC FUND",
"equity",
true,
true,
40,
1729977600000,
1200,
"sell",
800,
230,
null
],
[
"67859NOGKDQY9YTINFGRN",
"INF200K01190",
"KOTAK SEC FUND",
"equity",
true,
true,
50,
1730150400000,
1300,
"sell",
800,
245,
null
]
]
}
]
},
{
"name": "etf_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",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
true,
true,
250,
1714521600000,
650,
"buy",
400,
115,
74,
130,
137,
144,
113,
122,
132,
69,
76,
null,
"intraday"
],
[
"BVNCH72LKDQY9RRINTGH",
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
31.536,
1723132800000,
10,
"buy",
340,
92,
34,
93,
139,
17,
3,
68,
61,
48,
109,
null,
"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,
null,
"delivery"
],
[
"BHM88MYGKDQY9RRINTGH",
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
true,
true,
100,
1740336000000,
60,
"buy",
10,
88,
62,
132,
43,
111,
35,
4,
113,
61,
3,
null,
"delivery"
],
[
"GHL909MYGKDQY9RRINTGH",
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
true,
true,
20,
1731196800000,
15,
"buy",
17,
37,
7,
47,
38,
9,
43,
25,
78,
72,
16,
null,
"intraday"
],
[
"BLKMN98HJNMDQY9RRINTGH",
"INF200K01189",
"SBI Gold Fund",
"other",
true,
true,
50,
1641427200000,
120.5877,
"buy",
65,
28,
17,
52,
65,
13,
40,
13,
40,
40,
28,
null,
"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,
null,
"delivery"
],
[
"GMFCH72LKDQY9RRINTGH",
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
100,
1715212800000,
550,
"buy",
220,
137,
98,
138,
39,
106,
59,
21,
61,
146,
78,
null,
"intraday"
],
[
"JNV5CHMYLKDQY9RRINTG",
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
true,
true,
78,
1589414400000,
23,
"buy",
20,
106,
17,
123,
61,
31,
105,
24,
117,
16,
62,
null,
"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,
null,
"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,
null,
"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,
null,
"delivery"
],
[
"HNM88JKGKDQY9RRINGFB",
"INF179KB1QR7",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
75,
1729987200000,
125,
"buy",
300,
19,
128,
126,
28,
70,
59,
130,
1,
113,
31,
null,
"intraday"
],
[
"HJM98MYGKDQY9RRINGFB",
"INF179KB1QR8",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
75,
1721664000000,
150,
"buy",
300,
61,
16,
25,
121,
50,
103,
148,
33,
75,
7,
null,
"delivery"
],
[
"KGFCH72LKDQY9RRINTGH",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
true,
true,
250,
1714521600000,
600,
"sell",
400,
19,
9,
111,
62,
121,
45,
71,
74,
44,
24,
null,
"intraday"
],
[
"KHF78MYGKDQY9RRINTGH",
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
31.536,
1740787200000,
5,
"sell",
340,
134,
111,
2,
96,
29,
36,
128,
104,
94,
101,
null,
"delivery"
],
[
"GHN78MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
true,
true,
60,
1725667200000,
160,
"sell",
250,
60,
140,
15,
119,
139,
13,
18,
106,
10,
58,
null,
"delivery"
],
[
"GJK45MYGKDQY9RRINTGH",
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
true,
true,
100,
1713571200000,
30,
"sell",
10,
123,
38,
8,
101,
111,
99,
103,
89,
43,
11,
null,
"delivery"
],
[
"BHM88MTYH6QY9RRINTGH",
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
true,
true,
20,
1731196800000,
60,
"sell",
17,
43,
50,
48,
1,
7,
57,
9,
64,
73,
7,
null,
"intraday"
],
[
"BHMGP79GKDQY9RRINTGH",
"INF200K01189",
"SBI Gold Fund",
"other",
true,
true,
50,
1735516800000,
60,
"sell",
65,
43,
59,
55,
9,
45,
50,
10,
17,
39,
22,
null,
"delivery"
],
[
"CVH78MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
true,
true,
100,
1716681600000,
200,
"sell",
200,
72,
24,
22,
18,
57,
14,
17,
54,
32,
50,
null,
"delivery"
],
[
"FGN89H72LKDQY9RRINTKL",
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
100,
1715212800000,
500,
"sell",
220,
17,
117,
133,
9,
132,
83,
69,
1,
73,
27,
null,
"intraday"
],
[
"GGFCHMYLKDQY9RRINTGH",
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
true,
true,
78,
1713830400000,
88,
"sell",
20,
79,
35,
65,
99,
120,
146,
115,
90,
100,
93,
null,
"delivery"
],
[
"PKF88MYGKDQY9RRINTGH",
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
true,
true,
90,
1736294400000,
250,
"sell",
100,
95,
105,
55,
104,
39,
74,
23,
26,
42,
142,
null,
"delivery"
],
[
"GHNR59NOHJDQ901TINTLK",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
30,
1721174400000,
450,
"sell",
160,
4,
82,
120,
71,
34,
38,
45,
2,
67,
98,
null,
"delivery"
],
[
"HNT59NOGKDQY897TINF4R",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
80,
1725926400000,
500,
"sell",
160,
36,
36,
69,
74,
139,
57,
75,
81,
118,
149,
null,
"delivery"
],
[
"KNT59NOGKDQY897TINFTR",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
10,
1722297600000,
10,
"sell",
160,
57,
141,
136,
4,
44,
47,
7,
119,
105,
138,
null,
"delivery"
],
[
"HYT59NOGKDQY9YTINFGRN",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
true,
true,
10,
1721520000000,
50,
"sell",
160,
84,
38,
123,
61,
19,
8,
58,
18,
145,
85,
null,
"delivery"
],
[
"GJK48MYGKDQY9RRINGFB",
"INF179KB1QR6",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
75,
1729987200000,
45,
"sell",
300,
39,
95,
149,
59,
12,
133,
149,
109,
98,
66,
null,
"intraday"
]
]
}
]
},
{
"name": "bond_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",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1738694400000,
10,
"buy",
31,
50,
13,
3,
115,
100,
109,
56,
8,
null
],
[
"KGFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1741113600000,
10,
"buy",
121,
112,
21,
98,
33,
113,
104,
98,
61,
null
],
[
"BVNCH72LKDQY9RRINTGH",
"INE272F07011",
"Blue Dart Express",
true,
50,
1730832000000,
20,
"buy",
35,
112,
55,
9,
13,
41,
75,
37,
5,
null
],
[
"BNG57MYGKDQY9RRINTGH",
"INE112J07020",
"IFCI",
true,
200,
1733414400000,
16.55,
"buy",
78,
26,
27,
16,
60,
45,
87,
118,
84,
null
],
[
"GJK45MYGKDQY9RRINTGH",
"INE130K08000",
"SBOX",
false,
200,
1735574400000,
16.55,
"buy",
60,
16,
109,
81,
80,
114,
63,
119,
84,
null
],
[
"GHL909MYGKDQY9RRINTGH",
"INE130K08001",
"QCK",
false,
200,
1633996800000,
16.55,
"buy",
43,
127,
37,
52,
86,
116,
46,
118,
84,
null
],
[
"BHMGP79GKDQY9RRINTGH",
"INE130K08012",
"GGL",
true,
200,
1585008000000,
550,
"buy",
87,
21,
50,
5,
71,
37,
22,
81,
106,
null
],
[
"MJK88MYGKDQY9RRINTGH",
"INE130K08019",
"APPL",
false,
200,
1633564800000,
350,
"buy",
114,
12,
100,
114,
51,
15,
37,
44,
108,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INE261F07055",
"SGB",
true,
500,
1437177600000,
488,
"buy",
95,
69,
57,
104,
77,
41,
38,
28,
101,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INE261F07055",
"SGB",
true,
500,
1626652800000,
322,
"buy",
22,
51,
38,
76,
101,
87,
53,
77,
4,
null
],
[
"JHF78MYGKDQY9RRINTGH",
"INE261F07055",
"SGB",
true,
100,
1626739200000,
350,
"buy",
11,
26,
86,
34,
107,
43,
1,
101,
6,
null
],
[
"KHF78MYGKDQY9RRINTGH",
"INE272F07011",
"Blue Dart Express",
true,
20,
1733788800000,
200,
"sell",
108,
4,
102,
57,
11,
105,
16,
56,
86,
null
],
[
"GHN78MYGKDQY9RRINTGH",
"INE112J07020",
"IFCI",
true,
170,
1734998400000,
500,
"sell",
71,
109,
99,
30,
11,
126,
102,
18,
24,
null
],
[
"BHM88MYGKDQY9RRINTGH",
"INE130K08000",
"SBOX",
false,
170,
1733875200000,
500,
"sell",
78,
99,
8,
16,
9,
102,
63,
100,
31,
null
],
[
"BHM88MTYH6QY9RRINTGH",
"INE130K08001",
"QCK",
false,
200,
1721779200000,
500,
"sell",
48,
128,
1,
120,
112,
20,
79,
115,
74,
null
],
[
"BLKMN98HJNMDQY9RRINTGH",
"INE130K08015",
"GGL",
true,
200,
1712448000000,
600,
"sell",
37,
85,
53,
113,
102,
42,
48,
31,
15,
null
],
[
"CVH78MYGKDQY9RRINTGH",
"INE130K08019",
"APPL",
false,
180,
1734566400000,
310,
"sell",
112,
109,
45,
32,
49,
53,
47,
124,
111,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1728864000000,
125,
"sell",
15,
26,
86,
64,
56,
26,
30,
21,
125,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1729036800000,
125,
"sell",
76,
101,
104,
28,
127,
21,
26,
88,
70,
null
],
[
"JTR59NOGKDQY9YTINTGH",
"INE261F07055",
"SGB",
true,
550,
1721520000000,
350,
"sell",
107,
97,
94,
49,
49,
9,
112,
69,
129,
null
],
[
"DFGR59NOHJDQ751TINTJK",
"INE261F07055",
"SGB",
true,
50,
1728432000000,
400,
"sell",
80,
10,
130,
58,
5,
46,
108,
40,
106,
null
]
]
}
]
},
{
"name": "debenture_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",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
1000,
1525824000000,
10,
"buy",
177,
180,
238,
105,
243,
101,
131,
187,
104,
null
],
[
"DML3WXXE53PJOTGTEYKJ",
"INE272F07011",
"Blue Dart Express",
true,
50,
1589414400000,
20,
"buy",
61,
48,
59,
117,
236,
125,
232,
240,
106,
null
],
[
"ULDR4PE639LOMU4A4VCE",
"INE112J07020",
"IFCI",
true,
200,
1515456000000,
16.55,
"buy",
74,
176,
232,
177,
230,
53,
210,
110,
125,
null
],
[
"QOO5OYJLQBIRUMIGKCIQ",
"INE130K08000",
"SBOX",
false,
200,
1493769600000,
16.55,
"buy",
108,
88,
142,
17,
130,
214,
66,
207,
179,
null
],
[
"PZUTEFRTRX9LFW9DPHAW",
"INE130K08001",
"QCK",
false,
200,
1437177600000,
16.55,
"buy",
133,
242,
225,
166,
45,
232,
127,
64,
210,
null
],
[
"PGR2RDEZFVC2S3YBX1JF",
"INE130K08012",
"GGL",
true,
200,
1626739200000,
550,
"buy",
157,
86,
208,
79,
180,
94,
158,
38,
191,
null
],
[
"DUYJ4ZV7OKJA8CV8U1MT",
"INE130K08019",
"APPL",
false,
200,
1626912000000,
350,
"buy",
215,
228,
8,
98,
119,
44,
185,
50,
154,
null
],
[
"4AGDXGEEJOUHI6G8ATOU",
"INE261F07055",
"SGB",
true,
500,
1556409600000,
600,
"buy",
220,
239,
134,
180,
58,
131,
160,
117,
207,
null
],
[
"AHVDFMGBCECY1IR0QDH9",
"INE261F07055",
"SGB",
true,
500,
1556409600000,
764,
"buy",
159,
38,
58,
8,
34,
12,
202,
103,
31,
null
],
[
"Q2DZQ1ITYAOXILWQLHDN",
"INE261F07055",
"SGB",
true,
100,
1491436800000,
890,
"buy",
189,
118,
196,
90,
161,
199,
36,
138,
50,
null
],
[
"Y6W9FLHOVJ8TCHHNBYGF",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
1000,
1735516800000,
10,
"sell",
224,
48,
219,
210,
51,
234,
197,
66,
220,
null
],
[
"GYHVDLIIXVTLROOCLVYG",
"INE272F07011",
"Blue Dart Express",
true,
20,
1713830400000,
200,
"sell",
151,
188,
89,
94,
45,
54,
58,
220,
6,
null
],
[
"VIHCPUEYSZUMQUVPSJ1P",
"INE112J07020",
"IFCI",
true,
170,
1714262400000,
500,
"sell",
129,
82,
120,
187,
110,
174,
71,
160,
42,
null
],
[
"2BOMU4R5WMEONKEI5YT6",
"INE130K08000",
"SBOX",
false,
170,
1721174400000,
500,
"sell",
97,
118,
33,
9,
151,
6,
38,
52,
40,
null
],
[
"DIQDEZH7K04QBDCJY0NV",
"INE130K08001",
"QCK",
false,
200,
1721347200000,
500,
"sell",
78,
112,
194,
9,
128,
114,
154,
68,
207,
null
],
[
"TFCXQ3TKQRMOHU86MXO1",
"INE130K08015",
"GGL",
true,
200,
1721520000000,
600,
"sell",
103,
56,
160,
203,
240,
171,
239,
71,
42,
null
],
[
"2GFSS7XTAHUWHFZH0NBR",
"INE130K08019",
"APPL",
false,
180,
1721692800000,
310,
"sell",
12,
204,
93,
133,
63,
206,
65,
13,
167,
null
],
[
"FQQ96BPTGAPAQPLMABNU",
"INE261F07055",
"SGB",
true,
550,
1733875200000,
789,
"sell",
52,
8,
14,
119,
231,
1,
246,
128,
155,
null
],
[
"RKW88OVAQVWZMCD9VLJL",
"INE261F07055",
"SGB",
true,
50,
1728691200000,
890,
"sell",
139,
196,
103,
96,
207,
102,
68,
229,
5,
null
]
]
}
]
}
]
}
Tradewise PnL
Click here to learn more about this JSON Payload
{
"name": "tradewise_settlement_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "stock_sheet",
"@entity": "sheet",
"blocks": [
{
"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"
],
"rows": [
[
"INE002A01018",
"AJANTAPHARMA",
true,
true,
5,
"CJ1CLC4YCBFEZ4CVDNMH",
1463356800000,
136,
"CYX9TQSTWUYK8C9Z7BCE",
1733810043000,
580,
438,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
64.0981,
"trade",
"delivery"
],
[
"INE010B01019",
"CADILAHC",
true,
true,
1,
"VQLDME6IOJZR95BDEKQ9",
1730440443000,
1290.98,
"VXFUFI5Q9HH7FEJPLV3B",
1733032443000,
1301.78,
120,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
91.2,
"trade",
"delivery"
],
[
"INE010B01020",
"TATA",
true,
true,
10,
"VQLDME6IOJZR95BDEKQ4",
1730440443000,
100,
"VXFUFI5Q9HH7FEJPLV3C",
1730440443000,
150,
125,
5,
40,
60,
80,
1,
20,
30,
4,
2,
1,
"trade",
"intraday"
]
]
},
{
"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_holding_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"INE01C001018",
"ADANIPORTS",
48,
1631145600000,
270,
"buy",
null,
null
]
]
},
{
"name": "stock_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"sell_date",
"sell_price",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"INE00E101023",
"BIKAJI",
260,
1693440000000,
370,
"sell",
null,
null
]
]
}
]
},
{
"name": "mutual_fund_sheet",
"@entity": "sheet",
"blocks": [
{
"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"
],
"rows": [
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
true,
true,
355.9,
"GGFCHMYLKDQY9RRINTGH",
1491436800000,
124.2586,
"JHF78MYGKDQY9RRINTGH",
1733810043000,
212.7,
20,
68.1534,
"trade"
],
[
"INF846K01DI3",
"HDFC",
"debt",
true,
true,
4,
"GGFCHMYLKDQY9RRINTGA",
1730440443000,
40,
"JHF78MYGKDQY9RRINTGQ",
1733032443000,
20,
20,
50,
"trade"
]
]
},
{
"name": "mutual_fund_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
},
{
"name": "mutual_fund_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
50,
1491436800000,
124.2586,
"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"
],
"rows": [
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
17.137,
1682640000000,
160,
"sell",
null,
null
]
]
}
]
},
{
"name": "etf_sheet",
"@entity": "sheet",
"blocks": [
{
"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",
"product_type"
],
"rows": [
[
"INF179KB1QR6",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
true,
true,
75,
"HNM88JKGKDQY9RRINGFB",
1491436800000,
124.2586,
"JHF78MYGKDQY9RRINTGH",
1733810043000,
45,
300,
58,
223,
275,
87,
82,
192,
279,
110,
211,
97,
"trade",
"delivery"
],
[
"INF179KB1QR7",
"ABML",
"debt",
true,
true,
1,
"HNM88JKGKDQY9RRINGFL",
1730440443000,
40,
"JHF78MYGKDQY9RRINTGQ",
1733032443000,
45,
300,
58,
223,
275,
87,
82,
192,
279,
110,
211,
97,
"trade",
"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": "etf_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"INF179KB1QR8",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
75,
1658620800000,
150,
"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"
],
"rows": [
[
"INF179KB1QR9",
"Parag parikh",
"equity",
50,
1658620800000,
150,
"sell",
null,
null
]
]
}
]
},
{
"name": "future_sheet",
"@entity": "sheet",
"blocks": [
{
"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_fee",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement"
],
"rows": [
[
null,
"NIFTY 15 JAN 2023 FUT",
"equity",
25,
"Z0FCJBWODSL8GF3KKVPY",
1673481600000,
168,
"VLNYY0FTJTUGELL1TK8D",
1733810043000,
146,
107.7,
60.3,
3.8,
136.4,
221.4,
427.6,
12.2,
13.1,
58.5,
44.7,
"trade"
],
[
null,
"NIFTY 15 JAN 2023 FUT",
"commodity",
75,
"Z0FCJBWODSL8GF3KKVPY",
1673481600000,
168,
"VLNYY0FTJTUGELL1TK8D",
1733032443000,
158,
62.1,
126.9,
30.4,
169.2,
96.2,
155.8,
53.6,
181.3,
144.5,
8.1,
"trade"
]
]
},
{
"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"
],
"rows": [
[
null,
"FUTCUR JPYINR 24 AUG 2023",
"currency",
10,
1690848000000,
345.89,
"sell",
null,
null
],
[
null,
"NIFTY 17 APR 2023 FUT",
"equity",
10,
1679616000000,
457.89,
"buy",
null,
null
]
]
}
]
},
{
"name": "option_sheet",
"@entity": "sheet",
"blocks": [
{
"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_fee",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement"
],
"rows": [
[
null,
"NIFTY 23 JAN 2023 CE 15000",
"equity",
25,
"ULDR4PE639LOMU4A4VCE",
1670457600000,
1570,
"0B3PIU4WMIPKUQEG34BO",
1733810043000,
1460,
1206.3333,
2859.6667,
2816.6667,
1138,
442.6667,
2843.3333,
1416.6667,
3065.3333,
1862.6667,
728.6667,
"trade"
],
[
null,
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
70,
"Q5CUBQ2P6B7VKNHCKWD6",
1665446400000,
139.3077,
"DTXGC9I0ZVOI2FFSHIOL",
1733032443000,
148,
305.8462,
115.6923,
88,
140.6154,
114.6923,
140.6154,
185.9231,
186.3846,
139.1538,
165.5385,
"trade"
]
]
},
{
"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"
],
"rows": [
[
null,
"OPTFUT SILVERM 21 Nov 2022 58000 PE",
"commodity",
20,
1668902400000,
156,
"sell",
null,
null
],
[
null,
"FINNIFTY 25 MAY 2023 CE 14900",
"equity",
10,
1682726400000,
698.03,
"buy",
null,
null
]
]
}
]
},
{
"name": "bond_sheet",
"@entity": "sheet",
"blocks": [
{
"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"
],
"rows": [
[
"INE261F07055",
"SGB",
true,
500,
"GGFCHMYLKDQY9RRINTGH",
1437177600000,
488,
"JTR59NOGKDQY9YTINTGH",
1733810043000,
490,
192.2727,
157.1818,
142.4545,
148.5455,
121.5455,
49.1818,
139.8182,
90.7273,
218.2727,
"trade"
]
]
},
{
"name": "bond_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
},
{
"name": "bond_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"INE261F07055",
"SGB",
400,
322,
null,
"buy",
null,
null
]
]
},
{
"name": "bond_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"sell_date",
"sell_price",
"transaction_type",
"label",
"last_traded_price"
],
"rows": []
}
]
},
{
"name": "debenture_sheet",
"@entity": "sheet",
"blocks": [
{
"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"
],
"rows": [
[
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
1000,
"RJFWB5JYYDORFUEPK5DQ",
1437177600000,
10,
"Y6W9FLHOVJ8TCHHNBYGF",
1733810043000,
10,
401,
228,
457,
315,
294,
335,
328,
253,
324,
"trade"
]
]
},
{
"name": "debenture_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
},
{
"name": "debenture_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"INE112J07020",
"IFCI",
30,
1515456000000,
16.55,
"buy",
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"
],
"rows": []
}
]
}
]
}
Scripwise PnL
Click here to learn more about this JSON Payload
{
"@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", "INE03Q201024", "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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", "INE619I01012", "BANKNIFTY 01 Jun 2023 CE 44100", "equity", 25, 1680739200000, 363.1, "buy", 385, 201, 2235, 795, 1757, 202, 195, 2060, 2112, 1622, null],
["Y6W9FLHOVJ8TCHHNBYGF", "INE545C01013", "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 75, 1683158400000, 363.15, "buy", 2479, 304, 1657, 2282, 1170, 172, 1307, 1660, 1130, 1106, null],
["DML3WXXE53PJOTGTEYKJ", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 100, 1662940800000, 415, "buy", 107, 8, 114, 111, 90, 43, 36, 48, 119, 21, null],
["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, null],
["ULDR4PE639LOMU4A4VCE", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 75, 1670457600000, 1570, "buy", 2122, 1793, 1820, 1893, 560, 1651, 875, 2161, 32, 1916, null],
["VIHCPUEYSZUMQUVPSJ1P", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 125, 1671840000000, 1490, "buy", 114, 1074, 1522, 44, 1158, 535, 2252, 1115, 1171, 2449, null],
["QOO5OYJLQBIRUMIGKCIQ", "INE769A01020", "FINNIFTY 25 JAN 2023 CE 12500", "equity", 50, 1672617600000, 3450.67, "buy", 831, 1827, 1117, 1814, 1230, 499, 1882, 2344, 457, 1850, null],
["2BOMU4R5WMEONKEI5YT6", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 250, 1673481600000, 168, "buy", 1280, 657, 1291, 1139, 636, 2397, 795, 1161, 2236, 1620, null],
["PZUTEFRTRX9LFW9DPHAW", "INE118D01016", "NIFTY 23 JAN 2023 CE 15650", "equity", 100, 1672444800000, 175.55, "buy", 125, 882, 2432, 2077, 2189, 2472, 2156, 1856, 1068, 2285, null],
["DIQDEZH7K04QBDCJY0NV", "INE002A01018", "FINNIFTY 15 FEB 2023 CE 13400", "equity", 50, 1674086400000, 194.9, "buy", 1645, 1807, 1262, 2482, 829, 782, 540, 1000, 354, 2491, null],
["PGR2RDEZFVC2S3YBX1JF", "INE0C5901014", "NIFTY 23 FEB 2023 PE 17100", "equity", 105, 1675296000000, 194.9, "buy", 1760, 1640, 2143, 905, 1374, 1714, 842, 1776, 847, 299, null],
["TFCXQ3TKQRMOHU86MXO1", "INE082B0101", "BANKNIFTY 20 MAR 2023 PE 18900", "equity", 155, 1676505600000, 1500, "buy", 104, 552, 1064, 2411, 1835, 2056, 2421, 2289, 651, 2315, null],
["DUYJ4ZV7OKJA8CV8U1MT", "INE0C5901014", "NIFTY 17 APR 2023 PE 17800", "equity", 55, 1679616000000, 457.89, "buy", 1766, 2139, 1170, 2017, 723, 2101, 1756, 2357, 1517, 2394, null],
["2GFSS7XTAHUWHFZH0NBR", "INE322R01014", "FINNIFTY 25 MAY 2023 CE 14900", "equity", 130, 1682726400000, 698.03, "buy", 682, 2191, 400, 1922, 813, 188, 1323, 188, 880, 1267, null],
["4AGDXGEEJOUHI6G8ATOU", "INE694N01015", "RELIANCE OCT 1940 CE", "equity", 50, 1695945600000, 559.39, "buy", 1244, 2104, 102, 1018, 319, 1497, 1669, 2059, 1901, 485, null],
["AHVDFMGBCECY1IR0QDH9", "INE197R01010", "RELIANCE OCT 1960 CE", "equity", 175, 1696982400000, 1000, "buy", 2181, 2407, 104, 398, 1577, 1341, 55, 1215, 1616, 879, null],
["Q2DZQ1ITYAOXILWQLHDN", "INE576G01015", "INFOSYS OCT 2550 CE", "equity", 150, 1697500800000, 175, "buy", 444, 1610, 769, 2289, 1456, 437, 1601, 620, 810, 1319, null],
["FQQ96BPTGAPAQPLMABNU", "INE197R01010", "RELIANCE OCT 1920 CE", "equity", 250, 1697846400000, 186, "buy", 1158, 1954, 1513, 2091, 1622, 1175, 383, 2049, 191, 1624, null],
["RKW88OVAQVWZMCD9VLJL", "INE512R01010", "INFOSYS OCT 2590 CE", "equity", 225, 1698105600000, 180, "buy", 874, 1430, 2384, 1648, 1398, 596, 367, 396, 1897, 1511, null],
["TTGYOR1EOA3SUTMNCJ58", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 25, 1663632000000, 423, "sell", 106, 107, 78, 45, 79, 100, 14, 58, 70, 85, null],
["MYOFOBCC5W0PCWHVBFPU", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 50, 1664496000000, 456, "buy", 80, 89, 33, 66, 61, 71, 116, 120, 55, 33, null],
["VIX3TEN3GZKPVY2WZCEX", "INE512D09106", "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE", "commodity", 125, 1665619200000, 449, "sell", 4, 73, 78, 84, 113, 71, 1, 75, 118, 18, null],
["Q5CUBQ2P6B7VKNHCKWD6", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 50, 1665446400000, 135, "buy", 237, 56, 15, 18, 104, 15, 22, 76, 89, 112, null],
["Q5CUBQ2P6B7VKNHCKWD6", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 80, 1665446400000, 142, "buy", 188, 53, 11, 89, 31, 92, 119, 77, 58, 6, null],
["DTXGC9I0ZVOI2FFSHIOL", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 70, 1666137600000, 148, "sell", 77, 57, 74, 83, 42, 83, 110, 104, 60, 102, null],
["DTXGC9I0ZVOI2FFSHIOL", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 30, 1666224000000, 150, "sell", 187, 112, 77, 67, 93, 19, 84, 19, 54, 47, null],
["IU0HYP6ZN9EOERPBEWYA", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 140, 1666828800000, 137, "buy", 234, 97, 29, 100, 39, 72, 49, 115, 110, 93, null],
["TAODZZPWWR9R5CO1QX0R", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 80, 1668470400000, 154, "sell", 136, 76, 35, 49, 98, 56, 75, 2, 15, 75, null],
["TAODZZPWWR9R5CO1QX0R", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 20, 1668470400000, 153, "buy", 211, 31, 34, 6, 18, 105, 104, 41, 67, 52, null],
["HVG5B4A45J9CL4CZ35TF", "INE573G07017", "OPTFUT SILVERM 21 Nov 2022 58000 PE", "commodity", 130, 1668902400000, 156, "sell", 110, 41, 105, 57, 47, 64, 63, 34, 46, 26, null],
["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, null],
["EAU3BEIXICIMKLVWWU56", "INE113J07012", "OPTFUT GOLD 29 OCT 2023 60000 PE", "commodity", 55, 1695254400000, 121, "buy", 125, 52, 36, 22, 92, 17, 67, 79, 46, 109, null],
["OJDZI0SB29R3RMHWOG8P", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 85, 1697587200000, 135, "buy", 212, 24, 78, 32, 52, 54, 7, 83, 8, 119, null],
["DOHDNKFFITQRMFUYKQLE", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 35, 1698019200000, 138, "buy", 25, 89, 59, 114, 63, 56, 108, 2, 64, 35, null],
["CVWO1J0HIG9QEY5UVUDQ", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 90, 1700352000000, 142, "sell", 108, 57, 19, 77, 25, 94, 115, 78, 71, 117, null],
["R2K5E791EH5VAQZVOETW", "INE113J07012", "OPTFUT GOLD 29 NOV2023 61000 PE", "commodity", 10, 1700524800000, 149, "sell", 130, 3, 116, 15, 41, 119, 118, 26, 76, 77, null],
["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, null],
["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, null],
["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, null],
["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, null],
["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, null],
["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, null],
["MEHVXLLGPB5SODCHL5PT", "INE645F01015", "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 145, 1680307200000, 278, "sell", 20, 164, 152, 121, 98, 148, 35, 194, 110, 34, null],
["UQCTRKWJRKXVR7LSIBCN", "INE645F01015", "OPTCUR EURINR 13 MAY 2023 94 CE", "currency", 145, 1680739200000, 289, "buy", 25, 85, 159, 60, 145, 36, 46, 146, 237, 157, null],
["PIN8G2M1QKXY1FQZPRIF", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 75, 1694649600000, 4500, "buy", 21, 179, 65, 29, 21, 92, 124, 178, 153, 12, null],
["PIN8G2M1QKXY1FQZPRIF", "INE714H01019", "OPTCUR GBPINR 27 OCT 2023 115 PE", "currency", 75, 1694649600000, 4509, "sell", 15, 93, 151, 111, 104, 103, 55, 238, 153, 97, null],
["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, null],
["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, null],
["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, null],
["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, null],
["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, null],
["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, null],
["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, null],
["KLPAV9GOUCMPFH1WNKLV", "INE619I01012", "BANKNIFTY 01 Jun 2023 CE 44100", "equity", 25, 1685318400000, 450.09, "sell", 1657, 1302, 325, 2118, 2050, 604, 2148, 626, 1489, 2090, null],
["0WNSDPGK4LTXO38HPTLU", "INE545C01013", "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 25, 1685577600000, 469.22, "sell", 1711, 1948, 2048, 700, 2360, 120, 2415, 333, 2231, 736, null],
["QS2KFCND5DJXRNDLLVHD", "INE545C01013", "BANKNIFTY 01 Jun 2023 CE 44200", "equity", 50, 1684886400000, 425.3, "sell", 320, 375, 82, 1593, 1653, 620, 1637, 712, 542, 130, null],
["0B3PIU4WMIPKUQEG34BO", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 25, 1671408000000, 1460, "sell", 499, 2262, 2210, 507, 256, 2293, 1125, 2345, 1852, 90, null],
["S7XOLPIQ2V4R5L89ZEE1", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 45, 1672358400000, 1508, "sell", 1784, 825, 2087, 498, 666, 616, 1994, 763, 157, 2380, null],
["HSZA8B3XH3JC2POXMSXJ", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 50, 1673568000000, 1585, "sell", 335, 1434, 254, 1609, 999, 1979, 2229, 127, 389, 1244, null],
["ILKEYGKTOHFQI5UXMBOO", "INE512R02109", "NIFTY 23 JAN 2023 CE 15000", "equity", 80, 1674172800000, 1635, "sell", 208, 535, 279, 401, 2010, 248, 494, 746, 2399, 1196, null],
["A9HFP9X49AROF21K9KRY", "INE769A01020", "FINNIFTY 25 JAN 2023 CE 12500", "equity", 50, 1674518400000, 2568.98, "sell", 319, 59, 25, 2409, 2339, 423, 132, 250, 2137, 2442, null],
["GHQTIWHDAFE90NOAU6ZY", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 25, 1672185600000, 146, "sell", 1525, 678, 749, 379, 277, 1791, 2288, 545, 1042, 327, null],
["GHQTIWHDAFE90NOAU6ZY", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 75, 1672531200000, 158, "sell", 1761, 2349, 1082, 2181, 1054, 1396, 856, 1220, 1740, 1791, null],
["IXMBK9LENH6CSGULION2", "INE563D01013", "NIFTY 23 JAN 2023 CE 15600", "equity", 150, 1674259200000, 255, "sell", 2369, 875, 2202, 2488, 1574, 404, 532, 779, 2266, 1396, null],
["BEZ31FONIR1EQQI68F0Y", "INE118D01016", "NIFTY 23 JAN 2023 CE 15650", "equity", 100, 1674432000000, 126.78, "sell", 288, 7, 2495, 1391, 1859, 28, 1298, 355, 1234, 1955, null],
["HMC8SXGWGNGWUTFBYRHX", "INE002A01018", "FINNIFTY 15 FEB 2023 CE 13400", "equity", 50, 1675814400000, 174.55, "sell", 879, 2335, 1905, 1798, 456, 1765, 358, 1368, 1124, 1040, null],
["KQDQ54GEHLHTIUSPGAV6", "INE0C5901014", "NIFTY 23 FEB 2023 PE 17100", "equity", 55, 1675987200000, 174.8, "sell", 181, 764, 1349, 1121, 2195, 2042, 1398, 1674, 164, 2244, null],
["SLB3JNRIBXSZWLRWP8ZZ", "INE0C5901014", "NIFTY 23 FEB 2023 PE 17100", "equity", 50, 1676764800000, 210.89, "sell", 77, 713, 1563, 1666, 1745, 20, 528, 2500, 1068, 2008, null],
["LMQI22RLLZHQ5CWBGFYP", "INE082B0101", "BANKNIFTY 20 MAR 2023 PE 18900", "equity", 155, 1679097600000, 615.89, "sell", 1842, 519, 2150, 997, 536, 1241, 2437, 765, 2481, 2126, null],
["71ZRU28BNR9F5FMOZS8V", "INE0C5901014", "NIFTY 17 APR 2023 PE 17800", "equity", 55, 1681084800000, 489.67, "sell", 1519, 340, 2379, 190, 164, 2420, 662, 226, 1681, 722, null],
["PHGLBJWZZLIDKTTVLNQE", "INE322R01014", "FINNIFTY 25 MAY 2023 CE 14900", "equity", 120, 1684368000000, 745.32, "sell", 820, 1114, 2137, 646, 2399, 2314, 160, 1817, 2092, 283, null],
["SEZD4CXXIXJ79ZS0GUQ2", "INE694N01015", "RELIANCE OCT 1940 CE", "equity", 50, 1697328000000, 615.35, "sell", 1797, 249, 1653, 2028, 897, 542, 1158, 2067, 964, 1393, null],
["UESSXHU0UHWCRJ1Z7LJR", "INE576G01015", "INFOSYS OCT 2550 CE", "equity", 150, 1698192000000, 145, "sell", 1204, 722, 1103, 2190, 1165, 1168, 597, 1485, 1127, 1175, null],
["TVSWJDGSX7VFVHA2AUXG", "INE197R01010", "RELIANCE OCT 1920 CE", "equity", 250, 1698624000000, 199, "sell", 267, 1371, 436, 2246, 1747, 765, 1306, 1279, 1236, 1962, null]
]
}
]
},
{
"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", "INE914J01012", "BANKNIFTY 01 Jun 2023 FUT", "equity", 45, 1680739200000, 363.1, "buy", 51, 98, 75, 55, 32, 219, 11, 142, 55, 36, null],
["AUGUWEK01EI4YOIMH7RK", "INE519I01013", "BANKNIFTY 15 Jun 2023 FUT", "equity", 50, 1683158400000, 363.15, "buy", 7, 56, 55, 223, 245, 330, 106, 144, 103, 9, null],
["55MCNYCUWJO7C3ZAXWIX", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 100, 1662940800000, 415, "buy", 107, 8, 114, 111, 90, 43, 36, 48, 119, 21, null],
["JDNI9UJFKN2PGFJZ5U9O", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 135, 1670630400000, 90.69, "buy", 134, 183, 209, 9, 100, 50, 202, 60, 140, 214, null],
["5NGIOMFGDRBG5Q8XTNBP", "INE512R02109", "NIFTY 23 JAN 2023 FUT", "equity", 75, 1670457600000, 147.89, "buy", 143, 44, 39, 61, 130, 216, 102, 90, 158, 37, null],
["ANH3LZISNL7R8DPFNHJ0", "INE512R02109", "NIFTY 23 JAN 2023 FUT", "equity", 125, 1671840000000, 153.89, "buy", 84, 60, 3, 129, 221, 239, 11, 42, 160, 8, null],
["S4LOWQJP4P6SFB42C460", "INE769A01020", "FINNIFTY 25 JAN 2023 FUT", "equity", 35, 1672617600000, 3450.67, "buy", 23, 98, 64, 214, 268, 161, 118, 116, 9, 21, null],
["Z0FCJBWODSL8GF3KKVPY", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 250, 1673481600000, 168, "buy", 27, 73, 8, 224, 284, 306, 42, 111, 5, 17, null],
["CIKTMLOWJQLROEGJXMFF", "INE118D01016", "NIFTY 25 JAN 2023 FUT", "equity", 100, 1672444800000, 175.55, "buy", 65, 76, 54, 192, 58, 74, 149, 50, 17, 20, null],
["NKN2PS2TJZWDA9CDP1RA", "INE002A01018", "FINNIFTY 15 FEB 2023 FUT", "equity", 155, 1674086400000, 194.9, "buy", 39, 85, 72, 144, 40, 15, 16, 39, 66, 47, null],
["TWF45MCZTDWEWSJXU3EF", "INE0C5901014", "NIFTY 23 FEB 2023 FUT", "equity", 175, 1675296000000, 194.9, "buy", 50, 107, 81, 244, 314, 247, 91, 42, 72, 44, null],
["8LEGU2BN0HXVHXYBIIRZ", "INE435D01014", "BANKNIFTY 20 MAR 2023 FUT", "equity", 125, 1676505600000, 1500, "buy", 62, 53, 28, 146, 85, 446, 149, 77, 165, 22, null],
["GB8MD1GQRMB7M3KIPYBT", "INE0C5901014", "NIFTY 17 APR 2023 FUT", "equity", 145, 1679616000000, 457.89, "buy", 131, 77, 80, 49, 161, 373, 17, 130, 77, 16, null],
["GUEQKVCN1OGWGMPXO1WQ", "INE322R01014", "FINNIFTY 20 MAY 2023 FUT", "equity", 130, 1682726400000, 698.03, "buy", 85, 110, 89, 148, 121, 426, 32, 65, 22, 31, null],
["JG3ZELDXI8SYG4HLXSCG", "INE694N01015", "RIL 15 OCT 2023 FUT", "equity", 50, 1695945600000, 559.39, "buy", 111, 42, 44, 189, 145, 307, 57, 64, 43, 28, null],
["1HLEP1MBFH5JINCYGEJB", "INE197R01010", "RIL 01 NOV 2023 FUT", "equity", 175, 1696982400000, 1000, "buy", 72, 52, 33, 117, 71, 327, 39, 67, 132, 3, null],
["YFVS53SUIXO1FBXICSP8", "INE576G01015", "INFY 30 OCT 2023 FUT", "equity", 100, 1697500800000, 175, "buy", 40, 81, 12, 197, 124, 314, 159, 79, 166, 3, null],
["EGTDOZWR9NJKLHJDXYSO", "INE197R01010", "RIL 31 OCT 2023 FUT", "equity", 250, 1697846400000, 186, "buy", 150, 2, 17, 244, 29, 366, 100, 41, 15, 36, null],
["JBJYWGG6VA3VFF3J7OWZ", "INE512R01010", "INFY 25 OCT FUT", "equity", 225, 1698105600000, 180, "buy", 69, 65, 61, 243, 278, 69, 18, 109, 55, 17, null],
["52VUZC1SJ5MW4IKAJPIA", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 25, 1663632000000, 423, "sell", 106, 107, 78, 45, 79, 100, 14, 58, 70, 85, null],
["2FPD4QFGHO2ICG3SK0KG", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 50, 1664496000000, 456, "buy", 80, 89, 33, 66, 61, 71, 116, 120, 55, 33, null],
["XPDDDCPTROUOHFWCQH7O", "INE512D09106", "FUTCOM CRUDEOIL 16 OCT 2022", "commodity", 125, 1665619200000, 449, "sell", 4, 73, 78, 84, 113, 71, 1, 75, 118, 18, null],
["KMY2EC1UMISH0BUMIEGT", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 50, 1665446400000, 135, "buy", 237, 56, 15, 18, 104, 15, 22, 76, 89, 112, null],
["KMY2EC1UMISH0BUMIEGT", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 80, 1665446400000, 142, "buy", 188, 53, 11, 89, 31, 92, 119, 77, 58, 6, null],
["JAWOZXSLWYKHKUWGWS6L", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 70, 1666137600000, 148, "sell", 77, 57, 74, 83, 42, 83, 110, 104, 60, 102, null],
["JAWOZXSLWYKHKUWGWS6L", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 30, 1666224000000, 150, "sell", 187, 112, 77, 67, 93, 19, 84, 19, 54, 47, null],
["1AW8BG2NTK1BPSLMR0TV", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 140, 1666828800000, 137, "buy", 234, 97, 29, 100, 39, 72, 49, 115, 110, 93, null],
["XOUZUWMHBDCRPKRGDD1Q", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 80, 1668470400000, 154, "sell", 136, 76, 35, 49, 98, 56, 75, 2, 15, 75, null],
["XOUZUWMHBDCRPKRGDD1Q", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 20, 1668470400000, 153, "buy", 211, 31, 34, 6, 18, 105, 104, 41, 67, 52, null],
["LAGBHUZEYUH1K2OMGP49", "INE573G07017", "FUTCOM SILVERM 21 Nov 2022 ", "commodity", 130, 1668902400000, 156, "sell", 110, 41, 105, 57, 47, 64, 63, 34, 46, 26, null],
["GR4XEL9XWBSYPARPT0EF", "INE113J07012", "FUTCOM GOLD 29 OCT 2023", "commodity", 55, 1694995200000, 124.56, "sell", 103, 48, 70, 111, 21, 40, 84, 69, 15, 16, null],
["M5ZXEWJZFFR9DR1ECYIE", "INE113J07012", "FUTCOM GOLD 29 OCT 2023", "commodity", 55, 1695254400000, 121, "buy", 125, 52, 36, 22, 92, 17, 67, 79, 46, 109, null],
["FUWODRFMJFABB1VZGX5D", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 85, 1697587200000, 135, "buy", 212, 24, 78, 32, 52, 54, 7, 83, 8, 119, null],
["XVFHRXHI6QWNJUUKBJ0J", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 35, 1698019200000, 138, "buy", 25, 89, 59, 114, 63, 56, 108, 2, 64, 35, null],
["OHNNDTMWFFACP6JQ82GM", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 90, 1700352000000, 142, "sell", 108, 57, 19, 77, 25, 94, 115, 78, 71, 117, null],
["RRCAFBZWEKTPVLYJCRB4", "INE113J07012", "FUTCOM GOLD 29 NOV 2023", "commodity", 10, 1700524800000, 149, "sell", 130, 3, 116, 15, 41, 119, 118, 26, 76, 77, null],
["JDNI9UJFKN2PGFJZ5U9O", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 145, 1670630400000, 87.45, "buy", 212, 202, 223, 125, 116, 48, 71, 75, 100, 24, null],
["4TXSMROXNCO4YKN01YBF", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 165, 1671494400000, 94.78, "sell", 177, 48, 234, 38, 176, 182, 159, 80, 200, 136, null],
["D1VHUJNJ1WGO9JVCK2AZ", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 100, 1672358400000, 45.98, "sell", 97, 219, 153, 19, 118, 231, 228, 31, 185, 186, null],
["D1VHUJNJ1WGO9JVCK2AZ", "INE579I01014", "FUTCUR USDINR 27 JAN 2023 ", "currency", 15, 1672617600000, 78.3, "sell", 94, 93, 127, 162, 79, 232, 149, 211, 83, 6, null],
["UVSIUTXLTZHDRHICW9C0", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 50, 1680134400000, 245.78, "sell", 46, 228, 186, 237, 75, 6, 46, 97, 203, 34, null],
["V7L7EV2WB1F06YIJSHQS", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 50, 1680134400000, 260.7, "buy", 178, 162, 152, 207, 202, 185, 95, 232, 121, 209, null],
["8GTJ7JADP09KTKDPFWQJ", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 145, 1680307200000, 278, "sell", 20, 164, 152, 121, 98, 148, 35, 194, 110, 34, null],
["XNAQJZ3OTJFDZ2FEGVVQ", "INE645F01015", "FUTCUR EURINR 13 MAY 2023", "currency", 145, 1680739200000, 289, "buy", 25, 85, 159, 60, 145, 36, 46, 146, 237, 157, null],
["NU9Y7DKWYXX1B8HUGX0G", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 75, 1694649600000, 4500, "buy", 21, 179, 65, 29, 21, 92, 124, 178, 153, 12, null],
["NU9Y7DKWYXX1B8HUGX0G", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 75, 1694649600000, 4509, "sell", 15, 93, 151, 111, 104, 103, 55, 238, 153, 97, null],
["7BN92HT8TUYNDOW29YPQ", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 113, 1695168000000, 4492.367, "buy", 57, 230, 240, 67, 116, 76, 6, 3, 169, 150, null],
["QRJDSFMYL79ULAWADZ4C", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 60, 1695859200000, 4499.876, "sell", 145, 184, 130, 50, 35, 17, 90, 146, 149, 199, null],
["FZJQJNQWOJE78OSAKILB", "INE714H01019", "FUTCUR GBPINR 27 OCT 2023", "currency", 43, 1697673600000, 5008.596, "sell", 47, 22, 47, 31, 24, 32, 128, 195, 47, 87, null],
["BZAB3NIFLVXCEWLNXF0C", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 120, 1690848000000, 345.89, "sell", 7, 203, 116, 18, 12, 64, 159, 151, 211, 148, null],
["EUCWBOWYUQF5LLS2MG9P", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 80, 1691452800000, 325.67, "buy", 44, 87, 14, 179, 169, 178, 97, 26, 72, 170, null],
["EUCWBOWYUQF5LLS2MG9P", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 30, 1691452800000, 319.78, "buy", 89, 205, 71, 145, 106, 166, 209, 67, 6, 124, null],
["MUYD0KEIED2TJLMOBKEM", "INE632P01025", "FUTCUR JPYINR 24 AUG 2023", "currency", 40, 1692230400000, 329.587, "sell", 59, 42, 140, 65, 52, 47, 80, 128, 39, 105, null],
["DROFW5LAACDWOCFKDQET", "INE914J01012", "BANKNIFTY 01 Jun 2023 FUT", "equity", 45, 1685318400000, 450.09, "sell", 111, 55, 14, 84, 291, 436, 146, 24, 168, 39, null],
["Y9V66LWUBLF8P2I8FDAR", "INE519I01013", "BANKNIFTY 15 Jun 2023 FUT", "equity", 25, 1685577600000, 469.22, "sell", 78, 91, 80, 41, 123, 291, 83, 151, 115, 11, null],
["2C7BGL8DLAEX6DMFGRTF", "INE519I01013", "BANKNIFTY 15 Jun 2023 FUT", "equity", 25, 1684886400000, 425.3, "sell", 22, 107, 62, 188, 249, 158, 117, 82, 21, 18, null],
["CJLNLY40ORWJXUKGVC8E", "INE894N01016", "NIFTY 23 JAN 2023 FUT", "equity", 25, 1671408000000, 135.67, "sell", 69, 101, 25, 74, 90, 300, 128, 21, 56, 3, null],
["GFHNW8Q8GH4F408UZQ0M", "INE894N01017", "NIFTY 23 JAN 2023 FUT", "equity", 45, 1672358400000, 129.89, "sell", 132, 88, 37, 24, 279, 212, 148, 43, 116, 26, null],
["LL4ESNCPAINCWUTVOYKX", "INE894N01018", "NIFTY 23 JAN 2023 FUT", "equity", 50, 1673568000000, 147.89, "sell", 53, 67, 8, 87, 63, 171, 86, 89, 83, 9, null],
["WI62KWVR0MYO0WXLDQ4J", "INE694C01015", "NIFTY 23 JAN 2023 FUT", "equity", 80, 1674172800000, 150, "sell", 10, 50, 68, 204, 60, 36, 24, 6, 43, 16, null],
["IJPDDNJO9BNNH0TB9NPJ", "INE769A01020", "FINNIFTY 25 JAN 2023 FUT", "equity", 35, 1674518400000, 2568.98, "sell", 132, 85, 15, 82, 101, 10, 152, 75, 46, 11, null],
["VLNYY0FTJTUGELL1TK8D", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 25, 1672185600000, 146, "sell", 105, 53, 3, 114, 193, 397, 8, 2, 58, 43, null],
["VLNYY0FTJTUGELL1TK8D", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 75, 1672531200000, 158, "sell", 54, 105, 28, 102, 11, 64, 41, 148, 143, 3, null],
["VY3TYTSPMWLYJQAEMGTZ", "INE563D01013", "NIFTY 15 JAN 2023 FUT", "equity", 150, 1674259200000, 255, "sell", 138, 32, 42, 214, 44, 13, 146, 43, 52, 35, null],
["YQT2WZWDNZPPCRDSQFR9", "INE118D01016", "NIFTY 25 JAN 2023 FUT", "equity", 100, 1674432000000, 126.78, "sell", 18, 23, 81, 239, 107, 183, 158, 64, 137, 50, null],
["9ZLDZGRMJBSSAIJTBTHN", "INE002A01018", "FINNIFTY 15 FEB 2023 FUT", "equity", 155, 1675814400000, 174.55, "sell", 130, 33, 69, 197, 298, 266, 24, 142, 9, 19, null],
["RHSYRUIXEC7M4HJBK46H", "INE0C5901014", "NIFTY 23 FEB 2023 FUT", "equity", 55, 1675987200000, 174.8, "sell", 111, 86, 26, 17, 303, 388, 149, 16, 53, 20, null],
["I3RI1TXUYSFLFU4N8IWZ", "INE0C5901014", "NIFTY 23 FEB 2023 FUT", "equity", 120, 1676764800000, 210.89, "sell", 115, 42, 78, 151, 292, 262, 98, 151, 37, 30, null],
["BYSC5G1EPZIWIJJ6BAUB", "INE435D01014", "BANKNIFTY 20 MAR 2023 FUT", "equity", 125, 1679097600000, 615.89, "sell", 101, 83, 15, 219, 125, 349, 140, 154, 129, 6, null],
["MWLF0LTSOJNEXKVXSGWN", "INE0C5901014", "NIFTY 17 APR 2023 FUT", "equity", 135, 1681084800000, 489.67, "sell", 132, 94, 74, 184, 190, 173, 30, 72, 61, 48, null],
["B67GMDMHCZAHJBXKDGL0", "INE322R01014", "FINNIFTY 20 MAY 2023 FUT", "equity", 120, 1684368000000, 745.32, "sell", 150, 13, 35, 133, 133, 362, 128, 119, 83, 39, null],
["DEN7PSRIFMQ0VQXZF8O8", "INE694N01015", "RIL 15 OCT 2023 FUT", "equity", 50, 1697328000000, 615.35, "sell", 99, 59, 84, 104, 322, 159, 92, 122, 136, 15, null],
["GAVL50RNZDGGQSMMLKOF", "INE576G01015", "INFY 30 OCT 2023 FUT", "equity", 100, 1698192000000, 145, "sell", 50, 96, 11, 84, 204, 220, 20, 125, 146, 23, null],
["BWQRBJTC2V55AFBIZPYW", "INE197R01010", "RIL 31 OCT 2023 FUT", "equity", 250, 1698624000000, 199, "sell", 89, 57, 49, 235, 303, 147, 23, 114, 11, 24, null]
]
}
]
},
{
"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", "INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 32.31, 1525824000000, 50, "buy", 400, 10, null],
["KGFCH72LKDQY9RRINTGH", "INE397D01024", "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN", "debt", true, true, 32.31, 1577664000000, 900, "sell", 1000, 89.658, null],
["BVNCH72LKDQY9RRINTGH", "INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 37.216, 1589414400000, 10, "buy", 0, 98, null],
["KHF78MYGKDQY9RRINTGH", "INF251K01NO3", "BNP PARIBAS LIQUID FUND - DIRECT PLAN", "debt", true, true, 17.823, 1650672000000, 5, "sell", 0, 20, null],
["BNG57MYGKDQY9RRINTGH", "INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 19.574, 1515456000000, 120, "buy", 5, 78, null],
["GHN78MYGKDQY9RRINTGH", "INF277K01YE6", "TATA LIQUID FUND - DIRECT PLAN", "debt", true, true, 36.711, 1682640000000, 160, "sell", 5, 33.24, null],
["GJK45MYGKDQY9RRINTGH", "INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 36.023, 1493769600000, 30, "buy", 10, 68, null],
["BHM88MYGKDQY9RRINTGH", "INF278A06YE8", "Aditya Birla Sun Life Medium Term Direct Plan Growth", "debt", true, true, 36.023, 1626480000000, 60, "sell", 10, 100, null],
["GHL909MYGKDQY9RRINTGH", "INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 35.014, 1437177600000, 15, "buy", 17, 67, null],
["BHM88MTYH6QY9RRINTGH", "INF200K01UT4", "SBI LIQUID FUND - DIRECT PLAN", "other", true, true, 19.88, 1626652800000, 60, "sell", 17, 10, null],
["BHMGP79GKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 35.706, 1626739200000, 60, "buy", 65, 30, null],
["BLKMN98HJNMDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 36.062, 1563667200000, 60, "buy", 120, 50, null],
["MJK88MYGKDQY9RRINTGH", "INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 35.039, 1626912000000, 400.784, "buy", 200, 20, null],
["CVH78MYGKDQY9RRINTGH", "INF109KB1GK2", "ICICI Prudential Commodity Fund", "other", true, true, 32.531, 1690070400000, 200, "sell", 200, 90, null],
["GMFCH72LKDQY9RRINTGH", "INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 25.68, 1556409600000, 459, "buy", 220, 0.25, null],
["GMFCH72LKDQY9RRINTGH", "INF179KB1HP9", "HDFC LIQUID FUND - DIRECT PLAN", "equity", true, true, 25.68, 1556409600000, 500, "sell", 220, 50, null],
["GGFCHMYLKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 105.56, 1491436800000, 123, "buy", 20, 25, null],
["GGFCHMYLKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 550.34, 1491436800000, 124.5, "buy", 20, 49, null],
["JHF78MYGKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 355.9, 1662940800000, 212.7, "sell", 20, 28, null],
["JTR59NOGKDQY9YTINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 250, 1670630400000, 209, "sell", 20, 75, null],
["DFGR59NOHJDQ751TINTJK", "INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 129, 1670716800000, 150, "buy", 100, 32, null],
["DFGR59NOHJDQ751TINTJK", "INF179K01PT5", "HDFC Small Cap Fund", "equity", true, true, 100, 1670716800000, 250, "buy", 100, 56, null],
["GHNR59NOHJDQ901TINTLK", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 156.78, 1481500800000, 150, "buy", 160, 22, null],
["HNT59NOGKDQY897TINF4R", "INF200K01OR6", "SBI Magnum Multicap Fund", "equity", true, true, 125, 1670889600000, 400, "sell", 160, 89.658, null],
["KNT59NOGKDQY897TINFTR", "INF760K01FR2", "Canara Robeco Bluechip Equity Growth Direct Plan", "equity", true, true, 155, 1576022400000, 23.78, "buy", 25, 2, null],
["HYT59NOGKDQY9YTINFGRN", "INF760K01FR2", "Canara Robeco Bluechip Equity Growth Direct Plan", "equity", true, true, 155, 1633996800000, 56.9, "sell", 45, 2, null],
["HJM98MYGKDQY9RRINGFB", "INF200K01189", "SBI Gold Fund", "other", true, true, 35, 1374624000000, 200, "buy", 180, 589, null],
["JMCU8MYGKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 35, 1585008000000, 230, "buy", 180, 37, null],
["RTV678MYGKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 55, 1649289600000, 210, "sell", 180, 56, null],
["GHN78NOGKDQY9YTINFGHY", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 50, 1633564800000, 980, "buy", 800, 145, null],
["XCT59NOGKDQY9YTINFGRN", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 40, 1639872000000, 1000, "buy", 800, 198, null],
["VBN59NOGKDQY9YTINFGRN", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 40, 1634169600000, 1200, "sell", 800, 230, null],
["67859NOGKDQY9YTINFGRN", "INF200K01190", "KOTAK SEC FUND", "equity", true, true, 50, 1634342400000, 1300, "sell", 800, 245, null]
]
}
]
},
{
"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", "INE397D01024", "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "intraday"],
["BHMGP79GKDQY9RRINTGH", "INF200K01189", "SBI Gold Fund", "other", true, true, 50, 1640822400000, 60, "sell", 65, 43, 59, 55, 9, 45, 50, 10, 17, 39, 22, null, "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, null, "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, null, "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, null, "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, null, "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, null, "intraday"],
["JNV5CHMYLKDQY9RRINTG", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 78, 1589414400000, 23, "buy", 20, 106, 17, 123, 61, 31, 105, 24, 117, 16, 62, null, "delivery"],
["GGFCHMYLKDQY9RRINTGH", "INF846K01DI2", "Axis Bluechip Fund", "equity", true, true, 78, 1650672000000, 88, "sell", 20, 79, 35, 65, 99, 120, 146, 115, 90, 100, 93, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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, null, "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", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1680739200000, 10, "buy", 31, 50, 13, 3, 115, 100, 109, 56, 8, null],
["KGFCH72LKDQY9RRINTGH", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1683158400000, 10, "buy", 121, 112, 21, 98, 33, 113, 104, 98, 61, null],
["BVNCH72LKDQY9RRINTGH", "INE272F07011", "Blue Dart Express", true, 50, 1662940800000, 20, "buy", 35, 112, 55, 9, 13, 41, 75, 37, 5, null],
["KHF78MYGKDQY9RRINTGH", "INE272F07011", "Blue Dart Express", true, 20, 1670630400000, 200, "sell", 108, 4, 102, 57, 11, 105, 16, 56, 86, null],
["BNG57MYGKDQY9RRINTGH", "INE112J07020", "IFCI", true, 200, 1670457600000, 16.55, "buy", 78, 26, 27, 16, 60, 45, 87, 118, 84, null],
["GHN78MYGKDQY9RRINTGH", "INE112J07020", "IFCI", true, 170, 1671840000000, 500, "sell", 71, 109, 99, 30, 11, 126, 102, 18, 24, null],
["GJK45MYGKDQY9RRINTGH", "INE130K08000", "SBOX", false, 200, 1672617600000, 16.55, "buy", 60, 16, 109, 81, 80, 114, 63, 119, 84, null],
["BHM88MYGKDQY9RRINTGH", "INE130K08000", "SBOX", false, 170, 1576022400000, 500, "sell", 78, 99, 8, 16, 9, 102, 63, 100, 31, null],
["GHL909MYGKDQY9RRINTGH", "INE130K08001", "QCK", false, 200, 1633996800000, 16.55, "buy", 43, 127, 37, 52, 86, 116, 46, 118, 84, null],
["BHM88MTYH6QY9RRINTGH", "INE130K08001", "QCK", false, 200, 1374624000000, 500, "sell", 48, 128, 1, 120, 112, 20, 79, 115, 74, null],
["BHMGP79GKDQY9RRINTGH", "INE130K08012", "GGL", true, 200, 1585008000000, 550, "buy", 87, 21, 50, 5, 71, 37, 22, 81, 106, null],
["BLKMN98HJNMDQY9RRINTGH", "INE130K08015", "GGL", true, 200, 1649289600000, 600, "sell", 37, 85, 53, 113, 102, 42, 48, 31, 15, null],
["MJK88MYGKDQY9RRINTGH", "INE130K08019", "APPL", false, 200, 1633564800000, 350, "buy", 114, 12, 100, 114, 51, 15, 37, 44, 108, null],
["CVH78MYGKDQY9RRINTGH", "INE130K08019", "APPL", false, 180, 1639872000000, 310, "sell", 112, 109, 45, 32, 49, 53, 47, 124, 111, null],
["GMFCH72LKDQY9RRINTGH", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1634169600000, 125, "sell", 15, 26, 86, 64, 56, 26, 30, 21, 125, null],
["GMFCH72LKDQY9RRINTGH", "INE261F07032", "07.64% NABARD TFB 2031", true, 500, 1634342400000, 125, "sell", 76, 101, 104, 28, 127, 21, 26, 88, 70, null],
["GGFCHMYLKDQY9RRINTGH", "INE261F07055", "SGB", true, 500, 1437177600000, 488, "buy", 95, 69, 57, 104, 77, 41, 38, 28, 101, null],
["GGFCHMYLKDQY9RRINTGH", "INE261F07055", "SGB", true, 500, 1626652800000, 322, "buy", 22, 51, 38, 76, 101, 87, 53, 77, 4, null],
["JHF78MYGKDQY9RRINTGH", "INE261F07055", "SGB", true, 100, 1626739200000, 350, "buy", 11, 26, 86, 34, 107, 43, 1, 101, 6, null],
["JTR59NOGKDQY9YTINTGH", "INE261F07055", "SGB", true, 550, 1563667200000, 350, "sell", 107, 97, 94, 49, 49, 9, 112, 69, 129, null],
["DFGR59NOHJDQ751TINTJK", "INE261F07055", "SGB", true, 50, 1570579200000, 400, "sell", 80, 10, 130, 58, 5, 46, 108, 40, 106, null]
]
}
]
},
{
"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", "INE261F07032", "07.64% NABARD TFB 2031", true, 1000, 1525824000000, 10, "buy", 177, 180, 238, 105, 243, 101, 131, 187, 104, null],
["Y6W9FLHOVJ8TCHHNBYGF", "INE261F07032", "07.64% NABARD TFB 2031", true, 1000, 1577664000000, 10, "sell", 224, 48, 219, 210, 51, 234, 197, 66, 220, null],
["DML3WXXE53PJOTGTEYKJ", "INE272F07011", "Blue Dart Express", true, 50, 1589414400000, 20, "buy", 61, 48, 59, 117, 236, 125, 232, 240, 106, null],
["GYHVDLIIXVTLROOCLVYG", "INE272F07011", "Blue Dart Express", true, 20, 1650672000000, 200, "sell", 151, 188, 89, 94, 45, 54, 58, 220, 6, null],
["ULDR4PE639LOMU4A4VCE", "INE112J07020", "IFCI", true, 200, 1515456000000, 16.55, "buy", 74, 176, 232, 177, 230, 53, 210, 110, 125, null],
["VIHCPUEYSZUMQUVPSJ1P", "INE112J07020", "IFCI", true, 170, 1682640000000, 500, "sell", 129, 82, 120, 187, 110, 174, 71, 160, 42, null],
["QOO5OYJLQBIRUMIGKCIQ", "INE130K08000", "SBOX", false, 200, 1493769600000, 16.55, "buy", 108, 88, 142, 17, 130, 214, 66, 207, 179, null],
["2BOMU4R5WMEONKEI5YT6", "INE130K08000", "SBOX", false, 170, 1626480000000, 500, "sell", 97, 118, 33, 9, 151, 6, 38, 52, 40, null],
["PZUTEFRTRX9LFW9DPHAW", "INE130K08001", "QCK", false, 200, 1437177600000, 16.55, "buy", 133, 242, 225, 166, 45, 232, 127, 64, 210, null],
["DIQDEZH7K04QBDCJY0NV", "INE130K08001", "QCK", false, 200, 1626652800000, 500, "sell", 78, 112, 194, 9, 128, 114, 154, 68, 207, null],
["PGR2RDEZFVC2S3YBX1JF", "INE130K08012", "GGL", true, 200, 1626739200000, 550, "buy", 157, 86, 208, 79, 180, 94, 158, 38, 191, null],
["TFCXQ3TKQRMOHU86MXO1", "INE130K08015", "GGL", true, 200, 1563667200000, 600, "sell", 103, 56, 160, 203, 240, 171, 239, 71, 42, null],
["DUYJ4ZV7OKJA8CV8U1MT", "INE130K08019", "APPL", false, 200, 1626912000000, 350, "buy", 215, 228, 8, 98, 119, 44, 185, 50, 154, null],
["2GFSS7XTAHUWHFZH0NBR", "INE130K08019", "APPL", false, 180, 1690070400000, 310, "sell", 12, 204, 93, 133, 63, 206, 65, 13, 167, null],
["4AGDXGEEJOUHI6G8ATOU", "INE261F07055", "SGB", true, 500, 1556409600000, 600, "buy", 220, 239, 134, 180, 58, 131, 160, 117, 207, null],
["AHVDFMGBCECY1IR0QDH9", "INE261F07055", "SGB", true, 500, 1556409600000, 764, "buy", 159, 38, 58, 8, 34, 12, 202, 103, 31, null],
["Q2DZQ1ITYAOXILWQLHDN", "INE261F07055", "SGB", true, 100, 1491436800000, 890, "buy", 189, 118, 196, 90, 161, 199, 36, 138, 50, null],
["FQQ96BPTGAPAQPLMABNU", "INE261F07055", "SGB", true, 550, 1576022400000, 789, "sell", 52, 8, 14, 119, 231, 1, 246, 128, 155, null],
["RKW88OVAQVWZMCD9VLJL", "INE261F07055", "SGB", true, 50, 1633996800000, 890, "sell", 139, 196, 103, 96, 207, 102, 68, 229, 5, null]
]
}
]
}
]
}