stock-historic-data

Stock Historic Data

This project is designed to fetch and store historic and live stock data using the Yahoo Finance API. The data is stored in SQLite databases and can be accessed via a Flask web application.

Functionality

For a detailed walkthrough of the project's functionality, you can watch the following YouTube video:

Route: /

• Stock Historic Data Visualization Chart
• Data from Historic Database

Route: /live

• Stock Live Data Visualization and sending data to live_database

Route: /onlylive

• Only Tick per second Data for Data Visualization

Installation

• Clone the repository:

  git clone https://github.com/abhiwer/stock_historic_data.git
  cd stock_historic_data
  

• Create and activate a virtual environment:

  python -m venv env
  source env/bin/activate  # On Windows use `env\Scripts\activate`
  

• Install the dependencies:

  pip install -r requirements.txt
  

Usage

• Run the application:

  flask run
  

• Open your browser and navigate to:

  • http://127.0.0.1:5000/ for Stock Historic Data Visualization Chart
  • http://127.0.0.1:5000/live for Stock Live Data Visualization
  • http://127.0.0.1:5000/onlylive for Only Tick per second Data Visualization

Endpoints

• /: Main page to view historic data.
• /live: Page to view live data.
• /onlylive: Page to view only live data.
• /get_dates: API to get a range of dates.
• /get_currencies: API to get the list of supported currencies.
• /get_updatetheliveDB: API to update the live database.
• /get_updatethehistoricDB: API to update the historic database.

License

This project is licensed under the MIT License.