Automatic start of race when previous one has ended

[mellenec]

Currently, the Auto Select Markets menu gives you 3 choices to start a race.
Because I want to record some data in running in every race till its end, none of these choices suits me.
So, when my program has detected that the race is no longer In Play ( E2 cell content), how can I continue with the next race?

[phrenetic]

Assuming you are using Excel to record the data, you need to put a -1 in cell Q2 when the end of the race is detected. This will move you to the next race in the quick pick list.

Alistair

[mellenec]

Assuming you are using Excel to record the data, you need to put a -1 in cell Q2 when the end of the race is detected. This will move you to the next race in the quick pick list.

Alistair

very simple indeed, thank you Alistair !

[mellenec]

Assuming you are using Excel to record the data, you need to put a -1 in cell Q2 when the end of the race is detected. This will move you to the next race in the quick pick list.

Alistair

It works, but what I get is the next race of the current COURSE!javascript:emoticon(':shock:')
Shocked
to day for example, after the 315 Yarm I got the 345 Yarm, instead of the 330 Ayr.
Is Gruss aware of this glitch ?

[GaryRussell]

That's not a problem I am aware of. It selects the next race in the quick pick list. I presume you are using VBA to populate the cell. Are you sure your VBA is correct and it isn't populating the cell multiple times in quickk succession?

[mellenec]

That's not a problem I am aware of. It selects the next race in the quick pick list. I presume you are using VBA to populate the cell.


Are you sure your VBA is correct and it isn't populating the cell multiple times in quickk succession?

I admit that it is a possibility and I will check that.
Thank you,
mellenec

[phrenetic]

I've had no problems - it always seems to pick the next one in the quick pick list.

Alistair

[dealbanker]

Hello Gary

I have seen this advice throughout the forum to use cell Q2 to move to the next race when the previous has finished running. However I have been using that cell to manage the data call rate (based on other advice in the forum).

If I use this cell to move to next race, is there a way to make sure the call rate remains the same for every race that BA moves to in the quick pick list?

cheers
Banker

[GaryRussell]

Hello Gary

I have seen this advice throughout the forum to use cell Q2 to move to the next race when the previous has finished running. However I have been using that cell to manage the data call rate (based on other advice in the forum).

If I use this cell to move to next race, is there a way to make sure the call rate remains the same for every race that BA moves to in the quick pick list?

cheers
Banker

If you are always using the same rate then select preferences from the options menu and change the default refresh rate in general preferences.

[dealbanker]

Thanks Gary

I found it...

Banker