i already calculuated the EWMA (exponentially weighted moving average) in excel calculate EWMA (Exponentially weighted moving average).xlsx (G2523 in the excel file, the EWMA is red marked) for the last day.

i need to calculate the EWMA for all historical dates... (G2522, G2521 etc.) that i don't need to generate 100 new columns (for column J, K & L), i'm looking for a way to generate G2523, G2522 etc. with a single formula in one cell?

for those who don't know EWMA here's a little explanation: https://www.youtube.com/watch?v=P_tr9_Ue220

thank you very much for your help.

Excel File EWMA:
calculate EWMA (Exponentially weighted moving average).xlsx