Do we need to time the market?

For a while now, I have been wanting to do a full back-test of multiple market timing or tactical asset allocation strategies. I used a speaking invitation as an excuse to create a spreadsheet where multiple models can be quickly tested with 1000s of time periods.  While at it, I asked myself, do we need to time the market? I also recognised that question is different from, can we time the market?

The answer to, “can we time the market?” is a vehement yes, but we should recognise that market timing strategies have one common goal – reduce risk. So yes, we can time the market to reduce risk in portfolios. This risk reduction may or may not be associated with return enhancement. It all depends on the method chosen, the associated costs and tax.  Read more:

Want to time the market with Nifty PE? Learn from Franklin Dynamic PE Fund

Is it possible to time the market?

Axis Dynamic Equity Fund: Investment Strategy Analysis

Deconstructing the Motilal Oswal Value Index (MOVI)

Dynamic Asset Allocation Mutual Funds: Yield Gap vs. P/E Ratio

In addition to these,   I have also analysed tactical “dip” buying.

Nifty 200 DMA: Buying High vs Buying Low

Equity: Buying “High” vs Buying “Low”

Buying “low” vs Buying “systematically”: Surprise, Surprise!

Buying “low” with “active” cash vs buying systematically: still a surprise!

I am now building up to a series of tactical asset allocation back-tests with equity allocation swinging from 100% to 0%. And the results are pretty interesting. I am still thinking about how to present these results as they meant for the eyes of discerning DIY investors and can confuse newbie investors.

So I would like to first answer in this post: Do we need to time the market? Will I miss anything if I choose to avoid timing? The answer is: No, we do not need to time the market. No, we will not miss anything, BUT we need a proper strategy to systematically reduce risk in our portfolio.

This systematic risk reduction need not depend on any market signals. All we need is a clear goal. A clear date when we need the money and a clear target corpus. I had discussed this strategy in this post. Please read this in full as it will help you understand the context: How to reduce risk in an investment portfolio

Resolve is a series of steps on investing and portfolio management.  In the first step, we considered how to quickly select equity mutual funds and build a diversified (equity) portfolio. As a second step, we discussed how to quickly decide if I should stay invested in a mutual fund or exit it. Now, in the third step, we consider goal based risk management.

Let us consider a goal that is 15 years away. The current cost of that goal is 10 lakh. Assuming 10% yearly inflation, the future cost is shown below (blue dots). If we start investing for this in a mix of equity and debt (fixed income), the corpus assuming same returns (10% from equity and 7% from debt – both post-tax), the total corpus will be shown as below. The investment is assumed to increase by 5% each year.

RR 1 - How to reduce risk in an investment portfolio

Naturally, the aim should be for corpus (red line) to hit the target (blue line) on or before the end of the 15Y period. We start from 0, so it ends at 14. When the returns are fixed, you get a nice smooth corpus growth. Returns in real life fluctuate wildly as you will see below. This is known as sequence of returns.

Now, there are two way to invest in equity and debt. Use the same asset allocation for each year. Say 60% equity and 40% debt. We will refer to this as constant equity allocation

RR 2 - How to reduce risk in an investment portfolio

Or we can reduce equity gradually as we approach the goal. I prefer a step-wise decrease (on paper at least) and this is the approach recommended in the Freefincal Robo Advisory Software Template. We will refer to this as the reducing equity allocation.

RR 3 - How to reduce risk in an investment portfolio

To these asset allocation strategies, we need real market returns. So I have used past Sensex annual returns.

To do this we take Sensex closing price. For the preliminary results shown here, I have used data from Jan 1991 to Jan 2018. This is the first return sequence considered

From DateTo DateReturn
01-07-199115 July 1992121%
15-07-199215 July 1993-26%
19-07-199319 July 199496%
21-07-199421 July 1995-16%
25-07-199524 July 19961%
26-07-199628 July 199717%
30-07-199730 July 1998-24%
03-08-199803 August 199945%
05-08-199904 August 2000-9%
08-08-200008 August 2001-24%
10-08-200112 August 2002-9%
14-08-200214 August 200330%
19-08-200318 August 200426%
20-08-200422 August 200553%
24-08-200524 August 200651%

So we use: 121%, -26%, 96%, -16%, 1%, 17%, -24%, 45%, -9%, -24%, -9%, 30%, 26%, 53%, 51% as the sequence of annual returns for our portfolio.

Then we change the first date in the above table (marked in red) to the next business day to create the next sequence and so on. Here is another example:

From DateTo DateReturn
07-08-199106-08-199253%
06-08-199206-08-1993-6%
10-08-199310-08-199483%
16-08-199416-08-1995-24%
21-08-199520-08-1996-4%
23-08-199626-08-199720%
27-08-199727-08-1998-27%
31-08-199831-08-199967%
02-09-199904-09-2000-3%
05-09-200005-09-2001-30%
07-09-200109-09-2002-3%
11-09-200211-09-200341%
15-09-200314-09-200429%
16-09-200416-09-200553%
20-09-200520-09-200642%

