FII DEBT TRADES (AUGUST 2002 TO MARCH 2017)

Note:
  • Format of data is as follows:-
    S.No., Transaction Date, ISIN, Scrip Name, Transaction (Trade) Type(**), Quantity, Rate, Value(INR).
  • Fields in the above mentioned format is "Comma"(",") separated. Due care may be taken since Scrip name may include "comma".
  • The first record of any data file is the header as given below:-
    "TR_DT, ISIN, SCRIP_NAME, TR_TYPE(**), QUANTITY, RATE, VALUE(INR)".
  • Tr_Type(**) is described as follows:-
    Trade Type Description
    1 Purchase in secondary market
    2 Purchase in primary market (net of refund)
    3 Preferential allotment (net of refund)
    4 Sale in secondary market
    5 Purchase through rights issue (net of refund)
    6 Conversion of debentures into equity shares
    7 Receipt of bonus shares
    8 Redemption of debentures / units of mutual funds
    9 Lodging shares in terms of open offer
    10 Repurchase of units by Mutual Fund
    11 Buyback of shares by company
    12 Payment of allotment / call money
    13 Square off - on account of short delivery received
    14 Square off and auction - on account of short delivery given
    15 Consolidation/Sub Division of securities
    16 Surrendering of shares after merger / takeover
    17 Write-off of securities
    18 Write-back of securities


  • 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

  • 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