Hi, just wondering if anyone has had a similar problem.
I'm placing my bets via Excel, but use an automation file to perform some basic operations mainly SWITCH market and TAKE SP.
While most of my bets get matched immediately, on occasion I get caught in a fast-moving market.
Usually, my bets are placed 1 minute before the off, with the automation file firing Take SP at 10-second intervals.
Every now and again the Take SP simply doesn't function. I can't understand why it fails, does anyone have any ideas?
Take SP Intermittent Functioning Problem
-
- Posts: 58
- Joined: Tue Sep 09, 2014 9:49 am
And, when using Excel, use the roundup function to ensure the liability is £10 as opposed to £9.99.
-
- Posts: 58
- Joined: Tue Sep 09, 2014 9:49 am
Round up the backer's stake I should have said!
Dallas was right, I wasn't meeting the minimum.burntheory wrote: ↑Sun Aug 18, 2019 10:23 amAnd, when using Excel, use the roundup function to ensure the liability is £10 as opposed to £9.99.
Yes, rounding is accurate, I wrote this function for that.
Function TickRound(MyTick As Single)
Dim NewTick As Single
'****** roundedNumber = Round(number / 50, 0) * 50
If MyTick < 2 Then
NewTick = Round(MyTick / 0.01, 0) * 0.01
End If
If MyTick >= 2 And MyTick < 3 Then
NewTick = Round(MyTick / 0.02, 0) * 0.02
End If
If MyTick >= 3 And MyTick < 4 Then
NewTick = Round(MyTick / 0.05, 0) * 0.05
End If
If MyTick >= 4 And MyTick < 6 Then
NewTick = Round(MyTick / 0.1, 0) * 0.1
End If
If MyTick >= 6 And MyTick < 10 Then
NewTick = Round(MyTick / 0.2, 0) * 0.2
End If
If MyTick >= 10 And MyTick < 20 Then
NewTick = Round(MyTick / 0.5, 0) * 0.5
End If
If MyTick >= 20 And MyTick < 30 Then
NewTick = Round(MyTick / 1, 0) * 1
End If
If MyTick >= 30 And MyTick < 50 Then
NewTick = Round(MyTick / 2, 0) * 2
End If
If MyTick >= 50 Then
NewTick = Round(MyTick / 10, 0) * 10
End If
TickRound = NewTick
End Function