how to find highest price during period using "GOOGLEFINANCE"

Question

I'm try to find highest price using GoogleFinance.

=IF($I5="KRX", GOOGLEFINANCE("KRX:" & $J5, "price"), IF($I5="KOSDAQ", GOOGLEFINANCE("KOSDAQ:" & $J5, "price"), ""))

This is the formula what I used to find current price of stock.

I have data in 2 cells

B3 = 2023.Sep.1

C4 = 2023.Oct.2

I tried using the keyword "High", but it showed me all the high prices within the period I entered, but I only want to find the highest price within a certain period.

Thank you

Answer 1

Good afternoon, attached proposal.

=MAX(INDEX(GOOGLEFINANCE("ticker","high","start_date","end_date","DAILY"),0,2))

References
MAX Returns the maximum value in a numerical data set.
INDEX Returns the content of a cell, specified by row and column offset.

return highest price between two dates

Example:

=MAX(INDEX(GOOGLEFINANCE("BME:BBVA","high","2020/01/01","2025/06/01","DAILY"),0,2))

return 11.28