QuickpickList loading from vba - not "reload"

[joe lively]

The next update will allow you to use "-3.1t", "-4t" etc. which will only load events from the following day onwards.

Thats great Gary, thanks.

Out of interest how do we know when you do an update?

[GaryRussell]

The user guide has a version history section. You can view it via the help menu or here http://www.gruss-software.co.uk/Betting ... p/help.htm

You should also notice the popup displaying "Updating" when you first open the program if we have released an update.

[GaryRussell]

Version 1.1.0.66g is now available with the -4t option.

[joe lively]

Thanks Gary, will try this today.

[joe lively]

Hi Gary, the new q2 special triggers are working really well, thanks.

I have another question I wonder if you can help with.

Currently I can use -3.1t to load any new markets for the following day, I can then cycle though the list using -1. Once at the end of the list I would like I would like to us -3.1t again to load any new markes (as you know betfair don't open all the next days markets at the same time) then start again.

Do you have any suggestions as to how I can detect the last event in the current list?

Thanks again.

[GaryRussell]

Hi Gary, the new q2 special triggers are working really well, thanks.

I have another question I wonder if you can help with.

Currently I can use -3.1t to load any new markets for the following day, I can then cycle though the list using -1. Once at the end of the list I would like I would like to us -3.1t again to load any new markes (as you know betfair don't open all the next days markets at the same time) then start again.

Do you have any suggestions as to how I can detect the last event in the current list?

Thanks again.

Cell J3 contains "F" when it is the first market in the last and "L" when it is the last market.

[joe lively]

Ah yes, I should have seen that

I knew I should have looked a bit harder before asking, I knew you guys would have already thought of it.

Thanks

[Fixador]

I'm not finding “Quick pick reload triggers select first market” to 100% reliable - this is carrying forward in the ver 1.1.0.66 series.

I maybe using it incorrectly - or its just a network issue - just guessing.

What I am doing currently is at say 0830 , logging into BA - and from vba cmd intialisation issuing an OnTime for say 1230 to generate Q2= -3.1, where “Quick pick reload triggers select first market” option has been selected.

But I am reverting for a few days to a better set of my prior subs ( as page 1 of this thread ) which :-

at say 0830 , logging into BA - and from vba cmd intialisation issuing an OnTime for say 1230 to generate Q2=-3.1 and then delay 30 secs Q2 = -5 .... then after a 60 sec delay test that cell A1 has been populated, and if not - repeat , ie call the sub again. This has been run on ver 1.1.0.63 a few times ok.

from the cmd :-

Code: Select all

mytime1 = CStr(sht.Cells(3, 2))
Application.OnTime TimeValue(mytime1), "my_startP2"


where:-

Code: Select all

Sub my_startP2()
Dim sht As Worksheet, mytime1 As Date
Set sht = ThisWorkbook.Worksheets(1)
    If IsEmpty(sht.Cells(10, 1)) = True Then
        sht.Cells(11, 17) = -3.1  'load todays quickpick list
        Application.OnTime Now + TimeValue("00:00:30"), "my_FirstRaceP2"
        'what if called this sub again from here ?
        Application.OnTime Now + TimeValue("00:01:00"), "my_startP2"
    End If
End Sub
Sub my_FirstRaceP2()
If IsEmpty(ThisWorkbook.Worksheets(1).Cells(10, 1)) = True Then
    ThisWorkbook.Worksheets(1).Cells(11, 17) = -5   ' select first race in quickpick listt
    ThisWorkbook.Worksheets(1).Cells(3, 22) = 1
End If
End Sub


This way I maintain my critical elegance of solution he he !

Gary - BA is amazing kit ..............this just might seen as nitpicking !

[GaryRussell]

I'll investigate.

[Fixador]

Gary

- muppet here : if i use “Quick pick reload triggers select first market” AND my code - then one way or another I'm going to get the first market loaded - elegantly !

As regards 'reliability' to date : ( for ver 1.1.0.66 series) bit of a guesstimate ...... 5 workbooks/day - 1 workbook missed every other day/ or every 3rd day .... so, i think that makes it 90%- 95% reliable

[GaryRussell]

Gary

- muppet here : if i use “Quick pick reload triggers select first market” AND my code - then one way or another I'm going to get the first market loaded - elegantly !

As regards 'reliability' to date : ( for ver 1.1.0.66 series) bit of a guesstimate ...... 5 workbooks/day - 1 workbook missed every other day/ or every 3rd day .... so, i think that makes it 90%- 95% reliable

It needs to be 100%. Are these 5 workbooks all linked to the same instance of Betting Assistant and is the reload triggered in each workbook at the same time?

[Fixador]

All are to same instance of BA
Only one instance of BA on pc
6 instances of Excel - but only 4 using reload trigger ( sorry cant count ):-

(1) default has been : 2 x 1230, 2 x 1255

reload trigger has 'missed' on one instance of the 2 x 1255, but usually it is one of the 2 x 1230 ( never both )

(2) modified 3 days ago to : 1 x 1225, 1 x 1230, 2 x 1255

reload trigger has 'missed' on the 1 x 1225 on one occassion

[GaryRussell]

All are to same instance of BA
Only one instance of BA on pc
6 instances of Excel - but only 4 using reload trigger ( sorry cant count ):-

(1) default has been : 2 x 1230, 2 x 1255

reload trigger has 'missed' on one instance of the 2 x 1255, but usually it is one of the 2 x 1230 ( never both )

(2) modified 3 days ago to : 1 x 1225, 1 x 1230, 2 x 1255

reload trigger has 'missed' on the 1 x 1225 on one occassion

I've not found anything yet. When it misses do you know if it misses both the refresh of quick pick list and selection of first market or just the selection of the first market?

[Fixador]

Hi Gary,

It misses refresh of quick pick list and selection of first market.

I have fitted my code snippet this morning .... to back up the BA option “Quick pick reload triggers select first market”

Since there is now a dedicated sub for monitoring Q2 triggers ( -3.1, -5 ) : its no problem to add on a counter/list for how many times ( if ever ! ) my code fires off these specific Q2 triggers, and which trigger value for each workbook, and at what time - ummm, I can double up and run a second instance of BA on 2nd pc.

Hopefully get some definitive numbers rather than relying on my memory !

[Fixador]

Hello Gary - 44 instances logged now - No 'issues' on any occassion

- Job Done i reckon ! well done !