Hi all,
I have a column of numbers, below left, that updates via a DDE. New entries are added to the bottom. A second column, below right, contains numbers that are simple moving averages of the most recent five entries in the first column. I use =average( to calculate this number. Every time a new number is added to the data column, I use the fill function manually to calcualte the new average.
Is it possible to create a macro that will do this averaging calculation? I know how to create a macro using fill, but I don't know how to make the macro get fill to always look to the most recent five data entries.
The columns look like this in the worksheet.
(Data) (Average of last five data entries)
1.1669 1.1367
1.1694 1.1400
1.1832
Thanks in advance,
chaos
I have a column of numbers, below left, that updates via a DDE. New entries are added to the bottom. A second column, below right, contains numbers that are simple moving averages of the most recent five entries in the first column. I use =average( to calculate this number. Every time a new number is added to the data column, I use the fill function manually to calcualte the new average.
Is it possible to create a macro that will do this averaging calculation? I know how to create a macro using fill, but I don't know how to make the macro get fill to always look to the most recent five data entries.
The columns look like this in the worksheet.
(Data) (Average of last five data entries)
1.1669 1.1367
1.1694 1.1400
1.1832
Thanks in advance,
chaos
