Chartschool: do your own homework
In this video, I show you how to use an Excel spreadsheet and, in just a few minutes, get some basic answers about market tendencies and market stats. https://youtu.be/d6Ob19DMLlk
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: issues with data
If you've been following along with the short Excel course, you've created a spreadsheet using SPY daily data, and added daily TLT data to the sheet in another column. I…
Basic backtesting in Excel: More data
Today, we will add another data series to our file we created yesterday that had daily SPY data in it. It's not quite as simple as pasting the new data…
Basic backtesting in Excel: Getting data
Continuing from yesterday's post, let's roll up our sleeves and get into the process of managing data in Excel. The purpose of this short series of posts is to give…
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…