I am trying to get the YTD high of a ticker using
=max(INDEX(GOOGLEFINANCE("AAPL";"high";"01/01/2020"; today();"DAILY")))
but it does not work.
Any tip?
I am trying to get the YTD high of a ticker using
=max(INDEX(GOOGLEFINANCE("AAPL";"high";"01/01/2020"; today();"DAILY")))
but it does not work.
Any tip?
Just found out a way by doing:
=max(INDEX(GOOGLEFINANCE("AAPL";"high";"01/01/2021"; today()); ; 2))