Tradebook Payload
Tradebook provides you with all the trades that have been executed by an investor or trader. Brokers can use Tradebook to calculate Tax P&L using APIs.
Equity Tradebook
The headers are explained below:
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of equity share |
| is_listed | boolean | Yes | is the equity share listed in public markets |
| is_stt_paid | boolean | Yes | was security transaction tax paid on this trade |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | The unit price of the equity share |
| transaction_type | string | Yes | Indicates whether the order is :buy , sell, send, receive Or trade, |
| fmv | number | No | Fare market value of the equity share as on 31/01/2018 |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax |
| stamp_duty | number | No | Stamp duty paid on transfer of shares |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of shares |
| label | string | No | Refer to label for possible values |
ETF Tradebook
The headers are explained below:
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | Yes | ISIN is the international security identification number |
| scheme_name | string | Yes | Symbol or name of fund |
| asset_class | string | Yes | Asset class of fund, possible valuesequity, debt, other |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp in millis |
| price | number | Yes | Transaction price |
| transaction_type | string | Yes | Indicates whether the order is :buy , sell, send, receive Or trade, |
| fmv | number | No | Fare market value of the mutual fund unit as on 31/01/2018 |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax |
| stamp_duty | number | No | Stamp duty paid on transfer of fund units |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer fund units |
| label | string | No | Refer to label for possible values |
Mutual Fund Tradebook
The headers are explained below:
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | Yes | ISIN is the international security identification number |
| scheme_name | string | Yes | Symbol or name of mutual fund |
| asset_class | string | Yes | Asset class of fund, possible valuesequity, debt, other |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp in millis |
| price | number | Yes | Transaction price |
| transaction_type | string | Yes | Indicates whether the order is :buy , sell, send, receive Or trade, |
| fmv | number | No | Fare market value of the mutual fund unit as on 31/01/2018 |
| transfer_expenses | number | No | Any other expense relating to the transfer of fund units |
| label | string | No | Refer to label for possible values |
Futures Trade
The headers are explained below:
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| contract_name | string | Yes | Name of contract |
| asset_class | string | Yes | The asset class of the contract. Possible valuesequity, currency & commodity |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | Transaction price |
| transaction_type | string | Yes | Indicates whether the order is :buy Or sell, |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax |
| stamp_duty | number | No | Stamp duty paid on transfer of contract |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of the contract |
| label | string | No | Refer to label for possible values |
Options Trade
The headers are explained below:
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| contract_name | string | Yes | Name of contract |
| asset_class | string | Yes | The asset class of the contract. Possible valuesequity, currency & commodity |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | Transaction price |
| transaction_type | string | Yes | Indicates whether the order is :buy Or sell, |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax |
| stamp_duty | number | No | Stamp duty paid on transfer of contract |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of the contract |
| label | string | No | Refer to label for possible values |
Bonds Tradebook
The headers are explained below:
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | Yes | ISIN is the international security identification number |
| security_name | string | Yes | Symbol or description of bond |
| is_listed | boolean | Yes | is the equity share listed in public markets |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp in millis |
| price | number | Yes | The unit price of the bond |
| transaction_type | string | Yes | Indicates whether the order is :buy , sell, send, receive Or trade, |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stamp_duty | number | No | Stamp duty paid on transfer of bonds |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of bonds |
| label | string | No | Refer to label for possible values |
Debentures Tradebook
The headers are explained below:
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | Yes | ISIN is the international security identification number |
| security_name | string | Yes | Symbol or description of debenture |
| is_listed | boolean | Yes | is the equity share listed in public markets |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp in millis |
| price | number | Yes | The unit price of the debenture |
| transaction_type | string | Yes | Indicates whether the order is :buy , sell, send, receive Or trade, |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stamp_duty | number | No | Stamp duty paid on transfer of debentures |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of debentures |
| label | string | No | Refer to label for possible values |
Sample Payload
{
"@entity": "workbook",
"name": "tradebook_workbook",
"sheets": [
{
"name": "equity_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"name": "equity_tradebook_table",
"header": [
"trade_id",
"isin",
"symbol",
"is_listed",
"is_stt_paid",
"quantity",
"date",
"price",
"transaction_type",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"label"
],
"rows": [
[
"1a",
"INE002A01019",
"AJANTA PHARMA LIMITED",
true,
false,
33,
1483488000000,
200,
"buy",
645,
94,
0,
0,
0,
0,
4,
0,
0,
0,
0
],
[
"2a",
"INE002A01019",
"AJANTA PHARMA LIMITED",
true,
true,
16,
1486166400000,
911,
"send",
989,
85,
0,
0,
0,
6,
0,
0,
0,
0,
0,
"buy_back"
],
[
"4a",
"INE190B01019",
"HINDUJA GLOBAL SOLS. LTD.",
true,
true,
53,
1641556800000,
56,
"buy",
0,
0,
0,
0,
0,
0,
3,
0,
0,
0,
0
],
[
"19a",
"INE190B01019",
"HINDUJA GLOBAL SOLS. LTD.",
true,
true,
53,
1641520800000,
58,
"sell",
0,
0,
0,
0,
0,
0,
3,
0,
0,
0,
0
],
[
"5a",
"INE190A01019",
"ITC LTD",
false,
true,
31,
1641600000000,
346,
"buy",
382,
98,
5,
0,
0,
6,
0,
0,
0,
0,
0
],
[
"7a",
"INE190A01019",
"ITC LTD",
false,
true,
20,
1641772800000,
522,
"send",
382,
74,
0,
0,
0,
6,
3,
0,
0,
0,
0,
"transfer"
],
[
"8a",
"INE190001019",
"NIP IND ETF GOLD BEES",
true,
true,
75,
1547078400000,
314,
"receive",
300,
74,
0,
54,
0,
6,
3,
0,
0,
0,
0,
"transfer"
],
[
"23a",
"INE190001019",
"NIP IND ETF GOLD BEES",
true,
true,
75,
1672531200000,
0,
"send",
0,
74,
0,
54,
0,
6,
3,
0,
0,
0,
0,
"lost"
],
[
"24a",
"INE190B01020",
"RIL",
true,
false,
30,
1644624000000,
500,
"receive",
350,
0,
0,
0,
5,
6,
0,
0,
0,
0,
0,
"gift"
],
[
"24a",
"INE190B01020",
"RIL",
true,
false,
10,
1644624000000,
500,
"buy",
350,
0,
0,
0,
5,
6,
0,
0,
0,
0,
0
],
[
"25a",
"INE190B01027",
"INFY",
true,
true,
7,
1577836800000,
250,
"buy",
350,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"26a",
"INE190B01027",
"INFY",
true,
true,
8,
1609459200000,
275,
"send",
350,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
"gift"
],
[
"27a",
"INE190B01027",
"INFY",
true,
true,
9,
1641033000000,
300,
"buy",
350,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"27a",
"INE190B01027",
"INFY",
true,
true,
1,
1641033300000,
300,
"buy",
350,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"30a",
"INE190B01027",
"INFY",
true,
true,
5,
1641034800000,
305,
"sell",
350,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"31a",
"INE190B01027",
"INFY",
true,
true,
3,
1672531200000,
390,
"sell",
350,
9,
0,
5,
2,
6,
0,
0,
0.12,
0.3,
1
],
[
"31a",
"INE190B01027",
"INFY",
true,
true,
3,
1672531200000,
390,
"sell",
350,
10,
2,
0,
8,
2,
0,
0.11,
0,
0,
2
],
[
null,
"INE190B01037",
"BAJFIN",
true,
true,
90,
1184976000000,
500,
"buy",
490,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"33a",
"INE190B01037",
"BAJFIN",
true,
true,
10,
1184976000000,
500,
"buy",
490,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"40a",
"INE190B01037",
"BAJFIN",
true,
true,
30,
1942358400000,
540,
"buy",
490,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"45a",
"INE190B01037",
"BAJFIN",
true,
true,
95,
1742688000000,
600,
"sell",
490,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"99a",
"INE190B01033",
"TCS",
true,
true,
10,
1672531200000,
1000,
"sell",
600,
10,
2,
0,
8,
2,
0,
0.11,
0,
0,
2
]
]
}
]
},
{
"name": "mutual_fund_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"name": "mutual_fund_tradebook_table",
"header": [
"trade_id",
"isin",
"scheme_name",
"asset_class",
"quantity",
"date",
"price",
"transaction_type",
"fmv",
"transfer_expenses",
"label"
],
"rows": [
[
"9832q",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
32.31,
1654646400000,
900,
"sell",
1000,
89.658
],
[
"65412a",
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
37.216,
1650412800000,
10,
"buy",
0,
0
],
[
"14712a",
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
17.823,
1650412800000,
5,
"sell",
0,
20
],
[
"15545a",
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
19.574,
1682812800000,
120,
"buy",
5,
78
],
[
"89741a",
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
36.711,
1685404800000,
160,
"sell",
5,
33.24
],
[
"24896a",
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
36.023,
1682812800000,
30,
"buy",
10,
68
],
[
"41564a",
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
36.062,
1686009600000,
60,
"sell",
10,
100
],
[
"5544a",
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
35.014,
944956800000,
15,
"buy",
17,
2
],
[
"165a",
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
0.123,
1648684800000,
60,
"sell",
17,
10
],
[
"58s87",
"INF200K01189",
"SBI Gold Fund",
"other",
35.706,
1513036800000,
60,
"buy",
65,
30
],
[
"58s87",
"INF200K01189",
"SBI Gold Fund",
"other",
36.062,
1513036800000,
60,
"buy",
120,
50
],
[
"5411b",
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
35.039,
1584662400000,
400.784,
"buy",
200,
20
],
[
"4586w",
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
32.531,
1647993600000,
200,
"sell",
200,
5
],
[
"2154b",
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
25.68,
1118016000000,
2,
"buy",
220,
0.005
],
[
"1324h",
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
6.651,
1654646400000,
500,
"sell",
220,
50
],
[
"5187q",
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
31.959,
1525392000000,
23,
"buy",
20,
8
],
[
"5481j",
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
33.003,
1525392000000,
24,
"buy",
20,
12
],
[
"3212k",
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
33.807,
1620086400000,
150,
"receive",
100,
32,
"gift"
],
[
"9824b",
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
34.211,
1620172800000,
250,
"send",
100,
12,
"lost"
],
[
"4458l",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
22.253,
1497225600000,
150,
"buy",
160,
22
],
[
"4651z",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
11.338,
1686528000000,
400,
"sell",
160,
89.658
],
[
"999j",
"INF760K01FR2",
"Canara Robeco Bluechip Equity Growth Direct Plan",
"equity",
109.722,
1505865600000,
23.21,
"buy",
25,
2
],
[
"101q",
"INF760K01FR2",
"Canara Robeco Bluechip Equity Growth Direct Plan",
"equity",
45.57,
1648771200000,
23.21,
"sell",
45,
2
],
[
"123q",
"INF200K01189",
"SBI Gold Fund",
"other",
35,
1648814400000,
200,
"buy",
180,
2
],
[
"123q",
"INF200K01189",
"SBI Gold Fund",
"other",
35,
1648774800000,
200,
"buy",
180,
2
],
[
"230f",
"INF200K01189",
"SBI Gold Fund",
"other",
35,
1648778400000,
210,
"send",
180,
null,
"gift"
],
[
"488k",
"INF200K01190",
"KOTAK SEC FUND",
"equity",
50,
1505865600000,
980,
"buy",
800,
null
],
[
"480k",
"INF200K01190",
"KOTAK SEC FUND",
"equity",
40,
1505952000000,
1000,
"receive",
800,
null,
"transfer"
],
[
"500o",
"INF200K01190",
"KOTAK SEC FUND",
"equity",
40,
1513814400000,
1200,
"buy",
800,
1
],
[
"500i",
"INF200K01190",
"KOTAK SEC FUND",
"equity",
75,
1640044800000,
1300,
"sell",
800,
1
]
]
}
]
},
{
"name": "etf_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"name": "etf_tradebook_table",
"header": [
"trade_id",
"isin",
"scheme_name",
"asset_class",
"quantity",
"date",
"price",
"transaction_type",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"corporate_action"
],
"rows": [
[
"15648a",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
250,
1118016000000,
50,
"buy",
400,
0,
0,
0,
0,
5,
0,
18,
18,
0,
0
],
[
"15648a",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
250,
1659744000000,
600,
"sell",
400,
0,
0,
0,
0,
12,
25,
18,
18,
0,
0
],
[
"65412a",
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
31.536,
1621468800000,
10,
"buy",
0,
2,
0,
0,
0,
54,
0,
18,
18,
0,
0
],
[
"14712a",
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
30.739,
1650412800000,
5,
"sell",
0,
8,
0,
0,
0,
1,
0,
0,
18,
18,
0
],
[
"15545a",
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
80,
1682812800000,
120,
"buy",
5,
3,
0,
0,
0,
25,
0,
0,
18,
18,
0
],
[
"89741a",
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
60,
1685404800000,
160,
"sell",
5,
2,
0,
0,
9,
0.546,
0,
0,
18,
18,
0
],
[
"24896a",
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
100,
1682812800000,
30,
"buy",
10,
0,
0,
2,
0,
0.458,
0,
0,
18,
18,
0
],
[
"41564a",
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
100,
1781049600000,
60,
"sell",
10,
0,
10,
0,
0,
10,
0,
0,
18,
18,
0
],
[
"5544a",
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
20,
1513036800000,
15,
"buy",
17,
0.1,
1,
0.5,
0,
33,
0.001,
0,
18,
18,
0
],
[
"165a",
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
20,
1648684800000,
60,
"sell",
17,
0.223,
1,
0.5,
0,
4,
0.001,
0,
18,
18,
0
],
[
"58s87",
"INF200K01189",
"SBI Gold Fund",
"other",
50,
1513036800000,
60,
"buy",
65,
0.58,
1,
0.5,
0,
68,
0.001,
0,
18,
18,
0
],
[
"8784a",
"INF200K01189",
"SBI Gold Fund",
"other",
45.5488,
1654128000000,
120.5877,
"sell",
65,
2,
1,
0.5,
0,
89,
0.001,
0,
18,
18,
0
],
[
"5411b",
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
20,
1584662400000,
400.784,
"buy",
200,
0.544,
1,
0.5,
0,
12.5,
0.001,
0,
18,
18,
0
],
[
"4586w",
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
20,
1647993600000,
200,
"sell",
200,
6.54987,
1,
0.5,
0,
0.57,
0.001,
0,
18,
18,
0
],
[
"2154b",
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
101.5487,
1118016000000,
2,
"buy",
220,
2.54564,
1,
0.5,
0,
5.26,
0.001,
0,
18,
18,
0
],
[
"1324h",
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
99.78,
1659744000000,
500,
"sell",
220,
2.47213,
1,
0.5,
0,
3.245,
0.001,
0,
18,
18,
0
],
[
"5187q",
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
78,
1522886400000,
23,
"buy",
20,
6,
1,
0.5,
0,
2.677,
0.001,
18,
18,
0,
0
],
[
"5481j",
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
78,
1680652800000,
88,
"sell",
20,
2.5559,
1,
0.5,
0,
0.25468,
0.001,
18,
18,
0,
0
],
[
"3212k",
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
90,
1617580800000,
150,
"buy",
100,
3.3265,
1,
0.5,
0,
2.446,
0.001,
18,
18,
0,
0
],
[
"9824b",
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
90,
1620172800000,
250,
"sell",
100,
2.67456,
1,
0.5,
0,
3,
0.001,
18,
18,
0,
0
],
[
"4458l",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
95,
1512518400000,
150,
"buy",
160,
2.1423,
1,
0.5,
0,
10,
0.001,
18,
18,
0,
0
],
[
"4651z",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
50,
1670292000000,
400,
"buy",
160,
1.111,
1,
0.5,
0,
15,
0.001,
18,
18,
0,
0
],
[
"4651z",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
30,
1670292000000,
400,
"buy",
160,
1.111,
1,
0.5,
0,
15,
0.001,
18,
18,
0,
0
],
[
"302i",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
30,
1670295600000,
12,
"sell",
160,
1.111,
1,
0.5,
0,
15,
null,
null,
null,
null,
null
],
[
"302v",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
10,
1670295601000,
10,
"sell",
160,
1.111,
1,
0.5,
0,
15,
null,
null,
null,
null,
null
],
[
"939j",
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
30,
1680220800000,
50,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
null,
null
],
[
"131sa",
"INF179KB1QR8",
"ICICI LIQUID FUND - DIRECT PLAN",
"equity",
75,
1659744000000,
100,
"sell",
300,
2.47213,
1,
0.5,
0,
3.245,
0.001,
0,
18,
18,
0
]
]
}
]
},
{
"name": "options_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"name": "options_tradebook_table",
"header": [
"trade_id",
"contract_name",
"asset_class",
"quantity",
"date",
"price",
"transaction_type",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"label"
],
"rows": [
[
"12345a",
"CRUDE21APR14700CE",
"Commodity",
75,
1292889600000,
363.1,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"54321a",
"USD21APR14700CE",
"Currency",
75,
1522368000000,
363.15,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"54612a",
"FINNIFTY21MAYFUT",
"Equity",
40,
1199750400000,
15700,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"15484a",
"NIFTY21JUN17500CE",
"Equity",
75,
1609459200000,
4.55,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"456789a",
"NIFTY21JUN15800CE",
"Equity",
75,
1546646400000,
168,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"678901a",
"NIFTY21JUN15800CE",
"Equity",
75,
1546646400000,
175.55,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"789012a",
"CRUDE21APR14700CE",
"Commodity",
75,
1292889600000,
194.9,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"890123a",
"USD21APR14700CE",
"Currency",
75,
1515024000000,
194.9,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"123098a",
"FINNIFTY21MAYFUT",
"Equity",
40,
1199923200000,
1500,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"345876a",
"NIFTY21JUN17500CE",
"Equity",
75,
1640995200000,
0,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"333444a",
"NIFTY21JUN15800CE",
"Equity",
75,
1546732800000,
0,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"888000a",
"NIFTY21JUN15800CE",
"Equity",
75,
1546819200000,
0,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"888000q",
"NIFTY21JULY15800CE",
"Equity",
75,
1673049600000,
1000,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
null,
"NIFTY21Jan15800CE",
"Equity",
75,
1662719400000,
175,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
null
],
[
"893289a",
"NIFTY21Jan15800CE",
"Equity",
75,
1662721200000,
175,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
null
],
[
"892398k",
"NIFTY21Jan15800CE",
"Equity",
75,
1662723000000,
180,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"985949d",
"ONE-PUT",
"Commodity",
50,
1654300800000,
600,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"382983a",
"ONE-PUT",
"Commodity",
50,
1656126000000,
666,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"382983a",
"ONE-PUT",
"Commodity",
50,
1656127200000,
660,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"344324d",
"ONE-PUT",
"Commodity",
25,
1656127500000,
660,
"sell",
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"789012a",
"CRUDE23APR14700CE",
"Commodity",
75,
1656127500000,
194.9,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
]
]
}
]
},
{
"name": "futures_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"name": "futures_tradebook_table",
"header": [
"trade_id",
"contract_name",
"asset_class",
"quantity",
"date",
"price",
"transaction_type",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"label"
],
"rows": [
[
"12345a",
"CRUDE21APR14700CE",
"Commodity",
75,
1577836800000,
363.1,
"buy",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"54321a",
"USD21APR14700CE",
"Currency",
75,
1565222400000,
363.15,
"buy",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"54612a",
"FINNIFTY21MAYFUT",
"Equity",
40,
985305600000,
15700,
"buy",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"15484a",
"NIFTY21JUN17500CE",
"Equity",
75,
1648684800000,
4.55,
"buy",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"456789a",
"NIFTY21JUN15800CE",
"Equity",
75,
1536451200000,
168,
"buy",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"678901a",
"NIFTY21Jan15800CE",
"Equity",
40,
1639267200000,
175.55,
"buy",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"678901a",
"NIFTY21Jan15800CE",
"Equity",
35,
1639267200000,
175.55,
"buy",
1,
1,
1,
1,
0,
0,
null,
null,
null,
null
],
[
"789012a",
"CRUDE21APR14700CE",
"Commodity",
75,
1577923200000,
194.9,
"sell",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"890123a",
"USD21APR14700CE",
"Currency",
75,
1565222400000,
194.9,
"sell",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"123098a",
"FINNIFTY21MAYFUT",
"Equity",
40,
1680912000000,
15685.9,
"sell",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"345876a",
"NIFTY21JUN17500CE",
"Equity",
75,
1648771200000,
4.7,
"sell",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"333444a",
"NIFTY21JUN15800CE",
"Equity",
75,
1662681600000,
168.65,
"sell",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
"888000a",
"NIFTY21Jan15800CE",
"Equity",
75,
1662715800000,
174.25,
"sell",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
],
[
null,
"NIFTY21Jan15800CE",
"Equity",
75,
1662719400000,
175,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
null
],
[
"893289a",
"NIFTY21Jan15800CE",
"Equity",
75,
1662721200000,
175,
"buy",
0,
0,
0,
0,
0,
0,
0,
0,
0,
null
],
[
"892398k",
"NIFTY21Jan15800CE",
"Equity",
75,
1662723000000,
180,
"sell",
0,
0,
0,
0,
0,
0,
0,
0,
0,
null
],
[
"985949d",
"ONE-FUT",
"Commodity",
50,
1654300800000,
600,
"buy",
0,
null,
null,
null,
null,
null,
null,
null,
0,
null
],
[
"382983a",
"ONE-FUT",
"Commodity",
50,
1656126000000,
666,
"buy",
0,
null,
null,
null,
null,
null,
null,
null,
0,
null
],
[
"382983a",
"ONE-FUT",
"Commodity",
50,
1656127200000,
660,
"buy",
0,
0,
null,
null,
null,
null,
null,
null,
0,
null
],
[
"344324d",
"ONE-FUT",
"Commodity",
25,
1656127500000,
660,
"sell",
0,
0,
null,
null,
null,
null,
null,
null,
0,
null
],
[
"232432a",
"ONE-FUT",
"Commodity",
25,
1656201600000,
700,
"sell",
0,
null,
null,
null,
null,
null,
null,
null,
null,
null
],
[
"121212a",
"NIFTY23JUN15800CE",
"Equity",
89,
1662681600000,
100,
"sell",
1,
1,
1,
1,
0,
0,
0,
0,
0,
0
]
]
}
]
},
{
"name": "debentures_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"name": "debentures_tradebook_table",
"header": [
"trade_id",
"isin",
"security_name",
"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": [
[
"1a",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1577836800000,
10,
"buy",
1,
0,
6,
0,
0,
0,
0,
0,
0
],
[
"1a",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1577836800000,
10,
"buy",
1,
0,
6,
0,
0,
0,
0,
0,
0
],
[
"3a",
"INE272F07011",
"Blue Dart Express",
true,
50,
944179200000,
20,
"buy",
6,
2,
0,
0,
0,
0,
0,
0,
0
],
[
"4a",
"INE272F07011",
"Blue Dart Express",
true,
20,
1577836800000,
200,
"sell",
10,
20,
0,
0,
0,
3,
3,
3,
0
],
[
"5a",
"INE112J07020",
"IFCI",
true,
200,
1564963200000,
16.55,
"buy",
10,
6,
0,
0,
0,
0,
0,
0,
0
],
[
"6a",
"INE112J07020",
"IFCI",
true,
170,
1596585600000,
500,
"sell",
30,
21.5,
0,
0,
0,
2.2,
0.22,
2.2,
0
],
[
"7a",
"INE130K08000",
"SBOX",
false,
200,
1596585600000,
16.55,
"buy",
10,
6,
0,
0,
0,
0,
0,
0,
0
],
[
"8a",
"INE130K08000",
"SBOX",
false,
170,
1596672000000,
500,
"sell",
30,
21.5,
0,
0,
0,
2.2,
0.22,
2.2,
0
],
[
"10a",
"INE130K08001",
"QCK",
false,
200,
1659744000000,
500,
"sell",
30,
21.5,
0,
0,
0,
2.2,
0.22,
2.2,
0
],
[
"11a",
"INE130K08012",
"GGL",
true,
200,
1662681600000,
550,
"receive",
10,
6,
0,
0,
0,
0,
0,
0,
0,
"transfer"
],
[
"12a",
"INE130K08015",
"GGL",
true,
200,
1672531200000,
600,
"send",
30,
21.5,
0,
0,
0,
2.2,
0.22,
2.2,
0,
"gift"
],
[
"13a",
"INE130K08019",
"APPL",
false,
200,
1672531200000,
350,
"buy",
10,
6,
0,
0,
0,
0,
0,
0,
0
],
[
"14a",
"INE130K08019",
"APPL",
false,
180,
1672531200000,
310,
"sell",
30,
21.5,
0,
0,
0,
2.2,
0.22,
2.2,
0
],
[
"2a",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1672531200000,
125,
"sell",
20,
0,
10,
0,
0,
1,
1,
1,
0
],
[
"2a",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1672531200000,
125,
"sell",
20,
0,
10,
0,
0,
1,
1,
1,
0
],
[
"43a",
"INE261F07055",
"SGB",
true,
500,
1659744000000,
488,
"buy",
12,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"44a",
"INE261F07055",
"SGB",
true,
500,
1659830400000,
322,
"buy",
12,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"45a",
"INE261F07055",
"SGB",
true,
100,
1659920400000,
350,
"receive",
12,
0,
0,
0,
0,
0,
0,
0,
0,
"gift"
],
[
"46a",
"INE261F07055",
"SGB",
true,
550,
1659924000000,
350,
"send",
12,
0,
0,
0,
0,
0,
0,
0,
0,
"transfer"
],
[
"47a",
"INE261F07055",
"SGB",
true,
50,
1672531200000,
400,
"sell",
12,
null,
null,
null,
null,
null,
null,
null,
null
]
]
}
]
},
{
"name": "bonds_tradebook_sheet",
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"name": "bonds_tradebook_table",
"header": [
"trade_id",
"isin",
"security_name",
"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": [
[
"1a",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1577836800000,
10,
"buy",
1,
0,
6,
0,
0,
0,
0,
0,
0
],
[
"1a",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1577836800000,
10,
"buy",
1,
0,
6,
0,
0,
0,
0,
0,
0
],
[
"3a",
"INE272F07011",
"Blue Dart Express",
true,
50,
944179200000,
20,
"buy",
6,
2,
0,
0,
0,
0,
0,
0,
0
],
[
"4a",
"INE272F07011",
"Blue Dart Express",
true,
20,
1577836800000,
200,
"sell",
10,
20,
0,
0,
0,
3,
3,
3,
0
],
[
"5a",
"INE112J07020",
"IFCI",
true,
200,
1564963200000,
16.55,
"buy",
10,
6,
0,
0,
0,
0,
0,
0,
0
],
[
"6a",
"INE112J07020",
"IFCI",
true,
170,
1596585600000,
500,
"sell",
30,
21.5,
0,
0,
0,
2.2,
0.22,
2.2,
0
],
[
"7a",
"INE130K08000",
"SBOX",
false,
200,
1596585600000,
16.55,
"buy",
10,
6,
0,
0,
0,
0,
0,
0,
0
],
[
"8a",
"INE130K08000",
"SBOX",
false,
170,
1596672000000,
500,
"sell",
30,
21.5,
0,
0,
0,
2.2,
0.22,
2.2,
0
],
[
"10a",
"INE130K08001",
"QCK",
false,
200,
1659744000000,
500,
"sell",
30,
21.5,
0,
0,
0,
2.2,
0.22,
2.2,
0
],
[
"11a",
"INE130K08012",
"GGL",
true,
200,
1662681600000,
550,
"receive",
10,
6,
0,
0,
0,
0,
0,
0,
0,
"transfer"
],
[
"12a",
"INE130K08015",
"GGL",
true,
200,
1672531200000,
600,
"send",
30,
21.5,
0,
0,
0,
2.2,
0.22,
2.2,
0,
"gift"
],
[
"13a",
"INE130K08019",
"APPL",
false,
200,
1672531200000,
350,
"buy",
10,
6,
0,
0,
0,
0,
0,
0,
0
],
[
"14a",
"INE130K08019",
"APPL",
false,
180,
1672531200000,
310,
"sell",
30,
21.5,
0,
0,
0,
2.2,
0.22,
2.2,
0
],
[
"2a",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1672531200000,
125,
"sell",
20,
0,
10,
0,
0,
1,
1,
1,
0
],
[
"2a",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1672531200000,
125,
"sell",
20,
0,
10,
0,
0,
1,
1,
1,
0
],
[
"43a",
"INE261F07055",
"SGB",
true,
500,
1659744000000,
488,
"buy",
12,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"44a",
"INE261F07055",
"SGB",
true,
500,
1659830400000,
322,
"buy",
12,
0,
0,
0,
0,
0,
0,
0,
0
],
[
"45a",
"INE261F07055",
"SGB",
true,
100,
1659920400000,
350,
"receive",
12,
0,
0,
0,
0,
0,
0,
0,
0,
"gift"
],
[
"46a",
"INE261F07055",
"SGB",
true,
550,
1659924000000,
350,
"send",
12,
0,
0,
0,
0,
0,
0,
0,
0,
"transfer"
],
[
"47a",
"INE261F07055",
"SGB",
true,
50,
1672531200000,
400,
"sell",
12,
null,
null,
null,
null,
null,
null,
null,
null
]
]
}
]
}
]
}
Annexure
Annexure-1 Corporate Actions
The enumeration is explained below:
| Corporate Action | ENUM |
|---|---|
| Amalgamation | amalgamation |
| Bonus Issue | bonus_issue |
| Buy Back of Shares | buy_back |
| Consolidation of Shares | consolidation |
| Dividend | dividend |
| Dividend on Preference Shares | dividend |
| Income Distribution (InvIT) | income_distribution_invit |
| Income Distribution RITES | income_distribution_rites |
| InvIT - Return of Capital | return_of_capital_invit |
| Preferential Issue of shares | preferential_issue |
| Reduction of Capital | reduction_of_capital |
| Right Issue of Equity Shares | right_issue |
| Scheme of Arrangement | scheme_of_arrangement |
| Spin Off | spin_off |
| Stock Split | stock_split |
| Voluntary Delisting of Shares | voluntary_delisting_of_share |
Annexure-2 Nature of Transfer
| Nature of Transfer | ENUM |
|---|---|
| Asset transferred in | transfer_in |
| Asset transferred out | transfer_out |
| Asset sent as Gift | gift_send |
| Asset received as Gift | gift_receive |
| Asset donated | donation |
| Other | other |
Updated 15 days ago