Skip to main content
GET
/
domestic-securities-trade-book
Trade Book API
curl --request GET \
  --url https://api.broker.com/domestic-securities-trade-book \
  --header 'Authorization: <authorization>' \
  --header 'x-api-key: <x-api-key>'
"{\n   \"sheets\": [\n        {\n            \"name\": \"Equity\",\n            \"blocks\": [\n                {\n                    \"name\": \"Tradebook\",\n                    \"@entity\": \"table\",\n                    \"header\": [\n                        \"transaction_id\",\n                        \"isin\",\n                        \"symbol\",\n                        \"quantity\",\n                        \"date\",\n                        \"price\",\n                        \"transaction_type\",\n                        \"fmv\",\n                        \"brokerage\",\n                        \"clearing_charges\",\n                        \"exchange_transaction_charges\",\n                        \"sebi_turnover_fees\",\n                        \"stt\",\n                        \"stamp_duty\",\n                        \"sgst\",\n                        \"cgst\",\n                        \"igst\",\n                      \t\"interest\",\n                      \t\"depository_charges\",\n                        \"other_transfer_expenses\",\n                        \"corporate_action\"\n                    ],\n                    \"rows\": [\n                        [\n                            \"88fb3b2b-8a84-4873-9204-3c5225de4776\",\n                            \"BPCL\",\n                            1,\n                            1643380439478,\n                            2.59,\n                            \"SELL\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"02ba76af-d5a9-40a3-a3ea-60b8aada5817\",\n                            \"AMBUJACEM\",\n                            0.7644,\n                            1643380387229,\n                            164.29,\n                            \"SELL\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                          \t0,\n                            0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be75\",\n                            \"AMBUJACEM\",\n                            0.1,\n                            1634751623480,\n                            148.5,\n                            \"BUY\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                          \t0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be76\",\n                            \"AMBUJACEM\",\n                            0.6644,\n                            1634147917942,\n                            143.29,\n                            \"BUY\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                          \t0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be77\",\n                            \"BPCL\",\n                            1,\n                            1630598986512,\n                            9.63,\n                            \"BUY\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                          \t0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be77\",\n                            \"SCHAEFFLER\",\n                            0.4347826,\n                            1628536115398,\n                            9.2,\n                            \"SELL\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                          \t0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be79\",\n                            \"ASIANPAINT\",\n                            0.00149749,\n                            1628536054329,\n                            3338.92,\n                            \"BUY\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                          \t0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be80\",\n                            \"BERGEPAINT\",\n                            2.55754475,\n                            1628189423570,\n                            15.77,\n                            \"SELL\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                          \t0,\n                            0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be81\",\n                            \"BERGEPAINT\",\n                            2.55754475,\n                            1628189293460,\n                            15.64,\n                            \"BUY\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                          \t0,\n                            0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be85\",\n                            \"SCHAEFFLER\",\n                            1.10987791,\n                            1628017687633,\n                            9.01,\n                            \"BUY\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                          \t0,\n                            0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be87\",\n                            \"COALINDIA\",\n                            0.2,\n                            1626457655107,\n                            9.75,\n                            \"BUY\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                          \t0,\n                            0,\n                            0,\n                            null\n                        ]\n                    ]\n                }\n            ]\n        },\n        {\n            \"name\": \"Mutual Funds\",\n            \"blocks\": [\n                {\n                    \"name\": \"Tradebook\",\n                    \"@entity\": \"table\",\n                    \"header\": [\n                        \"transaction_id\",\n                        \"isin\",\n                        \"type\",\n                        \"symbol\",\n                        \"quantity\",\n                        \"date\",\n                        \"price\",\n                        \"transaction_type\",\n                        \"fmv\",\n                        \"brokerage\",\n                        \"clearing_charges\",\n                        \"exchange_transaction_charges\",\n                        \"sebi_turnover_fees\",\n                        \"stt\",\n                        \"stamp_duty\",\n                        \"sgst\",\n                        \"cgst\",\n                        \"igst\",\n                        \"other_transfer_expenses\",\n                        \"corporate_action\"\n                    ],\n                    \"rows\": [\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be98\",\n                            null,\n                            \"Equity\",\n                            \"HDFCNIFETF\",\n                            50.0,\n                            1599589800001,\n                            6.0,\n                            \"BUY\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be97\",\n                            null,\n                            \"Equity\",\n                            \"HDFCNIFETF\",\n                            35.0,\n                            1643804395000,\n                            8.5,\n                            \"SELL\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be96\",\n                            null,\n                            \"Debt\",\n                            \"GOLDBEES\",\n                            35.0,\n                            1599589800001,\n                            6,\n                            \"BUY\",\n                            0,\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            null\n                        ]\n                    ]\n                }\n            ]\n        },\n        {\n            \"name\": \"Futures and Options\",\n            \"blocks\": [\n                {\n                    \"name\": \"Tradebook\",\n                    \"@entity\": \"table\",\n                    \"header\": [\n                        \"transaction_id\",\n                        \"isin\",\n                        \"type\",\n                        \"symbol\",\n                        \"quantity\",\n                        \"date\",\n                        \"price\",\n                        \"transaction_type\",\n                        \"brokerage\",\n                        \"clearing_charges\",\n                        \"exchange_transaction_charges\",\n                        \"sebi_turnover_fees\",\n                        \"stt\",\n                        \"stamp_duty\",\n                        \"sgst\",\n                        \"cgst\",\n                        \"igst\",\n                      \t\"interest\",\n                        \"other_transfer_expenses\"\n                    ],\n                    \"rows\": [\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be94\",\n                            null,\n                            \"Futures\",\n                            \"BANKNIFTY OCT FUT\",\n                            50.0,\n                            1599589800001,\n                            6.0,\n                            \"BUY\",\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                            0\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be93\",\n                            null,\n                            \"Futures\",\n                            \"BANKNIFTY OCT FUT\",\n                            35.0,\n                            1643804395000,\n                            8.5,\n                            \"SELL\",\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                            0\n                        ],\n                        [\n                            \"58c3d492-3222-45bf-b316-33db0036be92\",\n                            null,\n                            \"Options\",\n                            \"BHARTIARTL OCT 630 CE\",\n                            35.0,\n                            1599589800001,\n                            6,\n                            \"BUY\",\n                            1,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                            0,\n                          \t0,\n                            0,\n                            0\n                        ]\n                    ]\n                }\n            ]\n        }\n    ]\n}"

Headers

x-api-key
string
required

API key to uniquely identify the API user

x-api-version
string

API version

Authorization
string
required

Authentication token to authorize the request

Query Parameters

from
string
required

The start date for fetching the trades

to
string
required

The end date for fetching the trades

Response

200

sheets
object[]