Saturday, January 27, 2018

yogi_Compute Number Of Days Taken For A Stock To Recover From Price Drop On A Specified Trading Day

Google Spreadsheet   Post  #2354

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-27-2018
question by Tomhawk
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/1otdKQaIycE;context-place=forum/docs
Days to recover from a price drop
Hi All,

I wanted to ask if anyone here knows the problem that i ran into.

I'm trying to find out how many days does a stock take to recover from a price drop (If there would be in within given number of days)

Say =GOOGLEFINANCE("AAPL","close","12/22/17","12/22/17"+25)

You get the following

DateClose
12/22/2017 16:00:00175.01
12/26/2017 16:00:00170.57
12/27/2017 16:00:00170.6
12/28/2017 16:00:00171.08
12/29/2017 16:00:00169.23
1/2/2018 16:00:00172.26
1/3/2018 16:00:00172.23
1/4/2018 16:00:00173.03
1/5/2018 16:00:00175
1/8/2018 16:00:00174.35
1/9/2018 16:00:00174.33
1/10/2018 16:00:00174.29
1/11/2018 16:00:00175.28
1/12/2018 16:00:00177.09
My questions is: say take Date 12/22/17 Apple was trading at $175.01. By looking at the chat above, it takes approximately 11 trading days, (1/11/2018) to fully recoverd $175.28. 

It would be wonderful if there is a find out the number of days it will take to get close to where it was within +-2%. in this case will be 1/5/2018 traded at $175. 1 cent slightly below $175.01 comparing to 12/22/17. 

Thanks a lot!