Getting a Offset filled before placing a new bet?
-
taxbreaks1
- Posts: 23
- Joined: Thu Apr 16, 2009 12:25 pm
I have set up a spread sheet to trade but do not want another bet to be placed until the offset has been filled or the stop filled - help please!
You can check the P/L (C6,C7 etc) via VB routine for > or < £xxx. eg
Private Sub Worksheet_Calculate()
Dim i As Integer
For i = 6 To 64 Step 2
If Range("M" & i).Value = "PLACED" And Range("C" & i).Value > -xxx Then _
Range("M" & i).ClearContents
Next i
End Sub
This will clear the status marker only if your P/L indicates that the offset has executed. Whilst the offset remains unfilled, the P/L on that bet will either be large red or large green (depending on whether you back/lay first).
This works for me but offset instructions, once initiated, will continue to fire even after the off time, Suspended or In-play markers. Which is why we need the ability to cease auto trading with enough time before the off, to allow offsets to complete.
Private Sub Worksheet_Calculate()
Dim i As Integer
For i = 6 To 64 Step 2
If Range("M" & i).Value = "PLACED" And Range("C" & i).Value > -xxx Then _
Range("M" & i).ClearContents
Next i
End Sub
This will clear the status marker only if your P/L indicates that the offset has executed. Whilst the offset remains unfilled, the P/L on that bet will either be large red or large green (depending on whether you back/lay first).
This works for me but offset instructions, once initiated, will continue to fire even after the off time, Suspended or In-play markers. Which is why we need the ability to cease auto trading with enough time before the off, to allow offsets to complete.