Get startedGet started for free

What is the average return?

You just calculated the daily returns for ABC's stock data. Now you can add the number of days and mean data to be able to see the average daily return.

This exercise is part of the course

Financial Modeling in Google Sheets

View Course

Exercise instructions

  • In B3, use the count() function to determine the number of stock days of data you are using from Column D.
  • In B4, use the average() function to calculate the mean daily return from Column G.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise