Formula Manipulation While Calculating Returns

Hello, everyone!

I have a range of data with daily stock returns presented in percentage for each company starting from the day when event has happened. For each stock, which is presented on the first row I need to add additional column and calculate cumulative returns, which is the value of 1$ investment.

a) I'm wondering what could be the best way to calculate cumulative returns data without adding a new column for each company
b) What could be the formula for this kind of operation, where we just put '1' (invest 1$) in the first cell in front of the first return and then we keep on with formulas?

I also add a sample with highlighted cells to be more clear.

Thank you beforehand!

Maybe creating a list for your companies and dates, then adding a dropdown+A vlookup for date.
and based on that date a single column formula:

Formula:

Please Login or Register  to view this content.

See attached