I have calculated parts A through to C as below and am unsure how to tackle questions
Question:
I have calculated parts A through to C as below and am unsure how to tackle questions d to k
a.Search for the stocks of APA Group and Transurban. Download historical daily price data over the last 501 trading days (approx. 2 years).
b.Calculate with Excel the daily returns of the stocks of companies APA and Transurban.
Historical simulation:
c.Based on the 500 returns for each stock calculated in b., calculate 500 alternative scenarios for the $ value of the $350,000 investment in APA stock and the $650,000 investment in Transurban stock, respectively. Sum these two for each scenario to obtain 500 simulations for the $ value of your portfolio consisting of stock APA and stock Transurban.
Below I have calculated the daily returns from the last 500 trading days of APA Group and Transurban Group as well as the investment values, value of portfolio and alternative portfolio gains/losses. However, I am stuck doing the next few questions, can anyone assist please.