Technical Analysis of National Stock Exchange

Introduction

This project is an implementation of automating the storage of NSE data into database

The purpose is to store the data in separate tables and to have a view of all the data conceretly which can further help the customers/users for easy understanding of prevalent market conditions.

To achieve the same, we have done evaluation on an interesting dataset and have analysed the obtained results.

A Database was created at first to store the data,python language was used as medium to communicate between the databases(MySQL) and (Python QT) the technology which was used to design UI.

Limitations of NSE Website:

1. As the data available on NSE website is of csv format so we have to face certain problem like Accessing Anomalies , Inconsistency , Duplicate data So on this type of data we firstly converted it into the Table Data in Database.

2. And then we have daily download the data by visiting on website and then download and afterwards store into database we automated this process by just single click on button now you can download the file.

3. As the NSE Doesn't show that which share can be more profitable to buy I tried my best to predict it.

Future Plan:

1. To predict the stock more accurately by adding more number of parameters.
2. To predict GDP growth of India.
3. To show different types of charts based on data available.

Versions

Python Version: 3.7 DataBase: MySql Server 8.0

Desktop App PyQt5 Output:

Python File:

FormDesign.py	Main File Contain Design and We can navigate to different scripts through this file.
CalculationUI.py	Calculation File Contain Design of Calculation and We can navigate to different scripts through this file.
StoreDataIntoDataBaseNIFTY50.py	Script to Store Nifty50 DataBase.
StoreBunchOfDataIntoNiftyAll.py	Script to Store All Data of One Folder to DataBase of BhavCopy.
StoreDataIntoDataBaseNIFTYALL.py	Script for Nifty All BhavCopy DataBase Store.
NIFTY50FROMNIFTYALL.py	Copy only Top Nifty 50 Data from Nifty All DataBase.
DownloadDataFromWebNIFTY50.py	Download Nifty50 File From Web Automatically.
RemovePast200RecordsNIFTY50.py	Remove Past 200 days Record From Nifty50
CheckForRemainingDayNiftyAll.py	Script to Check from which date NiftyAll Data is Absent
UpdateDataNiftyAllForRemainingDays.py	Script to Store Data in NiftyAll For Remaining Days
CalculatingLast5Days.py	Calculating Last 5 Days Record.

Extra Files:

geckodriver.exe:	In this geckodriver is for downloading data from web using selenium. Required for Mozilla Firefox.
logo.ico:	Contain Logo

Configue File: Config.cfg

For Database:

1. host
2. database
3. user
4. password

For File Path:

1. store_bunch__nifty_all_path
2. web_download_nifty50
3. nifty_all_file_path
4. nifty50_file_path
5. nifty_all_update_file_path

Directory Info:

NIFTY50:	Contains Script related to Nifty50
Data File:	Contains data file to store into database.
Config:	Contains Configure file
PROCESS:	Contains structure of Project.