Tradewise Settlements

Important Links

View Entity View Workbook

📘

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
                        ]
                    ]
                }
            ]
        }
    ]
}