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.
この演習はコースの一部です
Google Sheetsで学ぶファイナンシャル・モデリング
演習の手順
- In
B3, use thecount()function to determine the number of stock days of data you are using from ColumnD. - In
B4, use theaverage()function to calculate the mean daily return from ColumnG.
