Scripwise P&L (Coming Soon)

Scripwise trading activity collates all trades to a scrip/instrument. Brokers can use scripwise trading activity to calculate Tax P&L for investors and traders.

API Pricing

Overview

This API calculates Tax P&L by taking in the scripwise trading activity.

Problem

  • Brokers have to provide accurate Realized & Unrealized P&L.
  • Brokers must apply tax rules to accurately calculate Pre-Tax & Post-Tax returns on investments.
  • The tax landscape is ever-changing with announcements from regulators, tax departments & finance ministry.
  • Investors & Traders have to furnish accurate P&L, Holdings, and Turnover in their tax returns as per the tax law.
  • Brokers are unable to provide accurate tax computations.

Solution

  • API to calculate Tax P&L in real-time.
  • API covers tax calculation for corporate actions such as dividends, buybacks, etc.
  • Allows Brokers to visualize Tax P&L for their users.
  • Tax P&L report is generated using the scripwise method.

Endpoint

HTTP MethodEndpoint
POST/calculator/income-tax/tax-pnl

API Endpoint  Contact Us  Free Trial

Request

Follow the below guidelines to pass Scripwise trading activity to calculate Scripwise Tax P&L

Body

Equity Trade

ParamTypeRequiredDescription
isinstringNoISIN is the international security identification number
symbolstringYesSymbol or description of equity share
quantitynumberYesTrading quantity
buy_averagenumberYesAverage buy price across all trades
sell_averagenumberYesAverage sell price across all trades
fmvnumberNoHigh stock price on 31/01/2018
holding_periodnumberYesHolding period, possible values
Intraday, Short Term, Long Term
brokeragenumberNoBrokerage expense
clearing_chargesnumberNoCharges charged by clearing house
exchange_transaction_chargesnumberNoTransaction charges by exchange
sebi_turnover_feesnumberNoTurnover fees by SEBI
sttnumberNoSecurity Transaction Tax
stamp_dutynumberNoStamp duty paid on transfer of shares
sgstnumberNoState GST
cgstnumberNoCentral GST
igstnumberNoIntegrated GST
other_transfer_expensesnumberNoAny other expense relating to the transfer of shares
corporate_actionstringNoRefer to Corporate Actions for possible values

Mutual Fund Trade

ParamTypeRequiredDescription
isinstringNoISIN is the international security identification number
scheme_typestringYesScheme type, possible values
Equity, Debt, Other
symbolstringYesSymbol or description of Mutual Fund
quantitynumberYesTrading quantity
buy_averagenumberYesAverage buy price across all trades
sell_averagenumberYesAverage sell price across all trades
fmvnumberNoHigh stock price on 31/01/2018
holding_periodnumberYesHolding period, possible values
Short Term, Long Term
brokeragenumberNoBrokerage expense
clearing_chargesnumberNoCharges charged by clearing house
exchange_transaction_chargesnumberNoTransaction charges by exchange
sebi_turnover_feesnumberNoTurnover fees by SEBI
sttnumberNoSecurity Transaction Tax
stamp_dutynumberNoStamp duty paid on transfer of shares
sgstnumberNoState GST
cgstnumberNoCentral GST
igstnumberNoIntegrated GST
other_transfer_expensesnumberNoAny other expense relating to the transfer of shares
corporate_actionstringNoRefer to Corporate Actions for possible values

Futures and Options Trade

ParamTypeRequiredDescription
symbolstringYesSymbol or description of equity share
typestringYesType, possible values
Futures, Options
quantitynumberYesTrading quantity
buy_averagenumberYesAverage buy price across all trades
sell_averagenumberYesAverage sell price across all trades
brokeragenumberNoBrokerage expense
clearing_chargesnumberNoCharges charged by clearing house
exchange_transaction_chargesnumberNoTransaction charges by exchange
sebi_turnover_feesnumberNoTurnover fees by SEBI
sttnumberNoSecurity Transaction Tax
stamp_dutynumberNoStamp duty paid on transfer of shares
sgstnumberNoState GST
cgstnumberNoCentral GST
igstnumberNoIntegrated GST
other_transfer_expensesnumberNoAny other expense relating to the transfer of shares

Corporate Actions

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 RITESRITES
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 SharesDELISTING

Sample CURL Request

