Calculate Tax Loss Harvesting From Tradebook

{
    "sheets": [
        {
            "name": "Equity",
            "blocks": [
                {
                    "name": "Tradebook",
                    "@entity": "table",
                    "header": [
                        [
                            "isin",
                            "symbol",
                            "quantity",
                            "date",
                            "price",
                            "transaction_type",
                            "fmv",
                            "brokerage",
                            "clearing_charges",
                            "exchange_transaction_charges",
                            "sebi_turnover_fees",
                            "stt",
                            "stamp_duty",
                            "sgst",
                            "cgst",
                            "igst",
                            "other_transfer_expenses",
                            "corporate_action"
                        ]
                    ],
                    "rows": [
                        [
                            null,
                            "RIL",
                            1,
                            1643380439478,
                            2.59,
                            "SELL",
                            0,
                            1,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "INFY",
                            0.7644,
                            1643380387229,
                            164.29,
                            "SELL",
                            0,
                            1,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "INFY",
                            0.1,
                            1634751623480,
                            148.5,
                            "BUY",
                            0,
                            0.99,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "INFY",
                            0.6644,
                            1634147917942,
                            143.29,
                            "BUY",
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "RIL",
                            1,
                            1630598986512,
                            9.63,
                            "BUY",
                            0,
                            0.05,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "TCS",
                            0.4347826,
                            1628536115398,
                            9.2,
                            "SELL",
                            0,
                            3,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "HDFCBANK",
                            0.00149749,
                            1628536054329,
                            3338.92,
                            "BUY",
                            0,
                            2.99,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "HUL",
                            2.55754475,
                            1628189423570,
                            15.77,
                            "SELL",
                            0,
                            3,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "HUL",
                            2.55754475,
                            1628189293460,
                            15.64,
                            "BUY",
                            0,
                            2.99,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "TCS",
                            1.10987791,
                            1628017687633,
                            9.01,
                            "BUY",
                            0,
                            2.99,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "ITC",
                            0.2,
                            1626457655107,
                            9.75,
                            "BUY",
                            0,
                            2.99,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "Mutual Funds",
            "blocks": [
                {
                    "name": "Tradebook",
                    "@entity": "table",
                    "header": [
                        [
                            "isin",
                            "type",
                            "symbol",
                            "quantity",
                            "date",
                            "price",
                            "transaction_type",
                            "fmv",
                            "brokerage",
                            "clearing_charges",
                            "exchange_transaction_charges",
                            "sebi_turnover_fees",
                            "stt",
                            "stamp_duty",
                            "sgst",
                            "cgst",
                            "igst",
                            "other_transfer_expenses",                            
                            "corporate_action"
                        ]
                    ],
                    "rows": [
                        [
                            null,
                            "Equity",
                            "HDFC Flexi Cap Fund",
                            50.0,
                            1599589800001,
                            6.0,
                            "BUY",
                            0,
                            2.99,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "Equity",
                            "HDFC Flexi Cap Fund",
                            35.0,
                            1643804395000,
                            8.5,
                            "SELL",
                            0,
                            2.99,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ],
                        [
                            null,
                            "Debt",
                            "Tata Digital India Fund",
                            35.0,
                            1599589800001,
                            6,
                            "BUY",
                            0,
                            2.99,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            null
                        ]
                    ]
                }
            ]
        }
    ]
}
Language
Click Try It! to start a request and see the response here!