How sahidul-shaikh/stock-market-analysis-with-sql works
This repository is a SQL-based stock-market analysis assignment: historical prices for six stocks are imported into MySQL, analyzed with 20- and 50-day moving averages, and used to create trading signals. The README also specifies a combined price table, a Bajaj-specific signal function, and a written summary. The SQL source was not sampled, so internal query details and exact execution order cannot be verified.
Main entry points: sql-code.sql Analysis SQL · Bajaj Auto.csv Bajaj Prices · Eicher Motors.csv Eicher Prices · Hero Motocorp.csv Hero Prices
Components 14
Stock Data
- Bajaj Prices
Bajaj Auto.csv - Eicher Prices
Eicher Motors.csv - Hero Prices
Hero Motocorp.csv - Infosys Prices
Infosys.csv - TCS Prices
TCS.csv - TVS Prices
TVS Motors.csv
SQL Analysis
- MySQL Assignment
- Analysis SQL
sql-code.sql
Analysis Results
- Moving Averages
sql-code.sql - Master Prices
sql-code.sql - Buy Sell Hold
sql-code.sql - Bajaj Signal Function
sql-code.sql - Summary Report
Summary-Report.pdf
Other components
- Analyst
Connections 14
- Analyst → MySQL Assignment: imports data
- Bajaj Prices → MySQL Assignment: imported into
- Eicher Prices → MySQL Assignment: imported into
- Hero Prices → MySQL Assignment: imported into
- Infosys Prices → MySQL Assignment: imported into
- TCS Prices → MySQL Assignment: imported into
- TVS Prices → MySQL Assignment: imported into
- Analyst → Analysis SQL: runs
- Analysis SQL → MySQL Assignment: queries
- Analysis SQL → Moving Averages: creates
- Analysis SQL → Master Prices: creates
- Analysis SQL → Buy Sell Hold: creates
- Analysis SQL → Bajaj Signal Function: defines
- Analyst → Summary Report: reviews