Debunking market myths in Excel

Having the ability to call bullshit on market claims is a superpower. There’s some ancient trader lore that says it’s a bad idea to hold SPY when it’s under the 12-month moving average of its price. Is there anything to this idea? Check out the webinar below to see how we put this idea to …

Read more

What’s the chance that a market effect is real? Monte Carlo permutation tests in Excel

Let’s say you observe some effect in the market and quantify it with simple data analysis. A good question is, “What are the chances I’d see this effect solely due to chance?” And using simple Excel tools, we can answer this question without doing any formal statistics. Before we get into it, it’s worth noting …

Read more

Valuation Timing with Excel

Data analysis plays a central role in making sense of financial markets. But how can you verify the conclusions others draw, or better yet, uncover your own insights? Microsoft Excel remains one of the most powerful and accessible tools for financial data analysis, allowing anyone—from beginners to seasoned analysts—to explore data, test hypotheses, and make …

Read more