Is there any way to place 3 lay bets into the market on the same horse at 12 ticks apart for different liabilities. The first lay bet would be a variable amount of ticks below the sp it would have an offset bet with greening with the offset only being placed after the whole of the first lay bet has been matched.
If the offset back bet gets taken then the outstanding lay bets get cancelled
Excel help
why not use guardian automation? If you have some calculations in excel you can get it to send a stored value for automation to take over?caburch73 wrote: ↑Wed Feb 19, 2020 10:40 pmIs there any way to place 3 lay bets into the market on the same horse at 12 ticks apart for different liabilities. The first lay bet would be a variable amount of ticks below the sp it would have an offset bet with greening with the offset only being placed after the whole of the first lay bet has been matched.
If the offset back bet gets taken then the outstanding lay bets get cancelled
so i found a way to place 3 lay bets 1 after the other using some vba code it works fine using other betting software which i wont mention however i cant seem to get it to work with Betangel.
I have placed the VBA to the default betangel excel file that comes with the software and modified some of the cell positions.
I also have a seperate worksheet with my triggers on and these triggers work if i manually enter them into the correct fields but for some reason they will not copy over when i place the number 1 in the trigger cell.
The Triggers worksheet contains the following for testing
LAY 1.01 2
LAY 1.02 2
LAY 1.03 2
CANCEL-ALL
Private Sub Worksheet
Dim r As Integer, triggerRow As Integer
If Target.Columns.Count = 16 Then
Application.EnableEvents = False
With ThisWorkbook.Worksheets("Triggers")
For r = 5 To 54
If Cells(r, 25) <> "" Then
triggerRow = Cells(r, 25) + 1
.Range(.Cells(triggerRow, 1), .Cells(triggerRow, 3)).Copy Range(Cells(r, 17), Cells(r, 19))
If Cells(r, 17) = "CANCEL-ALL" Then Cells(r, 20) = "ALL" Else Cells(r, 20) = ""
If Cells(r, 17) = "" Then Cells(r, 25) = "" Else Cells(r, 25) = triggerRow
End If
Next
End With
Application.EnableEvents = True
End If
End Sub
any help on getting it to copy over would be great
I have placed the VBA to the default betangel excel file that comes with the software and modified some of the cell positions.
I also have a seperate worksheet with my triggers on and these triggers work if i manually enter them into the correct fields but for some reason they will not copy over when i place the number 1 in the trigger cell.
The Triggers worksheet contains the following for testing
LAY 1.01 2
LAY 1.02 2
LAY 1.03 2
CANCEL-ALL
Private Sub Worksheet
Dim r As Integer, triggerRow As Integer
If Target.Columns.Count = 16 Then
Application.EnableEvents = False
With ThisWorkbook.Worksheets("Triggers")
For r = 5 To 54
If Cells(r, 25) <> "" Then
triggerRow = Cells(r, 25) + 1
.Range(.Cells(triggerRow, 1), .Cells(triggerRow, 3)).Copy Range(Cells(r, 17), Cells(r, 19))
If Cells(r, 17) = "CANCEL-ALL" Then Cells(r, 20) = "ALL" Else Cells(r, 20) = ""
If Cells(r, 17) = "" Then Cells(r, 25) = "" Else Cells(r, 25) = triggerRow
End If
Next
End With
Application.EnableEvents = True
End If
End Sub
any help on getting it to copy over would be great