Calculating a series of stock's cumulative returns

[Jack Law]

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.

 

[AhoyNC]

See if this link is of help. Shows how to calculate cumulative return in Excel with PRODUCT function.

How to Calculate Cumulative Return of a Portfolio? - YouTube