EQUITIES TRADING SYSTEM

This is a database of all equities dating back to the year 2000, complete with dashboards and email alerts for buy and sell signals. It has been a personal project of mine as a data analyst over the years and exemplifies my ability to accumulate skills necessary to accomplish a project. The system has grown over time from simple spreadsheet analysis to a fully  autonomous trading system, complete with git version control. The system is completely autonomous: it pulls end of day quotes for the three major US stock exchanges, updates the database and dashboards, and emails me buy and sell signals to review.

​

I built the entire infrastructure from the ground up using various tools from AWS. The system:

1. Downloads the end of day quotes from the 3 major US stock exchanges

2. Adds them to the database and updates all of the tables with a batch of ETL processes

3. Calculates metrics and identifies buy and/or sell signals based on my portfolio, if any, and emails me the list

4. Dashboards are updated in AWS Quicksight so that I have quick views into how my portfolio is performing compared to the market

​

AWS tools utilized:

• EC2 Server - schedules and runs the python jobs

• S3 - stores the daily quotes cheaply

• Glue - organizes the files into queryable tables

• Athena - build queries to identify actionable signals

• Quicksight - provides interactive dashboards to investigate the data further

​