FPI DEBT TRADES (AUGUST 2002 TO December 2024)

• 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