Automate High Momentum Stock Screening with Google Apps Script

Рет қаралды 1,067

Күн бұрын

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
----------------------------------------------------------------------------------------------------------------------------------------------------------
QuantX-Builder for Mastering Momentum Investing. 4 week comprehensive cohort learning programme.
sekharsudhamsh.graphy.com/s/s...
----------------------------------------------------------------------------------------------------------------------------------------------------------

Пікірлер: 16

@dsudipto1 28 күн бұрын

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 28 күн бұрын

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.

@ReadySteadyMusic 20 күн бұрын

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 20 күн бұрын

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

@v3nkattrader684 28 күн бұрын

nice work brother ...

@MomentumLab_IN 28 күн бұрын

Thank you Venkat

@vhdodiya 29 күн бұрын

Thanks for sharing such valuable content ❤

@MomentumLab_IN 29 күн бұрын

Thank you

@suhaskothavale9265 17 күн бұрын

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 17 күн бұрын

Yes you can replace the tickers after Index rebalancing, there is a much simpler way to get High Momentum Stocks. Please check this video kzfaq.info/get/bejne/i7Rpo6aHsNitlJ8.htmlsi=u22EtnXOrkDyj5Yn&t=913

@kevalkumar9694 12 күн бұрын

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 12 күн бұрын

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 kzfaq.info/get/bejne/i7Rpo6aHsNitlJ8.htmlsi=dN7eWtGFaEKRJ9ET

@abhinavmisra8800 27 күн бұрын

rank1m - rank6m rates consistent good and bad performers 0

@MomentumLab_IN 26 күн бұрын

Hi Abhinav, can you elaborate your idea

@abhinavmisra8800 23 күн бұрын

@@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 23 күн бұрын

Got it 👍