Bet Angel and Excel

[SamT]

Do us a favor, place this code in the Main ("Bet Angel") sheet's code module and run Bet Angel. Take note of what address the message box gives,

Private Sub Worksheet_Change(ByVal Target As Range)
    ' This line exits only on changes in Column H
    If Target.Column = 8 Then Exit Sub
    ' This line exits on all other changes
    If Target.Column <> 8 Then Exit Sub
    MsgBox "Cell " & Target.Address & " Just changed"
End Sub

I am hoping that Bet Angel triggers a Change event in Column "H" by itself, some programs do and some don't. If you don't see a message box, change the two "Exit Sub" lines to use the other. We are looking for something to use as a timer or input counter.

Hopefully, we can count 10 changes/Inputs, then run the VBA that will fill your other Data Cells with values. How we do it will depend on how Bet Angel works with Excel. It may be as simple as reading the values into an array and extracting first, last, Min, Max, and Average, all of which operations are very fast with arrays.

Also note: It may be required to keep all results in memory for a bit and only update the Visual aspects of the WorkSheet once a second. That will depend on the accuracy the rest of your Project requires.

This OHLC data will go down my sheet along with other indicators I need to programme to trigger events

Why not do all that with VBA in superfast RAM?

Only show on the slow spreadsheets what you personally need to know in order to follow the automated process and override it if needed. Granted it might be too late by the time you notice a problem.