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
1 Answers
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.
Related