Calculate Aggregate Income from Trades

Calculate Aggregate income using tradewise or scripwise 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
                        ]
                    ]
                }
            ]
        }
    ]
}
{
    "sheets": [
        {
            "blocks": [
                {
                    "name": "Equity",
                    "rows": [
                        [
                            "isin",
                            "symbol",
                            "quantity",
                            "buy_average",
                            "sell_average",
                            "fmv",
                            "holding_period",
                            "brokerage",
                            "clearing_charges",
                            "exchange_transaction_charges",
                            "sebi_turnover_fees",
                            "stt",
                            "stamp_duty",
                            "sgst",
                            "cgst",
                            "igst",
                            "other_transfer_expenses",
                            "corporate_action"
                        ],
                        [
                            "INE428A01015",
                            "Allahabad Bank",
                            1,
                            8.05,
                            11.725,
                            null,
                            "Short Term",
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            "BUY_BACK"
                        ],
                        [
                            "INE428A01015",
                            "Allahabad Bank",
                            1,
                            11.725,
                            15.4,
                            11.725,
                            "Short Term",
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            "BUY_BACK"
                        ]
                    ]
                }
            ],
            "name": "Equity"
        },
        {
            "blocks": [
                {
                    "name": "Mutual Funds",
                    "rows": [
                        [
                            "isin",
                            "scheme_type",
                            "symbol",
                            "quantity",
                            "buy_average",
                            "sell_average",
                            "fmv",
                            "holding_period",
                            "brokerage",
                            "clearing_charges",
                            "exchange_transaction_charges",
                            "sebi_turnover_fees",
                            "stt",
                            "stamp_duty",
                            "sgst",
                            "cgst",
                            "igst",
                            "other_transfer_expenses",
                            "corporate_action"
                        ],
                        [
                            "INE428A01015",
                            "Debt",
                            "Allahabad Bank",
                            10,
                            8.05,
                            11.725,
                            null,
                            "Short Term",
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            "INE428A01015",
                            "Debt",
                            "Allahabad Bank",
                            10,
                            110.725,
                            150.4,
                            110.725,
                            "Long Term",
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ]
                    ]
                }
            ],
            "name": "Mutual Funds"
        },
        {
            "blocks": [
                {
                    "name": "Futures & Options",
                    "rows": [
                        [
                            "symbol",
                            "contract_type",
                            "quantity",
                            "buy_average",
                            "sell_average",
                            "holding_period",
                            "brokerage",
                            "clearing_charges",
                            "exchange_transaction_charges",
                            "sebi_turnover_fees",
                            "stt",
                            "stamp_duty",
                            "sgst",
                            "cgst",
                            "igst",
                            "other_transfer_expenses"
                        ],
                        [
                            "NIFTY",
                            "Options",
                            150,
                            43.1812,
                            43.0921,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ],
                        [
                            "NIFTY",
                            "Futures",
                            75,
                            11080.1317,
                            11050.8675,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ]
                    ]
                }
            ],
            "name": "Futures & Options"
        }
    ]
}
Language
Response
Click Try It! to start a request and see the response here!