Google Sheet to check the consistent growth of a stock for 52 weeks
Designed a Google sheet-based analysis to check, whether the growth of a stock is consistent or not in the past one year.
It calculates and averages the return of every previous, 7 days' close price for the past 1 year, from yesterday’s date and closing price.
So it's possible to check whether the growth is consistent for the past 52 weeks instead of conventional one-year return calculation, which is based on initial and final dates of a year.
In simple, it estimates an average of weekly returns (for the consequent previous 52 weeks from yesterday) and compares it with conventional yearly return (%).
It calculates and averages the return of every previous, 7 days' close price for the past 1 year, from yesterday’s date and closing price.
So it's possible to check whether the growth is consistent for the past 52 weeks instead of conventional one-year return calculation, which is based on initial and final dates of a year.
In simple, it estimates an average of weekly returns (for the consequent previous 52 weeks from yesterday) and compares it with conventional yearly return (%).
Screenshot
