Why the “Best” Wordle Seed Words Aren’t Really the Best — Over the past few weeks, I noticed more and more green, yellow, and black/white grids posted on Facebook, and that’s when I discovered Wordle. I was hooked — not so much in playing the game the human way, but in developing a system to try to play optimally. As I…

In this post, we set up Apache Airflow as part of the preparation to convert our ETL code into a full-fledged data pipeline. The Series This is the third post in my series, Towards Open Options Chains: A Data Pipeline for Collecting Options Data at Scale: Database Design Foundational ETL Code Getting…

In this post, we develop the essential code for extracting, transforming, and loading options data. We will need to retrieve data from the TD Ameritrade API, transform it, and load the data into the PostgreSQL database we created in Part I: Designing the Database. …

Designing the Database — Since September last year, I started trading options. Naturally, I wanted to use data to validate my strategies. But, it was tough getting hold of intra-day options data. I was surprised to learn that it is expensive as hell: a subscription for 30-minute data (quotes and greeks) for 10 tickers…

Joseph’s Schooling’s recent performance at the Tokyo Olympics sparked a huge reaction. Having won the 100m Butterfly at the Rio Olympics in 2016, it seemed that people expected Schooling to replicate his success in Tokyo. There were numerous snide remarks (most have been deleted) and expressions of disappointment. However, it…

Building a Convolutional Neural Network (CNN) from Scratch — For the past few years, I’ve kept current on developments in machine learning (ML) through courses and interest groups. One thing I’ve noticed is that a lot of success stories were recycled from the business world. Although there are many potential military applications, especially for intelligence, these generally can’t be…