Take SP Intermittent Functioning Problem

Advanced automation available in Guardian - Chat with others and share files here.
Post Reply
User avatar
MugPunter
Posts: 42
Joined: Fri Sep 14, 2018 10:58 pm

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?
User avatar
Dallas
Posts: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

Do the ones not been taken as SP meet the minimum SP bet size?
burntheory
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.
burntheory
Posts: 58
Joined: Tue Sep 09, 2014 9:49 am

Round up the backer's stake I should have said!
User avatar
MugPunter
Posts: 42
Joined: Fri Sep 14, 2018 10:58 pm

Thanks Dallas, that is most likely the problem. :D
Last edited by MugPunter on Mon Aug 19, 2019 7:18 am, edited 1 time in total.
User avatar
MugPunter
Posts: 42
Joined: Fri Sep 14, 2018 10:58 pm

burntheory wrote:
Sun Aug 18, 2019 10:23 am
And, when using Excel, use the roundup function to ensure the liability is £10 as opposed to £9.99.
Dallas was right, I wasn't meeting the minimum.

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
Post Reply

Return to “Bet Angel - Automation”