Skip to main content

Stock Tradewise Settlement Sheet

Stock Tradewise Settlement Table

ParamTypeDescription
isinstringISIN is the international security identification number
symbolstringSymbol or description of equity share
quantitynumberTrading quantity
buy_trade_idstringTransaction ID of the buy transaction
buy_datenumberThe date on which the equity stock was bought
buy_pricenumberPrice at which a unit was bought
sell_trade_idstringTransaction ID of the sell transaction
sell_datenumberThe date on which the equity stock was sold
sell_pricenumberPrice at which a unit was sold
currencystringThe 3 letter currency code for the price based on ISO 421
transfer_expensesnumberexpense relating to the transfer of stocks
nature_of_settlementstringThe nature of the settlement of transaction
product_typestringIndicates whether the order is :delivery , intraday

Stock Tradewise Open Sell Table

ParamTypeDescription
isinstringISIN is the international security identification number
symbolstringSymbol or description of equity share
quantitynumberTrading quantity
sell_trade_idstringTransaction ID of the sell transaction
sell_datenumberThe date on which the equity stock was sold
sell_pricenumberPrice at which a unit was sold
currencystringThe 3 letter currency code for the price based on ISO 4217
transaction_typestringIndicates whether the order is :buy, sell, trade, send, receive
labelstringIndicates the category of transaction type. Possible values: interest, staking, staking_reward, lost, mining_reward, airdrop, donation, fork, gift, payment, other_income
last_traded_pricenumberLast traded price of the security

Stock Tradewise Transfer Table

ParamTypeDescription
isinstringISIN is the international security identification number
symbolstringSymbol or description of equity share
quantitynumberTrading quantity
transfer_datenumberThe date on which the transfer was made
pricenumberPrice at which a unit was transferred
currencystringThe 3 letter currency code for the price based on ISO 4217
transfer_typestringIndicates whether the transfer is :transfer_in, transfer_out
nature_of_settlementstringThe nature of the settlement of transaction
transfer_valuenumbertotal value of transfers made
transfer_expensenumberexpenses incurred while transferring the asset.

Dividend Table

ParamTypeRequiredDescription
isinstringNoISIN is the international security identification number
scheme_namestringYesSymbol or description of the fund
quantitynumberYesTrading quantity
datenumberYesTransaction epoch timestamp
dividend_amountnumberYesDividend amount received
currencystringYesThe 3 letter currency code for the price based on ISO 4217
tax_withheldnumberYesTDS amount deducted on the dividend

Interest Income Sheet

Interest Table

ParamTypeRequiredDescription
descriptionstringNoDescription of interest credit
datenumberYesTransaction ID of the particular entry
amountnumberYesInterest amount received
currencystringYesThe 3 letter currency code for the price based on ISO 4217
tax_withheldnumberYesTDS amount deducted on the interest

Annexures

Annexure-1 Labels

The enumeration is explained below:
Corporate ActionENUM
Amalgamationamalgamation
Bonus Issuebonus_issue
Buy Back of Sharesbuy_back
Consolidation of Sharesconsolidation
Dividenddividend
Dividend on Preference Sharesdividend
Income Distribution (InvIT)income_distribution_invit
Income Distribution RITESincome_distribution_rites
InvIT - Return of Capitalreturn_of_capital_invit
Preferential Issue of sharespreferential_issue
Reduction of Capitalreduction_of_capital
Right Issue of Equity Sharesright_issue
Scheme of Arrangementscheme_of_arrangement
Spin Offspin_off
Stock Splitstock_split
Voluntary Delisting of Sharesvoluntary_delisting_of_share
Donation of securitydonation
Transfer of securities in form of giftgift
Loss of securitylost
Transfer of securitiestransfer
Otherother

Annexure-2 Nature of Settlement

Nature of SettlementENUM
Trade type settlementtrade
Interest on securityinterest
Asset transferred intransfer_in
Asset transferred outtransfer_out
Asset sent as Giftgift_send
Asset received as Giftgift_receive
Asset donateddonation
Buy back for the securitybuy_back
Otherother