Trade-wise Equity data of FPI
Note:
1. The format of data displayed is as follows:
| S.No |
Field Name |
Format |
| 1 |
Custodian Code |
Unmasked |
| 2 |
Report Date |
Unmasked |
| 3 |
Transaction ID |
Unmasked |
| 4 |
FPI Registration Number |
Masked |
| 5 |
Sub Account Registration Number |
Masked |
| 6 |
Broker Registration Number |
Masked |
| 7 |
Scrip Name |
Unmasked |
| 8 |
ISIN Code |
Unmasked |
| 9 |
Transaction Date |
Unmasked |
| 10 |
Transaction Type |
Unmasked |
| 11 |
Stock Exchange Code |
Unmasked |
| 12 |
Settled Code |
Unmasked |
| 13 |
Transaction Rate |
Unmasked |
| 14 |
Transaction Quantity |
Unmasked |
| 15 |
Value |
Unmasked |
| 16 |
Instrument Type |
Unmasked |
| 17 |
Reason For Delay In Reporting |
Unmasked
|
| 18 |
Reporting Type |
Unmasked |
| 19 |
Reason For Amendment |
Unmasked |
Fields in the above mentioned format is "Comma"(",") separated. Due care may be taken since Scrip name may include "comma".
2. The codes used for Transactions type are as given below:
| Nature of transaction |
Transaction code |
| Purchase in secondary market |
01 |
| Purchase in primary market (net of refund) |
02 |
| Preferential allotment (net of refund) |
03 |
| Sale in secondary market |
04 |
| Purchase through rights issue (net of refund) |
05 |
| Receipt of equity shares after conversion of debentures (transactions where a debt instrument has been received on surrender of another security may also be reported under this code in the debt report) |
06 |
| Receipt of bonus shares, or shares in a buyback/merger/open offer/ securities in lieu of shares* |
07 |
| Redemption of debentures / units of mutual funds |
08 |
| Acceptance of shares lodged /offered under open offer (accepted quantity) |
09 |
| Repurchase of units by Mutual Fund |
10 |
| Acceptance of shares lodged /offered under buy back offer (accepted quantity) |
11 |
| Payment of allotment / call money |
12 |
| Square off - on account of short delivery received |
13 |
| Square off and auction - on account of short delivery given |
14 |
| Consolidation / Sub-division of securities |
15 |
| Surrendering shares after Merger/Takeover |
16 |
| Write-off of securities |
17 |
| Write-back of securities |
18 |
* this is to indicate any security other than equity share received in respect of dividend, bonus, open offer etc.
3. The settlement codes used are as given below:
(a) REG_DL_STLD_01- Settlement through Clearing House
(b) REG_DL_STLD_02- Hand Delivery settlement not involving Clearing House
(c) REG_DL_STLD_03- Clearing house transactions settled through Hand Delivery due to non-receipt of client confirmation
(d) REG_DL_STLD_04- Other (Public issue, etc.)
4. Value of transactions is in INR.
5. The codes used for the Type of Security/Instrument are as given below:
| Type of Instrument |
Instrument code |
| Equity shares (listed) |
REG_DL_INSTR_EQ |
| Equity Shares (unlisted) |
REG_DL_INSTR_EU |
| Other equity instrument |
REG_DL_INSTR_OE |
| Preference shares |
REG_DL_INSTR_PS |
| Partly convertible debentures (quoted at unit price) |
REG_DL_INSTR_PC |
| Fully convertible debentures (quoted at unit price) |
REG_DL_INSTR_FC |
| Non convertible debentures (quoted at unit price) |
REG_DL_INSTR_NC |
| Corporate / Institutional Debentures or bonds (quoted in units of Rs 100) |
REG_DL_INSTR_BR |
| Warrants |
REG_DL_INSTR_WR |
| Corporate Bonds (quoted at unit price) |
REG_DL_INSTR_CB |
| Secured Premium Notes |
REG_DL_INSTR_SP |
| Floating Rate Notes |
REG_DL_INSTR_FN |
| Mutual Fund Units |
REG_DL_INSTR_MD |
| Government Bonds (quoted in units of Rs 100) |
REG_DL_INSTR_GB |
| Treasury Bills (quoted in units of Rs 100) |
REG_DL_INSTR_TB |
| Commercial Paper (quoted in units of Rs 100) |
REG_DL_INSTR_CP |
| Right renunciations |
REG_DL_INSTR_RR |
| Other debt instrument (Quoted at unit price) |
REG_DL_INSTR_DU |
| Other debt instrument (quoted in units of Rs 100) |
REG_DL_INSTR_DR |
6. The codes used for Reason for delay in reporting are as given below:
(a) REG_DL_DLAY_P - Prompt reporting
(b) REG_DL_DLAY_D - Delay in receipt of contract from broker
(c) REG_DL_DLAY_S - System failure at custodian office
(d) REG_DL_DLAY_O- Other delay reasons
7. The codes used for Reporting Type are as given below:
(a) DL_RPT_TYPE_N- New transaction
(b) DL_RPT_TYPE_A- Amendment in earlier transaction
(c) DL_RPT_TYPE_D- Deletion of earlier reported transaction
8. The codes used for Reason of Amendment are as given below
| DESCRIPTION |
CODE |
| New Transaction |
DL_AMDMNT_DEL_00 |
| Change in quantity of scrip |
DL_AMDMNT_DEL_01 |
| Change in name of scrip transacted |
DL_AMDMNT_DEL_02 |
| Change in price of scrip transacted |
DL_AMDMNT_DEL_03 |
| Change in date of contract |
DL_AMDMNT_DEL_04 |
| Change in name of FPI/sub-accounts (with same custodian) |
DL_AMDMNT_DEL_05 |
| Change in name of FPI/sub-accounts (with different custodian) |
DL_AMDMNT_DEL_06 |
| Sub division of the contract |
DL_AMDMNT_DEL_07 |
| Consolidation of two or more trades |
DL_AMDMNT_DEL_08 |
| Cancellation of trade by broker |
DL_AMDMNT_DEL_09 |
| Cancellation/non acceptance of trade by FPI |
DL_AMDMNT_DEL_10 |
| Two contract notes received for same deal |
DL_AMDMNT_DEL_11 |
| Contract note wrongly delivered by broker to us (pertaining to ***another custodian) |
DL_AMDMNT_DEL_12 |
| Change of stock exchange |
DL_AMDMNT_DEL_13 |
| Change in the ISIN code |
DL_AMDMNT_DEL_14 |
| Change in mode of settlement of trade |
DL_AMDMNT_DEL_15 |
| Multiple amendments in same transaction |
DL_AMDMNT_DEL_16 |
| Others (please submit details) |
DL_AMDMNT_DEL_17 |
9. The Registration Number of Custodians are as given below:
| REGISTRATION NUMBER |
CUSTODIAN NAME |
| 1 |
HDFC BANK LTD |
| 10 |
STATE BANK OF INDIA |
| 11 |
STOCK HOLDING CORPORATION OF INDIA |
| 13 |
THE ROYAL BANK OF SCOTLAND N.V. |
| 14 |
JPMORGAN CHASE BANK |
| 3 |
Deutsche Bank AG |
| 4 |
Citi Bank |
| 5 |
ICICI Bank Limited |
| 6 |
Standard Chartered bank |
| 8 |
IL&FS Securities Services Limited |
| 9 |
The Hongkong and Shanghai Banking Corporation Limited |
| IN/CUS/016 |
DBS Bank Limited |
| IN/CUS/017 |
KOTAK MAHINDRA BANK LIMITED |
| IN/CUS/018 |
The Bank of Nova Scotia |
| IN/CUS/019 |
AXIS BANK LTD |
| IN/CUS/020 |
Orbis Financial Corporation Ltd |
| IN/CUS/022 |
SBI-SG Global Securities Services Pvt. Ltd. |
| IN/CUS/023 |
BNP PARIBAS |
| IN/CUS/024 |
EDELWEISS CUSTODIAL SERVICES LIMITED |
10. The Registration Number of Stock Exchanges are as given below:
| REGISTRATION NUMBER |
EXCHANGE NAME |
| 1 |
BOMBAY STOCK EXCHANGE LIMITED |
| 2 |
AHMEDABAD STOCK EXCHANGE |
| 3 |
CALCUTTA STOCK EXCHANGE |
| 4 |
MADRAS STOCK EXCHANGE |
| 5 |
DELHI STOCK EXCHANGE |
| 6 |
HYDERABAD STOCK EXCHANGE |
| 7 |
MADHYA PRADESH STOCK EXCHANGE |
| 8 |
BANGALORE STOCK EXCHANGE |
| 9 |
COCHIN STOCK EXCHANGE |
| 10 |
UTTAR PRADESH STOCK EXCHANGE |
| 11 |
PUNE STOCK EXCHANGE |
| 12 |
LUDHIANA STOCK EXCHANGE |
| 13 |
GAUHATI STOCK EXCHANGE |
| 14 |
MANGALORE STOCK EXCHANGE |
| 15 |
MAGADH STOCK EXCHANGE |
| 16 |
JAIPUR STOCK EXCHANGE |
| 17 |
BHUBANESWAR STOCK EXCHANGE |
| 18 |
SAURASHTRA KUTCH STOCK EXCHANGE |
| 19 |
VADODARA STOCK EXCHANGE |
| 20 |
OTC EXCHANGE OF INDIA |
| 21 |
COIMBATORE STOCK EXCHANGE |
| 23 |
NATIONAL STOCK EXCHANGE OF INDIA LIMITED |
| 24 |
INTER-CONNECTED STOCK EXCHANGE OF (I) LTD |
| 25 |
CAPITAL STOCK EXCHANGE OF KERALA LTD. |
| 26 |
MCX STOCK EXCHANGE LIMITED |