JSON Payload
This API accepts payload in following formats:Tradebook
Click here to learn more about this JSON Payload.
Copy
{
"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"
],
[
"ZJZZOQLJZWYQRMSHK2E3",
"INE00E101023",
"BIKAJI",
true,
true,
321,
1725062400000,
370,
"sell",
0,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
45.6,
null,
"delivery"
]
]
}
]
},
{
"name": "future_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "future_tradebook_table",
"@entity": "table",
"header": [
"trade_id",
"isin",
"contract_name",
"asset_class",
"quantity",
"date",
"price",
"transaction_type",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"label"
],
"rows": [
[
"GGFCHMYLKDQYZRRINTEE",
"INE914J01012",
"BANKNIFTY 01 Jun 2023 FUT",
"equity",
45,
1711756800000,
363.1,
"buy",
51,
98,
75,
55,
32,
219,
11,
142,
55,
36,
null
],
[
"AUGUWEK01EI4YOIMH7RK",
"INE519I01013",
"BANKNIFTY 15 Jun 2023 FUT",
"equity",
50,
1714176000000,
363.15,
"sell",
7,
56,
55,
223,
245,
330,
106,
144,
103,
9,
null
]
]
}
]
},
{
"name": "option_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "option_tradebook_table",
"@entity": "table",
"header": [
"trade_id",
"isin",
"contract_name",
"asset_class",
"quantity",
"date",
"price",
"transaction_type",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"label"
],
"rows": [
[
"RJFWB5JYYDORFUEPK5DQ",
"INE619I01012",
"BANKNIFTY 01 Jun 2023 CE 44100",
"equity",
25,
1711756800000,
363.1,
"buy",
385,
201,
2235,
795,
1757,
202,
195,
2060,
2112,
1622,
null
]
]
}
]
},
{
"name": "mutual_fund_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "mutual_fund_tradebook_table",
"@entity": "table",
"header": [
"trade_id",
"isin",
"scheme_name",
"asset_class",
"is_listed",
"is_stt_paid",
"quantity",
"date",
"price",
"transaction_type",
"fmv",
"transfer_expenses",
"label"
],
"rows": [
[
"TGFCH72LKDQY9RRINTGH",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
true,
true,
32.31,
1525824000000,
50,
"buy",
400,
10,
null
]
]
}
]
},
{
"name": "etf_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "etf_tradebook_table",
"@entity": "table",
"header": [
"trade_id",
"isin",
"scheme_name",
"asset_class",
"is_listed",
"is_stt_paid",
"quantity",
"date",
"price",
"transaction_type",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"label",
"product_type"
],
"rows": [
[
"TGFCH72LKDQY9RRINTGH",
"INE397D01024",
"HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
"debt",
true,
true,
250,
1714521600000,
650,
"buy",
400,
115,
74,
130,
137,
144,
113,
122,
132,
69,
76,
null,
"intraday"
]
]
}
]
},
{
"name": "bond_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "bond_tradebook_table",
"@entity": "table",
"header": [
"trade_id",
"isin",
"security_name",
"is_listed",
"quantity",
"date",
"price",
"transaction_type",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"label"
],
"rows": [
[
"TGFCH72LKDQY9RRINTGH",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
500,
1738694400000,
10,
"buy",
31,
50,
13,
3,
115,
100,
109,
56,
8,
null
]
]
}
]
},
{
"name": "debenture_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "debenture_tradebook_table",
"@entity": "table",
"header": [
"trade_id",
"isin",
"security_name",
"is_listed",
"quantity",
"date",
"price",
"transaction_type",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fees",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"label"
],
"rows": [
[
"RJFWB5JYYDORFUEPK5DQ",
"INE261F07032",
"07.64% NABARD TFB 2031",
true,
1000,
1525824000000,
10,
"buy",
177,
180,
238,
105,
243,
101,
131,
187,
104,
null
]
]
}
]
}
]
}
Tradewise PnL
Click > Click here to learn more about this JSON Payload.
Copy
{
"sheets": [
{
"blocks": [
{
"header": [
"isin",
"symbol",
"is_listed",
"is_stt_paid",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fee",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement",
"product_type"
],
"name": "stock_tradewise_settlement_table",
"@entity": "table"
},
{
"header": [
"isin",
"symbol",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"name": "stock_tradewise_holding_table",
"@entity": "table"
},
{
"header": [
"isin",
"symbol",
"quantity",
"sell_date",
"sell_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"name": "stock_tradewise_open_sell_table",
"@entity": "table"
},
{
"header": [
"isin",
"symbol",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"name": "stock_tradewise_transfer_table",
"@entity": "table"
}
],
"name": "stock_sheet",
"@entity": "sheet"
},
{
"blocks": [
{
"header": [
"isin",
"contract_name",
"asset_class",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"brokerage",
"clearing_charges",
"exchange_transaction_charges",
"sebi_turnover_fee",
"stt",
"stamp_duty",
"sgst",
"cgst",
"igst",
"other_transfer_expenses",
"nature_of_settlement"
],
"rows": [
[
null,
"1",
"currency",
1,
"6a8aa695-6cc7-4d26-a5c6-52bc582abcf8-#-9fa5b9f0-b512-4814-ad94-218b8670f7c3",
1741199400000,
50000,
null,
1740940200000,
0,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
"trade"
]
],
"name": "future_tradewise_settlement_table",
"@entity": "table"
},
{
"header": [
"isin",
"contract_name",
"asset_class",
"quantity",
"trade_date",
"trade_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"name": "future_tradewise_open_position_table",
"@entity": "table"
}
],
"name": "future_sheet",
"@entity": "sheet"
},
{
"blocks": [
{
"header": [
"isin",
"scheme_name",
"asset_class",
"is_listed",
"is_stt_paid",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"fmv",
"transfer_expenses",
"nature_of_settlement"
],
"rows": [
[
null,
"MF PROF",
"equity",
true,
true,
50,
"a92177bc-f669-422f-900a-356ad31e1c29-#-9fa5b9f0-b512-4814-ad94-218b8670f7c3",
1444242600000,
23,
null,
1724351400000,
5555,
null,
0,
"trade"
]
],
"name": "mutual_fund_tradewise_settlement_table",
"@entity": "table"
},
{
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"buy_date",
"buy_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"name": "mutual_fund_tradewise_holding_table",
"@entity": "table"
},
{
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"sell_date",
"sell_price",
"transaction_type",
"label",
"last_traded_price",
"unrealized_pnl"
],
"name": "mutual_fund_tradewise_open_sell_table",
"@entity": "table"
},
{
"header": [
"isin",
"scheme_name",
"asset_class",
"quantity",
"transfer_date",
"price",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"name": "mutual_fund_tradewise_transfer_table",
"@entity": "table"
}
],
"name": "mutual_fund_sheet",
"@entity": "sheet"
}
],
"name": "tradewise_settlement_workbook",
"@entity": "workbook"
}
Headers
application/json or application/xlsx