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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.