i am looking for % change in SPY over the last 7 days. I have Close(Sep-26)=120.85, Close(Oct-07)=100.03. The formula I tried to use Close1-Close2/Close1*100% gives me -17.2%, which is clearly impossible. What am I doing wrong? What's wrong with my formula? Thank you for your feedback!