Posts

Showing posts with the label Google Sheet to check consistent growth of a stock

Google Sheet to check the consistent growth of a stock for 52 weeks

Image
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 (%). Screenshot Link to Google sheet