Trading Signals in High Definition

We’ve all used on/off type trading signals at some point. But you can nearly always extract more insight with a simple adjustment that focuses on using data efficiently. Let me show you how using a crypto trend example. The problem with binary signals You’ve seen them everywhere. “If price is above the 20-day moving average, …

Read more

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