How I Trade (Part 1 of 2)
Word Count: 1506Estimated Reading Time: 7-8 minutes While I’ve written extensively on trading approaches and market movements, I still get many questions like, “How do you trade?” and “What tools…
Roll em! How to calculate futures rolls (and why you care)
This post will be a bit more technical than most, but it’s an important subject to understand. Today, let’s talk about rolling and back-adjusting futures prices: why we did it.…
Basic backtesting in Excel: How to keep learning
My goal was to put simple, but powerful, tools into your hands so you can start doing the work to understand how the market moves. In this, the last, post…
Basic backtesting in Excel: Doing statistical tests
So this is what we've been waiting for. We finally have the tools to ask simple market questions and to ask some critical questions. If you are new to backtesting,…
Basic backtesting in Excel: Conditions, logic, and stats
Pat yourself on the back if you've come this far in the little backtesting mini-course. After many posts, we've basically gotten data into a spreadsheet and calculated some moving averages.…
Basic backtesting in Excel: graphs and first calculations
Continuing on with the short series on backtesting in Excel, let's look at some tools to visualize data and make some simple calculations. Excel is a good tool for quick…
Basic backtesting in Excel: Introduction
I've received many questions about how to do basic backtesting in Excel. I think I wrote in my book that we all have a love/hate relationship with Excel: it's a…
Reader question: how to backtest?
Reader Jas asked a question about backtesting: I was wondering if you'd be able to advise me on how to back test a strategy on some custom indicators. I'm aware…