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!

sub Private Sub Worksheet_Change(ByVal Target As Range)

    On Error Resume Next

   

    If Target.Address = "$B$1" Then
        If Target.value > 1.3 Then
       
             MsgBox "The value is  " & Target.value
        End If
    End If

End Sub