Hi Everyone,
I have the monthly return data of 17 stocks. I need to calculate the cumulative returns. I see some have posted saying to use the PRODUCT function. However, I've been using it but it doesn't seem correct. If i check by dividing the ending price by the beginning price I get a different answer.
I have the monthly return data of 17 stocks. I need to calculate the cumulative returns. I see some have posted saying to use the PRODUCT function. However, I've been using it but it doesn't seem correct. If i check by dividing the ending price by the beginning price I get a different answer.