Quickpick refresh

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

Moderator: 2020vision

Quickpick refresh

Postby philuk » Sun Mar 14, 2010 3:08 pm

Hi there

Just a short question...

I use the quickpick refresh sheet , but it refreshes only at midnight every day.

Is it possible to make it refresh in the mornings?

Reason for this is that the virtual racing ends at 07:57 in the morning and then starts again at 09:03 am.

I tried changing the code to 08:00 instead of 00:00:00 , but did not work.

Just wanted to know if I am doing soething wrong.

Thanx
Philip
philuk
 
Posts: 37
Joined: Tue Mar 02, 2010 12:55 am

Postby mak » Sun Mar 14, 2010 5:35 pm

are you changing both module & worksheet timers?I have the same copy & it is working fine in the morning..
mak
 
Posts: 1086
Joined: Tue Jun 30, 2009 8:17 am

Postby philuk » Sun Mar 14, 2010 9:19 pm

Hi there

When i view the code for sheet1 then i only change the following :

Private Sub Workbook_Open()
Application.OnTime TimeValue("08:00:00"), "loadQuickPickList"
End Sub


Is there anything i need to change in this one :

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Columns.Count = 16 Then
Application.EnableEvents = False
If triggerQuickPickListReload Then
triggerQuickPickListReload = False
Range("Q2").Value = -3
triggerFirstMarketSelect = True
Else
If triggerFirstMarketSelect Then
triggerFirstMarketSelect = False
Range("Q2").Value = -5
End If
End If
Application.EnableEvents = True
End If
End Sub


Thanx
philuk
 
Posts: 37
Joined: Tue Mar 02, 2010 12:55 am

Postby philuk » Sun Mar 14, 2010 9:21 pm

Ok , thanx for that.

Just found that I did not change the module.

That was still on 00:00:00

Thanx again for that

Philip
philuk
 
Posts: 37
Joined: Tue Mar 02, 2010 12:55 am

Postby philuk » Wed Mar 17, 2010 8:36 am

Hi there

Is there a way to let the quickpick list refresh at midnight and at 8:00 in the morning.

got it to refresh at 8:00 in morning , but just noticed I need it to do it at midnight also.

Thanx again

:)
philuk
 
Posts: 37
Joined: Tue Mar 02, 2010 12:55 am

Postby GaryRussell » Wed Mar 17, 2010 8:48 am

Change the code in module1 to the following.

Code: Select all
Public Sub loadQuickPickList()
    triggerQuickPickListReload = True
    If Hour(Now) = 0 Then
        Application.OnTime TimeValue("08:00:00"), "loadQuickPickList"
    Else
        Application.OnTime TimeValue("00:00:00"), "loadQuickPickList"
    End If
End Sub
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Postby philuk » Wed Mar 17, 2010 6:26 pm

Thanx for that

I copied and replaced it all over to module one :D

Just want to know about the general code :

Private Sub Workbook_Open()
Application.OnTime TimeValue("08:00:00"), "loadQuickPickList"
End Sub


Must I leave it like that.

Thanx
philuk
 
Posts: 37
Joined: Tue Mar 02, 2010 12:55 am

Postby GaryRussell » Thu Mar 18, 2010 8:18 am

The Workbook_Open code only runs once when you first open the workbook. If you open it after 8am then it will miss the midnight refresh. If you open it before then it doesn't need changing.

For completeness you can change it as follows.
Code: Select all
Private Sub Workbook_Open()
   If hour(now)>=8 then
      Application.OnTime TimeValue("00:00:00"), "loadQuickPickList"
   else
      Application.OnTime TimeValue("08:00:00"), "loadQuickPickList"
   End If
End Sub
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

quickpick list

Postby xraymitch » Thu Mar 18, 2010 4:00 pm

I have preferences set to only load today's market yet when I fired up BA after 8am this morning (no sheets loaded) the Quickpick list was populated with the virtual racing for the 18th and the 19th, rather than just the 18th which I was expecting.

Cheers

PS Thanks for the code really helpful :)
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Postby GaryRussell » Thu Mar 18, 2010 4:10 pm

That will be because Betfair are not putting the correct dates in. They have been doing this for some time. They correct it later in the day, but earlier in the morning they always seem to get it wrong for some strange reason.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Postby Yorkie » Thu Mar 18, 2010 4:27 pm

I've mentioned this here http://gruss-software.co.uk/forum/viewtopic.php?t=4648

The correct date is in the quick pick list as soon as they appear, I assume this isn't what ba uses to order them. Could this info be used by BA to order them correctly from the start?

Yorkie
Yorkie
 
Posts: 116
Joined: Wed Feb 25, 2009 1:04 pm

Postby philuk » Thu Mar 18, 2010 5:59 pm

GaryRussell wrote:The Workbook_Open code only runs once when you first open the workbook. If you open it after 8am then it will miss the midnight refresh. If you open it before then it doesn't need changing.

For completeness you can change it as follows.
Code: Select all
Private Sub Workbook_Open()
   If hour(now)>=8 then
      Application.OnTime TimeValue("00:00:00"), "loadQuickPickList"
   else
      Application.OnTime TimeValue("08:00:00"), "loadQuickPickList"
   End If
End Sub



Thanx for this Gary :D

You have been an excellent help in this.

Appreciate it loads !!!

Philip :D
philuk
 
Posts: 37
Joined: Tue Mar 02, 2010 12:55 am

Postby xraymitch » Thu Mar 18, 2010 10:46 pm

GaryRussell wrote:That will be because Betfair are not putting the correct dates in. They have been doing this for some time. They correct it later in the day, but earlier in the morning they always seem to get it wrong for some strange reason.


Thanks for the feedback Gary, I must admit to becoming more and more disenchanted with the service that Betfair offers it's consumers.
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK

Postby GaryRussell » Fri Mar 19, 2010 8:16 am

xraymitch wrote:
GaryRussell wrote:That will be because Betfair are not putting the correct dates in. They have been doing this for some time. They correct it later in the day, but earlier in the morning they always seem to get it wrong for some strange reason.


Thanks for the feedback Gary, I must admit to becoming more and more disenchanted with the service that Betfair offers it's consumers.


I have uploaded official version 1.1.0.65e and Beta version 1.1.0.66d to fix this problem. It overrides the date with the date from the market name.
User avatar
GaryRussell
Site Admin
 
Posts: 9679
Joined: Fri Nov 18, 2005 8:09 pm
Location: Birmingham, UK

Postby xraymitch » Fri Mar 19, 2010 8:30 am

Gary you really are a STAR :D

Many thanks

PS Have you noticed the posts are 1 hour ahead ? ie it's 7:34 at the time of writing this postscript
xraymitch
 
Posts: 410
Joined: Wed Jun 25, 2008 7:06 am
Location: UK


Return to Find an Excel developer

Who is online

Users browsing this forum: No registered users and 7 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.

cron