Step 1 ) - Calculate the daily returns (use can use log returns)
Step 2) - Use excel function =Average() to get the daily average.
More detailed explanation you can find here - http://zerodha.com/varsity/chapter/volatility-calculation-historical/
Step 1 ) - Calculate the daily returns (use can use log returns)
Step 2) - Use excel function =Average() to get the daily average.
More detailed explanation you can find here - http://zerodha.com/varsity/chapter/volatility-calculation-historical/