My Site Logo

My seriously awesome Google Sheet has 2 user-defined functions. One for bringing in a lot of stock data...


...and one for filtering/sorting that data to find "good" stocks.


To accomplish this feat, I use Google Apps Script...


...a MySQL database...


...Flask, SQLAlchemy, some webscraping (with BeautifulSoup), an API endpoint that returns a csv representation of the data...


...and some more Flask.