I'm trying to get the max value within a certain perdiod and tried: =max(GOOGLEFINANCE("FRA:CR6";"close";DATE(2020;4;1);DATE(2020;4;31)))
This returns the date sind it has a higher value than the price of this stock.
I also tried =DBMAX(GOOGLEFINANCE(A24;"close";DATE(2020;4;1);DATE(2020;4;31));2;)
But this returns just a #Value error...
What am I doing wrong?