PUT Request on Presigned URL
Once the job is successfully created, upload the payload using HTTP PUT method on generated presigned url. Read More
Tradewise PnL
Click here to learn more about this JSON Payload
{
"name": "tradewise_settlement_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "stock_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "reference_data_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"52_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
]
},
{
"name": "dividend_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Meta",
1,
1463356800000,
55,
null,
"USD",
3,
null
]
]
},
{
"name": "stock_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_date",
"buy_price",
"buy_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"US0378331022",
"AMAZON",
20,
1463356800000,
56,
null,
"POUND",
"buy",
null,
100
],
[
"US0378331023",
"INTEL",
35,
1692316800000,
88,
null,
"USD",
"buy",
null,
45
]
]
},
{
"name": "stock_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"US0378331012",
"MONSTER",
1,
1650412800000,
800,
null,
"DIRHAM",
"sell",
null,
700
],
[
"US0378331013",
"TSLA",
56,
1692403200000,
95,
null,
"CAD",
"sell",
null,
150
]
]
},
{
"name": "stock_tradewise_settlement_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"currency",
"transfer_expenses",
"nature_of_settlement",
"product_type"
],
"rows": [
[
"US0378331005",
"Apple",
645,
"CJ1CLC4YCBFEZ4CVDNMH",
1463356800000,
136,
"CYX9TQSTWUYK8C9Z7BCE",
1650412800000,
580,
"USD",
25,
"trade",
"intraday"
],
[
"US0378331008",
"NVIDIA",
254,
"VQLDME6IOJZR95BDEKQ9",
1692316800000,
1290.98,
"VXFUFI5Q9HH7FEJPLV3B",
1692403200000,
1301.78,
"EUR",
21,
"trade",
"delivery"
]
]
},
{
"name": "stock_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"transfer_date",
"price",
"currency",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
}
]
},
{
"name": "dr_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "reference_data_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"52_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
]
},
{
"name": "dividend_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Alphabet",
1,
1463356800000,
55,
null,
"USD",
3,
null
]
]
},
{
"name": "dr_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_date",
"buy_price",
"buy_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"US0378331022",
"MSFT",
20,
1463356800000,
56,
null,
"POUND",
"buy",
null,
100
]
]
},
{
"name": "dr_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"US0378331012",
"MONSTER",
1,
1650412800000,
800,
null,
"DIRHAM",
"sell",
null,
700
]
]
},
{
"name": "dr_tradewise_settlement_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"currency",
"transfer_expenses",
"nature_of_settlement",
"product_type"
],
"rows": [
[
"US0378331005",
"Apple",
645,
"CJ1CLC4YCBFEZ4CVDNMH",
1463356800000,
136,
"CYX9TQSTWUYK8C9Z7BCE",
1650412800000,
580,
"USD",
25,
"trade",
"intraday"
],
[
"US0378331008",
"NVIDIA",
254,
"VQLDME6IOJZR95BDEKQ9",
1692316800000,
1290.98,
"VXFUFI5Q9HH7FEJPLV3B",
1692403200000,
1301.78,
"EUR",
21,
"trade",
"delivery"
]
]
},
{
"name": "dr_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"transfer_date",
"price",
"currency",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
}
]
},
{
"name": "mutual_fund_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "reference_data_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"52_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
]
},
{
"name": "dividend_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Alphabet",
2,
1463356800000,
55,
null,
"USD",
3,
null
]
]
},
{
"name": "mutual_fund_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_date",
"buy_price",
"buy_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"US0378331022",
"MSFT",
"equity",
20,
1463356800000,
56,
null,
"POUND",
"buy",
null,
100
],
[
"US0378331322",
"Fidelity",
"debt",
1,
1463356800000,
5,
null,
"USD",
"buy",
null,
12
]
]
},
{
"name": "mutual_fund_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"US0378331022",
"MSFT",
"equity",
20,
1463356800000,
56,
null,
"POUND",
"sell",
null,
100
],
[
"US0378331322",
"Fidelity",
"debt",
1,
1463356800000,
5,
null,
"USD",
"sell",
null,
12
]
]
},
{
"name": "mutual_fund_tradewise_settlement_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"currency",
"transfer_expenses",
"nature_of_settlement"
],
"rows": [
[
"US0378331005",
"INV",
"equity",
645,
"CJ1CLC4YCBFEZ4CVDNMH",
1463356800000,
136,
"CYX9TQSTWUYK8C9Z7BCE",
1650412800000,
580,
"USD",
25,
"trade"
],
[
"US0378331008",
"FRO",
"debt",
254,
"VQLDME6IOJZR95BDEKQ9",
1692316800000,
1290.98,
"VXFUFI5Q9HH7FEJPLV3B",
1692403200000,
1301.78,
"EUR",
21,
"trade"
]
]
},
{
"name": "mutual_fund_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"transfer_date",
"price",
"currency",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
}
]
},
{
"name": "etf_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "reference_data_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"address",
"country",
"zip_code",
"52_week_high",
"closing_value"
],
"rows": [
[
"US0378331022",
"AMAZON",
"ENGLAND",
"ENGLAND",
null,
120,
120
],
[
"US0378331023",
"INTEL",
"USA",
"USA",
null,
66,
50
]
]
},
{
"name": "dividend_table",
"@entity": "table",
"header": [
"isin",
"symbol",
"quantity",
"date",
"dividend_amount",
"dividend_amount_inr",
"currency",
"tax_withheld",
"tax_withheld_inr"
],
"rows": [
[
"US0378331033",
"Alphabet",
2,
1463356800000,
55,
null,
"USD",
3,
null
]
]
},
{
"name": "etf_tradewise_holding_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_date",
"buy_price",
"buy_price_inr",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"US0378331022",
"MSFT",
"equity",
20,
1463356800000,
56,
null,
"POUND",
"buy",
null
],
[
"US0378331322",
"Fidelity",
"debt",
1,
1463356800000,
5,
null,
"USD",
"buy",
null
]
]
},
{
"name": "etf_tradewise_open_sell_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"sell_date",
"sell_price",
"sell_price_inr",
"currency",
"transaction_type",
"label",
"last_traded_price"
],
"rows": [
[
"US0378331022",
"MSFT",
"equity",
20,
1463356800000,
56,
null,
"POUND",
"sell",
null,
100
],
[
"US0378331322",
"Fidelity",
"debt",
1,
1463356800000,
5,
null,
"USD",
"sell",
null,
12
]
]
},
{
"name": "etf_tradewise_settlement_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"buy_trade_id",
"buy_date",
"buy_price",
"sell_trade_id",
"sell_date",
"sell_price",
"currency",
"transfer_expenses",
"nature_of_settlement",
"product_type"
],
"rows": [
[
"US0378331005",
"INV",
"equity",
645,
"CJ1CLC4YCBFEZ4CVDNMH",
1463356800000,
136,
"CYX9TQSTWUYK8C9Z7BCE",
1650412800000,
580,
"USD",
25,
"trade",
"intraday"
],
[
"US0378331008",
"FRO",
"debt",
254,
"VQLDME6IOJZR95BDEKQ9",
1692316800000,
1290.98,
"VXFUFI5Q9HH7FEJPLV3B",
1692403200000,
1301.78,
"EUR",
21,
"trade",
"delivery"
]
]
},
{
"name": "etf_tradewise_transfer_table",
"@entity": "table",
"header": [
"isin",
"scheme_name",
"scheme_type",
"quantity",
"transfer_date",
"price",
"currency",
"transfer_type",
"nature_of_transfer",
"transfer_value",
"transfer_expense"
],
"rows": []
}
]
},
{
"name": "interest_income_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "interest_income_table",
"@entity": "table",
"header": [
"description",
"date",
"amount",
"amount_inr",
"currency",
"tax_witheld",
"tax_witheld_inr"
],
"rows": [
[
"GG",
1463356800000,
8,
null,
"USD",
0.12,
null
],
[
"WP",
1692316800000,
54,
null,
"EUR",
2,
null
]
]
}
]
}
]
}