google finance function in google sheets to get all time high price?

Question

Is it possible to get the all time high for a ticker using google finance function in google sheets? Can't find it in https://blog.sheetgo.com/google-sheets-formulas/googlefinance-formula-google-sheets/, but I do see 52 week high

Answer 1

You can try something like that.

=MAX(INDEX(GOOGLEFINANCE("NASDAQ:GOOG", "high", DATE(2010,1,2), TODAY(), "DAILY"),,2))

• In this example I am getting the highest price since 2020 until today;
• Be aware, if you use this function with a high ticker number, you may have a performance issue.