Move from Excel to Python in 3 simple steps Use the workbook you already have. Most finance work still runs on Excel. When I was a derivatives trader, most the $7 billion operation was based on Excel. The process was the same: You build the model, drag the formulas down and refresh it every Monday. Eventually, the sheets got too big and wouldn't even open. The analysis was basic and not that interesting. An actuary in one of my courses said most of his analysis lived in Excel, and "it was...
13 days agoΒ β’Β 6 min read
You don't need a $30,000 terminal to build an AI research desk Let Python pick what matters. Let the agent explain it. A Bloomberg Terminal costs about $30,000 a year. So you do what everyone does: You paste news headlines into ChatGPT. Then a 10-K. Then a chart. Then another chat window. By Friday you have 40 chats, 12 browser tabs, and no idea if any of what ChatGPT came up with works. That's experimenting, which is fine, but the sooner you build a system, the sooner you get results. Every...
20 days agoΒ β’Β 5 min read
Shuffle your backtest 1,000 times with 6 lines of Python Shuffle your strategy 1,000 times. If it can't beat 95% of them, it's luck. Nobody taught me how to backtest a trading strategy. So I read the books (and wrote two), the documentation, the research, and the blogs. Most of them end the same way: an equity curve going up and to the right. You copy the code. It loses money. So you change the moving average from 50 days to 43. Now it looks great. A folder full of backtests. And you don't...
27 days agoΒ β’Β 6 min read
The 3-step roadmap out of Python overwhelm Pick one problem and write just enough code to solve it. Getting started using Python for algorithmic trading, market data analysis, and quant finance sucks. 500,000,000 Google results for "python tutorial" (or some weird AI generated nonsense). Hundreds of "agent coding IDEs." Billions of YouTube videos. The Python ecosystem is huge (and growing): PyPI, the official Python package index, lists more than 900,000 projects as of this week. In the 2025...
about 1 month agoΒ β’Β 6 min read
The first step in algorithmic trading is small (and easy) A three-stage path from a market view to your first paper trade. It's 9:40 p.m. and you have 14 browser tabs open. One is a video about how Jane Street trains its models on a cluster of GPUs. Another is a job post that asks for a PhD in physics. Your Python notebook sits in the last tab. It has one cell and that cell imports pandas (a far cry from Jane Street's GPU-powered neural networks). You close the laptop and tell yourself you'll...
about 1 month agoΒ β’Β 7 min read
Standard deviation counts a 6% day above the mean and a 6% day below it as the same risk np.std(returns) * np.sqrt(252) is one line, and it produces the volatility figure, the standard measure of how far a price swings from its average, that shows up on nearly every broker screen. Now picture two equity curves with the same standard deviation, one that jumped 9% in a single week and one that bled about 1% a week for two months. The measure scores them identically, so a ranking built on it...
about 2 months agoΒ β’Β 2 min read
Most beginners think portfolio math has no room for their own opinion about a stock (it does) You can follow the code in a portfolio tutorial line by line and still not know what the numbers mean, so when the program hands back weights you have no way to judge whether they're sensible. The first weight-picking program I built put almost all the money into two stocks, and nothing in the code was broken. I just didn't understand that the rough return guesses I fed it were doing all the work....
about 2 months agoΒ β’Β 2 min read
One CSV read cost me half a second On September 23 at 10:00 am Eastern US time, I'm hosting a free webinar. In it, you'll found out the fastest route to becoming a Python quant: Master the 20% of Python that drives 80% of quant results. Build professional-grade backtests in under 30 minutes. Automate execution by connecting Python directly to broker APIs. Clean messy market data using the exact workflows used at J.P. Morgan. Get the step-by-step roadmap to transition from βtutorial hellβ to...
2 months agoΒ β’Β 3 min read
Most beginners think a strategy needs constant attention to make money (it doesn't) You have a job, and the two hours you carve out on a Sunday keep going into data cleanup instead of testing an actual trading rule. So months pass and you still haven't seen a single strategy run start to finish. Discipline isn't the problem. The rule you picked is too big to finish, so pick a smaller one. Here's the reality. The idea Meb Faber published in 2007 holds a fund only while its price sits above its...
2 months agoΒ β’Β 2 min read