Is it possible to time entry and exit from gilt mutual funds for better returns?

Published: May 11, 2022 at 6:00 am

Last Updated on July 23, 2022 at 6:11 pm

In this article, we discuss the results of a tactical entry and exit strategy from gilt mutual funds and find out if it is more rewarding.

Readers unfamiliar with gilt funds may consult our previous work: (1) FAQ on gilt mutual funds: essentials investors should know. (2) Gilt mutual funds will not protect your money! Recognize risks before investing! (3) Can we buy gilt mutual funds now? They have given more than 10% returns in the last year! (4) Can we invest via SIP in gilt mutual funds for the long term?

Note: It must be kept in mind that long-term SIPs in gilt funds (see article 4 above) have been quite productive in the past and should at the very least provide an FD-like return before tax (better than FD after tax for those in 20% and above slabs).

Therefore a simple systematic rebalancing with equity is all that is necessary for most retail investors. The following methodology and results are only for those seeking better profit from gilt mutual funds.


Join over 32,000 readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email!
🔥Enjoy massive discounts on our robo-advisory tool & courses! 🔥

Warning and disclaimer: Please recognise results shown in backtests do not factor in future market movements especially sharp price fluctuations and sequence of returns, human emotions, taxation and exit loads. All these would impact the outcome of market timing.

No single strategy would work for all markets and at all times. After extensive backtesting, we have arrived at this strategy as a reasonable choice at the time of original publication. There is no guarantee that it would work in future. Future backtesting may reveal flaws in this strategy or reveal new or modified strategies.

Anyone who uses this tool does so at their own risk. Freefincal or this author/editor is not responsible or liable for any gains or losses that may result from the use of this strategy or the associated tool.

Backtest results for other asset classes: (1) Is this a good time to buy gold? A tactical buying strategy for gold (2) This “buy high, sell low” market timing strategy surprisingly works! (3) Do not use SIPs for Small Cap Mutual Funds: Try this instead!

A tool based on the above strategy is now available: A tool for tactical buying and selling using moving averages.

The timing strategy for gilt mutual funds:  We had earlier pointed out that the NAV of a gilt fund cannot be used for tactical play. So we shall use the 10-year gilt yield.

Since yield and price are inversely proportional to each other, we work with the inverse of the 10Y bond yield. This would serve as a bond PE ratio. Recall that the inverse of the Nifty PE is known as the earnings yield. See: Has the market recovered already? Did it even crash?

I-bex gilt index in red and inverse of 10-year gilt yield in blue
I-bex gilt index in red and inverse of 10-year gilt yield in blue

Notice that the 10Y bond PE is significantly more sensitive than the IBEX price. So we shall use this for our gilt timing backseat. We consider two models.

Model 1: Buy gilt funds when bond PE is greater than both the six-month moving average (6MMA) and the 12-month moving average (12MMA). Sell gilt funds when bond PE is less than both MMAs.

Model 2: Buy gilt funds when bond PE is greater than 6MMA. Sell gilt funds when bond PE is less than 6MMA.

This is a screenshot from the double moving average tool with “buy” (=1) and “sell” (=0) indicators (dotted line).

10 year bond PE with six and twelve month moving averages along with the buy and sell signal (right axis)
10 year bond PE with six and twelve month moving averages along with the buy and sell signal (right axis)

We shall use I-BEX gilt index and the 10-year gilt yield for this study and consider 5-year, 10-year and 15-year durations between May 1998 and May 2022.  Please note that results may vary if the test is done with an alternative index or yield.

Systematic approach: Buy a gilt fund each month via SIP.

Tactical approach: Buy/sell a gilt fund using method 1 or method 2. If the model does not indicate “buy” existing investments and future investments will be held as “cash” with a 6% return (before tax).

Method 1: using two moving averages

Five years

The backtest result for 5 years is shown below. Top left panel: the XIRR for each of the 231 5-year backrests are shown. Not too bad an outcome for the tactical approach. The no of times gilt funds were bought or sold on average (= buy/sell average) is three which is quite reasonable over a five year period.

5Y backtest of Tactical asset allocation with gilts using 10Y bond yield double moving average
5Y backtest of Tactical asset allocation with gilts using 10Y bond yield double moving average

Top right panel: The maximum drawdown (max fall from peak) of the portfolio is shown (less negative the better). For some runs, the tactical approach has a lesser drawdown. 

Bottom left panel: The standard deviation or volatility (lower the better). The tactical approach has a bit lower volatility.

Bottom right panel: the max no of months the portfolio was below its peak or underwater (lower the better). The tactical approach does marginally better sometimes.

Ten years: 171 trials were considered. Again the tactical strategy has done fairly well. The buy/sell average is 8.

10Y backtest of Tactical asset allocation with gilts using 10Y bond yield double moving average
10Y backtest of Tactical asset allocation with gilts using 10Y bond yield double moving average

15 years:

15Y backtest of Tactical asset allocation with gilts using 10Y bond yield double moving average
15Y backtest of Tactical asset allocation with gilts using 10Y bond yield double moving average

Method 2: using 6mma

5 years: Buy/sell average =4

5Y backtest of Tactical asset allocation with gilts using 10Y bond yield six-month moving average
5Y backtest of Tactical asset allocation with gilts using 10Y bond yield six-month moving average

10 years: Buy/sell average =10

10Y backtest of Tactical asset allocation with gilts using 10Y bond yield six-month moving average
10Y backtest of Tactical asset allocation with gilts using 10Y bond yield six-month moving average

15years: Buy/sell average =15

15Y backtest of Tactical asset allocation with gilts using 10Y bond yield six-month moving average
15Y backtest of Tactical asset allocation with gilts using 10Y bond yield six-month moving average

