New answers tagged google-finance
-1
Another alternative is using the opening price at the beginning of the week. Thanks Alan, is what I needed.
=ROUND( ( GOOGLEFINANCE(A$4,"price") / index(GOOGLEFINANCE(A$4,"open", datevalue(today()-7) ) , 2,2) - 1 ) * 100 ,2)
0
I figured it out.
It was:
=GOOGLEFINANCE("GOOG","price") / INDEX(GOOGLEFINANCE("GOOG","price","2/19/2020"),2,2) - 1
Top 50 recent answers are included
