> ## Documentation Index
> Fetch the complete documentation index at: https://developer.sandbox.co.in/llms.txt
> Use this file to discover all available pages before exploring further.

# Tradewise Settlements

## Client Details Sheet

### Client Details List

| Param | Type | Required | Description |
| :- | :- | :- | :- |
| name | `string` | Yes | \[cite\_start]Name of the client \[cite: 276] |
| pan | `string` | Yes | \[cite\_start]PAN of the client \[cite: 278] |
| client\_id | `string` | Yes | \[cite\_start]Client ID for the client \[cite: 280] |
| country | `string` | Yes | \[cite\_start]Country where investments were made \[cite: 282] |
| tin | `string` | Yes | \[cite\_start]TIN for the country or passport number \[cite: 284] |
| currency | `string` | Yes | \[cite\_start]The 3 letter currency code for the price based on ISO 421 \[cite: 286] |

***

## Stock Sheet

### Reference Data Table

| Param | Type | Required | Description |
| :- | :- | :- | :- |
| isin | `string` | No | \[cite\_start]ISIN is the international security identification number \[cite: 291] |
| symbol | `string` | Yes | \[cite\_start]Symbol or description of fund \[cite: 293] |
| address | `string` | No | \[cite\_start]Address of the company \[cite: 295] |
| country | `string` | Yes | \[cite\_start]Country of the company \[cite: 297] |
| zip\_code | `string` | Yes | \[cite\_start]Zip code of the address \[cite: 299] |
| 52\_week\_high | `number` | Yes | \[cite\_start]52 week high price for the symbol for the FY \[cite: 301] |
| closing\_value | `number` | \[cite\_start]Yes | closing value for the symbol \[cite: 303] |

### Dividend Table

| Param | Type | Required | Description |
| :- | :- | :- | :- |
| isin | `string` | No | \[cite\_start]ISIN is the international security identification number \[cite: 308] |
| symbol | `string` | Yes | \[cite\_start]Symbol or description of equity share \[cite: 310] |
| quantity | `number` | Yes | \[cite\_start]Trading quantity \[cite: 312] |
| date | `number` | Yes | \[cite\_start]Transaction epoch timestamp \[cite: 314] |
| dividend\_amount | `number` | Yes | \[cite\_start]Dividend amount received \[cite: 316] |
| currency | `string` | Yes | \[cite\_start]The 3 letter currency code for the price based on ISO 4217 \[cite: 318] |
| tax\_withheld | `number` | Yes | \[cite\_start]TDS amount deducted on the dividend \[cite: 319] |

### Stock Tradewise Holding Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| symbol | `string` | Symbol or description of equity share |
| quantity | `number` | Trading quantity |
| buy\_date | `number` | \[cite\_start]The date on which the equity share was bought \[cite: 321] |
| buy\_price | `number` | Price at which a unit was bought |
| currency | `string` | The 3 letter currency code for the price based on ISO 421 |
| transaction\_type | `string` | Indicates whether the order is : \n`buy` , `sell`, `send`, `receive` Or `trade`, |
| label | `string` | Refer to [label](/api-reference/it/calculator/tax_pnl/securities/domestic/annexures/labels) for possible values |
| last\_traded\_price | `string` | \[cite\_start]Last traded market price of the equity share. \[cite: 323] |

### Stock Tradewise Open Sell Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| symbol | `string` | Total value of the all the transactions |
| quantity | `number` | \[cite\_start]The realized profit or loss on the trade without considering transfer expenses \[cite: 324] |
| sell\_date | `number` | The date on which the equity share was sold |
| sell\_price | `number` | Price at which a unit was sold |
| currency | `string` | The 3 letter currency code for the price based on ISO 421 |
| transaction\_type | `string` | \[cite\_start]Indicates whether the order is : \n`buy` , `sell`, `send`, `receive` Or `trade`, \[cite: 325] |
| label | `string` | Refer to [label](/api-reference/it/calculator/tax_pnl/securities/domestic/annexures/labels) for possible values |
| last\_traded\_price | `number` | \[cite\_start]Last traded market price of the equity share. \[cite: 326] |