The 6MMA method is a bit more rewarding than the double MMA method. However, the number of buy/sell transactions is higher. Thus tax and exit load would reduce the final reward.

We would caution readers not to get carried away by these results and keep in mind the “no single strategy would work for all markets and at all times” warning mentioned above. A backtest that works 9 times out of 10 would be declared a “successful strategy” by an analyst. However, an investor must be aware that the lone bad result or even worse could their outcome once they start investing. This is also known as the sequence of returns risk.

Do share this article with your friends using the buttons below.

🔥Enjoy massive discounts on our courses, robo-advisory tool and exclusive investor circle! 🔥& join our community of 5000+ users!
Use our Robo-advisory Tool for a start-to-finish financial plan! More than 1,000 investors and advisors use this!
New Tool! => Track your mutual funds and stock investments with this Google Sheet!
Follow Freefincal on Google News
Follow Freefincal on Google News
Subscribe to the freefincal Youtube Channel. Subscribe button courtesy: Vecteezy.
Subscribe to the freefincal Youtube Channel.
Follow freefincal on WhatsApp Channel
Follow freefincal on WhatsApp
Podcast: Let's Get RICH With PATTU! Every single Indian CAN grow their wealth! 
Listen to the Lets Get Rich with Pattu Podcast
Listen to the Let's Get Rich with Pattu Podcast
You can watch podcast episodes on the OfSpin Media Friends YouTube Channel.
Lets Get RICH With PATTU podcast on YouTube
Let's Get RICH With PATTU podcast on YouTube.

  • Do you have a comment about the above article? Reach out to us on Twitter: @freefincal or @pattufreefincal
  • Have a question? Subscribe to our newsletter with the form below.
  • Hit 'reply' to any email from us! We do not offer personalized investment advice. We can write a detailed article without mentioning your name if you have a generic question.

Join over 32,000 readers and get free money management solutions delivered to your inbox! Subscribe to get posts via email!

Explore the site! Search among our 2000+ articles for information and insight!

About The Author

Pattabiraman editor freefincalDr. M. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. He has over ten years of experience publishing news analysis, research and financial product development. Connect with him via Twitter, Linkedin, or YouTube. Pattabiraman has co-authored three print books: (1) You can be rich too with goal-based investing (CNBC TV18) for DIY investors. (2) Gamechanger for young earners. (3) Chinchu Gets a Superpower! for kids. He has also written seven other free e-books on various money management topics. He is a patron and co-founder of “Fee-only India,” an organisation promoting unbiased, commission-free investment advice.
Our flagship course! Learn to manage your portfolio like a pro to achieve your goals regardless of market conditions! More than 3,000 investors and advisors are part of our exclusive community! Get clarity on how to plan for your goals and achieve the necessary corpus no matter what the market condition is!! Watch the first lecture for free!  One-time payment! No recurring fees! Life-long access to videos! Reduce fear, uncertainty and doubt while investing! Learn how to plan for your goals before and after retirement with confidence.
Our new course!  Increase your income by getting people to pay for your skills! More than 700 salaried employees, entrepreneurs and financial advisors are part of our exclusive community! Learn how to get people to pay for your skills! Whether you are a professional or small business owner who wants more clients via online visibility or a salaried person wanting a side income or passive income, we will show you how to achieve this by showcasing your skills and building a community that trusts you and pays you! (watch 1st lecture for free). One-time payment! No recurring fees! Life-long access to videos!   
Our new book for kids: “Chinchu gets a superpower!” is now available!
Both boy and girl version covers of Chinchu gets a superpower
Both the boy and girl version covers of Chinchu gets a superpower.
Most investor problems can be traced to a lack of informed decision-making. We have all made bad decisions and money mistakes when we started earning and spent years undoing these mistakes. Why should our children go through the same pain? What is this book about? As parents, what would it be if we had to groom one ability in our children that is key not only to money management and investing but to any aspect of life? My answer: Sound Decision Making. So in this book, we meet Chinchu, who is about to turn 10. What he wants for his birthday and how his parents plan for it and teach him several key ideas of decision-making and money management is the narrative. What readers say!
Feedback from a young reader after reading Chinchu gets a Superpower (small version)
Feedback from a young reader after reading Chinchu gets a Superpower!
Must-read book even for adults! This is something that every parent should teach their kids right from their young age. The importance of money management and decision making based on their wants and needs. Very nicely written in simple terms. - Arun.
Buy the book: Chinchu gets a superpower for your child!
How to profit from content writing: Our new ebook is for those interested in getting side income via content writing. It is available at a 50% discount for Rs. 500 only!
Want to check if the market is overvalued or undervalued? Use our market valuation tool (it will work with any index!), or get the Tactical Buy/Sell timing tool!
We publish monthly mutual fund screeners and momentum, low-volatility stock screeners.
About freefincal & it's content policy. Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on mutual funds, stocks, investing, retirement and personal finance developments. We do so without conflict of interest and bias. Follow us on Google News. Freefincal serves more than three million readers a year (5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified with credible and knowledgeable sources before publication. Freefincal does not publish paid articles, promotions, PR, satire or opinions without data. All opinions will be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
Our publications

You Can Be Rich Too with Goal-Based Investing

You can be rich too with goal based investingPublished by CNBC TV18, this book is meant to help you ask the right questions and seek the correct answers, and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantThis book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at a low cost! Get it or gift it to a young earner.

Your Ultimate Guide to Travel

Travel-Training-Kit-Cover-new This is an in-depth dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, and how travelling slowly is better financially and psychologically, with links to the web pages and hand-holding at every step. Get the pdf for Rs 300 (instant download)