## 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…