### Stock Tradewise Settlement Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| symbol | `string` | Symbol or description of equity share |
| quantity | `number` | \[cite\_start]Trading quantity \[cite: 327] |
| buy\_trade\_id | `string` | Transaction ID of the buy transaction |
| buy\_date | `number` | The date on which the equity share was bought |
| buy\_price | `number` | Price at which a unit was bought |
| sell\_trade\_id | `string` | Transaction ID of the sell transaction |
| sell\_date | `number` | \[cite\_start]The date on which the equity share was sold \[cite: 328] |
| sell\_price | `number` | Price at which a unit was sold |
| currency | `string` | The 3 letter currency code for the price based on ISO 421 |
| transfer\_expenses | `number` | expense relating to the transfer of shares |
| nature\_of\_settlement | `string` | The nature of the settlement of transaction |
| product\_type | `string` | \[cite\_start]Indicates whether the order is : \n`delivery` , `intraday` \[cite: 329] |

### Stock Tradewise Transfer Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | \[cite\_start]ISIN is the international security identification number \[cite: 333] |
| symbol | `string` | \[cite\_start]Symbol or description of equity share \[cite: 335] |
| quantity | `number` | \[cite\_start]Trading quantity \[cite: 337] |
| transfer\_date | \[cite\_start]`number` | date of transfer \[cite: 339] |
| price | \[cite\_start]`number` | price at which the asset was transferred \[cite: 341] |
| currency | `string` | \[cite\_start]The 3 letter currency code for the price based on ISO 421 \[cite: 343] |
| transfer\_type | \[cite\_start]`number` | expense relating to the transfer of shares \[cite: 344] |
| nature\_of\_transfer | `string` | \[cite\_start]The nature of the settlement of transaction \[cite: 345] |
| transfer\_value | \[cite\_start]`number` | total value of transfers made \[cite: 346] |
| transfer\_expense | \[cite\_start]`number` | expenses incurred while transferring the asset. \[cite: 347] |

***

## DR Sheet

### Reference Data Table

| Param | Type | Required | Description |
| :- | :- | :- | :- |
| isin | `string` | No | \[cite\_start]ISIN is the international security identification number \[cite: 352] |
| symbol | `string` | Yes | \[cite\_start]Symbol or description of fund \[cite: 354] |
| address | `string` | No | \[cite\_start]Address of the company \[cite: 356] |
| country | `string` | Yes | \[cite\_start]Country of the company \[cite: 358] |
| zip\_code | `string` | Yes | \[cite\_start]Zip code of the address \[cite: 360] |
| 52\_week\_high | `number` | Yes | \[cite\_start]52 week high price for the symbol for the FY \[cite: 362] |
| closing\_value | `number` | \[cite\_start]Yes | closing value for the symbol \[cite: 364] |

### Dividend Table

| Param | Type | Required | Description |
| :- | :- | :- | :- |
| isin | `string` | No | \[cite\_start]ISIN is the international security identification number \[cite: 368] |
| symbol | `string` | Yes | \[cite\_start]Symbol or description of equity share \[cite: 371] |
| quantity | `number` | Yes | \[cite\_start]Trading quantity \[cite: 373] |
| date | `number` | Yes | \[cite\_start]Transaction epoch timestamp \[cite: 375] |
| dividend\_amount | `number` | Yes | \[cite\_start]Dividend amount received \[cite: 377] |
| currency | `string` | Yes | \[cite\_start]The 3 letter currency code for the price based on ISO 4217 \[cite: 379] |
| tax\_withheld | `number` | Yes | \[cite\_start]TDS amount deducted on the dividend \[cite: 380] |

### DR Tradewise Holding Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| symbol | `string` | Symbol or description of equity share |
| quantity | `number` | Trading quantity |
| buy\_date | `number` | \[cite\_start]The date on which the equity share was bought \[cite: 382] |
| buy\_price | `number` | Price at which a unit was bought |
| currency | `string` | The 3 letter currency code for the price based on ISO 421 |
| transaction\_type | `string` | Indicates whether the order is : \n`buy` , `sell`, `send`, `receive` Or `trade`, |
| label | `string` | Refer to [label](/api-reference/it/calculator/tax_pnl/securities/domestic/annexures/labels) for possible values |
| last\_traded\_price | `string` | \[cite\_start]Last traded market price of the equity share. \[cite: 384] |

### DR Tradewise Open Sell Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| symbol | `string` | Total value of the all the transactions |
| quantity | `number` | \[cite\_start]The realized profit or loss on the trade without considering transfer expenses \[cite: 385] |
| sell\_date | `number` | The date on which the equity share was sold |
| sell\_price | `number` | Price at which a unit was sold |
| currency | `string` | The 3 letter currency code for the price based on ISO 421 |
| transaction\_type | `string` | \[cite\_start]Indicates whether the order is : \n`buy` , `sell`, `send`, `receive` Or `trade`, \[cite: 386] |
| label | `string` | Refer to [label](/api-reference/it/calculator/tax_pnl/securities/domestic/annexures/labels) for possible values |
| last\_traded\_price | `number` | \[cite\_start]Last traded market price of the equity share. \[cite: 387] |

