National Stock Exchange : Time Series

Context

The National Stock Exchange of India Ltd. (NSE) is an Indian stock exchange located at Mumbai, Maharashtra, India. National Stock Exchange (NSE) was established in 1992 as a demutualized electronic exchange. It was promoted by leading financial institutions on request of the Government of India. It is India’s largest exchange by turnover. In 1994, it launched electronic screen-based trading. Thereafter, it went on to launch index futures and internet trading in 2000, which were the first of its kind in the country.

With the help of NSE, you can trade in the following segments:

• Equities

• Indices

• Mutual Funds

• Exchange Traded Funds

• Initial Public Offerings

• Security Lending and Borrowing Scheme

Companies on successful IPOs gets their Stocks traded over different Stock Exchnage platforms. NSE is one important platofrm in India. There are thousands of companies trading their stocks in NSE. But, I have chosen two popular and high rated IT service companies of India; TCS and INFOSYS. and the third one is the benchmark for Indian IT companies , i.e. NIFTY_IT_INDEX .

Content

The dataset contains three csv files. Each resembling to INFOSYS, NIFTY_IT_INDEX, and TCS, respectively. One can easily identify that by the name of CSV files.

Timeline of Data recording : 1-1-2015 to 31-12-2015.

Source of Data : Official NSE website.

Method : We have used the NSEpy api to fetch the data from NSE site. I have also mentioned my approach in this Kernel - "WebScraper to download data for NSE". Please go though that to better understand the nature of this dataset.

Shape of Dataset:

INFOSYS - 248 x 15 || NIFTY_IT_INDEX - 248 x 7 || **TCS - 248 x 15

• Colum Descriptors:

• Date: date on which data is recorded

• Symbol: NSE symbol of the stock

• Series: Series of that stock | EQ - Equity

> ###### OTHER SERIES' ARE:

>> EQ: It stands for Equity. In this series intraday trading is possible in addition to delivery.

>> BE: It stands for Book Entry. Shares falling in the Trade-to-Trade or T-segment are traded in this series and no intraday is allowed. This means trades can only be settled by accepting or giving the delivery of shares.

>> BL: This series is for facilitating block deals. Block deal is a trade, with a minimum quantity of 5 lakh shares or minimum value of Rs. 5 crore, executed through a single transaction, on the special “Block Deal window”. The window is opened for only 35 minutes in the morning from 9:15 to 9:50AM.

>> BT: This series provides an exit route to small investors having shares in the physical form with a cap of maximum 500 shares.

>> GC: This series allows Government Securities and Treasury Bills to be traded under this category.

>> IL: This series allows only FIIs to trade among themselves. Permissible only in those securities where maximum permissible limit for FIIs is not breached.

• Prev Close: Last day close point

• Open: current day open point

• High: current day highest point

• Low: current day lowest point

• Last: the final quoted trading price for a particular stock, or stock-market index, during the most recent day of trading.

• Close: Closing point for the current day

• VWAP: volume-weighted average price is the ratio of the value traded to total volume traded over a particular time horizon

• Volume: the amount of a security that was traded during a given period of time. For every buyer, there is a seller, and each
  transaction contributes to the count of total volume.

• Turnover: Total Turnover of the stock till that day

• Trades: Number of buy or Sell of the stock.

• Deliverable: Volumethe quantity of shares which actually move from one set of people (who had those shares in their demat account before today and are selling today) to another set of people (who have purchased those shares and will get those shares by T+2 days in their demat account).

• %Deliverble: percentage deliverables of that stock

Acknowledgements

I woul dlike to acknowledge all my sincere thanks to the brains behind NSEpy api, and in particular SWAPNIL JARIWALA , who is also maintaining an amazing open source github repo for this api.

Inspiration

I have also built a starter kernel for this dataset. You can find that right here .

I am so excited to see your magical approaches for the same dataset.

THANKS!