FII EQUITY TRADES (2017)
FII EQUITY TRADES (2016)
FII EQUITY TRADES (2015)
FII EQUITY TRADES (2014)
FII EQUITY TRADES (2013)
FII EQUITY TRADES (2012)
FII EQUITY TRADES (2011)
FII EQUITY TRADES (2010)
FII EQUITY TRADES (2009)
FII EQUITY TRADES (2008)
FII EQUITY TRADES (2007)
FII EQUITY TRADES (2006)
FII EQUITY TRADES (2005)
FII EQUITY TRADES (2004)
FII EQUITY TRADES (2003)

Note:

1. The format of data displayed is as follows:

Sr.No Field Name New Format Old Format
1 Custodian Code Unmasked Masked
2 Report Date Unmasked Unmasked
3 Transaction ID Unmasked Unmasked
4 FII Registration Number Masked Masked
5 Sub Account Registration Number Masked Masked
6 Broker Registration Number Masked Masked
7 Scrip Name Unmasked Unmasked
8 ISIN Code Unmasked Unmasked
9 Transaction Date Unmasked Unmasked
10 Transaction Type Unmasked Unmasked
11 Stock Exchange Code Unmasked Masked
12 Settled Code Unmasked Unmasked
13 Transaction Rate Unmasked Unmasked
14 Transaction Quantity Unmasked Unmasked
15 Value Unmasked Unmasked
16 Instrument Type Unmasked Unmasked
17 Reason For Delay In Reporting Unmasked Unmasked
18 Reporting Type Unmasked Unmasked
19 Reason For Amendment Unmasked 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:

Sr.No. Nature of transaction Transaction code
1 Purchase in secondary market 01
2 Purchase in primary market (net of refund) 02
3 Preferential allotment (net of refund) 03
4 Sale in secondary market 04
5 Purchase through rights issue (net of refund) 05
6 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
7 Receipt of bonus shares, or shares in a buyback/merger/open offer/ securities in lieu of shares* 07
8 Redemption of debentures / units of mutual funds 08
9 Acceptance of shares lodged /offered under open offer (accepted quantity) 09
10 Repurchase of units by Mutual Fund 10
11 Acceptance of shares lodged /offered under buy back offer (accepted quantity) 11
12 Payment of allotment / call money 12
13 Square off - on account of short delivery received 13
14 Square off and auction - on account of short delivery given 14
15 Consolidation / Sub-division of securities 15
16 Surrendering shares after Merger/Takeover 16
17 Write-off of securities 17
18 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:

Sr.No. Description Settlement Codes
1 Settlement through Clearing House REG_DL_STLD_01
2 Hand Delivery settlement not involving Clearing House REG_DL_STLD_02
3 Clearing house transactions settled through Hand Delivery due to non-receipt of client confirmation REG_DL_STLD_03
4 Other (Public issue, etc.) REG_DL_STLD_04

4. Value of transactions is in INR.

5. The codes used for the Type of Security/Instrument are as given below:

Sr.No. Type of Instrument Instrument code
1 Equity shares (listed) REG_DL_INSTR_EQ
2 Equity Shares (unlisted) REG_DL_INSTR_EU
3 Other equity instrument REG_DL_INSTR_OE
4 Preference shares REG_DL_INSTR_PS
5 Partly convertible debentures (quoted at unit price) REG_DL_INSTR_PC
6 Fully convertible debentures (quoted at unit price) REG_DL_INSTR_FC
7 Non convertible debentures (quoted at unit price) REG_DL_INSTR_NC
8 Corporate / Institutional Debentures or bonds (quoted in units of Rs 100) REG_DL_INSTR_BR
8 Warrants REG_DL_INSTR_WR
10 Corporate Bonds (quoted at unit price) REG_DL_INSTR_CB
11 Secured Premium Notes REG_DL_INSTR_SP
12 Floating Rate Notes REG_DL_INSTR_FN
13 Mutual Fund Units REG_DL_INSTR_MD
14 Government Bonds (quoted in units of Rs 100) REG_DL_INSTR_GB
15 Treasury Bills (quoted in units of Rs 100) REG_DL_INSTR_TB
16 Commercial Paper (quoted in units of Rs 100) REG_DL_INSTR_CP
17 Right renunciations REG_DL_INSTR_RR
18 Other debt instrument (Quoted at unit price) REG_DL_INSTR_DU
19 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:

Sr.No. Description Settlement Codes
1 Prompt reporting REG_DL_DLAY_P
2 Delay in receipt of contract from broker REG_DL_DLAY_D
3 System failure at custodian office REG_DL_DLAY_S
4 Other delay reasons REG_DL_DLAY_O