### DR Tradewise Settlement Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| symbol | `string` | Symbol or description of equity share |
| quantity | `number` | \[cite\_start]Trading quantity \[cite: 388] |
| buy\_trade\_id | `string` | Transaction ID of the buy transaction |
| buy\_date | `number` | The date on which the equity share was bought |
| buy\_price | `number` | Price at which a unit was bought |
| sell\_trade\_id | `string` | Transaction ID of the sell transaction |
| sell\_date | `number` | \[cite\_start]The date on which the equity share was sold \[cite: 389] |
| sell\_price | `number` | Price at which a unit was sold |
| currency | `string` | The 3 letter currency code for the price based on ISO 421 |
| transfer\_expenses | `number` | expense relating to the transfer of shares |
| nature\_of\_settlement | `string` | The nature of the settlement of transaction |
| product\_type | `string` | \[cite\_start]Indicates whether the order is : \n`delivery` , `intraday` \[cite: 390] |

### DR Tradewise Transfer Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | \[cite\_start]ISIN is the international security identification number \[cite: 394] |
| symbol | `string` | \[cite\_start]Symbol or description of equity share \[cite: 396] |
| quantity | `number` | \[cite\_start]Trading quantity \[cite: 398] |
| transfer\_date | \[cite\_start]`number` | date of transfer \[cite: 400] |
| price | \[cite\_start]`number` | price at which the asset was transferred \[cite: 402] |
| currency | `string` | \[cite\_start]The 3 letter currency code for the price based on ISO 421 \[cite: 404] |
| transfer\_type | \[cite\_start]`number` | expense relating to the transfer of shares \[cite: 405] |
| nature\_of\_transfer | `string` | \[cite\_start]The nature of the settlement of transaction \[cite: 406] |
| transfer\_value | \[cite\_start]`number` | total value of transfers made \[cite: 407] |
| transfer\_expense | \[cite\_start]`number` | expenses incurred while transferring the asset. \[cite: 408] |

***

## Mutual Fund Sheet

### Reference Data Table

| Param | Type | Required | Description |
| :- | :- | :- | :- |
| isin | `string` | No | \[cite\_start]ISIN is the international security identification number \[cite: 413] |
| scheme\_name | `string` | Yes | \[cite\_start]Symbol or description of fund \[cite: 415] |
| address | `string` | No | \[cite\_start]Address of the company \[cite: 417] |
| country | `string` | Yes | \[cite\_start]Country of the company \[cite: 419] |
| zip\_code | `string` | Yes | \[cite\_start]Zip code of the address \[cite: 421] |
| 52\_week\_high | `number` | Yes | \[cite\_start]52 week high price for the symbol for the FY \[cite: 423] |
| closing\_value | `number` | \[cite\_start]Yes | closing value for the symbol \[cite: 425] |

### Dividend Table

| Param | Type | Required | Description |
| :- | :- | :- | :- |
| isin | `string` | No | \[cite\_start]ISIN is the international security identification number \[cite: 430] |
| scheme\_name | `string` | Yes | \[cite\_start]Symbol or description of fund \[cite: 432] |
| quantity | `number` | Yes | \[cite\_start]Trading quantity \[cite: 434] |
| date | `number` | Yes | \[cite\_start]Transaction epoch timestamp \[cite: 436] |
| dividend\_amount | `number` | Yes | \[cite\_start]Dividend amount received \[cite: 438] |
| currency | `string` | Yes | \[cite\_start]The 3 letter currency code for the price based on ISO 4217 \[cite: 440] |
| tax\_withheld | `number` | Yes | \[cite\_start]TDS amount deducted on the dividend \[cite: 441] |

### Mutual Fund Tradewise Holding Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| scheme\_name | `string` | Symbol or description of fund |
| quantity | `number` | Trading quantity |
| buy\_date | `number` | \[cite\_start]The date on which the fund was bought \[cite: 443] |
| buy\_price | `number` | Price at which a unit was bought |
| currency | `string` | The 3 letter currency code for the price based on ISO 421 |
| transaction\_type | `string` | Indicates whether the order is : \n`buy` , `sell`, `send`, `receive` Or `trade`, |
| label | `string` | Refer to [label](/api-reference/it/calculator/tax_pnl/securities/domestic/annexures/labels) for possible values |
| last\_traded\_price | `string` | \[cite\_start]Last traded market price of the equity share. \[cite: 445] |

