I have an Excel sheet with a DDE server that retrieves live data from MT5. I have a column that tracks changes in the live data, and whenever a value in a cell crosses above (e.g., 10) or below (e.g., -10), an alert is triggered with a sound.
The problem is that the live data updates quickly, and when I hear an alert and go to check it, the value changes in milliseconds, so I never know which cell in that column triggered the alert.
Is there a way to create a log in another sheet so that whenever there is an alert, it quickly records the cell reference of the alert and its timestamp? The log should record each alert row by row.
I would greatly appreciate any help.

I have an Excel sheet with a DDE server that retrieves live data from MT5. I have a column that tracks changes in the live data, and whenever a value in a cell crosses above (e.g., 10) or below (e.g., -10), an alert is triggered with a sound.
The problem is that the live data updates quickly, and when I hear an alert and go to check it, the value changes in milliseconds, so I never know which cell in that column triggered the alert.
Is there a way to create a log in another sheet so that whenever there is an alert, it quickly records the cell reference of the alert and its timestamp? The log should record each alert row by row.
I would greatly appreciate any help.

I have an Excel sheet with a DDE server that retrieves live data from MT5. I have a column that tracks changes in the live data, and whenever a value in a cell crosses above (e.g., 10) or below (e.g., -10), an alert is triggered with a sound.
The problem is that the live data updates quickly, and when I hear an alert and go to check it, the value changes in milliseconds, so I never know which cell in that column triggered the alert.
Is there a way to create a log in another sheet so that whenever there is an alert, it quickly records the cell reference of the alert and its timestamp? The log should record each alert row by row.
I would greatly appreciate any help.