So we keep repeating this to create return sequences and this is the last sequence considered.

From DateTo DateReturn
22-11-200224-11-200353%
24-11-200323-11-200425%
29-11-200429-11-200545%
01-12-200501-12-200655%
05-12-200605-12-200742%
07-12-200708-12-2008-54%
10-12-200810-12-200978%
14-12-200914-12-201016%
16-12-201016-12-2011-22%
21-12-201120-12-201224%
24-12-201224-12-20139%
27-12-201329-12-201429%
31-12-201431-12-2015-5%
04-01-201603-01-20174%
05-01-201705-01-201827%

This gives us a total of 2670 return sequences to test. In the above linked post, I had presented a few examples. For: -18%, -12%, 27%, -27%, 52%, -13%, -22%, -3%, 69%, 23%, 43%, 54%, 35%, -55%, 86%. Each of these is a return after one of year of investing. So 15 annual returns for 15 years of investing.

Constant Equity methodportfolio-risk-reduction method one

Decreasing Equity method

RR 7 - How to reduce risk in an investment portfolio

Now the question is, how do the results look if we backtest for all 2670 return sequences?

Constant Equity method (60% for all 15 years)

Total test runs: 2670

No of runs in which final portfolio value was equal to or above target value: 2670 (100%)

Decreasing Equity method (stepwise reduction)

Total test runs: 2670

No of runs in which final portfolio value was equal to or above target value: 2417 (91%)

No of runs in which final portfolio was equal to or above 90% of the target value: 2670 (100%). Full results will follow in a separate post.

Now, that is mighty impressive. Please note that the investment amount used for the decreasing equity method was the same as the constant equity method (the robo template accounts for this correctly). That is, it was lesser than necessary (when equity is fixed at 60% you need to invest less). So even then the result is remarkable.

So do you need to time the market? You can time the market if you wanted to, but there is no need. All you need to so is simple Goal Based Risk Managment to get you home.

UPDATE: Why we need to gradually pull out of equity investments well before we need the money!

Want to conduct a sales-free "basics of money management" session in your office?
I conduct free seminars to employees or societies. Only the very basics and getting-started steps are discussed (no scary math):For example: How to define financial goals, how to save tax with a clear goal in mind; How to use a credit card for maximum benefit; When to buy a house; How to start investing; where to invest; how to invest for and after retirement etc. depending on the audience. If you are interested, you can contact me: freefincal [at] Gmail [dot] com. I can do the talk via conferencing software, so there is no cost for your company. If you want me to travel, you need to cover my airfare (I live in Chennai)

Connect with us on social media


Do check out my books


You Can Be Rich Too with Goal-Based InvestingYou can be rich too with goal based investing

My first book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create customg solutions for your lifestye!Get it now.  It is also available in Kindle format.

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 want My second book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a youngearner

The ultimate guide to travel by Pranav Surya

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

Create a "from start to finish" financial plan with this free robo advisory software template


Free Apps for your Android Phone

All calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.

11 thoughts on “Do we need to time the market?

  1. This is very, very interesting and would fly against the opinions of many who firmly believe that timing, tactical asset allocation, etc are very important. These beliefs increase the complications in investing and hence require more specialized tools, and dare I say more ‘experts’ to give complicated advice. I am eagerly looking forward to the full data – it would be needed to answer the skeptics.

    1. Those who want to time have their eyes set on return. This is more focused on target corpus. Will present the full results in the next post.

  2. Greetings!

    Very interesting results – Just wondering – Do retail investors suffer because they might be stopping the ad-hoc investments during the downturn?

    You just might want to present a scenario where investors stops investing in equity when markets dip as he fears for his money because s/he has not done her own research and lacks conviction in their chosen investment avenue.

    I could not find this post on AIFW

  3. I am not sure I understand the last paragraph. Could you elaborate?

    It seems to me that constant equity was more successful in meeting the goal vs. reducing equity – i.e., 100% vs. 91%. Which seems to indicate that fix your allocation (in line with risk appetite) and forget it.

    Also, not sure what you mean by less amount is required in reducing equity model…

    1. Yes constant equity was more successful in the past but I had assumed constant 7% returns from debt. And it is too risk to have 60% equity. So I wont forget about it! When equity is reducing in the portfolio returns will reduce so investment will be higher.

  4. Fantastic article. Good Eye opener for me.. Really The Maths Expert also can not do like this…Thanks.

  5. Mr.Rob Arnott (and his colleagues) of Research Affiliates has a paper on stock market bubbles in April 2018.
    It specifically says “Timing the market is a necessary”, which among other things like the inefficiency of the stock market, make for interesting reading.
    Pl give your opinion.

  6. Sir,
    This article sort of supports SIP as an investment strategy. No timing the market, no need to spend time investing manually every month. Just a plain auto-pilot mode with some rebalancing and review of portfolio every year.

Comments are closed.