PUT Request

📘

PUT Request on Presigned URL

Once the job is successfully created, upload the payload using HTTP PUT method on generated presigned url. Read More

JSON Payload

This API accepts payload in following three formats:

Tradebook

View Workbook

👍

Click here to learn more about this JSON Payload

{
    "name": "tradebook_workbook",
    "@entity": "workbook",
    "sheets": [
        {
            "name": "stock_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "stock_tradebook_table",
                    "@entity": "table",
                    "header": [
                        "trade_id",
                        "isin",
                        "symbol",
                        "is_listed",
                        "is_stt_paid",
                        "quantity",
                        "date",
                        "price",
                        "transaction_type",
                        "fmv",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fees",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "label",
                        "product_type"
                    ],
                    "rows": [
                        [
                            "SUNMAQYIBRDSM4Y2TVW9",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            true,
                            25,
                            1718582400000,
                            4203.45,
                            "buy",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "CJ1CLC4YCBFEZ4CVDNMH",
                            "INE002A01018",
                            "AJANTAPHARMA",
                            true,
                            true,
                            1590,
                            1463356800000,
                            136,
                            "buy",
                            438,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "PEB6U5ERJBDTNFSLPOI2",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            true,
                            37,
                            1482451200000,
                            4089,
                            "buy",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "KZUG2ZMGMH4WFE2C9RMG",
                            "INE03Q201024",
                            "GLS",
                            true,
                            true,
                            50,
                            1499644800000,
                            5000,
                            "buy",
                            5500,
                            21.5,
                            22.6,
                            23.5,
                            58,
                            67,
                            21.5,
                            21.5,
                            21.5,
                            21.5,
                            21.5,
                            null,
                            "delivery "
                        ],
                        [
                            "VTHPFZ7KXVG5LMNZNBHT",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            1540,
                            1592611200000,
                            189,
                            "buy",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "YKSLVQ6HJEUROPF8Z7TL",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            435,
                            1602547200000,
                            209,
                            "buy",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "KQN4SO7YRL1T1YKS8XSO",
                            "INE01C001018",
                            "ADANIPORTS",
                            true,
                            true,
                            348,
                            1631145600000,
                            270,
                            "buy",
                            137,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "XEPL8VAO3PWPBVZRBSCE",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            200,
                            1631923200000,
                            221,
                            "buy",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "XEPL8VAO3PWPBVZRBSCE",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            85,
                            1632009600000,
                            225,
                            "buy",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "ZVQAT2PZ1RSLYWWYZTXP",
                            "INE767A01016",
                            "ADANIENT",
                            true,
                            true,
                            57,
                            1710288000000,
                            1950,
                            "buy",
                            1260,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "90VSCSRGLVSHW6FYHQDE",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            false,
                            85,
                            1741824000000,
                            269,
                            "buy",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "OUYO53NES6HVEGSBXALX",
                            "INE364U01010",
                            "ADANIGREEN",
                            true,
                            false,
                            15,
                            1712275200000,
                            281,
                            "buy",
                            127,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "YYUFIXODHUCNJPZL0TB1",
                            "INE767A01016",
                            "ADANIENT",
                            true,
                            true,
                            23,
                            1745884800000,
                            2016,
                            "buy",
                            1260,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "ZR0GPABQCZJDEBAVL85E",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            true,
                            29,
                            1746921600000,
                            4198.05,
                            "buy",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "ZDUUQFIZKFI1LPZJIGC1",
                            "INE364U01010",
                            "ADANIGREEN",
                            true,
                            true,
                            47,
                            1749340800000,
                            310,
                            "buy",
                            127,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "J9SYLEPLST8YFGPUOFCG",
                            "INE002A01018",
                            "AJANTAPHARMA",
                            true,
                            true,
                            145,
                            1749945600000,
                            578,
                            "buy",
                            438,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "KZ4XUMQL7O4OL1T0NWLW",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            140,
                            1750032000000,
                            327,
                            "buy",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "KZ4XUMQL7O4OL1T0NWLW",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            false,
                            267,
                            1718582400000,
                            329,
                            "buy",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "RP9WLFA5LS29NBTKARXN",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            false,
                            25,
                            1752278400000,
                            4254,
                            "buy",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "G3NSSV7XHVFUJ8BTPBIR",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            true,
                            29,
                            1752364800000,
                            4221,
                            "buy",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "JOQYLFGNAJXEBBANLTJ9",
                            "INE364U01010",
                            "ADANIGREEN",
                            true,
                            true,
                            20,
                            1752710400000,
                            290,
                            "buy",
                            127,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "RZ4TQQXBXGQZ4CIGW89W",
                            "INE01C001018",
                            "ADANIPORTS",
                            true,
                            false,
                            30,
                            1752796800000,
                            410,
                            "buy",
                            137,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "ABHV4GJO8FEWYZYYZXJ9",
                            "INE01C001018",
                            "ADANIPORTS",
                            true,
                            true,
                            20,
                            1721174400000,
                            429,
                            "buy",
                            137,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "VQLDME6IOJZR95BDEKQ9",
                            "INE010B01019",
                            "CADILAHC",
                            true,
                            false,
                            254,
                            1724025600000,
                            1290.98,
                            "buy",
                            120,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "XAOZHKSKJV0S5IENATLG",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            false,
                            28,
                            1759017600000,
                            4289,
                            "buy",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "8BARHLFV3FZVGYTSJ012",
                            "INE03Q201024",
                            "GLS",
                            true,
                            true,
                            50,
                            1721433600000,
                            5000,
                            "sell",
                            5500,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "CYX9TQSTWUYK8C9Z7BCE",
                            "INE002A01018",
                            "AJANTAPHARMA",
                            true,
                            true,
                            645,
                            1713594550000,
                            580,
                            "sell",
                            438,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "VXFUFI5Q9HH7FEJPLV3B",
                            "INE010B01019",
                            "CADILAHC",
                            true,
                            true,
                            254,
                            1724025600000,
                            1301.78,
                            "sell",
                            120,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "JOVR7LN5HKWR3H7LR3LK",
                            "INE364U01010",
                            "ADANIGREEN",
                            true,
                            true,
                            15,
                            1712275200000,
                            250,
                            "sell",
                            127,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "K0TMWRLU5HDBSNDITGWA",
                            "INE01C001018",
                            "ADANIPORTS",
                            true,
                            true,
                            256,
                            1714262400000,
                            409,
                            "sell",
                            137,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "NJK6VY186PT29EQOL5ZS",
                            "INE767A01016",
                            "ADANIENT",
                            true,
                            true,
                            60,
                            1726963200000,
                            2300,
                            "sell",
                            1260,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "DPB5UCBWCTWCCZQZAECT",
                            "INE767A01016",
                            "ADANIENT",
                            true,
                            true,
                            20,
                            1727395200000,
                            2456,
                            "sell",
                            1260,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "OCFAGNA9WLZOS2GPVEWY",
                            "INE364U01010",
                            "ADANIGREEN",
                            true,
                            true,
                            40,
                            1716681600000,
                            365,
                            "sell",
                            127,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "USTNCKBL23ZGYFBS1FWW",
                            "INE01C001018",
                            "ADANIPORTS",
                            true,
                            true,
                            44,
                            1714521600000,
                            418,
                            "sell",
                            137,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "AMLDHHSPBR225CYDH1G3",
                            "INE01C001018",
                            "ADANIPORTS",
                            true,
                            true,
                            20,
                            1752796800000,
                            436,
                            "sell",
                            137,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "G4FILRR9JSAWETX5BFEG",
                            "INE01C001018",
                            "ADANIPORTS",
                            true,
                            true,
                            58,
                            1727568000000,
                            447,
                            "sell",
                            137,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "3S1E2CVMTK3I115OG5IT",
                            "INE002A01018",
                            "AJANTAPHARMA",
                            true,
                            true,
                            900,
                            1734412800000,
                            618,
                            "sell",
                            438,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "HJWC2DJPNJV7KBYAVLMP",
                            "INE002A01018",
                            "AJANTAPHARMA",
                            true,
                            true,
                            190,
                            1724544000000,
                            689,
                            "sell",
                            438,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "8LWK9OAGZ64HKNYHYX6H",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            true,
                            31,
                            1713484800000,
                            4217.67,
                            "sell",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "ROJM9PXLTVRGADTWZXMX",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            true,
                            10,
                            1716076800000,
                            4228,
                            "sell",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "ROJM9PXLTVRGADTWZXMX",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            true,
                            9,
                            1716076800000,
                            4249,
                            "sell",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "UCB2JO0JMYBFRYRHILMZ",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            true,
                            25,
                            1752278400000,
                            4239,
                            "sell",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "1JQ2PDASHYXZCVH6IFTC",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            true,
                            70,
                            1725062400000,
                            4278.08,
                            "sell",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "AU2VBOKJGOGV82FMOSZL",
                            "INE462A01022",
                            "BAYERCROP",
                            true,
                            true,
                            28,
                            1727568000000,
                            4298,
                            "sell",
                            4199.55,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "IAVLRAW3OKLIHPD0DLKQ",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            640,
                            1708819200000,
                            265,
                            "sell",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "YHEZMWYMV85DIO52CY1B",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            110,
                            1707868800000,
                            257,
                            "sell",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "DLQMNK7WJJEH6SZOCZO6",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            85,
                            1741824000000,
                            273,
                            "sell",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "7UBKDTDSUWJEWXI71MB5",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            250,
                            1714262400000,
                            317,
                            "sell",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "SVYLOESSMFAWL2P1V4YN",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            260,
                            1716076800000,
                            334,
                            "sell",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "UZB55NEDOEZEB81QTBOI",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            267,
                            1718582400000,
                            321,
                            "sell",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "intraday"
                        ],
                        [
                            "T2D14C472FNCQD8A9SEL",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            730,
                            1721520000000,
                            339,
                            "sell",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "IHQR3WDABXX5LWECAVD4",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            349,
                            1722297600000,
                            345,
                            "sell",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ],
                        [
                            "ZJZZOQLJZWYQRMSHK2E3",
                            "INE00E101023",
                            "BIKAJI",
                            true,
                            true,
                            321,
                            1725062400000,
                            370,
                            "sell",
                            0,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            45.6,
                            null,
                            "delivery"
                        ]
                    ]
                }
            ]
        },
        {
            "name": "future_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "future_tradebook_table",
                    "@entity": "table",
                    "header": [
                        "trade_id",
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "date",
                        "price",
                        "transaction_type",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fees",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "label"
                    ],
                    "rows": [
                        [
                            "GGFCHMYLKDQYZRRINTEE",
                            "INE914J01012",
                            "BANKNIFTY 01 Jun 2023 FUT",
                            "equity",
                            45,
                            1711756800000,
                            363.1,
                            "buy",
                            51,
                            98,
                            75,
                            55,
                            32,
                            219,
                            11,
                            142,
                            55,
                            36,
                            null
                        ],
                        [
                            "AUGUWEK01EI4YOIMH7RK",
                            "INE519I01013",
                            "BANKNIFTY 15 Jun 2023 FUT",
                            "equity",
                            50,
                            1714176000000,
                            363.15,
                            "buy",
                            7,
                            56,
                            55,
                            223,
                            245,
                            330,
                            106,
                            144,
                            103,
                            9,
                            null
                        ],
                        [
                            "55MCNYCUWJO7C3ZAXWIX",
                            "INE512D09106",
                            "FUTCOM CRUDEOIL 16 OCT 2022",
                            "commodity",
                            100,
                            1727731200000,
                            415,
                            "buy",
                            107,
                            8,
                            114,
                            111,
                            90,
                            43,
                            36,
                            48,
                            119,
                            21,
                            null
                        ],
                        [
                            "JDNI9UJFKN2PGFJZ5U9O",
                            "INE579I01014",
                            "FUTCUR USDINR 27 JAN 2023 ",
                            "currency",
                            135,
                            1728585600000,
                            90.69,
                            "buy",
                            134,
                            183,
                            209,
                            9,
                            100,
                            50,
                            202,
                            60,
                            140,
                            214,
                            null
                        ],
                        [
                            "5NGIOMFGDRBG5Q8XTNBP",
                            "INE512R02109",
                            "NIFTY 23 JAN 2023 FUT",
                            "equity",
                            75,
                            1728412800000,
                            147.89,
                            "buy",
                            143,
                            44,
                            39,
                            61,
                            130,
                            216,
                            102,
                            90,
                            158,
                            37,
                            null
                        ],
                        [
                            "ANH3LZISNL7R8DPFNHJ0",
                            "INE512R02109",
                            "NIFTY 23 JAN 2023 FUT",
                            "equity",
                            125,
                            1728979200000,
                            153.89,
                            "buy",
                            84,
                            60,
                            3,
                            129,
                            221,
                            239,
                            11,
                            42,
                            160,
                            8,
                            null
                        ],
                        [
                            "S4LOWQJP4P6SFB42C460",
                            "INE769A01020",
                            "FINNIFTY 25 JAN 2023 FUT",
                            "equity",
                            35,
                            1729756800000,
                            3450.67,
                            "buy",
                            23,
                            98,
                            64,
                            214,
                            268,
                            161,
                            118,
                            116,
                            9,
                            21,
                            null
                        ],
                        [
                            "Z0FCJBWODSL8GF3KKVPY",
                            "INE563D01013",
                            "NIFTY 15 JAN 2023 FUT",
                            "equity",
                            250,
                            1730620800000,
                            168,
                            "buy",
                            27,
                            73,
                            8,
                            224,
                            284,
                            306,
                            42,
                            111,
                            5,
                            17,
                            null
                        ],
                        [
                            "CIKTMLOWJQLROEGJXMFF",
                            "INE118D01016",
                            "NIFTY 25 JAN 2023 FUT",
                            "equity",
                            100,
                            1729584000000,
                            175.55,
                            "buy",
                            65,
                            76,
                            54,
                            192,
                            58,
                            74,
                            149,
                            50,
                            17,
                            20,
                            null
                        ],
                        [
                            "NKN2PS2TJZWDA9CDP1RA",
                            "INE002A01018",
                            "FINNIFTY 15 FEB 2023 FUT",
                            "equity",
                            155,
                            1730707200000,
                            194.9,
                            "buy",
                            39,
                            85,
                            72,
                            144,
                            40,
                            15,
                            16,
                            39,
                            66,
                            47,
                            null
                        ],
                        [
                            "TWF45MCZTDWEWSJXU3EF",
                            "INE0C5901014",
                            "NIFTY 23 FEB 2023 FUT",
                            "equity",
                            175,
                            1730828800000,
                            194.9,
                            "buy",
                            50,
                            107,
                            81,
                            244,
                            314,
                            247,
                            91,
                            42,
                            72,
                            44,
                            null
                        ],
                        [
                            "8LEGU2BN0HXVHXYBIIRZ",
                            "INE435D01014",
                            "BANKNIFTY 20 MAR 2023 FUT",
                            "equity",
                            125,
                            1730950400000,
                            1500,
                            "buy",
                            62,
                            53,
                            28,
                            146,
                            85,
                            446,
                            149,
                            77,
                            165,
                            22,
                            null
                        ],
                        [
                            "GB8MD1GQRMB7M3KIPYBT",
                            "INE0C5901014",
                            "NIFTY 17 APR 2023 FUT",
                            "equity",
                            145,
                            1731260800000,
                            457.89,
                            "buy",
                            131,
                            77,
                            80,
                            49,
                            161,
                            373,
                            17,
                            130,
                            77,
                            16,
                            null
                        ],
                        [
                            "GUEQKVCN1OGWGMPXO1WQ",
                            "INE322R01014",
                            "FINNIFTY 20 MAY 2023 FUT",
                            "equity",
                            130,
                            1731699200000,
                            698.03,
                            "buy",
                            85,
                            110,
                            89,
                            148,
                            121,
                            426,
                            32,
                            65,
                            22,
                            31,
                            null
                        ],
                        [
                            "JG3ZELDXI8SYG4HLXSCG",
                            "INE694N01015",
                            "RIL 15 OCT 2023 FUT",
                            "equity",
                            50,
                            1726963200000,
                            559.39,
                            "buy",
                            111,
                            42,
                            44,
                            189,
                            145,
                            307,
                            57,
                            64,
                            43,
                            28,
                            null
                        ],
                        [
                            "1HLEP1MBFH5JINCYGEJB",
                            "INE197R01010",
                            "RIL 01 NOV 2023 FUT",
                            "equity",
                            175,
                            1728000000000,
                            1000,
                            "buy",
                            72,
                            52,
                            33,
                            117,
                            71,
                            327,
                            39,
                            67,
                            132,
                            3,
                            null
                        ],
                        [
                            "YFVS53SUIXO1FBXICSP8",
                            "INE576G01015",
                            "INFY 30 OCT 2023 FUT",
                            "equity",
                            100,
                            1728518400000,
                            175,
                            "buy",
                            40,
                            81,
                            12,
                            197,
                            124,
                            314,
                            159,
                            79,
                            166,
                            3,
                            null
                        ],
                        [
                            "EGTDOZWR9NJKLHJDXYSO",
                            "INE197R01010",
                            "RIL 31 OCT 2023 FUT",
                            "equity",
                            250,
                            1728864000000,
                            186,
                            "buy",
                            150,
                            2,
                            17,
                            244,
                            29,
                            366,
                            100,
                            41,
                            15,
                            36,
                            null
                        ],
                        [
                            "JBJYWGG6VA3VFF3J7OWZ",
                            "INE512R01010",
                            "INFY 25 OCT FUT",
                            "equity",
                            225,
                            1729123200000,
                            180,
                            "buy",
                            69,
                            65,
                            61,
                            243,
                            278,
                            69,
                            18,
                            109,
                            55,
                            17,
                            null
                        ],
                        [
                            "52VUZC1SJ5MW4IKAJPIA",
                            "INE512D09106",
                            "FUTCOM CRUDEOIL 16 OCT 2022",
                            "commodity",
                            25,
                            1727817600000,
                            423,
                            "sell",
                            106,
                            107,
                            78,
                            45,
                            79,
                            100,
                            14,
                            58,
                            70,
                            85,
                            null
                        ],
                        [
                            "2FPD4QFGHO2ICG3SK0KG",
                            "INE512D09106",
                            "FUTCOM CRUDEOIL 16 OCT 2022",
                            "commodity",
                            50,
                            1728681600000,
                            456,
                            "buy",
                            80,
                            89,
                            33,
                            66,
                            61,
                            71,
                            116,
                            120,
                            55,
                            33,
                            null
                        ],
                        [
                            "XPDDDCPTROUOHFWCQH7O",
                            "INE512D09106",
                            "FUTCOM CRUDEOIL 16 OCT 2022",
                            "commodity",
                            125,
                            1729804800000,
                            449,
                            "sell",
                            4,
                            73,
                            78,
                            84,
                            113,
                            71,
                            1,
                            75,
                            118,
                            18,
                            null
                        ],
                        [
                            "KMY2EC1UMISH0BUMIEGT",
                            "INE573G07017",
                            "FUTCOM SILVERM 21 Nov 2022 ",
                            "commodity",
                            50,
                            1729632000000,
                            135,
                            "buy",
                            237,
                            56,
                            15,
                            18,
                            104,
                            15,
                            22,
                            76,
                            89,
                            112,
                            null
                        ],
                        [
                            "KMY2EC1UMISH0BUMIEGT",
                            "INE573G07017",
                            "FUTCOM SILVERM 21 Nov 2022 ",
                            "commodity",
                            80,
                            1729632000000,
                            142,
                            "buy",
                            188,
                            53,
                            11,
                            89,
                            31,
                            92,
                            119,
                            77,
                            58,
                            6,
                            null
                        ],
                        [
                            "JAWOZXSLWYKHKUWGWS6L",
                            "INE573G07017",
                            "FUTCOM SILVERM 21 Nov 2022 ",
                            "commodity",
                            70,
                            1729728000000,
                            148,
                            "sell",
                            77,
                            57,
                            74,
                            83,
                            42,
                            83,
                            110,
                            104,
                            60,
                            102,
                            null
                        ],
                        [
                            "JAWOZXSLWYKHKUWGWS6L",
                            "INE573G07017",
                            "FUTCOM SILVERM 21 Nov 2022 ",
                            "commodity",
                            30,
                            1729814400000,
                            150,
                            "sell",
                            187,
                            112,
                            77,
                            67,
                            93,
                            19,
                            84,
                            19,
                            54,
                            47,
                            null
                        ],
                        [
                            "1AW8BG2NTK1BPSLMR0TV",
                            "INE573G07017",
                            "FUTCOM SILVERM 21 Nov 2022 ",
                            "commodity",
                            140,
                            1730419200000,
                            137,
                            "buy",
                            234,
                            97,
                            29,
                            100,
                            39,
                            72,
                            49,
                            115,
                            110,
                            93,
                            null
                        ],
                        [
                            "XOUZUWMHBDCRPKRGDD1Q",
                            "INE573G07017",
                            "FUTCOM SILVERM 21 Nov 2022 ",
                            "commodity",
                            80,
                            1732060800000,
                            154,
                            "sell",
                            136,
                            76,
                            35,
                            49,
                            98,
                            56,
                            75,
                            2,
                            15,
                            75,
                            null
                        ],
                        [
                            "XOUZUWMHBDCRPKRGDD1Q",
                            "INE573G07017",
                            "FUTCOM SILVERM 21 Nov 2022 ",
                            "commodity",
                            20,
                            1732060800000,
                            153,
                            "buy",
                            211,
                            31,
                            34,
                            6,
                            18,
                            105,
                            104,
                            41,
                            67,
                            52,
                            null
                        ],
                        [
                            "LAGBHUZEYUH1K2OMGP49",
                            "INE573G07017",
                            "FUTCOM SILVERM 21 Nov 2022 ",
                            "commodity",
                            130,
                            1732492800000,
                            156,
                            "sell",
                            110,
                            41,
                            105,
                            57,
                            47,
                            64,
                            63,
                            34,
                            46,
                            26,
                            null
                        ],
                        [
                            "GR4XEL9XWBSYPARPT0EF",
                            "INE113J07012",
                            "FUTCOM GOLD 29 OCT 2023",
                            "commodity",
                            55,
                            1726012800000,
                            124.56,
                            "sell",
                            103,
                            48,
                            70,
                            111,
                            21,
                            40,
                            84,
                            69,
                            15,
                            16,
                            null
                        ],
                        [
                            "M5ZXEWJZFFR9DR1ECYIE",
                            "INE113J07012",
                            "FUTCOM GOLD 29 OCT 2023",
                            "commodity",
                            55,
                            1726272000000,
                            121,
                            "buy",
                            125,
                            52,
                            36,
                            22,
                            92,
                            17,
                            67,
                            79,
                            46,
                            109,
                            null
                        ],
                        [
                            "FUWODRFMJFABB1VZGX5D",
                            "INE113J07012",
                            "FUTCOM GOLD 29 NOV 2023",
                            "commodity",
                            85,
                            1728604800000,
                            135,
                            "buy",
                            212,
                            24,
                            78,
                            32,
                            52,
                            54,
                            7,
                            83,
                            8,
                            119,
                            null
                        ],
                        [
                            "XVFHRXHI6QWNJUUKBJ0J",
                            "INE113J07012",
                            "FUTCOM GOLD 29 NOV 2023",
                            "commodity",
                            35,
                            1729036800000,
                            138,
                            "buy",
                            25,
                            89,
                            59,
                            114,
                            63,
                            56,
                            108,
                            2,
                            64,
                            35,
                            null
                        ],
                        [
                            "OHNNDTMWFFACP6JQ82GM",
                            "INE113J07012",
                            "FUTCOM GOLD 29 NOV 2023",
                            "commodity",
                            90,
                            1731369600000,
                            142,
                            "sell",
                            108,
                            57,
                            19,
                            77,
                            25,
                            94,
                            115,
                            78,
                            71,
                            117,
                            null
                        ],
                        [
                            "RRCAFBZWEKTPVLYJCRB4",
                            "INE113J07012",
                            "FUTCOM GOLD 29 NOV 2023",
                            "commodity",
                            10,
                            1731542400000,
                            149,
                            "sell",
                            130,
                            3,
                            116,
                            15,
                            41,
                            119,
                            118,
                            26,
                            76,
                            77,
                            null
                        ],
                        [
                            "JDNI9UJFKN2PGFJZ5U9O",
                            "INE579I01014",
                            "FUTCUR USDINR 27 JAN 2023 ",
                            "currency",
                            145,
                            1728585600000,
                            87.45,
                            "buy",
                            212,
                            202,
                            223,
                            125,
                            116,
                            48,
                            71,
                            75,
                            100,
                            24,
                            null
                        ],
                        [
                            "4TXSMROXNCO4YKN01YBF",
                            "INE579I01014",
                            "FUTCUR USDINR 27 JAN 2023 ",
                            "currency",
                            165,
                            1728240000000,
                            94.78,
                            "sell",
                            177,
                            48,
                            234,
                            38,
                            176,
                            182,
                            159,
                            80,
                            200,
                            136,
                            null
                        ],
                        [
                            "D1VHUJNJ1WGO9JVCK2AZ",
                            "INE579I01014",
                            "FUTCUR USDINR 27 JAN 2023 ",
                            "currency",
                            100,
                            1729104000000,
                            45.98,
                            "sell",
                            97,
                            219,
                            153,
                            19,
                            118,
                            231,
                            228,
                            31,
                            185,
                            186,
                            null
                        ],
                        [
                            "D1VHUJNJ1WGO9JVCK2AZ",
                            "INE579I01014",
                            "FUTCUR USDINR 27 JAN 2023 ",
                            "currency",
                            15,
                            1729756800000,
                            78.3,
                            "sell",
                            94,
                            93,
                            127,
                            162,
                            79,
                            232,
                            149,
                            211,
                            83,
                            6,
                            null
                        ],
                        [
                            "UVSIUTXLTZHDRHICW9C0",
                            "INE645F01015",
                            "FUTCUR EURINR 13 MAY 2023",
                            "currency",
                            50,
                            1731174400000,
                            245.78,
                            "sell",
                            46,
                            228,
                            186,
                            237,
                            75,
                            6,
                            46,
                            97,
                            203,
                            34,
                            null
                        ],
                        [
                            "V7L7EV2WB1F06YIJSHQS",
                            "INE645F01015",
                            "FUTCUR EURINR 13 MAY 2023",
                            "currency",
                            50,
                            1731174400000,
                            260.7,
                            "buy",
                            178,
                            162,
                            152,
                            207,
                            202,
                            185,
                            95,
                            232,
                            121,
                            209,
                            null
                        ],
                        [
                            "8GTJ7JADP09KTKDPFWQJ",
                            "INE645F01015",
                            "FUTCUR EURINR 13 MAY 2023",
                            "currency",
                            145,
                            1731347200000,
                            278,
                            "sell",
                            20,
                            164,
                            152,
                            121,
                            98,
                            148,
                            35,
                            194,
                            110,
                            34,
                            null
                        ],
                        [
                            "XNAQJZ3OTJFDZ2FEGVVQ",
                            "INE645F01015",
                            "FUTCUR EURINR 13 MAY 2023",
                            "currency",
                            145,
                            1711756800000,
                            289,
                            "buy",
                            25,
                            85,
                            159,
                            60,
                            145,
                            36,
                            46,
                            146,
                            237,
                            157,
                            null
                        ],
                        [
                            "NU9Y7DKWYXX1B8HUGX0G",
                            "INE714H01019",
                            "FUTCUR GBPINR 27 OCT 2023",
                            "currency",
                            75,
                            1725667200000,
                            4500,
                            "buy",
                            21,
                            179,
                            65,
                            29,
                            21,
                            92,
                            124,
                            178,
                            153,
                            12,
                            null
                        ],
                        [
                            "NU9Y7DKWYXX1B8HUGX0G",
                            "INE714H01019",
                            "FUTCUR GBPINR 27 OCT 2023",
                            "currency",
                            75,
                            1725667200000,
                            4509,
                            "sell",
                            15,
                            93,
                            151,
                            111,
                            104,
                            103,
                            55,
                            238,
                            153,
                            97,
                            null
                        ],
                        [
                            "7BN92HT8TUYNDOW29YPQ",
                            "INE714H01019",
                            "FUTCUR GBPINR 27 OCT 2023",
                            "currency",
                            113,
                            1726185600000,
                            4492.367,
                            "buy",
                            57,
                            230,
                            240,
                            67,
                            116,
                            76,
                            6,
                            3,
                            169,
                            150,
                            null
                        ],
                        [
                            "QRJDSFMYL79ULAWADZ4C",
                            "INE714H01019",
                            "FUTCUR GBPINR 27 OCT 2023",
                            "currency",
                            60,
                            1726876800000,
                            4499.876,
                            "sell",
                            145,
                            184,
                            130,
                            50,
                            35,
                            17,
                            90,
                            146,
                            149,
                            199,
                            null
                        ],
                        [
                            "FZJQJNQWOJE78OSAKILB",
                            "INE714H01019",
                            "FUTCUR GBPINR 27 OCT 2023",
                            "currency",
                            43,
                            1728691200000,
                            5008.596,
                            "sell",
                            47,
                            22,
                            47,
                            31,
                            24,
                            32,
                            128,
                            195,
                            47,
                            87,
                            null
                        ],
                        [
                            "BZAB3NIFLVXCEWLNXF0C",
                            "INE632P01025",
                            "FUTCUR JPYINR 24 AUG 2023",
                            "currency",
                            120,
                            1731184000000,
                            345.89,
                            "sell",
                            7,
                            203,
                            116,
                            18,
                            12,
                            64,
                            159,
                            151,
                            211,
                            148,
                            null
                        ],
                        [
                            "EUCWBOWYUQF5LLS2MG9P",
                            "INE632P01025",
                            "FUTCUR JPYINR 24 AUG 2023",
                            "currency",
                            80,
                            1731788800000,
                            325.67,
                            "buy",
                            44,
                            87,
                            14,
                            179,
                            169,
                            178,
                            97,
                            26,
                            72,
                            170,
                            null
                        ],
                        [
                            "EUCWBOWYUQF5LLS2MG9P",
                            "INE632P01025",
                            "FUTCUR JPYINR 24 AUG 2023",
                            "currency",
                            30,
                            1731788800000,
                            319.78,
                            "buy",
                            89,
                            205,
                            71,
                            145,
                            106,
                            166,
                            209,
                            67,
                            6,
                            124,
                            null
                        ],
                        [
                            "MUYD0KEIED2TJLMOBKEM",
                            "INE632P01025",
                            "FUTCUR JPYINR 24 AUG 2023",
                            "currency",
                            40,
                            1731961600000,
                            329.587,
                            "sell",
                            59,
                            42,
                            140,
                            65,
                            52,
                            47,
                            80,
                            128,
                            39,
                            105,
                            null
                        ],
                        [
                            "DROFW5LAACDWOCFKDQET",
                            "INE914J01012",
                            "BANKNIFTY 01 Jun 2023 FUT",
                            "equity",
                            45,
                            1730841600000,
                            450.09,
                            "sell",
                            111,
                            55,
                            14,
                            84,
                            291,
                            436,
                            146,
                            24,
                            168,
                            39,
                            null
                        ],
                        [
                            "Y9V66LWUBLF8P2I8FDAR",
                            "INE519I01013",
                            "BANKNIFTY 15 Jun 2023 FUT",
                            "equity",
                            25,
                            1731100800000,
                            469.22,
                            "sell",
                            78,
                            91,
                            80,
                            41,
                            123,
                            291,
                            83,
                            151,
                            115,
                            11,
                            null
                        ],
                        [
                            "2C7BGL8DLAEX6DMFGRTF",
                            "INE519I01013",
                            "BANKNIFTY 15 Jun 2023 FUT",
                            "equity",
                            25,
                            1730403200000,
                            425.3,
                            "sell",
                            22,
                            107,
                            62,
                            188,
                            249,
                            158,
                            117,
                            82,
                            21,
                            18,
                            null
                        ],
                        [
                            "CJLNLY40ORWJXUKGVC8E",
                            "INE894N01016",
                            "NIFTY 23 JAN 2023 FUT",
                            "equity",
                            25,
                            1728153600000,
                            135.67,
                            "sell",
                            69,
                            101,
                            25,
                            74,
                            90,
                            300,
                            128,
                            21,
                            56,
                            3,
                            null
                        ],
                        [
                            "GFHNW8Q8GH4F408UZQ0M",
                            "INE894N01017",
                            "NIFTY 23 JAN 2023 FUT",
                            "equity",
                            45,
                            1729104000000,
                            129.89,
                            "sell",
                            132,
                            88,
                            37,
                            24,
                            279,
                            212,
                            148,
                            43,
                            116,
                            26,
                            null
                        ],
                        [
                            "LL4ESNCPAINCWUTVOYKX",
                            "INE894N01018",
                            "NIFTY 23 JAN 2023 FUT",
                            "equity",
                            50,
                            1730620800000,
                            147.89,
                            "sell",
                            53,
                            67,
                            8,
                            87,
                            63,
                            171,
                            86,
                            89,
                            83,
                            9,
                            null
                        ],
                        [
                            "WI62KWVR0MYO0WXLDQ4J",
                            "INE694C01015",
                            "NIFTY 23 JAN 2023 FUT",
                            "equity",
                            80,
                            1730793600000,
                            150,
                            "sell",
                            10,
                            50,
                            68,
                            204,
                            60,
                            36,
                            24,
                            6,
                            43,
                            16,
                            null
                        ],
                        [
                            "IJPDDNJO9BNNH0TB9NPJ",
                            "INE769A01020",
                            "FINNIFTY 25 JAN 2023 FUT",
                            "equity",
                            35,
                            1731139200000,
                            2568.98,
                            "sell",
                            132,
                            85,
                            15,
                            82,
                            101,
                            10,
                            152,
                            75,
                            46,
                            11,
                            null
                        ],
                        [
                            "VLNYY0FTJTUGELL1TK8D",
                            "INE563D01013",
                            "NIFTY 15 JAN 2023 FUT",
                            "equity",
                            25,
                            1729411200000,
                            146,
                            "sell",
                            105,
                            53,
                            3,
                            114,
                            193,
                            397,
                            8,
                            2,
                            58,
                            43,
                            null
                        ],
                        [
                            "VLNYY0FTJTUGELL1TK8D",
                            "INE563D01013",
                            "NIFTY 15 JAN 2023 FUT",
                            "equity",
                            75,
                            1729670400000,
                            158,
                            "sell",
                            54,
                            105,
                            28,
                            102,
                            11,
                            64,
                            41,
                            148,
                            143,
                            3,
                            null
                        ],
                        [
                            "VY3TYTSPMWLYJQAEMGTZ",
                            "INE563D01013",
                            "NIFTY 15 JAN 2023 FUT",
                            "equity",
                            150,
                            1730707200000,
                            255,
                            "sell",
                            138,
                            32,
                            42,
                            214,
                            44,
                            13,
                            146,
                            43,
                            52,
                            35,
                            null
                        ],
                        [
                            "YQT2WZWDNZPPCRDSQFR9",
                            "INE118D01016",
                            "NIFTY 25 JAN 2023 FUT",
                            "equity",
                            100,
                            1730880000000,
                            126.78,
                            "sell",
                            18,
                            23,
                            81,
                            239,
                            107,
                            183,
                            158,
                            64,
                            137,
                            50,
                            null
                        ],
                        [
                            "9ZLDZGRMJBSSAIJTBTHN",
                            "INE002A01018",
                            "FINNIFTY 15 FEB 2023 FUT",
                            "equity",
                            155,
                            1731315200000,
                            174.55,
                            "sell",
                            130,
                            33,
                            69,
                            197,
                            298,
                            266,
                            24,
                            142,
                            9,
                            19,
                            null
                        ],
                        [
                            "RHSYRUIXEC7M4HJBK46H",
                            "INE0C5901014",
                            "NIFTY 23 FEB 2023 FUT",
                            "equity",
                            55,
                            1731488000000,
                            174.8,
                            "sell",
                            111,
                            86,
                            26,
                            17,
                            303,
                            388,
                            149,
                            16,
                            53,
                            20,
                            null
                        ],
                        [
                            "I3RI1TXUYSFLFU4N8IWZ",
                            "INE0C5901014",
                            "NIFTY 23 FEB 2023 FUT",
                            "equity",
                            120,
                            1732243200000,
                            210.89,
                            "sell",
                            115,
                            42,
                            78,
                            151,
                            292,
                            262,
                            98,
                            151,
                            37,
                            30,
                            null
                        ],
                        [
                            "BYSC5G1EPZIWIJJ6BAUB",
                            "INE435D01014",
                            "BANKNIFTY 20 MAR 2023 FUT",
                            "equity",
                            125,
                            1732329600000,
                            615.89,
                            "sell",
                            101,
                            83,
                            15,
                            219,
                            125,
                            349,
                            140,
                            154,
                            129,
                            6,
                            null
                        ],
                        [
                            "MWLF0LTSOJNEXKVXSGWN",
                            "INE0C5901014",
                            "NIFTY 17 APR 2023 FUT",
                            "equity",
                            135,
                            1732761600000,
                            489.67,
                            "sell",
                            132,
                            94,
                            74,
                            184,
                            190,
                            173,
                            30,
                            72,
                            61,
                            48,
                            null
                        ],
                        [
                            "B67GMDMHCZAHJBXKDGL0",
                            "INE322R01014",
                            "FINNIFTY 20 MAY 2023 FUT",
                            "equity",
                            120,
                            1732761600000,
                            745.32,
                            "sell",
                            150,
                            13,
                            35,
                            133,
                            133,
                            362,
                            128,
                            119,
                            83,
                            39,
                            null
                        ],
                        [
                            "DEN7PSRIFMQ0VQXZF8O8",
                            "INE694N01015",
                            "RIL 15 OCT 2023 FUT",
                            "equity",
                            50,
                            1732761600000,
                            615.35,
                            "sell",
                            99,
                            59,
                            84,
                            104,
                            322,
                            159,
                            92,
                            122,
                            136,
                            15,
                            null
                        ],
                        [
                            "GAVL50RNZDGGQSMMLKOF",
                            "INE576G01015",
                            "INFY 30 OCT 2023 FUT",
                            "equity",
                            100,
                            1732761600000,
                            145,
                            "sell",
                            50,
                            96,
                            11,
                            84,
                            204,
                            220,
                            20,
                            125,
                            146,
                            23,
                            null
                        ],
                        [
                            "BWQRBJTC2V55AFBIZPYW",
                            "INE197R01010",
                            "RIL 31 OCT 2023 FUT",
                            "equity",
                            250,
                            1732761600000,
                            199,
                            "sell",
                            89,
                            57,
                            49,
                            235,
                            303,
                            147,
                            23,
                            114,
                            11,
                            24,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "option_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "option_tradebook_table",
                    "@entity": "table",
                    "header": [
                        "trade_id",
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "date",
                        "price",
                        "transaction_type",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fees",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "label"
                    ],
                    "rows": [
                        [
                            "RJFWB5JYYDORFUEPK5DQ",
                            "INE619I01012",
                            "BANKNIFTY 01 Jun 2023 CE 44100",
                            "equity",
                            25,
                            1711756800000,
                            363.1,
                            "buy",
                            385,
                            201,
                            2235,
                            795,
                            1757,
                            202,
                            195,
                            2060,
                            2112,
                            1622,
                            null
                        ],
                        [
                            "Y6W9FLHOVJ8TCHHNBYGF",
                            "INE545C01013",
                            "BANKNIFTY 01 Jun 2023 CE 44200",
                            "equity",
                            75,
                            1714176000000,
                            363.15,
                            "buy",
                            2479,
                            304,
                            1657,
                            2282,
                            1170,
                            172,
                            1307,
                            1660,
                            1130,
                            1106,
                            null
                        ],
                        [
                            "DML3WXXE53PJOTGTEYKJ",
                            "INE512D09106",
                            "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
                            "commodity",
                            100,
                            1727731200000,
                            415,
                            "buy",
                            107,
                            8,
                            114,
                            111,
                            90,
                            43,
                            36,
                            48,
                            119,
                            21,
                            null
                        ],
                        [
                            "GYHVDLIIXVTLROOCLVYG",
                            "INE579I01014",
                            "OPTCUR USDINR 27 JAN 2023 83 PE",
                            "currency",
                            135,
                            1728585600000,
                            90.69,
                            "buy",
                            134,
                            183,
                            209,
                            9,
                            100,
                            50,
                            202,
                            60,
                            140,
                            214,
                            null
                        ],
                        [
                            "ULDR4PE639LOMU4A4VCE",
                            "INE512R02109",
                            "NIFTY 23 JAN 2023 CE 15000",
                            "equity",
                            75,
                            1728412800000,
                            1570,
                            "buy",
                            2122,
                            1793,
                            1820,
                            1893,
                            560,
                            1651,
                            875,
                            2161,
                            32,
                            1916,
                            null
                        ],
                        [
                            "VIHCPUEYSZUMQUVPSJ1P",
                            "INE512R02109",
                            "NIFTY 23 JAN 2023 CE 15000",
                            "equity",
                            125,
                            1728979200000,
                            1490,
                            "buy",
                            114,
                            1074,
                            1522,
                            44,
                            1158,
                            535,
                            2252,
                            1115,
                            1171,
                            2449,
                            null
                        ],
                        [
                            "QOO5OYJLQBIRUMIGKCIQ",
                            "INE769A01020",
                            "FINNIFTY 25 JAN 2023 CE 12500",
                            "equity",
                            50,
                            1729756800000,
                            3450.67,
                            "buy",
                            831,
                            1827,
                            1117,
                            1814,
                            1230,
                            499,
                            1882,
                            2344,
                            457,
                            1850,
                            null
                        ],
                        [
                            "2BOMU4R5WMEONKEI5YT6",
                            "INE563D01013",
                            "NIFTY 23 JAN 2023 CE 15600",
                            "equity",
                            250,
                            1730620800000,
                            168,
                            "buy",
                            1280,
                            657,
                            1291,
                            1139,
                            636,
                            2397,
                            795,
                            1161,
                            2236,
                            1620,
                            null
                        ],
                        [
                            "PZUTEFRTRX9LFW9DPHAW",
                            "INE118D01016",
                            "NIFTY 23 JAN 2023 CE 15650",
                            "equity",
                            100,
                            1729584000000,
                            175.55,
                            "buy",
                            125,
                            882,
                            2432,
                            2077,
                            2189,
                            2472,
                            2156,
                            1856,
                            1068,
                            2285,
                            null
                        ],
                        [
                            "DIQDEZH7K04QBDCJY0NV",
                            "INE002A01018",
                            "FINNIFTY 15 FEB 2023 CE 13400",
                            "equity",
                            50,
                            1730707200000,
                            194.9,
                            "buy",
                            1645,
                            1807,
                            1262,
                            2482,
                            829,
                            782,
                            540,
                            1000,
                            354,
                            2491,
                            null
                        ],
                        [
                            "PGR2RDEZFVC2S3YBX1JF",
                            "INE0C5901014",
                            "NIFTY 23 FEB 2023 PE 17100",
                            "equity",
                            105,
                            1730828800000,
                            194.9,
                            "buy",
                            1760,
                            1640,
                            2143,
                            905,
                            1374,
                            1714,
                            842,
                            1776,
                            847,
                            299,
                            null
                        ],
                        [
                            "TFCXQ3TKQRMOHU86MXO1",
                            "INE082B0101",
                            "BANKNIFTY 20 MAR 2023 PE 18900",
                            "equity",
                            155,
                            1730950400000,
                            1500,
                            "buy",
                            104,
                            552,
                            1064,
                            2411,
                            1835,
                            2056,
                            2421,
                            2289,
                            651,
                            2315,
                            null
                        ],
                        [
                            "DUYJ4ZV7OKJA8CV8U1MT",
                            "INE0C5901014",
                            "NIFTY 17 APR 2023 PE 17800",
                            "equity",
                            55,
                            1731260800000,
                            457.89,
                            "buy",
                            1766,
                            2139,
                            1170,
                            2017,
                            723,
                            2101,
                            1756,
                            2357,
                            1517,
                            2394,
                            null
                        ],
                        [
                            "2GFSS7XTAHUWHFZH0NBR",
                            "INE322R01014",
                            "FINNIFTY 25 MAY 2023 CE 14900",
                            "equity",
                            130,
                            1731699200000,
                            698.03,
                            "buy",
                            682,
                            2191,
                            400,
                            1922,
                            813,
                            188,
                            1323,
                            188,
                            880,
                            1267,
                            null
                        ],
                        [
                            "4AGDXGEEJOUHI6G8ATOU",
                            "INE694N01015",
                            "RELIANCE OCT 1940 CE",
                            "equity",
                            50,
                            1726963200000,
                            559.39,
                            "buy",
                            1244,
                            2104,
                            102,
                            1018,
                            319,
                            1497,
                            1669,
                            2059,
                            1901,
                            485,
                            null
                        ],
                        [
                            "AHVDFMGBCECY1IR0QDH9",
                            "INE197R01010",
                            "RELIANCE OCT 1960 CE",
                            "equity",
                            175,
                            1728000000000,
                            1000,
                            "buy",
                            2181,
                            2407,
                            104,
                            398,
                            1577,
                            1341,
                            55,
                            1215,
                            1616,
                            879,
                            null
                        ],
                        [
                            "Q2DZQ1ITYAOXILWQLHDN",
                            "INE576G01015",
                            "INFOSYS OCT 2550 CE",
                            "equity",
                            150,
                            1728518400000,
                            175,
                            "buy",
                            444,
                            1610,
                            769,
                            2289,
                            1456,
                            437,
                            1601,
                            620,
                            810,
                            1319,
                            null
                        ],
                        [
                            "FQQ96BPTGAPAQPLMABNU",
                            "INE197R01010",
                            "RELIANCE OCT 1920 CE",
                            "equity",
                            250,
                            1728864000000,
                            186,
                            "buy",
                            1158,
                            1954,
                            1513,
                            2091,
                            1622,
                            1175,
                            383,
                            2049,
                            191,
                            1624,
                            null
                        ],
                        [
                            "RKW88OVAQVWZMCD9VLJL",
                            "INE512R01010",
                            "INFOSYS OCT 2590 CE",
                            "equity",
                            225,
                            1729123200000,
                            180,
                            "buy",
                            874,
                            1430,
                            2384,
                            1648,
                            1398,
                            596,
                            367,
                            396,
                            1897,
                            1511,
                            null
                        ],
                        [
                            "TTGYOR1EOA3SUTMNCJ58",
                            "INE512D09106",
                            "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
                            "commodity",
                            25,
                            1727817600000,
                            423,
                            "sell",
                            106,
                            107,
                            78,
                            45,
                            79,
                            100,
                            14,
                            58,
                            70,
                            85,
                            null
                        ],
                        [
                            "MYOFOBCC5W0PCWHVBFPU",
                            "INE512D09106",
                            "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
                            "commodity",
                            50,
                            1728681600000,
                            456,
                            "buy",
                            80,
                            89,
                            33,
                            66,
                            61,
                            71,
                            116,
                            120,
                            55,
                            33,
                            null
                        ],
                        [
                            "VIX3TEN3GZKPVY2WZCEX",
                            "INE512D09106",
                            "OPTFUT CRUDEOIL 16 OCT 2022 7000 PE",
                            "commodity",
                            125,
                            1729804800000,
                            449,
                            "sell",
                            4,
                            73,
                            78,
                            84,
                            113,
                            71,
                            1,
                            75,
                            118,
                            18,
                            null
                        ],
                        [
                            "Q5CUBQ2P6B7VKNHCKWD6",
                            "INE573G07017",
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            50,
                            1729632000000,
                            135,
                            "buy",
                            237,
                            56,
                            15,
                            18,
                            104,
                            15,
                            22,
                            76,
                            89,
                            112,
                            null
                        ],
                        [
                            "Q5CUBQ2P6B7VKNHCKWD6",
                            "INE573G07017",
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            80,
                            1729632000000,
                            142,
                            "buy",
                            188,
                            53,
                            11,
                            89,
                            31,
                            92,
                            119,
                            77,
                            58,
                            6,
                            null
                        ],
                        [
                            "DTXGC9I0ZVOI2FFSHIOL",
                            "INE573G07017",
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            70,
                            1729728000000,
                            148,
                            "sell",
                            77,
                            57,
                            74,
                            83,
                            42,
                            83,
                            110,
                            104,
                            60,
                            102,
                            null
                        ],
                        [
                            "DTXGC9I0ZVOI2FFSHIOL",
                            "INE573G07017",
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            30,
                            1729814400000,
                            150,
                            "sell",
                            187,
                            112,
                            77,
                            67,
                            93,
                            19,
                            84,
                            19,
                            54,
                            47,
                            null
                        ],
                        [
                            "IU0HYP6ZN9EOERPBEWYA",
                            "INE573G07017",
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            140,
                            1730419200000,
                            137,
                            "buy",
                            234,
                            97,
                            29,
                            100,
                            39,
                            72,
                            49,
                            115,
                            110,
                            93,
                            null
                        ],
                        [
                            "TAODZZPWWR9R5CO1QX0R",
                            "INE573G07017",
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            80,
                            1732060800000,
                            154,
                            "sell",
                            136,
                            76,
                            35,
                            49,
                            98,
                            56,
                            75,
                            2,
                            15,
                            75,
                            null
                        ],
                        [
                            "TAODZZPWWR9R5CO1QX0R",
                            "INE573G07017",
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            20,
                            1732060800000,
                            153,
                            "buy",
                            211,
                            31,
                            34,
                            6,
                            18,
                            105,
                            104,
                            41,
                            67,
                            52,
                            null
                        ],
                        [
                            "HVG5B4A45J9CL4CZ35TF",
                            "INE573G07017",
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            130,
                            1732492800000,
                            156,
                            "sell",
                            110,
                            41,
                            105,
                            57,
                            47,
                            64,
                            63,
                            34,
                            46,
                            26,
                            null
                        ],
                        [
                            "CJ7UKXJFK6WDVAUWGXGW",
                            "INE113J07012",
                            "OPTFUT GOLD 29 OCT 2023 60000 PE",
                            "commodity",
                            55,
                            1726012800000,
                            124.56,
                            "sell",
                            103,
                            48,
                            70,
                            111,
                            21,
                            40,
                            84,
                            69,
                            15,
                            16,
                            null
                        ],
                        [
                            "EAU3BEIXICIMKLVWWU56",
                            "INE113J07012",
                            "OPTFUT GOLD 29 OCT 2023 60000 PE",
                            "commodity",
                            55,
                            1726272000000,
                            121,
                            "buy",
                            125,
                            52,
                            36,
                            22,
                            92,
                            17,
                            67,
                            79,
                            46,
                            109,
                            null
                        ],
                        [
                            "OJDZI0SB29R3RMHWOG8P",
                            "INE113J07012",
                            "OPTFUT GOLD 29 NOV2023 61000 PE",
                            "commodity",
                            85,
                            1728604800000,
                            135,
                            "buy",
                            212,
                            24,
                            78,
                            32,
                            52,
                            54,
                            7,
                            83,
                            8,
                            119,
                            null
                        ],
                        [
                            "DOHDNKFFITQRMFUYKQLE",
                            "INE113J07012",
                            "OPTFUT GOLD 29 NOV2023 61000 PE",
                            "commodity",
                            35,
                            1729036800000,
                            138,
                            "buy",
                            25,
                            89,
                            59,
                            114,
                            63,
                            56,
                            108,
                            2,
                            64,
                            35,
                            null
                        ],
                        [
                            "CVWO1J0HIG9QEY5UVUDQ",
                            "INE113J07012",
                            "OPTFUT GOLD 29 NOV2023 61000 PE",
                            "commodity",
                            90,
                            1731369600000,
                            142,
                            "sell",
                            108,
                            57,
                            19,
                            77,
                            25,
                            94,
                            115,
                            78,
                            71,
                            117,
                            null
                        ],
                        [
                            "R2K5E791EH5VAQZVOETW",
                            "INE113J07012",
                            "OPTFUT GOLD 29 NOV2023 61000 PE",
                            "commodity",
                            10,
                            1731542400000,
                            149,
                            "sell",
                            130,
                            3,
                            116,
                            15,
                            41,
                            119,
                            118,
                            26,
                            76,
                            77,
                            null
                        ],
                        [
                            "GYHVDLIIXVTLROOCLVYG",
                            "INE579I01014",
                            "OPTCUR USDINR 27 JAN 2023 83 PE",
                            "currency",
                            145,
                            1728585600000,
                            87.45,
                            "buy",
                            212,
                            202,
                            223,
                            125,
                            116,
                            48,
                            71,
                            75,
                            100,
                            24,
                            null
                        ],
                        [
                            "8VMAOKSBFKXAX1Z75UK5",
                            "INE579I01014",
                            "OPTCUR USDINR 27 JAN 2023 83 PE",
                            "currency",
                            165,
                            1728240000000,
                            94.78,
                            "sell",
                            177,
                            48,
                            234,
                            38,
                            176,
                            182,
                            159,
                            80,
                            200,
                            136,
                            null
                        ],
                        [
                            "ZXORPEEJE7TVFBPXQ8LI",
                            "INE579I01014",
                            "OPTCUR USDINR 27 JAN 2023 83 PE",
                            "currency",
                            100,
                            1729104000000,
                            45.98,
                            "sell",
                            97,
                            219,
                            153,
                            19,
                            118,
                            231,
                            228,
                            31,
                            185,
                            186,
                            null
                        ],
                        [
                            "ZXORPEEJE7TVFBPXQ8LI",
                            "INE579I01014",
                            "OPTCUR USDINR 27 JAN 2023 83 PE",
                            "currency",
                            15,
                            1729756800000,
                            78.3,
                            "sell",
                            94,
                            93,
                            127,
                            162,
                            79,
                            232,
                            149,
                            211,
                            83,
                            6,
                            null
                        ],
                        [
                            "6MDVYEYUKHJXIQSGEOPU",
                            "INE645F01015",
                            "OPTCUR EURINR 13 MAY 2023 94 CE",
                            "currency",
                            50,
                            1731174400000,
                            245.78,
                            "sell",
                            46,
                            228,
                            186,
                            237,
                            75,
                            6,
                            46,
                            97,
                            203,
                            34,
                            null
                        ],
                        [
                            "CPYBETZOWLDVTAYF3PRA",
                            "INE645F01015",
                            "OPTCUR EURINR 13 MAY 2023 94 CE",
                            "currency",
                            50,
                            1731174400000,
                            260.7,
                            "buy",
                            178,
                            162,
                            152,
                            207,
                            202,
                            185,
                            95,
                            232,
                            121,
                            209,
                            null
                        ],
                        [
                            "MEHVXLLGPB5SODCHL5PT",
                            "INE645F01015",
                            "OPTCUR EURINR 13 MAY 2023 94 CE",
                            "currency",
                            145,
                            1731347200000,
                            278,
                            "sell",
                            20,
                            164,
                            152,
                            121,
                            98,
                            148,
                            35,
                            194,
                            110,
                            34,
                            null
                        ],
                        [
                            "UQCTRKWJRKXVR7LSIBCN",
                            "INE645F01015",
                            "OPTCUR EURINR 13 MAY 2023 94 CE",
                            "currency",
                            145,
                            1711756800000,
                            289,
                            "buy",
                            25,
                            85,
                            159,
                            60,
                            145,
                            36,
                            46,
                            146,
                            237,
                            157,
                            null
                        ],
                        [
                            "PIN8G2M1QKXY1FQZPRIF",
                            "INE714H01019",
                            "OPTCUR GBPINR 27 OCT 2023 115 PE",
                            "currency",
                            75,
                            1725667200000,
                            4500,
                            "buy",
                            21,
                            179,
                            65,
                            29,
                            21,
                            92,
                            124,
                            178,
                            153,
                            12,
                            null
                        ],
                        [
                            "PIN8G2M1QKXY1FQZPRIF",
                            "INE714H01019",
                            "OPTCUR GBPINR 27 OCT 2023 115 PE",
                            "currency",
                            75,
                            1725667200000,
                            4509,
                            "sell",
                            15,
                            93,
                            151,
                            111,
                            104,
                            103,
                            55,
                            238,
                            153,
                            97,
                            null
                        ],
                        [
                            "69WJ3BI70HPVKNLEK5TR",
                            "INE714H01019",
                            "OPTCUR GBPINR 27 OCT 2023 115 PE",
                            "currency",
                            113,
                            1726185600000,
                            4492.367,
                            "buy",
                            57,
                            230,
                            240,
                            67,
                            116,
                            76,
                            6,
                            3,
                            169,
                            150,
                            null
                        ],
                        [
                            "P534DDQESQ6XNTI4NURV",
                            "INE714H01019",
                            "OPTCUR GBPINR 27 OCT 2023 115 PE",
                            "currency",
                            60,
                            1726876800000,
                            4499.876,
                            "sell",
                            145,
                            184,
                            130,
                            50,
                            35,
                            17,
                            90,
                            146,
                            149,
                            199,
                            null
                        ],
                        [
                            "OXGR4W3D3MYYBURZOEJ5",
                            "INE714H01019",
                            "OPTCUR GBPINR 27 OCT 2023 115 PE",
                            "currency",
                            43,
                            1728691200000,
                            5008.596,
                            "sell",
                            47,
                            22,
                            47,
                            31,
                            24,
                            32,
                            128,
                            195,
                            47,
                            87,
                            null
                        ],
                        [
                            "T6B8078DHAC9MGWPKR6B",
                            "INE632P01025",
                            "OPTCUR JPYINR 24 AUG 2023 45.6 CE",
                            "currency",
                            120,
                            1731184000000,
                            345.89,
                            "sell",
                            7,
                            203,
                            116,
                            18,
                            12,
                            64,
                            159,
                            151,
                            211,
                            148,
                            null
                        ],
                        [
                            "OFAILEZLEAPD9SU5ZOMT",
                            "INE632P01025",
                            "OPTCUR JPYINR 24 AUG 2023 45.6 CE",
                            "currency",
                            80,
                            1731788800000,
                            325.67,
                            "buy",
                            44,
                            87,
                            14,
                            179,
                            169,
                            178,
                            97,
                            26,
                            72,
                            170,
                            null
                        ],
                        [
                            "OFAILEZLHKPD8SU7ZOMT",
                            "INE632P01025",
                            "OPTCUR JPYINR 24 AUG 2023 45.6 CE",
                            "currency",
                            30,
                            1731788800000,
                            319.78,
                            "buy",
                            89,
                            205,
                            71,
                            145,
                            106,
                            166,
                            209,
                            67,
                            6,
                            124,
                            null
                        ],
                        [
                            "FDIT8EQR2XJFQJU2JLIG",
                            "INE632P01025",
                            "OPTCUR JPYINR 24 AUG 2023 45.6 CE",
                            "currency",
                            40,
                            1731961600000,
                            329.587,
                            "sell",
                            59,
                            42,
                            140,
                            65,
                            52,
                            47,
                            80,
                            128,
                            39,
                            105,
                            null
                        ],
                        [
                            "KLPAV9GOUCMPFH1WNKLV",
                            "INE619I01012",
                            "BANKNIFTY 01 Jun 2023 CE 44100",
                            "equity",
                            25,
                            1730841600000,
                            450.09,
                            "sell",
                            1657,
                            1302,
                            325,
                            2118,
                            2050,
                            604,
                            2148,
                            626,
                            1489,
                            2090,
                            null
                        ],
                        [
                            "0WNSDPGK4LTXO38HPTLU",
                            "INE545C01013",
                            "BANKNIFTY 01 Jun 2023 CE 44200",
                            "equity",
                            25,
                            1731100800000,
                            469.22,
                            "sell",
                            1711,
                            1948,
                            2048,
                            700,
                            2360,
                            120,
                            2415,
                            333,
                            2231,
                            736,
                            null
                        ],
                        [
                            "QS2KFCND5DJXRNDLLVHD",
                            "INE545C01013",
                            "BANKNIFTY 01 Jun 2023 CE 44200",
                            "equity",
                            50,
                            1730403200000,
                            425.3,
                            "sell",
                            320,
                            375,
                            82,
                            1593,
                            1653,
                            620,
                            1637,
                            712,
                            542,
                            130,
                            null
                        ],
                        [
                            "0B3PIU4WMIPKUQEG34BO",
                            "INE512R02109",
                            "NIFTY 23 JAN 2023 CE 15000",
                            "equity",
                            25,
                            1728153600000,
                            1460,
                            "sell",
                            499,
                            2262,
                            2210,
                            507,
                            256,
                            2293,
                            1125,
                            2345,
                            1852,
                            90,
                            null
                        ],
                        [
                            "S7XOLPIQ2V4R5L89ZEE1",
                            "INE512R02109",
                            "NIFTY 23 JAN 2023 CE 15000",
                            "equity",
                            45,
                            1729104000000,
                            1508,
                            "sell",
                            1784,
                            825,
                            2087,
                            498,
                            666,
                            616,
                            1994,
                            763,
                            157,
                            2380,
                            null
                        ],
                        [
                            "HSZA8B3XH3JC2POXMSXJ",
                            "INE512R02109",
                            "NIFTY 23 JAN 2023 CE 15000",
                            "equity",
                            50,
                            1730620800000,
                            1585,
                            "sell",
                            335,
                            1434,
                            254,
                            1609,
                            999,
                            1979,
                            2229,
                            127,
                            389,
                            1244,
                            null
                        ],
                        [
                            "ILKEYGKTOHFQI5UXMBOO",
                            "INE512R02109",
                            "NIFTY 23 JAN 2023 CE 15000",
                            "equity",
                            80,
                            1730793600000,
                            1635,
                            "sell",
                            208,
                            535,
                            279,
                            401,
                            2010,
                            248,
                            494,
                            746,
                            2399,
                            1196,
                            null
                        ],
                        [
                            "A9HFP9X49AROF21K9KRY",
                            "INE769A01020",
                            "FINNIFTY 25 JAN 2023 CE 12500",
                            "equity",
                            50,
                            1731139200000,
                            2568.98,
                            "sell",
                            319,
                            59,
                            25,
                            2409,
                            2339,
                            423,
                            132,
                            250,
                            2137,
                            2442,
                            null
                        ],
                        [
                            "GHQTIWHDAFE90NOAU6ZY",
                            "INE563D01013",
                            "NIFTY 23 JAN 2023 CE 15600",
                            "equity",
                            25,
                            1729411200000,
                            146,
                            "sell",
                            1525,
                            678,
                            749,
                            379,
                            277,
                            1791,
                            2288,
                            545,
                            1042,
                            327,
                            null
                        ],
                        [
                            "GHQTIWHDAFE90NOAU6ZY",
                            "INE563D01013",
                            "NIFTY 23 JAN 2023 CE 15600",
                            "equity",
                            75,
                            1729670400000,
                            158,
                            "sell",
                            1761,
                            2349,
                            1082,
                            2181,
                            1054,
                            1396,
                            856,
                            1220,
                            1740,
                            1791,
                            null
                        ],
                        [
                            "IXMBK9LENH6CSGULION2",
                            "INE563D01013",
                            "NIFTY 23 JAN 2023 CE 15600",
                            "equity",
                            150,
                            1730707200000,
                            255,
                            "sell",
                            2369,
                            875,
                            2202,
                            2488,
                            1574,
                            404,
                            532,
                            779,
                            2266,
                            1396,
                            null
                        ],
                        [
                            "BEZ31FONIR1EQQI68F0Y",
                            "INE118D01016",
                            "NIFTY 23 JAN 2023 CE 15650",
                            "equity",
                            100,
                            1730880000000,
                            126.78,
                            "sell",
                            288,
                            7,
                            2495,
                            1391,
                            1859,
                            28,
                            1298,
                            355,
                            1234,
                            1955,
                            null
                        ],
                        [
                            "HMC8SXGWGNGWUTFBYRHX",
                            "INE002A01018",
                            "FINNIFTY 15 FEB 2023 CE 13400",
                            "equity",
                            50,
                            1731315200000,
                            174.55,
                            "sell",
                            879,
                            2335,
                            1905,
                            1798,
                            456,
                            1765,
                            358,
                            1368,
                            1124,
                            1040,
                            null
                        ],
                        [
                            "KQDQ54GEHLHTIUSPGAV6",
                            "INE0C5901014",
                            "NIFTY 23 FEB 2023 PE 17100",
                            "equity",
                            55,
                            1731488000000,
                            174.8,
                            "sell",
                            181,
                            764,
                            1349,
                            1121,
                            2195,
                            2042,
                            1398,
                            1674,
                            164,
                            2244,
                            null
                        ],
                        [
                            "SLB3JNRIBXSZWLRWP8ZZ",
                            "INE0C5901014",
                            "NIFTY 23 FEB 2023 PE 17100",
                            "equity",
                            50,
                            1732243200000,
                            210.89,
                            "sell",
                            77,
                            713,
                            1563,
                            1666,
                            1745,
                            20,
                            528,
                            2500,
                            1068,
                            2008,
                            null
                        ],
                        [
                            "LMQI22RLLZHQ5CWBGFYP",
                            "INE082B0101",
                            "BANKNIFTY 20 MAR 2023 PE 18900",
                            "equity",
                            155,
                            1732329600000,
                            615.89,
                            "sell",
                            1842,
                            519,
                            2150,
                            997,
                            536,
                            1241,
                            2437,
                            765,
                            2481,
                            2126,
                            null
                        ],
                        [
                            "71ZRU28BNR9F5FMOZS8V",
                            "INE0C5901014",
                            "NIFTY 17 APR 2023 PE 17800",
                            "equity",
                            55,
                            1732761600000,
                            489.67,
                            "sell",
                            1519,
                            340,
                            2379,
                            190,
                            164,
                            2420,
                            662,
                            226,
                            1681,
                            722,
                            null
                        ],
                        [
                            "PHGLBJWZZLIDKTTVLNQE",
                            "INE322R01014",
                            "FINNIFTY 25 MAY 2023 CE 14900",
                            "equity",
                            120,
                            1732761600000,
                            745.32,
                            "sell",
                            820,
                            1114,
                            2137,
                            646,
                            2399,
                            2314,
                            160,
                            1817,
                            2092,
                            283,
                            null
                        ],
                        [
                            "SEZD4CXXIXJ79ZS0GUQ2",
                            "INE694N01015",
                            "RELIANCE OCT 1940 CE",
                            "equity",
                            50,
                            1732761600000,
                            615.35,
                            "sell",
                            1797,
                            249,
                            1653,
                            2028,
                            897,
                            542,
                            1158,
                            2067,
                            964,
                            1393,
                            null
                        ],
                        [
                            "UESSXHU0UHWCRJ1Z7LJR",
                            "INE576G01015",
                            "INFOSYS OCT 2550 CE",
                            "equity",
                            150,
                            1732761600000,
                            145,
                            "sell",
                            1204,
                            722,
                            1103,
                            2190,
                            1165,
                            1168,
                            597,
                            1485,
                            1127,
                            1175,
                            null
                        ],
                        [
                            "TVSWJDGSX7VFVHA2AUXG",
                            "INE197R01010",
                            "RELIANCE OCT 1920 CE",
                            "equity",
                            250,
                            1732761600000,
                            199,
                            "sell",
                            267,
                            1371,
                            436,
                            2246,
                            1747,
                            765,
                            1306,
                            1279,
                            1236,
                            1962,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "mutual_fund_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "mutual_fund_tradebook_table",
                    "@entity": "table",
                    "header": [
                        "trade_id",
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "is_listed",
                        "is_stt_paid",
                        "quantity",
                        "date",
                        "price",
                        "transaction_type",
                        "fmv",
                        "transfer_expenses",
                        "label"
                    ],
                    "rows": [
                        [
                            "TGFCH72LKDQY9RRINTGH",
                            "INE397D01024",
                            "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            32.31,
                            1525824000000,
                            50,
                            "buy",
                            400,
                            10,
                            null
                        ],
                        [
                            "BVNCH72LKDQY9RRINTGH",
                            "INF251K01NO3",
                            "BNP PARIBAS LIQUID FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            37.216,
                            1589414400000,
                            10,
                            "buy",
                            0,
                            98,
                            null
                        ],
                        [
                            "BNG57MYGKDQY9RRINTGH",
                            "INF277K01YE6",
                            "TATA LIQUID FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            19.574,
                            1515456000000,
                            120,
                            "buy",
                            5,
                            78,
                            null
                        ],
                        [
                            "GJK45MYGKDQY9RRINTGH",
                            "INF278A06YE8",
                            "Aditya Birla Sun Life Medium Term Direct Plan Growth",
                            "debt",
                            true,
                            true,
                            36.023,
                            1493769600000,
                            30,
                            "buy",
                            10,
                            68,
                            null
                        ],
                        [
                            "GHL909MYGKDQY9RRINTGH",
                            "INF200K01UT4",
                            "SBI LIQUID FUND - DIRECT PLAN",
                            "other",
                            true,
                            true,
                            35.014,
                            1437177600000,
                            15,
                            "buy",
                            17,
                            67,
                            null
                        ],
                        [
                            "BHMGP79GKDQY9RRINTGH",
                            "INF200K01189",
                            "SBI Gold Fund",
                            "other",
                            true,
                            true,
                            35.706,
                            1626739200000,
                            60,
                            "buy",
                            65,
                            30,
                            null
                        ],
                        [
                            "BLKMN98HJNMDQY9RRINTGH",
                            "INF200K01189",
                            "SBI Gold Fund",
                            "other",
                            true,
                            true,
                            36.062,
                            1563667200000,
                            60,
                            "buy",
                            120,
                            50,
                            null
                        ],
                        [
                            "MJK88MYGKDQY9RRINTGH",
                            "INF109KB1GK2",
                            "ICICI Prudential Commodity Fund",
                            "other",
                            true,
                            true,
                            35.039,
                            1626912000000,
                            400.784,
                            "buy",
                            200,
                            20,
                            null
                        ],
                        [
                            "GMFCH72LKDQY9RRINTGH",
                            "INF179KB1HP9",
                            "HDFC LIQUID FUND - DIRECT PLAN",
                            "equity",
                            true,
                            true,
                            25.68,
                            1556409600000,
                            459,
                            "buy",
                            220,
                            0.25,
                            null
                        ],
                        [
                            "GGFCHMYLKDQY9RRINTGH",
                            "INF846K01DI2",
                            "Axis Bluechip Fund",
                            "equity",
                            true,
                            true,
                            105.56,
                            1491436800000,
                            123,
                            "buy",
                            20,
                            25,
                            null
                        ],
                        [
                            "GGFCHMYLKDQY9RRINTGH",
                            "INF846K01DI2",
                            "Axis Bluechip Fund",
                            "equity",
                            true,
                            true,
                            550.34,
                            1491436800000,
                            124.5,
                            "buy",
                            20,
                            49,
                            null
                        ],
                        [
                            "DFGR59NOHJDQ751TINTJK",
                            "INF179K01PT5",
                            "HDFC Small Cap Fund",
                            "equity",
                            true,
                            true,
                            129,
                            1733760000000,
                            150,
                            "buy",
                            100,
                            32,
                            null
                        ],
                        [
                            "DFGR59NOHJDQ751TINTJK",
                            "INF179K01PT5",
                            "HDFC Small Cap Fund",
                            "equity",
                            true,
                            true,
                            100,
                            1733760000000,
                            250,
                            "buy",
                            100,
                            56,
                            null
                        ],
                        [
                            "GHNR59NOHJDQ901TINTLK",
                            "INF200K01OR6",
                            "SBI Magnum Multicap Fund",
                            "equity",
                            true,
                            true,
                            156.78,
                            1481500800000,
                            150,
                            "buy",
                            160,
                            22,
                            null
                        ],
                        [
                            "KNT59NOGKDQY897TINFTR",
                            "INF760K01FR2",
                            "Canara Robeco Bluechip Equity Growth Direct Plan",
                            "equity",
                            true,
                            true,
                            155,
                            1576022400000,
                            23.78,
                            "buy",
                            25,
                            2,
                            null
                        ],
                        [
                            "HJM98MYGKDQY9RRINGFB",
                            "INF200K01189",
                            "SBI Gold Fund",
                            "other",
                            true,
                            true,
                            35,
                            1374624000000,
                            200,
                            "buy",
                            180,
                            589,
                            null
                        ],
                        [
                            "JMCU8MYGKDQY9RRINTGH",
                            "INF200K01189",
                            "SBI Gold Fund",
                            "other",
                            true,
                            true,
                            35,
                            1585008000000,
                            230,
                            "buy",
                            180,
                            37,
                            null
                        ],
                        [
                            "GHN78NOGKDQY9YTINFGHY",
                            "INF200K01190",
                            "KOTAK SEC FUND",
                            "equity",
                            true,
                            true,
                            50,
                            1633564800000,
                            980,
                            "buy",
                            800,
                            145,
                            null
                        ],
                        [
                            "XCT59NOGKDQY9YTINFGRN",
                            "INF200K01190",
                            "KOTAK SEC FUND",
                            "equity",
                            true,
                            true,
                            40,
                            1639872000000,
                            1000,
                            "buy",
                            800,
                            198,
                            null
                        ],
                        [
                            "KGFCH72LKDQY9RRINTGH",
                            "INE397D01024",
                            "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            32.31,
                            1710921600000,
                            900,
                            "sell",
                            1000,
                            89.658,
                            null
                        ],
                        [
                            "KHF78MYGKDQY9RRINTGH",
                            "INF251K01NO3",
                            "BNP PARIBAS LIQUID FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            17.823,
                            1733625600000,
                            5,
                            "sell",
                            0,
                            20,
                            null
                        ],
                        [
                            "GHN78MYGKDQY9RRINTGH",
                            "INF277K01YE6",
                            "TATA LIQUID FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            36.711,
                            1714358400000,
                            160,
                            "sell",
                            5,
                            33.24,
                            null
                        ],
                        [
                            "BHM88MYGKDQY9RRINTGH",
                            "INF278A06YE8",
                            "Aditya Birla Sun Life Medium Term Direct Plan Growth",
                            "debt",
                            true,
                            true,
                            36.023,
                            1729036800000,
                            60,
                            "sell",
                            10,
                            100,
                            null
                        ],
                        [
                            "BHM88MTYH6QY9RRINTGH",
                            "INF200K01UT4",
                            "SBI LIQUID FUND - DIRECT PLAN",
                            "other",
                            true,
                            true,
                            19.88,
                            1729209600000,
                            60,
                            "sell",
                            17,
                            10,
                            null
                        ],
                        [
                            "CVH78MYGKDQY9RRINTGH",
                            "INF109KB1GK2",
                            "ICICI Prudential Commodity Fund",
                            "other",
                            true,
                            true,
                            32.531,
                            1721788800000,
                            200,
                            "sell",
                            200,
                            90,
                            null
                        ],
                        [
                            "GMFCH72LKDQY9RRINTGH",
                            "INF179KB1HP9",
                            "HDFC LIQUID FUND - DIRECT PLAN",
                            "equity",
                            true,
                            true,
                            25.68,
                            1731542400000,
                            500,
                            "sell",
                            220,
                            50,
                            null
                        ],
                        [
                            "JHF78MYGKDQY9RRINTGH",
                            "INF846K01DI2",
                            "Axis Bluechip Fund",
                            "equity",
                            true,
                            true,
                            355.9,
                            1727731200000,
                            212.7,
                            "sell",
                            20,
                            28,
                            null
                        ],
                        [
                            "JTR59NOGKDQY9YTINTGH",
                            "INF846K01DI2",
                            "Axis Bluechip Fund",
                            "equity",
                            true,
                            true,
                            250,
                            1728585600000,
                            209,
                            "sell",
                            20,
                            75,
                            null
                        ],
                        [
                            "HNT59NOGKDQY897TINF4R",
                            "INF200K01OR6",
                            "SBI Magnum Multicap Fund",
                            "equity",
                            true,
                            true,
                            125,
                            1728844800000,
                            400,
                            "sell",
                            160,
                            89.658,
                            null
                        ],
                        [
                            "HYT59NOGKDQY9YTINFGRN",
                            "INF760K01FR2",
                            "Canara Robeco Bluechip Equity Growth Direct Plan",
                            "equity",
                            true,
                            true,
                            155,
                            1729891200000,
                            56.9,
                            "sell",
                            45,
                            2,
                            null
                        ],
                        [
                            "RTV678MYGKDQY9RRINTGH",
                            "INF200K01189",
                            "SBI Gold Fund",
                            "other",
                            true,
                            true,
                            55,
                            1732147200000,
                            210,
                            "sell",
                            180,
                            56,
                            null
                        ],
                        [
                            "VBN59NOGKDQY9YTINFGRN",
                            "INF200K01190",
                            "KOTAK SEC FUND",
                            "equity",
                            true,
                            true,
                            40,
                            1729977600000,
                            1200,
                            "sell",
                            800,
                            230,
                            null
                        ],
                        [
                            "67859NOGKDQY9YTINFGRN",
                            "INF200K01190",
                            "KOTAK SEC FUND",
                            "equity",
                            true,
                            true,
                            50,
                            1730150400000,
                            1300,
                            "sell",
                            800,
                            245,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "etf_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "etf_tradebook_table",
                    "@entity": "table",
                    "header": [
                        "trade_id",
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "is_listed",
                        "is_stt_paid",
                        "quantity",
                        "date",
                        "price",
                        "transaction_type",
                        "fmv",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fees",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "label",
                        "product_type"
                    ],
                    "rows": [
                        [
                            "TGFCH72LKDQY9RRINTGH",
                            "INE397D01024",
                            "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            250,
                            1714521600000,
                            650,
                            "buy",
                            400,
                            115,
                            74,
                            130,
                            137,
                            144,
                            113,
                            122,
                            132,
                            69,
                            76,
                            null,
                            "intraday"
                        ],
                        [
                            "BVNCH72LKDQY9RRINTGH",
                            "INF251K01NO3",
                            "BNP PARIBAS LIQUID FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            31.536,
                            1723132800000,
                            10,
                            "buy",
                            340,
                            92,
                            34,
                            93,
                            139,
                            17,
                            3,
                            68,
                            61,
                            48,
                            109,
                            null,
                            "delivery"
                        ],
                        [
                            "BNG57MYGKDQY9RRINTGH",
                            "INF277K01YE6",
                            "TATA LIQUID FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            80,
                            1568160000000,
                            120,
                            "buy",
                            250,
                            127,
                            17,
                            108,
                            1,
                            26,
                            75,
                            33,
                            126,
                            113,
                            56,
                            null,
                            "delivery"
                        ],
                        [
                            "BHM88MYGKDQY9RRINTGH",
                            "INF278A06YE8",
                            "Aditya Birla Sun Life Medium Term Direct Plan Growth",
                            "debt",
                            true,
                            true,
                            100,
                            1740336000000,
                            60,
                            "buy",
                            10,
                            88,
                            62,
                            132,
                            43,
                            111,
                            35,
                            4,
                            113,
                            61,
                            3,
                            null,
                            "delivery"
                        ],
                        [
                            "GHL909MYGKDQY9RRINTGH",
                            "INF200K01UT4",
                            "SBI LIQUID FUND - DIRECT PLAN",
                            "other",
                            true,
                            true,
                            20,
                            1731196800000,
                            15,
                            "buy",
                            17,
                            37,
                            7,
                            47,
                            38,
                            9,
                            43,
                            25,
                            78,
                            72,
                            16,
                            null,
                            "intraday"
                        ],
                        [
                            "BLKMN98HJNMDQY9RRINTGH",
                            "INF200K01189",
                            "SBI Gold Fund",
                            "other",
                            true,
                            true,
                            50,
                            1641427200000,
                            120.5877,
                            "buy",
                            65,
                            28,
                            17,
                            52,
                            65,
                            13,
                            40,
                            13,
                            40,
                            40,
                            28,
                            null,
                            "delivery"
                        ],
                        [
                            "MJK88MYGKDQY9RRINTGH",
                            "INF109KB1GK2",
                            "ICICI Prudential Commodity Fund",
                            "other",
                            true,
                            true,
                            150,
                            1627862400000,
                            400.784,
                            "buy",
                            200,
                            77,
                            59,
                            77,
                            12,
                            5,
                            2,
                            7,
                            10,
                            5,
                            30,
                            null,
                            "delivery"
                        ],
                        [
                            "GMFCH72LKDQY9RRINTGH",
                            "INF179KB1HP9",
                            "HDFC LIQUID FUND - DIRECT PLAN",
                            "equity",
                            true,
                            true,
                            100,
                            1715212800000,
                            550,
                            "buy",
                            220,
                            137,
                            98,
                            138,
                            39,
                            106,
                            59,
                            21,
                            61,
                            146,
                            78,
                            null,
                            "intraday"
                        ],
                        [
                            "JNV5CHMYLKDQY9RRINTG",
                            "INF846K01DI2",
                            "Axis Bluechip Fund",
                            "equity",
                            true,
                            true,
                            78,
                            1589414400000,
                            23,
                            "buy",
                            20,
                            106,
                            17,
                            123,
                            61,
                            31,
                            105,
                            24,
                            117,
                            16,
                            62,
                            null,
                            "delivery"
                        ],
                        [
                            "PKF88MYGKDQY9RRINTGH",
                            "INF179K01PT5",
                            "HDFC Small Cap Fund",
                            "equity",
                            true,
                            true,
                            90,
                            1515456000000,
                            150,
                            "buy",
                            100,
                            92,
                            43,
                            29,
                            90,
                            64,
                            70,
                            66,
                            51,
                            112,
                            117,
                            null,
                            "delivery"
                        ],
                        [
                            "DFGR59NOHJDQ751TINTJK",
                            "INF200K01OR6",
                            "SBI Magnum Multicap Fund",
                            "equity",
                            true,
                            true,
                            95,
                            1493769600000,
                            150,
                            "buy",
                            160,
                            107,
                            98,
                            49,
                            143,
                            53,
                            73,
                            107,
                            52,
                            75,
                            56,
                            null,
                            "delivery"
                        ],
                        [
                            "DFGR59NOHJDQ751TINTJK",
                            "INF200K01OR6",
                            "SBI Magnum Multicap Fund",
                            "equity",
                            true,
                            true,
                            50,
                            1493769600000,
                            400,
                            "buy",
                            160,
                            9,
                            60,
                            101,
                            40,
                            146,
                            3,
                            23,
                            125,
                            139,
                            82,
                            null,
                            "delivery"
                        ],
                        [
                            "HNM88JKGKDQY9RRINGFB",
                            "INF179KB1QR7",
                            "ICICI LIQUID FUND - DIRECT PLAN",
                            "equity",
                            true,
                            true,
                            75,
                            1729987200000,
                            125,
                            "buy",
                            300,
                            19,
                            128,
                            126,
                            28,
                            70,
                            59,
                            130,
                            1,
                            113,
                            31,
                            null,
                            "intraday"
                        ],
                        [
                            "HJM98MYGKDQY9RRINGFB",
                            "INF179KB1QR8",
                            "ICICI LIQUID FUND - DIRECT PLAN",
                            "equity",
                            true,
                            true,
                            75,
                            1721664000000,
                            150,
                            "buy",
                            300,
                            61,
                            16,
                            25,
                            121,
                            50,
                            103,
                            148,
                            33,
                            75,
                            7,
                            null,
                            "delivery"
                        ],
                        [
                            "KGFCH72LKDQY9RRINTGH",
                            "INE397D01024",
                            "HDFC CREDIT RISK DEBT FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            250,
                            1714521600000,
                            600,
                            "sell",
                            400,
                            19,
                            9,
                            111,
                            62,
                            121,
                            45,
                            71,
                            74,
                            44,
                            24,
                            null,
                            "intraday"
                        ],
                        [
                            "KHF78MYGKDQY9RRINTGH",
                            "INF251K01NO3",
                            "BNP PARIBAS LIQUID FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            31.536,
                            1740787200000,
                            5,
                            "sell",
                            340,
                            134,
                            111,
                            2,
                            96,
                            29,
                            36,
                            128,
                            104,
                            94,
                            101,
                            null,
                            "delivery"
                        ],
                        [
                            "GHN78MYGKDQY9RRINTGH",
                            "INF277K01YE6",
                            "TATA LIQUID FUND - DIRECT PLAN",
                            "debt",
                            true,
                            true,
                            60,
                            1725667200000,
                            160,
                            "sell",
                            250,
                            60,
                            140,
                            15,
                            119,
                            139,
                            13,
                            18,
                            106,
                            10,
                            58,
                            null,
                            "delivery"
                        ],
                        [
                            "GJK45MYGKDQY9RRINTGH",
                            "INF278A06YE8",
                            "Aditya Birla Sun Life Medium Term Direct Plan Growth",
                            "debt",
                            true,
                            true,
                            100,
                            1713571200000,
                            30,
                            "sell",
                            10,
                            123,
                            38,
                            8,
                            101,
                            111,
                            99,
                            103,
                            89,
                            43,
                            11,
                            null,
                            "delivery"
                        ],
                        [
                            "BHM88MTYH6QY9RRINTGH",
                            "INF200K01UT4",
                            "SBI LIQUID FUND - DIRECT PLAN",
                            "other",
                            true,
                            true,
                            20,
                            1731196800000,
                            60,
                            "sell",
                            17,
                            43,
                            50,
                            48,
                            1,
                            7,
                            57,
                            9,
                            64,
                            73,
                            7,
                            null,
                            "intraday"
                        ],
                        [
                            "BHMGP79GKDQY9RRINTGH",
                            "INF200K01189",
                            "SBI Gold Fund",
                            "other",
                            true,
                            true,
                            50,
                            1735516800000,
                            60,
                            "sell",
                            65,
                            43,
                            59,
                            55,
                            9,
                            45,
                            50,
                            10,
                            17,
                            39,
                            22,
                            null,
                            "delivery"
                        ],
                        [
                            "CVH78MYGKDQY9RRINTGH",
                            "INF109KB1GK2",
                            "ICICI Prudential Commodity Fund",
                            "other",
                            true,
                            true,
                            100,
                            1716681600000,
                            200,
                            "sell",
                            200,
                            72,
                            24,
                            22,
                            18,
                            57,
                            14,
                            17,
                            54,
                            32,
                            50,
                            null,
                            "delivery"
                        ],
                        [
                            "FGN89H72LKDQY9RRINTKL",
                            "INF179KB1HP9",
                            "HDFC LIQUID FUND - DIRECT PLAN",
                            "equity",
                            true,
                            true,
                            100,
                            1715212800000,
                            500,
                            "sell",
                            220,
                            17,
                            117,
                            133,
                            9,
                            132,
                            83,
                            69,
                            1,
                            73,
                            27,
                            null,
                            "intraday"
                        ],
                        [
                            "GGFCHMYLKDQY9RRINTGH",
                            "INF846K01DI2",
                            "Axis Bluechip Fund",
                            "equity",
                            true,
                            true,
                            78,
                            1713830400000,
                            88,
                            "sell",
                            20,
                            79,
                            35,
                            65,
                            99,
                            120,
                            146,
                            115,
                            90,
                            100,
                            93,
                            null,
                            "delivery"
                        ],
                        [
                            "PKF88MYGKDQY9RRINTGH",
                            "INF179K01PT5",
                            "HDFC Small Cap Fund",
                            "equity",
                            true,
                            true,
                            90,
                            1736294400000,
                            250,
                            "sell",
                            100,
                            95,
                            105,
                            55,
                            104,
                            39,
                            74,
                            23,
                            26,
                            42,
                            142,
                            null,
                            "delivery"
                        ],
                        [
                            "GHNR59NOHJDQ901TINTLK",
                            "INF200K01OR6",
                            "SBI Magnum Multicap Fund",
                            "equity",
                            true,
                            true,
                            30,
                            1721174400000,
                            450,
                            "sell",
                            160,
                            4,
                            82,
                            120,
                            71,
                            34,
                            38,
                            45,
                            2,
                            67,
                            98,
                            null,
                            "delivery"
                        ],
                        [
                            "HNT59NOGKDQY897TINF4R",
                            "INF200K01OR6",
                            "SBI Magnum Multicap Fund",
                            "equity",
                            true,
                            true,
                            80,
                            1725926400000,
                            500,
                            "sell",
                            160,
                            36,
                            36,
                            69,
                            74,
                            139,
                            57,
                            75,
                            81,
                            118,
                            149,
                            null,
                            "delivery"
                        ],
                        [
                            "KNT59NOGKDQY897TINFTR",
                            "INF200K01OR6",
                            "SBI Magnum Multicap Fund",
                            "equity",
                            true,
                            true,
                            10,
                            1722297600000,
                            10,
                            "sell",
                            160,
                            57,
                            141,
                            136,
                            4,
                            44,
                            47,
                            7,
                            119,
                            105,
                            138,
                            null,
                            "delivery"
                        ],
                        [
                            "HYT59NOGKDQY9YTINFGRN",
                            "INF200K01OR6",
                            "SBI Magnum Multicap Fund",
                            "equity",
                            true,
                            true,
                            10,
                            1721520000000,
                            50,
                            "sell",
                            160,
                            84,
                            38,
                            123,
                            61,
                            19,
                            8,
                            58,
                            18,
                            145,
                            85,
                            null,
                            "delivery"
                        ],
                        [
                            "GJK48MYGKDQY9RRINGFB",
                            "INF179KB1QR6",
                            "ICICI LIQUID FUND - DIRECT PLAN",
                            "equity",
                            true,
                            true,
                            75,
                            1729987200000,
                            45,
                            "sell",
                            300,
                            39,
                            95,
                            149,
                            59,
                            12,
                            133,
                            149,
                            109,
                            98,
                            66,
                            null,
                            "intraday"
                        ]
                    ]
                }
            ]
        },
        {
            "name": "bond_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "bond_tradebook_table",
                    "@entity": "table",
                    "header": [
                        "trade_id",
                        "isin",
                        "security_name",
                        "is_listed",
                        "quantity",
                        "date",
                        "price",
                        "transaction_type",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fees",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "label"
                    ],
                    "rows": [
                        [
                            "TGFCH72LKDQY9RRINTGH",
                            "INE261F07032",
                            "07.64% NABARD TFB 2031",
                            true,
                            500,
                            1738694400000,
                            10,
                            "buy",
                            31,
                            50,
                            13,
                            3,
                            115,
                            100,
                            109,
                            56,
                            8,
                            null
                        ],
                        [
                            "KGFCH72LKDQY9RRINTGH",
                            "INE261F07032",
                            "07.64% NABARD TFB 2031",
                            true,
                            500,
                            1741113600000,
                            10,
                            "buy",
                            121,
                            112,
                            21,
                            98,
                            33,
                            113,
                            104,
                            98,
                            61,
                            null
                        ],
                        [
                            "BVNCH72LKDQY9RRINTGH",
                            "INE272F07011",
                            "Blue Dart Express",
                            true,
                            50,
                            1730832000000,
                            20,
                            "buy",
                            35,
                            112,
                            55,
                            9,
                            13,
                            41,
                            75,
                            37,
                            5,
                            null
                        ],
                        [
                            "BNG57MYGKDQY9RRINTGH",
                            "INE112J07020",
                            "IFCI",
                            true,
                            200,
                            1733414400000,
                            16.55,
                            "buy",
                            78,
                            26,
                            27,
                            16,
                            60,
                            45,
                            87,
                            118,
                            84,
                            null
                        ],
                        [
                            "GJK45MYGKDQY9RRINTGH",
                            "INE130K08000",
                            "SBOX",
                            false,
                            200,
                            1735574400000,
                            16.55,
                            "buy",
                            60,
                            16,
                            109,
                            81,
                            80,
                            114,
                            63,
                            119,
                            84,
                            null
                        ],
                        [
                            "GHL909MYGKDQY9RRINTGH",
                            "INE130K08001",
                            "QCK",
                            false,
                            200,
                            1633996800000,
                            16.55,
                            "buy",
                            43,
                            127,
                            37,
                            52,
                            86,
                            116,
                            46,
                            118,
                            84,
                            null
                        ],
                        [
                            "BHMGP79GKDQY9RRINTGH",
                            "INE130K08012",
                            "GGL",
                            true,
                            200,
                            1585008000000,
                            550,
                            "buy",
                            87,
                            21,
                            50,
                            5,
                            71,
                            37,
                            22,
                            81,
                            106,
                            null
                        ],
                        [
                            "MJK88MYGKDQY9RRINTGH",
                            "INE130K08019",
                            "APPL",
                            false,
                            200,
                            1633564800000,
                            350,
                            "buy",
                            114,
                            12,
                            100,
                            114,
                            51,
                            15,
                            37,
                            44,
                            108,
                            null
                        ],
                        [
                            "GGFCHMYLKDQY9RRINTGH",
                            "INE261F07055",
                            "SGB",
                            true,
                            500,
                            1437177600000,
                            488,
                            "buy",
                            95,
                            69,
                            57,
                            104,
                            77,
                            41,
                            38,
                            28,
                            101,
                            null
                        ],
                        [
                            "GGFCHMYLKDQY9RRINTGH",
                            "INE261F07055",
                            "SGB",
                            true,
                            500,
                            1626652800000,
                            322,
                            "buy",
                            22,
                            51,
                            38,
                            76,
                            101,
                            87,
                            53,
                            77,
                            4,
                            null
                        ],
                        [
                            "JHF78MYGKDQY9RRINTGH",
                            "INE261F07055",
                            "SGB",
                            true,
                            100,
                            1626739200000,
                            350,
                            "buy",
                            11,
                            26,
                            86,
                            34,
                            107,
                            43,
                            1,
                            101,
                            6,
                            null
                        ],
                        [
                            "KHF78MYGKDQY9RRINTGH",
                            "INE272F07011",
                            "Blue Dart Express",
                            true,
                            20,
                            1733788800000,
                            200,
                            "sell",
                            108,
                            4,
                            102,
                            57,
                            11,
                            105,
                            16,
                            56,
                            86,
                            null
                        ],
                        [
                            "GHN78MYGKDQY9RRINTGH",
                            "INE112J07020",
                            "IFCI",
                            true,
                            170,
                            1734998400000,
                            500,
                            "sell",
                            71,
                            109,
                            99,
                            30,
                            11,
                            126,
                            102,
                            18,
                            24,
                            null
                        ],
                        [
                            "BHM88MYGKDQY9RRINTGH",
                            "INE130K08000",
                            "SBOX",
                            false,
                            170,
                            1733875200000,
                            500,
                            "sell",
                            78,
                            99,
                            8,
                            16,
                            9,
                            102,
                            63,
                            100,
                            31,
                            null
                        ],
                        [
                            "BHM88MTYH6QY9RRINTGH",
                            "INE130K08001",
                            "QCK",
                            false,
                            200,
                            1721779200000,
                            500,
                            "sell",
                            48,
                            128,
                            1,
                            120,
                            112,
                            20,
                            79,
                            115,
                            74,
                            null
                        ],
                        [
                            "BLKMN98HJNMDQY9RRINTGH",
                            "INE130K08015",
                            "GGL",
                            true,
                            200,
                            1712448000000,
                            600,
                            "sell",
                            37,
                            85,
                            53,
                            113,
                            102,
                            42,
                            48,
                            31,
                            15,
                            null
                        ],
                        [
                            "CVH78MYGKDQY9RRINTGH",
                            "INE130K08019",
                            "APPL",
                            false,
                            180,
                            1734566400000,
                            310,
                            "sell",
                            112,
                            109,
                            45,
                            32,
                            49,
                            53,
                            47,
                            124,
                            111,
                            null
                        ],
                        [
                            "GMFCH72LKDQY9RRINTGH",
                            "INE261F07032",
                            "07.64% NABARD TFB 2031",
                            true,
                            500,
                            1728864000000,
                            125,
                            "sell",
                            15,
                            26,
                            86,
                            64,
                            56,
                            26,
                            30,
                            21,
                            125,
                            null
                        ],
                        [
                            "GMFCH72LKDQY9RRINTGH",
                            "INE261F07032",
                            "07.64% NABARD TFB 2031",
                            true,
                            500,
                            1729036800000,
                            125,
                            "sell",
                            76,
                            101,
                            104,
                            28,
                            127,
                            21,
                            26,
                            88,
                            70,
                            null
                        ],
                        [
                            "JTR59NOGKDQY9YTINTGH",
                            "INE261F07055",
                            "SGB",
                            true,
                            550,
                            1721520000000,
                            350,
                            "sell",
                            107,
                            97,
                            94,
                            49,
                            49,
                            9,
                            112,
                            69,
                            129,
                            null
                        ],
                        [
                            "DFGR59NOHJDQ751TINTJK",
                            "INE261F07055",
                            "SGB",
                            true,
                            50,
                            1728432000000,
                            400,
                            "sell",
                            80,
                            10,
                            130,
                            58,
                            5,
                            46,
                            108,
                            40,
                            106,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "debenture_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "debenture_tradebook_table",
                    "@entity": "table",
                    "header": [
                        "trade_id",
                        "isin",
                        "security_name",
                        "is_listed",
                        "quantity",
                        "date",
                        "price",
                        "transaction_type",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fees",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "label"
                    ],
                    "rows": [
                        [
                            "RJFWB5JYYDORFUEPK5DQ",
                            "INE261F07032",
                            "07.64% NABARD TFB 2031",
                            true,
                            1000,
                            1525824000000,
                            10,
                            "buy",
                            177,
                            180,
                            238,
                            105,
                            243,
                            101,
                            131,
                            187,
                            104,
                            null
                        ],
                        [
                            "DML3WXXE53PJOTGTEYKJ",
                            "INE272F07011",
                            "Blue Dart Express",
                            true,
                            50,
                            1589414400000,
                            20,
                            "buy",
                            61,
                            48,
                            59,
                            117,
                            236,
                            125,
                            232,
                            240,
                            106,
                            null
                        ],
                        [
                            "ULDR4PE639LOMU4A4VCE",
                            "INE112J07020",
                            "IFCI",
                            true,
                            200,
                            1515456000000,
                            16.55,
                            "buy",
                            74,
                            176,
                            232,
                            177,
                            230,
                            53,
                            210,
                            110,
                            125,
                            null
                        ],
                        [
                            "QOO5OYJLQBIRUMIGKCIQ",
                            "INE130K08000",
                            "SBOX",
                            false,
                            200,
                            1493769600000,
                            16.55,
                            "buy",
                            108,
                            88,
                            142,
                            17,
                            130,
                            214,
                            66,
                            207,
                            179,
                            null
                        ],
                        [
                            "PZUTEFRTRX9LFW9DPHAW",
                            "INE130K08001",
                            "QCK",
                            false,
                            200,
                            1437177600000,
                            16.55,
                            "buy",
                            133,
                            242,
                            225,
                            166,
                            45,
                            232,
                            127,
                            64,
                            210,
                            null
                        ],
                        [
                            "PGR2RDEZFVC2S3YBX1JF",
                            "INE130K08012",
                            "GGL",
                            true,
                            200,
                            1626739200000,
                            550,
                            "buy",
                            157,
                            86,
                            208,
                            79,
                            180,
                            94,
                            158,
                            38,
                            191,
                            null
                        ],
                        [
                            "DUYJ4ZV7OKJA8CV8U1MT",
                            "INE130K08019",
                            "APPL",
                            false,
                            200,
                            1626912000000,
                            350,
                            "buy",
                            215,
                            228,
                            8,
                            98,
                            119,
                            44,
                            185,
                            50,
                            154,
                            null
                        ],
                        [
                            "4AGDXGEEJOUHI6G8ATOU",
                            "INE261F07055",
                            "SGB",
                            true,
                            500,
                            1556409600000,
                            600,
                            "buy",
                            220,
                            239,
                            134,
                            180,
                            58,
                            131,
                            160,
                            117,
                            207,
                            null
                        ],
                        [
                            "AHVDFMGBCECY1IR0QDH9",
                            "INE261F07055",
                            "SGB",
                            true,
                            500,
                            1556409600000,
                            764,
                            "buy",
                            159,
                            38,
                            58,
                            8,
                            34,
                            12,
                            202,
                            103,
                            31,
                            null
                        ],
                        [
                            "Q2DZQ1ITYAOXILWQLHDN",
                            "INE261F07055",
                            "SGB",
                            true,
                            100,
                            1491436800000,
                            890,
                            "buy",
                            189,
                            118,
                            196,
                            90,
                            161,
                            199,
                            36,
                            138,
                            50,
                            null
                        ],
                        [
                            "Y6W9FLHOVJ8TCHHNBYGF",
                            "INE261F07032",
                            "07.64% NABARD TFB 2031",
                            true,
                            1000,
                            1735516800000,
                            10,
                            "sell",
                            224,
                            48,
                            219,
                            210,
                            51,
                            234,
                            197,
                            66,
                            220,
                            null
                        ],
                        [
                            "GYHVDLIIXVTLROOCLVYG",
                            "INE272F07011",
                            "Blue Dart Express",
                            true,
                            20,
                            1713830400000,
                            200,
                            "sell",
                            151,
                            188,
                            89,
                            94,
                            45,
                            54,
                            58,
                            220,
                            6,
                            null
                        ],
                        [
                            "VIHCPUEYSZUMQUVPSJ1P",
                            "INE112J07020",
                            "IFCI",
                            true,
                            170,
                            1714262400000,
                            500,
                            "sell",
                            129,
                            82,
                            120,
                            187,
                            110,
                            174,
                            71,
                            160,
                            42,
                            null
                        ],
                        [
                            "2BOMU4R5WMEONKEI5YT6",
                            "INE130K08000",
                            "SBOX",
                            false,
                            170,
                            1721174400000,
                            500,
                            "sell",
                            97,
                            118,
                            33,
                            9,
                            151,
                            6,
                            38,
                            52,
                            40,
                            null
                        ],
                        [
                            "DIQDEZH7K04QBDCJY0NV",
                            "INE130K08001",
                            "QCK",
                            false,
                            200,
                            1721347200000,
                            500,
                            "sell",
                            78,
                            112,
                            194,
                            9,
                            128,
                            114,
                            154,
                            68,
                            207,
                            null
                        ],
                        [
                            "TFCXQ3TKQRMOHU86MXO1",
                            "INE130K08015",
                            "GGL",
                            true,
                            200,
                            1721520000000,
                            600,
                            "sell",
                            103,
                            56,
                            160,
                            203,
                            240,
                            171,
                            239,
                            71,
                            42,
                            null
                        ],
                        [
                            "2GFSS7XTAHUWHFZH0NBR",
                            "INE130K08019",
                            "APPL",
                            false,
                            180,
                            1721692800000,
                            310,
                            "sell",
                            12,
                            204,
                            93,
                            133,
                            63,
                            206,
                            65,
                            13,
                            167,
                            null
                        ],
                        [
                            "FQQ96BPTGAPAQPLMABNU",
                            "INE261F07055",
                            "SGB",
                            true,
                            550,
                            1733875200000,
                            789,
                            "sell",
                            52,
                            8,
                            14,
                            119,
                            231,
                            1,
                            246,
                            128,
                            155,
                            null
                        ],
                        [
                            "RKW88OVAQVWZMCD9VLJL",
                            "INE261F07055",
                            "SGB",
                            true,
                            50,
                            1728691200000,
                            890,
                            "sell",
                            139,
                            196,
                            103,
                            96,
                            207,
                            102,
                            68,
                            229,
                            5,
                            null
                        ]
                    ]
                }
            ]
        }
    ]
}

Tradewise PnL

View Workbook

👍

Click here to learn more about this JSON Payload

{
    "name": "tradewise_settlement_workbook",
    "@entity": "workbook",
    "sheets": [
        {
            "name": "stock_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "stock_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "symbol",
                        "is_listed",
                        "is_stt_paid",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "fmv",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement",
                        "product_type"
                    ],
                    "rows": [
                        [
                            "INE002A01018",
                            "AJANTAPHARMA",
                            true,
                            true,
                            5,
                            "CJ1CLC4YCBFEZ4CVDNMH",
                            1463356800000,
                            136,
                            "CYX9TQSTWUYK8C9Z7BCE",
                            1733810043000,
                            580,
                            438,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            64.0981,
                            "trade",
                            "delivery"
                        ],
                        [
                            "INE010B01019",
                            "CADILAHC",
                            true,
                            true,
                            1,
                            "VQLDME6IOJZR95BDEKQ9",
                            1730440443000,
                            1290.98,
                            "VXFUFI5Q9HH7FEJPLV3B",
                            1733032443000,
                            1301.78,
                            120,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            91.2,
                            "trade",
                            "delivery"
                        ],
                        [
                            "INE010B01020",
                            "TATA",
                            true,
                            true,
                            10,
                            "VQLDME6IOJZR95BDEKQ4",
                            1730440443000,
                            100,
                            "VXFUFI5Q9HH7FEJPLV3C",
                            1730440443000,
                            150,
                            125,
                            5,
                            40,
                            60,
                            80,
                            1,
                            20,
                            30,
                            4,
                            2,
                            1,
                            "trade",
                            "intraday"
                        ]
                    ]
                },
                {
                    "name": "stock_tradewise_transfer_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "symbol",
                        "quantity",
                        "transfer_date",
                        "price",
                        "transfer_type",
                        "nature_of_transfer",
                        "transfer_value",
                        "transfer_expense"
                    ],
                    "rows": []
                },
                {
                    "name": "stock_tradewise_holding_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "symbol",
                        "quantity",
                        "buy_date",
                        "buy_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INE01C001018",
                            "ADANIPORTS",
                            48,
                            1631145600000,
                            270,
                            "buy",
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "stock_tradewise_open_sell_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "symbol",
                        "quantity",
                        "sell_date",
                        "sell_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INE00E101023",
                            "BIKAJI",
                            260,
                            1693440000000,
                            370,
                            "sell",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "mutual_fund_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "mutual_fund_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "is_listed",
                        "is_stt_paid",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "fmv",
                        "transfer_expenses",
                        "nature_of_settlement"
                    ],
                    "rows": [
                        [
                            "INF846K01DI2",
                            "Axis Bluechip Fund",
                            "equity",
                            true,
                            true,
                            355.9,
                            "GGFCHMYLKDQY9RRINTGH",
                            1491436800000,
                            124.2586,
                            "JHF78MYGKDQY9RRINTGH",
                            1733810043000,
                            212.7,
                            20,
                            68.1534,
                            "trade"
                        ],
                        [
                            "INF846K01DI3",
                            "HDFC",
                            "debt",
                            true,
                            true,
                            4,
                            "GGFCHMYLKDQY9RRINTGA",
                            1730440443000,
                            40,
                            "JHF78MYGKDQY9RRINTGQ",
                            1733032443000,
                            20,
                            20,
                            50,
                            "trade"
                        ]
                    ]
                },
                {
                    "name": "mutual_fund_tradewise_transfer_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "transfer_date",
                        "price",
                        "transfer_type",
                        "nature_of_transfer",
                        "transfer_value",
                        "transfer_expense"
                    ],
                    "rows": []
                },
                {
                    "name": "mutual_fund_tradewise_holding_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "buy_date",
                        "buy_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INF846K01DI2",
                            "Axis Bluechip Fund",
                            "equity",
                            50,
                            1491436800000,
                            124.2586,
                            "buy",
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "mutual_fund_tradewise_open_sell_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "sell_date",
                        "sell_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INF277K01YE6",
                            "TATA LIQUID FUND - DIRECT PLAN",
                            "debt",
                            17.137,
                            1682640000000,
                            160,
                            "sell",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "etf_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "etf_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "is_listed",
                        "is_stt_paid",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "fmv",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement",
                        "product_type"
                    ],
                    "rows": [
                        [
                            "INF179KB1QR6",
                            "ICICI LIQUID FUND - DIRECT PLAN",
                            "equity",
                            true,
                            true,
                            75,
                            "HNM88JKGKDQY9RRINGFB",
                            1491436800000,
                            124.2586,
                            "JHF78MYGKDQY9RRINTGH",
                            1733810043000,
                            45,
                            300,
                            58,
                            223,
                            275,
                            87,
                            82,
                            192,
                            279,
                            110,
                            211,
                            97,
                            "trade",
                            "delivery"
                        ],
                        [
                            "INF179KB1QR7",
                            "ABML",
                            "debt",
                            true,
                            true,
                            1,
                            "HNM88JKGKDQY9RRINGFL",
                            1730440443000,
                            40,
                            "JHF78MYGKDQY9RRINTGQ",
                            1733032443000,
                            45,
                            300,
                            58,
                            223,
                            275,
                            87,
                            82,
                            192,
                            279,
                            110,
                            211,
                            97,
                            "trade",
                            "delivery"
                        ]
                    ]
                },
                {
                    "name": "etf_tradewise_transfer_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "transfer_date",
                        "price",
                        "transfer_type",
                        "nature_of_transfer",
                        "transfer_value",
                        "transfer_expense"
                    ],
                    "rows": []
                },
                {
                    "name": "etf_tradewise_holding_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "buy_date",
                        "buy_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INF179KB1QR8",
                            "ICICI LIQUID FUND - DIRECT PLAN",
                            "equity",
                            75,
                            1658620800000,
                            150,
                            "buy",
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "etf_tradewise_open_sell_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "sell_date",
                        "sell_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INF179KB1QR9",
                            "Parag parikh",
                            "equity",
                            50,
                            1658620800000,
                            150,
                            "sell",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "future_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "future_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement"
                    ],
                    "rows": [
                        [
                            null,
                            "NIFTY 15 JAN 2023 FUT",
                            "equity",
                            25,
                            "Z0FCJBWODSL8GF3KKVPY",
                            1673481600000,
                            168,
                            "VLNYY0FTJTUGELL1TK8D",
                            1733810043000,
                            146,
                            107.7,
                            60.3,
                            3.8,
                            136.4,
                            221.4,
                            427.6,
                            12.2,
                            13.1,
                            58.5,
                            44.7,
                            "trade"
                        ],
                        [
                            null,
                            "NIFTY 15 JAN 2023 FUT",
                            "commodity",
                            75,
                            "Z0FCJBWODSL8GF3KKVPY",
                            1673481600000,
                            168,
                            "VLNYY0FTJTUGELL1TK8D",
                            1733032443000,
                            158,
                            62.1,
                            126.9,
                            30.4,
                            169.2,
                            96.2,
                            155.8,
                            53.6,
                            181.3,
                            144.5,
                            8.1,
                            "trade"
                        ]
                    ]
                },
                {
                    "name": "future_tradewise_open_position_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "trade_date",
                        "trade_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            null,
                            "FUTCUR JPYINR 24 AUG 2023",
                            "currency",
                            10,
                            1690848000000,
                            345.89,
                            "sell",
                            null,
                            null
                        ],
                        [
                            null,
                            "NIFTY 17 APR 2023 FUT",
                            "equity",
                            10,
                            1679616000000,
                            457.89,
                            "buy",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "option_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "option_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement"
                    ],
                    "rows": [
                        [
                            null,
                            "NIFTY 23 JAN 2023 CE 15000",
                            "equity",
                            25,
                            "ULDR4PE639LOMU4A4VCE",
                            1670457600000,
                            1570,
                            "0B3PIU4WMIPKUQEG34BO",
                            1733810043000,
                            1460,
                            1206.3333,
                            2859.6667,
                            2816.6667,
                            1138,
                            442.6667,
                            2843.3333,
                            1416.6667,
                            3065.3333,
                            1862.6667,
                            728.6667,
                            "trade"
                        ],
                        [
                            null,
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            70,
                            "Q5CUBQ2P6B7VKNHCKWD6",
                            1665446400000,
                            139.3077,
                            "DTXGC9I0ZVOI2FFSHIOL",
                            1733032443000,
                            148,
                            305.8462,
                            115.6923,
                            88,
                            140.6154,
                            114.6923,
                            140.6154,
                            185.9231,
                            186.3846,
                            139.1538,
                            165.5385,
                            "trade"
                        ]
                    ]
                },
                {
                    "name": "option_tradewise_open_position_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "trade_date",
                        "trade_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            null,
                            "OPTFUT SILVERM 21 Nov 2022 58000 PE",
                            "commodity",
                            20,
                            1668902400000,
                            156,
                            "sell",
                            null,
                            null
                        ],
                        [
                            null,
                            "FINNIFTY 25 MAY 2023 CE 14900",
                            "equity",
                            10,
                            1682726400000,
                            698.03,
                            "buy",
                            null,
                            null
                        ]
                    ]
                }
            ]
        },
        {
            "name": "bond_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "bond_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "is_listed",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement"
                    ],
                    "rows": [
                        [
                            "INE261F07055",
                            "SGB",
                            true,
                            500,
                            "GGFCHMYLKDQY9RRINTGH",
                            1437177600000,
                            488,
                            "JTR59NOGKDQY9YTINTGH",
                            1733810043000,
                            490,
                            192.2727,
                            157.1818,
                            142.4545,
                            148.5455,
                            121.5455,
                            49.1818,
                            139.8182,
                            90.7273,
                            218.2727,
                            "trade"
                        ]
                    ]
                },
                {
                    "name": "bond_tradewise_transfer_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "transfer_date",
                        "price",
                        "transfer_type",
                        "nature_of_transfer",
                        "transfer_value",
                        "transfer_expense"
                    ],
                    "rows": []
                },
                {
                    "name": "bond_tradewise_holding_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "buy_date",
                        "buy_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INE261F07055",
                            "SGB",
                            400,
                            322,
                            null,
                            "buy",
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "bond_tradewise_open_sell_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "sell_date",
                        "sell_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": []
                }
            ]
        },
        {
            "name": "debenture_sheet",
            "@entity": "sheet",
            "blocks": [
                {
                    "name": "debenture_tradewise_settlement_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "is_listed",
                        "quantity",
                        "buy_trade_id",
                        "buy_date",
                        "buy_price",
                        "sell_trade_id",
                        "sell_date",
                        "sell_price",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fee",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses",
                        "nature_of_settlement"
                    ],
                    "rows": [
                        [
                            "INE261F07032",
                            "07.64% NABARD TFB 2031",
                            true,
                            1000,
                            "RJFWB5JYYDORFUEPK5DQ",
                            1437177600000,
                            10,
                            "Y6W9FLHOVJ8TCHHNBYGF",
                            1733810043000,
                            10,
                            401,
                            228,
                            457,
                            315,
                            294,
                            335,
                            328,
                            253,
                            324,
                            "trade"
                        ]
                    ]
                },
                {
                    "name": "debenture_tradewise_transfer_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "transfer_date",
                        "price",
                        "transfer_type",
                        "nature_of_transfer",
                        "transfer_value",
                        "transfer_expense"
                    ],
                    "rows": []
                },
                {
                    "name": "debenture_tradewise_holding_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "buy_date",
                        "buy_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": [
                        [
                            "INE112J07020",
                            "IFCI",
                            30,
                            1515456000000,
                            16.55,
                            "buy",
                            null,
                            null
                        ]
                    ]
                },
                {
                    "name": "debenture_tradewise_open_sell_table",
                    "@entity": "table",
                    "header": [
                        "isin",
                        "security_name",
                        "quantity",
                        "sell_date",
                        "sell_price",
                        "transaction_type",
                        "label",
                        "last_traded_price"
                    ],
                    "rows": []
                }
            ]
        }
    ]
}

