Trade with the Odds: How to Construct Market-Beating Trading Systems

by Anthony Trongone

Quick Summary

Trongone presents a data-driven approach to trading system construction using Microsoft Excel as the primary analytical tool. The book teaches traders to calculate winning percentages, average returns, and performance statistics for various market conditions, then use these findings to build evidence-based trading strategies. It covers performance measurement, risk quantification, moving average integration, mean reversion, volume analysis, predictor variables, cross-hedging, and trade formulation.

Detailed Summary

Anthony Trongone's "Trade with the Odds" takes a distinctive approach to systematic trading by using Microsoft Excel as the primary analytical engine rather than specialized and expensive trading software. The book argues that traders should develop their own analytical skills rather than rely on purchased trading systems.

The book opens with a philosophical chapter arguing that mastery comes not from finding the perfect system but from developing the skills to create and evaluate systems continuously. Trongone emphasizes that systems inevitably lose their effectiveness as market conditions change, so the ability to create new systems is more valuable than any single system.

Chapter 2 introduces the concept of "playing the percentages" -- using historical data to determine the probability of various market outcomes under specific conditions. Chapter 3 covers performance measures in detail: winning percentage, average return, standard deviation, Sharpe ratio, maximum drawdown, profit factor, and various risk-adjusted return metrics.

Chapters 4-5 teach readers how to extract performance results from market data using Excel functions and how to monitor system performance over time to detect degradation. Chapter 6 demonstrates how to break down a stock or commodity's behavior by time of day, day of week, and market conditions.

Chapter 7 focuses on quantifying risk through Value-at-Risk calculations, drawdown analysis, and tail-risk assessment. Chapter 8 addresses trading in trendless (range-bound) markets, where mean-reversion strategies become appropriate.

Chapter 9 integrates multiple variables into moving average systems, showing how to improve basic crossover strategies by incorporating volume, volatility, and other conditioning variables. Chapter 10 covers contrarian strategies -- going against the grain when conditions suggest a reversal.

Chapter 11 introduces "restrictive trading systems" that only generate signals under very specific, statistically favorable conditions. Chapter 12 analyzes how to identify and exploit shifting characteristics of trading volume.

Chapter 13 covers predictor variables -- identifying market conditions that have historically preceded above-average returns. Chapter 14 presents cross-hedging strategies using correlated instruments. Chapter 15 discusses how to formulate trading decisions by combining multiple analytical inputs. Chapter 16 covers preparation for successful trading.

The Technical Appendix provides Excel formulas and step-by-step instructions for implementing the analytical techniques described in the book.

The book's main contribution is making quantitative trading analysis accessible to traders who are not programmers. By using Excel, which virtually every trader already owns, Trongone removes the barrier of expensive specialized software and allows traders to directly engage with the data.