AI Stock Insights

Table of Contents

• About This Project
• Libraries Used
• API Used
• Stock Splits and Data Adjustments
• Visualization Examples
• Contributors

About This Project

This project is designed to analyze and measure the historical performance of various stocks, focusing on key metrics such as percent change and adjusted close prices. By utilizing real-time stock data and adjusting for stock splits, the project allows for in-depth analysis and visualization of stock trends over time. The data is processed and visualized to provide insights into stock performance, helping users understand fluctuations and trends for companies like Amazon, Google, Tesla, and more.

Libraries Used

• hvplot For interactive plotting of stock trends and percent changes.
• pandas For data manipulation and analysis.
• requests For making HTTP requests to external APIs.
• matplotlib For static plotting of data.
• numpy For numerical operations and calculations.
• panel For creating interactive dashboards and visualizations.
• dash For building web-based interactive visualizations and dashboards.

To install:

pip install hvplot pandas requests matplotlib numpy panel dash

API Used

• Alpha Vantage API: We used the Alpha Vantage API to retrieve historical stock data for analysis.

Stock Splits and Data Adjustments

When analyzing stock data, we noticed anomalies such as sharp drop-offs in certain graphs. These discrepancies were due to stock splits, where companies increase the number of shares while reducing the price proportionally. To ensure accurate visualizations, we developed a function to adjust for these splits, resulting in split-adjusted prices for consistency in analysis.

Below are the graphs illustrating the stock prices before and after applying our stock split adjustments:

Below are two visualizations that demonstrate some of the key insights from our analysis:

Before Adjustments

After Adjustments

With these adjustments in place, we generated the following visualizations to highlight key trends and insights.

Visualization Examples

1. Cumulative Percent Change of All Stocks

This graph shows the cumulative percent change for all stocks over the selected period.

2. Average Daily Percent Change of All Stocks

This graph visualizes the average daily percent change for each stock.

3. Comparison Results Table

Here is a comparison table of key metrics for the stocks analyzed:

Contributors

Check out the list of contributors to this project here.

• Danny Srour
• Daniel Lui
• Ryan Brown
• Cathy Schassberger
• Austin Cappetta
• Caleb Kelson