Q2 trigger issues

[Fixador]

Hello Gary,

Only just started using this very very useful device - but having a couple of issues - or just plain lack of understanding on my part ! which potentailly point to my pc !

(1) from post http://gruss-software.co.uk/forum/viewtopic.php?t=3159

-1 trigger in Excel will trigger the first race even when no races have been selected yet.

I am finding - I MUST select the first race - else my code below does nothing ( When i tried NOT select the first race :pc un-attended for an hour prior )

and, If i leave my pc for a few hours - the code below does not activate - Yet , today, i returned to pc - at 1400 , waved the mouse and the code started . On prior days - i have been working on pc at 1230 and the code below started ok

Code: Select all

Application.OnTime earliesttime:=TimeValue("12:31:00"), procedure:="my_start", latesttime:=TimeValue("13:00:00"), schedule:=True


Checking my pc power settings( desktop : properties :power) - they are :-
Power Schemes : Always On
Turn off monitor : After 20 mins
Turn off hard disks : Never
System Standby : Never
System hibernates : Never

Any ideas gratefully recieved !

thank you

[Fixador]

I really should not have put that code in a WorkSheet_Change procedure !

durrrrrrhhhh

[Fixador]

New page:-
(1) No quickpick list selected
(2) Data input to Excel is at A10 - so, Q2 triggers are in Q11 cells(11,17)
(3) Log current proces selected
(4) Triggered betting selected

from within a cmd procedure:-

Code: Select all

Application.OnTime TimeValue("15:05:00"), "my_start"
Application.OnTime TimeValue("15:09:00"), "my_FirstRace"


where:-

Code: Select all

Sub my_start()
ThisWorkbook.Worksheets(1).Cells(11, 17) = -3.1 'load UK win quick pick list
ThisWorkbook.Worksheets(1).Cells(3, 22) = ""
End Sub


and

Code: Select all

Sub my_FirstRace()
    ThisWorkbook.Worksheets(1).Cells(11, 17) = -5  'load first race in quick pick list
    ThisWorkbook.Worksheets(1).Cells(3, 22) = 1
End Sub

Result:-
At 1505 : Q11 = - 3.1 - nothing else happened
At 1509 : Q11 = -5 - nothing else happened

Checking the rest of my procedure - if i made changes as follows:

Code: Select all

Application.OnTime TimeValue("15:15:00"), "my_start"

'remove "myFirstRace"
'Application.OnTime TimeValue("15:09:00"), "my_FirstRace"


where:-

Code: Select all

Sub my_start()
ThisWorkbook.Worksheets(1).Cells(11, 17) = ""
ThisWorkbook.Worksheets(1).Cells(3, 22) = 1
End Sub


Then load the quickpick list, and select the next race 1540 ? so race is begin displayed in Excel . My code runs through processing the race, then loads the next race by using Q11= -1 . So that end seems ok

It seems getting the Q2 ( my Q11 ) trigger from my worksheet to activate BA something is awry !

Have I missed something ?

[GaryRussell]

It looks like BA is awry. It's not processing the market selection/loading triggers until a market has already been selected. I am looking into it and will get back to you.

[Fixador]

Thank you. To confirm : this applies to BA version 1.1.0.59 - and furthermore , on selection of additional columns of data sent to Excel - selected SP ( whilst in trigger bet mode ) - not seen on Excel sheet. ( i see this had a fix in 1.1.0.61 )

Will upgrade to 1.1.0.62 now , will advise if any changes of above - cheers

[Fixador]

upgraded to 1.1.0.62 now - SP now showing - hurrah !

[GaryRussell]

I have uploaded pre-release version 1.1.0.63 which allows the market selection triggers to work before a market has been selected. Download using the link below.

http://www.gruss-software.co.uk/Betting ... _Beta1.msi

[Fixador]

1.1.0.63 does the business ! many thanks Gary

[Fixador]

Just as you guys go off on a well earned jolly for the afternoon : 1.1.0.63 Q2 triggers aren't working ( - 3.1 and -5 )

Also got report from vps for this version of BA 1.1.0.63 of a shutdown
[/img]

[Fixador]

Also in 1.1.0.63 quickpick list autoselect - has ceased to function

reverting to 1.1.0.62 for the afternoon !

[GaryRussell]

Can you provide more information please.

In what way has auto select ceased to function? Did it appear to attempt to load the market, ie. "Market loading" or did nothing happen at all?

What happens when you tried the -3.1 and -5 triggers? Did it clear the Q2 cell or appear to ignore it?

[GaryRussell]

Are any error messages available regarding the shutdown?

[Fixador]

(1) Quick pick list auto select from timer setting of tab ( ie, non Excel method ): No race selection when: No "Market loading" seen (a) first race not preloaded, (b) with first race preloaded: No "Market loading" seen

Selection via Excel Q2 triggers:-

Both -3.1 and - 5 :-

(2) No "Market loading" label. No response to Q2 trigger -1 is also suspected

(3) General protection pop up box event on vps - but this dont not occur on pc

Gary - It all worked fine the first day on the pc - it was the 2nd day - it all failed to respond. I closed down BA & Excel, Re-opened Excel , set the triggers to a few minutes ahead, saved, closed, reopened, restarted BA - still Q2 triggers not responding

It was first useage of v1.1.0.63 on the vps. There had been no reboot between install and open BA.

pic of vps general protection pop up box to follow.

Will reinstall v1.1.0.63 and run with Q2 triggers set v early on one instance on pc once - to discount idiot on keyboard effect !

[Fixador]

[/img]

[Fixador]

v 1.1.0.63 : Q2 = -1 working ( using known good xls ! )

next try -3.1 and - 5