curl --request POST \
--url https://api.sandbox.co.in/it/calculator/pnl/other \
--header 'Authorization: <authorization>' \
--header 'Content-Type: application/json' \
--header 'x-api-key: <x-api-key>' \
--header 'x-api-version: <x-api-version>' \
--data '
{
"name": "other_tradewise_settlement_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "tradewise_settlement_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "tradewise_settlement_table",
"@entity": "table",
"header": [
"serial_number",
"asset_type",
"asset_name",
"country",
"currency",
"buy_date",
"buy_price",
"cost_of_acquisition",
"sell_date",
"sell_price",
"transfer_expenses"
],
"rows": [
[
"6abba3b3-d061-45f5-a947-c6a944663605",
"jewelry",
"jew",
"india",
"INR",
1696185000000,
25000000,
25000000,
1712255400000,
17500100,
10000
],
[
"592994fb-3b14-4ec7-9203-502cd8927bec",
"art",
"art",
"india",
"INR",
1286649000000,
9590000,
9590000,
1712169000000,
24520000,
17000
],
[
"991d604c-989f-4530-948b-fa2e609c2d56",
"car",
"car",
"india",
"INR",
1286649000000,
8590010,
8590010,
1712169000000,
24582000,
17000
],
[
"cfb66c3b-ae78-4559-9755-ee83ba1f5540",
"other",
"other",
"india",
"INR",
1697740200000,
2301010,
2301010,
1712169000000,
1309000,
12400
]
]
},
{
"name": "cost_of_improvement_table",
"@entity": "table",
"header": [
"settlement_serial_number",
"financial_year",
"cost",
"indexed_cost"
],
"rows": [
[
"592994fb-3b14-4ec7-9203-502cd8927bec",
"FY 2011-12",
250000,
null
],
[
"991d604c-989f-4530-948b-fa2e609c2d56",
"FY 2012-13",
250000,
null
],
[
"cfb66c3b-ae78-4559-9755-ee83ba1f5540",
"FY 2023-24",
1330,
null
]
]
}
]
}
]
}
'{
"transaction_id": "9529f60d-ab22-4138-ac58-9b6bcdbd843c",
"code": 200,
"data": {
"@entity": "workbook",
"sheets": [
{
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"header": [
"settlement_id",
"asset_type",
"asset_name",
"country",
"currency",
"holding_period",
"turnover",
"turnover_inr",
"buy_date",
"buy_price",
"buy_price_inr",
"cost_of_acquisition",
"cost_of_acquisition_inr",
"sell_date",
"sell_price",
"sell_price_inr",
"total_cost_of_improvement",
"total_cost_of_improvement_inr",
"realized_pnl",
"realized_pnl_inr",
"transfer_expenses",
"transfer_expenses_inr",
"net_realized_pnl",
"net_realized_pnl_inr"
],
"rows": [
[
"6abba3b3-d061-45f5-a947-c6a944663605",
"jewelry",
"jew",
"India",
"INR",
"short_term",
17500100,
17500100,
1696185000000,
25000000,
25000000,
0,
null,
1712255400000,
17500100,
17500100,
0,
0,
-7499900,
-7499900,
10000,
10000,
-7509900,
-7509900
],
[
"592994fb-3b14-4ec7-9203-502cd8927bec",
"art",
"art",
"India",
"INR",
"long_term",
24520000,
24520000,
1286649000000,
9590000,
9590000,
0,
null,
1712169000000,
24520000,
24520000,
250000,
250000,
14930000,
14930000,
17000,
17000,
14663000,
14663000
],
[
"991d604c-989f-4530-948b-fa2e609c2d56",
"car",
"car",
"India",
"INR",
"long_term",
24582000,
24582000,
1286649000000,
8590010,
8590010,
0,
null,
1712169000000,
24582000,
24582000,
250000,
250000,
15991990,
15991990,
17000,
17000,
15724990,
15724990
],
[
"cfb66c3b-ae78-4559-9755-ee83ba1f5540",
"other",
"other",
"India",
"INR",
"short_term",
1309000,
1309000,
1697740200000,
2301010,
2301010,
0,
null,
1712169000000,
1309000,
1309000,
1330,
1330,
-992010,
-992010,
12400,
12400,
-1005740,
-1005740
]
],
"name": "tradewise_pnl_table"
},
{
"@entity": "table",
"header": [
"settlement_id",
"financial_year",
"cost",
"indexed_cost"
],
"rows": [
[
"592994fb-3b14-4ec7-9203-502cd8927bec",
"FY 2011-12",
250000,
493206.52
],
[
"991d604c-989f-4530-948b-fa2e609c2d56",
"FY 2012-13",
250000,
453750
],
[
"cfb66c3b-ae78-4559-9755-ee83ba1f5540",
"FY 2023-24",
1330,
1387.33
]
],
"name": "cost_of_improvement_table"
}
],
"name": "tradewise_pnl_sheet"
}
],
"name": "other_tradewise_pnl_workbook"
},
"timestamp": "1740056171000"
}Check the processing status of an other assets P&L job.
curl --request POST \
--url https://api.sandbox.co.in/it/calculator/pnl/other \
--header 'Authorization: <authorization>' \
--header 'Content-Type: application/json' \
--header 'x-api-key: <x-api-key>' \
--header 'x-api-version: <x-api-version>' \
--data '
{
"name": "other_tradewise_settlement_workbook",
"@entity": "workbook",
"sheets": [
{
"name": "tradewise_settlement_sheet",
"@entity": "sheet",
"blocks": [
{
"name": "tradewise_settlement_table",
"@entity": "table",
"header": [
"serial_number",
"asset_type",
"asset_name",
"country",
"currency",
"buy_date",
"buy_price",
"cost_of_acquisition",
"sell_date",
"sell_price",
"transfer_expenses"
],
"rows": [
[
"6abba3b3-d061-45f5-a947-c6a944663605",
"jewelry",
"jew",
"india",
"INR",
1696185000000,
25000000,
25000000,
1712255400000,
17500100,
10000
],
[
"592994fb-3b14-4ec7-9203-502cd8927bec",
"art",
"art",
"india",
"INR",
1286649000000,
9590000,
9590000,
1712169000000,
24520000,
17000
],
[
"991d604c-989f-4530-948b-fa2e609c2d56",
"car",
"car",
"india",
"INR",
1286649000000,
8590010,
8590010,
1712169000000,
24582000,
17000
],
[
"cfb66c3b-ae78-4559-9755-ee83ba1f5540",
"other",
"other",
"india",
"INR",
1697740200000,
2301010,
2301010,
1712169000000,
1309000,
12400
]
]
},
{
"name": "cost_of_improvement_table",
"@entity": "table",
"header": [
"settlement_serial_number",
"financial_year",
"cost",
"indexed_cost"
],
"rows": [
[
"592994fb-3b14-4ec7-9203-502cd8927bec",
"FY 2011-12",
250000,
null
],
[
"991d604c-989f-4530-948b-fa2e609c2d56",
"FY 2012-13",
250000,
null
],
[
"cfb66c3b-ae78-4559-9755-ee83ba1f5540",
"FY 2023-24",
1330,
null
]
]
}
]
}
]
}
'{
"transaction_id": "9529f60d-ab22-4138-ac58-9b6bcdbd843c",
"code": 200,
"data": {
"@entity": "workbook",
"sheets": [
{
"@entity": "sheet",
"blocks": [
{
"@entity": "table",
"header": [
"settlement_id",
"asset_type",
"asset_name",
"country",
"currency",
"holding_period",
"turnover",
"turnover_inr",
"buy_date",
"buy_price",
"buy_price_inr",
"cost_of_acquisition",
"cost_of_acquisition_inr",
"sell_date",
"sell_price",
"sell_price_inr",
"total_cost_of_improvement",
"total_cost_of_improvement_inr",
"realized_pnl",
"realized_pnl_inr",
"transfer_expenses",
"transfer_expenses_inr",
"net_realized_pnl",
"net_realized_pnl_inr"
],
"rows": [
[
"6abba3b3-d061-45f5-a947-c6a944663605",
"jewelry",
"jew",
"India",
"INR",
"short_term",
17500100,
17500100,
1696185000000,
25000000,
25000000,
0,
null,
1712255400000,
17500100,
17500100,
0,
0,
-7499900,
-7499900,
10000,
10000,
-7509900,
-7509900
],
[
"592994fb-3b14-4ec7-9203-502cd8927bec",
"art",
"art",
"India",
"INR",
"long_term",
24520000,
24520000,
1286649000000,
9590000,
9590000,
0,
null,
1712169000000,
24520000,
24520000,
250000,
250000,
14930000,
14930000,
17000,
17000,
14663000,
14663000
],
[
"991d604c-989f-4530-948b-fa2e609c2d56",
"car",
"car",
"India",
"INR",
"long_term",
24582000,
24582000,
1286649000000,
8590010,
8590010,
0,
null,
1712169000000,
24582000,
24582000,
250000,
250000,
15991990,
15991990,
17000,
17000,
15724990,
15724990
],
[
"cfb66c3b-ae78-4559-9755-ee83ba1f5540",
"other",
"other",
"India",
"INR",
"short_term",
1309000,
1309000,
1697740200000,
2301010,
2301010,
0,
null,
1712169000000,
1309000,
1309000,
1330,
1330,
-992010,
-992010,
12400,
12400,
-1005740,
-1005740
]
],
"name": "tradewise_pnl_table"
},
{
"@entity": "table",
"header": [
"settlement_id",
"financial_year",
"cost",
"indexed_cost"
],
"rows": [
[
"592994fb-3b14-4ec7-9203-502cd8927bec",
"FY 2011-12",
250000,
493206.52
],
[
"991d604c-989f-4530-948b-fa2e609c2d56",
"FY 2012-13",
250000,
453750
],
[
"cfb66c3b-ae78-4559-9755-ee83ba1f5540",
"FY 2023-24",
1330,
1387.33
]
],
"name": "cost_of_improvement_table"
}
],
"name": "tradewise_pnl_sheet"
}
],
"name": "other_tradewise_pnl_workbook"
},
"timestamp": "1740056171000"
}Your API key used to authenticate and authorize the request.
Indicates the version of the API you want to use. Ensures backward-compatible behavior.
Token for user-level authorization.
Was this page helpful?