Pending Over-ride

[Spike]

Is there any way fire more bets whilst earlier bets are still showing "PENDING" (in excel)?

I'd like to make a really psychotic rapid fire IR bot that doesn't care whether bets are already waiting, I tried just clearing "PENDING" from the bet ref cell as soon as it appears and firing another bet but that doesn't seem to work- the bets are still held up.

If this is not possible via excel is it possible via the COM?

[GaryRussell]

It waits for the bet result before allowing another Excel refresh so you won't be able to trigger another bet until after the 1 second delay. The COM function also waits for the result unfortunately. I could add a COM function to place a bet without waiting. Please leave it with me.

[Spike]

Great thanks Gary. It'll take me a little while to learn how to use the COM so there's no great rush.

[Spike]

Hi Gary,

I know your busy at the moment but is there any chance you could have a look at this some time? I'm making an effort to rationalise my setup a bit and having the ability to get refreshes and fire new bets in whilst others are pending would allow me to combine a whole bunch of bots onto one sheet.

Via the COM would be just the ticket. I imagine being able to put more triggers into the same row whilst others are still pending in adjacent cells (hope that makes sense)- either that or some other way. I'm not all that bothered about getting a bet ref so if that's a necessary sacrifice that's fine.

Thanks,

Michael

[greenfingers]

The version 66x beta allows you to open the same market in several tabs without incurring any more requests to betfair. You can then link each of the tabs to seperate sheets and trigger bets with differing criteria on the same horse(s) simultaneously.

[Spike]

I know that, but I'd still rather use one sheet 5 times a second than have to set up and run 5 instances of excel.

[GaryRussell]

Hi Gary,

I know your busy at the moment but is there any chance you could have a look at this some time? I'm making an effort to rationalise my setup a bit and having the ability to get refreshes and fire new bets in whilst others are pending would allow me to combine a whole bunch of bots onto one sheet.

Via the COM would be just the ticket. I imagine being able to put more triggers into the same row whilst others are still pending in adjacent cells (hope that makes sense)- either that or some other way. I'm not all that bothered about getting a bet ref so if that's a necessary sacrifice that's fine.

Thanks,

Michael

Since you're not bothered about getting the result I've made a quick amendment. The COM function placeBet has a new parameter: waitForResult. The parameter is optional, if it's not supplied then it waits for a result by default. To place a bet without waiting for a response use something like the following.

Code: Select all

placeBet(0, "B", 500, 2, False)

It's included in the latest Beta which is not officially released yet. See http://www.gruss-software.co.uk/forum/v ... php?t=4992

[Spike]

Fantastic!

Just the job, thanks Gary.

Michael

[Spike]

Sorry to keep bothering you Gary but just another thought (then I promise to leave you alone for a while)- would it be complicated to add a non-COM excel trigger modifier to do the same thing? I mean like "LAY-NR" or something like that. If it would be a bind then forget it, but if it would be easy to implement it I'd really appreciate that too.

New site looks great by the way.

[Spike]

Actually maybe "LAY-DW" would be better, I was thinking "No Result" but I've just realised that it looks like "Non Runner", DW would be "Don't Wait". Not that it matters, anything would do.

[GaryRussell]

I'm afraid it isn't that easy to implement. It's not impossible though so I will consider it as a suggestion for a future release.

[Spike]

No problem, I was just being lazy and wondering if I could avoid shifting some things onto COM sheets.

Thanks again,

Michael

[keesbart]

Hi Gary,

Do I understand correctly that during pending of a bet the system comes to a halt (stops data transfer from and to Betfair?) and that processing resumes after 1 second or untill the program receives a trigger from Betfair that the bet is accepted for matching?

If Excel is firing, let's say, 5 bets at the same time, how are this bets processed and in which order?

Sometimes I fire 2 or 3 bets (In Play) in the Place Market. I noticed that in most of these cases only the first bet fired, is matched.
Yesterday the response times of the bets were between 1234 and 1594.
Is this the "Pending" time?
The transaction log of yesterday showed that I fired in 1 race to bets:
- 15:22:02 (response time 1250)
- 15:22:09 (response time 1266)
Can you tell me how I have to interpret this numbers?

The new Forum program looks great.

[GaryRussell]

Do I understand correctly that during pending of a bet the system comes to a halt (stops data transfer from and to Betfair?) and that processing resumes after 1 second or untill the program receives a trigger from Betfair that the bet is accepted for matching?

This is not strictly true. It is only Excel updating that is halted. Price refreshes will still happen, but will not be updated in Excel.

If Excel is firing, let's say, 5 bets at the same time, how are this bets processed and in which order?

If they are triggered on the same refresh then they are all placed at exactly the same time in one request to Betfair.

Sometimes I fire 2 or 3 bets (In Play) in the Place Market. I noticed that in most of these cases only the first bet fired, is matched.
Yesterday the response times of the bets were between 1234 and 1594.
Is this the "Pending" time?

Yes, it's the pending time.

The transaction log of yesterday showed that I fired in 1 race to bets:
- 15:22:02 (response time 1250)
- 15:22:09 (response time 1266)
Can you tell me how I have to interpret this numbers?

They are the response times. ie. the bet request was sent to Betfair and a response was received 1250 milliseconds later. 1000 milliseconds of the response time is the 1 second delay that Betfair impose.

[keesbart]

Gary,

Thanks for your quick response.