### Mutual Fund Tradewise Open Sell Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| scheme\_name | `string` | Symbol or description of fund |
| quantity | `number` | \[cite\_start]Trading quantity \[cite: 446] |
| sell\_date | `number` | The date on which the fund was sold |
| sell\_price | `number` | Price at which a unit was sold |
| currency | `string` | The 3 letter currency code for the price based on ISO 421 |
| transaction\_type | `string` | \[cite\_start]Indicates whether the order is : \n`buy` , `sell`, `send`, `receive` Or `trade`, \[cite: 447] |
| label | `string` | Refer to [label](/api-reference/it/calculator/tax_pnl/securities/domestic/annexures/labels) for possible values |
| last\_traded\_price | `number` | \[cite\_start]Last traded market price of the equity share. \[cite: 448] |

### Mutual Fund Tradewise Settlement Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| scheme\_name | `string` | name of the fund |
| asset\_class | `string` | \[cite\_start]Fund's asset class, possible values: \n`equity`, `debt`, `other` \[cite: 449] |
| quantity | `number` | Trading quantity |
| buy\_trade\_id | `string` | Transaction ID of the buy transaction |
| buy\_date | `number` | The date on which the fund was bought |
| buy\_price | `number` | Price at which a unit was bought |
| sell\_trade\_id | `string` | \[cite\_start]Transaction ID of the sell transaction \[cite: 450] |
| sell\_date | `number` | The date on which the fund was sold |
| sell\_price | `number` | Price at which a unit was sold |
| currency | `string` | The 3 letter currency code for the price based on ISO 421 |
| transfer\_expenses | `number` | expense relating to the transfer of shares |
| nature\_of\_settlement | `string` | \[cite\_start]The nature of the settlement of transaction \[cite: 451] |

### Mutual Fund Tradewise Transfer Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | \[cite\_start]ISIN is the international security identification number \[cite: 455] |
| scheme\_name | `string` | \[cite\_start]Symbol or description of equity share \[cite: 457] |
| quantity | `number` | \[cite\_start]Trading quantity \[cite: 459] |
| transfer\_date | \[cite\_start]`number` | date of transfer \[cite: 461] |
| price | \[cite\_start]`number` | price at which the asset was transferred \[cite: 463] |
| currency | `string` | \[cite\_start]The 3 letter currency code for the price based on ISO 421 \[cite: 465] |
| transfer\_type | \[cite\_start]`number` | expense relating to the transfer of shares \[cite: 466] |
| nature\_of\_transfer | `string` | \[cite\_start]The nature of the settlement of transaction \[cite: 467] |
| transfer\_value | \[cite\_start]`number` | total value of transfers made \[cite: 468] |
| transfer\_expense | \[cite\_start]`number` | expenses incurred while transferring the asset. \[cite: 469] |

***

## ETF Sheet

### Reference Data Table

| Param | Type | Required | Description |
| :- | :- | :- | :- |
| isin | `string` | No | \[cite\_start]ISIN is the international security identification number \[cite: 474] |
| scheme\_name | `string` | Yes | \[cite\_start]Symbol or description of fund \[cite: 476] |
| address | `string` | No | \[cite\_start]Address of the company \[cite: 478] |
| country | `string` | Yes | \[cite\_start]Country of the company \[cite: 480] |
| zip\_code | `string` | Yes | \[cite\_start]Zip code of the address \[cite: 482] |
| 52\_week\_high | `number` | Yes | \[cite\_start]52 week high price for the symbol for the FY \[cite: 484] |
| closing\_value | `number` | \[cite\_start]Yes | closing value for the symbol \[cite: 486] |

### Dividend Table

| Param | Type | Required | Description |
| :- | :- | :- | :- |
| isin | `string` | No | \[cite\_start]ISIN is the international security identification number \[cite: 491] |
| scheme\_name | `string` | Yes | \[cite\_start]Symbol or description of fund \[cite: 493] |
| quantity | `number` | Yes | \[cite\_start]Trading quantity \[cite: 495] |
| date | `number` | Yes | \[cite\_start]Transaction epoch timestamp \[cite: 497] |
| dividend\_amount | `number` | Yes | \[cite\_start]Dividend amount received \[cite: 499] |
| currency | `string` | Yes | \[cite\_start]The 3 letter currency code for the price based on ISO 4217 \[cite: 501] |
| tax\_withheld | `number` | Yes | \[cite\_start]TDS amount deducted on the dividend \[cite: 502] |

