FPI Report and Nifty Indices,Exploratory Data Analysis

• The goal of this notebook is to do data analysis on NSDL Sector-wise FPI Investment report, as well as the sectoral Indices.

Dataset

• Dataset consists of FPIs report and Nifty indices data from kaggle.

• Lets quicky understand what those are:

What is FPI?

• Foreign Investment inflow is an important reason for India’s economic growth. So to simplify compliance requirements and have uniform guidelines for various categories of foreign investors like Foreign Institutional Investors (FIIs), Sub Accounts and Qualified Foreign Investors (QFIs) merged into a new investor class termed as Foreign Portfolio Investors (FPIs).

• SEBI has authorized NSDL to monitor of these Group investment and various data related to FPI activities to be displayed on NSDL web portal.

• NSDL provides this data at an interval of 15 days.

Source: FPI NSDL

Nifty sectorial Indices

• This includes NIFTY 50, NIFTY AUTO, NIFTY BANK, NIFTY FMCG, NIFTY IT, NIFTY METAL, NIFTY OILGAS, NIFTY PHARMA, NIFTY PRIVATE BANK.

• These indices are designed to reflect the behavior and performance of their respective sectors.

Tools used

• Pandas
• Datetime
• glob
• plotly

Downloading the Dataset

• Get nifty indices data from kaggle.
  Source: INDICES DATA

• Installing necessary packages

Let's begin by downloading the data, and listing the files within the dataset.