Scrip Master
PURPOSE
The scrip master URL can be used to fetch the scrip details of all the equity, derivates and commodities for NSE, BSE, MCX and NCDEX. The details are fetched in the form of CSV dump which can be imported to a database. Scrip master is updated regularly and can be accessed through the URL mentioned below.
Scrip Master URL
http://content.indiainfoline.com/IIFLTT/Scripmaster.csvCSV COLUMNS
| Column Header | Description | Data Type |
|---|---|---|
| Exch | It contains the exchange like N : NSE B : BSE M : MCX (ExchType will be D) N : NCDEX (only if exchtype is 'X') |
String |
| ExchType | It contains segments like C : Equity D : Derivative (F&O) (But if Exch is M then Commodity) U : Currency Derivative X : NCDEX Commodity Y : Commodity (NSE OR BSE) |
String |
| ScripCode | Unique number for particular segment | Integer |
| Name | Contract Name: It is the symbol but in case of F&O it is the combination of Symbol, Expiry, OptionType, StrikePrice | String |
| Series | It contain the series of equity symbol like BE, EQ etc. (for equity only) |
String |
| Expiry | Contains expiry of F&O contract (ignore in case equity) |
Integer |
| CpType | Option type like CE : Call PE : PUT |
String |
| StrikeRate | Strike rate of F&O contracts | Integer |
| ISIN | ISIN of stock (valid for equity only) |
String |