Skip to main content
GET
/
securities
/
foreign
/
tradewise-pnl
Foreign Securities Tradewise P&L API
curl --request GET \
  --url https://api.broker.com/securities/foreign/tradewise-pnl \
  --header 'Authorization: <authorization>' \
  --header 'x-api-key: <x-api-key>'
"{\n  \"sheets\": [\n        {\n            \"name\": \"Equity\",\n            \"blocks\": [\n                {\n                    \"name\": \"Equity\",\n                    \"@entity\" : \"table\",\n                    \"header\": [\n                        \"isin\",\n                        \"symbol\",\n                        \"quantity\",\n                        \"buy_date\",\n                        \"buy_average\",\n                        \"sell_date\",\n                        \"sell_average\",\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                            \"INE428A01015\",\n                            \"Allahabad Bank\",\n                            100,\n                            1666867967000,\n                            11.75,\n                            1666867965000,\n                            15.25,\n                            null,\n                            0,\n                            0,\n                            1.5,\n                            0.75,\n                            2.25,\n                            0.5,\n                            0,\n                            0,\n                            0,\n                            0,\n                            null\n                        ],\n                        [\n                            \"INE428A01015\",\n                            \"Allahabad Bank\",\n                            10,\n                            1666867967000,\n                            11.5,\n                            1666867967000,\n                            16,\n                            null,\n                            0,\n                            0,\n                            0.25,\n                            0.35,\n                            0.25,\n                            0.15,\n                            0,\n                            0,\n                            0,\n                            0,\n                            null\n                        ]\n                    ]\n                }\n            ]\n        },\n        {\n            \"name\": \"Mutual Funds\",\n            \"blocks\": [\n                {\n                    \"name\": \"Mutual Funds\",\n                    \"@entity\": \"table\",\n                    \"header\": [\n                        \"isin\",\n                        \"scheme_type\",\n                        \"symbol\",\n                        \"quantity\",\n                        \"buy_date\",\n                        \"buy_average\",\n                        \"sell_date\",\n                        \"sell_average\",\n                        \"fmv\",\n                        \"brokerage\",\n                        \"clearing_charges\",\n                        \"exchange_transaction_charges\",\n                        \"sebi_turnover_charges\",\n                        \"stt\",\n                        \"stamp_duty\",\n                        \"sgst\",\n                        \"cgst\",\n                        \"igst\",\n                        \"other_transfer_expenses\",\n                        \"corporate_actions\"\n                    ]\n                }\n            ]\n        },\n        {\n            \"name\": \"Futures & Options\",\n            \"@entity\": \"table\",\n            \"blocks\": [\n                {\n                    \"name\": \"Futures & Options\",\n                    \"header\": [\n                        \"symbol\",\n                        \"type\",\n                        \"quantity\",\n                        \"buy_average\",\n                        \"sell_average\",\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                    ]\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[]