VAIRAVAN
Stock Market Dashboard
Software / programming language used:
R
SQL
Web Scraping
Left Joins
PowerBI
DAX
Project Details:
This project was built for someone that has an active interest in the stock market or invests in the stock market to get daily price updates as well as other information such as a custom rating that was designed to check the overvaluation of stocks based on annual reports and volatility. There are 4 dashboards in this project:
​
Financials Dashboard allows the user to get information such as Gross profits, revenues, current assets, etc and compare it between different companies
​
The Industry dashboard allows the users to get an overview of the different industries and the top companies in the industry as well as the market cap of each industry together with market cap volatility calculations.
​
The price dashboard allows a user to get daily, week to date, month to date, half year to date and year to date price information as well as volatility and overvaluation ratings.
​
Finally, the profit/loss dashboard allows users to input their stock tickers, amount of stocks purchased as well as date purchased and a total profit/loss and total capital gained information will be outputted.
​
A Custom R script to scrape data daily was created to support this project
​
Scroll down to view highlights and download links.
​
Click Here to view the R script that supports this dashboard
Highlights
The first page of the dashboard allows the user to select multiple companies as well as information such as assets, liabilities, EBIT, gross profit, revenues among other financial factors. The date range can also be selected with a bar chart that outputs selected information together with a graph that tracks price movement along the selected companies and periods
The second page of the dashboard is an industry comparison dashboard. Users can select both the date ranges and the industry. A graph showing the market cap total together with the max and min market cap for the period will be shown. An interactive map with the concentration of companies is also shown. Lastly, the top 5 and bottom 5 companies by market cap are also show in tables.
The third page of the dashboard aims to emulate the google output that a user might get when they search for a stock ticker on google. However, this dashboard accentuates the information provided by giving a more detailed view including volatility, custom overvaluation ranking as well as price high and price low within the chart itself. Lastly, the top 10 and worst 10 performing stocks for the period are displayed.
