Hi and thanks for watching :-)
This video is the first part of a larger scale stock recommendation system built with Python with the example of three indices (Nifty50, Bovespa and RTSI) which are screened for technical indicators in the upcoming videos. I am covering the MySQL Installation, the Python MySQL connection using pymysql and the population of the Database in this video.

In specific we are requesting online stock price data and store this data into the MySQL database. I am keeping it scalable so that you can take even more indices.

If you are interested in topics like that please subscribe and like the video.

MySQL Download:
https://dev.mysql.com/downloads/

First video on building a stock recommender:
https://youtu.be/AuZmsv6dQCM

Pandas and SQL:
https://youtu.be/OjMDXTlVOYU

Building a SQL database with SQLite:
https://youtu.be/5bUn-D4eL4k

Windows Installation:
https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

0:00 - 01:24 Introduction
01:24 - 05:28 MySQL Installation on MacOS (both Server and Workbench)
05:28 - 06:51 Mini Walkthrough MySQL Workbench
06:51 - 07:33 Requirements setup (sqlalchemy and PyMySQL)
07:33 - 11:05 Create schemas
11:05 - 15:55 Getting ticker symbols for the indices (+ amendments)
15:55 - 16:25 Getting stock prices with yahoo finance
16:25 - 21:45 Populating the Database with online stock prices
21:45 - 24:25 Check data in MySQL and outlook for next vid

#Python #MySQL #Stockmarket

#python #mysql #stockmarket