Client Details Sheet
Client Details List
| Param | Type | Required | Description | |
|---|---|---|---|---|
| name | string | Yes | Name of the client | |
| pan | string | Yes | PAN of the client | |
| client_id | string | Yes | Client ID for the client | |
| country | string | Yes | Country of residence | |
| currency | string | Yes | Currency in which trade was placed |
Stock Sheet
Stock Tradebook Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| trade_id | string | No | Transaction ID of the particular trade |
| symbol | string | Yes | Symbol or description of equity stock |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | The unit price of the equity share |
| transaction_type | string | Yes | Indicates whether the order is : \nbuy Or sell, |
| transfer_expenses | number | Yes | Any 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 : \ndelivery , intraday |
Reference Data Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of equity share |
| address | string | No | Address of the company |
| country | string | Yes | Country of the company |
| zip_code | string | Yes | Zip code of the address |
| 52_week_high | number | Yes | 52 week high price for the symbol for the FY |
| closing_value | number | Yes | closing value for the symbol |
Dividend Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of equity share |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| dividend_amount | number | Yes | Dividend amount received |
| tax_withheld | number | Yes | TDS amount deducted on the dividend |
DR Sheet
DR Tradebook Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| trade_id | string | No | Transaction ID of the particular trade |
| symbol | string | Yes | Symbol or description of ADR |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | The unit price of the ADR |
| transaction_type | string | Yes | Indicates whether the order is : \nbuy Or sell, |
| transfer_expenses | number | Yes | Any expense relating to the transfer of ADR |
| label | string | No | Refer to label for possible values |
| product_type | string | Yes | Indicates whether the order is : \ndelivery , intraday |
Reference Data Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of adr |
| address | string | No | Address of the company |
| country | string | Yes | Country of the company |
| zip_code | string | Yes | Zip code of the address |
| 52_week_high | number | Yes | 52 week high price for the symbol for the FY |
| closing_value | number | Yes | closing value for the symbol |
Dividend Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of adr |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| dividend_amount | number | Yes | Dividend amount received |
| tax_withheld | number | Yes | TDS amount deducted on the dividend |
Mutual Fund Sheet
Mutual Fund Tradebook Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| trade_id | string | No | Transaction ID of the particular trade |
| scheme_name | string | Yes | Scheme name of the mutual fund |
| scheme_type | string | Yes | Scheme type, possible values \nequity, debt, other |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | The unit price of the mutual fund |
| transaction_type | string | Yes | Indicates whether the order is : \nbuy Or sell, |
| transfer_expenses | number | Yes | Any expense relating to the transfer of Mutual funds |
| label | string | No | Refer to label for possible values |
Reference Data Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of fund |
| address | string | No | Address of the company |
| country | string | Yes | Country of the company |
| zip_code | string | Yes | Zip code of the address |
| 52_week_high | number | Yes | 52 week high price for the symbol for the FY |
| closing_value | number | Yes | closing value for the symbol |
Dividend Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of fund |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| dividend_amount | number | Yes | Dividend amount received |
| tax_withheld | number | Yes | TDS amount deducted on the dividend |
ETF Sheet
ETF Tradebook Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| trade_id | string | No | Transaction ID of the particular trade |
| scheme_name | string | Yes | Scheme name of the mutual fund |
| scheme_type | string | Yes | Scheme type, possible values \nequity, debt, other |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| price | number | Yes | The unit price of the mutual fund |
| transaction_type | string | Yes | Indicates whether the order is : \nbuy Or sell, |
| transfer_expenses | number | Yes | Any expense relating to the transfer of Mutual funds |
| label | string | No | Refer to label for possible values |
| product_type | string | Yes | Indicates whether the order is : \ndelivery , intraday |
Reference Data Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of fund |
| address | string | No | Address of the company |
| country | string | Yes | Country of the company |
| zip_code | string | Yes | Zip code of the address |
| 52_week_high | number | Yes | 52 week high price for the symbol for the FY |
| closing_value | number | Yes | closing value for the symbol |
Dividend Table
| Param | Type | Required | Description |
|---|---|---|---|
| isin | string | No | ISIN is the international security identification number |
| symbol | string | Yes | Symbol or description of fund |
| quantity | number | Yes | Trading quantity |
| date | number | Yes | Transaction epoch timestamp |
| dividend_amount | number | Yes | Dividend amount received |
| tax_withheld | number | Yes | TDS amount deducted on the dividend |
Interest Income Sheet
Interest Income Table
| Param | Type | Required | Description |
|---|---|---|---|
| description | string | No | Description of interest credit |
| date | number | Yes | Transaction ID of the particular entry |
| amount | number | Yes | Interest amount received |
| amount_inr | number | No | Interest in INR |
| tax_withheld | number | Yes | TDS amount deducted on the interest |
| tax_withheld_inr | number | No | TDS in INR |