I have developed a google sheet which uses the functionalities of google finance to extract the price history of any stock you desire. Instructions are available in the sheet.
Kindly make a copy of the sheet to your google drive so that everyone can make use of it at the same time.
Parameters included in the sheet are:
Absolute & CAGR returns.
All-time high, 52-week high/low.
% change from all-time high & 52-week H/L.
Rolling returns for periods of the month, 1/3/5/7/10 years.
Disclaimer: The opinions expressed in this publication are those of the authors. They do not purport to reflect the opinions or views of the FinMedium or its members. The presentation of material therein does not imply the expression of any opinion whatsoever on the part of the FinMedium concerning the legal status of any company, country, area, or territory or of its authorities. For more info. please read our ToU & Privacy Policy here. If you have any concerns regarding this post, please reach out to us at finmedium@gmail.com
Abhinav focuses on long-term positions in deeply moated businesses in the Indian equity space. He seeks momentum in the business model of a company and in the space in which it operates.
Please Share Now :)
Published by Abhinav Mehrotra
Abhinav focuses on long-term positions in deeply moated businesses in the Indian equity space. He seeks momentum in the business model of a company and in the space in which it operates.
View all posts by Abhinav Mehrotra