7. The codes used for Reporting Type are as given below:

Sr.No. Description Settlement Codes
1 New transaction DL_RPT_TYPE_N
2 Amendment in earlier transaction DL_RPT_TYPE_A
3 Deletion of earlier reported transaction DL_RPT_TYPE_D


8. The codes used for Reason of Amendment are as given below:

Sr.No. DESCRIPTION CODE
1 New Transaction DL_AMDMNT_DEL_00
2 Change in quantity of scrip DL_AMDMNT_DEL_01
3 Change in name of scrip transacted DL_AMDMNT_DEL_02
4 Change in price of scrip transacted DL_AMDMNT_DEL_03
5 Change in date of contract DL_AMDMNT_DEL_04
6 Change in name of FII/sub-accounts (with same custodian) DL_AMDMNT_DEL_05
7 Change in name of FII/sub-accounts (with different custodian) DL_AMDMNT_DEL_06
8 Sub division of the contract DL_AMDMNT_DEL_07
9 Consolidation of two or more trades DL_AMDMNT_DEL_08
10 Cancellation of trade by broker DL_AMDMNT_DEL_09
11 Cancellation/non acceptance of trade by FII DL_AMDMNT_DEL_10
12 Two contract notes received for same deal DL_AMDMNT_DEL_11
13 Contract note wrongly delivered by broker to us (pertaining to ***another custodian) DL_AMDMNT_DEL_12
14 Change of stock exchange DL_AMDMNT_DEL_13
15 Change in the ISIN code DL_AMDMNT_DEL_14
16 Change in mode of settlement of trade DL_AMDMNT_DEL_15
17 Multiple amendments in same transaction DL_AMDMNT_DEL_16
18 Others (please submit details) DL_AMDMNT_DEL_17

9. The Registration Number of Custodians are as given below:

Sr.No. REGISTRATION NUMBER CUSTODIAN NAME
1 1 HDFC BANK LTD
2 10 STATE BANK OF INDIA
3 11 STOCK HOLDING CORPORATION OF INDIA
4 13 THE ROYAL BANK OF SCOTLAND N.V.
5 14 JPMORGAN CHASE BANK
6 3 Deutsche Bank AG
7 4 Citi Bank
8 5 ICICI Bank Limited
9 6 Standard Chartered bank
10 8 IL&FS Securities Services Limited
11 9 The Hongkong and Shanghai Banking Corporation Limited
12 IN/CUS/016 DBS Bank Limited
13 IN/CUS/017 KOTAK MAHINDRA BANK LIMITED
14 IN/CUS/018 The Bank of Nova Scotia
15 IN/CUS/019 AXIS BANK LTD
16 IN/CUS/020 Orbis Financial Corporation Ltd
17 IN/CUS/022 SBI-SG Global Securities Services Pvt. Ltd.
18 IN/CUS/023 BNP PARIBAS
19 IN/CUS/024 EDELWEISS CUSTODIAL SERVICES LIMITED

10. The Registration Number of Stock Exchanges are as given below:

Sr.No. REGISTRATION NUMBER EXCHANGE NAME
1 1 BOMBAY STOCK EXCHANGE LIMITED
2 2 AHMEDABAD STOCK EXCHANGE
3 3 CALCUTTA STOCK EXCHANGE
4 4 MADRAS STOCK EXCHANGE
5 5 DELHI STOCK EXCHANGE
6 6 HYDERABAD STOCK EXCHANGE
7 7 MADHYA PRADESH STOCK EXCHANGE
8 8 BANGALORE STOCK EXCHANGE
9 9 COCHIN STOCK EXCHANGE
10 10 UTTAR PRADESH STOCK EXCHANGE
11 11 PUNE STOCK EXCHANGE
12 12 LUDHIANA STOCK EXCHANGE
13 13 GAUHATI STOCK EXCHANGE
14 14 MANGALORE STOCK EXCHANGE
15 15 MAGADH STOCK EXCHANGE
16 16 JAIPUR STOCK EXCHANGE
17 17 BHUBANESWAR STOCK EXCHANGE
18 18 SAURASHTRA KUTCH STOCK EXCHANGE
19 19 VADODARA STOCK EXCHANGE
20 20 OTC EXCHANGE OF INDIA
21 21 COIMBATORE STOCK EXCHANGE
22 23 NATIONAL STOCK EXCHANGE OF INDIA LIMITED
23 24 INTER-CONNECTED STOCK EXCHANGE OF (I) LTD
24 25 CAPITAL STOCK EXCHANGE OF KERALA LTD.
25 26 MCX STOCK EXCHANGE LIMITED