post https://api.sandbox.co.in/it-calculator/crypto/tax-pnl/tradebook/spreadsheet
Calculates Tax P&L from Tradebook for Crypto and returns signed URL of the spreadsheet
Important Links
Request Body Example
{
"@entity": "workbook",
"name": "tradebook_workbook",
"sheets": [
{
"name": "tradebook_sheet",
"metadata": {},
"blocks": [
{
"name": "tradebook_table",
"@entity": "table",
"header": [
"id",
"date",
"transaction_type",
"label",
"received_currency",
"received_quantity",
"price",
"price_currency",
"price_in_inr",
"sent_currency",
"sent_quantity",
"fees_currency",
"fees_amount",
"fee_in_inr"
],
"rows": [
[
"111",
1617235200000,
"buy",
null,
"BUSD",
49.4698,
75,
"INR",
null,
null,
null,
null,
null,
null
],
[
"222",
1617321600000,
"buy",
null,
"ETH",
0.25,
1000,
"INR",
null,
null,
null,
null,
null,
null
],
[
"333",
1620604800000,
"sell",
null,
null,
null,
90,
"INR",
null,
"BUSD",
24.7349,
null,
null,
null
],
[
"444",
1623369600000,
"trade",
null,
"LUNA",
0.31,
79.79,
"BUSD",
6562.7275,
"BUSD",
24.7349,
null,
null,
null
],
[
"555",
1624147200000,
"trade",
null,
"BUSD",
15.009,
100.06,
"BUSD",
8229.935,
"LUNA",
0.15,
null,
null,
null
],
[
"666",
1624233600000,
"trade",
null,
"BUSD",
15.5856,
100.06,
"BUSD",
8229.935,
"LUNA",
0.16,
null,
null,
null
],
[
"777",
1625097600000,
"receive",
"airdrop",
"BUSD",
1,
null,
null,
85,
null,
null,
null,
null,
null
],
[
"888",
1625875200000,
"receive",
"interest",
"LUNA",
0.31,
null,
null,
9000,
null,
null,
null,
null,
null
],
[
"999",
1628121600000,
"receive",
"staking_reward",
"MATIC",
10,
null,
null,
240,
null,
null,
null,
null,
null
],
[
"101010",
1628553600000,
"send",
"lost",
null,
null,
null,
null,
2000,
"ETH",
0.15,
null,
null,
null
],
[
"111111",
1636588800000,
"receive",
"mining_reward",
"ETH",
0.25,
null,
null,
1800,
null,
null,
null,
null,
null
],
[
"121212",
1637366400000,
"sell",
null,
null,
null,
1200,
"INR",
null,
"ETH",
0.3,
null,
null,
null
]
]
}
]
}
]
}