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": "scripwise_settlement_workbook",
"sheets": [
{
"@entity": "sheet",
"name": "stock_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "stock_scripwise_settlement_table",
"header": [
"id",
"isin",
"symbol",
"is_listed",
"is_stt_paid",
"quantity",
"buy_average",
"sell_average",
"holding_period",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": [
[
null,
"null",
"INFY",
true,
true,
55,
203.5,
300,
"long_term",
3,
2,
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
},
{
"@entity": "sheet",
"name": "mutual_fund_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "mutual_fund_scripwise_settlement_table",
"header": [
"id",
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"holding_period",
"transfer_expenses"
],
"rows": [
[
null,
"ISIN_GROWW",
"GROWW TAX SAVING FUND",
"debt",
50,
200,
300,
"long_term",
3
]
]
}
]
},
{
"@entity": "sheet",
"name": "future_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "future_scripwise_settlement_table",
"header": [
"id",
"isin",
"contract_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": [
[
null,
null,
"NIFTY",
"equity",
12,
4000,
5000,
12,
23,
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
},
{
"@entity": "sheet",
"name": "option_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "option_scripwise_settlement_table",
"header": [
"id",
"isin",
"contract_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": [
[
null,
null,
"NIFTY",
"equity",
12,
4000,
5000,
12,
23,
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
},
{
"@entity": "sheet",
"name": "etf_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "etf_scripwise_settlement_table",
"header": [
"id",
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_average",
"sell_average",
"holding_period",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": [
[
null,
null,
"GOLDBEES",
"debt",
50,
200,
300,
"long_term",
5,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
null,
null,
"GOLDBEES",
"equity",
50,
200,
300,
"intraday",
5,
0,
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
},
{
"@entity": "sheet",
"name": "bond_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "bond_scripwise_settlement_table",
"header": [
"id",
"isin",
"security_name",
"is_listed",
"quantity",
"buy_average",
"sell_average",
"holding_period",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": [
[
null,
"ISIN_BOND_SVG",
"BOND_SVG",
true,
10,
100,
200,
"short_term",
20,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
},
{
"@entity": "sheet",
"name": "debenture_scripwise_settlement_sheet",
"blocks": [
{
"@entity": "block",
"name": "debenture_scripwise_settlement_table",
"header": [
"id",
"isin",
"security_name",
"is_listed",
"quantity",
"buy_average",
"sell_average",
"holding_period",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": [
[
null,
"ISIN_DEBENTURES_HINDALCO",
"DEBENTURE_HINDALCO",
false,
30,
200,
100,
"short_term",
20,
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
}
]
}