Scripwise PnL

View Workbook

👍

Click here to learn more about this JSON Payload

{
    "@entity": "workbook",
    "name": "scripwise_settlement_workbook",
    "sheets": [
        {
            "@entity": "sheet",
            "name": "stock_scripwise_settlement_sheet",
            "blocks": [
                {
                    "@entity": "block",
                    "name": "stock_scripwise_settlement_table",
                    "header": [
                        "id",
                        "isin",
                        "symbol",
                        "is_listed",
                        "is_stt_paid",
                        "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"
                    ],
                    "rows": [
                        [
                            null,
                            "null",
                            "INFY",
                            true,
                            true,
                            55,
                            203.5,
                            300,
                            "long_term",
                            3,
                            2,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ]
                    ]
                }
            ]
        },
        {
            "@entity": "sheet",
            "name": "mutual_fund_scripwise_settlement_sheet",
            "blocks": [
                {
                    "@entity": "block",
                    "name": "mutual_fund_scripwise_settlement_table",
                    "header": [
                        "id",
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "quantity",
                        "buy_average",
                        "sell_average",
                        "holding_period",
                        "transfer_expenses"
                    ],
                    "rows": [
                        [
                            null,
                            "ISIN_GROWW",
                            "GROWW TAX SAVING FUND",
                            "debt",
                            50,
                            200,
                            300,
                            "long_term",
                            3
                        ]
                    ]
                }
            ]
        },
        {
            "@entity": "sheet",
            "name": "future_scripwise_settlement_sheet",
            "blocks": [
                {
                    "@entity": "block",
                    "name": "future_scripwise_settlement_table",
                    "header": [
                        "id",
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "buy_average",
                        "sell_average",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fees",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses"
                    ],
                    "rows": [
                        [
                            null,
                            null,
                            "NIFTY",
                            "equity",
                            12,
                            4000,
                            5000,
                            12,
                            23,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ]
                    ]
                }
            ]
        },
        {
            "@entity": "sheet",
            "name": "option_scripwise_settlement_sheet",
            "blocks": [
                {
                    "@entity": "block",
                    "name": "option_scripwise_settlement_table",
                    "header": [
                        "id",
                        "isin",
                        "contract_name",
                        "asset_class",
                        "quantity",
                        "buy_average",
                        "sell_average",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fees",
                        "stt",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses"
                    ],
                    "rows": [
                        [
                            null,
                            null,
                            "NIFTY",
                            "equity",
                            12,
                            4000,
                            5000,
                            12,
                            23,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ]
                    ]
                }
            ]
        },
        {
            "@entity": "sheet",
            "name": "etf_scripwise_settlement_sheet",
            "blocks": [
                {
                    "@entity": "block",
                    "name": "etf_scripwise_settlement_table",
                    "header": [
                        "id",
                        "isin",
                        "scheme_name",
                        "asset_class",
                        "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"
                    ],
                    "rows": [
                        [
                            null,
                            null,
                            "GOLDBEES",
                            "debt",
                            50,
                            200,
                            300,
                            "long_term",
                            5,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ],
                        [
                            null,
                            null,
                            "GOLDBEES",
                            "equity",
                            50,
                            200,
                            300,
                            "intraday",
                            5,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ]
                    ]
                }
            ]
        },
        {
            "@entity": "sheet",
            "name": "bond_scripwise_settlement_sheet",
            "blocks": [
                {
                    "@entity": "block",
                    "name": "bond_scripwise_settlement_table",
                    "header": [
                        "id",
                        "isin",
                        "security_name",
                        "is_listed",
                        "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"
                    ],
                    "rows": [
                        [
                            null,
                            "ISIN_BOND_SVG",
                            "BOND_SVG",
                            true,
                            10,
                            100,
                            200,
                            "short_term",
                            20,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ]
                    ]
                }
            ]
        },
        {
            "@entity": "sheet",
            "name": "debenture_scripwise_settlement_sheet",
            "blocks": [
                {
                    "@entity": "block",
                    "name": "debenture_scripwise_settlement_table",
                    "header": [
                        "id",
                        "isin",
                        "security_name",
                        "is_listed",
                        "quantity",
                        "buy_average",
                        "sell_average",
                        "holding_period",
                        "brokerage",
                        "clearing_charges",
                        "exchange_transaction_charges",
                        "sebi_turnover_fees",
                        "stamp_duty",
                        "sgst",
                        "cgst",
                        "igst",
                        "other_transfer_expenses"
                    ],
                    "rows": [
                        [
                            null,
                            "ISIN_DEBENTURES_HINDALCO",
                            "DEBENTURE_HINDALCO",
                            false,
                            30,
                            200,
                            100,
                            "short_term",
                            20,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0,
                            0
                        ]
                    ]
                }
            ]
        }
    ]
}