Hello

I have a sheet which is connected via DDE, i.e. some cells get updated via
API.

I would like to analyse this data for high and low values.

How can I save this data in other cells (continuous) or print a chart
(dynamicly). Is there a funktion which adds new cells after a value has
changed?

To use =MAX() or =MIN() is not good as it is overwritten with new data.

Any ideas, links, etc. are welcome.

Daniel