Code Monkey home page Code Monkey logo

analysis-of-national-stock-exchange's Introduction

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

Setup:

1) Design Preview Available 2) DataBase 3) Complete Python Setup Avaliable Here: https://github.com/atharvaagrawal/analysis-of-national-stock-exchange/tree/master/PROCESS

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.

analysis-of-national-stock-exchange's People

Contributors

atharvaagrawal avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.