1

Currently I have the following formula:

=MIN(INDEX(GOOGLEFINANCE(B2, "low",DATE(2020,2,19),TODAY()),0,2))

This gives me the lowest price for my stock but I want to know what date this lowest price was as well. Can anyone help me out?

player0
  • 124,011
  • 12
  • 67
  • 124
goodone05004
  • 11
  • 1

1 Answers1

2

try:

=QUERY(GOOGLEFINANCE(B2, "low", DATE(2020, 2, 19), TODAY()),
 "order by Col2 limit 1 offset 1", 0)

0

player0
  • 124,011
  • 12
  • 67
  • 124
  • 1
    Excellent, thank you! To find the HIGHEST price, only change 2 parameters: "low" to "high", obviously, and add " desc" after "order by Col2" – Nico Aug 15 '22 at 19:08