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

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 :)