New answers tagged

-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