Excel Spread does not fire Bet everytime active command given

Advanced automation available in Guardian - Chat with others and share files here.
Post Reply
User avatar
ChrisF
Posts: 56
Joined: Mon May 22, 2017 10:48 am

Hi

Finishing a new project in excel but the interface below does not seem to fire a bet off every time the command is issue for 2 seconds. Attached is what I mean, obviously it would be in a market when the command is issued. Is there a new version of the interface sheet that works better or am I doing something wrong. The command is issued for 2 seconds. Its in the racing markets.
BackBet-in-Market.PNG
Chris
You do not have the required permissions to view the files attached to this post.
User avatar
ChrisF
Posts: 56
Joined: Mon May 22, 2017 10:48 am

Any ideas?
User avatar
ChrisF
Posts: 56
Joined: Mon May 22, 2017 10:48 am

Is my issue Related to the Status Cell, does this need clearing to place multple fast bet?
User avatar
ChrisF
Posts: 56
Joined: Mon May 22, 2017 10:48 am

Yes it was. Thats fixed got the solution from another post.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Range("O9").Value = "PLACED" Then
Application.Wait (Now + #12:00:02 AM#)
Range("O9").Value = ""
End If
etc

The last peace on the puzzle is related to staking. In the new version of betangle you can submit a bet by liability (back/Lay). Is it possible to do this through the excel interface, if so what are the commands?
User avatar
ChrisF
Posts: 56
Joined: Mon May 22, 2017 10:48 am

Actually its just a excel calculation :)
User avatar
ChrisF
Posts: 56
Joined: Mon May 22, 2017 10:48 am

Actually I have now changed it to:


Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Range("O9").Value = "PLACED" Then
Call Module1.Reset_Bet
End If

etc
Post Reply

Return to “Bet Angel - Automation”