Calculate Scripwise Trade from Tradewise Trades

Calculate scripwise aggregation from Tradewise reported transactions.

{
    "sheets": [
        {
            "name": "Equity",
            "blocks": [
                {
                    "name": "Equity",
                    "rows": [
                        [
                            "isin",
                            "symbol",
                            "quantity",
                            "buy_date",
                            "buy_average",
                            "sell_date",
                            "sell_average",
                            "fmv",
                            "brokerage",
                            "clearing_charges",
                            "exchange_transaction_charges",
                            "sebi_turnover_fees",
                            "stt",
                            "stamp_duty",
                            "sgst",
                            "cgst",
                            "igst",
                            "other_transfer_expenses",
                            "corporate_action"
                        ],
                        [
                            "INE428A01015",
                            "Allahabad Bank",
                            1,
                            "13/02/2020",
                            11.725,
                            "20/03/2020",
                            15.4,
                            null,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            "BUY_BACK"
                        ],
                        [
                            "INE428A01015",
                            "Allahabad Bank",
                            1,
                            "18/03/2020",
                            8.05,
                            "20/03/2020",
                            11.725,
                            null,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            "BUY_BACK"
                        ]
                    ]
                }
            ]
        },
        {
            "name": "Futures & Options",
            "blocks": [
                {
                    "name": "Futures & Options",
                    "rows": [
                        [
                            "symbol",
                            "type",
                            "quantity",
                            "buy_average",
                            "sell_average",
                            "brokerage",
                            "clearing_charges",
                            "exchange_transaction_charges",
                            "sebi_turnover_fees",
                            "stt",
                            "stamp_duty",
                            "sgst",
                            "cgst",
                            "igst",
                            "other_transfer_expenses"
                        ],
                        [
                            "NIFTY",
                            "Futures",
                            75,
                            11080.131666666666,
                            11050.8675,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ],
                        [
                            "NIFTY",
                            "Options",
                            75,
                            81.747734375,
                            82.152265625,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ],
                        [
                            "NIFTY",
                            "Options",
                            75,
                            9.43546630859375,
                            8.91453369140625,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ]
                    ]
                }
            ]
        }
    ]
}
Language
Response
Click Try It! to start a request and see the response here!