Skip to main content

Overview

The Domestic Securities Tradebook API provides a comprehensive record of all trades executed by a user for domestic securities. A trade book includes details of every buy and sell transaction, along with associated taxes and expenses. This data is critical for Quicko to:
  • Calculate capital gains and losses
  • Track cost basis and holding periods for tax compliance
  • Identify tax harvesting opportunities
  • Prepare accurate tax reports and maintain audit trails
  • Ensure compliance with tax regulations

Query Parameters

Your API should accept from and to query parameters to retrieve trades within a specific date range. Quicko typically requests all trades since account inception for accurate tax calculations.
GET /domestic-securities-trade-book?from=YYYY-MM-DD&to=YYYY-MM-DD
ImportantAll the transactions should be passed in the request since inception of the account to ensure accurate tax calculations and compliance.

Trade Types

Equity Trades

Domestic equity share transactions with comprehensive tax expense breakdowns.

Required Fields

ParamTypeDescription
transaction_idstringTransaction Id to uniquely identify the transaction
symbolstringSymbol or description of equity share
quantitynumberTrading quantity
datenumberTransaction epoch timestamp
pricenumberTransaction price
transaction_typestringTransaction type from possible values of ‘BUY’ or ‘SELL’
ParamTypeDescription
isinstringISIN is the international security identification number
fmvnumberHigh stock price on 31/01/2018
brokeragenumberBrokerage expense
clearing_chargesnumberCharges charged by clearing house
exchange_transaction_chargesnumberTransaction charges by exchange
sebi_turnover_feesnumberTurnover fees by SEBI
sttnumberSecurity Transaction Tax
stamp_dutynumberStamp duty paid on transfer of shares
sgstnumberState GST
cgstnumberCentral GST
igstnumberIntegrated GST
interestnumberInterest paid on margins eg Margin Trading Facility
depository_chargesnumberDepository charges paid on delivery of shares
other_transfer_expensesnumberAny other expense relating to the transfer of shares
corporate_actionstringCorporate Action. Possible values: BUY_BACK, DIVIDEND

Mutual Fund Trades

Mutual fund purchase and redemption transactions with scheme classification.

Required Fields

ParamTypeDescription
transaction_idstringTransaction Identifier to uniquely identify the transaction
typestringScheme type, possible values: Equity, Debt, Other
symbolstringSymbol or description of mutual fund scheme
quantitynumberTrading quantity (units)
datenumberTransaction epoch timestamp
pricenumberNAV (Net Asset Value) at transaction
transaction_typestringTransaction type possible values: ‘BUY’, ‘SELL’
ParamTypeDescription
isinstringISIN is the international security identification number
fmvnumberHigh stock price on 31/01/2018
brokeragenumberBrokerage expense
clearing_chargesnumberCharges charged by clearing house
exchange_transaction_chargesnumberTransaction charges by exchange
sebi_turnover_feesnumberTurnover fees by SEBI
sttnumberSecurity Transaction Tax
stamp_dutynumberStamp duty paid on transfer of shares
sgstnumberState GST
cgstnumberCentral GST
igstnumberIntegrated GST
other_transfer_expensesnumberAny other expense relating to the transfer of units

Futures and Options Trades

Derivative contracts including futures and options trading with comprehensive expense tracking.

Required Fields

ParamTypeDescription
transaction_idstringTransaction identifier to uniquely identify the transaction
symbolstringSymbol or description of the derivative contract
typestringType, possible values: Futures, Options
quantitynumberTrading quantity (lot size)
datenumberTransaction epoch timestamp
pricenumberTransaction price
transaction_typestringTransaction type possible values: ‘BUY’, ‘SELL’
ParamTypeDescription
brokeragenumberBrokerage expense
clearing_chargesnumberCharges charged by clearing house
exchange_transaction_chargesnumberTransaction charges by exchange
sebi_turnover_feesnumberTurnover fees by SEBI
sttnumberSecurity Transaction Tax
stamp_dutynumberStamp duty paid on transfer
sgstnumberState GST
cgstnumberCentral GST
igstnumberIntegrated GST
interestnumberInterest paid on margins eg Margin Trading Facility
other_transfer_expensesnumberAny other expense relating to the transfer

Foreign Securities

International equity share transactions.
ParamTypeRequiredDescription
transaction_idstringYesTransaction Identifier to uniquely identify the transaction
isinstringNoISIN is the international security identification number
symbolstringYesSymbol or description of equity share
quantitynumberYesTrading quantity
datenumberYesTransaction epoch timestamp
pricenumberYesTransaction price
transaction_typestringYesTransaction type from possible values of ‘BUY’ or ‘SELL’
transfer_expensesnumberYesTransfer expense
corporate_actionstringNoCorporate Action. Possible values: BUY_BACK, DIVIDEND
For foreign securities, transfer expenses typically include foreign exchange fees, wire transfer charges, and custodian fees.

Corporate Actions

Use these standard enumeration values when reporting corporate actions in trade data.
Corporate actions can significantly impact capital gains calculations. Ensure you use the correct enum value for accurate tax reporting.

Share Structure Changes

Corporate ActionENUM ValueDescription
Bonus IssueBONUS_ISSUEFree additional shares to shareholders
Stock SplitSTOCK_SPLITSubdivision of existing shares
Consolidation of SharesCONSOLIDATIONReverse stock split
Right Issue of Equity SharesRIGHT_ISSUEAdditional shares offered to existing shareholders
Corporate ActionENUM ValueDescription
DividendDIVIDENDCash or stock dividend payment
Income Distribution (InvIT)INCOME_DISTRIBUTION_INVITInvIT income distribution
Income Distribution RITESRITESRITES income distribution
InvIT - Return of CapitalRETURN_OF_CAPITAL_INVITReturn of capital from InvIT
Corporate ActionENUM ValueDescription
AmalgamationAMALGAMATIONMerger of two or more companies
Scheme of ArrangementSCHEME_OF_ARRANGEMENTCorporate restructuring scheme
Spin OffSPIN_OFFSeparation of business division
Corporate ActionENUM ValueDescription
Buy Back of SharesBUY_BACKCompany repurchasing its own shares
Reduction of CapitalREDUCTION_OF_CAPITALReduction in company’s share capital
Preferential Issue of sharesPREFERENTIAL_ISSUEPrivate placement of shares
Voluntary Delisting of SharesDELISTINGRemoval from stock exchange listing
When processing corporate actions, ensure you maintain the continuity of cost basis and holding period for accurate capital gains tax calculations.