Comments:
Setting alerts which are triggered by changes in real-time data can be done within Excel. One of our products, Reuters Tools has an Alert tool which allows you to set up and monitor Alerts on cells in a worksheet which contain real-time data.
The tool has a wizard which guides you through the steps of setting up an Alert. You can set up the Alert to beep when an alert is triggered. It also allows you to display a message in the status bar or to display a message box. Although it does not offer cell flashing it lets you change the color of a cell when the alert was triggered. You could also set up the Alert to run a macro. You could write the macro so that an email message could be sent.
The Reuters Tools works only with Reuters real-time data.
If you are not Reuters subscriber you will need to write a custom Excel macro with the functionality you describe. To monitor the real-time data and trigger an alert you will need to use the VBA’s OnData property. Then when the Alert is triggered you will need to create macros to perform the series of tasks which you want.
We have an example of a macro code which uses OnData in Willow Tip 2001-10. It uses OnData to collect ticks but you can modify the code to monitor cell values and run macros which will perform the Alert functionality you want.
|
