Trigger Macro on cell change by real time data

Hi

I receive real time stock data from my broker. I would like to trigger a macro ( say if stock value is > 5). My little research shows that many people suggested to use the a code with the worksheet_change trigger such as )see below. The worksheet_change is not initiated when the value changes via real time data. It work when I change the value manually or with a program but not if the change in the target cell is changes via incoming real time data. Any solutions? Many thanks!

Please Login or Register  to view this content.

You may want to try creating a public function that receives the cell (or column) as a parameter. Whenever the input to the function changes (i.e. the cell value) the function gets automatically called as part of the calculation trigger.

you can also use the worksheet_calculate event and test the value against its previous value which you store in a static variable

please note the code tags I added to your post and please learn to use them in future

I am very surprised if an rtd function doesn't trigger a calculate event but if it in fact doesn't you might perhaps be able to use the workbook's setlinkondata method