Building a DIY Momentum Screener on Google Sheets

thumbnail
Reading Time: 3 minutes


Before you start building a screen you need to understand what factor based trading strategies are and how momentum, which is a subset of factors, has performed over the centuries.

Below is a repository of all the research material I have collected, this is, by no means complete, I keep adding new materials as I chance upon them. This will definitely give you a good idea of the strategy before starting.

https://drive.google.com/drive/folders/17FX9ps3CKAEoU8UgVVey7EsQ4V0hoisj?usp=sharing

Beyond this you should listen to the podcasts on YT by channels like ‘Chat with Traders”, “Top Traders Unplugged” where best of the best who have been doing this for decades share their knowledge of trend following systems.

So moving on to the screener, google sheets is sort of the easy way of doing this. Do note that google sheets will not allow you to do back tests on your strategy. For that you need to know a coding language and obtain clean corporate action adjusted data from the exchanges.

Most of these data feeds are paid, you can build a system where you download the entire historical data from a feed once and then append the data from google sheets everyday.

Also Read on FinMedium:  Rising from the ashes – Zorba Wealth

More creative people can scrape the data from exchange websites for free. If I remember correctly there was a CFA society video by Parijat Garg on this subject.

Back testing is sort of important when you add certain conditions to your strategy, but it is not the holy grail. So you can do without back testing if you have faith in your system.

Here is a sample of what I have built on google sheets. This is just to tell you that if you are decent in excel, you can build it yourself and run your momentum strategy without knowledge of coding.

To give a few pointers,

  1. Define you stock universe – Can be 50/100/200/500 or all stocks.
  2. Get the tickers from NSE website.
  3. Define your lookback period.
  4. Get the price data for each of the stocks in your universe for the above lookback period and current price.
  5. Calculate the % change in price and sort them based on this.

The above is the simplest form of momentum. You can even build a ranking system based on Sharpe, Sortino and various other factors mentioned in the repository above. But it will require some more data in the sheets.

Also Read on FinMedium:  CAMS IPO Analysis – Should you subscribe to CAMS IPO?

Besides this you will also have to make decisions on your portfolio diversification, weightage, entry/exit strategy, rebalancing frequency etc.

If you have read till here, obviously you are interested in DIY momentum strategy but just in case someone is completely new to the momentum bandwagon, and you are intimidated by sheets, there are a lot of small case providers who will run the strategy for you for a fee.

Depending on your portfolio diversification, if you want to follow the system perfectly you will need 2-6 lacs capital to start with. This figure is wide, the more you will diversify the more capital you will need. Some periods will require less capital and some more. If you are really constrained on starting capital, you should not be doing this in the first place. If you are still adamant you can remove the most expensive scrips till the portfolio reaches your capital level.

To conclude with the important question, why momentum strategy? Well, the answer is simple. It provides a good strategy diversification to your portfolio. No strategy works all the time just as no asset class works all the time.

Also Read on FinMedium:  KSB Pumps Stock Analysis - An Indian Agri Growth Story?

Disclaimers:

  1. Please do not construe this post as an investment advice. This is for educational purpose only.
  2. No investment capital is being solicited from the readers of this post.
  3. Momentum based trend following is the holy grail, panacea of making money. Be aware of it.
  4. Beware of momentum crashes.

Source link

Every Wednesday and Saturday, we send Info-Graphic and FinMedium Weekly Digest newsletters to our 25000+ Subscribers.

Join Them Now!

Please Share :)
Abhinav Mehrotra
Abhinav focuses on long-term positions in deeply moated businesses in the Indian equity space. He seeks momentum in the business model of a company and in the space in which it operates.
Back To Top