Gruss Forum • View topic

by **Roadhouse** » Sun Mar 11, 2012 6:17 pm

Hi everyone I'm new to the forum. what I would like to do is only place bets 2seconds after the race goes in play and upto 30seconds in play. Could someone help me please Ive had a look around the forum and cant find something that does this exactly sorry if Ive missed it.

by **MarkRussell** » Sun Mar 11, 2012 11:16 pm

Hi,

You would need to use Excel triggered betting to do that with Betting Assistant.
Do you have Microsoft Excel?
Can you work with Excel formulas?

Regards,
Mark

by **Roadhouse** » Mon Mar 12, 2012 1:00 am

Hi Mark Im a newby with excel but Ive learnt bits Im prepared to give it a go I can manage a few formulas

by **Captain Sensible** » Mon Mar 12, 2012 2:05 pm

Here's a small snippet of vba code I use to log the inplay time, basically it'll log the time the market goes inplay in cell X1 ( just format the cell to time) and display the inplay seconds in cell X2. Bit rough and ready and you just need to incorporate some other code within your 'bot' to clear the values when needed , i.e switching market etc

Code: Select all: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Cells(2, 5) = "In Play" Then If Cells(1, 24) = "" Then Cells(1, 24) = Cells(2, 3) If Cells(1, 24) <> "" Then Cells(2, 24) = DateDiff("s", Cells(1, 24), Cells(2, 3)) End If Application.EnableEvents = True End Sub

by **Captain Sensible** » Mon Mar 12, 2012 2:09 pm

You can then just incorporate the inplay seconds etc into your triggers with simple if statements , greater or equal to >= 2 and less than or equal to =< 30 AND $E$2 ="In Play" etc plus whatever criteria you need

by **Roadhouse** » Mon Mar 12, 2012 4:52 pm

Thats great thankyou Captain it works fine

by **Captain Sensible** » Mon Mar 12, 2012 5:05 pm

No problem glad to see it worked.

I just use a piece of code gary put up ages ago to clear the timer cells when it switches races. You might find it useful to use to reset any variables if your sheet is automated to move between markets

Code: Select all: Private Sub Worksheet_Calculate() Static MyMarket As Variant Application.EnableEvents = False Application.Calculation = xlCalculationManual If [A1].Value = MyMarket Then GoTo Xit Else MyMarket = [A1].Value Range("X1:X2").Value = "" 'insert any additional coding here End If Xit: Application.EnableEvents = True Application.Calculation = xlCalculationAutomatic End Sub

by **Roadhouse** » Mon Mar 12, 2012 5:42 pm

great thanks captain I am switching between races thats brilliant exactly what I needed cheers mate

In play timed bets

In play timed bets

Who is online

Sports betting software from Gruss Software