How to calculate Investment Performance Statistics

I want to calculate rolling period statistics in Coda. The calculations work fine, except, my table will ultimately have 20,000+ rows and these calculations become unresponsive. Is there a better way to do these calcs e.g. using FormulaMap or some other way?

This is the formula to calculate the 3 Month (3M) linked return.
IF(thisRow.[ITD Months] < 3,"",
(thisTable
.Filter(
[Fund Backstop ID] = thisRow.[Fund Backstop ID] AND
[Effective Date] <= thisRow.[Effective Date] AND
[Effective Date] >= thisRow.[ED-3M]
)
.[1Plus MTD]
.Product() - 1
))

1 Like