### ETF Tradewise Holding Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| scheme\_name | `string` | Symbol or description of fund |
| quantity | `number` | Trading quantity |
| buy\_date | `number` | \[cite\_start]The date on which the fund was bought \[cite: 504] |
| buy\_price | `number` | Price at which a unit was bought |
| transaction\_type | `string` | Indicates whether the order is : \n`buy` , `sell`, `send`, `receive` Or `trade`, |
| label | `string` | Refer to [label](/api-reference/it/calculator/tax_pnl/securities/domestic/annexures/labels) for possible values |
| last\_traded\_price | `string` | \[cite\_start]Last traded market price of the equity share. \[cite: 505] |

### ETF Tradewise Open Sell Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| scheme\_name | `string` | Symbol or description of fund |
| quantity | `number` | \[cite\_start]Trading quantity \[cite: 506] |
| sell\_date | `number` | The date on which the fund was sold |
| sell\_price | `number` | Price at which a unit was sold |
| transaction\_type | `string` | Indicates whether the order is : \n`buy` , `sell`, `send`, `receive` Or `trade`, |
| label | `string` | Refer to [label](/api-reference/it/calculator/tax_pnl/securities/domestic/annexures/labels) for possible values |
| last\_traded\_price | `number` | \[cite\_start]Last traded market price of the equity share. \[cite: 508] |

### ETF Tradewise Settlement Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | ISIN is the international security identification number |
| symbol | `string` | Symbol or description of equity share |
| quantity | `number` | \[cite\_start]Trading quantity \[cite: 509] |
| buy\_trade\_id | `string` | Transaction ID of the buy transaction |
| buy\_date | `number` | The date on which the equity share was bought |
| buy\_price | `number` | Price at which a unit was bought |
| sell\_trade\_id | `string` | Transaction ID of the sell transaction |
| sell\_date | `number` | \[cite\_start]The date on which the equity share was sold \[cite: 510] |
| sell\_price | `number` | Price at which a unit was sold |
| transfer\_expenses | `number` | expense relating to the transfer of shares |
| nature\_of\_settlement | `string` | The nature of the settlement of transaction |
| product\_type | `string` | Indicates whether the order is : \n`delivery` , `intraday` |

### ETF Tradewise Transfer Table

| Param | Type | Description |
| :- | :- | :- |
| isin | `string` | \[cite\_start]ISIN is the international security identification number \[cite: 515] |
| scheme\_name | `string` | \[cite\_start]Symbol or description of equity share \[cite: 517] |
| quantity | `number` | \[cite\_start]Trading quantity \[cite: 519] |
| transfer\_date | \[cite\_start]`number` | date of transfer \[cite: 521] |
| price | \[cite\_start]`number` | price at which the asset was transferred \[cite: 523] |
| currency | `string` | \[cite\_start]The 3 letter currency code for the price based on ISO 421 \[cite: 525] |
| transfer\_type | \[cite\_start]`number` | expense relating to the transfer of shares \[cite: 526] |
| nature\_of\_transfer | `string` | \[cite\_start]The nature of the settlement of transaction \[cite: 527] |
| transfer\_value | \[cite\_start]`number` | total value of transfers made \[cite: 528] |
| transfer\_expense | \[cite\_start]`number` | expenses incurred while transferring the asset. \[cite: 529] |

***

## Interest Income Sheet

### Interest Table

| Param | Type | Required | Description |
| :- | :- | :- | :- |
| description | `string` | No | \[cite\_start]Description of interest credit \[cite: 533] |
| date | `number` | Yes | \[cite\_start]Transaction ID of the particular entry \[cite: 535] |
| amount | `number` | Yes | \[cite\_start]Interest amount received \[cite: 537] |
| amount\_inr | `number` | No | \[cite\_start]Interest in INR \[cite: 539] |
| currency | `string` | Yes | \[cite\_start]The 3 letter currency code for the price based on ISO 4217 \[cite: 541] |
| tax\_withheld | `number` | Yes | \[cite\_start]TDS amount deducted on the interest \[cite: 542] |
| tax\_withheld\_inr | `number` | No | \[cite\_start]TDS in INR \[cite: 544] |

***

Would you like me to focus on a specific sheet or table for further clarification or transformation?


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.