A Stock Price History Tool – oldschoolfinance

Reading Time: < 1 minute

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:

  1. Absolute & CAGR returns.
  2. All-time high, 52-week high/low.
  3. % change from all-time high & 52-week H/L.
  4. Rolling returns for periods of the month, 1/3/5/7/10 years.
  5. Drawdown % and days.
  6. Moving Averages.
  7. Charting.

Hope you will find the tool helpful.

Google Sheet: Stock Price History



Source link

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 our grievance officer Ghanisht Nagpal and drop a mail to editor@finmedium.com

Also Read on FinMedium:  10 common secrets of a good fundamental analyst and a good technical analyst – Factsbeyondnumbers

Every Wednesday and Saturday, we send Info-Graphic and FinMedium Weekly Digest newsletters to our 25000+ Subscribers.

Join Them Now!

Abhinav Mehrotra

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.
Please Share Now :)