Diamond Hands - Catch the next GME

cockroachdb throughput
db

Inspiration

We all witnessed history when the subreddit /r/wsb managed to raise the price of multiple industry-shorted stocks to meteoric prices, such as GME and BB. Although many profited from this rise in price, many were late to the party and went in at a too high price. Well, to those people, look no further as we have created a tracker for momentum stocks discussed on /r/wsb! Never be late to the party ever again! However, we want to make sure that our project serves to inform anyone who is not knowledgable to these momentum plays, and advise caution to any beginner investor looking to get in on any speculative stock purchase.

What it does

At its core, our web application tracks reddit submissions and scrapes data ranging from submission titles, submission bodies and comments. We use this functionality to primarily track the wallstreetbets subreddit. Our web app will feature the most mentionned tickers on the wsb subreddit, as well as analyze the sentiment around the discussion of a specific stock. This sentiment score represents the enthusiasm of redditors pertaining to that stock. Our goal is to provide clarity to our users by displaying these stocks as well as any pertinent financial information pertaining to that stock. Our website tracks the top daily posts, and will update periodically to update its list of most mentionned tickers.

How we built it

Our project uses the Django web framework, as it provided a faster setup process than comparative js frameworks. Python also allows us to interact with many libraries such as praw, that we used to scrape data off of Reddit. In order to obtain financial data, we access the yahoofinance yfinance API, which gives us enormous information about a specific stock. Finally, we used vaderSentiment, an open-source sentiment analyzer that we used to score the sentiment of the discussion around our featured stocks. We also setup a connection from our back-end to a cockroachdb database, that is still semi-functional, but have done succesful puts.

Challenges we ran into

Since reddit features enormous amounts of data, scraping the top daily posts consumes a lot of time. This slows down the performance of our web application, which impacts our users. Additionaly, we had a hard time succesfully connecting our Django framework to CockroachDB.

Accomplishments that we're proud of

tbh nothing

What we learned

cockroachdb is the best python > javascript

one of us spent 6 hours playing with hex codes to change colors in css

What's next for Diamond Hands - Catch the next GME

Hopefully, we catch the next trip to the moon. Optimize performance when scraping reddit, Expand on our learn-more section to include more financial data, and even analysts' recommendation pertaining to that specific stock Tighter back-end infrastructure as we get better at using Django this project is prolly gonna get deleted ngl