Fantasy Sports

  • Sleeper API in Excel Power Query: Payout Tracker

    Sleeper API in Excel Power Query: Payout Tracker

    Fantasy sports platform Sleeper has developed an API to give players access to a trove of league-specific data that is not publicly accessible on other platforms. Things like like historical roster makeup, results over time, and setting changes are now easily viewable by anyone who plays fantasy on Sleeper. Needless to say, the Sleeper API…


  • Lotto Simulator – Draft Lottery Math

    Lotto Simulator – Draft Lottery Math

    A couple years ago, my Fantasy Football league passed a rule that said our draft order would be determined by lottery each year. As commissioner, it was my job to implement this rule. My initial idea was to buy an actual full-blown lottery ball machine. How cool would that be?! But due a combination of…


  • Fantasy Football and the Poisson Binomial Probability Distribution

    Fantasy Football and the Poisson Binomial Probability Distribution

    In my most recent post I introduced a process to estimate the probability of me making a putt in my garage. I also provided a tool for others to do the same (though one doesn’t necessarily need to be in their garage if the weather cooperates). In that exercise, I assumed that each putt had…