Updating results sheet

Find a developer for your Excel triggered betting needs and advertise your development service here.

Moderator: 2020vision

Updating results sheet

Postby Tony Grant » Fri Apr 12, 2013 8:47 pm

Hi,

I have developed quite a few sheets along the way and learned plenty of tips and tricks but there is always that next thing that keeps me in the land of the frustrated developer.
At the moment I am working on a sheet that is a staking model and so it needs the settled market information to work out the stakes for the next race.
Ok, that's simple enough, I set the sheet to auto select markets at xx minutes before the off which, with UK racing tends to give ample time for the market to have settled.
My problem is though that I can't tell what bets have been placed along the way. Ok I can temporarily see the bet being matched in column W but once the market has zeroed, this information has gone.
So ideally I would like a way to move on to the next race much earlier (which of course I can do in the betting assistant settings) but I need to know how to refresh the results page about 1 minute before the start of the next race.
Does anyone know how I might trigger this?

Thanks
Tony Grant
 
Posts: 6
Joined: Mon Jan 14, 2013 4:43 am
Location: Lincoln, UK

Postby osknows » Fri Apr 12, 2013 9:57 pm

Put a -6 trigger into cell [Q2] to refresh the results; assuming the market has settled.
User avatar
osknows
 
Posts: 946
Joined: Wed Jul 29, 2009 12:01 am

Q2 Trigger

Postby Tony Grant » Mon Apr 15, 2013 2:16 pm

Hi, thanks for that suggestion. Is this a manual trigger that I will need to enter into the market sheet or could I maybe automed it? If it needs to be typed in and then replaced by the standard 1 afterwards, I am guessing I would need to do this by macro?

any thoughts please.

Tony
Tony Grant
 
Posts: 6
Joined: Mon Jan 14, 2013 4:43 am
Location: Lincoln, UK

Postby osknows » Mon Apr 15, 2013 2:34 pm

You could manually type -6 into cell Q2 or you could automate with something like this in each market sheet object

Code: Select all
Dim lastResultsUpdate As Date

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngArray() As Variant

If Target.Columns.Count = 16 Then
    Application.EnableEvents = False
   
        rngArray = .Range("A1:CX61").Value2
       
        'Refresh Results Every 5 minutes
        If DateDiff("n", lastResultsUpdate, rngArray(2, 2)) > 5 Then
            lastResultsUpdate = rngArray(2, 2)
            UpdateResults (Target.Parent)
        End If
       
    Application.EnableEvents = True
End If

End Sub


and this in a MODULE

Code: Select all
Public Sub UpdateResults(ByVal ws As Worksheet)

    If ws.Range("Q2").Value >= 0 Then ws.Range("Q2").Value = -6

End Sub
User avatar
osknows
 
Posts: 946
Joined: Wed Jul 29, 2009 12:01 am


Return to Find an Excel developer

Who is online

Users browsing this forum: No registered users and 6 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.