- Alison Andrade (@alisonands2000)
- Sourav Kumar (@s0uravk)
- Sakina Jaffri (@SakinaJaffri)
- Kunal Khirwar (@kunalkhirwar)
In this repo, we perform an analysis of the stock market over 4 sectors: Automobiles, Healthcare, Technology and Finance to determine the performance of the stock market in these sectors throughtout the duration of the COVID-19 pandemic.
This repo contains 4 folders that contains the files with the Jupyter notebooks that extract the required data for analysis in each sector. These Jupyter notebooks use AlphaVantage and Yahoo Finance modules to extract the data for the ticker symbols for their respective sectors. The outputs of the csv files that will be merged used for the final analysis. The data was broken down as follows.
| Automobiles | Healthcare | Technology | Finance |
|---|---|---|---|
| Semiconductors | Medical Instruments and Supplies | Semiconductors | Credit Services |
| Auto & Truck Dealerships | Healthcare Plan | Software | Asset Management |
| Auto Parts | Biotechnology | Consumer Tech | Insurance |
| Auto Manufacturers | Drug Manufacturers | Info Tech | Mortgage |
Packages used:
- For data extraction: AlphaVantage package, yfinance
- Visualizations: Matplotlib, Plotly, Seaborn, hvplot
- Analysis: Pandas, Numpy, Scipy
This report answers the following questions:
- Which stocks are best performing in their respective sectors? (Sourav)
- Which ticker performed the worst/best by year? (Sourav)
- How did each sector perform for each year regarding average volume? (Kunal)
- Find a correlation between industries within each sector. (Kunal)
- What does the moving average look like for each industry? (Alison)
- Which stock was most traded in each year? (Alison)
- What is the allocation of portfolio for each Sector? (Sakina)
- What is the allocation of portfolio for each Industry? (Sakina)
!pip install alpha_vantage
!pip install yfinance
While our analysis provides valuable insights, it is essential to acknowledge certain limitations. The data used in the analysis represents a small fraction of the entire stock market, and should be acknowledged as a limitation, as this is not fully representative of the entire market. Factors such as market sentiment, geopolitical events(i.e. The war in Ukraine, 2022), and unforeseen circumstances may also not be fully captured in our methodology.