Store max value of changing cell

Q

q5

I have a spreadsheet cell which is linked via DDE to another datasource.
The cell value changes frequently. I would like some way to store in an
adjacent cell the maximum value that the cell achieves.

I can't figure out how to do it. Can anyone help?

Thanks.
 
Top