Skip to Content
0
Sep 22, 2020 at 07:33 AM

"rolling" moving average formula

62 Views

HI,

I would like to use the SMA formula but with a rolling period selection.

Ex.

- january: value(jan)/1

- feburary: value(jan+feb)/2

- march: value(jan+feb+mar)/3

...

I thought that this is possible with "SMA" formula but the selection of the periode is fix. Is there any other formula that I can use for that purpose?

Thank you

Attachments

sma.png (7.0 kB)