curl --request POST \
     --url https://api.sandbox.co.in/calculators/income-tax/securities/tax-pnl/scripwise \
     --header 'Authorization: xxxxxxxxxxxxxxxxx' \
     --header 'accept: application/json' \
     --header 'content-type: application/json' \
     --header 'x-api-key: xxxxxxxxxxxxxxxxxxxx' \
     --header 'x-api-version: 1.0' \
     --data '
{
     "sheets": [
          {
               "name": "Equity",
               "blocks": [
                    {
                         "name": "Scripwise P&L",
                         "header": [
                              "isin",
                              "symbol",
                              "quantity",
                              "buy_average",
                              "sell_average",
                              "holding_period",
                              "fmv",
                              "brokerage",
                              "clearing_charges",
                              "exchange_transaction_charges",
                              "sebi_turnover_fees",
                              "stt",
                              "stamp_duty",
                              "sgst",
                              "cgst",
                              "igst",
                              "other_transfer_expenses",
                              "corporate_action"
                         ],
                         "rows": [
                              [
                                   "INE079A01024",
                                   "AMBUJACEM",
                                   5,
                                   372.2,
                                   369.4,
                                   "Short Term",
                                   null,
                                   0,
                                   0,
                                   0.78,
                                   0.53,
                                   3.72,
                                   0,
                                   0,
                                   0,
                                   0,
                                   0,
                                   null
                              ]
                         ]
                    }
               ]
          },
          {
               "name": "Mutual Funds",
               "blocks": [
                    {
                         "name": "Scripwise P&L",
                         "header": [
                              "isin",
                              "scheme_type",
                              "symbol",
                              "quantity",
                              "buy_average",
                              "sell_average",
                              "holding_period",
                              "fmv",
                              "brokerage",
                              "clearing_charges",
                              "exchange_transaction_charges",
                              "sebi_turnover_charges",
                              "stt",
                              "stamp_duty",
                              "sgst",
                              "cgst",
                              "igst",
                              "other_transfer_expenses",
                              "corporate_actions"
                         ],
                         "rows": []
                    }
               ]
          },
          {
               "name": "Futures & Options",
               "blocks": [
                    {
                         "name": "Scripwise P&L",
                         "header": [
                              "symbol",
                              "type",
                              "quantity",
                              "buy_average",
                              "sell_average",
                              "brokerage",
                              "clearing_charges",
                              "exchange_transaction_charges",
                              "sebi_turnover_fees",
                              "stt",
                              "stamp_duty",
                              "sgst",
                              "cgst",
                              "igst",
                              "other_transfer_expenses"
                         ],
                         "rows": []
                    }
               ]
          }
     ]
}
'

❗️

Test Environment Not Available

Response

Equity Trade

ParamTypeRequiredDescription
isinstringNoISIN is the international security identification number
symbolstringYesSymbol or description of equity share
quantitynumberYesTrading quantity
buy_averagenumberYesAverage buy price across all trades
sell_averagenumberYesAverage sell price across all trades
fmvnumberNoHigh stock price on 31/01/2018
holding_periodnumberYesHolding period, possible values
Intraday, Short Term, Long Term
brokeragenumberNoBrokerage expense
clearing_chargesnumberNoCharges charged by clearing house
exchange_transaction_chargesnumberNoTransaction charges by exchange
sebi_turnover_feesnumberNoTurnover fees by SEBI
sttnumberNoSecurity Transaction Tax
stamp_dutynumberNoStamp duty paid on transfer of shares
sgstnumberNoState GST
cgstnumberNoCentral GST
igstnumberNoIntegrated GST
other_transfer_expensesnumberNoAny other expense relating to the transfer of shares
corporate_actionstringNoRefer to Corporate Actions for possible values

Mutual Fund Trade

ParamTypeRequiredDescription
isinstringNoISIN is the international security identification number
scheme_typestringYesScheme type, possible values
Equity, Debt, Other
symbolstringYesSymbol or description of Mutual Fund
quantitynumberYesTrading quantity
buy_averagenumberYesAverage buy price across all trades
sell_averagenumberYesAverage sell price across all trades
fmvnumberNoHigh stock price on 31/01/2018
holding_periodnumberYesHolding period, possible values
Short Term, Long Term
brokeragenumberNoBrokerage expense
clearing_chargesnumberNoCharges charged by clearing house
exchange_transaction_chargesnumberNoTransaction charges by exchange
sebi_turnover_feesnumberNoTurnover fees by SEBI
sttnumberNoSecurity Transaction Tax
stamp_dutynumberNoStamp duty paid on transfer of shares
sgstnumberNoState GST
cgstnumberNoCentral GST
igstnumberNoIntegrated GST
other_transfer_expensesnumberNoAny other expense relating to the transfer of shares
corporate_actionstringNoRefer to Corporate Actions for possible values

Futures and Options Trade

ParamTypeRequiredDescription
symbolstringYesSymbol or description of equity share
typestringYesType, possible values
Futures, Options
quantitynumberYesTrading quantity
buy_averagenumberYesAverage buy price across all trades
sell_averagenumberYesAverage sell price across all trades
brokeragenumberNoBrokerage expense
clearing_chargesnumberNoCharges charged by clearing house
exchange_transaction_chargesnumberNoTransaction charges by exchange
sebi_turnover_feesnumberNoTurnover fees by SEBI
sttnumberNoSecurity Transaction Tax
stamp_dutynumberNoStamp duty paid on transfer of shares
sgstnumberNoState GST
cgstnumberNoCentral GST
igstnumberNoIntegrated GST
other_transfer_expensesnumberNoAny other expense relating to the transfer of shares

Response Caching

Response caching is not available for this API. Learn more about our response caching mechanism here

Wallet Charge

Since the Tax P&L Calculator from Scripwise API is not a Paid API, no wallet charge will take place.

Versioning

This API is currently in major version 1.0. Refer to our versioning policies here