Tradewise Settlements Payload
Tradewise trading activity provides you with an absolute value of profits made. Brokers can use tradewise trading activity to calculate Tax P&L for investors and traders.
Equity Tradewise Settlements
| Param | Type | Required | Description |
|---|---|---|---|
| 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 |
| buy_trade_id | string | Yes | Buy Trade ID |
| buy_date | number | Yes | Date of purchase |
| buy_price | number | Yes | Buy price for the trade |
| sell_trade_id | string | Yes | Sell Trade ID |
| sell_date | number | Yes | Date of Sell |
| sell_price | number | Yes | Sell price for the trade |
| fmv | number | No | High stock price 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 |
| nature_of_transaction | string | No | Refer to Nature of Transaction |
Mutual Fund Tradewise Settlements
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| scheme_name | string | Yes | Symbol or description of mutual fund |
| asset_class | string | Yes | Scheme type, possible valuesequity, debt, other |
| quantity | number | Yes | Trading quantity |
| buy_trade_id | string | Yes | Buy Trade ID |
| buy_date | number | Yes | Date of purchase |
| buy_price | number | Yes | Buy price for the trade |
| sell_trade_id | string | Yes | Sell Trade ID |
| sell_date | number | Yes | Date of Sell |
| sell_price | number | Yes | Sell price for the trade |
| fmv | number | No | High stock price on 31/01/2018 |
| transfer_expenses | number | No | Any expense relating to the transfer of asset |
Futures Tradewise Settlements
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| 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 |
| buy_trade_id | string | Yes | Buy Trade ID |
| buy_date | number | Yes | Date of purchase |
| buy_price | number | Yes | Buy price for the trade |
| sell_trade_id | string | Yes | Sell Trade ID |
| sell_date | number | Yes | Date of Sell |
| sell_price | number | Yes | Sell price for the 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 |
| 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 |
Options Tradewise Settlements
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| 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 |
| buy_trade_id | string | Yes | Buy Trade ID |
| buy_date | number | Yes | Date of purchase |
| buy_price | number | Yes | Buy price for the trade |
| sell_trade_id | string | Yes | Sell Trade ID |
| sell_date | number | Yes | Date of Sell |
| sell_price | number | Yes | Sell price for the 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 |
| 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 |
ETF Tradewise Settlements
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| scheme_name | string | Yes | Name of ETF |
| asset_class | string | Yes | The asset class of the contract. Possible valuesequity, currency & commodity |
| quantity | number | Yes | Trading quantity |
| buy_trade_id | string | Yes | Buy Trade ID |
| buy_date | number | Yes | Date of purchase |
| buy_price | number | Yes | Buy price for the trade |
| sell_trade_id | string | Yes | Sell Trade ID |
| sell_date | number | Yes | Date of Sell |
| sell_price | number | Yes | Sell price for the trade |
| fmv | number | No | High stock price 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 |
| nature_of_transaction | string | No | Refer to Nature of Transaction |
Bonds Tradewise Settlements
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| security_name | string | Yes | Symbol or description of equity share |
| is_listed | boolean | Yes | is the equity share listed in public markets |
| quantity | number | Yes | Trading quantity |
| buy_trade_id | string | Yes | Buy Trade ID |
| buy_date | number | Yes | Date of purchase |
| buy_price | number | Yes | Buy price for the trade |
| sell_trade_id | string | Yes | Sell Trade ID |
| sell_date | number | Yes | Date of Sell |
| sell_price | number | Yes | Sell price for the 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 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 |
| nature_of_transaction | string | No | Refer to Nature of Transaction |
Debentures Tradewise Settlements
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| security_name | string | Yes | Symbol or description of equity share |
| is_listed | boolean | Yes | is the equity share listed in public markets |
| quantity | number | Yes | Trading quantity |
| buy_trade_id | string | Yes | Buy Trade ID |
| buy_date | number | Yes | Date of purchase |
| buy_price | number | Yes | Buy price for the trade |
| sell_trade_id | string | Yes | Sell Trade ID |
| sell_date | number | Yes | Date of Sell |
| sell_price | number | Yes | Sell price for the 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 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 |
| nature_of_transaction | string | No | Refer to Nature of Transaction |
Sample Payload
You can refer to the sample payload in workbook format
{
"@entity": "workbook",
"name": "tradewise_pnl_workbook",
"sheets": [
{
"name": "equity_tradewise_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "equity_tradewise_pnl_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"is_listed",
"is_stt_paid",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_transaction"
],
"rows": [
[
null,
"AJANTA PHARMA LIMITED",
true,
true,
16.0000,
"1a",
1483488000000,
200.0000,
"2a",
1486166400000,
911.0000,
989,
130.5758,
0.0000,
0.0000,
0.0000,
6.0000,
1.9394,
0.0000,
0.0000,
0.0000,
0.0000,
"trade"
],
[
"INE190001019",
"NIP IND ETF GOLD BEES",
true,
true,
75.0000,
"8a",
1547078400000,
314.0000,
"23a",
1672531200000,
500.0000,
300,
148.0000,
0.0000,
108.0000,
0.0000,
12.0000,
6.0000,
0.0000,
0.0000,
0.0000,
0.0000,
"trade"
],
[
"INE190A01019",
"ITC LTD",
false,
true,
20.0000,
"5a",
1641600000000,
346.0000,
"7a",
1641772800000,
522.0000,
382,
137.2258,
3.2258,
0.0000,
0.0000,
9.8710,
3.0000,
0.0000,
0.0000,
0.0000,
0.0000,
"trade"
],
[
"INE190B01027",
"INFY",
true,
true,
5.0000,
"27a",
1641033000000,
300.0000,
"30a",
1641034800000,
305.0000,
350,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
"trade"
],
[
"INE190B01027",
"INFY",
true,
true,
6.0000,
"25a",
1577836800000,
250.0000,
"31a",
1672531200000,
390.0000,
350,
19.0000,
2.0000,
5.0000,
10.0000,
8.0000,
0.0000,
0.1100,
0.1200,
0.3000,
3.0000,
"trade"
],
[
"INE190B01019",
"HINDUJA GLOBAL SOLS. LTD.",
true,
true,
53.0000,
"4a",
1641556800000,
56.0000,
"19a",
1641520800000,
58.0000,
0,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
6.0000,
0.0000,
0.0000,
0.0000,
0.0000,
"trade"
]
]
}
]
},
{
"name": "futures_tradewise_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "futures_tradewise_pnl_table",
"@entity": "table",
"header": [
"isin",
"contract_name",
"asset_class",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": [
[
null,
"NIFTY21JUN15800CE",
"Equity",
75.0000,
"456789a",
1536451200000,
168.0000,
"333444a",
1662681600000,
168.6500,
2.0000,
2.0000,
2.0000,
2.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"FINNIFTY21MAYFUT",
"Equity",
40.0000,
"54612a",
985305600000,
15700.0000,
"123098a",
1680912000000,
15685.9000,
2.0000,
2.0000,
2.0000,
2.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"NIFTY21Jan15800CE",
"Equity",
75.0000,
"678901a",
1639267200000,
175.5500,
"888000a",
1662715800000,
174.2500,
3.0000,
3.0000,
3.0000,
3.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"NIFTY21Jan15800CE",
"Equity",
75.0000,
null,
1662719400000,
175.0000,
"892398k",
1662723000000,
180.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"USD21APR14700CE",
"Currency",
75.0000,
"54321a",
1565222400000,
363.1500,
"890123a",
1565222400000,
194.9000,
2.0000,
2.0000,
2.0000,
2.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"CRUDE21APR14700CE",
"Commodity",
75.0000,
"12345a",
1577836800000,
363.1000,
"789012a",
1577923200000,
194.9000,
2.0000,
2.0000,
2.0000,
2.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"ONE-FUT",
"Commodity",
25.0000,
"985949d",
1654300800000,
600.0000,
"344324d",
1656127500000,
660.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"ONE-FUT",
"Commodity",
25.0000,
"985949d",
1654300800000,
600.0000,
"232432a",
1656201600000,
700.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"NIFTY21JUN17500CE",
"Equity",
75.0000,
"15484a",
1648684800000,
4.5500,
"345876a",
1648771200000,
4.7000,
2.0000,
2.0000,
2.0000,
2.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
]
]
}
]
},
{
"name": "options_tradewise_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "options_tradewise_pnl_table",
"@entity": "table",
"header": [
"isin",
"contract_name",
"asset_class",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": [
[
null,
"NIFTY21JUN15800CE",
"Equity",
75.0000,
"456789a",
1546646400000,
168.0000,
"333444a",
1546732800000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"NIFTY21JUN15800CE",
"Equity",
75.0000,
"678901a",
1546646400000,
175.5500,
"888000a",
1546819200000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"ONE-PUT",
"Commodity",
25.0000,
"985949d",
1654300800000,
600.0000,
"344324d",
1656127500000,
660.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"FINNIFTY21MAYFUT",
"Equity",
40.0000,
"54612a",
1199750400000,
15700.0000,
"123098a",
1199923200000,
1500.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"NIFTY21Jan15800CE",
"Equity",
75.0000,
null,
1662719400000,
175.0000,
"892398k",
1662723000000,
180.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"USD21APR14700CE",
"Currency",
75.0000,
"54321a",
1522368000000,
363.1500,
"890123a",
1515024000000,
194.9000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"CRUDE21APR14700CE",
"Commodity",
75.0000,
"12345a",
1292889600000,
363.1000,
"789012a",
1292889600000,
194.9000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
null,
"NIFTY21JUN17500CE",
"Equity",
75.0000,
"15484a",
1609459200000,
4.5500,
"345876a",
1640995200000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
]
]
}
]
},
{
"name": "mutual_fund_tradewise_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "mutual_fund_tradewise_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"transfer_expenses",
"nature_of_transaction"
],
"rows": [
[
"INF200K01190",
"KOTAK SEC FUND",
"equity",
50.0000,
"488k",
1505865600000,
980.0000,
"500i",
1640044800000,
1300.0000,
800,
0.6667,
null
],
[
"INF200K01190",
"KOTAK SEC FUND",
"equity",
25.0000,
"480k",
1505952000000,
1000.0000,
"500i",
1640044800000,
1300.0000,
800,
0.3333,
null
],
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
17.8230,
"65412a",
1650412800000,
10.0000,
"14712a",
1650412800000,
5.0000,
0,
20.0000,
null
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
19.5740,
"15545a",
1682812800000,
120.0000,
"89741a",
1685404800000,
160.0000,
5,
95.7233,
null
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
35.0000,
"58s87",
1513036800000,
60.0000,
"230f",
1648778400000,
210.0000,
180,
39.0146,
null
],
[
"INF760K01FR2",
"Canara Robeco Bluechip Equity Growth Direct Plan",
"equity",
45.5700,
"999j",
1505865600000,
23.2100,
"101q",
1648771200000,
23.2100,
45,
2.8306,
null
],
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
6.6510,
"2154b",
1118016000000,
2.0000,
"1324h",
1654646400000,
500.0000,
220,
50.0013,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
11.3380,
"4458l",
1497225600000,
150.0000,
"4651z",
1686528000000,
400.0000,
160,
100.8671,
null
],
[
"INF278A06YE8",
"Aditya Birla Sun Life Medium Term Direct Plan Growth",
"debt",
36.0230,
"24896a",
1682812800000,
30.0000,
"41564a",
1686009600000,
60.0000,
10,
167.8919,
null
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
0.1230,
"5544a",
944956800000,
15.0000,
"165a",
1648684800000,
60.0000,
17,
10.0070,
null
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
32.5310,
"5411b",
1584662400000,
400.7840,
"4586w",
1647993600000,
200.0000,
200,
23.5685,
null
],
[
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
32.3100,
"15648a",
1528243200000,
50.0000,
"9832q",
1654646400000,
900.0000,
1000,
99.6580,
null
],
[
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
33.8070,
"3212k",
1620086400000,
150.0000,
"9824b",
1620172800000,
250.0000,
100,
43.8583,
null
]
]
}
]
},
{
"name": "etf_tradewise_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "etf_tradewise_pnl_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses"
],
"rows": [
[
"INF846K01DI2",
"Axis Bluechip Fund",
"equity",
78.0000,
"5187q",
1522886400000,
23.0000,
"5481j",
1680652800000,
88.0000,
20,
8.5559,
2.0000,
1.0000,
0.0000,
2.9317,
0.0020,
36.0000,
36.0000,
0.0000,
0.0000,
null
],
[
"INF200K01UT4",
"SBI LIQUID FUND - DIRECT PLAN",
"other",
20.0000,
"5544a",
1513036800000,
15.0000,
"165a",
1648684800000,
60.0000,
17,
0.3230,
2.0000,
1.0000,
0.0000,
37.0000,
0.0020,
0.0000,
36.0000,
36.0000,
0.0000,
null
],
[
"INF251K01NO3",
"BNP PARIBAS LIQUID FUND - DIRECT PLAN",
"debt",
30.7390,
"65412a",
1621468800000,
10.0000,
"14712a",
1650412800000,
5.0000,
0,
9.9495,
0.0000,
0.0000,
0.0000,
53.6353,
0.0000,
17.5451,
35.5451,
18.0000,
0.0000,
null
],
[
"INF277K01YE6",
"TATA LIQUID FUND - DIRECT PLAN",
"debt",
60.0000,
"15545a",
1682812800000,
120.0000,
"89741a",
1685404800000,
160.0000,
5,
4.2500,
0.0000,
0.0000,
9.0000,
19.2960,
0.0000,
0.0000,
31.5000,
31.5000,
0.0000,
null
],
[
"INF109KB1GK2",
"ICICI Prudential Commodity Fund",
"other",
20.0000,
"5411b",
1584662400000,
400.7840,
"4586w",
1647993600000,
200.0000,
200,
7.0939,
2.0000,
1.0000,
0.0000,
13.0700,
0.0020,
0.0000,
36.0000,
36.0000,
0.0000,
null
],
[
"INF200K01189",
"SBI Gold Fund",
"other",
45.5488,
"58s87",
1513036800000,
60.0000,
"8784a",
1654128000000,
120.5877,
65,
2.5284,
1.9110,
0.9555,
0.0000,
150.9464,
0.0019,
0.0000,
34.3976,
34.3976,
0.0000,
null
],
[
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
250.0000,
"15648a",
1118016000000,
50.0000,
"15648a",
1659744000000,
600.0000,
400,
0.0000,
0.0000,
0.0000,
0.0000,
17.0000,
25.0000,
36.0000,
36.0000,
0.0000,
0.0000,
null
],
[
"INF179KB1HP9",
"HDFC LIQUID FUND - DIRECT PLAN",
"equity",
99.7800,
"2154b",
1118016000000,
2.0000,
"1324h",
1659744000000,
500.0000,
220,
4.9734,
1.9826,
0.9913,
0.0000,
8.4134,
0.0020,
0.0000,
35.6865,
35.6865,
0.0000,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
30.0000,
"4651z",
1670292000000,
400.0000,
"302i",
1670295600000,
12.0000,
160,
1.9442,
1.7500,
0.8750,
0.0000,
26.2500,
0.0007,
13.5000,
13.5000,
0.0000,
0.0000,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
10.0000,
"4651z",
1670292000000,
400.0000,
"302v",
1670295601000,
10.0000,
160,
1.3888,
1.2500,
0.6250,
0.0000,
18.7500,
0.0003,
4.5000,
4.5000,
0.0000,
0.0000,
null
],
[
"INF200K01OR6",
"SBI Magnum Multicap Fund",
"equity",
30.0000,
"4458l",
1512518400000,
150.0000,
"939j",
1680220800000,
50.0000,
0,
0.6765,
0.3158,
0.1579,
0.0000,
3.1579,
0.0003,
5.6842,
5.6842,
0.0000,
0.0000,
null
],
[
"INF179K01PT5",
"HDFC Small Cap Fund",
"equity",
90.0000,
"3212k",
1617580800000,
150.0000,
"9824b",
1620172800000,
250.0000,
100,
6.0011,
2.0000,
1.0000,
0.0000,
5.4460,
0.0020,
36.0000,
36.0000,
0.0000,
0.0000,
null
]
]
}
]
},
{
"name": "bonds_tradewise_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "bonds_tradewise_pnl_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"is_listed",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_transaction"
],
"rows": [
[
"INE272F07011",
"Blue Dart Express",
true,
20.0000,
"3a",
944179200000,
20.0000,
"4a",
1577836800000,
200.0000,
12.4000,
20.8000,
0.0000,
0.0000,
0.0000,
3.0000,
3.0000,
3.0000,
0.0000,
null
],
[
"INE112J07020",
"IFCI",
true,
170.0000,
"5a",
1564963200000,
16.5500,
"6a",
1596585600000,
500.0000,
38.5000,
26.6000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
null
],
[
"INE130K08019",
"APPL",
false,
180.0000,
"13a",
1672531200000,
350.0000,
"14a",
1672531200000,
310.0000,
39.0000,
26.9000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
null
],
[
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
1000.0000,
"1a",
1577836800000,
10.0000,
"2a",
1672531200000,
125.0000,
42.0000,
0.0000,
32.0000,
0.0000,
0.0000,
2.0000,
2.0000,
2.0000,
0.0000,
null
],
[
"INE130K08001",
"QCK",
false,
200.0000,
"9a",
1659744000000,
16.5500,
"10a",
1659744000000,
500.0000,
40.0000,
27.5000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
null
],
[
"INE130K08015",
"GGL",
true,
200.0000,
"11a",
1662681600000,
550.0000,
"12a",
1672531200000,
600.0000,
40.0000,
27.5000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
null
],
[
"INE130K08000",
"SBOX",
false,
170.0000,
"7a",
1596585600000,
16.5500,
"8a",
1596672000000,
500.0000,
38.5000,
26.6000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
null
],
[
"INE261F07055",
"SGB",
true,
500.0000,
"43a",
1659744000000,
488.0000,
"46a",
1659924000000,
350.0000,
22.9091,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
"INE261F07055",
"SGB",
true,
50.0000,
"44a",
1659830400000,
322.0000,
"46a",
1659924000000,
350.0000,
2.2909,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
"INE261F07055",
"SGB",
true,
50.0000,
"44a",
1659830400000,
322.0000,
"47a",
1672531200000,
400.0000,
13.2000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
]
]
}
]
},
{
"name": "debentures_tradewise_pnl_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "debentures_tradewise_pnl_table",
"@entity": "table",
"header": [
"isin",
"security_name",
"is_listed",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_transaction"
],
"rows": [
[
"INE272F07011",
"Blue Dart Express",
true,
20.0000,
"3a",
1217548800000,
20.0000,
"4a",
1609459200000,
200.0000,
12.4000,
20.8000,
0.0000,
0.0000,
0.0000,
3.0000,
3.0000,
3.0000,
0.0000,
null
],
[
"INE112J07020",
"IFCI",
true,
170.0000,
"5a",
1556668800000,
16.5500,
"6a",
1556668800000,
500.0000,
38.5000,
26.6000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
null
],
[
"INE130K08019",
"APPL",
false,
180.0000,
"13a",
1688169600000,
350.0000,
"14a",
1688169600000,
310.0000,
39.0000,
26.9000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
null
],
[
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
1000.0000,
"1a",
1292889600000,
10.0000,
"2a",
1522368000000,
125.0000,
21.0000,
0.0000,
16.0000,
0.0000,
0.0000,
1.0000,
1.0000,
1.0000,
0.0000,
null
],
[
"INE130K08001",
"QCK",
false,
200.0000,
"9a",
1222819200000,
16.5500,
"10a",
1640995200000,
500.0000,
40.0000,
27.5000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
null
],
[
"INE130K08015",
"GGL",
true,
200.0000,
"11a",
1559347200000,
550.0000,
"12a",
1561939200000,
600.0000,
40.0000,
27.5000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
null
],
[
"INE130K08000",
"SBOX",
false,
170.0000,
"7a",
1292889600000,
16.5500,
"8a",
1522540800000,
500.0000,
38.5000,
26.6000,
0.0000,
0.0000,
0.0000,
2.2000,
0.2200,
2.2000,
0.0000,
null
],
[
"INE261F07055",
"SGB",
true,
500.0000,
"43a",
1654646400000,
488.0000,
"46a",
1659924000000,
350.0000,
22.9091,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
"INE261F07055",
"SGB",
true,
50.0000,
"44a",
1657238400000,
322.0000,
"46a",
1659924000000,
350.0000,
2.2909,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
],
[
"INE261F07055",
"SGB",
true,
50.0000,
"44a",
1657238400000,
322.0000,
"47a",
1672531200000,
400.0000,
13.2000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
0.0000,
null
]
]
}
]
}
]
}
Updated 2 days ago