Smoothing real-time data in Excel

[programmernovice]

I receive into Excel some real-time data which varies constantly.

For example, Cell A4 contains a number which varies in real time. How would I set up a VBA script so that one number every 15 seconds is stored and after some given time interval (say 3 minutes) their average is computed and posted to Cell A5?

This would allow the smoothing of data, and give more accurate results than the individual numbers.

It would seem inconvenient to store so many numbers temporarily on the worksheet itself, so it may be necessary to name some container containing them.

I'd appreciate all hints, suggestions, etc. on how to go about this. Many thanks in advance.

[Auric__]

It might be better to do this outside of Excel. Where does the data come from
in the first place? How is it acquired? How is it imported into Excel?

--
Problem not solved, but acceptably worked around.

[programmernovice]

On Tuesday, August 10, 2021 at 11:35:20 AM UTC-5, Auric__ wrote:

> It might be better to do this outside of Excel. Where does the data come from
> in the first place? How is it acquired? How is it imported into Excel?

Thanks for replying.

Data is from financial markets, via RTD from a broker. It is imported into Excel using a formula for the RTD platform, by specifying the variables for the instrument in question into the formula (for instance date, symbol, bid, asked, etc). It works very well with Excel, but the real time numbers jump around and there needs to be some procedure to establish a trend, for instance using a moving average.

I can do some rudimentary VBA programming in Excel, but would not know how to use any outside program for the purpose.

Thanks again.