0

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?

seralouk
  • 30,938
  • 9
  • 118
  • 133

1 Answers1

0

Just found out a way by doing:

=max(INDEX(GOOGLEFINANCE("AAPL";"high";"01/01/2021"; today()); ; 2))
seralouk
  • 30,938
  • 9
  • 118
  • 133