How to backtest a simple momentum strategy in excel using free data sources
I often get asked how to validate an investment idea without paying for fancy software or hiring a quant team. One of my favorite ways to do that is to backtest a straightforward momentum strategy in Excel using free data sources. It’s practical, transparent, and — crucially — reproducible. In this article I’ll walk you through the exact steps I use, including where to get data, how to structure your spreadsheet, the formulas to...