Friday, October 4, 2013

yogi_Compute MIN And MAX Of LOWs And HIGHs For A Stock Within A Specified Range of from And To Dates

                                          Google Spreadsheet   Post  #1382
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 28, 2013
user Grove Under (http://productforums.google.com/forum/?zx=kv2v4ugrv7vv#!category-topic/docs/spreadsheets/VHavMFBwfVg)
=MAX function bug when calling GoogeFinance?
I tried to find out the lowest low of a stock price since 9/1/2013 via googlefinance using the formula below and it worked fine:

=MIN(googlefinance("GOOG","low", "9/1/2013", today(), 1))    <- This formula works fine and returns the proper answer
However, when I tried to find the highest low (or the highest high) using the following formulas, I could not get it to work:

=MAX(googlefinance("GOOG","low", "9/1/2013", today(), 1))
=MAX(googlefinance("GOOG","high", "9/1/2013", today(), 1))

The =MAX function returns a value of 41550.666667, no matter what stock symbol is used.  

Is this a bug, or is the =MAX function not being used properly with googlefinance?  Thanks!

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

there is no bug -- you have to operate on the second column values of the output from GoogleFinance function --
have a look at the illustration I present in the following