Workbook contains sheets for Stocks, MFs, ETFs, FnO, Bonds & Debentures
Stock Tradebook Sheet
Sheet contains table of stock trades
Stock Tradebook Table
Table contains transactional data including buy value, sell value, quantity etc...
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of equity stock |
| is_listed | boolean | Yes | is the equity stock listed in public markets |
| is_stt_paid | boolean | Yes | was security transaction tax paid on this trade |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | The unit price of the equity stock |
| transaction_type | string | Yes | Indicates whether the order is :buy , sell, send, receive Or trade, |
| fmv | number | No | Fair market value of the equity stock as on 31/01/2018 |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax paid on the security |
| stamp_duty | number | No | Stamp duty paid on transfer of stock |
| sgst | number | No | State Goods & Services Tax |
| cgst | number | No | Central Goods & Services Tax |
| igst | number | No | Integrated Goods & Services Tax |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of shares |
| label | string | No | Refer to label for possible values |
| product_type | string | Yes | Indicates whether the order is :delivery , intraday |
Mutual Fund Tradebook Sheet
Sheet contains table of mutual fund trades
Mutual Fund Tradebook Table
Table contains transactional data including scheme, buy & sell value, quantity, expenses, etc...
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | Yes | ISIN is the international security identification number |
| scheme_name | string | Yes | Symbol or name of mutual fund |
| asset_class | string | Yes | Asset class of fund, possible valuesequity, debt, other |
| is_listed | boolean | Yes | is the scheme listed in public markets |
| is_stt_paid | boolean | Yes | was security transaction tax paid on this trade |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp in millis |
| price | number | Yes | Transaction price |
| transaction_type | string | Yes | Indicates whether the order is :buy , sell, send, receive Or trade, |
| fmv | number | No | Fare market value of the mutual fund unit as on 31/01/2018 |
| transfer_expenses | number | No | Any other expense relating to the transfer of fund units |
| label | string | No | Refer to label for possible values |
ETF Tradebook Sheet
Sheet contains table of Exchange Traded Fund trades
ETF Tradebook Table
Table contains transactional data including scheme, buy & sell value, quantity, expenses, etc...
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | No | ISIN is the international security identification number |
| scheme_name | string | Yes | Symbol or description of exchange-traded fund |
| asset_class | string | Yes | Asset class of fund, possible valuesequity, debt, other |
| is_listed | boolean | Yes | is the fund listed in public markets |
| is_stt_paid | boolean | Yes | was security transaction tax paid on this trade |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | The unit price of the fund |
| transaction_type | string | Yes | Indicates whether the order is :buy , sell, send, receive Or trade, |
| fmv | number | No | Fair market value of the fund as on 31/01/2018 |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax paid on the security |
| stamp_duty | number | No | Stamp duty paid on transfer of the fund |
| sgst | number | No | State Goods & Services Tax |
| cgst | number | No | Central Goods & Services Tax |
| igst | number | No | Integrated Goods & Services Tax |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of fund |
| label | string | No | Refer to label for possible values |
| product_type | string | Yes | Indicates whether the order is :delivery , intraday |
Future Tradebook Sheet
Sheet contains table of Futures trades
Future Tradebook Table
Table contains transactional data including scheme, buy & sell value, quantity, expenses, etc...
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | Yes | ISIN is the international security identification number |
| contract_name | string | Yes | Name of contract |
| asset_class | string | Yes | The asset class of the contract. Possible valuesequity, currency & commodity |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | Transaction price |
| transaction_type | string | Yes | Indicates whether the order is :buy Or sell, |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax |
| stamp_duty | number | No | Stamp duty paid on transfer of contract |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of the contract |
| label | string | No | Refer to label for possible values |
OptionTradebook Sheet
Sheet contains table of Options trades
Option Tradebook Table
Table contains transactional data including scheme, buy & sell value, quantity, expenses, etc...
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | Yes | ISIN is the international security identification number |
| contract_name | string | Yes | Name of contract |
| asset_class | string | Yes | The asset class of the contract. Possible valuesequity, currency & commodity |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | Transaction price |
| transaction_type | string | Yes | Indicates whether the order is :buy Or sell, |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stt | number | No | Security Transaction Tax |
| stamp_duty | number | No | Stamp duty paid on transfer of contract |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of the contract |
| label | string | No | Refer to label for possible values |
Bond Tradebook Sheet
Sheet contains table of Bonds trades.
Bond Tradebook Table
Table contains transactional data including scheme, buy & sell value, quantity, expenses, etc...
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | Yes | ISIN is the international security identification number |
| security_name | string | Yes | Symbol or description of bond |
| is_listed | boolean | Yes | is the bond listed in public markets |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp in millis |
| price | number | Yes | The unit price of the bond |
| transaction_type | string | Yes | Indicates whether the order is :buy , sell, send, receive Or trade, |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stamp_duty | number | No | Stamp duty paid on transfer of bonds |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of bonds |
| label | string | No | Refer to label for possible values |
Debenture Sheet
Sheet contains table of Debenture Trades
Debenture Tradebook
Table contains transactional data including scheme, buy & sell value, quantity, expenses, etc...
| Param | Type | Required | Description |
|---|---|---|---|
| trade_id | string | No | Transaction ID of the particular trade |
| isin | string | Yes | ISIN is the international security identification number |
| security_name | string | Yes | Symbol or description of the debenture |
| is_listed | boolean | Yes | is the debenture listed in public markets |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp in millis |
| price | number | Yes | The unit price of the debenture |
| transaction_type | string | Yes | Indicates whether the order is :buy , sell, send, receive Or trade, |
| brokerage | number | No | Brokerage expense |
| clearing_charges | number | No | Charges charged by clearing house |
| exchange_transaction_charges | number | No | Transaction charges by exchange |
| sebi_turnover_fees | number | No | Turnover fees by SEBI |
| stamp_duty | number | No | Stamp duty paid on transfer of bonds |
| sgst | number | No | State GST |
| cgst | number | No | Central GST |
| igst | number | No | Integrated GST |
| other_transfer_expenses | number | No | Any other expense relating to the transfer of bonds |
| label | string | No | Refer to label for possible values |