As a financial advisor, you are asked to advise your Singaporean clients to invest in 3 Exchange Trade Funds (ETF):

(i) SPDR Straits Times Index ETF

(ii) ABF Singapore Bond Index Fd

(iii) SPDR Gold Shares

Your clients are (Client group 1) graduate students (25-28 years old) who have worked for 2- 3 years, (Client group 2) managers (35-45 years old) and (Client group 3) directors (60 years old) nearing retirement.

Using monthly data from Feb 2008 to May 2021(including Feb 2008 and May 2021) from Yahoo Finance, perform the following:

(a) Compute the geometric return and use the return to estimate the total risk for each ETF.

Reference is from yahoo finance historical data - monthly data from Feb 2008 to May 2021(including Feb 2008 and May 2021)

Have to sort the time period and the frequency to monthly instead of daily Afterwards can apply and download as excel Will have to sort the data and remove the volume data , high Low etc which are not needed

i am unable to add the excel of figures here as too many digits.

Pls help me as i do not know how to compute and use the return to estimate total risk.

This image is just a reference for 1 fund which is the SPDR gold shares, there is still SPDR Straits times & ABF Singapore Bond Index