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…
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…
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,…
We, all of us, tend to be overconfident and make too many assumptions. Consider this case: a few years ago, it seemed the TA landscape was swept with the idea…
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.…
A few months ago I wrote a post on a certain kind of trending pattern I have called "slide along the bands." This pattern is characterized by a market that…
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…
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…
Patterns are important in trading; you might even say that trading is basically a game of recognizing the right patterns and doing the right thing when they happen. Most of…
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…
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…
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…
I'm convinced that one of the biggest lies of traditional technical analysis (TA) is that "you can apply any tool to any market or any timeframe with the same results."…
The idea of "trading for a living" has, no doubt, motivated an army of new and developing traders over the years. Perhaps people look at their current jobs, and think…
A reader sent me a question this week on how to develop mental toughness in discretionary trading, noting that his own toughness seemed to be getting less tough as he…
I received a good question this week from a reader, Vladan: Adam, can you please talk in one of your podcasts about mental strength when it comes to discretionary trading…
I've been in this business for about two decades, and I've seen some... let's say... "stuff". One of the most interesting things is that everyone, in developing their process or…