Microcap momentum portfolio

Hi All,
Just FYI – @SOMASHEKAR_A_C and I worked on automating this flow and I would like to share this view only Google sheet with you all MomentumPortfolio_V3 – Google Sheets

I am very well aware that the results that I get from this sheet are a “little” different from the ones @visuarchie posts. But since I had offered to see if this flow can be automated I am posting my work here. If you wish to copy this sheet and automate your workflow you could do so. I have only given view access to this sheet, so you will need to copy it if you want to use it.

I don’t intend to keep this sheet updated every week ( at least don’t want to promise that ) and neither do I intend to post my stock picks here. I can’t be as punctual and methodical as @visuarchie so I will let him drive the forum. My intention of sharing the sheet is to contribute back and hopefully help others.

If you spend sometime with the sheet you will be able to understand how it works. Anyways a brief explanation follows

What are the different sheets

1. Database: Contains data for all 750 stocks
2. Microcap: Ranks the 250 microcap stocks by using the data in the Database sheet
3. Smallcap: Ranks the 250 smallcap stocks by using the data in the Database sheet
4. Midcap: Ranks the 150 midcap stocks by using the data in the Database sheet.

Where my approach differs

1. I intentionally don’t select stocks that don’t have a 1 year history. Basically want to give equal treatment to all stocks. So if we intend to look at a 12 month and a 6 month lag performance all stocks need to pass that criteria. For example JYOTICNC was suggested on this forum but my sheet does not recommend that
2. GOOGLEFINANCE() has a weird behavior that it sometimes omits the data for the last 2 days in a given date range. I have modified the sheet to live with this oddity.
3. For microcap we were selecting 25 stocks out of the 250 stocks i.e. 10% of the universe. I decided to select the same number of stocks for smallcap as well i.e. select top 25 stocks from a universe of 250 smallcap stocks. If you decide to invest in only the top 20 stocks you could choose to do so
4. The sheet automatically calculates which stocks should exit and which new ones you should invest in. For example, if you look into the Microcap sheet, cells D14 to K39 indicate which stocks to exit and which to enter. For example, my sheet told me to exit UFLEX and OPTIEMUS and invest in NETWEB and DHANUKA

Even if you dont intend to use the sheet, you could use some of the ideas from the sheet. For instance,

1. @SOMASHEKAR_A_C gave a brilliant suggestion on how to use the GOOGLEFINANCE() function to fetch the stock data. Essentially a single call to the GOOGLEFINANCE() function can fetch data for a range of dates. This speeds up the data updation process significantly. How to use this function can be found as a comment on cell Database!B2. I have copy pasted the values from the GOOGLEFINANCE() call so you wont see the function call being made.
2. The sheet uses some formulas to calculate which stocks to exit and which to enter. This can easily be done manually, but I wanted to automate this part and I learnt some interesting things on how to use Google sheets along the way.