Skip to content

Resource · Included with membership

Moving-Average Crossovers: Test the Rule Before Using It

Calculate two fictional SMAs, define equality and signal timing, and separate crossover events from execution and strategy evaluation in a reusable worksheet.

Published

Public summary

A crossover is a relationship between calculated lines, not a complete strategy. Work a fictional three-period and five-period SMA example, identify two signal bars, and use a worksheet to keep completed-bar information separate from next-bar decisions and fills.

The three-period SMA crosses above the five-period SMA at bar six and below at bar nine.
Fictional completed-close calculations; no execution prices or trading returns are supplied.
Image credit

Fictional completed-close calculations; no execution prices or trading returns are supplied.

FavAcademy · Original FavAcademy educational illustration; public use authorized

Crossover Calculation and Timing Test

Reproduce averages and crossing rules before adding an independently documented execution and cost model.

Included with membership

  • Crossover Calculation and Timing Test — editable workbook· Editable workbook
  • Crossover Calculation and Timing Test — printable workbook· Printable companion

The full guide is available to eligible members. Open member resource.

Risk disclosure

The closes and windows are fictional. Crossover detection does not supply executable fills, costs, an optimal setting or evidence of future returns.