4 ms·
Mostly functions that could be achieved with Excel formulas, but would require to add some more columns. As we are already struggling with file size, we often g
by zrz 13y ago
Mostly functions that could be achieved with Excel formulas, but would require to add some more columns. As we are already struggling with file size, we often go with VBA implementation. I'm talking about calculating things like drawdowns in series, and other timeseries properties.
We compared both implementation (Formulas ad VBA) and most of the time, VBA is several times faster, and reduces chances of application freeze; So we are not even discussing the need for VBA in the team.