An Excel-based backtesting strategy simulator for indices and stocks. Test how swing strategies actually would have played out — and find the combinations that generate returns at low beta rather than just riding high beta up and down.
Every month a fixed amount goes into the index, the same as an ordinary SIP. The strategy adds one rule on top: when the index falls far enough from its peak, part of the holding moves into a liquid fund. It comes back either when the index recovers close to its old high, or when the fall gets deep enough to look like a crash rather than a dip.
Every one of those thresholds is a cell you can edit. Change it and all 108 simulations recalculate.
| Setting | What it controls |
|---|---|
| Monthly investment | The fixed amount invested each month |
| Sell trigger | How far the index must fall from its peak before you move money out |
| Buy-back trigger | How deep a fall counts as a crash worth buying into |
| Recovery trigger | How close to the old high the index must climb before you return |
| Share moved | How much of the holding actually shifts on a sell |
| Liquid fund return | What the money earns while it sits out |
Turn a screenshot of any index chart into a monthly data series you can test against.
Six sell triggers by six buy-back triggers by three ways of splitting the move — 108 live simulations, heat-mapped so the good and bad regions are obvious.
Pick any combination from a dropdown and one chart redraws, with a marker on every month money actually moved and the amount alongside it.
Nothing is a hardcoded number. Open any cell and the working is there to check.