Google-finance syntax for date of all time low of a stock

73 Views Asked by At

What's GOGGLEFINANCE Syntax do I use to get the DATE of ALL TIME LOW of the Stock?

I am using - =MIN(GOOGLEFINANCE("ABBV","low","01/01/1980",TODAY(),7))

It is giving me ALL TIME LOW Quote of ABBV. How do I get the corresponding date for all time low?

1

There are 1 best solutions below

1
user11222393 On

It sorts all prices from lowest to highest and takes first date in the list:

=to_date(index(sort((GOOGLEFINANCE("ABBV","low","01/01/1980",TODAY(),7)),2,1),1,1))