Войти

Excel & VBA

Excel: EWMA-based volatility calculation with VBA

Excel: EWMA-based volatility calculation with VBA

28.12.2020 · 6894 hits

Exponential Weighted Volatility (EWMA, Exponential Weighted Moving Average) is an approach to volatility calculation. The main objective of the EWMA approach is to closely track the volatility as it changes.

Read more

Excel: Accelerate VBA calculations

Excel: Accelerate VBA calculations

01.01.2020 · 1751 hits

 If you run your VBA code with calculations that affect any cells on your workbook sheets, it is good practice to disable some Excel services to increase the speed of the calculation. 

Read more