Tuesday, December 23, 2014

yogi_Compute Stock Price A Specified Number Of Days Ago And The Price Movement over Time

             Google Spreadsheet   Post  #1866
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-23-2014
post by  Xoron101:
Is there a way to choose the price from X days ago?
is there a way to retrieve a historical price for X days ago?

IE, I'd like the close price from 180 days ago (which would change everyday).  I'm trying to calculate the price movement over the past x days.

So the formula I'll be using is [(Today's Price) - (Historical Price from 180 Days ago)] / Today's Price = Price Movement over the past 180 Days.