Google Spreadsheet Post #1382
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep 28, 2013
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
=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","
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","
=MAX(googlefinance("GOOG","
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
No comments:
Post a Comment