The Excel spreadsheet is linked via ActiveX to a trading platform from here it takes the stock quotes in real time.
The code to be implemented must:
- monitor in real time two columns of the sheet
- when a particular value appears in any of the cells of the two monitored columns,
must send an email with some values taken from the sheet at that precise moment.