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:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/jDfRUj8zZmQ
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.

-------------------------------------------------------------------------------------------------------------------------------------