About this Dataset

NIFTY50 Data Mar2008 To Dec2022

Extracted 15 years NIFTY50 data using nsepy/nsetools to perform analysis to drive data driven investment insights.

Detailed Analysis Series @ Medium

https://medium.com/@kmrmanish/nifty50-data-analysis-using-python-d9227e525894

NIFTY50 Data Analysis Series

Data Extraction : Download NIFTY50 daily data for last 15 years using API like nsetools/nsepy
Data Visualization : Plot the interactive trends(Line, Candlesticks and Heikin Ashi Charts) for different period using Cufflinks and Plotly
High-Low Analysis & Open-Close Analysis
Gap Up-Gap Down Analysis
Simple Moving Average (SMA) Analysis : Calculate and Plot 7 days, 14 days, 21 days, 50 days and 200 days SMA
Exponential Moving Average (EMA) Analysis : Calculate and Plot 7 days, 14 days, 21 days, 50 days and 200 days EMA
Monthly Return Analysis : Calculate and Plot %Monthly Return and Positive & Negative Return Count
Portfolio Analysis : One Time Lump-sum Investment
Portfolio Analysis : Monthly SIP on 1st trading day of the month
Portfolio Analysis : Invest only on First Gap Down Day of the every month
Portfolio Analysis : Invest on All Gap Down Days
Sharpe Ratio Comparison : Compare different investment strategies and risk adjusted returns

Tables

Nifty50

@kaggle.manishkr1754_nifty50_mar2008_dec_2022csv.nifty50

186.97 KB
3718 rows
7 columns


CREATE TABLE nifty50 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover" DOUBLE
);

Nifty50 Mar2008 Dec 2022

@kaggle.manishkr1754_nifty50_mar2008_dec_2022csv.nifty50_mar2008_dec_2022

176.16 KB
3671 rows
7 columns


CREATE TABLE nifty50_mar2008_dec_2022 (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover" DOUBLE
);