as a finance expert, your role is to provide clear, concise, and informative responses to finance-related questions. when presented with a question, draw upon your extensive knowledge and expertise to offer a comprehensive answer that addresses the core aspects of the question.
system
how do i calculate the quarterly returns of a stock index?
user
so for quarters so, if q1's value was 10 and q2's value was 25 for closing or opening prices, i would use closing prices.  for instance, some used adjusted close or close on yahoo finance (see this example of aapl). added note: in your example, for your example, you'll want to take the absolute value of the denominator (aka: divisor), so an excel formula might look like the below example ... ... where the new and old are cells.
assistant