I have a column of numbers representing periodic returns (but expressed without the %):
1.31
0.21
-0.33
I want to calculate a cumulative return of the "% changes" above (the answer is 1.1877% in this simplified case), but with some restrictions that make this hard for me to figure out:
Is there any reasonable way to do what I want? Sorry for all of the restrictions!
1.31
0.21
-0.33
I want to calculate a cumulative return of the "% changes" above (the answer is 1.1877% in this simplified case), but with some restrictions that make this hard for me to figure out:
- I'd rather not add more intermediate calculation columns to the data, to keep the spreadsheet as simple/clean as possible. This rules out the normal solution of converting them to a %, creating a new column where you add 1 to that %, and then using =Product(Range)+1 on the new column.
- I'd rather not use array formulas, if possible, to make this spreadsheet more usable by non-experts
- The column of numbers above is auto-generated by a program I can't easily change, so I'd rather not have to manually modify the column of numbers above by diving by 100, etc. since any changes I make will be overwritten each time the program runs.
- I'd prefer not to use a complex/repetitive formula like =((1+A1)*(1+A2)*(1+A3)....)-1 since there might be 100+ returns/cells to reference.
Is there any reasonable way to do what I want? Sorry for all of the restrictions!