This works so far but how would I do this if I wanted to do 365 days from a specified date instead of today? For example, 2020/2/19 and 365 days prior.
=GOOGLEFINANCE(A2,"price") / index(GOOGLEFINANCE(A2,"price", datevalue(today()-365) ) , 2,2) - 1
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community