How to get min/max value

106 views
Skip to first unread message

corni corni

unread,
May 6, 2020, 10:58:08 AM5/6/20
to Google Finance
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?

corni corni

unread,
May 7, 2020, 3:14:43 AM5/7/20
to Google Finance
=MAX(INDEX(GOOGLEFINANCE(A7;"low";DATUM(2020;4;1);DATUM(2020;4;31));0;2))
works :)
Reply all
Reply to author
Forward
0 new messages