Still suspended!

[the lion]

I originally posted this is the Bugs section, but I am not sure that it is actually a bug. I think it just be the way that the API works, so I have posted the same query here to see if anyone else has any ideas.

Sorry for my diabolical cross posting!


I like to set up an Excel sheet to resubmit my unmatched bets when a soccer market goes back into play after being suspended. I use the criteria AND(F2<>"Suspended",E2="In Play") in the trigger formula to check this, but I have found that the bet is being triggered too early and returns an error that states that the market is still suspended and the bet can't be placed. The bet refernce still gets entered in Excel though.

If this isn't a bug and happens to everyone else, does anyone else have a work around?

I don't recall it happening with the html versions...

Cheers!

[inplay]

Hello Lion

I hope, I have really understood your problem .
Your bets are sent too early when the game goes into play.
The same problem, I had have myself also.
Mitch has written a VBA program for me

The Link is here
http://gruss-software.co.uk/forum/viewtopic.php?t=781

I hope this helps you.

[Castillo]

I like to set up an Excel sheet to resubmit my unmatched bets when a soccer market goes back into play after being suspended.

Hi The Lion

I've posted a message about the calculation of the Overound in excel http://gruss-software.co.uk/forum/viewtopic.php?t=829
When a market goes IN PLAY you can specify when a bet is triggered according to the Overound, this will mean a bet is not submitted too quickly and only until the market settles down.

Hope it helps,

Cheers
Castillo

[Mitch]

Just so you don't think you're cracking up, it's happened to me as well.

I use vba in my sheets and like you, won't fire a bet if the sheet says the market is suspended. The last sheet I made I got the market suspended error quite a few times so I found a workaround but I wouldn't know how to do it with a formula.

Basically, my code says...
Ok - market not suspended - have I paused. No, so pause. Next refresh, market still not suspended - have I paused, yes, ok place the bets then.

Seems strange getting bet refs returned though. When it happened to me, PENDING stayed there until I cleared it myself.

[the lion]

Thanks for the replies guys!

Castillo: I have used the overound method in racing spreads, and did actually post the method for calculating the round on the book in an earlier thread here:

http://www.gruss-software.co.uk/forum/v ... .php?t=671

I actually wanted to get my bets back into the market as quickly as possible so that I can get to the front of the queue and hopefully get matched before another goal goes in, so the overound method wouldn't work here as it depends on other bets being made, whereas I wanted to get in first!

Thanks for your reply anyway!

MItch: Yeah I was thinking of going along the same lines but I was actually trying to stop using VBA in my sheets, as I thought it was slowing the sheet down. Probably not true.. just my paranoia!

I suppose I could declare a variable and give it a certain value when the market gets suspended, and then run the pause routine and set the function to change the variable back to the original value at the end of the pause routine.

How long do you reckon you need to pause for the market to really come back into play?

Of course I could use the html version, which doesn't have this problem... hmmm.

Cheers!

[GeorgeUK]

can't you just have a loop so that it will do the action while checking that inplay is true and suspended = false
if suspended = true then go back to beginning of procedure?

Or have i totally missed something ... again

[the lion]

Sorry George but I think you might have!


My problem is that the API.. or the API version of BA... reports that suspended = true when suspended actually still = false... so the bet doesn't get placed as the market is still suspended.

[Mitch]

I think that should be the other way round 'the lion' but I know what you mean.

As far as the time to run a macro goes, as long as there's not heaps of unnecessary code you shouldn't have an issue with the time it takes (depending on your refresh rate). When I started using vba I thought the same thing so I built a timer into my sheets to see how long it took to run. Start the timer after application.enableevents=false and stop and print it just before you set it to true at the end.

The most complicated macro I've written took half a second at most, and easier sheets it takes about a tenth. Since I use a 1 sec refresh rate I'm not in any danger of messing things up with it.

[the lion]

Yes I was the wrong way round..... But you know what I mean!

Thanks for your help Mitch.