I have a table with daily return. I need to get the compound interest
or return for every month using a pivot table of excel.
What I need is to add 1 to the every return and multiply the result
grouping an entire month and then to reduce 1 again. how can I do it in
a pivot table?? Thanks.