Automate High Momentum Stock Screening with Google Apps Script

Discover how to streamline your stock analysis with a custom Google Apps Script that screens high momentum stocks directly in Google Sheets.
In this video, I'll walk you through the process of building and utilizing a powerful tool to update ticker metrics, analyze historical data, and calculate returns for stocks effortlessly.
GitHub Repository (To access the code) : github.com/Momentum1ab/Moment...
View Access of Google Sheet : docs.google.com/spreadsheets/...
Don't forget to "Make a Copy" of this file
----------------------------------------------------------------------------------------------------------------------------------------------------------
A COMPLETE GUIDE TO TRACKING YOUR PORTFOLIO:
www.momentumlab.in/courses/Bu...
----------------------------------------------------------------------------------------------------------------------------------------------------------

[@dsudipto1]

This is very helpful. Instead of simple averaging of ranks we can look at exponential Weighing if there is any existing literature around that.

[@MomentumLab_IN]

Thank you Sudipto . Absolutely we can giving exponential weightage to different months and get a cumulative score.I'll show how we can play around these parameters in the next video.

[@vhdodiya]

Thanks for sharing such valuable content ❤

[@MomentumLab_IN]

Thank you

[@v3nkattrader684]

nice work brother ...

[@MomentumLab_IN]

Thank you Venkat

[@ReadySteadyMusic]

Hi Sekhar..Firstly thankyou for sharing this sheet.Can i request you to make a video on how can we change the list of stock universe to Nifty50 or Midcap150 or smallcap250.Appreciate your knowledge sharing

[@MomentumLab_IN]

Sure Sir
I'll create a sheet which has stocks in different indices , so that you can copy paste and run the script.

[@suhaskothavale9265]

Thank you for this work. Does this run on Nifty 200 in the given sheet ? If yes , can we replace the ticker after index rebalancing ?

[@MomentumLab_IN]

Yes you can replace the tickers after Index rebalancing, there is a much simpler way to get High Momentum Stocks. Please check this video ua-cam.com/video/UN9pCVKrIdk/v-deo.htmlsi=u22EtnXOrkDyj5Yn&t=913

[@kevalkumar9694]

When doing Apps Script and running the code - asked for authorization and logs out time...happening again and again and not able to get ....what to do.
Can you provide any number where I can connect ?

[@MomentumLab_IN]

Hi Keval ji,
There is a simple solution. You can watch it here. It is an automated way where you don't have to run any scripts.
Use this Google Sheets, it calculates automatically
docs.google.com/spreadsheets/d/1DQrdhB4rTOO6ffustjUw-Wyyjfon2VF7QWRzYft5lek/edit?usp=drivesdk
You can watch how to use this here ua-cam.com/video/UN9pCVKrIdk/v-deo.htmlsi=dN7eWtGFaEKRJ9ET

[@abhinavmisra8800]

rank1m - rank6m rates consistent good and bad performers 0

[@MomentumLab_IN]

Hi Abhinav, can you elaborate your idea

[@abhinavmisra8800]

@@MomentumLab_IN not much just that if a stock is consistently on same rank, the score would be zero and would probably be ignore in rank1m - rank6m rating

[@MomentumLab_IN]

Got it 👍