A tool for tactical buying and selling using moving averages

NAV movement of small cap fund along with six and tweleve month moving averages plus the buy sell indicator in dotted line

Published: June 16, 2020 at 11:25 am

Last Updated on

We are happy to release a new market timing tool with which you can convert daily price data to monthly data and compute moving averages for equity (indices, stocks and mutual funds), gold and gilt (using bond yield). This is a follow up to backtest conducted on equity, gold and gilts using double and single moving averages. The tool is available at an introductory price of Rs. 500 for the next few days, after which it will become Rs. 1000.  inside, you also get an Rs. 1000 off, discounted link to the lectures on goal-based portfolio management.

This is a momentum-based trend-following tool in Excel (will work in old Excel version as it is a .xls file but macros are necessary for daily to monthly price conversion).

For instance, if the six-month moving average (6MMA) is greater than the twelve-month moving average (12MMA), it is a “buy” signal for equity or gold. If 6MMA < 12MMA it is a “sell” signal”

Readers who have the following articles for the last two weeks may be aware of the six months and twelve-month moving average results shown for equity (Sensex, small cap funds), gold and gilts. I strongly recommend that you read these articles first before using this tool.

(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! (4) Can we get better returns by timing entry & exit from gilt mutual funds?

Warning and disclaimer

Start of warning and disclaimer: The strategy outlined in the above articles and in this tool may or may not provide a higher return or lower risk when you try it. Please recognise results shown in backtests do not factor in human emotions, taxation and exit loads. All these would impact the outcome of market timing (aka tactical asset allocation wrt this tool).

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 tool. While the sheet has been checked for errors and bugs, like any other tool, we cannot guarantee they are free of them.

The tool is open-source (but not free). This means all the formulae and Excel VBA are accessible to the user. So users are requested to understand what the tool does and double-check for errors and inconsistencies.

The tool has a built-in “buy/sell signal”. This has different meanings for a single moving average, double moving average, gold and gilts. The users must read the above-linked articles and develop their own tactical strategy.

I will not provide any other investment advice wrt to future market movements. 

Buy the sheet only if you are willing to learn, explore, investigate and device your own, independent strategy. Please note: tactical asset allocation or market timing means exiting one asset class and entering another.

That is, as an example, if you have Rs. 100 invested into equity and the 6MMA falls below the 12MMA, you sell the equity holding (fully or partially as per your set plan) and put it into another asset class.

If you plan to use this tool only to find out “what is a good time to buy additional units or stocks”, then as discussed before the benefits of such an act is likely to either small, limited or non-existent. So kindly be aware of these limitations.

Please note that by the release of this tool, freefincal or this author is only offering tactical portfolio management as an alternative to systematic portfolio management. No claim is made about the superiority of either method. It is up to the buyer to decide on their own which is suitable for their personal circumstances.

This tool is not a financial planning tool. It will not help with goal-based portfolio management in any way. End of warning and disclaimer.

Features of the moving average market timer

This is the offer page for the course on goal-based portfolio management.

freefincal double moving average offer course
freefincal double moving average offer course

NSE Indices, MF NAV and Stock price

Daily data from NSE (for indices), Mutual Fund NAV (link to tool provided) or stocks (link to tool provided) can be taken and pasted in col A and B. Then on clicking the black button the monthly averages are computed..

freefincal double moving average input screen
freefincal double moving average input screen

You can calculate any monthly moving average in this sheet and generate a corresponding buy/sell signal.

freefincal singe moving average result
freefincal singe moving average result

In this sheet 6 and 12-month moving averages are computed with buy/sell signal.

freefincal double moving average result
freefincal double moving average result

Sensex

You can get month-end Sensex data with the link provided to generate 6,12 MMAs and buy/sell signals.

freefincal double moving average Sensex result
freefincal double moving average Sensex result

Gold

You can get month-end Gold data with the link provided to generate 6,12 MMAs and buy/sell signals.

freefincal double moving average Gold result
freefincal double moving average Gold result

Gilt Yield

You can get month-end 10-year gilt data, calculate bond PE and then generate 6,12 MMAs and buy/sell signals.

freefincal double moving average Yield result
freefincal double moving average Yield result

Demo Video

Purchase link to procure the tool

Get the Tactical buying and selling tool using moving averages (Stocks, Gold, Gilts). Rs. 500 (50% off) This introductory offer is only for the next few days. The price will revert to Rs. 1000 after that.

Do share if you found this useful