Submit P&L Job
Copy
curl --request POST \
--url https://api.sandbox.co.in/it/calculator/pnl/securities/domestic \
--header 'Content-Type: application/json' \
--header 'x-accept-type: <x-accept-type>' \
--header 'x-api-key: <x-api-key>' \
--data '
{
"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"
],
[
"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"
],
[
"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"
],
[
"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"
],
[
"8BARHLFV3FZVGYTSJ012",
"INE03Q201024",
"GLS",
true,
true,
50,
1752312475956,
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,
1769642020179,
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"
],
[
"K0TMWRLU5HDBSNDITGWA",
"INE01C001018",
"ADANIPORTS",
true,
true,
256,
1748898675819,
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,
1773604877992,
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,
1773830433667,
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,
1763130929850,
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,
1774199712397,
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"
],
[
"G4FILRR9JSAWETX5BFEG",
"INE01C001018",
"ADANIPORTS",
true,
true,
58,
1773283556238,
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,
1758080507721,
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,
1747474320748,
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,
1758132355304,
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,
1761069806897,
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,
1752202262858,
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"
],
[
"1JQ2PDASHYXZCVH6IFTC",
"INE462A01022",
"BAYERCROP",
true,
true,
70,
1774247525697,
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"
],
[
"IAVLRAW3OKLIHPD0DLKQ",
"INE00E101023",
"BIKAJI",
true,
true,
640,
1751356488905,
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,
1768648883439,
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"
],
[
"7UBKDTDSUWJEWXI71MB5",
"INE00E101023",
"BIKAJI",
true,
true,
250,
1744248500579,
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,
1773069853789,
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"
],
[
"T2D14C472FNCQD8A9SEL",
"INE00E101023",
"BIKAJI",
true,
true,
730,
1758219413841,
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,
1768900564083,
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,
1756389295773,
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",
"BANKNIFTY01Jun2023FUT",
"equity",
45,
1711756800000,
363.1,
"buy",
51,
98,
75,
55,
32,
219,
11,
142,
55,
36,
null
],
[
"AUGUWEK01EI4YOIMH7RK",
"INE519I01013",
"BANKNIFTY15Jun2023FUT",
"equity",
50,
1714176000000,
363.15,
"buy",
7,
56,
55,
223,
245,
330,
106,
144,
103,
9,
null
],
[
"55MCNYCUWJO7C3ZAXWIX",
"INE512D09106",
"FUTCOMCRUDEOIL16OCT2022",
"commodity",
100,
1727731200000,
415,
"buy",
107,
8,
114,
111,
90,
43,
36,
48,
119,
21,
null
],
[
"JDNI9UJFKN2PGFJZ5U9O",
"INE579I01014",
"FUTCURUSDINR27JAN2023",
"currency",
135,
1728585600000,
90.69,
"buy",
134,
183,
209,
9,
100,
50,
202,
60,
140,
214,
null
],
[
"5NGIOMFGDRBG5Q8XTNBP",
"INE512R02109",
"NIFTY23JAN2023FUT",
"equity",
75,
1728412800000,
147.89,
"buy",
143,
44,
39,
61,
130,
216,
102,
90,
158,
37,
null
],
[
"ANH3LZISNL7R8DPFNHJ0",
"INE512R02109",
"NIFTY23JAN2023FUT",
"equity",
125,
1728979200000,
153.89,
"buy",
84,
60,
3,
129,
221,
239,
11,
42,
160,
8,
null
],
[
"S4LOWQJP4P6SFB42C460",
"INE769A01020",
"FINNIFTY25JAN2023FUT",
"equity",
35,
1729756800000,
3450.67,
"buy",
23,
98,
64,
214,
268,
161,
118,
116,
9,
21,
null
],
[
"Z0FCJBWODSL8GF3KKVPY",
"INE563D01013",
"NIFTY15JAN2023FUT",
"equity",
250,
1730620800000,
168,
"buy",
27,
73,
8,
224,
284,
306,
42,
111,
5,
17,
null
],
[
"CIKTMLOWJQLROEGJXMFF",
"INE118D01016",
"NIFTY25JAN2023FUT",
"equity",
100,
1729584000000,
175.55,
"buy",
65,
76,
54,
192,
58,
74,
149,
50,
17,
20,
null
],
[
"NKN2PS2TJZWDA9CDP1RA",
"INE002A01018",
"FINNIFTY15FEB2023FUT",
"equity",
155,
1730707200000,
194.9,
"buy",
39,
85,
72,
144,
40,
15,
16,
39,
66,
47,
null
],
[
"TWF45MCZTDWEWSJXU3EF",
"INE0C5901014",
"NIFTY23FEB2023FUT",
"equity",
175,
1730828800000,
194.9,
"buy",
50,
107,
81,
244,
314,
247,
91,
42,
72,
44,
null
],
[
"8LEGU2BN0HXVHXYBIIRZ",
"INE435D01014",
"BANKNIFTY20MAR2023FUT",
"equity",
125,
1730950400000,
1500,
"buy",
62,
53,
28,
146,
85,
446,
149,
77,
165,
22,
null
],
[
"GB8MD1GQRMB7M3KIPYBT",
"INE0C5901014",
"NIFTY17APR2023FUT",
"equity",
145,
1731260800000,
457.89,
"buy",
131,
77,
80,
49,
161,
373,
17,
130,
77,
16,
null
],
[
"GUEQKVCN1OGWGMPXO1WQ",
"INE322R01014",
"FINNIFTY20MAY2023FUT",
"equity",
130,
1731699200000,
698.03,
"buy",
85,
110,
89,
148,
121,
426,
32,
65,
22,
31,
null
],
[
"JG3ZELDXI8SYG4HLXSCG",
"INE694N01015",
"RIL15OCT2023FUT",
"equity",
50,
1726963200000,
559.39,
"buy",
111,
42,
44,
189,
145,
307,
57,
64,
43,
28,
null
],
[
"1HLEP1MBFH5JINCYGEJB",
"INE197R01010",
"RIL01NOV2023FUT",
"equity",
175,
1728000000000,
1000,
"buy",
72,
52,
33,
117,
71,
327,
39,
67,
132,
3,
null
],
[
"YFVS53SUIXO1FBXICSP8",
"INE576G01015",
"INFY30OCT2023FUT",
"equity",
100,
1728518400000,
175,
"buy",
40,
81,
12,
197,
124,
314,
159,
79,
166,
3,
null
],
[
"EGTDOZWR9NJKLHJDXYSO",
"INE197R01010",
"RIL31OCT2023FUT",
"equity",
250,
1728864000000,
186,
"buy",
150,
2,
17,
244,
29,
366,
100,
41,
15,
36,
null
],
[
"JBJYWGG6VA3VFF3J7OWZ",
"INE512R01010",
"INFY25OCTFUT",
"equity",
225,
1729123200000,
180,
"buy",
69,
65,
61,
243,
278,
69,
18,
109,
55,
17,
null
],
[
"52VUZC1SJ5MW4IKAJPIA",
"INE512D09106",
"FUTCOMCRUDEOIL16OCT2022",
"commodity",
25,
1744467694986,
423,
"sell",
106,
107,
78,
45,
79,
100,
14,
58,
70,
85,
null
],
[
"2FPD4QFGHO2ICG3SK0KG",
"INE512D09106",
"FUTCOMCRUDEOIL16OCT2022",
"commodity",
50,
1728681600000,
456,
"buy",
80,
89,
33,
66,
61,
71,
116,
120,
55,
33,
null
],
[
"XPDDDCPTROUOHFWCQH7O",
"INE512D09106",
"FUTCOMCRUDEOIL16OCT2022",
"commodity",
125,
1768596734295,
449,
"sell",
4,
73,
78,
84,
113,
71,
1,
75,
118,
18,
null
],
[
"KMY2EC1UMISH0BUMIEGT",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
50,
1729632000000,
135,
"buy",
237,
56,
15,
18,
104,
15,
22,
76,
89,
112,
null
],
[
"KMY2EC1UMISH0BUMIEGT",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
80,
1729632000000,
142,
"buy",
188,
53,
11,
89,
31,
92,
119,
77,
58,
6,
null
],
[
"JAWOZXSLWYKHKUWGWS6L",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
70,
1771205810599,
148,
"sell",
77,
57,
74,
83,
42,
83,
110,
104,
60,
102,
null
],
[
"JAWOZXSLWYKHKUWGWS6L",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
30,
1762268156139,
150,
"sell",
187,
112,
77,
67,
93,
19,
84,
19,
54,
47,
null
],
[
"1AW8BG2NTK1BPSLMR0TV",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
140,
1730419200000,
137,
"buy",
234,
97,
29,
100,
39,
72,
49,
115,
110,
93,
null
],
[
"XOUZUWMHBDCRPKRGDD1Q",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
80,
1751059490639,
154,
"sell",
136,
76,
35,
49,
98,
56,
75,
2,
15,
75,
null
],
[
"XOUZUWMHBDCRPKRGDD1Q",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
20,
1732060800000,
153,
"buy",
211,
31,
34,
6,
18,
105,
104,
41,
67,
52,
null
],
[
"LAGBHUZEYUH1K2OMGP49",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
130,
1746751858366,
156,
"sell",
110,
41,
105,
57,
47,
64,
63,
34,
46,
26,
null
],
[
"GR4XEL9XWBSYPARPT0EF",
"INE113J07012",
"FUTCOMGOLD29OCT2023",
"commodity",
55,
1752075290423,
124.56,
"sell",
103,
48,
70,
111,
21,
40,
84,
69,
15,
16,
null
],
[
"M5ZXEWJZFFR9DR1ECYIE",
"INE113J07012",
"FUTCOMGOLD29OCT2023",
"commodity",
55,
1726272000000,
121,
"buy",
125,
52,
36,
22,
92,
17,
67,
79,
46,
109,
null
],
[
"FUWODRFMJFABB1VZGX5D",
"INE113J07012",
"FUTCOMGOLD29NOV2023",
"commodity",
85,
1728604800000,
135,
"buy",
212,
24,
78,
32,
52,
54,
7,
83,
8,
119,
null
],
[
"XVFHRXHI6QWNJUUKBJ0J",
"INE113J07012",
"FUTCOMGOLD29NOV2023",
"commodity",
35,
1729036800000,
138,
"buy",
25,
89,
59,
114,
63,
56,
108,
2,
64,
35,
null
],
[
"OHNNDTMWFFACP6JQ82GM",
"INE113J07012",
"FUTCOMGOLD29NOV2023",
"commodity",
90,
1766545293127,
142,
"sell",
108,
57,
19,
77,
25,
94,
115,
78,
71,
117,
null
],
[
"RRCAFBZWEKTPVLYJCRB4",
"INE113J07012",
"FUTCOMGOLD29NOV2023",
"commodity",
10,
1767533278432,
149,
"sell",
130,
3,
116,
15,
41,
119,
118,
26,
76,
77,
null
],
[
"JDNI9UJFKN2PGFJZ5U9O",
"INE579I01014",
"FUTCURUSDINR27JAN2023",
"currency",
145,
1728585600000,
87.45,
"buy",
212,
202,
223,
125,
116,
48,
71,
75,
100,
24,
null
],
[
"4TXSMROXNCO4YKN01YBF",
"INE579I01014",
"FUTCURUSDINR27JAN2023",
"currency",
165,
1771973461682,
94.78,
"sell",
177,
48,
234,
38,
176,
182,
159,
80,
200,
136,
null
],
[
"D1VHUJNJ1WGO9JVCK2AZ",
"INE579I01014",
"FUTCURUSDINR27JAN2023",
"currency",
100,
1753820344176,
45.98,
"sell",
97,
219,
153,
19,
118,
231,
228,
31,
185,
186,
null
],
[
"D1VHUJNJ1WGO9JVCK2AZ",
"INE579I01014",
"FUTCURUSDINR27JAN2023",
"currency",
15,
1771795091847,
78.3,
"sell",
94,
93,
127,
162,
79,
232,
149,
211,
83,
6,
null
],
[
"UVSIUTXLTZHDRHICW9C0",
"INE645F01015",
"FUTCUREURINR13MAY2023",
"currency",
50,
1763676835290,
245.78,
"sell",
46,
228,
186,
237,
75,
6,
46,
97,
203,
34,
null
],
[
"V7L7EV2WB1F06YIJSHQS",
"INE645F01015",
"FUTCUREURINR13MAY2023",
"currency",
50,
1731174400000,
260.7,
"buy",
178,
162,
152,
207,
202,
185,
95,
232,
121,
209,
null
],
[
"8GTJ7JADP09KTKDPFWQJ",
"INE645F01015",
"FUTCUREURINR13MAY2023",
"currency",
145,
1750492920896,
278,
"sell",
20,
164,
152,
121,
98,
148,
35,
194,
110,
34,
null
],
[
"XNAQJZ3OTJFDZ2FEGVVQ",
"INE645F01015",
"FUTCUREURINR13MAY2023",
"currency",
145,
1711756800000,
289,
"buy",
25,
85,
159,
60,
145,
36,
46,
146,
237,
157,
null
],
[
"NU9Y7DKWYXX1B8HUGX0G",
"INE714H01019",
"FUTCURGBPINR27OCT2023",
"currency",
75,
1725667200000,
4500,
"buy",
21,
179,
65,
29,
21,
92,
124,
178,
153,
12,
null
],
[
"NU9Y7DKWYXX1B8HUGX0G",
"INE714H01019",
"FUTCURGBPINR27OCT2023",
"currency",
75,
1774239395461,
4509,
"sell",
15,
93,
151,
111,
104,
103,
55,
238,
153,
97,
null
],
[
"7BN92HT8TUYNDOW29YPQ",
"INE714H01019",
"FUTCURGBPINR27OCT2023",
"currency",
113,
1726185600000,
4492.367,
"buy",
57,
230,
240,
67,
116,
76,
6,
3,
169,
150,
null
],
[
"QRJDSFMYL79ULAWADZ4C",
"INE714H01019",
"FUTCURGBPINR27OCT2023",
"currency",
60,
1750448250099,
4499.876,
"sell",
145,
184,
130,
50,
35,
17,
90,
146,
149,
199,
null
],
[
"FZJQJNQWOJE78OSAKILB",
"INE714H01019",
"FUTCURGBPINR27OCT2023",
"currency",
43,
1770416893638,
5008.596,
"sell",
47,
22,
47,
31,
24,
32,
128,
195,
47,
87,
null
],
[
"BZAB3NIFLVXCEWLNXF0C",
"INE632P01025",
"FUTCURJPYINR24AUG2023",
"currency",
120,
1761818827953,
345.89,
"sell",
7,
203,
116,
18,
12,
64,
159,
151,
211,
148,
null
],
[
"EUCWBOWYUQF5LLS2MG9P",
"INE632P01025",
"FUTCURJPYINR24AUG2023",
"currency",
80,
1731788800000,
325.67,
"buy",
44,
87,
14,
179,
169,
178,
97,
26,
72,
170,
null
],
[
"EUCWBOWYUQF5LLS2MG9P",
"INE632P01025",
"FUTCURJPYINR24AUG2023",
"currency",
30,
1731788800000,
319.78,
"buy",
89,
205,
71,
145,
106,
166,
209,
67,
6,
124,
null
],
[
"MUYD0KEIED2TJLMOBKEM",
"INE632P01025",
"FUTCURJPYINR24AUG2023",
"currency",
40,
1746531637884,
329.587,
"sell",
59,
42,
140,
65,
52,
47,
80,
128,
39,
105,
null
],
[
"DROFW5LAACDWOCFKDQET",
"INE914J01012",
"BANKNIFTY01Jun2023FUT",
"equity",
45,
1758650011897,
450.09,
"sell",
111,
55,
14,
84,
291,
436,
146,
24,
168,
39,
null
],
[
"Y9V66LWUBLF8P2I8FDAR",
"INE519I01013",
"BANKNIFTY15Jun2023FUT",
"equity",
25,
1754476743732,
469.22,
"sell",
78,
91,
80,
41,
123,
291,
83,
151,
115,
11,
null
],
[
"2C7BGL8DLAEX6DMFGRTF",
"INE519I01013",
"BANKNIFTY15Jun2023FUT",
"equity",
25,
1768028851878,
425.3,
"sell",
22,
107,
62,
188,
249,
158,
117,
82,
21,
18,
null
],
[
"CJLNLY40ORWJXUKGVC8E",
"INE894N01016",
"NIFTY23JAN2023FUT",
"equity",
25,
1770550676537,
135.67,
"sell",
69,
101,
25,
74,
90,
300,
128,
21,
56,
3,
null
],
[
"GFHNW8Q8GH4F408UZQ0M",
"INE894N01017",
"NIFTY23JAN2023FUT",
"equity",
45,
1758588641252,
129.89,
"sell",
132,
88,
37,
24,
279,
212,
148,
43,
116,
26,
null
],
[
"LL4ESNCPAINCWUTVOYKX",
"INE894N01018",
"NIFTY23JAN2023FUT",
"equity",
50,
1760677372383,
147.89,
"sell",
53,
67,
8,
87,
63,
171,
86,
89,
83,
9,
null
],
[
"WI62KWVR0MYO0WXLDQ4J",
"INE694C01015",
"NIFTY23JAN2023FUT",
"equity",
80,
1764217116229,
150,
"sell",
10,
50,
68,
204,
60,
36,
24,
6,
43,
16,
null
],
[
"IJPDDNJO9BNNH0TB9NPJ",
"INE769A01020",
"FINNIFTY25JAN2023FUT",
"equity",
35,
1769566147929,
2568.98,
"sell",
132,
85,
15,
82,
101,
10,
152,
75,
46,
11,
null
],
[
"VLNYY0FTJTUGELL1TK8D",
"INE563D01013",
"NIFTY15JAN2023FUT",
"equity",
25,
1745530642634,
146,
"sell",
105,
53,
3,
114,
193,
397,
8,
2,
58,
43,
null
],
[
"VLNYY0FTJTUGELL1TK8D",
"INE563D01013",
"NIFTY15JAN2023FUT",
"equity",
75,
1746317962485,
158,
"sell",
54,
105,
28,
102,
11,
64,
41,
148,
143,
3,
null
],
[
"VY3TYTSPMWLYJQAEMGTZ",
"INE563D01013",
"NIFTY15JAN2023FUT",
"equity",
150,
1751020662630,
255,
"sell",
138,
32,
42,
214,
44,
13,
146,
43,
52,
35,
null
],
[
"YQT2WZWDNZPPCRDSQFR9",
"INE118D01016",
"NIFTY25JAN2023FUT",
"equity",
100,
1766329920870,
126.78,
"sell",
18,
23,
81,
239,
107,
183,
158,
64,
137,
50,
null
],
[
"9ZLDZGRMJBSSAIJTBTHN",
"INE002A01018",
"FINNIFTY15FEB2023FUT",
"equity",
155,
1766443698204,
174.55,
"sell",
130,
33,
69,
197,
298,
266,
24,
142,
9,
19,
null
],
[
"RHSYRUIXEC7M4HJBK46H",
"INE0C5901014",
"NIFTY23FEB2023FUT",
"equity",
55,
1755563901129,
174.8,
"sell",
111,
86,
26,
17,
303,
388,
149,
16,
53,
20,
null
],
[
"I3RI1TXUYSFLFU4N8IWZ",
"INE0C5901014",
"NIFTY23FEB2023FUT",
"equity",
120,
1770417584742,
210.89,
"sell",
115,
42,
78,
151,
292,
262,
98,
151,
37,
30,
null
],
[
"BYSC5G1EPZIWIJJ6BAUB",
"INE435D01014",
"BANKNIFTY20MAR2023FUT",
"equity",
125,
1749233214203,
615.89,
"sell",
101,
83,
15,
219,
125,
349,
140,
154,
129,
6,
null
],
[
"MWLF0LTSOJNEXKVXSGWN",
"INE0C5901014",
"NIFTY17APR2023FUT",
"equity",
135,
1762034908837,
489.67,
"sell",
132,
94,
74,
184,
190,
173,
30,
72,
61,
48,
null
],
[
"B67GMDMHCZAHJBXKDGL0",
"INE322R01014",
"FINNIFTY20MAY2023FUT",
"equity",
120,
1764485109621,
745.32,
"sell",
150,
13,
35,
133,
133,
362,
128,
119,
83,
39,
null
],
[
"DEN7PSRIFMQ0VQXZF8O8",
"INE694N01015",
"RIL15OCT2023FUT",
"equity",
50,
1764079239262,
615.35,
"sell",
99,
59,
84,
104,
322,
159,
92,
122,
136,
15,
null
],
[
"GAVL50RNZDGGQSMMLKOF",
"INE576G01015",
"INFY30OCT2023FUT",
"equity",
100,
1749645989739,
145,
"sell",
50,
96,
11,
84,
204,
220,
20,
125,
146,
23,
null
],
[
"BWQRBJTC2V55AFBIZPYW",
"INE197R01010",
"RIL31OCT2023FUT",
"equity",
250,
1749297629088,
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",
"BANKNIFTY01Jun2023CE44100",
"equity",
25,
1711756800000,
363.1,
"buy",
385,
201,
2235,
795,
1757,
202,
195,
2060,
2112,
1622,
null
],
[
"Y6W9FLHOVJ8TCHHNBYGF",
"INE545C01013",
"BANKNIFTY01Jun2023CE44200",
"equity",
75,
1714176000000,
363.15,
"buy",
2479,
304,
1657,
2282,
1170,
172,
1307,
1660,
1130,
1106,
null
],
[
"DML3WXXE53PJOTGTEYKJ",
"INE512D09106",
"OPTFUTCRUDEOIL16OCT20227000PE",
"commodity",
100,
1727731200000,
415,
"buy",
107,
8,
114,
111,
90,
43,
36,
48,
119,
21,
null
],
[
"GYHVDLIIXVTLROOCLVYG",
"INE579I01014",
"OPTCURUSDINR27JAN202383PE",
"currency",
135,
1728585600000,
90.69,
"buy",
134,
183,
209,
9,
100,
50,
202,
60,
140,
214,
null
],
[
"ULDR4PE639LOMU4A4VCE",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
75,
1728412800000,
1570,
"buy",
2122,
1793,
1820,
1893,
560,
1651,
875,
2161,
32,
1916,
null
],
[
"VIHCPUEYSZUMQUVPSJ1P",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
125,
1728979200000,
1490,
"buy",
114,
1074,
1522,
44,
1158,
535,
2252,
1115,
1171,
2449,
null
],
[
"QOO5OYJLQBIRUMIGKCIQ",
"INE769A01020",
"FINNIFTY25JAN2023CE12500",
"equity",
50,
1729756800000,
3450.67,
"buy",
831,
1827,
1117,
1814,
1230,
499,
1882,
2344,
457,
1850,
null
],
[
"2BOMU4R5WMEONKEI5YT6",
"INE563D01013",
"NIFTY23JAN2023CE15600",
"equity",
250,
1730620800000,
168,
"buy",
1280,
657,
1291,
1139,
636,
2397,
795,
1161,
2236,
1620,
null
],
[
"PZUTEFRTRX9LFW9DPHAW",
"INE118D01016",
"NIFTY23JAN2023CE15650",
"equity",
100,
1729584000000,
175.55,
"buy",
125,
882,
2432,
2077,
2189,
2472,
2156,
1856,
1068,
2285,
null
],
[
"DIQDEZH7K04QBDCJY0NV",
"INE002A01018",
"FINNIFTY15FEB2023CE13400",
"equity",
50,
1730707200000,
194.9,
"buy",
1645,
1807,
1262,
2482,
829,
782,
540,
1000,
354,
2491,
null
],
[
"PGR2RDEZFVC2S3YBX1JF",
"INE0C5901014",
"NIFTY23FEB2023PE17100",
"equity",
105,
1730828800000,
194.9,
"buy",
1760,
1640,
2143,
905,
1374,
1714,
842,
1776,
847,
299,
null
],
[
"TFCXQ3TKQRMOHU86MXO1",
"INE082B0101",
"BANKNIFTY20MAR2023PE18900",
"equity",
155,
1730950400000,
1500,
"buy",
104,
552,
1064,
2411,
1835,
2056,
2421,
2289,
651,
2315,
null
],
[
"DUYJ4ZV7OKJA8CV8U1MT",
"INE0C5901014",
"NIFTY17APR2023PE17800",
"equity",
55,
1731260800000,
457.89,
"buy",
1766,
2139,
1170,
2017,
723,
2101,
1756,
2357,
1517,
2394,
null
],
[
"2GFSS7XTAHUWHFZH0NBR",
"INE322R01014",
"FINNIFTY25MAY2023CE14900",
"equity",
130,
1731699200000,
698.03,
"buy",
682,
2191,
400,
1922,
813,
188,
1323,
188,
880,
1267,
null
],
[
"4AGDXGEEJOUHI6G8ATOU",
"INE694N01015",
"RELIANCEOCT1940CE",
"equity",
50,
1726963200000,
559.39,
"buy",
1244,
2104,
102,
1018,
319,
1497,
1669,
2059,
1901,
485,
null
],
[
"AHVDFMGBCECY1IR0QDH9",
"INE197R01010",
"RELIANCEOCT1960CE",
"equity",
175,
1728000000000,
1000,
"buy",
2181,
2407,
104,
398,
1577,
1341,
55,
1215,
1616,
879,
null
],
[
"Q2DZQ1ITYAOXILWQLHDN",
"INE576G01015",
"INFOSYSOCT2550CE",
"equity",
150,
1728518400000,
175,
"buy",
444,
1610,
769,
2289,
1456,
437,
1601,
620,
810,
1319,
null
],
[
"FQQ96BPTGAPAQPLMABNU",
"INE197R01010",
"RELIANCEOCT1920CE",
"equity",
250,
1728864000000,
186,
"buy",
1158,
1954,
1513,
2091,
1622,
1175,
383,
2049,
191,
1624,
null
],
[
"RKW88OVAQVWZMCD9VLJL",
"INE512R01010",
"INFOSYSOCT2590CE",
"equity",
225,
1729123200000,
180,
"buy",
874,
1430,
2384,
1648,
1398,
596,
367,
396,
1897,
1511,
null
],
[
"TTGYOR1EOA3SUTMNCJ58",
"INE512D09106",
"OPTFUTCRUDEOIL16OCT20227000PE",
"commodity",
25,
1772190392277,
423,
"sell",
106,
107,
78,
45,
79,
100,
14,
58,
70,
85,
null
],
[
"MYOFOBCC5W0PCWHVBFPU",
"INE512D09106",
"OPTFUTCRUDEOIL16OCT20227000PE",
"commodity",
50,
1728681600000,
456,
"buy",
80,
89,
33,
66,
61,
71,
116,
120,
55,
33,
null
],
[
"VIX3TEN3GZKPVY2WZCEX",
"INE512D09106",
"OPTFUTCRUDEOIL16OCT20227000PE",
"commodity",
125,
1753322058310,
449,
"sell",
4,
73,
78,
84,
113,
71,
1,
75,
118,
18,
null
],
[
"Q5CUBQ2P6B7VKNHCKWD6",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
50,
1729632000000,
135,
"buy",
237,
56,
15,
18,
104,
15,
22,
76,
89,
112,
null
],
[
"Q5CUBQ2P6B7VKNHCKWD6",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
80,
1729632000000,
142,
"buy",
188,
53,
11,
89,
31,
92,
119,
77,
58,
6,
null
],
[
"DTXGC9I0ZVOI2FFSHIOL",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
70,
1749669372484,
148,
"sell",
77,
57,
74,
83,
42,
83,
110,
104,
60,
102,
null
],
[
"DTXGC9I0ZVOI2FFSHIOL",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
30,
1754867768752,
150,
"sell",
187,
112,
77,
67,
93,
19,
84,
19,
54,
47,
null
],
[
"IU0HYP6ZN9EOERPBEWYA",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
140,
1730419200000,
137,
"buy",
234,
97,
29,
100,
39,
72,
49,
115,
110,
93,
null
],
[
"TAODZZPWWR9R5CO1QX0R",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
80,
1760702830207,
154,
"sell",
136,
76,
35,
49,
98,
56,
75,
2,
15,
75,
null
],
[
"TAODZZPWWR9R5CO1QX0R",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
20,
1732060800000,
153,
"buy",
211,
31,
34,
6,
18,
105,
104,
41,
67,
52,
null
],
[
"HVG5B4A45J9CL4CZ35TF",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
130,
1747648985500,
156,
"sell",
110,
41,
105,
57,
47,
64,
63,
34,
46,
26,
null
],
[
"CJ7UKXJFK6WDVAUWGXGW",
"INE113J07012",
"OPTFUTGOLD29OCT202360000PE",
"commodity",
55,
1755112457295,
124.56,
"sell",
103,
48,
70,
111,
21,
40,
84,
69,
15,
16,
null
],
[
"EAU3BEIXICIMKLVWWU56",
"INE113J07012",
"OPTFUTGOLD29OCT202360000PE",
"commodity",
55,
1726272000000,
121,
"buy",
125,
52,
36,
22,
92,
17,
67,
79,
46,
109,
null
],
[
"OJDZI0SB29R3RMHWOG8P",
"INE113J07012",
"OPTFUTGOLD29NOV202361000PE",
"commodity",
85,
1728604800000,
135,
"buy",
212,
24,
78,
32,
52,
54,
7,
83,
8,
119,
null
],
[
"DOHDNKFFITQRMFUYKQLE",
"INE113J07012",
"OPTFUTGOLD29NOV202361000PE",
"commodity",
35,
1729036800000,
138,
"buy",
25,
89,
59,
114,
63,
56,
108,
2,
64,
35,
null
],
[
"CVWO1J0HIG9QEY5UVUDQ",
"INE113J07012",
"OPTFUTGOLD29NOV202361000PE",
"commodity",
90,
1767082414482,
142,
"sell",
108,
57,
19,
77,
25,
94,
115,
78,
71,
117,
null
],
[
"R2K5E791EH5VAQZVOETW",
"INE113J07012",
"OPTFUTGOLD29NOV202361000PE",
"commodity",
10,
1756305421265,
149,
"sell",
130,
3,
116,
15,
41,
119,
118,
26,
76,
77,
null
],
[
"GYHVDLIIXVTLROOCLVYG",
"INE579I01014",
"OPTCURUSDINR27JAN202383PE",
"currency",
145,
1728585600000,
87.45,
"buy",
212,
202,
223,
125,
116,
48,
71,
75,
100,
24,
null
],
[
"8VMAOKSBFKXAX1Z75UK5",
"INE579I01014",
"OPTCURUSDINR27JAN202383PE",
"currency",
165,
1744956653918,
94.78,
"sell",
177,
48,
234,
38,
176,
182,
159,
80,
200,
136,
null
],
[
"ZXORPEEJE7TVFBPXQ8LI",
"INE579I01014",
"OPTCURUSDINR27JAN202383PE",
"currency",
100,
1756783227749,
45.98,
"sell",
97,
219,
153,
19,
118,
231,
228,
31,
185,
186,
null
],
[
"ZXORPEEJE7TVFBPXQ8LI",
"INE579I01014",
"OPTCURUSDINR27JAN202383PE",
"currency",
15,
1745656580011,
78.3,
"sell",
94,
93,
127,
162,
79,
232,
149,
211,
83,
6,
null
],
[
"6MDVYEYUKHJXIQSGEOPU",
"INE645F01015",
"OPTCUREURINR13MAY202394CE",
"currency",
50,
1773690786760,
245.78,
"sell",
46,
228,
186,
237,
75,
6,
46,
97,
203,
34,
null
],
[
"CPYBETZOWLDVTAYF3PRA",
"INE645F01015",
"OPTCUREURINR13MAY202394CE",
"currency",
50,
1731174400000,
260.7,
"buy",
178,
162,
152,
207,
202,
185,
95,
232,
121,
209,
null
],
[
"MEHVXLLGPB5SODCHL5PT",
"INE645F01015",
"OPTCUREURINR13MAY202394CE",
"currency",
145,
1767623346855,
278,
"sell",
20,
164,
152,
121,
98,
148,
35,
194,
110,
34,
null
],
[
"UQCTRKWJRKXVR7LSIBCN",
"INE645F01015",
"OPTCUREURINR13MAY202394CE",
"currency",
145,
1711756800000,
289,
"buy",
25,
85,
159,
60,
145,
36,
46,
146,
237,
157,
null
],
[
"PIN8G2M1QKXY1FQZPRIF",
"INE714H01019",
"OPTCURGBPINR27OCT2023115PE",
"currency",
75,
1725667200000,
4500,
"buy",
21,
179,
65,
29,
21,
92,
124,
178,
153,
12,
null
],
[
"PIN8G2M1QKXY1FQZPRIF",
"INE714H01019",
"OPTCURGBPINR27OCT2023115PE",
"currency",
75,
1761192677238,
4509,
"sell",
15,
93,
151,
111,
104,
103,
55,
238,
153,
97,
null
],
[
"69WJ3BI70HPVKNLEK5TR",
"INE714H01019",
"OPTCURGBPINR27OCT2023115PE",
"currency",
113,
1726185600000,
4492.367,
"buy",
57,
230,
240,
67,
116,
76,
6,
3,
169,
150,
null
],
[
"P534DDQESQ6XNTI4NURV",
"INE714H01019",
"OPTCURGBPINR27OCT2023115PE",
"currency",
60,
1769948168912,
4499.876,
"sell",
145,
184,
130,
50,
35,
17,
90,
146,
149,
199,
null
],
[
"OXGR4W3D3MYYBURZOEJ5",
"INE714H01019",
"OPTCURGBPINR27OCT2023115PE",
"currency",
43,
1746712233880,
5008.596,
"sell",
47,
22,
47,
31,
24,
32,
128,
195,
47,
87,
null
],
[
"T6B8078DHAC9MGWPKR6B",
"INE632P01025",
"OPTCURJPYINR24AUG202345.6CE",
"currency",
120,
1756408554558,
345.89,
"sell",
7,
203,
116,
18,
12,
64,
159,
151,
211,
148,
null
],
[
"OFAILEZLEAPD9SU5ZOMT",
"INE632P01025",
"OPTCURJPYINR24AUG202345.6CE",
"currency",
80,
1731788800000,
325.67,
"buy",
44,
87,
14,
179,
169,
178,
97,
26,
72,
170,
null
],
[
"OFAILEZLHKPD8SU7ZOMT",
"INE632P01025",
"OPTCURJPYINR24AUG202345.6CE",
"currency",
30,
1731788800000,
319.78,
"buy",
89,
205,
71,
145,
106,
166,
209,
67,
6,
124,
null
],
[
"FDIT8EQR2XJFQJU2JLIG",
"INE632P01025",
"OPTCURJPYINR24AUG202345.6CE",
"currency",
40,
1745008531011,
329.587,
"sell",
59,
42,
140,
65,
52,
47,
80,
128,
39,
105,
null
],
[
"KLPAV9GOUCMPFH1WNKLV",
"INE619I01012",
"BANKNIFTY01Jun2023CE44100",
"equity",
25,
1743718310553,
450.09,
"sell",
1657,
1302,
325,
2118,
2050,
604,
2148,
626,
1489,
2090,
null
],
[
"0WNSDPGK4LTXO38HPTLU",
"INE545C01013",
"BANKNIFTY01Jun2023CE44200",
"equity",
25,
1751163508968,
469.22,
"sell",
1711,
1948,
2048,
700,
2360,
120,
2415,
333,
2231,
736,
null
],
[
"QS2KFCND5DJXRNDLLVHD",
"INE545C01013",
"BANKNIFTY01Jun2023CE44200",
"equity",
50,
1761590934853,
425.3,
"sell",
320,
375,
82,
1593,
1653,
620,
1637,
712,
542,
130,
null
],
[
"0B3PIU4WMIPKUQEG34BO",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
25,
1744864470570,
1460,
"sell",
499,
2262,
2210,
507,
256,
2293,
1125,
2345,
1852,
90,
null
],
[
"S7XOLPIQ2V4R5L89ZEE1",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
45,
1771172357246,
1508,
"sell",
1784,
825,
2087,
498,
666,
616,
1994,
763,
157,
2380,
null
],
[
"HSZA8B3XH3JC2POXMSXJ",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
50,
1749700715623,
1585,
"sell",
335,
1434,
254,
1609,
999,
1979,
2229,
127,
389,
1244,
null
],
[
"ILKEYGKTOHFQI5UXMBOO",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
80,
1764221232709,
1635,
"sell",
208,
535,
279,
401,
2010,
248,
494,
746,
2399,
1196,
null
],
[
"A9HFP9X49AROF21K9KRY",
"INE769A01020",
"FINNIFTY25JAN2023CE12500",
"equity",
50,
1763440981795,
2568.98,
"sell",
319,
59,
25,
2409,
2339,
423,
132,
250,
2137,
2442,
null
],
[
"GHQTIWHDAFE90NOAU6ZY",
"INE563D01013",
"NIFTY23JAN2023CE15600",
"equity",
25,
1771143409491,
146,
"sell",
1525,
678,
749,
379,
277,
1791,
2288,
545,
1042,
327,
null
],
[
"GHQTIWHDAFE90NOAU6ZY",
"INE563D01013",
"NIFTY23JAN2023CE15600",
"equity",
75,
1774573228486,
158,
"sell",
1761,
2349,
1082,
2181,
1054,
1396,
856,
1220,
1740,
1791,
null
],
[
"IXMBK9LENH6CSGULION2",
"INE563D01013",
"NIFTY23JAN2023CE15600",
"equity",
150,
1761215243037,
255,
"sell",
2369,
875,
2202,
2488,
1574,
404,
532,
779,
2266,
1396,
null
],
[
"BEZ31FONIR1EQQI68F0Y",
"INE118D01016",
"NIFTY23JAN2023CE15650",
"equity",
100,
1744194826996,
126.78,
"sell",
288,
7,
2495,
1391,
1859,
28,
1298,
355,
1234,
1955,
null
],
[
"HMC8SXGWGNGWUTFBYRHX",
"INE002A01018",
"FINNIFTY15FEB2023CE13400",
"equity",
50,
1772245765781,
174.55,
"sell",
879,
2335,
1905,
1798,
456,
1765,
358,
1368,
1124,
1040,
null
],
[
"KQDQ54GEHLHTIUSPGAV6",
"INE0C5901014",
"NIFTY23FEB2023PE17100",
"equity",
55,
1750835577853,
174.8,
"sell",
181,
764,
1349,
1121,
2195,
2042,
1398,
1674,
164,
2244,
null
],
[
"SLB3JNRIBXSZWLRWP8ZZ",
"INE0C5901014",
"NIFTY23FEB2023PE17100",
"equity",
50,
1773265720214,
210.89,
"sell",
77,
713,
1563,
1666,
1745,
20,
528,
2500,
1068,
2008,
null
],
[
"LMQI22RLLZHQ5CWBGFYP",
"INE082B0101",
"BANKNIFTY20MAR2023PE18900",
"equity",
155,
1744940811350,
615.89,
"sell",
1842,
519,
2150,
997,
536,
1241,
2437,
765,
2481,
2126,
null
],
[
"71ZRU28BNR9F5FMOZS8V",
"INE0C5901014",
"NIFTY17APR2023PE17800",
"equity",
55,
1746783362527,
489.67,
"sell",
1519,
340,
2379,
190,
164,
2420,
662,
226,
1681,
722,
null
],
[
"PHGLBJWZZLIDKTTVLNQE",
"INE322R01014",
"FINNIFTY25MAY2023CE14900",
"equity",
120,
1759417387455,
745.32,
"sell",
820,
1114,
2137,
646,
2399,
2314,
160,
1817,
2092,
283,
null
],
[
"SEZD4CXXIXJ79ZS0GUQ2",
"INE694N01015",
"RELIANCEOCT1940CE",
"equity",
50,
1770860977415,
615.35,
"sell",
1797,
249,
1653,
2028,
897,
542,
1158,
2067,
964,
1393,
null
],
[
"UESSXHU0UHWCRJ1Z7LJR",
"INE576G01015",
"INFOSYSOCT2550CE",
"equity",
150,
1773024954910,
145,
"sell",
1204,
722,
1103,
2190,
1165,
1168,
597,
1485,
1127,
1175,
null
],
[
"TVSWJDGSX7VFVHA2AUXG",
"INE197R01010",
"RELIANCEOCT1920CE",
"equity",
250,
1752759372785,
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",
"HDFCCREDITRISKDEBTFUND-DIRECTPLAN",
"debt",
true,
true,
32.31,
1525824000000,
50,
"buy",
400,
10,
null
],
[
"BVNCH72LKDQY9RRINTGH",
"INF251K01NO3",
"BNPPARIBASLIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
37.216,
1589414400000,
10,
"buy",
0,
98,
null
],
[
"BNG57MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATALIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
19.574,
1515456000000,
120,
"buy",
5,
78,
null
],
[
"GJK45MYGKDQY9RRINTGH",
"INF278A06YE8",
"AdityaBirlaSunLifeMediumTermDirectPlanGrowth",
"debt",
true,
true,
36.023,
1493769600000,
30,
"buy",
10,
68,
null
],
[
"GHL909MYGKDQY9RRINTGH",
"INF200K01UT4",
"SBILIQUIDFUND-DIRECTPLAN",
"other",
true,
true,
35.014,
1437177600000,
15,
"buy",
17,
67,
null
],
[
"BHMGP79GKDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
35.706,
1626739200000,
60,
"buy",
65,
30,
null
],
[
"BLKMN98HJNMDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
36.062,
1563667200000,
60,
"buy",
120,
50,
null
],
[
"MJK88MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICIPrudentialCommodityFund",
"other",
true,
true,
35.039,
1626912000000,
400.784,
"buy",
200,
20,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INF179KB1HP9",
"HDFCLIQUIDFUND-DIRECTPLAN",
"equity",
true,
true,
25.68,
1556409600000,
459,
"buy",
220,
0.25,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
105.56,
1491436800000,
123,
"buy",
20,
25,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
550.34,
1491436800000,
124.5,
"buy",
20,
49,
null
],
[
"DFGR59NOHJDQ751TINTJK",
"INF179K01PT5",
"HDFCSmallCapFund",
"equity",
true,
true,
129,
1733760000000,
150,
"buy",
100,
32,
null
],
[
"DFGR59NOHJDQ751TINTJK",
"INF179K01PT5",
"HDFCSmallCapFund",
"equity",
true,
true,
100,
1733760000000,
250,
"buy",
100,
56,
null
],
[
"GHNR59NOHJDQ901TINTLK",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
156.78,
1481500800000,
150,
"buy",
160,
22,
null
],
[
"KNT59NOGKDQY897TINFTR",
"INF760K01FR2",
"CanaraRobecoBluechipEquityGrowthDirectPlan",
"equity",
true,
true,
155,
1576022400000,
23.78,
"buy",
25,
2,
null
],
[
"HJM98MYGKDQY9RRINGFB",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
35,
1374624000000,
200,
"buy",
180,
589,
null
],
[
"JMCU8MYGKDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
35,
1585008000000,
230,
"buy",
180,
37,
null
],
[
"GHN78NOGKDQY9YTINFGHY",
"INF200K01190",
"KOTAKSECFUND",
"equity",
true,
true,
50,
1633564800000,
980,
"buy",
800,
145,
null
],
[
"XCT59NOGKDQY9YTINFGRN",
"INF200K01190",
"KOTAKSECFUND",
"equity",
true,
true,
40,
1639872000000,
1000,
"buy",
800,
198,
null
],
[
"KGFCH72LKDQY9RRINTGH",
"INE397D01024",
"HDFCCREDITRISKDEBTFUND-DIRECTPLAN",
"debt",
true,
true,
32.31,
1758159468004,
900,
"sell",
1000,
89.658,
null
],
[
"KHF78MYGKDQY9RRINTGH",
"INF251K01NO3",
"BNPPARIBASLIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
17.823,
1766811844423,
5,
"sell",
0,
20,
null
],
[
"GHN78MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATALIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
36.711,
1758442592259,
160,
"sell",
5,
33.24,
null
],
[
"BHM88MYGKDQY9RRINTGH",
"INF278A06YE8",
"AdityaBirlaSunLifeMediumTermDirectPlanGrowth",
"debt",
true,
true,
36.023,
1761533937248,
60,
"sell",
10,
100,
null
],
[
"BHM88MTYH6QY9RRINTGH",
"INF200K01UT4",
"SBILIQUIDFUND-DIRECTPLAN",
"other",
true,
true,
19.88,
1768826225992,
60,
"sell",
17,
10,
null
],
[
"CVH78MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICIPrudentialCommodityFund",
"other",
true,
true,
32.531,
1771469391914,
200,
"sell",
200,
90,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INF179KB1HP9",
"HDFCLIQUIDFUND-DIRECTPLAN",
"equity",
true,
true,
25.68,
1774298905737,
500,
"sell",
220,
50,
null
],
[
"JHF78MYGKDQY9RRINTGH",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
355.9,
1747475787479,
212.7,
"sell",
20,
28,
null
],
[
"JTR59NOGKDQY9YTINTGH",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
250,
1749834306150,
209,
"sell",
20,
75,
null
],
[
"HNT59NOGKDQY897TINF4R",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
125,
1750955038501,
400,
"sell",
160,
89.658,
null
],
[
"HYT59NOGKDQY9YTINFGRN",
"INF760K01FR2",
"CanaraRobecoBluechipEquityGrowthDirectPlan",
"equity",
true,
true,
155,
1774141921111,
56.9,
"sell",
45,
2,
null
],
[
"RTV678MYGKDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
55,
1744528138656,
210,
"sell",
180,
56,
null
],
[
"VBN59NOGKDQY9YTINFGRN",
"INF200K01190",
"KOTAKSECFUND",
"equity",
true,
true,
40,
1763070425482,
1200,
"sell",
800,
230,
null
],
[
"67859NOGKDQY9YTINFGRN",
"INF200K01190",
"KOTAKSECFUND",
"equity",
true,
true,
50,
1763186904766,
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": [
[
"BVNCH72LKDQY9RRINTGH",
"INF251K01NO3",
"BNPPARIBASLIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
31.536,
1723132800000,
10,
"buy",
340,
92,
34,
93,
139,
17,
3,
68,
61,
48,
109,
null,
"delivery"
],
[
"BNG57MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATALIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
80,
1568160000000,
120,
"buy",
250,
127,
17,
108,
1,
26,
75,
33,
126,
113,
56,
null,
"delivery"
],
[
"BHM88MYGKDQY9RRINTGH",
"INF278A06YE8",
"AdityaBirlaSunLifeMediumTermDirectPlanGrowth",
"debt",
true,
true,
100,
1740336000000,
60,
"buy",
10,
88,
62,
132,
43,
111,
35,
4,
113,
61,
3,
null,
"delivery"
],
[
"BLKMN98HJNMDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
50,
1641427200000,
120.5877,
"buy",
65,
28,
17,
52,
65,
13,
40,
13,
40,
40,
28,
null,
"delivery"
],
[
"MJK88MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICIPrudentialCommodityFund",
"other",
true,
true,
150,
1627862400000,
400.784,
"buy",
200,
77,
59,
77,
12,
5,
2,
7,
10,
5,
30,
null,
"delivery"
],
[
"JNV5CHMYLKDQY9RRINTG",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
78,
1589414400000,
23,
"buy",
20,
106,
17,
123,
61,
31,
105,
24,
117,
16,
62,
null,
"delivery"
],
[
"PKF88MYGKDQY9RRINTGH",
"INF179K01PT5",
"HDFCSmallCapFund",
"equity",
true,
true,
90,
1515456000000,
150,
"buy",
100,
92,
43,
29,
90,
64,
70,
66,
51,
112,
117,
null,
"delivery"
],
[
"DFGR59NOHJDQ751TINTJK",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
95,
1493769600000,
150,
"buy",
160,
107,
98,
49,
143,
53,
73,
107,
52,
75,
56,
null,
"delivery"
],
[
"DFGR59NOHJDQ751TINTJK",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
50,
1493769600000,
400,
"buy",
160,
9,
60,
101,
40,
146,
3,
23,
125,
139,
82,
null,
"delivery"
],
[
"HJM98MYGKDQY9RRINGFB",
"INF179KB1QR8",
"ICICILIQUIDFUND-DIRECTPLAN",
"equity",
true,
true,
75,
1721664000000,
150,
"buy",
300,
61,
16,
25,
121,
50,
103,
148,
33,
75,
7,
null,
"delivery"
],
[
"KHF78MYGKDQY9RRINTGH",
"INF251K01NO3",
"BNPPARIBASLIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
31.536,
1748590909274,
5,
"sell",
340,
134,
111,
2,
96,
29,
36,
128,
104,
94,
101,
null,
"delivery"
],
[
"GHN78MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATALIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
60,
1756246804345,
160,
"sell",
250,
60,
140,
15,
119,
139,
13,
18,
106,
10,
58,
null,
"delivery"
],
[
"GJK45MYGKDQY9RRINTGH",
"INF278A06YE8",
"AdityaBirlaSunLifeMediumTermDirectPlanGrowth",
"debt",
true,
true,
100,
1774372623141,
30,
"sell",
10,
123,
38,
8,
101,
111,
99,
103,
89,
43,
11,
null,
"delivery"
],
[
"BHMGP79GKDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
50,
1756191021653,
60,
"sell",
65,
43,
59,
55,
9,
45,
50,
10,
17,
39,
22,
null,
"delivery"
],
[
"CVH78MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICIPrudentialCommodityFund",
"other",
true,
true,
100,
1760828890202,
200,
"sell",
200,
72,
24,
22,
18,
57,
14,
17,
54,
32,
50,
null,
"delivery"
],
[
"GGFCHMYLKDQY9RRINTGH",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
78,
1754178413427,
88,
"sell",
20,
79,
35,
65,
99,
120,
146,
115,
90,
100,
93,
null,
"delivery"
],
[
"PKF88MYGKDQY9RRINTGH",
"INF179K01PT5",
"HDFCSmallCapFund",
"equity",
true,
true,
90,
1769189188159,
250,
"sell",
100,
95,
105,
55,
104,
39,
74,
23,
26,
42,
142,
null,
"delivery"
],
[
"GHNR59NOHJDQ901TINTLK",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
30,
1771331886011,
450,
"sell",
160,
4,
82,
120,
71,
34,
38,
45,
2,
67,
98,
null,
"delivery"
],
[
"HNT59NOGKDQY897TINF4R",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
80,
1767442617551,
500,
"sell",
160,
36,
36,
69,
74,
139,
57,
75,
81,
118,
149,
null,
"delivery"
],
[
"KNT59NOGKDQY897TINFTR",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
10,
1757525424323,
10,
"sell",
160,
57,
141,
136,
4,
44,
47,
7,
119,
105,
138,
null,
"delivery"
],
[
"HYT59NOGKDQY9YTINFGRN",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
10,
1757470844896,
50,
"sell",
160,
84,
38,
123,
61,
19,
8,
58,
18,
145,
85,
null,
"delivery"
]
]
}
]
},
{
"name": "bond_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "bond_tradebook_table",
"@entity": "table",
"header": [
"trade_id",
"isin",
"security_name",
"is_listed",
"is_stt_paid",
"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": [
[
"TGFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
500,
1738694400000,
10,
"buy",
31,
50,
13,
3,
23,
115,
100,
109,
56,
8,
null
],
[
"KGFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
500,
1741113600000,
10,
"buy",
121,
112,
21,
98,
33,
33,
113,
104,
98,
61,
null
],
[
"BVNCH72LKDQY9RRINTGH",
"INE272F07011",
"BlueDartExpress",
true,
true,
50,
1730832000000,
20,
"buy",
35,
112,
55,
9,
67,
13,
41,
75,
37,
5,
null
],
[
"BNG57MYGKDQY9RRINTGH",
"INE112J07020",
"IFCI",
true,
true,
200,
1733414400000,
16.55,
"buy",
78,
26,
27,
16,
23,
60,
45,
87,
118,
84,
null
],
[
"GJK45MYGKDQY9RRINTGH",
"INE130K08000",
"SBOX",
false,
false,
200,
1735574400000,
16.55,
"buy",
60,
16,
109,
81,
0,
80,
114,
63,
119,
84,
null
],
[
"GHL909MYGKDQY9RRINTGH",
"INE130K08001",
"QCK",
false,
false,
200,
1633996800000,
16.55,
"buy",
43,
127,
37,
52,
0,
86,
116,
46,
118,
84,
null
],
[
"BHMGP79GKDQY9RRINTGH",
"INE130K08012",
"GGL",
true,
true,
200,
1585008000000,
550,
"buy",
87,
21,
50,
5,
23,
71,
37,
22,
81,
106,
null
],
[
"MJK88MYGKDQY9RRINTGH",
"INE130K08019",
"APPL",
false,
false,
200,
1633564800000,
350,
"buy",
114,
12,
100,
114,
0,
51,
15,
37,
44,
108,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INE261F07055",
"SGB",
true,
true,
500,
1437177600000,
488,
"buy",
95,
69,
57,
104,
67,
77,
41,
38,
28,
101,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INE261F07055",
"SGB",
true,
true,
500,
1626652800000,
322,
"buy",
22,
51,
38,
76,
12,
101,
87,
53,
77,
4,
null
],
[
"JHF78MYGKDQY9RRINTGH",
"INE261F07055",
"SGB",
true,
true,
100,
1626739200000,
350,
"buy",
11,
26,
86,
34,
23,
107,
43,
1,
101,
6,
null
],
[
"KHF78MYGKDQY9RRINTGH",
"INE272F07011",
"BlueDartExpress",
true,
true,
20,
1772737689039,
200,
"sell",
108,
4,
102,
57,
33,
11,
105,
16,
56,
86,
null
],
[
"GHN78MYGKDQY9RRINTGH",
"INE112J07020",
"IFCI",
true,
true,
170,
1768142143586,
500,
"sell",
71,
109,
99,
30,
67,
11,
126,
102,
18,
24,
null
],
[
"BHM88MYGKDQY9RRINTGH",
"INE130K08000",
"SBOX",
false,
false,
170,
1747811650141,
500,
"sell",
78,
99,
8,
16,
0,
9,
102,
63,
100,
31,
null
],
[
"BHM88MTYH6QY9RRINTGH",
"INE130K08001",
"QCK",
false,
false,
200,
1772784887881,
500,
"sell",
48,
128,
1,
120,
0,
112,
20,
79,
115,
74,
null
],
[
"BLKMN98HJNMDQY9RRINTGH",
"INE130K08015",
"GGL",
true,
true,
200,
1760544844289,
600,
"sell",
37,
85,
53,
113,
67,
102,
42,
48,
31,
15,
null
],
[
"CVH78MYGKDQY9RRINTGH",
"INE130K08019",
"APPL",
false,
false,
180,
1772665028030,
310,
"sell",
112,
109,
45,
32,
0,
49,
53,
47,
124,
111,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
500,
1748478931773,
125,
"sell",
15,
26,
86,
64,
33,
56,
26,
30,
21,
125,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
500,
1750415876039,
125,
"sell",
76,
101,
104,
28,
67,
127,
21,
26,
88,
70,
null
],
[
"JTR59NOGKDQY9YTINTGH",
"INE261F07055",
"SGB",
true,
true,
550,
1761741616537,
350,
"sell",
107,
97,
94,
49,
12,
49,
9,
112,
69,
129,
null
],
[
"DFGR59NOHJDQ751TINTJK",
"INE261F07055",
"SGB",
true,
true,
50,
1762949787971,
400,
"sell",
80,
10,
130,
58,
44,
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",
"is_stt_paid",
"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",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
1000,
1525824000000,
10,
"buy",
177,
180,
238,
105,
105,
243,
101,
131,
187,
104,
null
],
[
"DML3WXXE53PJOTGTEYKJ",
"INE272F07011",
"BlueDartExpress",
true,
true,
50,
1589414400000,
20,
"buy",
61,
48,
59,
117,
117,
236,
125,
232,
240,
106,
null
],
[
"ULDR4PE639LOMU4A4VCE",
"INE112J07020",
"IFCI",
true,
true,
200,
1515456000000,
16.55,
"buy",
74,
176,
232,
177,
177,
230,
53,
210,
110,
125,
null
],
[
"QOO5OYJLQBIRUMIGKCIQ",
"INE130K08000",
"SBOX",
false,
false,
200,
1493769600000,
16.55,
"buy",
108,
88,
142,
17,
0,
130,
214,
66,
207,
179,
null
],
[
"PZUTEFRTRX9LFW9DPHAW",
"INE130K08001",
"QCK",
false,
false,
200,
1437177600000,
16.55,
"buy",
133,
242,
225,
166,
0,
45,
232,
127,
64,
210,
null
],
[
"PGR2RDEZFVC2S3YBX1JF",
"INE130K08012",
"GGL",
true,
true,
200,
1626739200000,
550,
"buy",
157,
86,
208,
79,
79,
180,
94,
158,
38,
191,
null
],
[
"DUYJ4ZV7OKJA8CV8U1MT",
"INE130K08019",
"APPL",
false,
false,
200,
1626912000000,
350,
"buy",
215,
228,
8,
98,
0,
119,
44,
185,
50,
154,
null
],
[
"4AGDXGEEJOUHI6G8ATOU",
"INE261F07055",
"SGB",
true,
true,
500,
1556409600000,
600,
"buy",
220,
239,
134,
180,
180,
58,
131,
160,
117,
207,
null
],
[
"AHVDFMGBCECY1IR0QDH9",
"INE261F07055",
"SGB",
true,
true,
500,
1556409600000,
764,
"buy",
159,
38,
58,
8,
8,
34,
12,
202,
103,
31,
null
],
[
"Q2DZQ1ITYAOXILWQLHDN",
"INE261F07055",
"SGB",
true,
true,
100,
1491436800000,
890,
"buy",
189,
118,
196,
90,
90,
161,
199,
36,
138,
50,
null
],
[
"Y6W9FLHOVJ8TCHHNBYGF",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
1000,
1764583887544,
10,
"sell",
224,
48,
219,
210,
210,
51,
234,
197,
66,
220,
null
],
[
"GYHVDLIIXVTLROOCLVYG",
"INE272F07011",
"BlueDartExpress",
true,
true,
20,
1759301230685,
200,
"sell",
151,
188,
89,
94,
94,
45,
54,
58,
220,
6,
null
],
[
"VIHCPUEYSZUMQUVPSJ1P",
"INE112J07020",
"IFCI",
true,
true,
170,
1751520034430,
500,
"sell",
129,
82,
120,
187,
187,
110,
174,
71,
160,
42,
null
],
[
"2BOMU4R5WMEONKEI5YT6",
"INE130K08000",
"SBOX",
false,
false,
170,
1746115966803,
500,
"sell",
97,
118,
33,
9,
0,
151,
6,
38,
52,
40,
null
],
[
"DIQDEZH7K04QBDCJY0NV",
"INE130K08001",
"QCK",
false,
false,
200,
1748304011006,
500,
"sell",
78,
112,
194,
9,
0,
128,
114,
154,
68,
207,
null
],
[
"TFCXQ3TKQRMOHU86MXO1",
"INE130K08015",
"GGL",
true,
true,
200,
1772120698642,
600,
"sell",
103,
56,
160,
203,
203,
240,
171,
239,
71,
42,
null
],
[
"2GFSS7XTAHUWHFZH0NBR",
"INE130K08019",
"APPL",
false,
false,
180,
1771070135804,
310,
"sell",
12,
204,
93,
133,
0,
63,
206,
65,
13,
167,
null
],
[
"FQQ96BPTGAPAQPLMABNU",
"INE261F07055",
"SGB",
true,
true,
550,
1743557101246,
789,
"sell",
52,
8,
14,
119,
119,
231,
1,
246,
128,
155,
null
],
[
"RKW88OVAQVWZMCD9VLJL",
"INE261F07055",
"SGB",
true,
true,
50,
1758463330011,
890,
"sell",
139,
196,
103,
96,
96,
207,
102,
68,
229,
5,
null
]
]
}
]
}
]
}
'Copy
{
"code": 200,
"data": {
"@entity": "in.co.sandbox.it.calculator.pnl.securities.job",
"job_id": "0d931fe5-5a9f-4e6d-bde7-c28d95e00706",
"url": "https://in-co-sandbox-it-calculator-pnl-securities-dev.s3.ap-south-1.amazonaws.com/domestic/0d931fe5-5a9f-4e6d-bde7-c28d95e00706/workbook.input?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIARB4EOKMVFH7274FA%2F20250121%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250121T074117Z&X-Amz-Expires=86400&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCmFwLXNvdXRoLTEiRzBFAiBo4d6JJUm9E1HtYb4hX3h2vzPCCP9yuYnDkDh0Fab6lAIhAJ782GssR5yycAc6hhQS7vx1QWTrF6KSRttFVvp6uyE5KrsDCLn%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQABoMMDcyNzU1MzM1OTc4IgyVC5e1MNp9kpK1QdYqjwMKV4QWxEac3TF2zvsq3GAjnji8B4fuMNdmMSRTZi3BtWUPnylGKPb7l%2FK%2BD0t0RxMPaBpspPsXSGZK%2FiZ3cGXmvDbCE808bCUwsz2N33ebir7dh%2FmSjvntRotmZqrJW4KFirU1vWBEDbeleDQAlV3GNvT5JUp%2FjId4p%2FqAqMRAUWKfwRq7Ud6%2BFztZbeteOzl4GIgsRP%2Bm7NS8y06YcVE2ZcKuA2WprBbR1mKsreqKzvxw5PTZQztHGzJO5IBFM7rSPSfn6TowRgkf2Q9pTbsh2rG7BJZklcbe%2BiYG9gXOfbeFX66m1R7OKWS7XgVi%2BtzRG5YMxaBrgzfCcYbJZswECXnpdSm7ne1sM%2FPJnAtgLaStc%2F1VOQCf7oq0tmnamRgo8uou1VwrhD9oDcLXMbvujOg2QcKJgDw2Tag%2FCYIq57KugDZUgWmeOmzp61CumxeYjpfDCV6zK6%2F5DIGJrUTjJV%2BsotVROVXMv679h1QOULzRVYKiNMqgrTNB%2FbaWiQS0qwGI7RrmtPJIXDWKELIwg5q9vAY6ngGG0lHpUoSm2g9f9663xtOYvjFmVCNr%2FgReV%2BNurV%2BGZTXTW6N6TpzwKz%2FRUJEJHhU27mawtDCfZ6VU5XvGR1vo6uTqHNnWO2QPNcV7IRZqObtdqLb%2BUcwSGpyLBWECTFNiaxzdZskxOvgT%2FmgiINKszi%2FquANPf%2BdB1vIGXfkkgomiZu54mcw0QVcVogyXyAZQxy677eaTDTWVPTDCAg%3D%3D&X-Amz-Signature=ea0297aa89e8f5d9e04ee4aa0a5d5860b9bb8b207573b213c0f12e904c4f4675&X-Amz-SignedHeaders=host&x-id=PutObject",
"type": "pnl",
"created_at": 1737445277235,
"updated_at": 1737445277235
},
"transaction_id": "0d931fe5-5a9f-4e6d-bde7-c28d95e00706",
"timestamp": 1737445277097
}Check the processing status of a domestic securities P&L job.
POST
/
it
/
calculator
/
pnl
/
securities
/
domestic
Submit P&L Job
Copy
curl --request POST \
--url https://api.sandbox.co.in/it/calculator/pnl/securities/domestic \
--header 'Content-Type: application/json' \
--header 'x-accept-type: <x-accept-type>' \
--header 'x-api-key: <x-api-key>' \
--data '
{
"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"
],
[
"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"
],
[
"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"
],
[
"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"
],
[
"8BARHLFV3FZVGYTSJ012",
"INE03Q201024",
"GLS",
true,
true,
50,
1752312475956,
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,
1769642020179,
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"
],
[
"K0TMWRLU5HDBSNDITGWA",
"INE01C001018",
"ADANIPORTS",
true,
true,
256,
1748898675819,
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,
1773604877992,
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,
1773830433667,
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,
1763130929850,
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,
1774199712397,
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"
],
[
"G4FILRR9JSAWETX5BFEG",
"INE01C001018",
"ADANIPORTS",
true,
true,
58,
1773283556238,
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,
1758080507721,
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,
1747474320748,
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,
1758132355304,
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,
1761069806897,
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,
1752202262858,
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"
],
[
"1JQ2PDASHYXZCVH6IFTC",
"INE462A01022",
"BAYERCROP",
true,
true,
70,
1774247525697,
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"
],
[
"IAVLRAW3OKLIHPD0DLKQ",
"INE00E101023",
"BIKAJI",
true,
true,
640,
1751356488905,
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,
1768648883439,
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"
],
[
"7UBKDTDSUWJEWXI71MB5",
"INE00E101023",
"BIKAJI",
true,
true,
250,
1744248500579,
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,
1773069853789,
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"
],
[
"T2D14C472FNCQD8A9SEL",
"INE00E101023",
"BIKAJI",
true,
true,
730,
1758219413841,
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,
1768900564083,
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,
1756389295773,
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",
"BANKNIFTY01Jun2023FUT",
"equity",
45,
1711756800000,
363.1,
"buy",
51,
98,
75,
55,
32,
219,
11,
142,
55,
36,
null
],
[
"AUGUWEK01EI4YOIMH7RK",
"INE519I01013",
"BANKNIFTY15Jun2023FUT",
"equity",
50,
1714176000000,
363.15,
"buy",
7,
56,
55,
223,
245,
330,
106,
144,
103,
9,
null
],
[
"55MCNYCUWJO7C3ZAXWIX",
"INE512D09106",
"FUTCOMCRUDEOIL16OCT2022",
"commodity",
100,
1727731200000,
415,
"buy",
107,
8,
114,
111,
90,
43,
36,
48,
119,
21,
null
],
[
"JDNI9UJFKN2PGFJZ5U9O",
"INE579I01014",
"FUTCURUSDINR27JAN2023",
"currency",
135,
1728585600000,
90.69,
"buy",
134,
183,
209,
9,
100,
50,
202,
60,
140,
214,
null
],
[
"5NGIOMFGDRBG5Q8XTNBP",
"INE512R02109",
"NIFTY23JAN2023FUT",
"equity",
75,
1728412800000,
147.89,
"buy",
143,
44,
39,
61,
130,
216,
102,
90,
158,
37,
null
],
[
"ANH3LZISNL7R8DPFNHJ0",
"INE512R02109",
"NIFTY23JAN2023FUT",
"equity",
125,
1728979200000,
153.89,
"buy",
84,
60,
3,
129,
221,
239,
11,
42,
160,
8,
null
],
[
"S4LOWQJP4P6SFB42C460",
"INE769A01020",
"FINNIFTY25JAN2023FUT",
"equity",
35,
1729756800000,
3450.67,
"buy",
23,
98,
64,
214,
268,
161,
118,
116,
9,
21,
null
],
[
"Z0FCJBWODSL8GF3KKVPY",
"INE563D01013",
"NIFTY15JAN2023FUT",
"equity",
250,
1730620800000,
168,
"buy",
27,
73,
8,
224,
284,
306,
42,
111,
5,
17,
null
],
[
"CIKTMLOWJQLROEGJXMFF",
"INE118D01016",
"NIFTY25JAN2023FUT",
"equity",
100,
1729584000000,
175.55,
"buy",
65,
76,
54,
192,
58,
74,
149,
50,
17,
20,
null
],
[
"NKN2PS2TJZWDA9CDP1RA",
"INE002A01018",
"FINNIFTY15FEB2023FUT",
"equity",
155,
1730707200000,
194.9,
"buy",
39,
85,
72,
144,
40,
15,
16,
39,
66,
47,
null
],
[
"TWF45MCZTDWEWSJXU3EF",
"INE0C5901014",
"NIFTY23FEB2023FUT",
"equity",
175,
1730828800000,
194.9,
"buy",
50,
107,
81,
244,
314,
247,
91,
42,
72,
44,
null
],
[
"8LEGU2BN0HXVHXYBIIRZ",
"INE435D01014",
"BANKNIFTY20MAR2023FUT",
"equity",
125,
1730950400000,
1500,
"buy",
62,
53,
28,
146,
85,
446,
149,
77,
165,
22,
null
],
[
"GB8MD1GQRMB7M3KIPYBT",
"INE0C5901014",
"NIFTY17APR2023FUT",
"equity",
145,
1731260800000,
457.89,
"buy",
131,
77,
80,
49,
161,
373,
17,
130,
77,
16,
null
],
[
"GUEQKVCN1OGWGMPXO1WQ",
"INE322R01014",
"FINNIFTY20MAY2023FUT",
"equity",
130,
1731699200000,
698.03,
"buy",
85,
110,
89,
148,
121,
426,
32,
65,
22,
31,
null
],
[
"JG3ZELDXI8SYG4HLXSCG",
"INE694N01015",
"RIL15OCT2023FUT",
"equity",
50,
1726963200000,
559.39,
"buy",
111,
42,
44,
189,
145,
307,
57,
64,
43,
28,
null
],
[
"1HLEP1MBFH5JINCYGEJB",
"INE197R01010",
"RIL01NOV2023FUT",
"equity",
175,
1728000000000,
1000,
"buy",
72,
52,
33,
117,
71,
327,
39,
67,
132,
3,
null
],
[
"YFVS53SUIXO1FBXICSP8",
"INE576G01015",
"INFY30OCT2023FUT",
"equity",
100,
1728518400000,
175,
"buy",
40,
81,
12,
197,
124,
314,
159,
79,
166,
3,
null
],
[
"EGTDOZWR9NJKLHJDXYSO",
"INE197R01010",
"RIL31OCT2023FUT",
"equity",
250,
1728864000000,
186,
"buy",
150,
2,
17,
244,
29,
366,
100,
41,
15,
36,
null
],
[
"JBJYWGG6VA3VFF3J7OWZ",
"INE512R01010",
"INFY25OCTFUT",
"equity",
225,
1729123200000,
180,
"buy",
69,
65,
61,
243,
278,
69,
18,
109,
55,
17,
null
],
[
"52VUZC1SJ5MW4IKAJPIA",
"INE512D09106",
"FUTCOMCRUDEOIL16OCT2022",
"commodity",
25,
1744467694986,
423,
"sell",
106,
107,
78,
45,
79,
100,
14,
58,
70,
85,
null
],
[
"2FPD4QFGHO2ICG3SK0KG",
"INE512D09106",
"FUTCOMCRUDEOIL16OCT2022",
"commodity",
50,
1728681600000,
456,
"buy",
80,
89,
33,
66,
61,
71,
116,
120,
55,
33,
null
],
[
"XPDDDCPTROUOHFWCQH7O",
"INE512D09106",
"FUTCOMCRUDEOIL16OCT2022",
"commodity",
125,
1768596734295,
449,
"sell",
4,
73,
78,
84,
113,
71,
1,
75,
118,
18,
null
],
[
"KMY2EC1UMISH0BUMIEGT",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
50,
1729632000000,
135,
"buy",
237,
56,
15,
18,
104,
15,
22,
76,
89,
112,
null
],
[
"KMY2EC1UMISH0BUMIEGT",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
80,
1729632000000,
142,
"buy",
188,
53,
11,
89,
31,
92,
119,
77,
58,
6,
null
],
[
"JAWOZXSLWYKHKUWGWS6L",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
70,
1771205810599,
148,
"sell",
77,
57,
74,
83,
42,
83,
110,
104,
60,
102,
null
],
[
"JAWOZXSLWYKHKUWGWS6L",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
30,
1762268156139,
150,
"sell",
187,
112,
77,
67,
93,
19,
84,
19,
54,
47,
null
],
[
"1AW8BG2NTK1BPSLMR0TV",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
140,
1730419200000,
137,
"buy",
234,
97,
29,
100,
39,
72,
49,
115,
110,
93,
null
],
[
"XOUZUWMHBDCRPKRGDD1Q",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
80,
1751059490639,
154,
"sell",
136,
76,
35,
49,
98,
56,
75,
2,
15,
75,
null
],
[
"XOUZUWMHBDCRPKRGDD1Q",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
20,
1732060800000,
153,
"buy",
211,
31,
34,
6,
18,
105,
104,
41,
67,
52,
null
],
[
"LAGBHUZEYUH1K2OMGP49",
"INE573G07017",
"FUTCOMSILVERM21Nov2022",
"commodity",
130,
1746751858366,
156,
"sell",
110,
41,
105,
57,
47,
64,
63,
34,
46,
26,
null
],
[
"GR4XEL9XWBSYPARPT0EF",
"INE113J07012",
"FUTCOMGOLD29OCT2023",
"commodity",
55,
1752075290423,
124.56,
"sell",
103,
48,
70,
111,
21,
40,
84,
69,
15,
16,
null
],
[
"M5ZXEWJZFFR9DR1ECYIE",
"INE113J07012",
"FUTCOMGOLD29OCT2023",
"commodity",
55,
1726272000000,
121,
"buy",
125,
52,
36,
22,
92,
17,
67,
79,
46,
109,
null
],
[
"FUWODRFMJFABB1VZGX5D",
"INE113J07012",
"FUTCOMGOLD29NOV2023",
"commodity",
85,
1728604800000,
135,
"buy",
212,
24,
78,
32,
52,
54,
7,
83,
8,
119,
null
],
[
"XVFHRXHI6QWNJUUKBJ0J",
"INE113J07012",
"FUTCOMGOLD29NOV2023",
"commodity",
35,
1729036800000,
138,
"buy",
25,
89,
59,
114,
63,
56,
108,
2,
64,
35,
null
],
[
"OHNNDTMWFFACP6JQ82GM",
"INE113J07012",
"FUTCOMGOLD29NOV2023",
"commodity",
90,
1766545293127,
142,
"sell",
108,
57,
19,
77,
25,
94,
115,
78,
71,
117,
null
],
[
"RRCAFBZWEKTPVLYJCRB4",
"INE113J07012",
"FUTCOMGOLD29NOV2023",
"commodity",
10,
1767533278432,
149,
"sell",
130,
3,
116,
15,
41,
119,
118,
26,
76,
77,
null
],
[
"JDNI9UJFKN2PGFJZ5U9O",
"INE579I01014",
"FUTCURUSDINR27JAN2023",
"currency",
145,
1728585600000,
87.45,
"buy",
212,
202,
223,
125,
116,
48,
71,
75,
100,
24,
null
],
[
"4TXSMROXNCO4YKN01YBF",
"INE579I01014",
"FUTCURUSDINR27JAN2023",
"currency",
165,
1771973461682,
94.78,
"sell",
177,
48,
234,
38,
176,
182,
159,
80,
200,
136,
null
],
[
"D1VHUJNJ1WGO9JVCK2AZ",
"INE579I01014",
"FUTCURUSDINR27JAN2023",
"currency",
100,
1753820344176,
45.98,
"sell",
97,
219,
153,
19,
118,
231,
228,
31,
185,
186,
null
],
[
"D1VHUJNJ1WGO9JVCK2AZ",
"INE579I01014",
"FUTCURUSDINR27JAN2023",
"currency",
15,
1771795091847,
78.3,
"sell",
94,
93,
127,
162,
79,
232,
149,
211,
83,
6,
null
],
[
"UVSIUTXLTZHDRHICW9C0",
"INE645F01015",
"FUTCUREURINR13MAY2023",
"currency",
50,
1763676835290,
245.78,
"sell",
46,
228,
186,
237,
75,
6,
46,
97,
203,
34,
null
],
[
"V7L7EV2WB1F06YIJSHQS",
"INE645F01015",
"FUTCUREURINR13MAY2023",
"currency",
50,
1731174400000,
260.7,
"buy",
178,
162,
152,
207,
202,
185,
95,
232,
121,
209,
null
],
[
"8GTJ7JADP09KTKDPFWQJ",
"INE645F01015",
"FUTCUREURINR13MAY2023",
"currency",
145,
1750492920896,
278,
"sell",
20,
164,
152,
121,
98,
148,
35,
194,
110,
34,
null
],
[
"XNAQJZ3OTJFDZ2FEGVVQ",
"INE645F01015",
"FUTCUREURINR13MAY2023",
"currency",
145,
1711756800000,
289,
"buy",
25,
85,
159,
60,
145,
36,
46,
146,
237,
157,
null
],
[
"NU9Y7DKWYXX1B8HUGX0G",
"INE714H01019",
"FUTCURGBPINR27OCT2023",
"currency",
75,
1725667200000,
4500,
"buy",
21,
179,
65,
29,
21,
92,
124,
178,
153,
12,
null
],
[
"NU9Y7DKWYXX1B8HUGX0G",
"INE714H01019",
"FUTCURGBPINR27OCT2023",
"currency",
75,
1774239395461,
4509,
"sell",
15,
93,
151,
111,
104,
103,
55,
238,
153,
97,
null
],
[
"7BN92HT8TUYNDOW29YPQ",
"INE714H01019",
"FUTCURGBPINR27OCT2023",
"currency",
113,
1726185600000,
4492.367,
"buy",
57,
230,
240,
67,
116,
76,
6,
3,
169,
150,
null
],
[
"QRJDSFMYL79ULAWADZ4C",
"INE714H01019",
"FUTCURGBPINR27OCT2023",
"currency",
60,
1750448250099,
4499.876,
"sell",
145,
184,
130,
50,
35,
17,
90,
146,
149,
199,
null
],
[
"FZJQJNQWOJE78OSAKILB",
"INE714H01019",
"FUTCURGBPINR27OCT2023",
"currency",
43,
1770416893638,
5008.596,
"sell",
47,
22,
47,
31,
24,
32,
128,
195,
47,
87,
null
],
[
"BZAB3NIFLVXCEWLNXF0C",
"INE632P01025",
"FUTCURJPYINR24AUG2023",
"currency",
120,
1761818827953,
345.89,
"sell",
7,
203,
116,
18,
12,
64,
159,
151,
211,
148,
null
],
[
"EUCWBOWYUQF5LLS2MG9P",
"INE632P01025",
"FUTCURJPYINR24AUG2023",
"currency",
80,
1731788800000,
325.67,
"buy",
44,
87,
14,
179,
169,
178,
97,
26,
72,
170,
null
],
[
"EUCWBOWYUQF5LLS2MG9P",
"INE632P01025",
"FUTCURJPYINR24AUG2023",
"currency",
30,
1731788800000,
319.78,
"buy",
89,
205,
71,
145,
106,
166,
209,
67,
6,
124,
null
],
[
"MUYD0KEIED2TJLMOBKEM",
"INE632P01025",
"FUTCURJPYINR24AUG2023",
"currency",
40,
1746531637884,
329.587,
"sell",
59,
42,
140,
65,
52,
47,
80,
128,
39,
105,
null
],
[
"DROFW5LAACDWOCFKDQET",
"INE914J01012",
"BANKNIFTY01Jun2023FUT",
"equity",
45,
1758650011897,
450.09,
"sell",
111,
55,
14,
84,
291,
436,
146,
24,
168,
39,
null
],
[
"Y9V66LWUBLF8P2I8FDAR",
"INE519I01013",
"BANKNIFTY15Jun2023FUT",
"equity",
25,
1754476743732,
469.22,
"sell",
78,
91,
80,
41,
123,
291,
83,
151,
115,
11,
null
],
[
"2C7BGL8DLAEX6DMFGRTF",
"INE519I01013",
"BANKNIFTY15Jun2023FUT",
"equity",
25,
1768028851878,
425.3,
"sell",
22,
107,
62,
188,
249,
158,
117,
82,
21,
18,
null
],
[
"CJLNLY40ORWJXUKGVC8E",
"INE894N01016",
"NIFTY23JAN2023FUT",
"equity",
25,
1770550676537,
135.67,
"sell",
69,
101,
25,
74,
90,
300,
128,
21,
56,
3,
null
],
[
"GFHNW8Q8GH4F408UZQ0M",
"INE894N01017",
"NIFTY23JAN2023FUT",
"equity",
45,
1758588641252,
129.89,
"sell",
132,
88,
37,
24,
279,
212,
148,
43,
116,
26,
null
],
[
"LL4ESNCPAINCWUTVOYKX",
"INE894N01018",
"NIFTY23JAN2023FUT",
"equity",
50,
1760677372383,
147.89,
"sell",
53,
67,
8,
87,
63,
171,
86,
89,
83,
9,
null
],
[
"WI62KWVR0MYO0WXLDQ4J",
"INE694C01015",
"NIFTY23JAN2023FUT",
"equity",
80,
1764217116229,
150,
"sell",
10,
50,
68,
204,
60,
36,
24,
6,
43,
16,
null
],
[
"IJPDDNJO9BNNH0TB9NPJ",
"INE769A01020",
"FINNIFTY25JAN2023FUT",
"equity",
35,
1769566147929,
2568.98,
"sell",
132,
85,
15,
82,
101,
10,
152,
75,
46,
11,
null
],
[
"VLNYY0FTJTUGELL1TK8D",
"INE563D01013",
"NIFTY15JAN2023FUT",
"equity",
25,
1745530642634,
146,
"sell",
105,
53,
3,
114,
193,
397,
8,
2,
58,
43,
null
],
[
"VLNYY0FTJTUGELL1TK8D",
"INE563D01013",
"NIFTY15JAN2023FUT",
"equity",
75,
1746317962485,
158,
"sell",
54,
105,
28,
102,
11,
64,
41,
148,
143,
3,
null
],
[
"VY3TYTSPMWLYJQAEMGTZ",
"INE563D01013",
"NIFTY15JAN2023FUT",
"equity",
150,
1751020662630,
255,
"sell",
138,
32,
42,
214,
44,
13,
146,
43,
52,
35,
null
],
[
"YQT2WZWDNZPPCRDSQFR9",
"INE118D01016",
"NIFTY25JAN2023FUT",
"equity",
100,
1766329920870,
126.78,
"sell",
18,
23,
81,
239,
107,
183,
158,
64,
137,
50,
null
],
[
"9ZLDZGRMJBSSAIJTBTHN",
"INE002A01018",
"FINNIFTY15FEB2023FUT",
"equity",
155,
1766443698204,
174.55,
"sell",
130,
33,
69,
197,
298,
266,
24,
142,
9,
19,
null
],
[
"RHSYRUIXEC7M4HJBK46H",
"INE0C5901014",
"NIFTY23FEB2023FUT",
"equity",
55,
1755563901129,
174.8,
"sell",
111,
86,
26,
17,
303,
388,
149,
16,
53,
20,
null
],
[
"I3RI1TXUYSFLFU4N8IWZ",
"INE0C5901014",
"NIFTY23FEB2023FUT",
"equity",
120,
1770417584742,
210.89,
"sell",
115,
42,
78,
151,
292,
262,
98,
151,
37,
30,
null
],
[
"BYSC5G1EPZIWIJJ6BAUB",
"INE435D01014",
"BANKNIFTY20MAR2023FUT",
"equity",
125,
1749233214203,
615.89,
"sell",
101,
83,
15,
219,
125,
349,
140,
154,
129,
6,
null
],
[
"MWLF0LTSOJNEXKVXSGWN",
"INE0C5901014",
"NIFTY17APR2023FUT",
"equity",
135,
1762034908837,
489.67,
"sell",
132,
94,
74,
184,
190,
173,
30,
72,
61,
48,
null
],
[
"B67GMDMHCZAHJBXKDGL0",
"INE322R01014",
"FINNIFTY20MAY2023FUT",
"equity",
120,
1764485109621,
745.32,
"sell",
150,
13,
35,
133,
133,
362,
128,
119,
83,
39,
null
],
[
"DEN7PSRIFMQ0VQXZF8O8",
"INE694N01015",
"RIL15OCT2023FUT",
"equity",
50,
1764079239262,
615.35,
"sell",
99,
59,
84,
104,
322,
159,
92,
122,
136,
15,
null
],
[
"GAVL50RNZDGGQSMMLKOF",
"INE576G01015",
"INFY30OCT2023FUT",
"equity",
100,
1749645989739,
145,
"sell",
50,
96,
11,
84,
204,
220,
20,
125,
146,
23,
null
],
[
"BWQRBJTC2V55AFBIZPYW",
"INE197R01010",
"RIL31OCT2023FUT",
"equity",
250,
1749297629088,
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",
"BANKNIFTY01Jun2023CE44100",
"equity",
25,
1711756800000,
363.1,
"buy",
385,
201,
2235,
795,
1757,
202,
195,
2060,
2112,
1622,
null
],
[
"Y6W9FLHOVJ8TCHHNBYGF",
"INE545C01013",
"BANKNIFTY01Jun2023CE44200",
"equity",
75,
1714176000000,
363.15,
"buy",
2479,
304,
1657,
2282,
1170,
172,
1307,
1660,
1130,
1106,
null
],
[
"DML3WXXE53PJOTGTEYKJ",
"INE512D09106",
"OPTFUTCRUDEOIL16OCT20227000PE",
"commodity",
100,
1727731200000,
415,
"buy",
107,
8,
114,
111,
90,
43,
36,
48,
119,
21,
null
],
[
"GYHVDLIIXVTLROOCLVYG",
"INE579I01014",
"OPTCURUSDINR27JAN202383PE",
"currency",
135,
1728585600000,
90.69,
"buy",
134,
183,
209,
9,
100,
50,
202,
60,
140,
214,
null
],
[
"ULDR4PE639LOMU4A4VCE",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
75,
1728412800000,
1570,
"buy",
2122,
1793,
1820,
1893,
560,
1651,
875,
2161,
32,
1916,
null
],
[
"VIHCPUEYSZUMQUVPSJ1P",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
125,
1728979200000,
1490,
"buy",
114,
1074,
1522,
44,
1158,
535,
2252,
1115,
1171,
2449,
null
],
[
"QOO5OYJLQBIRUMIGKCIQ",
"INE769A01020",
"FINNIFTY25JAN2023CE12500",
"equity",
50,
1729756800000,
3450.67,
"buy",
831,
1827,
1117,
1814,
1230,
499,
1882,
2344,
457,
1850,
null
],
[
"2BOMU4R5WMEONKEI5YT6",
"INE563D01013",
"NIFTY23JAN2023CE15600",
"equity",
250,
1730620800000,
168,
"buy",
1280,
657,
1291,
1139,
636,
2397,
795,
1161,
2236,
1620,
null
],
[
"PZUTEFRTRX9LFW9DPHAW",
"INE118D01016",
"NIFTY23JAN2023CE15650",
"equity",
100,
1729584000000,
175.55,
"buy",
125,
882,
2432,
2077,
2189,
2472,
2156,
1856,
1068,
2285,
null
],
[
"DIQDEZH7K04QBDCJY0NV",
"INE002A01018",
"FINNIFTY15FEB2023CE13400",
"equity",
50,
1730707200000,
194.9,
"buy",
1645,
1807,
1262,
2482,
829,
782,
540,
1000,
354,
2491,
null
],
[
"PGR2RDEZFVC2S3YBX1JF",
"INE0C5901014",
"NIFTY23FEB2023PE17100",
"equity",
105,
1730828800000,
194.9,
"buy",
1760,
1640,
2143,
905,
1374,
1714,
842,
1776,
847,
299,
null
],
[
"TFCXQ3TKQRMOHU86MXO1",
"INE082B0101",
"BANKNIFTY20MAR2023PE18900",
"equity",
155,
1730950400000,
1500,
"buy",
104,
552,
1064,
2411,
1835,
2056,
2421,
2289,
651,
2315,
null
],
[
"DUYJ4ZV7OKJA8CV8U1MT",
"INE0C5901014",
"NIFTY17APR2023PE17800",
"equity",
55,
1731260800000,
457.89,
"buy",
1766,
2139,
1170,
2017,
723,
2101,
1756,
2357,
1517,
2394,
null
],
[
"2GFSS7XTAHUWHFZH0NBR",
"INE322R01014",
"FINNIFTY25MAY2023CE14900",
"equity",
130,
1731699200000,
698.03,
"buy",
682,
2191,
400,
1922,
813,
188,
1323,
188,
880,
1267,
null
],
[
"4AGDXGEEJOUHI6G8ATOU",
"INE694N01015",
"RELIANCEOCT1940CE",
"equity",
50,
1726963200000,
559.39,
"buy",
1244,
2104,
102,
1018,
319,
1497,
1669,
2059,
1901,
485,
null
],
[
"AHVDFMGBCECY1IR0QDH9",
"INE197R01010",
"RELIANCEOCT1960CE",
"equity",
175,
1728000000000,
1000,
"buy",
2181,
2407,
104,
398,
1577,
1341,
55,
1215,
1616,
879,
null
],
[
"Q2DZQ1ITYAOXILWQLHDN",
"INE576G01015",
"INFOSYSOCT2550CE",
"equity",
150,
1728518400000,
175,
"buy",
444,
1610,
769,
2289,
1456,
437,
1601,
620,
810,
1319,
null
],
[
"FQQ96BPTGAPAQPLMABNU",
"INE197R01010",
"RELIANCEOCT1920CE",
"equity",
250,
1728864000000,
186,
"buy",
1158,
1954,
1513,
2091,
1622,
1175,
383,
2049,
191,
1624,
null
],
[
"RKW88OVAQVWZMCD9VLJL",
"INE512R01010",
"INFOSYSOCT2590CE",
"equity",
225,
1729123200000,
180,
"buy",
874,
1430,
2384,
1648,
1398,
596,
367,
396,
1897,
1511,
null
],
[
"TTGYOR1EOA3SUTMNCJ58",
"INE512D09106",
"OPTFUTCRUDEOIL16OCT20227000PE",
"commodity",
25,
1772190392277,
423,
"sell",
106,
107,
78,
45,
79,
100,
14,
58,
70,
85,
null
],
[
"MYOFOBCC5W0PCWHVBFPU",
"INE512D09106",
"OPTFUTCRUDEOIL16OCT20227000PE",
"commodity",
50,
1728681600000,
456,
"buy",
80,
89,
33,
66,
61,
71,
116,
120,
55,
33,
null
],
[
"VIX3TEN3GZKPVY2WZCEX",
"INE512D09106",
"OPTFUTCRUDEOIL16OCT20227000PE",
"commodity",
125,
1753322058310,
449,
"sell",
4,
73,
78,
84,
113,
71,
1,
75,
118,
18,
null
],
[
"Q5CUBQ2P6B7VKNHCKWD6",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
50,
1729632000000,
135,
"buy",
237,
56,
15,
18,
104,
15,
22,
76,
89,
112,
null
],
[
"Q5CUBQ2P6B7VKNHCKWD6",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
80,
1729632000000,
142,
"buy",
188,
53,
11,
89,
31,
92,
119,
77,
58,
6,
null
],
[
"DTXGC9I0ZVOI2FFSHIOL",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
70,
1749669372484,
148,
"sell",
77,
57,
74,
83,
42,
83,
110,
104,
60,
102,
null
],
[
"DTXGC9I0ZVOI2FFSHIOL",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
30,
1754867768752,
150,
"sell",
187,
112,
77,
67,
93,
19,
84,
19,
54,
47,
null
],
[
"IU0HYP6ZN9EOERPBEWYA",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
140,
1730419200000,
137,
"buy",
234,
97,
29,
100,
39,
72,
49,
115,
110,
93,
null
],
[
"TAODZZPWWR9R5CO1QX0R",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
80,
1760702830207,
154,
"sell",
136,
76,
35,
49,
98,
56,
75,
2,
15,
75,
null
],
[
"TAODZZPWWR9R5CO1QX0R",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
20,
1732060800000,
153,
"buy",
211,
31,
34,
6,
18,
105,
104,
41,
67,
52,
null
],
[
"HVG5B4A45J9CL4CZ35TF",
"INE573G07017",
"OPTFUTSILVERM21Nov202258000PE",
"commodity",
130,
1747648985500,
156,
"sell",
110,
41,
105,
57,
47,
64,
63,
34,
46,
26,
null
],
[
"CJ7UKXJFK6WDVAUWGXGW",
"INE113J07012",
"OPTFUTGOLD29OCT202360000PE",
"commodity",
55,
1755112457295,
124.56,
"sell",
103,
48,
70,
111,
21,
40,
84,
69,
15,
16,
null
],
[
"EAU3BEIXICIMKLVWWU56",
"INE113J07012",
"OPTFUTGOLD29OCT202360000PE",
"commodity",
55,
1726272000000,
121,
"buy",
125,
52,
36,
22,
92,
17,
67,
79,
46,
109,
null
],
[
"OJDZI0SB29R3RMHWOG8P",
"INE113J07012",
"OPTFUTGOLD29NOV202361000PE",
"commodity",
85,
1728604800000,
135,
"buy",
212,
24,
78,
32,
52,
54,
7,
83,
8,
119,
null
],
[
"DOHDNKFFITQRMFUYKQLE",
"INE113J07012",
"OPTFUTGOLD29NOV202361000PE",
"commodity",
35,
1729036800000,
138,
"buy",
25,
89,
59,
114,
63,
56,
108,
2,
64,
35,
null
],
[
"CVWO1J0HIG9QEY5UVUDQ",
"INE113J07012",
"OPTFUTGOLD29NOV202361000PE",
"commodity",
90,
1767082414482,
142,
"sell",
108,
57,
19,
77,
25,
94,
115,
78,
71,
117,
null
],
[
"R2K5E791EH5VAQZVOETW",
"INE113J07012",
"OPTFUTGOLD29NOV202361000PE",
"commodity",
10,
1756305421265,
149,
"sell",
130,
3,
116,
15,
41,
119,
118,
26,
76,
77,
null
],
[
"GYHVDLIIXVTLROOCLVYG",
"INE579I01014",
"OPTCURUSDINR27JAN202383PE",
"currency",
145,
1728585600000,
87.45,
"buy",
212,
202,
223,
125,
116,
48,
71,
75,
100,
24,
null
],
[
"8VMAOKSBFKXAX1Z75UK5",
"INE579I01014",
"OPTCURUSDINR27JAN202383PE",
"currency",
165,
1744956653918,
94.78,
"sell",
177,
48,
234,
38,
176,
182,
159,
80,
200,
136,
null
],
[
"ZXORPEEJE7TVFBPXQ8LI",
"INE579I01014",
"OPTCURUSDINR27JAN202383PE",
"currency",
100,
1756783227749,
45.98,
"sell",
97,
219,
153,
19,
118,
231,
228,
31,
185,
186,
null
],
[
"ZXORPEEJE7TVFBPXQ8LI",
"INE579I01014",
"OPTCURUSDINR27JAN202383PE",
"currency",
15,
1745656580011,
78.3,
"sell",
94,
93,
127,
162,
79,
232,
149,
211,
83,
6,
null
],
[
"6MDVYEYUKHJXIQSGEOPU",
"INE645F01015",
"OPTCUREURINR13MAY202394CE",
"currency",
50,
1773690786760,
245.78,
"sell",
46,
228,
186,
237,
75,
6,
46,
97,
203,
34,
null
],
[
"CPYBETZOWLDVTAYF3PRA",
"INE645F01015",
"OPTCUREURINR13MAY202394CE",
"currency",
50,
1731174400000,
260.7,
"buy",
178,
162,
152,
207,
202,
185,
95,
232,
121,
209,
null
],
[
"MEHVXLLGPB5SODCHL5PT",
"INE645F01015",
"OPTCUREURINR13MAY202394CE",
"currency",
145,
1767623346855,
278,
"sell",
20,
164,
152,
121,
98,
148,
35,
194,
110,
34,
null
],
[
"UQCTRKWJRKXVR7LSIBCN",
"INE645F01015",
"OPTCUREURINR13MAY202394CE",
"currency",
145,
1711756800000,
289,
"buy",
25,
85,
159,
60,
145,
36,
46,
146,
237,
157,
null
],
[
"PIN8G2M1QKXY1FQZPRIF",
"INE714H01019",
"OPTCURGBPINR27OCT2023115PE",
"currency",
75,
1725667200000,
4500,
"buy",
21,
179,
65,
29,
21,
92,
124,
178,
153,
12,
null
],
[
"PIN8G2M1QKXY1FQZPRIF",
"INE714H01019",
"OPTCURGBPINR27OCT2023115PE",
"currency",
75,
1761192677238,
4509,
"sell",
15,
93,
151,
111,
104,
103,
55,
238,
153,
97,
null
],
[
"69WJ3BI70HPVKNLEK5TR",
"INE714H01019",
"OPTCURGBPINR27OCT2023115PE",
"currency",
113,
1726185600000,
4492.367,
"buy",
57,
230,
240,
67,
116,
76,
6,
3,
169,
150,
null
],
[
"P534DDQESQ6XNTI4NURV",
"INE714H01019",
"OPTCURGBPINR27OCT2023115PE",
"currency",
60,
1769948168912,
4499.876,
"sell",
145,
184,
130,
50,
35,
17,
90,
146,
149,
199,
null
],
[
"OXGR4W3D3MYYBURZOEJ5",
"INE714H01019",
"OPTCURGBPINR27OCT2023115PE",
"currency",
43,
1746712233880,
5008.596,
"sell",
47,
22,
47,
31,
24,
32,
128,
195,
47,
87,
null
],
[
"T6B8078DHAC9MGWPKR6B",
"INE632P01025",
"OPTCURJPYINR24AUG202345.6CE",
"currency",
120,
1756408554558,
345.89,
"sell",
7,
203,
116,
18,
12,
64,
159,
151,
211,
148,
null
],
[
"OFAILEZLEAPD9SU5ZOMT",
"INE632P01025",
"OPTCURJPYINR24AUG202345.6CE",
"currency",
80,
1731788800000,
325.67,
"buy",
44,
87,
14,
179,
169,
178,
97,
26,
72,
170,
null
],
[
"OFAILEZLHKPD8SU7ZOMT",
"INE632P01025",
"OPTCURJPYINR24AUG202345.6CE",
"currency",
30,
1731788800000,
319.78,
"buy",
89,
205,
71,
145,
106,
166,
209,
67,
6,
124,
null
],
[
"FDIT8EQR2XJFQJU2JLIG",
"INE632P01025",
"OPTCURJPYINR24AUG202345.6CE",
"currency",
40,
1745008531011,
329.587,
"sell",
59,
42,
140,
65,
52,
47,
80,
128,
39,
105,
null
],
[
"KLPAV9GOUCMPFH1WNKLV",
"INE619I01012",
"BANKNIFTY01Jun2023CE44100",
"equity",
25,
1743718310553,
450.09,
"sell",
1657,
1302,
325,
2118,
2050,
604,
2148,
626,
1489,
2090,
null
],
[
"0WNSDPGK4LTXO38HPTLU",
"INE545C01013",
"BANKNIFTY01Jun2023CE44200",
"equity",
25,
1751163508968,
469.22,
"sell",
1711,
1948,
2048,
700,
2360,
120,
2415,
333,
2231,
736,
null
],
[
"QS2KFCND5DJXRNDLLVHD",
"INE545C01013",
"BANKNIFTY01Jun2023CE44200",
"equity",
50,
1761590934853,
425.3,
"sell",
320,
375,
82,
1593,
1653,
620,
1637,
712,
542,
130,
null
],
[
"0B3PIU4WMIPKUQEG34BO",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
25,
1744864470570,
1460,
"sell",
499,
2262,
2210,
507,
256,
2293,
1125,
2345,
1852,
90,
null
],
[
"S7XOLPIQ2V4R5L89ZEE1",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
45,
1771172357246,
1508,
"sell",
1784,
825,
2087,
498,
666,
616,
1994,
763,
157,
2380,
null
],
[
"HSZA8B3XH3JC2POXMSXJ",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
50,
1749700715623,
1585,
"sell",
335,
1434,
254,
1609,
999,
1979,
2229,
127,
389,
1244,
null
],
[
"ILKEYGKTOHFQI5UXMBOO",
"INE512R02109",
"NIFTY23JAN2023CE15000",
"equity",
80,
1764221232709,
1635,
"sell",
208,
535,
279,
401,
2010,
248,
494,
746,
2399,
1196,
null
],
[
"A9HFP9X49AROF21K9KRY",
"INE769A01020",
"FINNIFTY25JAN2023CE12500",
"equity",
50,
1763440981795,
2568.98,
"sell",
319,
59,
25,
2409,
2339,
423,
132,
250,
2137,
2442,
null
],
[
"GHQTIWHDAFE90NOAU6ZY",
"INE563D01013",
"NIFTY23JAN2023CE15600",
"equity",
25,
1771143409491,
146,
"sell",
1525,
678,
749,
379,
277,
1791,
2288,
545,
1042,
327,
null
],
[
"GHQTIWHDAFE90NOAU6ZY",
"INE563D01013",
"NIFTY23JAN2023CE15600",
"equity",
75,
1774573228486,
158,
"sell",
1761,
2349,
1082,
2181,
1054,
1396,
856,
1220,
1740,
1791,
null
],
[
"IXMBK9LENH6CSGULION2",
"INE563D01013",
"NIFTY23JAN2023CE15600",
"equity",
150,
1761215243037,
255,
"sell",
2369,
875,
2202,
2488,
1574,
404,
532,
779,
2266,
1396,
null
],
[
"BEZ31FONIR1EQQI68F0Y",
"INE118D01016",
"NIFTY23JAN2023CE15650",
"equity",
100,
1744194826996,
126.78,
"sell",
288,
7,
2495,
1391,
1859,
28,
1298,
355,
1234,
1955,
null
],
[
"HMC8SXGWGNGWUTFBYRHX",
"INE002A01018",
"FINNIFTY15FEB2023CE13400",
"equity",
50,
1772245765781,
174.55,
"sell",
879,
2335,
1905,
1798,
456,
1765,
358,
1368,
1124,
1040,
null
],
[
"KQDQ54GEHLHTIUSPGAV6",
"INE0C5901014",
"NIFTY23FEB2023PE17100",
"equity",
55,
1750835577853,
174.8,
"sell",
181,
764,
1349,
1121,
2195,
2042,
1398,
1674,
164,
2244,
null
],
[
"SLB3JNRIBXSZWLRWP8ZZ",
"INE0C5901014",
"NIFTY23FEB2023PE17100",
"equity",
50,
1773265720214,
210.89,
"sell",
77,
713,
1563,
1666,
1745,
20,
528,
2500,
1068,
2008,
null
],
[
"LMQI22RLLZHQ5CWBGFYP",
"INE082B0101",
"BANKNIFTY20MAR2023PE18900",
"equity",
155,
1744940811350,
615.89,
"sell",
1842,
519,
2150,
997,
536,
1241,
2437,
765,
2481,
2126,
null
],
[
"71ZRU28BNR9F5FMOZS8V",
"INE0C5901014",
"NIFTY17APR2023PE17800",
"equity",
55,
1746783362527,
489.67,
"sell",
1519,
340,
2379,
190,
164,
2420,
662,
226,
1681,
722,
null
],
[
"PHGLBJWZZLIDKTTVLNQE",
"INE322R01014",
"FINNIFTY25MAY2023CE14900",
"equity",
120,
1759417387455,
745.32,
"sell",
820,
1114,
2137,
646,
2399,
2314,
160,
1817,
2092,
283,
null
],
[
"SEZD4CXXIXJ79ZS0GUQ2",
"INE694N01015",
"RELIANCEOCT1940CE",
"equity",
50,
1770860977415,
615.35,
"sell",
1797,
249,
1653,
2028,
897,
542,
1158,
2067,
964,
1393,
null
],
[
"UESSXHU0UHWCRJ1Z7LJR",
"INE576G01015",
"INFOSYSOCT2550CE",
"equity",
150,
1773024954910,
145,
"sell",
1204,
722,
1103,
2190,
1165,
1168,
597,
1485,
1127,
1175,
null
],
[
"TVSWJDGSX7VFVHA2AUXG",
"INE197R01010",
"RELIANCEOCT1920CE",
"equity",
250,
1752759372785,
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",
"HDFCCREDITRISKDEBTFUND-DIRECTPLAN",
"debt",
true,
true,
32.31,
1525824000000,
50,
"buy",
400,
10,
null
],
[
"BVNCH72LKDQY9RRINTGH",
"INF251K01NO3",
"BNPPARIBASLIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
37.216,
1589414400000,
10,
"buy",
0,
98,
null
],
[
"BNG57MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATALIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
19.574,
1515456000000,
120,
"buy",
5,
78,
null
],
[
"GJK45MYGKDQY9RRINTGH",
"INF278A06YE8",
"AdityaBirlaSunLifeMediumTermDirectPlanGrowth",
"debt",
true,
true,
36.023,
1493769600000,
30,
"buy",
10,
68,
null
],
[
"GHL909MYGKDQY9RRINTGH",
"INF200K01UT4",
"SBILIQUIDFUND-DIRECTPLAN",
"other",
true,
true,
35.014,
1437177600000,
15,
"buy",
17,
67,
null
],
[
"BHMGP79GKDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
35.706,
1626739200000,
60,
"buy",
65,
30,
null
],
[
"BLKMN98HJNMDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
36.062,
1563667200000,
60,
"buy",
120,
50,
null
],
[
"MJK88MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICIPrudentialCommodityFund",
"other",
true,
true,
35.039,
1626912000000,
400.784,
"buy",
200,
20,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INF179KB1HP9",
"HDFCLIQUIDFUND-DIRECTPLAN",
"equity",
true,
true,
25.68,
1556409600000,
459,
"buy",
220,
0.25,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
105.56,
1491436800000,
123,
"buy",
20,
25,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
550.34,
1491436800000,
124.5,
"buy",
20,
49,
null
],
[
"DFGR59NOHJDQ751TINTJK",
"INF179K01PT5",
"HDFCSmallCapFund",
"equity",
true,
true,
129,
1733760000000,
150,
"buy",
100,
32,
null
],
[
"DFGR59NOHJDQ751TINTJK",
"INF179K01PT5",
"HDFCSmallCapFund",
"equity",
true,
true,
100,
1733760000000,
250,
"buy",
100,
56,
null
],
[
"GHNR59NOHJDQ901TINTLK",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
156.78,
1481500800000,
150,
"buy",
160,
22,
null
],
[
"KNT59NOGKDQY897TINFTR",
"INF760K01FR2",
"CanaraRobecoBluechipEquityGrowthDirectPlan",
"equity",
true,
true,
155,
1576022400000,
23.78,
"buy",
25,
2,
null
],
[
"HJM98MYGKDQY9RRINGFB",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
35,
1374624000000,
200,
"buy",
180,
589,
null
],
[
"JMCU8MYGKDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
35,
1585008000000,
230,
"buy",
180,
37,
null
],
[
"GHN78NOGKDQY9YTINFGHY",
"INF200K01190",
"KOTAKSECFUND",
"equity",
true,
true,
50,
1633564800000,
980,
"buy",
800,
145,
null
],
[
"XCT59NOGKDQY9YTINFGRN",
"INF200K01190",
"KOTAKSECFUND",
"equity",
true,
true,
40,
1639872000000,
1000,
"buy",
800,
198,
null
],
[
"KGFCH72LKDQY9RRINTGH",
"INE397D01024",
"HDFCCREDITRISKDEBTFUND-DIRECTPLAN",
"debt",
true,
true,
32.31,
1758159468004,
900,
"sell",
1000,
89.658,
null
],
[
"KHF78MYGKDQY9RRINTGH",
"INF251K01NO3",
"BNPPARIBASLIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
17.823,
1766811844423,
5,
"sell",
0,
20,
null
],
[
"GHN78MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATALIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
36.711,
1758442592259,
160,
"sell",
5,
33.24,
null
],
[
"BHM88MYGKDQY9RRINTGH",
"INF278A06YE8",
"AdityaBirlaSunLifeMediumTermDirectPlanGrowth",
"debt",
true,
true,
36.023,
1761533937248,
60,
"sell",
10,
100,
null
],
[
"BHM88MTYH6QY9RRINTGH",
"INF200K01UT4",
"SBILIQUIDFUND-DIRECTPLAN",
"other",
true,
true,
19.88,
1768826225992,
60,
"sell",
17,
10,
null
],
[
"CVH78MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICIPrudentialCommodityFund",
"other",
true,
true,
32.531,
1771469391914,
200,
"sell",
200,
90,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INF179KB1HP9",
"HDFCLIQUIDFUND-DIRECTPLAN",
"equity",
true,
true,
25.68,
1774298905737,
500,
"sell",
220,
50,
null
],
[
"JHF78MYGKDQY9RRINTGH",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
355.9,
1747475787479,
212.7,
"sell",
20,
28,
null
],
[
"JTR59NOGKDQY9YTINTGH",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
250,
1749834306150,
209,
"sell",
20,
75,
null
],
[
"HNT59NOGKDQY897TINF4R",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
125,
1750955038501,
400,
"sell",
160,
89.658,
null
],
[
"HYT59NOGKDQY9YTINFGRN",
"INF760K01FR2",
"CanaraRobecoBluechipEquityGrowthDirectPlan",
"equity",
true,
true,
155,
1774141921111,
56.9,
"sell",
45,
2,
null
],
[
"RTV678MYGKDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
55,
1744528138656,
210,
"sell",
180,
56,
null
],
[
"VBN59NOGKDQY9YTINFGRN",
"INF200K01190",
"KOTAKSECFUND",
"equity",
true,
true,
40,
1763070425482,
1200,
"sell",
800,
230,
null
],
[
"67859NOGKDQY9YTINFGRN",
"INF200K01190",
"KOTAKSECFUND",
"equity",
true,
true,
50,
1763186904766,
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": [
[
"BVNCH72LKDQY9RRINTGH",
"INF251K01NO3",
"BNPPARIBASLIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
31.536,
1723132800000,
10,
"buy",
340,
92,
34,
93,
139,
17,
3,
68,
61,
48,
109,
null,
"delivery"
],
[
"BNG57MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATALIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
80,
1568160000000,
120,
"buy",
250,
127,
17,
108,
1,
26,
75,
33,
126,
113,
56,
null,
"delivery"
],
[
"BHM88MYGKDQY9RRINTGH",
"INF278A06YE8",
"AdityaBirlaSunLifeMediumTermDirectPlanGrowth",
"debt",
true,
true,
100,
1740336000000,
60,
"buy",
10,
88,
62,
132,
43,
111,
35,
4,
113,
61,
3,
null,
"delivery"
],
[
"BLKMN98HJNMDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
50,
1641427200000,
120.5877,
"buy",
65,
28,
17,
52,
65,
13,
40,
13,
40,
40,
28,
null,
"delivery"
],
[
"MJK88MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICIPrudentialCommodityFund",
"other",
true,
true,
150,
1627862400000,
400.784,
"buy",
200,
77,
59,
77,
12,
5,
2,
7,
10,
5,
30,
null,
"delivery"
],
[
"JNV5CHMYLKDQY9RRINTG",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
78,
1589414400000,
23,
"buy",
20,
106,
17,
123,
61,
31,
105,
24,
117,
16,
62,
null,
"delivery"
],
[
"PKF88MYGKDQY9RRINTGH",
"INF179K01PT5",
"HDFCSmallCapFund",
"equity",
true,
true,
90,
1515456000000,
150,
"buy",
100,
92,
43,
29,
90,
64,
70,
66,
51,
112,
117,
null,
"delivery"
],
[
"DFGR59NOHJDQ751TINTJK",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
95,
1493769600000,
150,
"buy",
160,
107,
98,
49,
143,
53,
73,
107,
52,
75,
56,
null,
"delivery"
],
[
"DFGR59NOHJDQ751TINTJK",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
50,
1493769600000,
400,
"buy",
160,
9,
60,
101,
40,
146,
3,
23,
125,
139,
82,
null,
"delivery"
],
[
"HJM98MYGKDQY9RRINGFB",
"INF179KB1QR8",
"ICICILIQUIDFUND-DIRECTPLAN",
"equity",
true,
true,
75,
1721664000000,
150,
"buy",
300,
61,
16,
25,
121,
50,
103,
148,
33,
75,
7,
null,
"delivery"
],
[
"KHF78MYGKDQY9RRINTGH",
"INF251K01NO3",
"BNPPARIBASLIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
31.536,
1748590909274,
5,
"sell",
340,
134,
111,
2,
96,
29,
36,
128,
104,
94,
101,
null,
"delivery"
],
[
"GHN78MYGKDQY9RRINTGH",
"INF277K01YE6",
"TATALIQUIDFUND-DIRECTPLAN",
"debt",
true,
true,
60,
1756246804345,
160,
"sell",
250,
60,
140,
15,
119,
139,
13,
18,
106,
10,
58,
null,
"delivery"
],
[
"GJK45MYGKDQY9RRINTGH",
"INF278A06YE8",
"AdityaBirlaSunLifeMediumTermDirectPlanGrowth",
"debt",
true,
true,
100,
1774372623141,
30,
"sell",
10,
123,
38,
8,
101,
111,
99,
103,
89,
43,
11,
null,
"delivery"
],
[
"BHMGP79GKDQY9RRINTGH",
"INF200K01189",
"SBIGoldFund",
"other",
true,
true,
50,
1756191021653,
60,
"sell",
65,
43,
59,
55,
9,
45,
50,
10,
17,
39,
22,
null,
"delivery"
],
[
"CVH78MYGKDQY9RRINTGH",
"INF109KB1GK2",
"ICICIPrudentialCommodityFund",
"other",
true,
true,
100,
1760828890202,
200,
"sell",
200,
72,
24,
22,
18,
57,
14,
17,
54,
32,
50,
null,
"delivery"
],
[
"GGFCHMYLKDQY9RRINTGH",
"INF846K01DI2",
"AxisBluechipFund",
"equity",
true,
true,
78,
1754178413427,
88,
"sell",
20,
79,
35,
65,
99,
120,
146,
115,
90,
100,
93,
null,
"delivery"
],
[
"PKF88MYGKDQY9RRINTGH",
"INF179K01PT5",
"HDFCSmallCapFund",
"equity",
true,
true,
90,
1769189188159,
250,
"sell",
100,
95,
105,
55,
104,
39,
74,
23,
26,
42,
142,
null,
"delivery"
],
[
"GHNR59NOHJDQ901TINTLK",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
30,
1771331886011,
450,
"sell",
160,
4,
82,
120,
71,
34,
38,
45,
2,
67,
98,
null,
"delivery"
],
[
"HNT59NOGKDQY897TINF4R",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
80,
1767442617551,
500,
"sell",
160,
36,
36,
69,
74,
139,
57,
75,
81,
118,
149,
null,
"delivery"
],
[
"KNT59NOGKDQY897TINFTR",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
10,
1757525424323,
10,
"sell",
160,
57,
141,
136,
4,
44,
47,
7,
119,
105,
138,
null,
"delivery"
],
[
"HYT59NOGKDQY9YTINFGRN",
"INF200K01OR6",
"SBIMagnumMulticapFund",
"equity",
true,
true,
10,
1757470844896,
50,
"sell",
160,
84,
38,
123,
61,
19,
8,
58,
18,
145,
85,
null,
"delivery"
]
]
}
]
},
{
"name": "bond_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "bond_tradebook_table",
"@entity": "table",
"header": [
"trade_id",
"isin",
"security_name",
"is_listed",
"is_stt_paid",
"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": [
[
"TGFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
500,
1738694400000,
10,
"buy",
31,
50,
13,
3,
23,
115,
100,
109,
56,
8,
null
],
[
"KGFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
500,
1741113600000,
10,
"buy",
121,
112,
21,
98,
33,
33,
113,
104,
98,
61,
null
],
[
"BVNCH72LKDQY9RRINTGH",
"INE272F07011",
"BlueDartExpress",
true,
true,
50,
1730832000000,
20,
"buy",
35,
112,
55,
9,
67,
13,
41,
75,
37,
5,
null
],
[
"BNG57MYGKDQY9RRINTGH",
"INE112J07020",
"IFCI",
true,
true,
200,
1733414400000,
16.55,
"buy",
78,
26,
27,
16,
23,
60,
45,
87,
118,
84,
null
],
[
"GJK45MYGKDQY9RRINTGH",
"INE130K08000",
"SBOX",
false,
false,
200,
1735574400000,
16.55,
"buy",
60,
16,
109,
81,
0,
80,
114,
63,
119,
84,
null
],
[
"GHL909MYGKDQY9RRINTGH",
"INE130K08001",
"QCK",
false,
false,
200,
1633996800000,
16.55,
"buy",
43,
127,
37,
52,
0,
86,
116,
46,
118,
84,
null
],
[
"BHMGP79GKDQY9RRINTGH",
"INE130K08012",
"GGL",
true,
true,
200,
1585008000000,
550,
"buy",
87,
21,
50,
5,
23,
71,
37,
22,
81,
106,
null
],
[
"MJK88MYGKDQY9RRINTGH",
"INE130K08019",
"APPL",
false,
false,
200,
1633564800000,
350,
"buy",
114,
12,
100,
114,
0,
51,
15,
37,
44,
108,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INE261F07055",
"SGB",
true,
true,
500,
1437177600000,
488,
"buy",
95,
69,
57,
104,
67,
77,
41,
38,
28,
101,
null
],
[
"GGFCHMYLKDQY9RRINTGH",
"INE261F07055",
"SGB",
true,
true,
500,
1626652800000,
322,
"buy",
22,
51,
38,
76,
12,
101,
87,
53,
77,
4,
null
],
[
"JHF78MYGKDQY9RRINTGH",
"INE261F07055",
"SGB",
true,
true,
100,
1626739200000,
350,
"buy",
11,
26,
86,
34,
23,
107,
43,
1,
101,
6,
null
],
[
"KHF78MYGKDQY9RRINTGH",
"INE272F07011",
"BlueDartExpress",
true,
true,
20,
1772737689039,
200,
"sell",
108,
4,
102,
57,
33,
11,
105,
16,
56,
86,
null
],
[
"GHN78MYGKDQY9RRINTGH",
"INE112J07020",
"IFCI",
true,
true,
170,
1768142143586,
500,
"sell",
71,
109,
99,
30,
67,
11,
126,
102,
18,
24,
null
],
[
"BHM88MYGKDQY9RRINTGH",
"INE130K08000",
"SBOX",
false,
false,
170,
1747811650141,
500,
"sell",
78,
99,
8,
16,
0,
9,
102,
63,
100,
31,
null
],
[
"BHM88MTYH6QY9RRINTGH",
"INE130K08001",
"QCK",
false,
false,
200,
1772784887881,
500,
"sell",
48,
128,
1,
120,
0,
112,
20,
79,
115,
74,
null
],
[
"BLKMN98HJNMDQY9RRINTGH",
"INE130K08015",
"GGL",
true,
true,
200,
1760544844289,
600,
"sell",
37,
85,
53,
113,
67,
102,
42,
48,
31,
15,
null
],
[
"CVH78MYGKDQY9RRINTGH",
"INE130K08019",
"APPL",
false,
false,
180,
1772665028030,
310,
"sell",
112,
109,
45,
32,
0,
49,
53,
47,
124,
111,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
500,
1748478931773,
125,
"sell",
15,
26,
86,
64,
33,
56,
26,
30,
21,
125,
null
],
[
"GMFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
500,
1750415876039,
125,
"sell",
76,
101,
104,
28,
67,
127,
21,
26,
88,
70,
null
],
[
"JTR59NOGKDQY9YTINTGH",
"INE261F07055",
"SGB",
true,
true,
550,
1761741616537,
350,
"sell",
107,
97,
94,
49,
12,
49,
9,
112,
69,
129,
null
],
[
"DFGR59NOHJDQ751TINTJK",
"INE261F07055",
"SGB",
true,
true,
50,
1762949787971,
400,
"sell",
80,
10,
130,
58,
44,
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",
"is_stt_paid",
"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",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
1000,
1525824000000,
10,
"buy",
177,
180,
238,
105,
105,
243,
101,
131,
187,
104,
null
],
[
"DML3WXXE53PJOTGTEYKJ",
"INE272F07011",
"BlueDartExpress",
true,
true,
50,
1589414400000,
20,
"buy",
61,
48,
59,
117,
117,
236,
125,
232,
240,
106,
null
],
[
"ULDR4PE639LOMU4A4VCE",
"INE112J07020",
"IFCI",
true,
true,
200,
1515456000000,
16.55,
"buy",
74,
176,
232,
177,
177,
230,
53,
210,
110,
125,
null
],
[
"QOO5OYJLQBIRUMIGKCIQ",
"INE130K08000",
"SBOX",
false,
false,
200,
1493769600000,
16.55,
"buy",
108,
88,
142,
17,
0,
130,
214,
66,
207,
179,
null
],
[
"PZUTEFRTRX9LFW9DPHAW",
"INE130K08001",
"QCK",
false,
false,
200,
1437177600000,
16.55,
"buy",
133,
242,
225,
166,
0,
45,
232,
127,
64,
210,
null
],
[
"PGR2RDEZFVC2S3YBX1JF",
"INE130K08012",
"GGL",
true,
true,
200,
1626739200000,
550,
"buy",
157,
86,
208,
79,
79,
180,
94,
158,
38,
191,
null
],
[
"DUYJ4ZV7OKJA8CV8U1MT",
"INE130K08019",
"APPL",
false,
false,
200,
1626912000000,
350,
"buy",
215,
228,
8,
98,
0,
119,
44,
185,
50,
154,
null
],
[
"4AGDXGEEJOUHI6G8ATOU",
"INE261F07055",
"SGB",
true,
true,
500,
1556409600000,
600,
"buy",
220,
239,
134,
180,
180,
58,
131,
160,
117,
207,
null
],
[
"AHVDFMGBCECY1IR0QDH9",
"INE261F07055",
"SGB",
true,
true,
500,
1556409600000,
764,
"buy",
159,
38,
58,
8,
8,
34,
12,
202,
103,
31,
null
],
[
"Q2DZQ1ITYAOXILWQLHDN",
"INE261F07055",
"SGB",
true,
true,
100,
1491436800000,
890,
"buy",
189,
118,
196,
90,
90,
161,
199,
36,
138,
50,
null
],
[
"Y6W9FLHOVJ8TCHHNBYGF",
"INE261F07032",
"07.64%NABARDTFB2031",
true,
true,
1000,
1764583887544,
10,
"sell",
224,
48,
219,
210,
210,
51,
234,
197,
66,
220,
null
],
[
"GYHVDLIIXVTLROOCLVYG",
"INE272F07011",
"BlueDartExpress",
true,
true,
20,
1759301230685,
200,
"sell",
151,
188,
89,
94,
94,
45,
54,
58,
220,
6,
null
],
[
"VIHCPUEYSZUMQUVPSJ1P",
"INE112J07020",
"IFCI",
true,
true,
170,
1751520034430,
500,
"sell",
129,
82,
120,
187,
187,
110,
174,
71,
160,
42,
null
],
[
"2BOMU4R5WMEONKEI5YT6",
"INE130K08000",
"SBOX",
false,
false,
170,
1746115966803,
500,
"sell",
97,
118,
33,
9,
0,
151,
6,
38,
52,
40,
null
],
[
"DIQDEZH7K04QBDCJY0NV",
"INE130K08001",
"QCK",
false,
false,
200,
1748304011006,
500,
"sell",
78,
112,
194,
9,
0,
128,
114,
154,
68,
207,
null
],
[
"TFCXQ3TKQRMOHU86MXO1",
"INE130K08015",
"GGL",
true,
true,
200,
1772120698642,
600,
"sell",
103,
56,
160,
203,
203,
240,
171,
239,
71,
42,
null
],
[
"2GFSS7XTAHUWHFZH0NBR",
"INE130K08019",
"APPL",
false,
false,
180,
1771070135804,
310,
"sell",
12,
204,
93,
133,
0,
63,
206,
65,
13,
167,
null
],
[
"FQQ96BPTGAPAQPLMABNU",
"INE261F07055",
"SGB",
true,
true,
550,
1743557101246,
789,
"sell",
52,
8,
14,
119,
119,
231,
1,
246,
128,
155,
null
],
[
"RKW88OVAQVWZMCD9VLJL",
"INE261F07055",
"SGB",
true,
true,
50,
1758463330011,
890,
"sell",
139,
196,
103,
96,
96,
207,
102,
68,
229,
5,
null
]
]
}
]
}
]
}
'Copy
{
"code": 200,
"data": {
"@entity": "in.co.sandbox.it.calculator.pnl.securities.job",
"job_id": "0d931fe5-5a9f-4e6d-bde7-c28d95e00706",
"url": "https://in-co-sandbox-it-calculator-pnl-securities-dev.s3.ap-south-1.amazonaws.com/domestic/0d931fe5-5a9f-4e6d-bde7-c28d95e00706/workbook.input?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIARB4EOKMVFH7274FA%2F20250121%2Fap-south-1%2Fs3%2Faws4_request&X-Amz-Date=20250121T074117Z&X-Amz-Expires=86400&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCmFwLXNvdXRoLTEiRzBFAiBo4d6JJUm9E1HtYb4hX3h2vzPCCP9yuYnDkDh0Fab6lAIhAJ782GssR5yycAc6hhQS7vx1QWTrF6KSRttFVvp6uyE5KrsDCLn%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQABoMMDcyNzU1MzM1OTc4IgyVC5e1MNp9kpK1QdYqjwMKV4QWxEac3TF2zvsq3GAjnji8B4fuMNdmMSRTZi3BtWUPnylGKPb7l%2FK%2BD0t0RxMPaBpspPsXSGZK%2FiZ3cGXmvDbCE808bCUwsz2N33ebir7dh%2FmSjvntRotmZqrJW4KFirU1vWBEDbeleDQAlV3GNvT5JUp%2FjId4p%2FqAqMRAUWKfwRq7Ud6%2BFztZbeteOzl4GIgsRP%2Bm7NS8y06YcVE2ZcKuA2WprBbR1mKsreqKzvxw5PTZQztHGzJO5IBFM7rSPSfn6TowRgkf2Q9pTbsh2rG7BJZklcbe%2BiYG9gXOfbeFX66m1R7OKWS7XgVi%2BtzRG5YMxaBrgzfCcYbJZswECXnpdSm7ne1sM%2FPJnAtgLaStc%2F1VOQCf7oq0tmnamRgo8uou1VwrhD9oDcLXMbvujOg2QcKJgDw2Tag%2FCYIq57KugDZUgWmeOmzp61CumxeYjpfDCV6zK6%2F5DIGJrUTjJV%2BsotVROVXMv679h1QOULzRVYKiNMqgrTNB%2FbaWiQS0qwGI7RrmtPJIXDWKELIwg5q9vAY6ngGG0lHpUoSm2g9f9663xtOYvjFmVCNr%2FgReV%2BNurV%2BGZTXTW6N6TpzwKz%2FRUJEJHhU27mawtDCfZ6VU5XvGR1vo6uTqHNnWO2QPNcV7IRZqObtdqLb%2BUcwSGpyLBWECTFNiaxzdZskxOvgT%2FmgiINKszi%2FquANPf%2BdB1vIGXfkkgomiZu54mcw0QVcVogyXyAZQxy677eaTDTWVPTDCAg%3D%3D&X-Amz-Signature=ea0297aa89e8f5d9e04ee4aa0a5d5860b9bb8b207573b213c0f12e904c4f4675&X-Amz-SignedHeaders=host&x-id=PutObject",
"type": "pnl",
"created_at": 1737445277235,
"updated_at": 1737445277235
},
"transaction_id": "0d931fe5-5a9f-4e6d-bde7-c28d95e00706",
"timestamp": 1737445277097
}Headers
application/json or application/xlsx
Your API key used to authenticate and authorize the request.
Query Parameters
Start timestamp (inclusive) for the P&L calculation period, expressed as Unix epoch time in milliseconds.
Required range:
x >= 0End timestamp (inclusive) for the P&L calculation period, expressed as Unix epoch time in milliseconds.
Type of input file. Allowed values: tradewise_settlement or tradebook.
Available options:
tradebook Type of output file. Allowed values: tradewise_pnl or scripwise_pnl
Available options:
tradewise_pnl, scripwise_pnl Was this page helpful?
āI