I’ve been working on a simple backtest using historical Nifty 50 PE data starting from 2006 to evaluate a valuation based investment strategy. The idea is straightforward: invest in the Nifty when the trailing PE falls below 20, and move to liquid funds when the PE rises above 22. During times when the market is considered overvalued (PE > 22), the capital is parked in liquid instruments.
This is a rule based strategy either fully invested in Nifty or fully in liquid funds. No averaging down is done, even during sharp corrections like in 2008 or 2020. For example, if the investor entered at a P/E of 19.6, they would remain invested regardless of further declines, instead of trying to catch the bottom.
The objective is to compare this approach with a simple buy and hold investment in the Nifty over the same time period. Specifically, it seeks to assess whether a basic valuation filter can help reduce downside risk and enhance long term returns especially for conservative investors who might otherwise prefer parking their capital in fixed deposits. Have attached the Excel sheet below as well of my calculations.
NIFTY 20 PE Strategy.xlsx (13.3 KB)