Excel calculations
Budget: $10 – $30 AUD
I have a spreadsheet with 7 stocks and assets.
Need to calculate the following:
1) calculate the daily returns for these asset classes.
2) Calculate the annualised average return and annualised standard deviations
3) Calculate the annualised average return and annualised standard deviations of a portfolio containing 2 assets. I will give the details
4)Calculate the correlation coefficients
5) Sharpe Ratio
Need to calculate the following:
1) calculate the daily returns for these asset classes.
2) Calculate the annualised average return and annualised standard deviations
3) Calculate the annualised average return and annualised standard deviations of a portfolio containing 2 assets. I will give the details
4)Calculate the correlation coefficients
5) Sharpe Ratio