Looping - Minimizing The Use Of Columns

I am running a few loops within one big loop,

1st loop gets the moving average of the first 10 rows.

2nd loop uses that moving average to calculate the exponential moving average of 5,000 rows.

Now, after the first loop is run, I put that value in a Cell in Column (O). The 2nd loops works off of that cell to calculate the next exponential moving average and then that to calculate the next, and so on and on.

then I run two of the same loops as above, but with different period (for the moving average) and everything is printed in the next column, P.

THEN, another loop subtracts the column O from column P, and prints the value in the next column, Q.

Now, this takes up 3 columns, and I only need the third value, the one printed in column Q. Is there a way where my loops can store all of these values in some type of an array (instead of filling up a column on a worksheet) and then for me to simply just subtract the two arrays and have only that show up on my worksheet?